{"id":"https://openalex.org/W1615880688","doi":"https://doi.org/10.1109/icinfa.2015.7279485","title":"Real-Time data ETL framework for big real-time data analysis","display_name":"Real-Time data ETL framework for big real-time data analysis","publication_year":2015,"publication_date":"2015-08-01","ids":{"openalex":"https://openalex.org/W1615880688","doi":"https://doi.org/10.1109/icinfa.2015.7279485","mag":"1615880688"},"language":"en","primary_location":{"id":"doi:10.1109/icinfa.2015.7279485","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icinfa.2015.7279485","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE International Conference on Information and Automation","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/A5086450848","display_name":"Xiaofang Li","orcid":"https://orcid.org/0000-0003-1554-4484"},"institutions":[{"id":"https://openalex.org/I4210108723","display_name":"Changzhou Institute of Technology","ror":"https://ror.org/020mrfq61","country_code":"CN","type":"education","lineage":["https://openalex.org/I4210108723"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Xiaofang Li","raw_affiliation_strings":["College of Computer and Information Engineering, Changzhou Institute of Technology, Changzhou, China","College of Computer and Information Engineering, Changzhou Institute of Technology, China"],"affiliations":[{"raw_affiliation_string":"College of Computer and Information Engineering, Changzhou Institute of Technology, Changzhou, China","institution_ids":["https://openalex.org/I4210108723"]},{"raw_affiliation_string":"College of Computer and Information Engineering, Changzhou Institute of Technology, China","institution_ids":["https://openalex.org/I4210108723"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5113881053","display_name":"Yingchi Mao","orcid":"https://orcid.org/0000-0002-9884-8100"},"institutions":[{"id":"https://openalex.org/I163340411","display_name":"Hohai University","ror":"https://ror.org/01wd4xt90","country_code":"CN","type":"education","lineage":["https://openalex.org/I163340411"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yingchi Mao","raw_affiliation_strings":["College of Computer and Information Engineering, Hohai University, Nanjing, China","College of Computer and Information Engineering , Hohai University Nanjing , China"],"affiliations":[{"raw_affiliation_string":"College of Computer and Information Engineering, Hohai University, Nanjing, China","institution_ids":["https://openalex.org/I163340411"]},{"raw_affiliation_string":"College of Computer and Information Engineering , Hohai University Nanjing , China","institution_ids":["https://openalex.org/I163340411"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5086450848"],"corresponding_institution_ids":["https://openalex.org/I4210108723"],"apc_list":null,"apc_paid":null,"fwci":2.3297,"has_fulltext":false,"cited_by_count":27,"citation_normalized_percentile":{"value":0.89315772,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1289","last_page":"1294"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9976999759674072,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9976999759674072,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9962999820709229,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9954000115394592,"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/data-warehouse","display_name":"Data warehouse","score":0.855636715888977},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8113778829574585},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.6725690364837646},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.6723058223724365},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.6139248609542847},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6049636006355286},{"id":"https://openalex.org/keywords/real-time-database","display_name":"Real-time database","score":0.5959819555282593},{"id":"https://openalex.org/keywords/scada","display_name":"SCADA","score":0.5211220383644104},{"id":"https://openalex.org/keywords/real-time-data","display_name":"Real-time data","score":0.4912359118461609},{"id":"https://openalex.org/keywords/skew","display_name":"Skew","score":0.48129525780677795},{"id":"https://openalex.org/keywords/dynamic-data","display_name":"Dynamic data","score":0.4593863785266876},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.41697725653648376},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.39951807260513306},{"id":"https://openalex.org/keywords/real-time-computing","display_name":"Real-time computing","score":0.37369346618652344},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.27559369802474976},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.19038790464401245},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.17402416467666626},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.0906444787979126}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.855636715888977},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8113778829574585},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.6725690364837646},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.6723058223724365},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.6139248609542847},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6049636006355286},{"id":"https://openalex.org/C2776675167","wikidata":"https://www.wikidata.org/wiki/Q669265","display_name":"Real-time database","level":2,"score":0.5959819555282593},{"id":"https://openalex.org/C113863187","wikidata":"https://www.wikidata.org/wiki/Q17498","display_name":"SCADA","level":2,"score":0.5211220383644104},{"id":"https://openalex.org/C110593043","wikidata":"https://www.wikidata.org/wiki/Q7300787","display_name":"Real-time data","level":2,"score":0.4912359118461609},{"id":"https://openalex.org/C43711488","wikidata":"https://www.wikidata.org/wiki/Q7534783","display_name":"Skew","level":2,"score":0.48129525780677795},{"id":"https://openalex.org/C197298091","wikidata":"https://www.wikidata.org/wiki/Q5318963","display_name":"Dynamic data","level":2,"score":0.4593863785266876},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.41697725653648376},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.39951807260513306},{"id":"https://openalex.org/C79403827","wikidata":"https://www.wikidata.org/wiki/Q3988","display_name":"Real-time computing","level":1,"score":0.37369346618652344},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.27559369802474976},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.19038790464401245},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.17402416467666626},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0906444787979126},{"id":"https://openalex.org/C119599485","wikidata":"https://www.wikidata.org/wiki/Q43035","display_name":"Electrical engineering","level":1,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icinfa.2015.7279485","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icinfa.2015.7279485","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE International Conference on Information and Automation","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":8,"referenced_works":["https://openalex.org/W197630086","https://openalex.org/W2065668182","https://openalex.org/W2088398920","https://openalex.org/W2098806777","https://openalex.org/W2130420584","https://openalex.org/W2149928191","https://openalex.org/W3138367763","https://openalex.org/W6638231387"],"related_works":["https://openalex.org/W2188975716","https://openalex.org/W1555950237","https://openalex.org/W2084383859","https://openalex.org/W2067405892","https://openalex.org/W2612731889","https://openalex.org/W834810655","https://openalex.org/W2759374221","https://openalex.org/W2400366270","https://openalex.org/W2493592314","https://openalex.org/W2102729946"],"abstract_inverted_index":{"In":[0,81],"the":[1,30,47,53,59,69,77,84,94,116,125,132,137,140,150,160],"big":[2],"data":[3,5,20,32,35,43,49,55,66,79,86,96,143,155,164],"era,":[4],"become":[6],"more":[7],"important":[8],"for":[9],"BI":[10],"and":[11,24,51,97,121,163],"SCADA":[12,62],"system":[13],"operation.":[14],"The":[15,64,146],"load":[16],"cycle":[17],"of":[18,41,61,139],"traditional":[19,42],"warehouse":[21,36],"is":[22,72,89,127],"fix":[23],"longer,":[25],"which":[26],"cannot":[27],"timely":[28],"response":[29],"rapid":[31,48],"change.":[33],"Real-time":[34],"technology,":[37],"as":[38],"an":[39,102],"extension":[40],"warehouse,":[44],"can":[45,157],"capture":[46],"change":[50],"process":[52,93],"real-time":[54,65,78,85,98,142,154],"analysis":[56],"to":[57,76,91,114,135,153],"meet":[58],"requirements":[60],"system.":[63],"access":[67],"without":[68],"processing":[70],"delay":[71],"a":[73,107],"challenging":[74],"task":[75],"warehouse.":[80],"this":[82],"paper,":[83],"ETL":[87,144,156],"framework":[88],"presented":[90],"separately":[92],"historical":[95],"data.":[99],"Then,":[100],"combining":[101],"external":[103],"dynamic":[104,108],"storage":[105],"area,":[106],"mirror":[109],"replication":[110],"technology":[111],"was":[112],"proposed":[113,141,151],"avoid":[115],"contention":[117,162],"between":[118],"OLAP":[119],"queries":[120],"OLTP":[122],"updates.":[123],"Finally,":[124],"experiments":[126],"set":[128],"up":[129],"based":[130],"on":[131],"TPC-H":[133],"benchmark":[134],"evaluate":[136],"performance":[138],"framework.":[145],"experimental":[147],"results":[148],"demonstrates":[149],"solution":[152],"effectively":[158],"mitigate":[159],"query":[161],"skew.":[165]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":5},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}