{"id":"https://openalex.org/W4404181119","doi":"https://doi.org/10.14778/3685800.3685879","title":"Clean4TSDB: A Data Cleaning Tool for Time Series Databases","display_name":"Clean4TSDB: A Data Cleaning Tool for Time Series Databases","publication_year":2024,"publication_date":"2024-08-01","ids":{"openalex":"https://openalex.org/W4404181119","doi":"https://doi.org/10.14778/3685800.3685879"},"language":"en","primary_location":{"id":"doi:10.14778/3685800.3685879","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3685800.3685879","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/A5035726597","display_name":"Xiaoou Ding","orcid":"https://orcid.org/0000-0002-9426-1820"},"institutions":[{"id":"https://openalex.org/I204983213","display_name":"Harbin Institute of Technology","ror":"https://ror.org/01yqg2h08","country_code":"CN","type":"education","lineage":["https://openalex.org/I204983213"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Xiaoou Ding","raw_affiliation_strings":["Harbin Institute of Technology"],"affiliations":[{"raw_affiliation_string":"Harbin Institute of Technology","institution_ids":["https://openalex.org/I204983213"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5043849707","display_name":"Yichen Song","orcid":null},"institutions":[{"id":"https://openalex.org/I204983213","display_name":"Harbin Institute of Technology","ror":"https://ror.org/01yqg2h08","country_code":"CN","type":"education","lineage":["https://openalex.org/I204983213"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yichen Song","raw_affiliation_strings":["Harbin Institute of Technology"],"affiliations":[{"raw_affiliation_string":"Harbin Institute of Technology","institution_ids":["https://openalex.org/I204983213"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100396652","display_name":"Hongzhi Wang","orcid":"https://orcid.org/0000-0002-7521-2871"},"institutions":[{"id":"https://openalex.org/I204983213","display_name":"Harbin Institute of Technology","ror":"https://ror.org/01yqg2h08","country_code":"CN","type":"education","lineage":["https://openalex.org/I204983213"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Hongzhi Wang","raw_affiliation_strings":["Harbin Institute of Technology"],"affiliations":[{"raw_affiliation_string":"Harbin Institute of Technology","institution_ids":["https://openalex.org/I204983213"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100321852","display_name":"Donghua Yang","orcid":"https://orcid.org/0000-0002-6102-1804"},"institutions":[{"id":"https://openalex.org/I204983213","display_name":"Harbin Institute of Technology","ror":"https://ror.org/01yqg2h08","country_code":"CN","type":"education","lineage":["https://openalex.org/I204983213"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Donghua Yang","raw_affiliation_strings":["Harbin Institute of Technology"],"affiliations":[{"raw_affiliation_string":"Harbin Institute of Technology","institution_ids":["https://openalex.org/I204983213"]}]},{"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"],"affiliations":[{"raw_affiliation_string":"Tsinghua University","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5115591736","display_name":"Jianmin Wang","orcid":null},"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"],"affiliations":[{"raw_affiliation_string":"Tsinghua University","institution_ids":["https://openalex.org/I99065089"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5035726597"],"corresponding_institution_ids":["https://openalex.org/I204983213"],"apc_list":null,"apc_paid":null,"fwci":4.8755,"has_fulltext":false,"cited_by_count":13,"citation_normalized_percentile":{"value":0.96091659,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"17","issue":"12","first_page":"4377","last_page":"4380"},"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.9980000257492065,"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.9980000257492065,"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.9976999759674072,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.994700014591217,"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/database","display_name":"Database","score":0.7143945693969727},{"id":"https://openalex.org/keywords/series","display_name":"Series (stratigraphy)","score":0.638152003288269},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.491299569606781},{"id":"https://openalex.org/keywords/geology","display_name":"Geology","score":0.1273440420627594}],"concepts":[{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7143945693969727},{"id":"https://openalex.org/C143724316","wikidata":"https://www.wikidata.org/wiki/Q312468","display_name":"Series (stratigraphy)","level":2,"score":0.638152003288269},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.491299569606781},{"id":"https://openalex.org/C127313418","wikidata":"https://www.wikidata.org/wiki/Q1069","display_name":"Geology","level":0,"score":0.1273440420627594},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3685800.3685879","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3685800.3685879","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":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.5199999809265137}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":11,"referenced_works":["https://openalex.org/W2481159763","https://openalex.org/W2574787764","https://openalex.org/W2734096706","https://openalex.org/W2970651950","https://openalex.org/W3094404806","https://openalex.org/W3202226255","https://openalex.org/W4288057688","https://openalex.org/W4366572738","https://openalex.org/W4381326806","https://openalex.org/W4400909959","https://openalex.org/W6732337570"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W4391913857","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052"],"abstract_inverted_index":{"Billions":[0],"of":[1,11,39,49,188,199],"data":[2,16,30,79,93,114],"points":[3],"are":[4],"generated":[5],"by":[6],"devices":[7],"equipped":[8],"with":[9,159],"thousands":[10],"sensors,":[12],"leading":[13],"to":[14,57,194],"significant":[15],"quality":[17,94,115],"issues":[18],"in":[19],"time":[20,28,50,67,83,101,124,145,160,190],"series":[21,29,51,68,84,102,146,161,191],"data.":[22,44],"These":[23],"errors":[24],"not":[25],"only":[26],"complicate":[27],"management":[31,201],"but":[32],"also":[33],"compromise":[34],"the":[35,46,196],"accuracy":[36],"and":[37,61,99,126,138,168,177],"reliability":[38],"analysis":[40],"based":[41],"on":[42],"such":[43],"Given":[45],"noteworthy":[47],"characteristics":[48],"data,":[52],"existing":[53],"cleaning":[54,80,147,180],"methods":[55],"struggle":[56],"provide":[58],"adequate":[59],"repairs,":[60],"tools":[62],"supporting":[63],"expressive":[64,92],"constraints":[65],"for":[66,82,131,156],"remain":[69],"scarce.":[70],"To":[71],"address":[72],"this,":[73],"we":[74,110,141,183],"develop":[75],"Clean4TSDB,":[76],"a":[77,105,113,150,185],"specialized":[78],"system":[81,87,151],"databases.":[85],"This":[86],"integrates":[88],"three":[89],"key":[90],"modules:":[91],"constraint":[95,116],"discovery,":[96],"violation":[97],"detection,":[98],"multivariate":[100,123],"repairing,":[103],"forming":[104],"comprehensive":[106,186],"\"profiling-detection-repair\"":[107],"workflow.":[108],"Technically,":[109],"introduce":[111],"TSDD,":[112],"that":[117],"effectively":[118,172],"captures":[119],"contextual":[120],"relationships":[121],"within":[122],"series,":[125],"implement":[127],"an":[128,143],"efficient":[129],"algorithm":[130],"its":[132],"automated":[133],"mining.":[134],"Leveraging":[135],"both":[136],"row-":[137],"column-based":[139],"constraints,":[140,170],"propose":[142],"effective":[144],"algorithm.":[148],"From":[149],"standpoint,":[152],"Clean4TSDB":[153],"is":[154],"pre-configured":[155],"seamless":[157],"integration":[158],"databases":[162],"like":[163],"Apache":[164],"IoTDB.":[165],"Using":[166],"user-provided":[167],"algorithmically-mined":[169],"it":[171],"identifies":[173],"various":[174],"error":[175],"patterns":[176],"offers":[178],"reliable":[179],"solutions.":[181],"Furthermore,":[182],"establish":[184],"library":[187],"state-of-the-art":[189],"repair":[192],"algorithms":[193],"meet":[195],"diverse":[197],"needs":[198],"different":[200],"scenarios.":[202]},"counts_by_year":[{"year":2025,"cited_by_count":12},{"year":2024,"cited_by_count":1}],"updated_date":"2025-12-21T01:58:51.020947","created_date":"2025-10-10T00:00:00"}