Data warehouses and decision support systems

Computer ◽  
2001 ◽  
Vol 34 (12) ◽  
pp. 38-39 ◽  
Author(s):  
M. Blaha
Keyword(s):  
Decision Support ◽  
Decision Support Systems ◽  
Support Systems ◽  
Data Warehouses

Using OCL to Model Constraints in Data Warehouses

2013 ◽  
pp. 212-224
Author(s):  
François Pinet ◽  
Myoung-Ah Kang ◽  
Kamal Boulil ◽  
Sandro Bimonte ◽  
Gil De Sousa ◽  
...  
Keyword(s):  
Decision Support ◽  
Decision Support Systems ◽  
Data Warehouse ◽  
Support Systems ◽  
General Information ◽  
Data Warehouses ◽  
Object Constraint Language ◽  
Software Applications ◽  
Constraint Language ◽  
Transactional Databases

Recent research works propose using Object-Oriented (OO) approaches, such as UML to model data warehouses. This paper overviews these recent OO techniques, describing the facts and different analysis dimensions of the data. The authors propose a tutorial of the Object Constraint Language (OCL) and show how this language can be used to specify constraints in OO-based models of data warehouses. Previously, OCL has been only applied to describe constraints in software applications and transactional databases. As such, the authors demonstrate in this paper how to use OCL to represent the different types of data warehouse constraints. This paper helps researchers working in the fields of business intelligence and decision support systems, who wish to learn about the major possibilities that OCL offer in the context of data warehouses. The authors also provide general information about the possible types of implementation of multi-dimensional models and their constraints.

Decision Support and Data Warehousing

2008 ◽  
pp. 397-407
Author(s):  
Alexander Anisimov
Keyword(s):  
Decision Making ◽  
Information Technology ◽  
Decision Support ◽  
Decision Support Systems ◽  
Support Systems ◽  
Data Warehousing ◽  
Global Information ◽  
Data Warehouses ◽  
Sources Of Information ◽  
External Sources

This chapter is dedicated to the major managerial, organizational and technological aspects of development of data warehouses in a global information environment, when different external sources of information are available and potentially may have value for decision support and managerial analysis. It summarizes the major benefits that become available for businesses if they decide to integrate information from external sources into their data warehouses. It also introduces the overall organizational framework of development of data warehouses that are based upon the information from different external sources. Furthermore the author hopes that understanding of the framework introduced will not only inform practitioners (both information technology (IT) specialists and managers in different spheres of business) of new possible approaches to design of decision support systems but also assist in the improvement of approaches to decision-making procedures.

Design features of decision support systems with adaptation elements

2020 ◽  
pp. 58-68
Author(s):  
Э.Э. Акимкина
Keyword(s):  
Decision Support ◽  
Decision Support System ◽  
Decision Support Systems ◽  
Support System ◽  
System Performance ◽  
Support Systems ◽  
Multidimensional Data ◽  
Internal Environment ◽  
Data Warehouses ◽  
Design Features

Рассмотрены вопросы повышения эффективности систем поддержки принятия решений на основе многомерных хранилищ данных, имеющие существенное значение для выполнения требований по увеличению быстродействия систем. Показано, что эффективность функционирования системы поддержки принятия решений возрастает при введении в нее элементов обслуживания, которые позволяют учитывать изменение условий внешней и внутренней среды. Разработана методика проектирования системы поддержки принятия решений, учитывающая особенности ее адаптации к изменяющимся условиям с помощью элементов обслуживания. Issues of increasing the effectiveness of decision support systems based on multidimensional data warehouses are considered, which are essential for fulfilling the requirements to increase system performance. It is shown that the effectiveness of the functioning of the decision support system increases with the introduction of service elements in it, which allow taking into account changes in the conditions of the external and internal environment. A methodology has been developed for designing a decision support system that takes into account the peculiarities of its adaptation to changing conditions using service elements.

Implementation of Business Intelligence For Sales Management

