Open Source Data Warehouse

ISBN-13: 9783846532041 / Angielski / Miękka / 56 str.

Ahsan Habib; Md. Masum Billah

Opis

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.

O autorze

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.