{"id":"https://openalex.org/W2750787376","doi":"https://doi.org/10.14778/3137765.3137769","title":"Dimensions based data clustering and zone maps","display_name":"Dimensions based data clustering and zone maps","publication_year":2017,"publication_date":"2017-08-01","ids":{"openalex":"https://openalex.org/W2750787376","doi":"https://doi.org/10.14778/3137765.3137769","mag":"2750787376"},"language":"en","primary_location":{"id":"doi:10.14778/3137765.3137769","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3137765.3137769","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5082164597","display_name":"Mohamed Ziauddin","orcid":"https://orcid.org/0009-0003-3383-487X"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mohamed Ziauddin","raw_affiliation_strings":["Oracle Corporation"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5088270000","display_name":"Andrew Witkowski","orcid":"https://orcid.org/0009-0001-6118-8380"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Andrew Witkowski","raw_affiliation_strings":["Oracle Corporation"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5062938103","display_name":"Youjung Kim","orcid":"https://orcid.org/0000-0002-1617-3956"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"You Jung Kim","raw_affiliation_strings":["Oracle Corporation"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Dmitry Potapov","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Dmitry Potapov","raw_affiliation_strings":["Oracle Corporation"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5016266359","display_name":"Janaki Lahorani","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Janaki Lahorani","raw_affiliation_strings":["Oracle Corporation"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5029772809","display_name":"M. Haneesh Krishna","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Murali Krishna","raw_affiliation_strings":["Oracle Corporation"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I1342911587"],"apc_list":null,"apc_paid":null,"fwci":1.4725,"has_fulltext":false,"cited_by_count":18,"citation_normalized_percentile":{"value":0.84885661,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"10","issue":"12","first_page":"1622","last_page":"1633"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"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/T11106","display_name":"Data Management and Algorithms","score":0.9995999932289124,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9983999729156494,"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/cluster-analysis","display_name":"Cluster analysis","score":0.7359914779663086},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.67946457862854},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.6686544418334961},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.633512556552887},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.5743518471717834},{"id":"https://openalex.org/keywords/pruning","display_name":"Pruning","score":0.5167154669761658},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.5049927830696106},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.4579980671405792},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.42889177799224854},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3717712163925171},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3508426547050476},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.20089781284332275},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.18461614847183228}],"concepts":[{"id":"https://openalex.org/C73555534","wikidata":"https://www.wikidata.org/wiki/Q622825","display_name":"Cluster analysis","level":2,"score":0.7359914779663086},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.67946457862854},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6686544418334961},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.633512556552887},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.5743518471717834},{"id":"https://openalex.org/C108010975","wikidata":"https://www.wikidata.org/wiki/Q500094","display_name":"Pruning","level":2,"score":0.5167154669761658},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.5049927830696106},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.4579980671405792},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.42889177799224854},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3717712163925171},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3508426547050476},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.20089781284332275},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.18461614847183228},{"id":"https://openalex.org/C6557445","wikidata":"https://www.wikidata.org/wiki/Q173113","display_name":"Agronomy","level":1,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3137765.3137769","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3137765.3137769","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.6299999952316284,"display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W1494049834","https://openalex.org/W1495859460","https://openalex.org/W1530458829","https://openalex.org/W1574862731","https://openalex.org/W1982525351","https://openalex.org/W2005112390","https://openalex.org/W2066679214","https://openalex.org/W2069325139","https://openalex.org/W2123845384","https://openalex.org/W2144839430","https://openalex.org/W2153485419","https://openalex.org/W2255491979","https://openalex.org/W2340222647","https://openalex.org/W3138367763"],"related_works":["https://openalex.org/W3024364549","https://openalex.org/W4206019083","https://openalex.org/W2054476758","https://openalex.org/W1976265003","https://openalex.org/W2370378377","https://openalex.org/W2048865712","https://openalex.org/W4210535024","https://openalex.org/W4237510188","https://openalex.org/W2130160813","https://openalex.org/W1895366714"],"abstract_inverted_index":{"In":[0,230],"recent":[1],"years,":[2],"the":[3,30,41,78,111,117,150,179,189,200,238,250,264],"data":[4,21,24,27,38,49,63,81,93,113,128,164,192,203,241,261],"warehouse":[5,193,242],"industry":[6,122],"has":[7,123,147,248],"witnessed":[8],"decreased":[9],"use":[10,15,79],"of":[11,16,20,37,80,92,143,152,178,191,208,220,226,232,235,240,256,263],"indexing":[12],"but":[13],"increased":[14],"compression":[17],"and":[18,26,135],"clustering":[19,141,222,255],"facilitating":[22],"efficient":[23],"access":[25],"pruning":[28,39,82,103,262],"in":[29,129,163],"query":[31],"processing":[32],"area.":[33],"A":[34,74,87],"classic":[35],"example":[36,76],"is":[40,45,50,77,100,107,114,204],"partition":[42,71],"pruning,":[43],"which":[44,98],"used":[46],"when":[47,110],"table":[48,70,96,112,202,228],"range":[51],"or":[52,72],"list":[53],"partitioned.":[54],"But":[55],"lately,":[56],"techniques":[57],"have":[58],"been":[59],"developed":[60],"to":[61,126,136,183],"prune":[62],"at":[64],"a":[65,69,95,184],"lower":[66],"granularity":[67],"than":[68],"sub-partition.":[73],"good":[75],"structure":[83],"called":[84],"zone":[85,88,105,138,213,270],"map.":[86],"map":[89,106],"prunes":[90],"zones":[91,225],"from":[94],"on":[97,140,158,169,176],"it":[99],"defined.":[101],"Data":[102],"via":[104,267],"very":[108],"effective":[109],"clustered":[115,205],"by":[116,131,206],"filtering":[118],"columns.":[119,160],"The":[120],"database":[121],"offered":[124],"support":[125,251],"cluster":[127],"tables":[130,181,210,258,266],"its":[132],"local":[133,159],"columns,":[134],"define":[137],"maps":[139,214],"columns":[142,177,207,223],"such":[144],"tables.":[145],"This":[146],"helped":[148],"improve":[149],"performance":[151,190,239],"queries":[153,162,194],"that":[154,215],"contain":[155],"filter":[156,173],"predicates":[157,174],"However,":[161],"warehouses":[165],"are":[166],"typically":[167],"based":[168,254,269],"star/snowflake":[170],"schema":[171],"with":[172,212,260],"usually":[175],"dimension":[180,209,253,268],"joined":[182],"fact":[185,201,227,257,265],"table.":[186],"Given":[187],"this,":[188],"can":[195],"be":[196],"significantly":[197,236],"improved":[198],"if":[199],"together":[211,259],"maintain":[216],"min/max":[217],"value":[218],"ranges":[219],"these":[221],"over":[224],"data.":[229],"recognition":[231],"this":[233],"opportunity":[234],"improving":[237],"queries,":[243],"Oracle":[244],"12c":[245],"release":[246],"1":[247],"introduced":[249],"for":[252],"maps.":[271]},"counts_by_year":[{"year":2025,"cited_by_count":5},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}