{"id":"https://openalex.org/W3192056702","doi":"https://doi.org/10.14778/3476249.3476292","title":"Crystal","display_name":"Crystal","publication_year":2021,"publication_date":"2021-07-01","ids":{"openalex":"https://openalex.org/W3192056702","doi":"https://doi.org/10.14778/3476249.3476292","mag":"3192056702"},"language":"en","primary_location":{"id":"doi:10.14778/3476249.3476292","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3476249.3476292","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,"listed_in":["cwts-core","norway-2"],"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/A5060469796","display_name":"Dominik Durner","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Dominik Durner","raw_affiliation_strings":["Technische Universit\u00e4t M\u00fcnchen"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Technische Universit\u00e4t M\u00fcnchen","institution_ids":["https://openalex.org/I62916508"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5067654293","display_name":"Badrish Chandramouli","orcid":"https://orcid.org/0000-0002-8468-4037","observed_orcids":["https://orcid.org/0000-0002-8468-4037"]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Badrish Chandramouli","raw_affiliation_strings":["Microsoft Research"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Research","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100599397","display_name":"Yinan Li","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yinan Li","raw_affiliation_strings":["Microsoft Research"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Research","institution_ids":["https://openalex.org/I1290206253"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.0869,"has_fulltext":false,"cited_by_count":29,"citation_normalized_percentile":{"value":0.8658776,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":99},"biblio":{"volume":"14","issue":"11","first_page":"2432","last_page":"2444"},"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.7724999785423279,"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.7724999785423279,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.16110000014305115,"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"}},{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.04390000179409981,"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/query-optimization","display_name":"query optimization","score":0.5669999718666077},{"id":"https://openalex.org/keywords/query-time","display_name":"query response time","score":0.6069999933242798},{"id":"https://openalex.org/keywords/bandwidth-compression","display_name":"bandwidth reduction","score":0.6430000066757202},{"id":"https://openalex.org/keywords/spark","display_name":"Spark","score":0.5820000171661377},{"id":"https://openalex.org/keywords/columnar-storage","display_name":"columnar storage","score":0.7020000219345093}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.813990592956543},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.6637332439422607},{"id":"https://openalex.org/C2776257435","wikidata":"https://www.wikidata.org/wiki/Q1576430","display_name":"Bandwidth (computing)","level":2,"score":0.5280314683914185},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.519279956817627},{"id":"https://openalex.org/C2777059624","wikidata":"https://www.wikidata.org/wiki/Q914359","display_name":"Cloud storage","level":3,"score":0.45767754316329956},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.45701271295547485},{"id":"https://openalex.org/C2777210771","wikidata":"https://www.wikidata.org/wiki/Q4927124","display_name":"Block (permutation group theory)","level":2,"score":0.44143080711364746},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.4296322166919708},{"id":"https://openalex.org/C194739806","wikidata":"https://www.wikidata.org/wiki/Q66221","display_name":"Computer data storage","level":2,"score":0.4222247302532196},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.41476666927337646},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.4115898013114929},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.295518159866333},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","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}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3476249.3476292","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3476249.3476292","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,"listed_in":["cwts-core","norway-2"],"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":[],"sustainable_development_goals_aurora":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":35,"referenced_works":["https://openalex.org/W38346608","https://openalex.org/W53283472","https://openalex.org/W1485782945","https://openalex.org/W1527733826","https://openalex.org/W1549717312","https://openalex.org/W1563590781","https://openalex.org/W1585029481","https://openalex.org/W1835416193","https://openalex.org/W1946262574","https://openalex.org/W1960895309","https://openalex.org/W1981988185","https://openalex.org/W1983428358","https://openalex.org/W1989893188","https://openalex.org/W1992977903","https://openalex.org/W2026891055","https://openalex.org/W2033078763","https://openalex.org/W2038157364","https://openalex.org/W2054170837","https://openalex.org/W2164049396","https://openalex.org/W2171492933","https://openalex.org/W2430301697","https://openalex.org/W2507304688","https://openalex.org/W2799060872","https://openalex.org/W2799237774","https://openalex.org/W2892073027","https://openalex.org/W2970621975","https://openalex.org/W2992496917","https://openalex.org/W3001621465","https://openalex.org/W3002980296","https://openalex.org/W3085477028","https://openalex.org/W3107842002","https://openalex.org/W3138367763","https://openalex.org/W3167346145","https://openalex.org/W4242825475","https://openalex.org/W4255826646"],"related_works":["https://openalex.org/W2348283597","https://openalex.org/W3022042262","https://openalex.org/W2369572752","https://openalex.org/W4231450971","https://openalex.org/W1999590660","https://openalex.org/W2921774642","https://openalex.org/W3162884427","https://openalex.org/W2946119021","https://openalex.org/W2369516071","https://openalex.org/W4287184259"],"abstract_inverted_index":{"Cloud":[0],"analytical":[1],"databases":[2],"employ":[3],"a":[4,54,80,84,110,135],"disaggregated":[5],"storage":[6,19,33,87],"model,":[7],"where":[8],"the":[9,25,35,45],"elastic":[10],"compute":[11,46],"layer":[12],"accesses":[13],"data":[14,43,138],"persisted":[15],"on":[16,71,120,146,154],"remote":[17,32,157],"cloud":[18],"in":[20,53,57,107],"block-oriented":[21],"columnar":[22],"formats.":[23],"Given":[24],"high":[26],"latency":[27],"and":[28,34,50,116,123,149],"low":[29],"bandwidth":[30,155],"to":[31,109],"limited":[36],"size":[37],"of":[38,83,125],"fast":[39],"local":[40],"storage,":[41],"caching":[42,58,67,122],"at":[44],"node":[47],"is":[48,93],"important":[49],"has":[51],"resulted":[52],"renewed":[55],"interest":[56],"for":[59],"analytics.":[60],"Today,":[61],"each":[62],"DBMS":[63],"builds":[64],"its":[65],"own":[66],"solution,":[68],"usually":[69],"based":[70],"file-or":[72],"block-level":[73],"LRU.":[74],"In":[75],"this":[76],"paper,":[77],"we":[78],"advocate":[79],"new":[81],"architecture":[82],"smart":[85],"cache":[86],"system":[88],"called":[89,128],"Crystal":[90,112],",":[91],"that":[92,132],"co-located":[94],"with":[95,103,134],"compute.":[96],"Crystal's":[97],"clients":[98],"are":[99],"DBMS-specific":[100,137],"\"data":[101],"sources\"":[102],"push-down":[104],"predicates.":[105],"Similar":[106],"spirit":[108],"DBMS,":[111],"incorporates":[113],"query":[114,144],"processing":[115],"optimization":[117],"components":[118],"focusing":[119],"efficient":[121],"serving":[124],"single-table":[126],"hyper-rectangles":[127],"regions.":[129],"Results":[130],"show":[131],"Crystal,":[133],"small":[136],"source":[139],"connector,":[140],"can":[141],"significantly":[142],"improve":[143],"latencies":[145],"unmodified":[147],"Spark":[148],"Greenplum":[150],"while":[151],"also":[152],"saving":[153],"from":[156],"storage.":[158]},"counts_by_year":[{"year":2026,"cited_by_count":6},{"year":2025,"cited_by_count":5},{"year":2024,"cited_by_count":6},{"year":2023,"cited_by_count":7},{"year":2022,"cited_by_count":4},{"year":2021,"cited_by_count":1}],"updated_date":"2026-10-01T08:54:57.152042","created_date":"2021-08-16T00:00:00"}