Data Warehousing Fundamentals: A Comprehensive Guide for IT ProfessionalsGeared to IT professionals eager to get into the all-important field of data warehousing, this book explores all topics needed by those who design and implement data warehouses. Readers will learn about planning requirements, architecture, infrastructure, data preparation, information delivery, implementation, and maintenance. They'll also find a wealth of industry examples garnered from the author's 25 years of experience in designing and implementing databases and data warehouse applications for major corporations. Market: IT Professionals, Consultants. |
What people are saying - Write a review
User ratings
| 5 stars |
| ||
| 4 stars |
| ||
| 3 stars |
| ||
| 2 stars |
| ||
| 1 star |
|
User Review - Flag as inappropriate
GREAT
User Review - Flag as inappropriate
All 7 reviews »Its is great work
thank you very much
Contents
| 1 | |
Part 2 PLANNING AND REQUIREMENTS | 63 |
Part 3 ARCHITECTURE AND INFRASTRUCTURE | 127 |
Part 4 DATA DESIGN AND DATA PREPARATION | 203 |
Part 5 INFORMATION ACCESS AND DELIVERY | 315 |
Part 6 IMPLEMENTATION AND MAINTENANCE | 429 |
Appendix A Project Life Cycle Steps and Checklists | 493 |
Appendix B Critical Factors for Success | 497 |
Appendix C Guidelines for Evaluating Vendor Solutions | 499 |
| 501 | |
Glossary | 503 |
| 511 | |
Other editions - View all
Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals Paulraj Ponniah No preview available - 2004 |
Common terms and phrases
aggregate algorithms analysis applications architectural components attributes business dimensions capture changes chapter columns complex create data cleansing data elements data extraction data loading data marts data mining data model data quality data sources data staging data storage data structures data transformation data warehouse environment data warehouse project data warehousing database DBMS deployment dimension table dimensional model end-users enterprise example fact table Figure files functions hardware incremental loads integrated interface marketing MDDBs methods metrics MOLAP multidimensional OLAP system OLTP online analytical processing operational systems options package diagrams performance pilot platform predefined primary key product dimension programs project team queries and reports records relational requirements definition ROLAP selection server source data source systems specific staging area standards STAR schema summary techniques tion transaction types users values vendors ware Web-enabled data warehouse
Popular passages
Page 18 - Inmon identified four characteristics of a data warehouse, which are represented in his formal definition: "... a data warehouse is a subject oriented, integrated, non-volatile and time variant collection of data in support of management's decisions.
Page 501 - Kimball, Ralph, and Richard Merz. The Data Webhouse Toolkit: Building the WebEnabled Data Warehouse. New York: John Wiley & Sons, 2000.
Page 501 - Managing the Data Warehouse: Practical Techniques for Monitoring Operations and Performances, Administering Data and Tools, Managing Change and Growth, New York: Wiley, 1997.
Page 5 - Web-enabled analysis tools enables merchants to gain insights into their customer base, manage inventories more tightly, and keep the right products in front of the right people at the right place at the right time.
Bibliographic information
| Title | Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals |
| Author | Paulraj Ponniah |
| Publisher | John Wiley & Sons, 2004 |
| ISBN | 0471463892, 9780471463894 |
| Length | 544 pages |
| Subjects | › › Computers / Databases / Data Warehousing Computers / Information Technology |
| Export Citation | BiBTeX EndNote RefMan |