ABSTRACT

Decision support systems are interactive, computer-based information systems that provide data and analysis tools in order to assist managers at various levels of an organization in the process of decision-making. Data warehouses have been developed and deployed as an integral part of decision support systems. A data warehouse is a database that allows the storage of high volumes of historical data required for analytical purposes. These data are extracted from operational databases, transformed into a coherent whole, and loaded into a data warehouse during an extraction-transformation-loading (ETL) process. Data in data warehouses can be dynamically manipulated using online analytical processing (OLAP) systems. A database is deployed on a database management system (DBMS), which is a software system that allows users to define, create, manipulate, and administer a database. OLAP analyses developed by knowledge workers may need to access the information associated with several cuboids, based on the specific queries and analyses being carried out.