2016 ◽  
Vol 5 (1) ◽  
pp. 22
Author(s):  
Bouzekri Moustaid ◽  
Mohamed Fakir
Keyword(s):  
Decision Making ◽  
Decision Support ◽  
Decision Support Systems ◽  
Business Intelligence ◽  
Support Systems ◽  
Applied Mathematics ◽  
Sales Management ◽  
Economic Environment ◽  
Action Plans ◽  
Data Warehouses

<p>Today's company operates in a socio-economic environment increasingly demanding. In such a context, it is obliged to adopt a competitive approach by exploiting at best the information that it possesses for developing appropriate action plans and taking effective decisions. The decision support systems provide to the enterprise the tools that help it for decision-making based on techniques and methodologies coming from domain of applied mathematics such as optimization, statistics and theory of the decision. The decision support systems are composed of various components such as data warehouses, ETL tools and reporting and analysis tools.</p>

Decision Support and Data Warehousing

2008 ◽  
pp. 908-919
Author(s):  
Alexander Anisimov
Keyword(s):  
Decision Making ◽  
Information Technology ◽  
Decision Support ◽  
Decision Support Systems ◽  
Support Systems ◽  
Data Warehousing ◽  
Global Information ◽  
Data Warehouses ◽  
Sources Of Information ◽  
External Sources

This chapter is dedicated to the major managerial, organizational and technological aspects of development of data warehouses in a global information environment, when different external sources of information are available and potentially may have value for decision support and managerial analysis. It summarizes the major benefits that become available for businesses if they decide to integrate information from external sources into their data warehouses. It also introduces the overall organizational framework of development of data warehouses that are based upon the information from different external sources. Furthermore the author hopes that understanding of the framework introduced will not only inform practitioners (both information technology (IT) specialists and managers in different spheres of business) of new possible approaches to design of decision support systems but also assist in the improvement of approaches to decision-making procedures.

Decision Support and Data Warehousing

2011 ◽  
pp. 149-166
Author(s):  
Alexander Anisimov
Keyword(s):  
Decision Making ◽  
Information Technology ◽  
Decision Support ◽  
Decision Support Systems ◽  
Support Systems ◽  
Data Warehousing ◽  
Global Information ◽  
Data Warehouses ◽  
Sources Of Information ◽  
External Sources

This chapter is dedicated to the major managerial, organizational and technological aspects of development of data warehouses in a global information environment, when different external sources of information are available and potentially may have value for decision support and managerial analysis. It summarizes the major benefits that become available for businesses if they decide to integrate information from external sources into their data warehouses. It also introduces the overall organizational framework of development of data warehouses that are based upon the information from different external sources. Furthermore the author hopes that understanding of the framework introduced will not only inform practitioners (both information technology (IT) specialists and managers in different spheres of business) of new possible approaches to design of decision support systems but also assist in the improvement of approaches to decision-making procedures.

scholarly journals EVALUATION OF BITMAP INDEX USING PROTOTYPE DATA WAREHOUSE

2012 ◽  
Vol 2 (2) ◽  
pp. 39-42
Author(s):  
Murtadha M. Hamad ◽  
Muhammed Abdul Raheem
Keyword(s):  
Decision Support ◽  
Query Processing ◽  
Decision Support Systems ◽  
Data Warehouse ◽  
Support Systems ◽  
Data Warehouses ◽  
Bitmap Index ◽  
Access Methods ◽  
Complex Query ◽  
Bitwise Operations

Bitmap indices have become popular access methods for data warehouse applications and decision support systems with large amounts of read-mostly data. This paper could arrive a number of results such as ; Bitmap Index highly improves the performance of Query Answering in Data Warehouses, It highly increases the efficiency of Complex Query processing through using bitwise operations (AND, OR). A prototype of Data Warehouse “STUDENTS DW” has been built according to the conditions of W. Inomn of Data Warehouses. This prototype is built for student's information.

Sign in / Sign up

Export Citation Format

Share Document