{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2022,4,2]],"date-time":"2022-04-02T18:54:31Z","timestamp":1648925671642},"reference-count":9,"publisher":"World Scientific Pub Co Pte Lt","issue":"04","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Int. J. Soft. Eng. Knowl. Eng."],"published-print":{"date-parts":[[2011,6]]},"abstract":"<jats:p> Extraction-Transformation-Loading (ETL) tools are pieces of software responsible for the extraction of data from several sources, their cleaning, customization and insertion into Data Warehouses (DWs). Complexity, usability and maintainability are the primary problems concerning ETL processes. To deal with these problems, in this paper we provide a dynamic approach for designing, modeling and realizing ETL processes. We propose a new architecture based on Unified Views Model (UVM) for ETL processes, in which Unified view layer is added between source data level and DWs level. The unified views model serves as the means to conform the structure and semantics of the source data to the ones of the data warehouses, and help designers understand and analyze the meaning, relationships and lineage of information. In order to guarantee the transparency access and the usability, two mapping methods are adopted between Unified view level and source data level as well as between DWs level and Unified view level. Based on this architecture, the method of constructing UVM and ETL operations among three levels is given. Then, we describe how to build the conceptual modeling for ETL processes based on UVM by using an extension of the Unified Modeling Language (UML). Finally, we present an ETL tool based on UVM (UVETL) with the goal of facilitating the design, modeling and realization of ETL processes, and give a case study to exemplify the benefits of our proposal. <\/jats:p>","DOI":"10.1142\/s0218194011005402","type":"journal-article","created":{"date-parts":[[2011,8,29]],"date-time":"2011-08-29T11:18:00Z","timestamp":1314616680000},"page":"543-570","source":"Crossref","is-referenced-by-count":0,"title":["AN APPROACH FOR DESIGNING, MODELING AND REALIZING ETL PROCESSES BASED ON UNIFIED VIEWS MODEL"],"prefix":"10.1142","volume":"21","author":[{"given":"XUDONG","family":"SONG","sequence":"first","affiliation":[{"name":"Computer Science Department, Dalian Jiaotong University, Dalian, Liaoning 116028, China"},{"name":"Computer Science Department, Dalian University of Technology, Dalian, Liaoning 116024, China"}]},{"given":"XIAOBING","family":"LIU","sequence":"additional","affiliation":[{"name":"Computer Integrated Manufacturing Systems Center, Dalian University of Technology, Dalian, Liaoning 116028, China"}]}],"member":"219","published-online":{"date-parts":[[2011,11,21]]},"reference":[{"key":"rf1","volume-title":"Building the Data Warehouse","author":"Inmon W.","year":"2002"},{"key":"rf2","author":"Maz\u00f3n J.-N.","journal-title":"Decision Support Systems"},{"key":"rf3","first-page":"907","volume":"16","author":"Jia Z.","journal-title":"Journal of System Simulation"},{"key":"rf4","doi-asserted-by":"publisher","DOI":"10.1016\/S0306-4379(01)00039-4"},{"key":"rf6","volume-title":"The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling","author":"Kimbal R.","year":"2002"},{"key":"rf16","volume":"22","author":"Rundensteiner E.","journal-title":"Bull. Tech. Committee Data Eng."},{"key":"rf17","volume":"23","author":"Sarawagi S.","journal-title":"Bull. Tech. Committee Data Eng."},{"key":"rf20","doi-asserted-by":"publisher","DOI":"10.1016\/j.is.2004.11.002"},{"key":"rf21","author":"Simitsis A.","journal-title":"Decision Support Systems"}],"container-title":["International Journal of Software Engineering and Knowledge Engineering"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.worldscientific.com\/doi\/pdf\/10.1142\/S0218194011005402","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2019,8,7]],"date-time":"2019-08-07T16:13:48Z","timestamp":1565194428000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.worldscientific.com\/doi\/abs\/10.1142\/S0218194011005402"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2011,6]]},"references-count":9,"journal-issue":{"issue":"04","published-online":{"date-parts":[[2011,11,21]]},"published-print":{"date-parts":[[2011,6]]}},"alternative-id":["10.1142\/S0218194011005402"],"URL":"https:\/\/doi.org\/10.1142\/s0218194011005402","relation":{},"ISSN":["0218-1940","1793-6403"],"issn-type":[{"value":"0218-1940","type":"print"},{"value":"1793-6403","type":"electronic"}],"subject":[],"published":{"date-parts":[[2011,6]]}}}