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 条
  • [21] Extraction, Transformation, and Loading (ETL) module for hotspot spatial data warehouse using geokettle
    Astriani, Winda
    Trisminingsih, Rina
    [J]. 2ND INTERNATIONAL SYMPOSIUM ON LAPAN-IPB SATELLITE (LISAT) FOR FOOD SECURITY AND ENVIRONMENTAL MONITORING, 2016, 33 : 626 - 634
  • [22] Data Validation in ETL Using TALEND
    Sreemathy, J.
    Priyadharshini, S.
    Radha, K.
    Sangeerna, K.
    Nivetha, G.
    [J]. 2019 5TH INTERNATIONAL CONFERENCE ON ADVANCED COMPUTING & COMMUNICATION SYSTEMS (ICACCS), 2019, : 1183 - 1186
  • [23] Towards a UML 2.0 extension for the modeling of security requirements in business processes
    Rodriguez, Alfonso
    Fernandez-Medina, Eduardo
    Piattini, Mario
    [J]. TRUST, PRIVACY, AND SECURITY IN DIGITAL BUSINESS, PROCEEDINGS, 2006, 4083 : 51 - 61
  • [24] Data Integration in ETL Using TALEND
    Sreemathy, J.
    Joseph, Infant, V
    Nisha, S.
    Prabha, Chaaru, I
    Priya, Gokula R. M.
    [J]. 2020 6TH INTERNATIONAL CONFERENCE ON ADVANCED COMPUTING AND COMMUNICATION SYSTEMS (ICACCS), 2020, : 1444 - 1448
  • [25] Using the Unified Modelling Language (UML) to guide the systemic description of biological processes and systems
    Roux-Rouquié, M
    Caritey, N
    Gaubert, L
    Rosenthal-Sabroux, C
    [J]. BIOSYSTEMS, 2004, 75 (1-3) : 3 - 14
  • [26] A UML 2.0/OCL extension for designing secure data warehouses
    Villarroel, R
    Fernández-Medina, E
    Piattini, M
    Trujillo, J
    [J]. JOURNAL OF RESEARCH AND PRACTICE IN INFORMATION TECHNOLOGY, 2006, 38 (01): : 31 - 43
  • [27] A UML 2.0 profile to define security requirements for Data Warehouses
    Trujillo, Juan
    Soler, Emilio
    Fernandez-Medina, Eduardo
    Piattini, Mario
    [J]. COMPUTER STANDARDS & INTERFACES, 2009, 31 (05) : 969 - 983
  • [28] Using UML 2.0 collaborations for compositional service specification
    Sanders, RT
    Castejón, HN
    Kraemer, FA
    Bræk, R
    [J]. MODEL DRIVEN ENGINEERING LANGUAGES AND SYSTEMS, PROCEEDINGS, 2005, 3713 : 460 - 475
  • [29] Using BPMN for ETL Conceptual Modelling: A Case Study
    Oliveira, Bruno
    Oliveira, Oscar
    Belo, Orlando
    [J]. PROCEEDINGS OF THE 10TH INTERNATIONAL CONFERENCE ON DATA SCIENCE, TECHNOLOGY AND APPLICATIONS (DATA), 2021, : 267 - 274
  • [30] Mapping ADLs into UML 2.0 using a meta ADL
    Smeda, Adel
    Oussalah, Mourad
    Khammaci, Tahar
    [J]. 5TH WORKING IEEE/IFIP CONFERENCE ON SOFTWARE ARCHITECTURE, PROCEEDINGS, 2006, : 247 - +
12345