{"id":"https://openalex.org/W2536218159","doi":"https://doi.org/10.1145/2983323.2983775","title":"PISA","display_name":"PISA","publication_year":2016,"publication_date":"2016-10-24","ids":{"openalex":"https://openalex.org/W2536218159","doi":"https://doi.org/10.1145/2983323.2983775","mag":"2536218159"},"language":"en","primary_location":{"id":"doi:10.1145/2983323.2983775","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2983323.2983775","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 25th ACM International on Conference on Information and Knowledge Management","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5084887843","display_name":"Xiangdong Huang","orcid":null},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Xiangdong Huang","raw_affiliation_strings":["Tsinghua University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100373517","display_name":"Jianmin Wang","orcid":"https://orcid.org/0000-0001-6841-7943"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jianmin Wang","raw_affiliation_strings":["Tsinghua University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5015158455","display_name":"Raymond K. Wong","orcid":"https://orcid.org/0000-0002-9814-6029"},"institutions":[{"id":"https://openalex.org/I31746571","display_name":"UNSW Sydney","ror":"https://ror.org/03r8z3t63","country_code":"AU","type":"education","lineage":["https://openalex.org/I31746571"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Raymond Wong","raw_affiliation_strings":["University of New South Wales, Sydney, Australia"],"affiliations":[{"raw_affiliation_string":"University of New South Wales, Sydney, Australia","institution_ids":["https://openalex.org/I31746571"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101961350","display_name":"Jinrui Zhang","orcid":"https://orcid.org/0000-0001-9035-3050"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jinrui Zhang","raw_affiliation_strings":["Tsinghua University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100337628","display_name":"Chen Wang","orcid":"https://orcid.org/0000-0002-9315-3780"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chen Wang","raw_affiliation_strings":["Tsinghua University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5084887843"],"corresponding_institution_ids":["https://openalex.org/I99065089"],"apc_list":null,"apc_paid":null,"fwci":1.0087,"has_fulltext":false,"cited_by_count":10,"citation_normalized_percentile":{"value":0.77605097,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"979","last_page":"988"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9977999925613403,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8886418342590332},{"id":"https://openalex.org/keywords/nosql","display_name":"NoSQL","score":0.8166468143463135},{"id":"https://openalex.org/keywords/latency","display_name":"Latency (audio)","score":0.6144362688064575},{"id":"https://openalex.org/keywords/byte","display_name":"Byte","score":0.50571608543396},{"id":"https://openalex.org/keywords/database-index","display_name":"Database index","score":0.49374398589134216},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.45125070214271545},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.44353970885276794},{"id":"https://openalex.org/keywords/data-structure","display_name":"Data structure","score":0.43822187185287476},{"id":"https://openalex.org/keywords/tree","display_name":"Tree (set theory)","score":0.4151500463485718},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.38908809423446655},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.34507274627685547},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.30475571751594543},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.27597498893737793},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.21350255608558655},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.17254990339279175}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8886418342590332},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.8166468143463135},{"id":"https://openalex.org/C82876162","wikidata":"https://www.wikidata.org/wiki/Q17096504","display_name":"Latency (audio)","level":2,"score":0.6144362688064575},{"id":"https://openalex.org/C43364308","wikidata":"https://www.wikidata.org/wiki/Q8799","display_name":"Byte","level":2,"score":0.50571608543396},{"id":"https://openalex.org/C59276292","wikidata":"https://www.wikidata.org/wiki/Q580427","display_name":"Database index","level":3,"score":0.49374398589134216},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.45125070214271545},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.44353970885276794},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.43822187185287476},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.4151500463485718},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.38908809423446655},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.34507274627685547},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.30475571751594543},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.27597498893737793},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.21350255608558655},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.17254990339279175},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2983323.2983775","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2983323.2983775","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 25th ACM International on Conference on Information and Knowledge Management","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":20,"referenced_works":["https://openalex.org/W148571498","https://openalex.org/W564800084","https://openalex.org/W1538270387","https://openalex.org/W1967601791","https://openalex.org/W2006595462","https://openalex.org/W2055387198","https://openalex.org/W2077584722","https://openalex.org/W2081102106","https://openalex.org/W2109892086","https://openalex.org/W2127558904","https://openalex.org/W2149503419","https://openalex.org/W2166597031","https://openalex.org/W2171497557","https://openalex.org/W2173213060","https://openalex.org/W2296117781","https://openalex.org/W2394680079","https://openalex.org/W3019609263","https://openalex.org/W4213372399","https://openalex.org/W4250071346","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W1505866794","https://openalex.org/W1989329634","https://openalex.org/W2527247821","https://openalex.org/W4237510188","https://openalex.org/W2048379072","https://openalex.org/W4301000806","https://openalex.org/W2059878404","https://openalex.org/W2097844351","https://openalex.org/W2185250746","https://openalex.org/W1562055306"],"abstract_inverted_index":{"Aggregation":[0],"operation":[1],"plays":[2],"an":[3,107],"important":[4],"role":[5],"in":[6,89],"time":[7,168],"series":[8],"database":[9],"management.":[10],"As":[11],"the":[12,49,53,84],"amount":[13],"of":[14,87,97,132,136,174,176],"data":[15,50,116,137,177],"increases,":[16],"current":[17],"solutions":[18],"such":[19,30,37],"as":[20,38],"summary":[21],"table":[22],"and":[23,72,102,125,148,154],"MapReduce-based":[24],"methods":[25,42],"struggle":[26],"to":[27,29,82,109],"respond":[28],"queries":[31,111,159],"with":[32],"low":[33,73],"latency.":[34],"Other":[35],"approaches":[36],"segment":[39,61,91],"tree":[40,62],"based":[41,63],"have":[43],"a":[44,59,80,128,163,167],"poor":[45],"insertion":[46,70],"performance":[47,71,85],"when":[48],"size":[51],"exceeds":[52],"available":[54],"memory.":[55],"This":[56],"paper":[57],"proposes":[58],"new":[60],"index":[64,120],"called":[65],"PISA,":[66],"which":[67],"has":[68],"fast":[69],"latency":[74],"for":[75,134,166],"aggregation":[76,158],"queries.":[77],"PISA":[78,139],"uses":[79],"forest":[81],"overcome":[83],"disadvantages":[86],"insertions":[88],"traditional":[90,146],"trees.":[92],"By":[93],"defining":[94],"two":[95],"kinds":[96],"tags,":[98],"namely":[99],"code":[100],"number":[101],"serial":[103],"number,":[104],"we":[105],"propose":[106],"algorithm":[108],"accelerate":[110],"by":[112],"avoiding":[113],"reading":[114],"unnecessary":[115],"on":[117,123,144,162],"disk.":[118],"The":[119],"is":[121],"stored":[122],"disk":[124],"only":[126],"takes":[127],"few":[129],"hundred":[130],"bytes":[131],"memory":[133],"billions":[135,175],"points.":[138,178],"can":[140],"be":[141],"easily":[142],"implemented":[143],"both":[145],"databases":[147],"NoSQL":[149],"systems,":[150],"examples":[151],"including":[152],"MySQL":[153],"Cassandra.":[155],"It":[156],"handles":[157],"within":[160],"milliseconds":[161],"commodity":[164],"server":[165],"range":[169],"that":[170],"may":[171],"contain":[172],"tens":[173]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2016-10-28T00:00:00"}