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. P...

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 presen...

NoSQL (Not Only SQL) systems are becoming popular due to known advantages such as horizontal scalability and elasticity. In this paper, we study the implementation of multidimensional data warehouses with columnoriented NoSQL systems. We define mapping rules that transform the conceptual multidimensional data model to logical column-oriented models. We consider three different logical models an...

A source for errors in results of OLAP queries lies in neglecting changes in dimension data of Data Warehouses over time. In addition to the correct representation of such changes in temporal data warehouses it is necessary to discover such changes when they appear in the sources of a data warehouse. We propose to use data mining techniques in form of multidimensional outlier detection to disco...

NoSQL (Not Only SQL) systems are becoming popular due to known advantages such as horizontal scalability and elasticity. In this paper, we study the implementation of data warehouses with document-oriented NoSQL systems. We propose mapping rules that transform the multidimensional data model to logical document-oriented models. We consider three different logical models and we use them to insta...

Data warehouses have recently appeared in answer to the new requirements of the database technologies. With them appeared some automated techniques like Knowledge Discovery in Databases (KDD), Data Mining (DM) and On-Line Analytical Processing (OLAP), which have registered a great demand in relational, transactional and finally in geographical databases. In this paper, we are giving a survey of...

A federated data warehouse is a logical integration of data warehouses applicable when physical integration is impossible due to privacy policy or legal restrictions. In order to enable the translation of queries in a federated approach, schemas of the federated and the local warehouses must be matched. In this paper we present a procedure that enables the matching process for schema structures...

In many applications one has to fetch and assemble pieces of information coming from more than one web sources such as SPARQL endpoints. In this paper we describe the corresponding requirements and challenges, based on our experience, and then we present a process and a tool that we have developed, called MatWare, for constructing such semantic warehouses. We focus on domain-specific warehouses...

At present, it is very difficult to develop a methodology that fulfills all criteria and comprises all security constraints in the successful design of data warehouses. If that methodology were developed, its complexity would hinder its success. The solution, therefore, would be an approach in which techniques and models defined by the most accepted model standards were extended by integrating ...

Unit-load warehouses are used to store items—typically pallets—that can be stowed or retrieved in a single trip. In the traditional, ubiquitous design, storage racks are arranged to create parallel picking aisles, which force workers to travel rectilinear distances to picking locations. We consider the problem of arranging aisles in new ways to reduce the cost of travel within these warehouses....