Please use this identifier to cite or link to this item:
Title: Improved extraction mechanism in ETL process for building of a data warehouse
Researcher: Patil, Preeti S
Guide(s): Rao, Srikantha
Keywords: Computer Sciences
Change Data Capture
Data warehouse
Extraction Transformation and Loading Process
Upload Date: 22-Feb-2013
University: Narsee Monjee Institute of Management Studies
Completed Date: n.d.
Abstract: Today the Data warehouse plays an important role in decision making, data analysis, and strategic information and so on. Extraction Transformation and Loading (ETL) process is used very popularly in building up of the data warehouse. In todays competitive Business world Mergers and Acquisitions are very common. It requires Extraction, Transformation and Loading of a huge amount of Organizational Data movement. This work proposed with respect to the Time and Space domains by the improvement in the extraction speed and file size. The existing approach is modified to apply both the standard methods of extraction, the Full Extraction and Incremental Extraction Procedures in the ETL Process. Though flat files have been widely used for simplification of the database file and existing systems does not provide any security for the same. In this thesis we are proposing the various security methods to apply over a flat file during the extraction process in ETL. These security methods can be highly recommended for very high sensitive data. Applications of security measures presented in this thesis are effective to reduce the possibility of the data leakage risk. To further reduce the size of the file the use of the delimited flat files rather than fixed length flat files converted from database files is suggested. Consequently results with reducing the extraction time of the data file. Such conversion proposal would certainly improve the speed of the extraction as presented in this thesis work. This work has provided preparatory inputs for the building process of Data warehouse and how ETL contributes to the major role in the building process. As these flat files are created from the database files the problems like redundancy, consistency, and more searching time does not occur and we can make use of the advantages of flat file during extraction process. This work provides security to the flat files before extraction and then it is extracted from the source to the destination system.
Pagination: 136p.
Appears in Departments:Department of Computer Engineering

Files in This Item:
File Description SizeFormat 
01_title.pdfAttached File201.79 kBAdobe PDFView/Open
02_certificate & declaration.pdf350.73 kBAdobe PDFView/Open
03_acknowledgement.pdf300.98 kBAdobe PDFView/Open
04_abstract.pdf234.62 kBAdobe PDFView/Open
05_list of figures & tables.pdf292.96 kBAdobe PDFView/Open
06_contents.pdf491.33 kBAdobe PDFView/Open
07_chapter 1.pdf386.69 kBAdobe PDFView/Open
08_chapter 2.pdf352.52 kBAdobe PDFView/Open
09_chapter 3.pdf1.87 MBAdobe PDFView/Open
10_chapter 4.pdf854.72 kBAdobe PDFView/Open
11_chapter 5.pdf2.26 MBAdobe PDFView/Open
12_chapter 6.pdf581.68 kBAdobe PDFView/Open
13_appendix.pdf352.63 kBAdobe PDFView/Open
14_references & list of publications.pdf462 kBAdobe PDFView/Open

Items in Shodhganga are protected by copyright, with all rights reserved, unless otherwise indicated.

Altmetric Badge: