An architecture for data warehouse systems

The growing demand for decision support tools has resulted in data warehousing as an important database research area. We propose an architecture for data warehouse systems. The architecture involves client/server properties and deductive database features. It can provide good properties of generality, extendibility, efficiency, scalability, and intelligence. We detail information flow in warehouse systems and functions of warehouse components. We also review and highlight the research problems in this area.