Data Warehouse Structure Design and Implementation: Building the Pyramid of Information Systems

Author: Chi Tai Wei
Publisher:
Publish Date: 2005-11-01
Features: This book helps businesses solve the following problems: How to establish a data warehouse on existing databases during the process of establishing or developing their own information systems? How to build a data warehouse? How to make the data warehouse truly become a support system for strategic decision-making? Based on the author's practical experience in the implementation of data warehouse technology, this book provides an in-depth analysis of the characteristics and strategic applications in each stage of data warehouse development, as well as its role and significance in management information systems. The book primarily describes the stages of the data warehouse design and development lifecycle and their corresponding technical structural frameworks. Additionally, it offers successful engineering development cases such as the Check Credit Approval Network System, single-source production data from a certain aircraft manufacturing company, and the Automobile Sales Management Network System.
At the same time, the book introduces the process and strategies of data warehouse development, mainly including: leapfrog (frog) development, the multi-level structure of the data warehouse system—core and shell, key points and characteristics of data warehouse application development, data warehouse design, quality assurance, resources, teams, and skills. Finally, through a series of programs and examples, it explains the process of establishing a data warehouse, as well as the implementation of SQL programs on Oracle9i and SQL Server Analysis Services.
Based on successful practices, the book closely combines theory with technical implementation, making it suitable as a teaching and research textbook for information technology and management majors, as well as database majors in higher education institutions. It is also an ideal reference for a broad range of science and technology personnel engaged in the research and engineering application development of information systems.