期刊名称：DESIDOC Journal of Library & Information Technology
电子版ISSN：0976-4658
出版年度：2006
卷号：26
期号：5
语种：English
出版社：DESIDOC, Ministry of Defence, India
摘要：The topic of data warehousing encompasses architectures, algorithms, and tools for bringing together the selected data from multiple databases or other information sources into a single repository called data warehouse. Extraction-transformationloading tools are pieces of software responsible for the extraction of data from several sources, their cleaning, customisation, and insertion into a data warehouse. The paper proposes an object-oriented approach to accomplish the data extraction modelling of extraction-transformation-loading process. The data extraction scenario consists of data staging area, heterogeneous information sources, wrappers, monitors, integrator, and source identifier. All the afore mentioned entities have been modelled using Unified Modelling Language 2.0. Banking system has been used as an application to illustrate the modelling. http://dx.doi.org/10.14429/dbit.26.5.36 90
关键词：Extraction transformation loading (ETL), Data extraction, Distributed systems, Heterogeneous data, UML, Banking system
