{"id":"https://openalex.org/W3093547726","doi":"https://doi.org/10.1145/3424978.3425101","title":"Design of ETL Tool for Structured Data Based on Data Warehouse","display_name":"Design of ETL Tool for Structured Data Based on Data Warehouse","publication_year":2020,"publication_date":"2020-10-15","ids":{"openalex":"https://openalex.org/W3093547726","doi":"https://doi.org/10.1145/3424978.3425101","mag":"3093547726"},"language":"en","primary_location":{"id":"doi:10.1145/3424978.3425101","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3424978.3425101","pdf_url":null,"source":{"id":"https://openalex.org/S4306523839","display_name":"Proceedings of the 4th International Conference on Computer Science and Application Engineering","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 4th International Conference on Computer Science and Application Engineering","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":null,"display_name":"Jingting Wang","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Jingting Wang","raw_affiliation_strings":["College of Engineering and Technology, Xi'an Fanyi University, Xi'an, Shaanxi, China"],"affiliations":[{"raw_affiliation_string":"College of Engineering and Technology, Xi'an Fanyi University, Xi'an, Shaanxi, China","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5068795685","display_name":"Bao Liu","orcid":"https://orcid.org/0000-0002-9335-5411"},"institutions":[{"id":"https://openalex.org/I110440473","display_name":"Xi'an University of Science and Technology","ror":"https://ror.org/046fkpt18","country_code":"CN","type":"education","lineage":["https://openalex.org/I110440473"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Bao Liu","raw_affiliation_strings":["College of Electronical and Control Engineering, Xi'an University of Science and Technology, Xi'an, Shaanxi, China"],"affiliations":[{"raw_affiliation_string":"College of Electronical and Control Engineering, Xi'an University of Science and Technology, Xi'an, Shaanxi, China","institution_ids":["https://openalex.org/I110440473"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.3041,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.51265823,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":"39","issue":null,"first_page":"1","last_page":"5"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9435999989509583,"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"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9435999989509583,"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/data-warehouse","display_name":"Data warehouse","score":0.911349892616272},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6861324310302734},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.600144624710083},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.4309086501598358}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.911349892616272},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6861324310302734},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.600144624710083},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.4309086501598358}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3424978.3425101","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3424978.3425101","pdf_url":null,"source":{"id":"https://openalex.org/S4306523839","display_name":"Proceedings of the 4th International Conference on Computer Science and Application Engineering","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 4th International Conference on Computer Science and Application Engineering","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.550000011920929}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":2,"referenced_works":["https://openalex.org/W2360971938","https://openalex.org/W2368263657"],"related_works":["https://openalex.org/W1799555191","https://openalex.org/W2751504412","https://openalex.org/W2118336583","https://openalex.org/W2404676707","https://openalex.org/W1497149511","https://openalex.org/W2381748642","https://openalex.org/W2369971203","https://openalex.org/W2363407304","https://openalex.org/W2072764742","https://openalex.org/W2337113826"],"abstract_inverted_index":{"This":[0],"paper":[1],"takes":[2],"the":[3,17,20,31,35,45,53,57,65,75,83,86,94,103,106,112,117,121],"current":[4,36],"business":[5],"system":[6,66],"of":[7,48,85,105,120],"a":[8],"mobile":[9],"communication-equipment-chain":[10],"sales-service-company":[11],"as":[12],"an":[13,89],"example,":[14],"and":[15,74,78],"analyzes":[16],"problem":[18],"that":[19],"data":[21,24,32,58,96,108],"from":[22],"multiple":[23],"sources":[25],"cannot":[26],"directly":[27],"be":[28],"loaded":[29],"into":[30],"warehouse":[33],"by":[34,111],"commercial":[37,113],"ETL":[38,49,62,72,87,114,122],"(Extraction-Transformation-Loading,":[39],"ETL)":[40],"tool.":[41,63],"Firstly,":[42],"it":[43],"designs":[44],"logical":[46],"model":[47],"tool":[50,123],"based":[51],"on":[52,71],"metadata,":[54],"then":[55],"customizes":[56],"cleaning":[59,97,109],"method":[60],"in":[61],"Finally,":[64],"experiments":[67],"are":[68,80],"carried":[69],"out":[70],"tool,":[73,88,115],"experimental":[76],"results":[77],"analysis":[79],"given.":[81],"Through":[82],"development":[84],"interface":[90],"is":[91,124],"provided":[92],"for":[93,102],"user-defined":[95],"function,":[98],"which":[99],"makes":[100],"up":[101],"shortage":[104],"custom":[107],"function":[110],"thereby":[116],"use":[118],"efficiency":[119],"improved.":[125]},"counts_by_year":[{"year":2024,"cited_by_count":3},{"year":2022,"cited_by_count":1}],"updated_date":"2026-04-16T08:26:57.006410","created_date":"2025-10-10T00:00:00"}