{"id":"https://openalex.org/W2044685095","doi":"https://doi.org/10.1109/dbta.2010.5658928","title":"One CWM-Based Data Transformation Method in ETL Process","display_name":"One CWM-Based Data Transformation Method in ETL Process","publication_year":2010,"publication_date":"2010-11-01","ids":{"openalex":"https://openalex.org/W2044685095","doi":"https://doi.org/10.1109/dbta.2010.5658928","mag":"2044685095"},"language":"en","primary_location":{"id":"doi:10.1109/dbta.2010.5658928","is_oa":false,"landing_page_url":"https://doi.org/10.1109/dbta.2010.5658928","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2010 2nd International Workshop on Database Technology and Applications","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/A5101577598","display_name":"Ying Pei","orcid":"https://orcid.org/0000-0002-3889-4834"},"institutions":[{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"funder","lineage":["https://openalex.org/I19820366"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Ying Pei","raw_affiliation_strings":["School of Information Science and Engineering, Chinese Academy of Sciences, Beijing, China","[Sch. of Inf. Sci. & Eng., Grad. Univ. of Chinese Acad. of Sci., Beijing, China]"],"affiliations":[{"raw_affiliation_string":"School of Information Science and Engineering, Chinese Academy of Sciences, Beijing, China","institution_ids":["https://openalex.org/I19820366"]},{"raw_affiliation_string":"[Sch. of Inf. Sci. & Eng., Grad. Univ. of Chinese Acad. of Sci., Beijing, China]","institution_ids":["https://openalex.org/I19820366"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5016973102","display_name":"Jungang Xu","orcid":"https://orcid.org/0000-0002-3994-1401"},"institutions":[{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"funder","lineage":["https://openalex.org/I19820366"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jungang Xu","raw_affiliation_strings":["School of Information Science and Engineering, Chinese Academy of Sciences, Beijing, China","[Sch. of Inf. Sci. & Eng., Grad. Univ. of Chinese Acad. of Sci., Beijing, China]"],"affiliations":[{"raw_affiliation_string":"School of Information Science and Engineering, Chinese Academy of Sciences, Beijing, China","institution_ids":["https://openalex.org/I19820366"]},{"raw_affiliation_string":"[Sch. of Inf. Sci. & Eng., Grad. Univ. of Chinese Acad. of Sci., Beijing, China]","institution_ids":["https://openalex.org/I19820366"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100367009","display_name":"Qiang Wang","orcid":"https://orcid.org/0000-0002-7078-7545"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Qiang Wang","raw_affiliation_strings":["Beijing China Soft Technology Company Limited, Beijing, China","Beijing Chinsoft Technol. Co., Ltd., Beijing, China"],"affiliations":[{"raw_affiliation_string":"Beijing China Soft Technology Company Limited, Beijing, China","institution_ids":[]},{"raw_affiliation_string":"Beijing Chinsoft Technol. Co., Ltd., Beijing, China","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5101577598"],"corresponding_institution_ids":["https://openalex.org/I19820366"],"apc_list":null,"apc_paid":null,"fwci":0.9021,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.80059883,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":"29","issue":null,"first_page":"1","last_page":"4"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13734","display_name":"Advanced Computational Techniques and Applications","score":0.9595999717712402,"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"}},"topics":[{"id":"https://openalex.org/T13734","display_name":"Advanced Computational Techniques and Applications","score":0.9595999717712402,"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"}},{"id":"https://openalex.org/T14474","display_name":"Industrial Technology and Control Systems","score":0.9139999747276306,"subfield":{"id":"https://openalex.org/subfields/2207","display_name":"Control and Systems Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/metadata","display_name":"Metadata","score":0.9106429815292358},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7469479441642761},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.7336229681968689},{"id":"https://openalex.org/keywords/cwm","display_name":"Cwm","score":0.706519365310669},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.6118533611297607},{"id":"https://openalex.org/keywords/metadata-management","display_name":"Metadata management","score":0.5961289405822754},{"id":"https://openalex.org/keywords/data-transformation","display_name":"Data transformation","score":0.5887036919593811},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5606417059898376},{"id":"https://openalex.org/keywords/data-element","display_name":"Data element","score":0.5217077136039734},{"id":"https://openalex.org/keywords/transformation","display_name":"Transformation (genetics)","score":0.5109359622001648},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.43623149394989014},{"id":"https://openalex.org/keywords/data-extraction","display_name":"Data extraction","score":0.41994017362594604},{"id":"https://openalex.org/keywords/metadata-repository","display_name":"Metadata repository","score":0.41498589515686035},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3896873891353607},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.34229326248168945},{"id":"https://openalex.org/keywords/rdf","display_name":"RDF","score":0.3395792841911316},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.16917425394058228},{"id":"https://openalex.org/keywords/semantic-web","display_name":"Semantic Web","score":0.09024947881698608},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.08558326959609985},{"id":"https://openalex.org/keywords/sparql","display_name":"SPARQL","score":0.07132697105407715}],"concepts":[{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.9106429815292358},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7469479441642761},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7336229681968689},{"id":"https://openalex.org/C157595922","wikidata":"https://www.wikidata.org/wiki/Q50745537","display_name":"Cwm","level":5,"score":0.706519365310669},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.6118533611297607},{"id":"https://openalex.org/C2779489174","wikidata":"https://www.wikidata.org/wiki/Q6822246","display_name":"Metadata management","level":3,"score":0.5961289405822754},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.5887036919593811},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5606417059898376},{"id":"https://openalex.org/C30872290","wikidata":"https://www.wikidata.org/wiki/Q1172389","display_name":"Data element","level":3,"score":0.5217077136039734},{"id":"https://openalex.org/C204241405","wikidata":"https://www.wikidata.org/wiki/Q461499","display_name":"Transformation (genetics)","level":3,"score":0.5109359622001648},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.43623149394989014},{"id":"https://openalex.org/C2777466982","wikidata":"https://www.wikidata.org/wiki/Q5227287","display_name":"Data extraction","level":3,"score":0.41994017362594604},{"id":"https://openalex.org/C153048206","wikidata":"https://www.wikidata.org/wiki/Q3454922","display_name":"Metadata repository","level":3,"score":0.41498589515686035},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3896873891353607},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.34229326248168945},{"id":"https://openalex.org/C147497476","wikidata":"https://www.wikidata.org/wiki/Q54872","display_name":"RDF","level":3,"score":0.3395792841911316},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.16917425394058228},{"id":"https://openalex.org/C2129575","wikidata":"https://www.wikidata.org/wiki/Q54837","display_name":"Semantic Web","level":2,"score":0.09024947881698608},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.08558326959609985},{"id":"https://openalex.org/C41009113","wikidata":"https://www.wikidata.org/wiki/Q54871","display_name":"SPARQL","level":4,"score":0.07132697105407715},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C2779473830","wikidata":"https://www.wikidata.org/wiki/Q1540899","display_name":"MEDLINE","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/dbta.2010.5658928","is_oa":false,"landing_page_url":"https://doi.org/10.1109/dbta.2010.5658928","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2010 2nd International Workshop on Database Technology and Applications","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5799999833106995,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W1540445047","https://openalex.org/W1971518725","https://openalex.org/W2108971776","https://openalex.org/W2366536353","https://openalex.org/W2374162572"],"related_works":["https://openalex.org/W3084772717","https://openalex.org/W2365178252","https://openalex.org/W1512114296","https://openalex.org/W2389651964","https://openalex.org/W2374379029","https://openalex.org/W2376038160","https://openalex.org/W2907247951","https://openalex.org/W1577283115","https://openalex.org/W2751232557","https://openalex.org/W2186093090"],"abstract_inverted_index":{"Metadata":[0],"is":[1,12,32,39,60,75,79],"the":[2,6,64,91],"command":[3],"center":[4],"in":[5,48,87],"process":[7,93],"of":[8,68,96],"data":[9,16,22,27,53,69,72],"warehousing,and":[10],"which":[11,38,78],"very":[13],"helpful":[14],"to":[15,62,81,84,99],"ETL":[17,70,88,101],"(Extraction,":[18],"Transformation":[19],"and":[20,26,44,55,66,77,94],"Loading),":[21],"storage":[23],"management,data":[24],"analysis":[25],"mining.CWM":[28],"(Common":[29],"Warehouse":[30],"Meta-model)":[31],"an":[33],"open":[34],"industry":[35],"metadata":[36,86],"standard,and":[37],"widely":[40],"used":[41,80],"currently,public":[42],"meta-models":[43],"its":[45],"rules":[46],"defined":[47],"CWM":[49,98],"can":[50],"properly":[51],"support":[52,63],"transformation":[54,73],"cleansing.One":[56],"metadata-driven":[57],"development":[58,67,92],"approach":[59],"proposed":[61],"design":[65],"process.One":[71],"module":[74],"realized,":[76],"specify":[82],"how":[83],"use":[85],"process.":[89],"Finally,":[90],"steps":[95],"using":[97],"build":[100],"tool":[102],"are":[103],"given.":[104]},"counts_by_year":[{"year":2015,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}