{"id":"https://openalex.org/W4380433151","doi":"https://doi.org/10.1145/3588703","title":"Grouping Time Series for Efficient Columnar Storage","display_name":"Grouping Time Series for Efficient Columnar Storage","publication_year":2023,"publication_date":"2023-05-26","ids":{"openalex":"https://openalex.org/W4380433151","doi":"https://doi.org/10.1145/3588703"},"language":"en","primary_location":{"id":"doi:10.1145/3588703","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3588703","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://doi.org/10.1145/3588703","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5050152830","display_name":"Chenguang Fang","orcid":"https://orcid.org/0000-0002-7261-7478"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chenguang Fang","raw_affiliation_strings":["Tsinghua University, China, Beijing, China"],"raw_orcid":"https://orcid.org/0000-0002-7261-7478","affiliations":[{"raw_affiliation_string":"Tsinghua University, China, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084430029","display_name":"Shaoxu Song","orcid":"https://orcid.org/0000-0002-9503-2755"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Shaoxu Song","raw_affiliation_strings":["Tsinghua University, China, Beijing, China"],"raw_orcid":"https://orcid.org/0000-0002-9503-2755","affiliations":[{"raw_affiliation_string":"Tsinghua University, China, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5079955858","display_name":"Haoquan Guan","orcid":"https://orcid.org/0009-0007-5412-4489"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Haoquan Guan","raw_affiliation_strings":["Tsinghua University, China, Beijing, China"],"raw_orcid":"https://orcid.org/0009-0007-5412-4489","affiliations":[{"raw_affiliation_string":"Tsinghua University, China, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084887843","display_name":"Xiangdong Huang","orcid":"https://orcid.org/0000-0002-6868-4045"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiangdong Huang","raw_affiliation_strings":["Tsinghua University, China, Beijing, China"],"raw_orcid":"https://orcid.org/0000-0002-6868-4045","affiliations":[{"raw_affiliation_string":"Tsinghua University, China, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100337653","display_name":"Chen Wang","orcid":"https://orcid.org/0000-0003-1698-8992"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chen Wang","raw_affiliation_strings":["Tsinghua University, China, Beijing, China"],"raw_orcid":"https://orcid.org/0000-0003-1698-8992","affiliations":[{"raw_affiliation_string":"Tsinghua University, China, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100373517","display_name":"Jianmin Wang","orcid":"https://orcid.org/0000-0001-6841-7943"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jianmin Wang","raw_affiliation_strings":["Tsinghua University, China, Beijing, China"],"raw_orcid":"https://orcid.org/0000-0001-6841-7943","affiliations":[{"raw_affiliation_string":"Tsinghua University, China, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I99065089"],"apc_list":null,"apc_paid":null,"fwci":1.8256,"has_fulltext":false,"cited_by_count":10,"citation_normalized_percentile":{"value":0.86024633,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"1","issue":"1","first_page":"1","last_page":"26"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12205","display_name":"Time Series Analysis and Forecasting","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"}},"topics":[{"id":"https://openalex.org/T12205","display_name":"Time Series Analysis and Forecasting","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/T11719","display_name":"Data Quality and Management","score":0.9990000128746033,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9965999722480774,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/timestamp","display_name":"Timestamp","score":0.8749138116836548},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.8309759497642517},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5931230783462524},{"id":"https://openalex.org/keywords/series","display_name":"Series (stratigraphy)","score":0.5885831713676453},{"id":"https://openalex.org/keywords/heuristic","display_name":"Heuristic","score":0.45025646686553955},{"id":"https://openalex.org/keywords/value","display_name":"Value (mathematics)","score":0.4385336935520172},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.32078492641448975},{"id":"https://openalex.org/keywords/real-time-computing","display_name":"Real-time computing","score":0.29777616262435913},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.09634560346603394}],"concepts":[{"id":"https://openalex.org/C113954288","wikidata":"https://www.wikidata.org/wiki/Q186885","display_name":"Timestamp","level":2,"score":0.8749138116836548},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.8309759497642517},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5931230783462524},{"id":"https://openalex.org/C143724316","wikidata":"https://www.wikidata.org/wiki/Q312468","display_name":"Series (stratigraphy)","level":2,"score":0.5885831713676453},{"id":"https://openalex.org/C173801870","wikidata":"https://www.wikidata.org/wiki/Q201413","display_name":"Heuristic","level":2,"score":0.45025646686553955},{"id":"https://openalex.org/C2776291640","wikidata":"https://www.wikidata.org/wiki/Q2912517","display_name":"Value (mathematics)","level":2,"score":0.4385336935520172},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.32078492641448975},{"id":"https://openalex.org/C79403827","wikidata":"https://www.wikidata.org/wiki/Q3988","display_name":"Real-time computing","level":1,"score":0.29777616262435913},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.09634560346603394},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"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/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3588703","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3588703","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1145/3588703","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3588703","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-article"},"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","score":0.6499999761581421,"id":"https://metadata.un.org/sdg/9"}],"awards":[{"id":"https://openalex.org/G1089940128","display_name":null,"funder_award_id":"62021002, 62072265, 62232005","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G2154614518","display_name":"\u65f6\u5e8f\u6570\u636e\u6e05\u7406\u5173\u952e\u6280\u672f\u7814\u7a76","funder_award_id":"62072265","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G416325850","display_name":null,"funder_award_id":"BNR2022RC01011","funder_id":"https://openalex.org/F4320329777","funder_display_name":"Beijing National Research Center For Information Science And Technology"},{"id":"https://openalex.org/G7091651887","display_name":null,"funder_award_id":"62021002","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G7508556822","display_name":null,"funder_award_id":"62232005","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320329777","display_name":"Beijing National Research Center For Information Science And Technology","ror":null}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":20,"referenced_works":["https://openalex.org/W2044220375","https://openalex.org/W2089117840","https://openalex.org/W2096598900","https://openalex.org/W2114854276","https://openalex.org/W2121269638","https://openalex.org/W2121516976","https://openalex.org/W2137847645","https://openalex.org/W2294581520","https://openalex.org/W2295880318","https://openalex.org/W2482320976","https://openalex.org/W2558012959","https://openalex.org/W2981881106","https://openalex.org/W3081257211","https://openalex.org/W3086558596","https://openalex.org/W3105021520","https://openalex.org/W3147694699","https://openalex.org/W3175055685","https://openalex.org/W3196580506","https://openalex.org/W4220865118","https://openalex.org/W6697188744"],"related_works":["https://openalex.org/W2060561905","https://openalex.org/W1417711376","https://openalex.org/W2032260263","https://openalex.org/W1986883493","https://openalex.org/W2469862403","https://openalex.org/W2166378262","https://openalex.org/W2035891203","https://openalex.org/W4379524643","https://openalex.org/W2011027677","https://openalex.org/W2367807705"],"abstract_inverted_index":{"Columnar":[0],"storage":[1,40,78,135,195,232],"is":[2,61,108,137,169],"now":[3],"an":[4,202],"industry":[5],"standard":[6],"design":[7],"in":[8,54,75,199],"most":[9],"open-source":[10,203],"or":[11,235,255],"commercial":[12],"time":[13,22,26,44,69,87,110,153,186,204,244,261],"series":[14,27,45,111,187,205],"database":[15],"products,":[16],"making":[17],"them":[18,65],"HTAP":[19],"systems.":[20],"The":[21,106,133,192,207],"column":[23,70,88,162,193,222,247],"of":[24,50,57,93,158,233,246,253],"a":[25,47,55,76,180],"serves":[28],"as":[29],"the":[30,34,85,90,147,151,156,160,165,220,231,240],"key":[31],"for":[32,102,164,183,188],"identifying":[33],"other":[35],"value":[36,73,82,148],"column,":[37],"namely":[38],"single-column":[39,234,254],"scheme.":[41,79],"When":[42],"multiple":[43,58,72,81,143],"share":[46,150],"similar":[48],"set":[49],"timestamps,":[51,95],"very":[52],"likely":[53],"module":[56],"sensors,":[59],"it":[60,96],"natural":[62],"to":[63,121,139,174,251],"group":[64],"together,":[66],"i.e.,":[67,257],"one":[68],"identifies":[71],"columns":[74,83,141,149],"single-group":[77,236],"While":[80],"sharing":[84],"same":[86,152],"reduce":[89],"space":[91,100,167],"cost":[92,101,168],"repeating":[94],"may":[97,112],"introduce":[98],"extra":[99,260],"recording":[103],"null":[104],"values.":[105],"reason":[107],"that":[109,219],"not":[113],"be":[114],"exactly":[115],"aligned":[116],"on":[117],"each":[118],"timestamp,":[119],"owing":[120],"missing":[122],"values,":[123],"distinct":[124],"data":[125,213],"collection":[126],"frequencies,":[127],"unsynchronized":[128],"clocks":[129],"and":[130,242],"so":[131],"on.":[132],"columngroups":[134],"scheme":[136],"thus":[138],"divide":[140],"into":[142],"groups,":[144],"within":[145],"which":[146],"column.":[154],"Unfortunately,":[155],"problem":[157],"finding":[159],"optimal":[161,226],"groups":[163,194,223,248],"minimum":[166],"highly":[170],"challenging,":[171],"NP-hard":[172],"according":[173],"our":[175,215],"analysis.":[176],"Thereby,":[177],"we":[178],"propose":[179],"heuristic":[181],"algorithm":[182],"automatically":[184],"grouping":[185],"efficient":[189],"columnar":[190],"storage.":[191],"has":[196],"been":[197],"deployed":[198],"Apache":[200],"IoTDB,":[201],"database.":[206],"extensive":[208],"performance":[209],"analysis,":[210],"over":[211],"real-world":[212],"from":[214],"industrial":[216],"partners,":[217],"demonstrates":[218],"proposed":[221],"achieve":[224],"near":[225],"storage,":[227],"more":[228],"concise":[229],"than":[230],"schemes.":[237],"Interestingly,":[238],"both":[239],"flushing":[241],"querying":[243],"costs":[245],"are":[249],"comparable":[250],"those":[252],"singlegroup,":[256],"without":[258],"incurring":[259],"cost.":[262]},"counts_by_year":[{"year":2025,"cited_by_count":5},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":1}],"updated_date":"2026-06-26T08:34:08.712188","created_date":"2025-10-10T00:00:00"}