{"id":"https://openalex.org/W2123686039","doi":"https://doi.org/10.1145/1142473.1142548","title":"Integrating compression and execution in column-oriented database systems","display_name":"Integrating compression and execution in column-oriented database systems","publication_year":2006,"publication_date":"2006-06-27","ids":{"openalex":"https://openalex.org/W2123686039","doi":"https://doi.org/10.1145/1142473.1142548","mag":"2123686039"},"language":"en","primary_location":{"id":"doi:10.1145/1142473.1142548","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1142473.1142548","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2006 ACM SIGMOD international conference on Management of data","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/A5049333271","display_name":"Daniel J. Abadi","orcid":"https://orcid.org/0000-0003-3771-2995"},"institutions":[{"id":"https://openalex.org/I4210109586","display_name":"Moscow Institute of Thermal Technology","ror":"https://ror.org/021es5e59","country_code":"RU","type":"facility","lineage":["https://openalex.org/I4210109586"]}],"countries":["RU"],"is_corresponding":true,"raw_author_name":"Daniel Abadi","raw_affiliation_strings":["MIT"],"affiliations":[{"raw_affiliation_string":"MIT","institution_ids":["https://openalex.org/I4210109586"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037742794","display_name":"Samuel Madden","orcid":null},"institutions":[{"id":"https://openalex.org/I4210109586","display_name":"Moscow Institute of Thermal Technology","ror":"https://ror.org/021es5e59","country_code":"RU","type":"facility","lineage":["https://openalex.org/I4210109586"]}],"countries":["RU"],"is_corresponding":false,"raw_author_name":"Samuel Madden","raw_affiliation_strings":["MIT"],"affiliations":[{"raw_affiliation_string":"MIT","institution_ids":["https://openalex.org/I4210109586"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5084217393","display_name":"Miguel Ferreira","orcid":null},"institutions":[{"id":"https://openalex.org/I4210109586","display_name":"Moscow Institute of Thermal Technology","ror":"https://ror.org/021es5e59","country_code":"RU","type":"facility","lineage":["https://openalex.org/I4210109586"]}],"countries":["RU"],"is_corresponding":false,"raw_author_name":"Miguel Ferreira","raw_affiliation_strings":["MIT"],"affiliations":[{"raw_affiliation_string":"MIT","institution_ids":["https://openalex.org/I4210109586"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5049333271"],"corresponding_institution_ids":["https://openalex.org/I4210109586"],"apc_list":null,"apc_paid":null,"fwci":18.5853,"has_fulltext":false,"cited_by_count":600,"citation_normalized_percentile":{"value":0.99335961,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":99,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"671","last_page":"682"},"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.9995999932289124,"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.9995999932289124,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.9993000030517578,"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/computer-science","display_name":"Computer science","score":0.8136946558952332},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.8021281361579895},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.7497153282165527},{"id":"https://openalex.org/keywords/compression","display_name":"Compression (physics)","score":0.642051637172699},{"id":"https://openalex.org/keywords/data-compression","display_name":"Data compression","score":0.5881290435791016},{"id":"https://openalex.org/keywords/database-index","display_name":"Database index","score":0.5694096088409424},{"id":"https://openalex.org/keywords/compression-ratio","display_name":"Compression ratio","score":0.5207764506340027},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5190166234970093},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.516254186630249},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.4875583052635193},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.4343898296356201},{"id":"https://openalex.org/keywords/scheme","display_name":"Scheme (mathematics)","score":0.42317262291908264},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.24778813123703003},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.1826634705066681},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.16356971859931946},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.16128191351890564},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.12416070699691772},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.08292806148529053},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.07860121130943298}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8136946558952332},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.8021281361579895},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.7497153282165527},{"id":"https://openalex.org/C180016635","wikidata":"https://www.wikidata.org/wiki/Q2712821","display_name":"Compression (physics)","level":2,"score":0.642051637172699},{"id":"https://openalex.org/C78548338","wikidata":"https://www.wikidata.org/wiki/Q2493","display_name":"Data compression","level":2,"score":0.5881290435791016},{"id":"https://openalex.org/C59276292","wikidata":"https://www.wikidata.org/wiki/Q580427","display_name":"Database index","level":3,"score":0.5694096088409424},{"id":"https://openalex.org/C25797200","wikidata":"https://www.wikidata.org/wiki/Q828137","display_name":"Compression ratio","level":3,"score":0.5207764506340027},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5190166234970093},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.516254186630249},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.4875583052635193},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4343898296356201},{"id":"https://openalex.org/C77618280","wikidata":"https://www.wikidata.org/wiki/Q1155772","display_name":"Scheme (mathematics)","level":2,"score":0.42317262291908264},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.24778813123703003},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.1826634705066681},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.16356971859931946},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.16128191351890564},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.12416070699691772},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.08292806148529053},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.07860121130943298},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","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/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C171146098","wikidata":"https://www.wikidata.org/wiki/Q124192","display_name":"Automotive engineering","level":1,"score":0.0},{"id":"https://openalex.org/C511840579","wikidata":"https://www.wikidata.org/wiki/Q12757","display_name":"Internal combustion engine","level":2,"score":0.0},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/1142473.1142548","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1142473.1142548","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2006 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.296.6581","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.296.6581","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://db.csail.mit.edu/pubs/915.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.523.6450","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.523.6450","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.inf.fu-berlin.de/lehre/WS07/DBS-Seminar2/reader/cstore/p671-abadi.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":37,"referenced_works":["https://openalex.org/W11308288","https://openalex.org/W21419474","https://openalex.org/W126684907","https://openalex.org/W1546274087","https://openalex.org/W1547206386","https://openalex.org/W1561200998","https://openalex.org/W1561713787","https://openalex.org/W1570477871","https://openalex.org/W1574952374","https://openalex.org/W1576757369","https://openalex.org/W1600355623","https://openalex.org/W1806858515","https://openalex.org/W1993819379","https://openalex.org/W2056007277","https://openalex.org/W2060108852","https://openalex.org/W2063601856","https://openalex.org/W2068644217","https://openalex.org/W2101566835","https://openalex.org/W2105326258","https://openalex.org/W2107745473","https://openalex.org/W2108392934","https://openalex.org/W2111967617","https://openalex.org/W2122962290","https://openalex.org/W2124851765","https://openalex.org/W2130598739","https://openalex.org/W2130642985","https://openalex.org/W2132019011","https://openalex.org/W2140453381","https://openalex.org/W2152580645","https://openalex.org/W2156000104","https://openalex.org/W2167911783","https://openalex.org/W2341510490","https://openalex.org/W3138367763","https://openalex.org/W4365799926","https://openalex.org/W6633644953","https://openalex.org/W6678708722","https://openalex.org/W6679817081"],"related_works":["https://openalex.org/W4383723869","https://openalex.org/W4384298135","https://openalex.org/W4383722264","https://openalex.org/W2388481516","https://openalex.org/W2161302774","https://openalex.org/W1723410974","https://openalex.org/W3007688875","https://openalex.org/W2152893502","https://openalex.org/W3209669196","https://openalex.org/W2110517301"],"abstract_inverted_index":{"Column-oriented":[0],"database":[1],"system":[2],"architectures":[3],"invite":[4],"a":[5,19,71,94],"re-evaluation":[6],"of":[7,26,49,54,96,111,119],"how":[8,63,76],"and":[9,31,56,99],"when":[10],"data":[11,17,113],"in":[12,18,52,82],"databases":[13],"is":[14],"compressed.":[15],"Storing":[16],"column-oriented":[20,68,89],"fashion":[21],"greatly":[22],"increases":[23],"the":[24,46,102,109,112,117,120],"similarity":[25],"adjacent":[27,41],"records":[28],"on":[29,108,116],"disk":[30],"thus":[32],"opportunities":[33],"for":[34],"compression.":[35],"The":[36],"ability":[37],"to":[38,88],"compress":[39],"many":[40],"tuples":[42],"at":[43],"once":[44],"lowers":[45],"per-tuple":[47],"cost":[48],"compression,":[50],"both":[51],"terms":[53],"CPU":[55],"space":[57],"overheads.In":[58],"this":[59],"paper,":[60],"we":[61,64],"discuss":[62],"extended":[65],"C-Store":[66],"(a":[67],"DBMS)":[69],"with":[70],"compression":[72,77,97],"sub-system.":[73],"We":[74,91],"show":[75,100],"schemes":[78,98],"not":[79,106],"traditionally":[80],"used":[81],"row-oriented":[83],"DBMSs":[84],"can":[85],"be":[86],"applied":[87],"systems.":[90],"then":[92],"evaluate":[93],"set":[95],"that":[101],"best":[103],"scheme":[104],"depends":[105],"only":[107],"properties":[110],"but":[114],"also":[115],"nature":[118],"query":[121],"workload.":[122]},"counts_by_year":[{"year":2025,"cited_by_count":22},{"year":2024,"cited_by_count":23},{"year":2023,"cited_by_count":26},{"year":2022,"cited_by_count":25},{"year":2021,"cited_by_count":28},{"year":2020,"cited_by_count":28},{"year":2019,"cited_by_count":31},{"year":2018,"cited_by_count":40},{"year":2017,"cited_by_count":29},{"year":2016,"cited_by_count":38},{"year":2015,"cited_by_count":44},{"year":2014,"cited_by_count":35},{"year":2013,"cited_by_count":44},{"year":2012,"cited_by_count":48}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}