{"id":"https://openalex.org/W2121605000","doi":"https://doi.org/10.1109/icde.2004.1320007","title":"Making the pyramid technique robust to query types and workloads","display_name":"Making the pyramid technique robust to query types and workloads","publication_year":2004,"publication_date":"2004-09-28","ids":{"openalex":"https://openalex.org/W2121605000","doi":"https://doi.org/10.1109/icde.2004.1320007","mag":"2121605000"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2004.1320007","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2004.1320007","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings. 20th International Conference on Data Engineering","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/A5100422102","display_name":"Rui Zhang","orcid":"https://orcid.org/0000-0002-8729-8393"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":true,"raw_author_name":"R. Zhang","raw_affiliation_strings":["Department of Computer Science, National University of Singapore, Singapore","Department of Computer Science, National University of Singapore, Singapore,"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, National University of Singapore, Singapore","institution_ids":["https://openalex.org/I165932596"]},{"raw_affiliation_string":"Department of Computer Science, National University of Singapore, Singapore,","institution_ids":["https://openalex.org/I165932596"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5024892041","display_name":"Beng Chin Ooi","orcid":"https://orcid.org/0000-0003-4446-1100"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"B.C. Ooi","raw_affiliation_strings":["Department of Computer Science, National University of Singapore, Singapore","Department of Computer Science, National University of Singapore, Singapore,"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, National University of Singapore, Singapore","institution_ids":["https://openalex.org/I165932596"]},{"raw_affiliation_string":"Department of Computer Science, National University of Singapore, Singapore,","institution_ids":["https://openalex.org/I165932596"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5077593594","display_name":"Kian\u2010Lee Tan","orcid":"https://orcid.org/0000-0001-9315-4057"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"K.-L. Tan","raw_affiliation_strings":["Department of Computer Science, National University of Singapore, Singapore","Department of Computer Science, National University of Singapore, Singapore,"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, National University of Singapore, Singapore","institution_ids":["https://openalex.org/I165932596"]},{"raw_affiliation_string":"Department of Computer Science, National University of Singapore, Singapore,","institution_ids":["https://openalex.org/I165932596"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5100422102"],"corresponding_institution_ids":["https://openalex.org/I165932596"],"apc_list":null,"apc_paid":null,"fwci":2.2861,"has_fulltext":false,"cited_by_count":68,"citation_normalized_percentile":{"value":0.88626385,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"313","last_page":"324"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":1.0,"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":1.0,"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.9944999814033508,"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.9930999875068665,"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.780428409576416},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.7402002215385437},{"id":"https://openalex.org/keywords/pyramid","display_name":"Pyramid (geometry)","score":0.6987160444259644},{"id":"https://openalex.org/keywords/b-tree","display_name":"B-tree","score":0.6789232492446899},{"id":"https://openalex.org/keywords/linear-subspace","display_name":"Linear subspace","score":0.5819066762924194},{"id":"https://openalex.org/keywords/cluster-analysis","display_name":"Cluster analysis","score":0.5538604259490967},{"id":"https://openalex.org/keywords/tree","display_name":"Tree (set theory)","score":0.5477742552757263},{"id":"https://openalex.org/keywords/hypercube","display_name":"Hypercube","score":0.48506417870521545},{"id":"https://openalex.org/keywords/data-structure","display_name":"Data structure","score":0.46659043431282043},{"id":"https://openalex.org/keywords/window","display_name":"Window (computing)","score":0.4632251262664795},{"id":"https://openalex.org/keywords/subspace-topology","display_name":"Subspace topology","score":0.4320310950279236},{"id":"https://openalex.org/keywords/speedup","display_name":"Speedup","score":0.4237609803676605},{"id":"https://openalex.org/keywords/curse-of-dimensionality","display_name":"Curse of dimensionality","score":0.41740643978118896},{"id":"https://openalex.org/keywords/tree-structure","display_name":"Tree structure","score":0.4131554961204529},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3775104284286499},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.3356861472129822},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.2414710521697998},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.21462678909301758},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.1808679699897766},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.1499563455581665}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.780428409576416},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.7402002215385437},{"id":"https://openalex.org/C142575187","wikidata":"https://www.wikidata.org/wiki/Q3358290","display_name":"Pyramid (geometry)","level":2,"score":0.6987160444259644},{"id":"https://openalex.org/C78669399","wikidata":"https://www.wikidata.org/wiki/Q677051","display_name":"B-tree","level":3,"score":0.6789232492446899},{"id":"https://openalex.org/C12362212","wikidata":"https://www.wikidata.org/wiki/Q728435","display_name":"Linear subspace","level":2,"score":0.5819066762924194},{"id":"https://openalex.org/C73555534","wikidata":"https://www.wikidata.org/wiki/Q622825","display_name":"Cluster analysis","level":2,"score":0.5538604259490967},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.5477742552757263},{"id":"https://openalex.org/C50820777","wikidata":"https://www.wikidata.org/wiki/Q213723","display_name":"Hypercube","level":2,"score":0.48506417870521545},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.46659043431282043},{"id":"https://openalex.org/C2778751112","wikidata":"https://www.wikidata.org/wiki/Q835016","display_name":"Window (computing)","level":2,"score":0.4632251262664795},{"id":"https://openalex.org/C32834561","wikidata":"https://www.wikidata.org/wiki/Q660730","display_name":"Subspace topology","level":2,"score":0.4320310950279236},{"id":"https://openalex.org/C68339613","wikidata":"https://www.wikidata.org/wiki/Q1549489","display_name":"Speedup","level":2,"score":0.4237609803676605},{"id":"https://openalex.org/C111030470","wikidata":"https://www.wikidata.org/wiki/Q1430460","display_name":"Curse of dimensionality","level":2,"score":0.41740643978118896},{"id":"https://openalex.org/C163797641","wikidata":"https://www.wikidata.org/wiki/Q2067937","display_name":"Tree structure","level":3,"score":0.4131554961204529},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3775104284286499},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3356861472129822},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.2414710521697998},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.21462678909301758},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.1808679699897766},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.1499563455581665},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1109/icde.2004.1320007","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2004.1320007","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings. 20th International Conference on Data Engineering","raw_type":"proceedings-article"},{"id":"pmh:oai:scholarbank.nus.edu.sg:10635/41759","is_oa":false,"landing_page_url":"http://scholarbank.nus.edu.sg/handle/10635/41759","pdf_url":null,"source":{"id":"https://openalex.org/S7407052290","display_name":"National University of Singapore","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Scopus","raw_type":"Conference Paper"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.128.9613","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.128.9613","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.mu.oz.au/~rui/publication/Icde04_p+tree.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.64.1691","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.64.1691","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.comp.nus.edu.sg/~ooibc/p+.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W123030148","https://openalex.org/W1541459201","https://openalex.org/W1566022212","https://openalex.org/W1633157623","https://openalex.org/W1975830550","https://openalex.org/W2017411278","https://openalex.org/W2097042476","https://openalex.org/W2105022522","https://openalex.org/W2107110814","https://openalex.org/W2117281615","https://openalex.org/W2118269922","https://openalex.org/W2133542527","https://openalex.org/W2145725688","https://openalex.org/W2150661231","https://openalex.org/W2151135734","https://openalex.org/W2155776210","https://openalex.org/W2157092487","https://openalex.org/W2165558283","https://openalex.org/W2238624099","https://openalex.org/W4285719527","https://openalex.org/W6632397832","https://openalex.org/W6633912359","https://openalex.org/W6636710603","https://openalex.org/W6675816764","https://openalex.org/W6682969285","https://openalex.org/W7062905887"],"related_works":["https://openalex.org/W2372453241","https://openalex.org/W2371387875","https://openalex.org/W2531660186","https://openalex.org/W2064670891","https://openalex.org/W1508699539","https://openalex.org/W1987871343","https://openalex.org/W2005258962","https://openalex.org/W1481260592","https://openalex.org/W154592988","https://openalex.org/W2189261042"],"abstract_inverted_index":{"The":[0,75,108],"effectiveness":[1],"of":[2,13,110,117,150],"many":[3],"existing":[4],"high-dimensional":[5],"indexing":[6],"structures":[7],"is":[8,33,66,78,154],"limited":[9],"to":[10,68,147],"specific":[11],"types":[12],"queries":[14,51,54,199],"and":[15,23,52,85,101,167,194,200],"workloads.":[16],"For":[17],"example,":[18],"while":[19],"the":[20,24,31,44,60,70,98,104,111,115,118,135,144,148,151,155,158,173,184,191,195,202],"Pyramid":[21,99,136,159,192],"technique":[22,137,160,193],"iMinMax":[25,196],"are":[26,90],"efficient":[27],"for":[28,35,172,197,204],"window":[29,50,166,198],"queries,":[30],"iDistance":[32,203],"superior":[34],"kNN":[36,53,168,205],"queries.":[37,206],"We":[38,164],"present":[39,165],"a":[40,63,93,131],"new":[41],"structure,":[42],"called":[43],"P/sup":[45,61,174,185],"+/-tree,":[46,62],"that":[47,134,157,183],"supports":[48],"both":[49],"under":[55],"different":[56],"workloads":[57],"efficiently.":[58,163],"In":[59],"B/sup":[64,105],"+/-tree":[65,186],"employed":[67],"index":[69],"data":[71,76,119],"points":[72,86],"as":[73],"follows.":[74],"space":[77,96],"partitioned":[79],"into":[80,130],"subspaces":[81],"based":[82],"on":[83],"clustering,":[84],"in":[87,103,114],"each":[88,128],"subspace":[89,129],"mapped":[91],"onto":[92],"single":[94],"dimensional":[95],"using":[97],"technique,":[100],"stored":[102],"+/":[106],"-tree.":[107],"crux":[109],"scheme":[112],"lies":[113],"transformation":[116],"which":[120,153],"has":[121,187],"two":[122],"crucial":[123],"properties.":[124],"First,":[125],"it":[126,142],"maps":[127],"hypercube":[132],"so":[133],"can":[138],"be":[139],"applied.":[140],"Second,":[141],"shifts":[143],"cluster":[145],"center":[146],"top":[149],"pyramid,":[152],"case":[156],"works":[161],"very":[162],"query":[169],"processing":[170],"algorithms":[171],"+/-tree.":[175],"Through":[176],"an":[177],"extensive":[178],"performance":[179],"study,":[180],"we":[181],"show":[182],"considerable":[188],"speedup":[189],"over":[190],"outperforms":[201]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":5},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":8},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":6}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}