Building the Data Warehouse

Скачать в pdf «Building the Data Warehouse»


Archiving External Data    275


Comparing Internal Data to External Data    275


Summary    276


Chapter 9 Migration to the Architected Environment    277


A Migration Plan    278


The Feedback Loop    286


Strategic Considerations    287


Methodology and Migration    289


A Data-Driven Development Methodology    291


Data-Driven Methodology    293


System Development Life Cycles    294


A Philosophical Observation    294


Operational Development/DSS Development    294


Summary    295


Chapter 10 The Data Warehouse and the Web    297


Supporting the Ebusiness Environment    307


Moving Data from the Web to the Data Warehouse    307


Moving Data from the Data Warehouse to the Web    308


Web Support    309


Summary    310


Chapter П    ERP and the Data Warehouse    3П


ERP Applications Outside the Data Warehouse    312


Building the Data Warehouse inside the ERP Environment 314


Feeding the Data Warehouse through ERP and Non-ERP Systems    314


The ERP-Oriented Corporate Data Warehouse    318


Summary    320


Chapter 12    Data Warehouse Design Review Checklist    321


When to Do Design Review    322


Who Should Be in the Design Review?    323


What Should the Agenda Be?    323


The Results    323


Administering the Review    324


A Typical Data Warehouse Design Review    324


Summary    342


Appendix    343


Glossary    385


Reference    397


407


Index


Databases and database theory have been around for a long time. Early renditions of databases centered around a single database serving every purpose known to the information processing community—from transaction to batch processing to analytical processing. In most cases, the primary focus of the early database systems was operational—usually transactional—processing. In recent years, a more sophisticated notion of the database has emerged—one that serves operational needs and another that serves informational or analytical needs. To some extent, this more enlightened notion of the database is due to the advent of PCs, 4GL technology, and the empowerment of the end user.

Скачать в pdf «Building the Data Warehouse»