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

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







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 قانون
حفظ في:
LEADER 02885nam a22002537a 4500
001 1715011
024 |3 10.33948/0584-023-002-005 
041 |a eng 
044 |b السعودية 
100 |9 523855  |a El-Sappagh, Shaker H. Ali  |e Author 
245 |a A Proposed Model For Data Warehouse ETL Processes 
260 |b جامعة الملك سعود  |c 2011 
300 |a 91 - 104 
336 |a بحوث ومقالات  |b Article 
520 |b  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. 
653 |a علوم الحاسوب  |a قواعد البيانات  |a نظم المعلومات 
692 |b Data Warehouse  |b ETL Processes  |b Database  |b Data Mart  |b OLAP  |b Conceptual Modeling 
700 |9 523856  |a Hendawi, Abdeltawab M. Ahmed  |e Co-Author 
700 |9 523857  |a El Bastawissy, Ali Hamed  |e Co-Author 
773 |c 005  |e Journal of King Saud University (Computer and Information Sciences)  |f Maǧalaẗ ǧamʼaẗ al-malīk Saud : ùlm al-ḥasib wa al-maʼlumat  |l 002  |m مج23, ع2  |o 0584  |s مجلة جامعة الملك سعود - علوم الحاسب والمعلومات  |v 023  |x 1319-1578 
856 |u 0584-023-002-005.pdf 
930 |d y  |p y 
995 |a science 
999 |c 971979  |d 971979 

عناصر مشابهة