Using OCL to Model Constraints in Data Warehouses

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.

Download Full-text

EVALUATION OF BITMAP INDEX USING PROTOTYPE DATA WAREHOUSE

INTERNATIONAL JOURNAL OF COMPUTERS & TECHNOLOGY ◽

10.24297/ijct.v2i1.2614 ◽

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.

Download Full-text

Enhancing Decision Support Systems with Spatial Capabilities

Strategic Information Systems ◽

10.4018/978-1-60566-677-8.ch158 ◽

2011 ◽

pp. 2542-2557

Author(s):

Marcus Costa Sampaio ◽

Cláudio de Souza Baptista ◽

André Gomes de Sousa ◽

Fabiana Ferreira do Nascimento

Keyword(s):

Decision Support ◽

Decision Support Systems ◽

Data Warehouse ◽

Spatial Data ◽

Support Systems ◽

Data Cube ◽

Related Data ◽

Spatial Dimensions ◽

Object Relational ◽

Long Time

This chapter introduces spatial dimensions and measures as a means of enhancing decision support systems with spatial capabilities. By some way or other, spatial related data has been used for a long time; however, spatial dimensions have not been fully exploited. It is presented a data model that tightly integrates data warehouse and geographical information systems — so characterizing a spatial data warehouse (SDW) — ; more precisely, the focus is on a formalization of SDW concepts, on a spatial-aware data cube using object-relational technology, and on issues underlying a SDW — specially regarding spatial data aggregation operations. Finally, the MapWarehouse prototype is presented aiming to validate the ideas proposed. The authors believe that SDW allows for the efficient processing of queries that use, jointly, spatial and numerical temporal data (e.g., temporal series from summarized spatial and numerical measures).

Download Full-text

Modelling Spatial Decision Support Systems Focused on the Development of a Data Warehouse

International Journal of Decision Support System Technology ◽

10.4018/ijdsst.2014070103 ◽

2014 ◽

Vol 6 (3) ◽

pp. 43-64

Author(s):

Concepción M. Gascueña ◽

Rafael Guadalupe

Keyword(s):

Decision Support ◽

Decision Support Systems ◽

Data Warehouse ◽

Support Systems ◽

Spatial Decision Support ◽

Model Driven ◽

Engineering Software ◽

Development Methodology ◽

Software Engineering Process ◽

Integration Problems

Nowadays, organizations have plenty of data stored in DB databases, which contain invaluable information. Decision Support Systems DSS provide the support needed to manage this information and planning medium and long-term “the modus operandi” of these organizations. Despite the growing importance of these systems, most proposals do not include its total development, mostly limiting itself on the development of isolated parts, which often have serious integration problems. Hence, methodologies that include models and processes that consider every factor are necessary. This paper will try to fill this void as it proposes an approach for developing spatial DSS driven by the development of their associated Data Warehouse DW, without forgetting its other components. To the end of framing the proposal different Engineering Software focus (The Software Engineering Process and Model Driven Architecture) are used, and coupling with the DB development methodology, (and both of them adapted to DW peculiarities). Finally, an example illustrates the proposal.

Download Full-text

Decision Support and Data Warehousing

Data Warehousing and Mining ◽

10.4018/978-1-59904-951-9.ch029 ◽

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.

Download Full-text

Design features of decision support systems with adaptation elements

Informacionno-technologicheskij vestnik ◽

10.21499/2409-1650-2020-24-2-58-68 ◽

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.

Download Full-text