Data warehouses are fundamentally different from OLTP (online transaction processing) systems, which are more familiar to developers and database administrators. This book gives you the concepts for understanding, designing, and delivering data warehouses as well as the technical tools for building them with MySQL.MySQL is ready to take a serious role in the data warehouse. With its speedy execution, extensive set of built-in functions, and solid data import capabilities, it has all the relevant features of competing proprietary tools such as Microsoft SQL Server and Oracle.
Data warehouses are fundamentally different from OLTP (online transaction processing) systems, which are more familiar to developers and database administrators. This book gives you the concepts for understanding, designing, and delivering data warehouses as well as the technical tools for building them with MySQL.MySQL is ready to take a serious role in the data warehouse. With its speedy execution, extensive set of built-in functions, and solid data import capabilities, it has all the relevant features of competing proprietary tools such as Microsoft SQL Server and Oracle.
Auflage
Sprache
Verlagsort
Zielgruppe
Für Beruf und Forschung
Popular/general
Maße
Höhe: 230 mm
Breite: 180 mm
Dicke: 13 mm
ISBN-13
978-1-59059-393-6 (9781590593936)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
John Paul Ashenfelter is president and CTO of TransitionPoint.com, a consulting firm dedicated to technology strategy and software development and focused on delivering robust web applications quickly and reliably. John Paul founded and maintains the webDatabase.org Web site. He is also the author of Choosing a Database for Your Web Site and the coauthor of ColdFusion 4 for Dummies.
An Introduction to MySQL and Data Warehouses * Data Warehousing in a Nutshell * MySQL Basics for Data Warehousing * An Order (Sales) Data Warehouse * Extraction: Getting Data Into MySQL * Transformation: OLTP to DW * Loading: Delivering the Datawarehouse * Complementary Open Source Tools.
