Enhancement approach for data warehouse staging area / (Record no. 52804)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 02652cam a2200337 a 4500 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | EG-GiCUC |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20250223031321.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 151018s2014 ua dh f m 000 0 eng d |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | EG-GiCUC |
| Language of cataloging | eng |
| Transcribing agency | EG-GiCUC |
| 041 0# - LANGUAGE CODE | |
| Language code of text/sound track or separate title | eng |
| 049 ## - LOCAL HOLDINGS (OCLC) | |
| Holding library | Deposite |
| 097 ## - Thesis Degree | |
| Thesis Level | M.Sc |
| 099 ## - LOCAL FREE-TEXT CALL NUMBER (OCLC) | |
| Classification number | Cai01.20.04.M.Sc.2014.Ma.E |
| 100 0# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Mahmoud Cherif Elwessimy |
| 245 10 - TITLE STATEMENT | |
| Title | Enhancement approach for data warehouse staging area / |
| Statement of responsibility, etc. | Mahmoud Cherif Elwessimy ; Supervised Osman Hegazy , Hoda Mokhtar Omar Mokhtar |
| 246 15 - VARYING FORM OF TITLE | |
| Title proper/short title | تحسين المرحلة الأنتقالية ما قبل مستودع البيانات |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. | |
| Place of publication, distribution, etc. | Cairo : |
| Name of publisher, distributor, etc. | Mahmoud Cherif Elwessimy , |
| Date of publication, distribution, etc. | 2014 |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 79 Leaves : |
| Other physical details | charts , facsimiles ; |
| Dimensions | 30cm |
| 502 ## - DISSERTATION NOTE | |
| Dissertation note | Thesis (M.Sc.) - Cairo University - Faculty of Computers and Information - Department of Information System |
| 520 ## - SUMMARY, ETC. | |
| Summary, etc. | The efficiency of data warehouse staging area could almost always be better. However, in any domain like the sales domain that we have chosen for evaluation this can be a difficult question to answer. Therefore, we directed our investigation towards two main areas. In the beginning, we improved the quality of sales data throughout the extraction and transformation stages of the raw data acquired from the operational sources and evaluate the differences after applying predefined measures and sales ontologies. Afterwards, we present an evaluation of different four techniques and their impact on data transfer to its final destination. Within this thesis we start by giving an introduction regarding data warehouse. Afterwards, we explain what Staging Area is and how it is extremely important for a well-built Data Warehouse. In the attempt to enhance the Staging Area, lots of researches have been conducted. We present a literature of different ETL ontologies researches and their impact on the Staging Area. Afterwards, we refer to the chosen sales domain for applying the enhancement approach. We then introduce our approach to enhance the ETL phases. First, we applied predefined industrial ontologies besides running a semi-automated program on the extract phase then on transformation phase. After finishing both phases we noticed that the data quality of the tables have improved like with address table |
| 530 ## - ADDITIONAL PHYSICAL FORM AVAILABLE NOTE | |
| Additional physical form available note | Issued also as CD |
| 653 #4 - INDEX TERM--UNCONTROLLED | |
| Uncontrolled term | Data Loading schedules |
| 653 #4 - INDEX TERM--UNCONTROLLED | |
| Uncontrolled term | Data Warehouse |
| 653 #4 - INDEX TERM--UNCONTROLLED | |
| Uncontrolled term | ETL |
| 700 0# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Hoda Mokhtar Omar Mokhtar , |
| Relator term | |
| 700 0# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Osman Hegazy , |
| Relator term | |
| 856 ## - ELECTRONIC LOCATION AND ACCESS | |
| Uniform Resource Identifier | <a href="http://172.23.153.220/th.pdf">http://172.23.153.220/th.pdf</a> |
| 905 ## - LOCAL DATA ELEMENT E, LDE (RLIN) | |
| Cataloger | Nazla |
| Reviser | Revisor |
| 905 ## - LOCAL DATA ELEMENT E, LDE (RLIN) | |
| Cataloger | Soheir |
| Reviser | Cataloger |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Source of classification or shelving scheme | Dewey Decimal Classification |
| Koha item type | Thesis |
| Source of classification or shelving scheme | Not for loan | Home library | Current library | Date acquired | Full call number | Barcode | Date last seen | Koha item type | Copy number |
|---|---|---|---|---|---|---|---|---|---|
| Dewey Decimal Classification | المكتبة المركزبة الجديدة - جامعة القاهرة | قاعة الرسائل الجامعية - الدور الاول | 11.02.2024 | Cai01.20.04.M.Sc.2014.Ma.E | 01010110066510000 | 22.09.2023 | Thesis | ||
| Dewey Decimal Classification | المكتبة المركزبة الجديدة - جامعة القاهرة | مخـــزن الرســائل الجـــامعية - البدروم | 11.02.2024 | Cai01.20.04.M.Sc.2014.Ma.E | 01020110066510000 | 22.09.2023 | CD - Rom | 66510.CD |