Ahsan Habib, Md. Masum Billah

Open Source Data Warehouse

Design a back-end tool using open-source technology for loading data into data warehouse from a number of data sources.

• Broschiertes Buch

Produktbeschreibung

To fulfill the objectives of data warehouse, a number of front-end tools and back-end tools are required. Front-end tools include analysis, OLAP queries, reporting, data mining etc, while back-end tools include data cleaning, data loading and refreshing etc. Vendor specific Structured Query Language (SQL) engines like Oracle, MS SQL Server, IBM DB2 provide data warehousing facility. However, small and medium enterprise cannot take the advantages of the vendor provided DBMS due to its high Total Cost of Ownership (TCO). As a result open-source SQL engines are becoming popular nowadays. But open-source SQL engines have still no generalized data warehousing facility. In this book it is shown that how to develop a back end tool for loading data into data warehouse from many sources using open source Structured Query Language (SQL) engine MySQL. In this book it is also shown that how to test data loading into data warehouse using the developed back-end tool where data sources are multiple operational MySQL data-bases connected through computer network or backup databases stored in non-volatile media like CD, VCD, pen drive etc.

Produktdetails

• Verlag: LAP Lambert Academic Publishing
• Aufl.
• Seitenzahl: 56
• Erscheinungstermin: 18. Oktober 2011
• Englisch
• Abmessung: 220mm x 150mm x 4mm
• Gewicht: 102g
• ISBN-13: 9783846532041
• ISBN-10: 3846532045
• Artikelnr.: 34430162

Autorenporträt

Mr. Ahsan Habib, BSc in CSE, MSc in MIS, having 12 publications and working as Assistant Professor of Metropolitan University, Bangladesh,is interested in E-Governance and DBMS. Mr. Md. Masum Billah, BSc in CSE, MSc in ICT, having 3 publications and working as Senior System Analyst of Bangladesh Public Service Commission, is interested in DBMS.