scholarly journals An Automatic Schema-Instance Approach for Merging Multidimensional Data Warehouses

2021 ◽  
Author(s):  
Yuzhao Yang ◽  
Jérôme Darmont ◽  
Franck Ravat ◽  
Olivier Teste
2008 ◽  
pp. 303-335
Author(s):  
Haorianto Cokrowijoyo Tjioe ◽  
David Taniar

Data mining applications have enormously altered the strategic decision-making processes of organizations. The application of association rules algorithms is one of the well-known data mining techniques that have been developed to cope with multidimensional databases. However, most of these algorithms focus on multidimensional data models for transactional data. As data warehouses can be presented using a multidimensional model, in this paper we provide another perspective to mine association rules in data warehouses by focusing on a measurement of summarized data. We propose four algorithms — VAvg, HAvg, WMAvg, and ModusFilter — to provide efficient data initialization for mining association rules in data warehouses by concentrating on the measurement of aggregate data. Then we apply those algorithms both on a non-repeatable predicate, which is known as mining normal association rules, using GenNLI, and a repeatable predicate using ComDims and GenHLI, which is known as mining hybrid association rules.


2013 ◽  
Vol 9 (2) ◽  
pp. 89-109 ◽  
Author(s):  
Marie-Aude Aufaure ◽  
Alfredo Cuzzocrea ◽  
Cécile Favre ◽  
Patrick Marcel ◽  
Rokia Missaoui

In this vision paper, the authors discuss models and techniques for integrating, processing and querying data, information and knowledge within data warehouses in a user-centric manner. The user-centric emphasis allows us to achieve a number of clear advantages with respect to classical data warehouse architectures, whose most relevant ones are the following: (i) a unified and meaningful representation of multidimensional data and knowledge patterns throughout the data warehouse layers (i.e., loading, storage, metadata, etc); (ii) advanced query mechanisms and guidance that are capable of extracting targeted information and knowledge by means of innovative information retrieval and data mining techniques. Following this main framework, the authors first outline the importance of knowledge representation and management in data warehouses, where knowledge is expressed by existing ontology or patterns discovered from data. Then, the authors propose a user-centric architecture for OLAP query processing, which is the typical applicative interface to data warehouse systems. Finally, the authors propose insights towards cooperative query answering that make use of knowledge management principles and exploit the peculiarities of data warehouses (e.g., multidimensionality, multi-resolution, and so forth).


Author(s):  
Э.Э. Акимкина

Рассмотрены вопросы повышения эффективности систем поддержки принятия решений на основе многомерных хранилищ данных, имеющие существенное значение для выполнения требований по увеличению быстродействия систем. Показано, что эффективность функционирования системы поддержки принятия решений возрастает при введении в нее элементов обслуживания, которые позволяют учитывать изменение условий внешней и внутренней среды. Разработана методика проектирования системы поддержки принятия решений, учитывающая особенности ее адаптации к изменяющимся условиям с помощью элементов обслуживания. 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.


Author(s):  
Mirek Riedewald ◽  
Divyakant Agrawal

Rapidly improving computing and networking technology enables enterprises to collect data from virtually all its business units. The main challenge today is to extract useful information from an overwhelmingly large amount of raw data. To support complex analysis queries, data warehouses were introduced. They manage data, which is extracted from the different operational databases and from external data sources, and they are optimized for fast query processing. For modern data warehouses, it is common to manage Terabytes of data. According to a recent survey by the Winter Corporation (2003), for instance, the decision support database of SBC reached a size of almost 25 Terabytes, up from 10.5 Terabytes in 2001 (Winter Corporation, 2001).


2016 ◽  
Vol 12 (4) ◽  
pp. 20-53 ◽  
Author(s):  
Franck Ravat ◽  
Jiefu Song ◽  
Olivier Teste

Data reduction in Multidimensional Data Warehouses (MDWs) allows increasing the efficiency of analysis and facilitating decision-makers' tasks. In this paper, the authors model a MDW containing reduced data through a set of states. Each state is valid for a certain period of time; it contains only useful information according to decision-makers' needs. In order to carry out analyses in a MDW composed of multiple states, an extension of traditional OLAP analysis operators is required. In this paper, the authors define a set of OLAP operators compatible with reduced MDWs. For each operator, they propose a user-oriented definition along with an algorithmic translation. To show the feasibility and the efficiency of the proposed concepts, they implement the analysis operators in an R-OLAP framework.


Author(s):  
Max Chevalier ◽  
Mohammed El Malki ◽  
Arlind Kopliku ◽  
Olivier Teste ◽  
Ronan Tournier

Author(s):  
MOHAMMED SHAFEEQ AHMED

Data-driven decision support systems, such as data warehouses can serve the requirement of extraction of information from more than one subject area. Data warehouses standardize the data across the organization so as to have a single view of information. Data warehouses (DW) can provide the information required by the decision makers. The data warehouse supports an on-line analytical processing (OLAP), the functional and performance requirements of which are quite different from those of the on-line transaction processing (OLTP) applications traditionally supported by the operational databases. Data warehouses provide on-line analytical processing (OLAP) tools for the interactive analysis of multidimensional data of varied granularities, which facilitates effective data mining. Data warehousing and OLAP have emerged as leading technologies that facilitate data storage, organization and then, significant retrieval. Both are essential elements of decision support, which has increasingly become a focus of the database industry. This paper provides a detailed picture of Data warehousing (DW), exploring the features of it, applications and the architecture of DW over Data Mining, Online Analytical Processing (OLAP), On-line Transaction Processing (OLTP) technologies.


Controlling ◽  
2003 ◽  
Vol 15 (6) ◽  
pp. 323-330 ◽  
Author(s):  
Jürgen Propach ◽  
Svend Reuse
Keyword(s):  

Sign in / Sign up

Export Citation Format

Share Document