{"id":"https://openalex.org/W3100254136","doi":"https://doi.org/10.1109/crc51253.2020.9253463","title":"Query Optimization for Air Quality Big Data based on Hive-ORC","display_name":"Query Optimization for Air Quality Big Data based on Hive-ORC","publication_year":2020,"publication_date":"2020-10-16","ids":{"openalex":"https://openalex.org/W3100254136","doi":"https://doi.org/10.1109/crc51253.2020.9253463","mag":"3100254136"},"language":"en","primary_location":{"id":"doi:10.1109/crc51253.2020.9253463","is_oa":false,"landing_page_url":"https://doi.org/10.1109/crc51253.2020.9253463","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2020 5th International Conference on Control, Robotics and Cybernetics (CRC)","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/A5033387642","display_name":"Bei Peng","orcid":null},"institutions":[{"id":"https://openalex.org/I91125648","display_name":"Wuhan Institute of Technology","ror":"https://ror.org/04jcykh16","country_code":"CN","type":"education","lineage":["https://openalex.org/I91125648"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Bei Peng","raw_affiliation_strings":["School of Computer Science and Engineering, Wuhan Institute of Technology, Wuhan, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science and Engineering, Wuhan Institute of Technology, Wuhan, China","institution_ids":["https://openalex.org/I91125648"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5090737854","display_name":"Lizhi Liu","orcid":null},"institutions":[{"id":"https://openalex.org/I91125648","display_name":"Wuhan Institute of Technology","ror":"https://ror.org/04jcykh16","country_code":"CN","type":"education","lineage":["https://openalex.org/I91125648"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Lizhi Liu","raw_affiliation_strings":["School of Computer Science and Engineering, Wuhan Institute of Technology, Wuhan, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science and Engineering, Wuhan Institute of Technology, Wuhan, China","institution_ids":["https://openalex.org/I91125648"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5033387642"],"corresponding_institution_ids":["https://openalex.org/I91125648"],"apc_list":null,"apc_paid":null,"fwci":0.2661,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.60625882,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":"45","issue":null,"first_page":"19","last_page":"23"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T14249","display_name":"Water Quality Monitoring and Analysis","score":0.9664999842643738,"subfield":{"id":"https://openalex.org/subfields/2311","display_name":"Industrial and Manufacturing Engineering"},"field":{"id":"https://openalex.org/fields/23","display_name":"Environmental Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T14249","display_name":"Water Quality Monitoring and Analysis","score":0.9664999842643738,"subfield":{"id":"https://openalex.org/subfields/2311","display_name":"Industrial and Manufacturing Engineering"},"field":{"id":"https://openalex.org/fields/23","display_name":"Environmental 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.9484000205993652,"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/T12120","display_name":"Air Quality Monitoring and Forecasting","score":0.9412000179290771,"subfield":{"id":"https://openalex.org/subfields/2305","display_name":"Environmental Engineering"},"field":{"id":"https://openalex.org/fields/23","display_name":"Environmental 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.7271037101745605},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.5913312435150146},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5672784447669983},{"id":"https://openalex.org/keywords/quality","display_name":"Quality (philosophy)","score":0.5612624883651733},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4111787676811218},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.24208959937095642}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7271037101745605},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.5913312435150146},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5672784447669983},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.5612624883651733},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4111787676811218},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.24208959937095642},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/crc51253.2020.9253463","is_oa":false,"landing_page_url":"https://doi.org/10.1109/crc51253.2020.9253463","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2020 5th International Conference on Control, Robotics and Cybernetics (CRC)","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":5,"referenced_works":["https://openalex.org/W2533798180","https://openalex.org/W2578439235","https://openalex.org/W2784129778","https://openalex.org/W2972702295","https://openalex.org/W2982021771"],"related_works":["https://openalex.org/W2748952813","https://openalex.org/W4390608645","https://openalex.org/W4247566972","https://openalex.org/W2960264696","https://openalex.org/W3090563135","https://openalex.org/W2497432351","https://openalex.org/W4206777497","https://openalex.org/W4233347783","https://openalex.org/W2910064364","https://openalex.org/W4255224757"],"abstract_inverted_index":{"To":[0],"improve":[1],"the":[2,6,46,59,73,97,101,108,123,133,157],"efficiency":[3],"of":[4,9,48,63,110,136,159],"analyzing":[5],"massive":[7],"amount":[8],"monitoring":[10,17,56,61],"data":[11,24,28,57,74,112,138,160],"collected":[12],"from":[13,58],"an":[14],"air":[15,49,54],"quality":[16,50,55],"system,":[18],"a":[19,69],"method":[20,102,109,125],"based":[21,126],"on":[22,92,117,127],"Hive":[23],"warehouse":[25],"to":[26,44,77,82,95],"store":[27],"as":[29,68,113],"ORC":[30],"file":[31],"format":[32],"then":[33],"create":[34],"Row":[35],"Group":[36],"Index":[37,41],"and":[38,84,107,129,141],"Bloom":[39],"Filter":[40],"is":[42],"proposed":[43,103],"optimize":[45],"query":[47,83,144],"big":[51,137],"data.":[52,86],"The":[53,119],"environmental":[60],"center":[62],"Hubei":[64],"province":[65],"was":[66,75,80],"taken":[67],"research":[70],"object.":[71],"After":[72],"transferred":[76],"Hive,":[78],"Spark":[79],"used":[81],"analyze":[85],"Five":[87],"queries":[88],"were":[89],"carried":[90],"out":[91],"three":[93],"datasets":[94],"conduct":[96],"comparison":[98],"experiment":[99],"between":[100],"in":[104],"this":[105],"paper":[106],"storing":[111],"TextFile":[114],"by":[115,139,146],"default":[116],"Hive.":[118],"results":[120],"show":[121],"that":[122],"optimization":[124,151],"Hive-ORC":[128],"its":[130,143],"indexes":[131],"reduces":[132,142],"storage":[134],"space":[135],"90%":[140],"time":[145],"86%.":[147],"What's":[148],"more,":[149],"better":[150],"effect":[152],"can":[153],"be":[154],"achieved":[155],"with":[156],"increase":[158],"volume.":[161]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}