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? The 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, based on the author's practical experience in implementing data warehouse technology. The book primarily describes the stages of the data warehouse design and development lifecycle and their corresponding technical structural frameworks. Additionally, it offers multiple 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 professionals engaged in information system research and engineering development.