{"id":"https://openalex.org/W1989347482","doi":"https://doi.org/10.1145/2513190.2513197","title":"Optimizing OLAP cube processing on solid state drives","display_name":"Optimizing OLAP cube processing on solid state drives","publication_year":2013,"publication_date":"2013-10-28","ids":{"openalex":"https://openalex.org/W1989347482","doi":"https://doi.org/10.1145/2513190.2513197","mag":"1989347482"},"language":"en","primary_location":{"id":"doi:10.1145/2513190.2513197","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2513190.2513197","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the sixteenth international workshop on Data warehousing and OLAP","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/A5101943419","display_name":"Zhibo Chen","orcid":"https://orcid.org/0000-0002-2346-7530"},"institutions":[{"id":"https://openalex.org/I44461941","display_name":"University of Houston","ror":"https://ror.org/048sx0r50","country_code":"US","type":"education","lineage":["https://openalex.org/I44461941"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zhibo Chen","raw_affiliation_strings":["University of Houston, Houston, TX, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Houston, Houston, TX, USA","institution_ids":["https://openalex.org/I44461941"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5031610238","display_name":"Carlos Ordo\u0144\u1ebdz","orcid":"https://orcid.org/0009-0005-1135-9726"},"institutions":[{"id":"https://openalex.org/I44461941","display_name":"University of Houston","ror":"https://ror.org/048sx0r50","country_code":"US","type":"education","lineage":["https://openalex.org/I44461941"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Carlos Ordonez","raw_affiliation_strings":["University of Houston, Houston, TX, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Houston, Houston, TX, USA","institution_ids":["https://openalex.org/I44461941"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I44461941"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.10057093,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"79","last_page":"84"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998999834060669,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998999834060669,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9948999881744385,"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/T11478","display_name":"Caching and Content Delivery","score":0.9929999709129333,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.9754359126091003},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8328254222869873},{"id":"https://openalex.org/keywords/cube","display_name":"Cube (algebra)","score":0.6198400855064392},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5453022718429565},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.5047398805618286},{"id":"https://openalex.org/keywords/data-cube","display_name":"Data cube","score":0.4989047050476074},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4917776882648468},{"id":"https://openalex.org/keywords/point","display_name":"Point (geometry)","score":0.47900575399398804},{"id":"https://openalex.org/keywords/solid-state","display_name":"Solid-state","score":0.4590834677219391},{"id":"https://openalex.org/keywords/state","display_name":"State (computer science)","score":0.45622310042381287},{"id":"https://openalex.org/keywords/performance-improvement","display_name":"Performance improvement","score":0.41125959157943726},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.3315461277961731},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.16930943727493286},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.1333954632282257}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.9754359126091003},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8328254222869873},{"id":"https://openalex.org/C53051483","wikidata":"https://www.wikidata.org/wiki/Q861555","display_name":"Cube (algebra)","level":2,"score":0.6198400855064392},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5453022718429565},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.5047398805618286},{"id":"https://openalex.org/C78168278","wikidata":"https://www.wikidata.org/wiki/Q5227269","display_name":"Data cube","level":2,"score":0.4989047050476074},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4917776882648468},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.47900575399398804},{"id":"https://openalex.org/C107814960","wikidata":"https://www.wikidata.org/wiki/Q611957","display_name":"Solid-state","level":2,"score":0.4590834677219391},{"id":"https://openalex.org/C48103436","wikidata":"https://www.wikidata.org/wiki/Q599031","display_name":"State (computer science)","level":2,"score":0.45622310042381287},{"id":"https://openalex.org/C2778915421","wikidata":"https://www.wikidata.org/wiki/Q3643177","display_name":"Performance improvement","level":2,"score":0.41125959157943726},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.3315461277961731},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.16930943727493286},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.1333954632282257},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","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/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C61696701","wikidata":"https://www.wikidata.org/wiki/Q770766","display_name":"Engineering physics","level":1,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2513190.2513197","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2513190.2513197","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the sixteenth international workshop on Data warehousing and OLAP","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/7","display_name":"Affordable and clean energy","score":0.4300000071525574}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":11,"referenced_works":["https://openalex.org/W1966901553","https://openalex.org/W1981029608","https://openalex.org/W1990946453","https://openalex.org/W1996964471","https://openalex.org/W2004806949","https://openalex.org/W2027437447","https://openalex.org/W2038607816","https://openalex.org/W2049859567","https://openalex.org/W2103201239","https://openalex.org/W2130183999","https://openalex.org/W2171148344"],"related_works":["https://openalex.org/W2078886005","https://openalex.org/W2091980729","https://openalex.org/W2366586806","https://openalex.org/W2198278743","https://openalex.org/W2359610078","https://openalex.org/W1578257433","https://openalex.org/W2386977141","https://openalex.org/W2360760838","https://openalex.org/W2727179277","https://openalex.org/W119671363"],"abstract_inverted_index":{"Hardware":[0],"technology":[1],"has":[2],"improved":[3],"to":[4,26,42,88],"a":[5,8,17,79],"point":[6],"where":[7],"solid":[9],"state":[10],"drive":[11,21],"(SSD)":[12],"can":[13],"read":[14,124],"faster":[15],"than":[16,120,127],"traditional":[18],"hard":[19],"disk":[20],"(HDD).":[22],"This":[23],"unique":[24],"ability":[25],"retrieve":[27],"data":[28],"quickly":[29],"combines":[30],"perfectly":[31],"with":[32,97],"OLAP":[33,46],"cube":[34,47],"processing.":[35],"In":[36],"this":[37,129],"paper,":[38],"we":[39,59],"study":[40],"how":[41],"improve":[43],"performance":[44,91,102],"of":[45,54,66,103],"processing":[48],"on":[49,92,106],"SSDs.":[50,93],"The":[51],"main":[52],"novelty":[53],"our":[55,104],"work":[56],"is":[57],"that":[58,112],"do":[60],"not":[61],"alter":[62],"the":[63,67,70,73,98],"internal":[64],"subsystems":[65],"DBMS.":[68],"Instead,":[69],"DBMS":[71],"treats":[72],"SSD":[74],"as":[75],"though":[76,114],"it":[77],"was":[78],"regular":[80],"HDD.":[81],"We":[82,110],"propose":[83],"optimizations":[84,105],"for":[85],"SQL":[86],"queries":[87],"enhance":[89],"their":[90,122],"An":[94],"experimental":[95],"evaluation":[96],"TPC-H":[99],"database":[100],"compares":[101],"SSDs":[107,115],"and":[108],"HDDs.":[109],"found":[111],"even":[113],"have":[116],"slower":[117],"write":[118],"speeds":[119],"HDDs,":[121],"excellent":[123],"speed":[125],"more":[126],"overcomes":[128],"limitation.":[130]},"counts_by_year":[{"year":2021,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2017,"cited_by_count":1}],"updated_date":"2026-06-26T08:34:08.712188","created_date":"2025-10-10T00:00:00"}