Optimizing Data Warehousing Startegies

Abstract

Database technologies have evolved over the last two decades into different constructs to support the ever-growing information needs for organizations spanning the spectrum of operational and analytical processing. This paper examines the characteristics of transactional databases, operational data stores, data warehouses and virtual data warehouses. A framework is devloped for an optimal data warehousing strategy based on organizational needs classified by the types of business processes defined by the requirements of supporting functional areas and the levels of decision structures. Enterprise architecture is described to provide an integrated and complementary view of various data warehousing constructs.