Nowadays, data warehousing and online analytical processing (OLAP) are core technologies in business intelligence and therefore have drawn much interest by researchers in the last decade. However, these technologies have been mainly developed for relational database systems in centralized environments. In other words, these technologies have not been designed to be applied in scalable systems s...

Data Warehouse (DW) and OLAP systems are Business Intelligence (BI) technologies intended to support decision-making process by means of on-line and multidimensional analysis of large volume of alphanumeric data (Kimball, 1996). DW models represent data according to the multidimensional model, which organizes warehoused data in dimensions (analysis axes) and facts, described by measures (analys...

In database management systems (DBMSs), query workloads can be classified as online transactional processing (OLTP) or analytical (OLAP). These often run within separate DBMSs. hybrid and (HTAP), both may execute the same DBMS. This article shows that it is possible to OLTP OLAP DBMSs, still support timely business decisions from queries running off fresh data. Several setups manage are analyse...

In this paper the authors describe a method to integrate explanatory business analytics in OLAP information systems. This method supports the discovery of exceptional values in OLAP data and the explanation of such values by giving their underlying causes. OLAP applications offer a support tool for business analysts and accountants in analyzing financial data because of the availability of diff...

OLAP (On-line Analytical Processing) technologies rely on multidimensional models to provide decision makers with appropriate structures allowing them to intuitively analyze data. However, these multidimensional models may be potentially large, thus becoming too complex to be understood at a glance. Current approaches for OLAP design are focused on providing analysts with a single multidimensio...

On-Line Analytical Processing (OLAP) enables analysts to gain insight into data through fast and interactive access to a variety of possible views on information, organized in a dimensional model. The demand for data integration is rapidly becoming larger as more and more information sources appear in modern enterprises. In the data warehousing approach, selected information is extracted in adv...

The queries in Online Analytical Processing (OLAP) are user-guided. OLAP is based on a multidimensional data model for complex analytical and ad-hoc queries with a rapid execution time. Those queries are either routed or on-demand revolved around the OLAP task. Most such queries are reusable and optimized in the system. Therefore, the queries recorded in the query logs for completing various OL...

The ability to analyze large amounts of data for the extraction of valuable information presents a competitive advantage for any organization. The technologies of data warehousing, OLAP, and data classification support that ability. The data warehouse is a central data pool which integrates heterogeneous data sources and provides strategic information for analysis and decision support. OnLine A...