ارسل ملاحظاتك

ارسل ملاحظاتك لنا







A Proposed Model For Data Warehouse ETL Processes

المصدر: مجلة جامعة الملك سعود - علوم الحاسب والمعلومات
الناشر: جامعة الملك سعود
المؤلف الرئيسي: El-Sappagh, Shaker H. Ali (Author)
مؤلفين آخرين: Hendawi, Abdeltawab M. Ahmed (Co-Author) , El Bastawissy, Ali Hamed (Co-Author)
المجلد/العدد: مج23, ع2
محكمة: نعم
الدولة: السعودية
التاريخ الميلادي: 2011
الصفحات: 91 - 104
DOI: 10.33948/0584-023-002-005
ISSN: 1319-1578
رقم MD: 971979
نوع المحتوى: بحوث ومقالات
اللغة: الإنجليزية
قواعد المعلومات: science
مواضيع:
كلمات المؤلف المفتاحية:
Data Warehouse | ETL Processes | Database | Data Mart | OLAP | Conceptual Modeling
رابط المحتوى:
صورة الغلاف QR قانون
حفظ في:
المستخلص: Extraction–transformation–loading (ETL) tools are pieces of software responsible for the extraction of data from several sources, its cleansing, customization, reformatting, integration, and insertion into a data warehouse. Building the ETL process is potentially one of the biggest tasks of building a warehouse; it is complex, time consuming, and consume most of data warehouse project’s implementation efforts, costs, and resources. Building a data warehouse requires focusing closely on understanding three main areas: the source area, the destination area, and the mapping area (ETL processes). The source area has standard models such as entity relationship diagram, and the destination area has standard models such as star schema, but the mapping area has not a standard model till now. In spite of the importance of ETL processes, little research has been done in this area due to its complexity. There is a clear lack of a standard model that can be used to represent the ETL scenarios. In this paper we will try to navigate through the efforts done to conceptualize the ETL processes. Research in the field of modeling ETL processes can be categorized into three main approaches: Modeling based on mapping expressions and guidelines, modeling based on conceptual constructs, and modeling based on UML environment. These projects try to represent the main mapping activities at the conceptual level. Due to the variation and differences between the proposed solutions for the conceptual design of ETL processes and due to their limitations, this paper also will propose a model for conceptual design of ETL processes. The proposed model is built upon the enhancement of the models in the previous models to support some missing mapping features.

ISSN: 1319-1578

عناصر مشابهة