Data warehousing with MySQL, a free and popular database, has never been made easier with this step-by-step tutorial on building dimensional data warehouses. Topics include star-schema modeling, populating (Extract, Transform, and Load: ETL), testing, and dimensional querying. It comes complete with a hands-on case-scaled-down from a real project. Computer programmers who need to build a data warehouse will find relevant examples and information written in a thorough, easy-to-follow style.
About the Author
Djoni Darmawikarta built his career at IBM and currently works for a Canadian insurance company as a technical specialist in its data warehousing/business intelligence team. He lives in Toronto, Ontario.
2007 by Brainy Software Corp.
First Edition: May 2007
All rights reserved. No part of this book may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage and retrieval system, without written permission from the publisher, except for the inclusion of brief quotations in a review.
Book and Cover Designer: Mona Setiadi
Technical Reviewer: Paul Deck
Indexer: Chris Mayle
Warning and Disclaimer
Every effort has been made to make this book as accurate as possible. The author and the publisher shall have
Welcome to Dimensional Data Warehousing with MySQL: A Tutorial.
Data warehousing enables unified information delivery by collecting data from various operational and administrative information systems already in operation and possibly from external data sources. The data from these sources are integrated, cleaned and transformed, and stored for easier access than if the data has to be read directly from the sources.
The data structure in a data warehouse allows you to store current and historical data. Current information is needed for operational activities, mostly for producing regular hardcopy or online
Integrating data from multiple sources, storing and
Dimensional Data Warehousing with MySQL is a practical book. You will use MySQL, but this book is not about MySQL. The book does not discuss hardware infrastructural aspects either.
The focus of this book is on data warehouse design and development techniques. The book however is not about techniques on managing development projects, development methodologies, or leading developments.
The book uses an example data warehouse development to show the implementation of the techniques. The data model and the SQL scripts are included and can be
In addition, this book does not
The concepts of data warehousing