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. - Tapa blanda

Habib, Ahsan; Billah, Md. Masum

 
9783846532041: 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.
Tapa blanda
ISBN 10: 3846532045 ISBN 13: 9783846532041
Editorial: LAP LAMBERT Academic Publishing, 2011

Sinopsis

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.

"Sinopsis" puede pertenecer a otra edición de este libro.

Reseña del editor

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.

Biografía del autor

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.

"Sobre este título" puede pertenecer a otra edición de este libro.

Editorial
LAP LAMBERT Academic Publishing
Año de publicación
2011
Idioma
Inglés
ISBN 10 
3846532045
ISBN 13 
9783846532041
Encuadernación
Tapa blanda
Número de páginas
56
Contacto del fabricante
no disponible
Persona responsable
no disponible