文档介绍：Data Warehouse Design: Technology, Techniques, and Tools
1
Data Warehouse Design: Technology, Techniques, and Tools
Introduction
It’s tough pete in the new right-sized corporate environment where time to market is everything, and
decisions need to be made yesterday. Information exists within most corporate business systems that can help with
the decision-making process. Unfortunately, the information is often spread across multiple systems, making it very
time-consuming to get the information in the format necessary for decision support. As a result, panies are
seeking new decision support technologies to help them get the most of their information resources, so they can
utilize their experience to its maximum potential.
panies are required to develop their data warehouse and decision support systems in less time and with
less development resources than they might have devoted to a similar sized project in the past. Rapid application
development is not an option, it’s a means of survival. Today’s analysts and developers need tools that not only
assist them in the development process, but do the work for them whenever possible.
In this paper we examine the essential areas you need to be familiar with as you think about developing a data
warehouse:
· Data Warehouse Technology: the various concepts ponents of a data warehouse system,
including what types of databases are in the system and how they interrelate.
· Design Techniques: the methods used by analysts and designers for the most efficient and useful
design of the data warehouse system.
· Analysis and Design Tools: the features to look for in a tool to assist you in the analysis and design of a
data warehouse system.
2
Data Warehouse Design: Technology, Techniques, and Tools
Data Warehouse Technology
What are Decision Support and Executive Information Systems?
Decision Support Systems (DSS) and Executive Information Systems (EIS) are querying software used to provide the
informa