{"id":"https://openalex.org/W1992958587","doi":"https://doi.org/10.1109/etfa.2010.5641312","title":"Data compression and query for large scale sensor data on COTS DBMS","display_name":"Data compression and query for large scale sensor data on COTS DBMS","publication_year":2010,"publication_date":"2010-09-01","ids":{"openalex":"https://openalex.org/W1992958587","doi":"https://doi.org/10.1109/etfa.2010.5641312","mag":"1992958587"},"language":"en","primary_location":{"id":"doi:10.1109/etfa.2010.5641312","is_oa":false,"landing_page_url":"https://doi.org/10.1109/etfa.2010.5641312","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2010 IEEE 15th Conference on Emerging Technologies & Factory Automation (ETFA 2010)","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/A5061104254","display_name":"Pei-Lun Suei","orcid":null},"institutions":[{"id":"https://openalex.org/I16733864","display_name":"National Taiwan University","ror":"https://ror.org/05bqach95","country_code":"TW","type":"education","lineage":["https://openalex.org/I16733864"]}],"countries":["TW"],"is_corresponding":true,"raw_author_name":"Pei-Lun Suei","raw_affiliation_strings":["Department of Computer Science and Information Engineering, National Taiwan University, Taipei, Taiwan","Department of Computer Science and Information Engineering, National Taiwan University, Taipei, Taiwan 106"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Information Engineering, National Taiwan University, Taipei, Taiwan","institution_ids":["https://openalex.org/I16733864"]},{"raw_affiliation_string":"Department of Computer Science and Information Engineering, National Taiwan University, Taipei, Taiwan 106","institution_ids":["https://openalex.org/I16733864"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101197341","display_name":"Che-Wei Kuo","orcid":null},"institutions":[{"id":"https://openalex.org/I16733864","display_name":"National Taiwan University","ror":"https://ror.org/05bqach95","country_code":"TW","type":"education","lineage":["https://openalex.org/I16733864"]}],"countries":["TW"],"is_corresponding":false,"raw_author_name":"Che-Wei Kuo","raw_affiliation_strings":["Department of Computer Science and Information Engineering, National Taiwan University, Taipei, Taiwan","Department of Computer Science and Information Engineering, National Taiwan University, Taipei, Taiwan 106"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Information Engineering, National Taiwan University, Taipei, Taiwan","institution_ids":["https://openalex.org/I16733864"]},{"raw_affiliation_string":"Department of Computer Science and Information Engineering, National Taiwan University, Taipei, Taiwan 106","institution_ids":["https://openalex.org/I16733864"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5097852354","display_name":"Ren-Shan Luoh","orcid":null},"institutions":[{"id":"https://openalex.org/I16733864","display_name":"National Taiwan University","ror":"https://ror.org/05bqach95","country_code":"TW","type":"education","lineage":["https://openalex.org/I16733864"]}],"countries":["TW"],"is_corresponding":false,"raw_author_name":"Ren-Shan Luoh","raw_affiliation_strings":["Department of Computer Science and Information Engineering, National Taiwan University, Taipei, Taiwan","Department of Computer Science and Information Engineering, National Taiwan University, Taipei, Taiwan 106"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Information Engineering, National Taiwan University, Taipei, Taiwan","institution_ids":["https://openalex.org/I16733864"]},{"raw_affiliation_string":"Department of Computer Science and Information Engineering, National Taiwan University, Taipei, Taiwan 106","institution_ids":["https://openalex.org/I16733864"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109103258","display_name":"Tai-Wei Kuo","orcid":null},"institutions":[{"id":"https://openalex.org/I16733864","display_name":"National Taiwan University","ror":"https://ror.org/05bqach95","country_code":"TW","type":"education","lineage":["https://openalex.org/I16733864"]}],"countries":["TW"],"is_corresponding":false,"raw_author_name":"Tai-Wei Kuo","raw_affiliation_strings":["Department of Computer Science and Information Engineering, National Taiwan University, Taipei, Taiwan","Department of Computer Science and Information Engineering, National Taiwan University, Taipei, Taiwan 106"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Information Engineering, National Taiwan University, Taipei, Taiwan","institution_ids":["https://openalex.org/I16733864"]},{"raw_affiliation_string":"Department of Computer Science and Information Engineering, National Taiwan University, Taipei, Taiwan 106","institution_ids":["https://openalex.org/I16733864"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057633046","display_name":"Chi\u2010Sheng Shih","orcid":"https://orcid.org/0000-0001-8936-8255"},"institutions":[{"id":"https://openalex.org/I16733864","display_name":"National Taiwan University","ror":"https://ror.org/05bqach95","country_code":"TW","type":"education","lineage":["https://openalex.org/I16733864"]}],"countries":["TW"],"is_corresponding":false,"raw_author_name":"Chi-Sheng Shih","raw_affiliation_strings":["Graduate Institute of Networking and Multimedia, National Taiwan University, Taipei, Taiwan","Graduate Institute of Networking and Multimedia, National Taiwan University, Taipei, Taiwan 106"],"affiliations":[{"raw_affiliation_string":"Graduate Institute of Networking and Multimedia, National Taiwan University, Taipei, Taiwan","institution_ids":["https://openalex.org/I16733864"]},{"raw_affiliation_string":"Graduate Institute of Networking and Multimedia, National Taiwan University, Taipei, Taiwan 106","institution_ids":["https://openalex.org/I16733864"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5019808209","display_name":"Min-Siong Liang","orcid":null},"institutions":[{"id":"https://openalex.org/I3141939062","display_name":"Institute for Information Industry","ror":"https://ror.org/01d8kr740","country_code":"TW","type":"nonprofit","lineage":["https://openalex.org/I3141939062"]}],"countries":["TW"],"is_corresponding":false,"raw_author_name":"Min-Siong Liang","raw_affiliation_strings":["Institute for Information Industry, Taipei, Taiwan","Institute for Information Industry, Taipei, Taiwan 106"],"affiliations":[{"raw_affiliation_string":"Institute for Information Industry, Taipei, Taiwan","institution_ids":["https://openalex.org/I3141939062"]},{"raw_affiliation_string":"Institute for Information Industry, Taipei, Taiwan 106","institution_ids":["https://openalex.org/I3141939062"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5061104254"],"corresponding_institution_ids":["https://openalex.org/I16733864"],"apc_list":null,"apc_paid":null,"fwci":0.3561,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.60667356,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"91","issue":null,"first_page":"1","last_page":"8"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10080","display_name":"Energy Efficient Wireless Sensor Networks","score":0.9965000152587891,"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/T10080","display_name":"Energy Efficient Wireless Sensor Networks","score":0.9965000152587891,"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/T11106","display_name":"Data Management and Algorithms","score":0.9897000193595886,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9700000286102295,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8209190964698792},{"id":"https://openalex.org/keywords/lossless-compression","display_name":"Lossless compression","score":0.604428768157959},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.5377877354621887},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5329796671867371},{"id":"https://openalex.org/keywords/data-compression","display_name":"Data compression","score":0.5326489806175232},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.518761396408081},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.5104090571403503},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.49202463030815125},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4794929623603821},{"id":"https://openalex.org/keywords/data-set","display_name":"Data set","score":0.43998607993125916},{"id":"https://openalex.org/keywords/data-compression-ratio","display_name":"Data compression ratio","score":0.4381875991821289},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.4277113676071167},{"id":"https://openalex.org/keywords/lossy-compression","display_name":"Lossy compression","score":0.4238138496875763},{"id":"https://openalex.org/keywords/compression-ratio","display_name":"Compression ratio","score":0.4223180413246155},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.29382461309432983},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.2704582214355469},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.16865214705467224},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.15583059191703796},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.10848754644393921},{"id":"https://openalex.org/keywords/image-compression","display_name":"Image compression","score":0.09591829776763916},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.09552589058876038}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8209190964698792},{"id":"https://openalex.org/C81081738","wikidata":"https://www.wikidata.org/wiki/Q55542","display_name":"Lossless compression","level":3,"score":0.604428768157959},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.5377877354621887},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5329796671867371},{"id":"https://openalex.org/C78548338","wikidata":"https://www.wikidata.org/wiki/Q2493","display_name":"Data compression","level":2,"score":0.5326489806175232},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.518761396408081},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.5104090571403503},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.49202463030815125},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4794929623603821},{"id":"https://openalex.org/C58489278","wikidata":"https://www.wikidata.org/wiki/Q1172284","display_name":"Data set","level":2,"score":0.43998607993125916},{"id":"https://openalex.org/C94835093","wikidata":"https://www.wikidata.org/wiki/Q3113333","display_name":"Data compression ratio","level":5,"score":0.4381875991821289},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.4277113676071167},{"id":"https://openalex.org/C165021410","wikidata":"https://www.wikidata.org/wiki/Q55564","display_name":"Lossy compression","level":2,"score":0.4238138496875763},{"id":"https://openalex.org/C25797200","wikidata":"https://www.wikidata.org/wiki/Q828137","display_name":"Compression ratio","level":3,"score":0.4223180413246155},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.29382461309432983},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.2704582214355469},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.16865214705467224},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.15583059191703796},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.10848754644393921},{"id":"https://openalex.org/C13481523","wikidata":"https://www.wikidata.org/wiki/Q412438","display_name":"Image compression","level":4,"score":0.09591829776763916},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.09552589058876038},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C115961682","wikidata":"https://www.wikidata.org/wiki/Q860623","display_name":"Image (mathematics)","level":2,"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/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C9417928","wikidata":"https://www.wikidata.org/wiki/Q1070689","display_name":"Image processing","level":3,"score":0.0},{"id":"https://openalex.org/C171146098","wikidata":"https://www.wikidata.org/wiki/Q124192","display_name":"Automotive engineering","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/etfa.2010.5641312","is_oa":false,"landing_page_url":"https://doi.org/10.1109/etfa.2010.5641312","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2010 IEEE 15th Conference on Emerging Technologies & Factory Automation (ETFA 2010)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W2986990","https://openalex.org/W1558322811","https://openalex.org/W1993819379","https://openalex.org/W2011233235","https://openalex.org/W2018745370","https://openalex.org/W2105326258","https://openalex.org/W2137486085","https://openalex.org/W2149259182","https://openalex.org/W2167911783","https://openalex.org/W2341510490","https://openalex.org/W2753693129","https://openalex.org/W3145128584","https://openalex.org/W6655396424"],"related_works":["https://openalex.org/W2554271401","https://openalex.org/W2889903446","https://openalex.org/W2992414350","https://openalex.org/W3125756434","https://openalex.org/W2150741898","https://openalex.org/W3087188470","https://openalex.org/W4281289408","https://openalex.org/W2371929047","https://openalex.org/W2249768123","https://openalex.org/W185198413"],"abstract_inverted_index":{"Multi-dimensional":[0],"temporal":[1,15,78],"data":[2,29,56,79,100,126,154,158,173],"set":[3,30,80,127],"is":[4,63,89,189],"the":[5,21,24,28,37,115,124,132,148,165,180,183],"common":[6],"format":[7],"in":[8,27,151],"sensor":[9,95],"network":[10,96],"applications":[11],"to":[12,33,44,53,130,146,174,192],"store":[13],"sampled":[14,99],"data.":[16,178],"As":[17],"time":[18],"goes":[19],"on,":[20],"size":[22,35],"of":[23,153],"core":[25],"tables":[26,38],"may":[31],"increase":[32],"enormous":[34],"and":[36,48,88,110,143,157],"become":[39],"not":[40,83],"managable.":[41],"In":[42,67,114,179],"order":[43],"reduce":[45],"storage":[46],"space":[47],"allow":[49],"on-line":[50,60,85,118],"query,":[51],"how":[52],"trade":[54],"off":[55],"compression":[57,155,166],"effectiveness":[58],"for":[59,77,92,171,176,186],"query":[61,86,133,159,188],"performance":[62,87],"a":[64,139],"challenge":[65],"issue.":[66],"this":[68],"paper,":[69],"we":[70],"are":[71,101,120,136],"concerned":[72],"with":[73],"an":[74],"effective":[75],"framework":[76],"that":[81,164],"does":[82],"scarify":[84],"specifically":[90],"designed":[91],"very":[93],"large":[94],"database.":[97],"The":[98,161],"compressed":[102,125],"using":[103],"several":[104],"candidate":[105],"approaches":[106],"including":[107],"dictionary-base":[108],"compress":[109],"lossless":[111],"vector":[112],"quantization.":[113],"mean":[116,181],"time,":[117,182],"queries":[119],"conducted":[121,137],"without":[122],"decompressing":[123],"so":[128],"as":[129],"enhance":[131],"performance.":[134],"Experiments":[135],"on":[138],"power":[140],"meter":[141],"database":[142,145],"sonoma":[144],"evaluate":[147],"proposed":[149],"methodologies":[150],"terms":[152],"rate":[156,167],"speed.":[160],"results":[162],"show":[163],"ranges":[168],"from":[169],"70%":[170],"numerical":[172],"20%":[175],"character":[177],"increased":[184],"overhead":[185],"online":[187],"limited":[190],"up":[191],"2%.":[193]},"counts_by_year":[{"year":2020,"cited_by_count":2},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}