{"id":"https://openalex.org/W2790373568","doi":"https://doi.org/10.1109/access.2018.2816001","title":"An Integrated Approach for Massive Sequential Data Processing in Civil Infrastructure Operation and Maintenance","display_name":"An Integrated Approach for Massive Sequential Data Processing in Civil Infrastructure Operation and Maintenance","publication_year":2018,"publication_date":"2018-01-01","ids":{"openalex":"https://openalex.org/W2790373568","doi":"https://doi.org/10.1109/access.2018.2816001","mag":"2790373568"},"language":"en","primary_location":{"id":"doi:10.1109/access.2018.2816001","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2018.2816001","pdf_url":"https://ieeexplore.ieee.org/ielx7/6287639/8274985/08316849.pdf","source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://ieeexplore.ieee.org/ielx7/6287639/8274985/08316849.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5040261755","display_name":"Gang Yu","orcid":"https://orcid.org/0000-0003-1376-7959"},"institutions":[{"id":"https://openalex.org/I113940042","display_name":"Shanghai University","ror":"https://ror.org/006teas31","country_code":"CN","type":"education","lineage":["https://openalex.org/I113940042"]},{"id":"https://openalex.org/I4210086678","display_name":"Shanghai Urban Construction Design and Research Institute (Group)","ror":"https://ror.org/00y4qmx55","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210086678"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Gang Yu","raw_affiliation_strings":["Shanghai University\u2013Shanghai Urban Construction Group Research Center of Building Industrialization, Shanghai University, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"Shanghai University\u2013Shanghai Urban Construction Group Research Center of Building Industrialization, Shanghai University, Shanghai, China","institution_ids":["https://openalex.org/I4210086678","https://openalex.org/I113940042"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5026753820","display_name":"Jiajun Liu","orcid":"https://orcid.org/0000-0002-5800-8254"},"institutions":[{"id":"https://openalex.org/I4210086678","display_name":"Shanghai Urban Construction Design and Research Institute (Group)","ror":"https://ror.org/00y4qmx55","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210086678"]},{"id":"https://openalex.org/I113940042","display_name":"Shanghai University","ror":"https://ror.org/006teas31","country_code":"CN","type":"education","lineage":["https://openalex.org/I113940042"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jiajun Liu","raw_affiliation_strings":["Shanghai University\u2013Shanghai Urban Construction Group Research Center of Building Industrialization, Shanghai University, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"Shanghai University\u2013Shanghai Urban Construction Group Research Center of Building Industrialization, Shanghai University, Shanghai, China","institution_ids":["https://openalex.org/I4210086678","https://openalex.org/I113940042"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5070679528","display_name":"Juan Du","orcid":"https://orcid.org/0000-0002-6428-7763"},"institutions":[{"id":"https://openalex.org/I4210086678","display_name":"Shanghai Urban Construction Design and Research Institute (Group)","ror":"https://ror.org/00y4qmx55","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210086678"]},{"id":"https://openalex.org/I113940042","display_name":"Shanghai University","ror":"https://ror.org/006teas31","country_code":"CN","type":"education","lineage":["https://openalex.org/I113940042"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Juan Du","raw_affiliation_strings":["Shanghai University\u2013Shanghai Urban Construction Group Research Center of Building Industrialization, Shanghai University, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"Shanghai University\u2013Shanghai Urban Construction Group Research Center of Building Industrialization, Shanghai University, Shanghai, China","institution_ids":["https://openalex.org/I4210086678","https://openalex.org/I113940042"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101748110","display_name":"Min Hu","orcid":"https://orcid.org/0000-0001-8288-3078"},"institutions":[{"id":"https://openalex.org/I113940042","display_name":"Shanghai University","ror":"https://ror.org/006teas31","country_code":"CN","type":"education","lineage":["https://openalex.org/I113940042"]},{"id":"https://openalex.org/I4210086678","display_name":"Shanghai Urban Construction Design and Research Institute (Group)","ror":"https://ror.org/00y4qmx55","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210086678"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Min Hu","raw_affiliation_strings":["Shanghai University\u2013Shanghai Urban Construction Group Research Center of Building Industrialization, Shanghai University, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"Shanghai University\u2013Shanghai Urban Construction Group Research Center of Building Industrialization, Shanghai University, Shanghai, China","institution_ids":["https://openalex.org/I4210086678","https://openalex.org/I113940042"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5080285200","display_name":"Vijayan Sugumaran","orcid":"https://orcid.org/0000-0003-2557-3182"},"institutions":[{"id":"https://openalex.org/I177721651","display_name":"Oakland University","ror":"https://ror.org/01ythxj32","country_code":"US","type":"education","lineage":["https://openalex.org/I177721651"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Vijayan Sugumaran","raw_affiliation_strings":["Center for Data Science and Big Data Analytics, Oakland University, Rochester, MI, USA"],"affiliations":[{"raw_affiliation_string":"Center for Data Science and Big Data Analytics, Oakland University, Rochester, MI, USA","institution_ids":["https://openalex.org/I177721651"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5040261755"],"corresponding_institution_ids":["https://openalex.org/I113940042","https://openalex.org/I4210086678"],"apc_list":{"value":1850,"currency":"USD","value_usd":1850},"apc_paid":{"value":1850,"currency":"USD","value_usd":1850},"fwci":0.1935,"has_fulltext":true,"cited_by_count":6,"citation_normalized_percentile":{"value":0.54760654,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"6","issue":null,"first_page":"19739","last_page":"19751"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11344","display_name":"Traffic Prediction and Management Techniques","score":0.9975000023841858,"subfield":{"id":"https://openalex.org/subfields/2215","display_name":"Building and Construction"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11344","display_name":"Traffic Prediction and Management Techniques","score":0.9975000023841858,"subfield":{"id":"https://openalex.org/subfields/2215","display_name":"Building and Construction"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.9833999872207642,"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/T11719","display_name":"Data Quality and Management","score":0.9664000272750854,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8384108543395996},{"id":"https://openalex.org/keywords/standardization","display_name":"Standardization","score":0.5361053943634033},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.5236501693725586},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.4857052266597748},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.47855669260025024},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4559316337108612},{"id":"https://openalex.org/keywords/data-verification","display_name":"Data verification","score":0.4232640862464905},{"id":"https://openalex.org/keywords/real-time-computing","display_name":"Real-time computing","score":0.32053256034851074},{"id":"https://openalex.org/keywords/systems-engineering","display_name":"Systems engineering","score":0.14849483966827393}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8384108543395996},{"id":"https://openalex.org/C188087704","wikidata":"https://www.wikidata.org/wiki/Q369577","display_name":"Standardization","level":2,"score":0.5361053943634033},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.5236501693725586},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4857052266597748},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.47855669260025024},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4559316337108612},{"id":"https://openalex.org/C49895821","wikidata":"https://www.wikidata.org/wiki/Q5227368","display_name":"Data verification","level":2,"score":0.4232640862464905},{"id":"https://openalex.org/C79403827","wikidata":"https://www.wikidata.org/wiki/Q3988","display_name":"Real-time computing","level":1,"score":0.32053256034851074},{"id":"https://openalex.org/C201995342","wikidata":"https://www.wikidata.org/wiki/Q682496","display_name":"Systems engineering","level":1,"score":0.14849483966827393},{"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/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/access.2018.2816001","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2018.2816001","pdf_url":"https://ieeexplore.ieee.org/ielx7/6287639/8274985/08316849.pdf","source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:5da6c77429154e12bc2a0d51f7551f11","is_oa":true,"landing_page_url":"https://doaj.org/article/5da6c77429154e12bc2a0d51f7551f11","pdf_url":null,"source":{"id":"https://openalex.org/S112646816","display_name":"SHILAP Revista de lepidopterolog\u00eda","issn_l":"0300-5267","issn":["0300-5267","2340-4078"],"is_oa":true,"is_in_doaj":true,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"IEEE Access, Vol 6, Pp 19739-19751 (2018)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.1109/access.2018.2816001","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2018.2816001","pdf_url":"https://ieeexplore.ieee.org/ielx7/6287639/8274985/08316849.pdf","source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.6000000238418579}],"awards":[{"id":"https://openalex.org/G1023919524","display_name":null,"funder_award_id":", Grant","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G1231421488","display_name":null,"funder_award_id":"under","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G2010386442","display_name":null,"funder_award_id":"201704","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G2087396116","display_name":null,"funder_award_id":"China","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G3317480652","display_name":null,"funder_award_id":"Science","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G3744313044","display_name":null,"funder_award_id":"Social","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G391238517","display_name":null,"funder_award_id":", and","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G4020255992","display_name":null,"funder_award_id":"Project","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G4043358968","display_name":null,"funder_award_id":"71701121","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G4784243591","display_name":null,"funder_award_id":"17DZ1204203","funder_id":"https://openalex.org/F4320321885","funder_display_name":"Science and Technology Commission of Shanghai Municipality"},{"id":"https://openalex.org/G4894670639","display_name":null,"funder_award_id":"7170112","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G5271169559","display_name":null,"funder_award_id":"16DZ1201704","funder_id":"https://openalex.org/F4320321885","funder_display_name":"Science and Technology Commission of Shanghai Municipality"},{"id":"https://openalex.org/G5939423041","display_name":null,"funder_award_id":"Technology","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G5994120800","display_name":null,"funder_award_id":"Natural","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G6258415954","display_name":null,"funder_award_id":"Chinese","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G6914330941","display_name":null,"funder_award_id":"2014008","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G8904687143","display_name":null,"funder_award_id":"13511504803","funder_id":"https://openalex.org/F4320321885","funder_display_name":"Science and Technology Commission of Shanghai Municipality"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320321885","display_name":"Science and Technology Commission of Shanghai Municipality","ror":"https://ror.org/03kt66j61"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2790373568.pdf","grobid_xml":"https://content.openalex.org/works/W2790373568.grobid-xml"},"referenced_works_count":49,"referenced_works":["https://openalex.org/W108755719","https://openalex.org/W1517818194","https://openalex.org/W1971518725","https://openalex.org/W1976175488","https://openalex.org/W1982212058","https://openalex.org/W1993582687","https://openalex.org/W2000272791","https://openalex.org/W2006312452","https://openalex.org/W2011617234","https://openalex.org/W2014763157","https://openalex.org/W2015789539","https://openalex.org/W2019431987","https://openalex.org/W2020010531","https://openalex.org/W2030364429","https://openalex.org/W2039780220","https://openalex.org/W2075662269","https://openalex.org/W2081050398","https://openalex.org/W2099574652","https://openalex.org/W2115886503","https://openalex.org/W2120865520","https://openalex.org/W2136404694","https://openalex.org/W2138195712","https://openalex.org/W2139452609","https://openalex.org/W2141924506","https://openalex.org/W2161163382","https://openalex.org/W2166006219","https://openalex.org/W2167340337","https://openalex.org/W2184663082","https://openalex.org/W2252784747","https://openalex.org/W2306445825","https://openalex.org/W2338572656","https://openalex.org/W2340788565","https://openalex.org/W2343820316","https://openalex.org/W2411296839","https://openalex.org/W2539362992","https://openalex.org/W2542502579","https://openalex.org/W2549293107","https://openalex.org/W2579443346","https://openalex.org/W2587660050","https://openalex.org/W2592866295","https://openalex.org/W2592878116","https://openalex.org/W2594063224","https://openalex.org/W2597296902","https://openalex.org/W2597904088","https://openalex.org/W2606568264","https://openalex.org/W6655212275","https://openalex.org/W6683921922","https://openalex.org/W6686084051","https://openalex.org/W6692219649"],"related_works":["https://openalex.org/W2378767206","https://openalex.org/W1540871478","https://openalex.org/W328308450","https://openalex.org/W282641168","https://openalex.org/W2376963063","https://openalex.org/W2066396794","https://openalex.org/W2366734808","https://openalex.org/W2002476357","https://openalex.org/W2391444248","https://openalex.org/W2390716080"],"abstract_inverted_index":{"This":[0],"paper":[1],"presents":[2],"an":[3],"extract-transform-load":[4],"(ETL)":[5],"approach":[6,25,170],"based":[7,163],"on":[8,41,164],"multilayer":[9,146],"task":[10,29,38],"execution":[11,31],"for":[12,86,102,109,144,173],"processing":[13],"massive":[14,96,179],"sequential":[15,97,180],"data":[16,72,108,126,181],"collected":[17,113],"from":[18,114],"infrastructure":[19],"operation":[20],"and":[21,34,83,117,141,176,190],"maintenance.":[22],"The":[23,37,168],"proposed":[24,131,169],"consists":[26],"of":[27,58,70,120,129,178,187],"ETL":[28,35,44,77],"partition,":[30],"mode":[32,64],"selection,":[33],"modeling.":[36],"partition":[39],"focuses":[40],"dividing":[42],"the":[43,71,76,87,103,125,130,145,161,165,174,185],"process":[45],"into":[46],"four":[47],"tasks":[48],"to":[49,94,123,138,156],"be":[50],"executed":[51],"in":[52,160,183],"accordance":[53],"with":[54],"different":[55,121],"organizational":[56],"forms":[57],"data.":[59,167],"Sequenced":[60],"or":[61],"non-sequenced":[62],"load":[63],"is":[65,68,93,171],"optional,":[66],"which":[67],"independent":[69],"standardization.":[73],"In":[74,148],"addition,":[75,149],"modeling":[78,85],"phase":[79],"implements":[80],"conceptual,":[81],"logical,":[82],"physical":[84],"multi-dimensional":[88],"model.":[89],"Our":[90],"main":[91],"objective":[92],"integrate":[95],"data,":[98],"enhancing":[99],"decision-making":[100],"performance":[101],"intelligent":[104],"management":[105,175],"platform.":[106],"Traffic":[107],"two":[110],"years":[111],"were":[112],"various":[115],"systems":[116],"acquisition":[118],"tools":[119],"providers":[122],"evaluate":[124],"integration":[127],"capability":[128],"approach.":[132],"Furthermore,":[133],"Kettle":[134],"software":[135],"was":[136,154],"used":[137,155],"perform":[139],"transformation":[140],"job":[142],"modules":[143],"tasks.":[147],"a":[150],"machine":[151],"learning":[152],"algorithm":[153],"generate":[157],"traffic":[158],"warning":[159],"tunnels":[162],"integrated":[166],"promising":[172],"analysis":[177],"generated":[182],"operation,":[184],"maintenance":[186],"transportation":[188],"tunnels,":[189],"effective":[191],"decision-making.":[192]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2018,"cited_by_count":1}],"updated_date":"2026-03-18T14:38:29.013473","created_date":"2025-10-10T00:00:00"}