Modelling of Data Extraction in ETL Processes Using UML 2.0

被引：0
|
作者：
Mrunalini, M. [1 ]
Kumar, T. V. Suresh [1 ]
Geetha, D. Evangelin [1 ]
Rajanikanth, K. [1 ]
机构：
[1] MS Ramaiah Inst Technol, Bangalore 560054, Karnataka, India
来源：
DESIDOC JOURNAL OF LIBRARY & INFORMATION TECHNOLOGY | 2006年 / 26卷 / 05期
关键词：
ETL; data extraction; distributed systems; heterogeneous data; UML; banking system; extraction-transformation-loading;
D O I：
10.14429/dbit.26.3.3690
中图分类号：
G25 [图书馆学、图书馆事业]; G35 [情报学、情报工作];
学科分类号：
1205 ; 120501 ;
摘要：
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-transformation-loading 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.
引用
收藏
页码：3 / 9
页数：7
相关论文
共 50 条
  • [1] Modelling ETL Processes of Data Warehouses with UML Activity Diagrams
    Munoz, Lilia
    Mazon, Jose-Norberto
    Pardillo, Jesus
    Trujillo, Juan
    [J]. ON THE MOVE TO MEANINGFUL INTERNET SYSTEMS: OTM 2008 WORKSHOPS, 2008, 5333 : 44 - +
  • [2] A UML based approach for modeling ETL processes in data warehouses
    Trujillo, J
    Luján-Mora, S
    [J]. CONCEPTUAL MODELING - ER 2003, PROCEEDINGS, 2003, 2813 : 307 - 320
  • [3] Simulating Secure Data Extraction in Extraction Transformation Loading (ETL) Processes
    Mrunalini, M.
    Kumar, T. V. Suresh
    Kanth, K. Rajani
    [J]. 2009 THIRD UKSIM EUROPEAN SYMPOSIUM ON COMPUTER MODELING AND SIMULATION (EMS 2009), 2009, : 142 - +
  • [4] A family of experiments to validate measures for UML activity diagrams of ETL processes in data warehouses
    Munoz, Lilia
    Mazon, Jose-Norberto
    Trujillo, Juan
    [J]. INFORMATION AND SOFTWARE TECHNOLOGY, 2010, 52 (11) : 1188 - 1203
  • [5] An approach to conceptual modelling of ETL processes
    Dupor, Sasa
    Jovanovic, Vladan
    [J]. 2014 37TH INTERNATIONAL CONVENTION ON INFORMATION AND COMMUNICATION TECHNOLOGY, ELECTRONICS AND MICROELECTRONICS (MIPRO), 2014, : 1485 - 1490
  • [6] A Method for Modelling and Organazing ETL Processes
    Kabiri, Ahmed
    Chiadmi, Dalila
    [J]. 2012 SECOND INTERNATIONAL CONFERENCE ON INNOVATIVE COMPUTING TECHNOLOGY (INTECH), 2012, : 138 - 143
  • [7] Optimizing ETL processes in data warehouses
    Simitsis, A
    Vassiliadis, P
    Sellis, T
    [J]. ICDE 2005: 21ST INTERNATIONAL CONFERENCE ON DATA ENGINEERING, PROCEEDINGS, 2005, : 564 - 575
  • [8] Modeling and Optimization of Extraction-Transformation-Loading (ETL) processes in Data Warehouse: An Overview
    Anand, Nitin
    Kumar, Manoj
    [J]. 2013 FOURTH INTERNATIONAL CONFERENCE ON COMPUTING, COMMUNICATIONS AND NETWORKING TECHNOLOGIES (ICCCNT), 2013,
  • [9] MODELLING PROCUREMENT PROCESSES BY UML DIAGRAMS
    Stransky, Martin
    [J]. 20TH INTERNATIONAL SCIENTIFIC CONFERENCE ENGINEERING FOR RURAL DEVELOPMENT, 2021, : 437 - 443
  • [10] ETL Standard Processes Modelling A Novel BPMN Approach
    Oliveira, Bruno
    Belo, Orlando
    [J]. ICEIS: PROCEEDINGS OF THE 15TH INTERNATIONAL CONFERENCE ON ENTERPRISE INFORMATION SYSTEMS, VOL 1, 2013, : 120 - 127
12345