Results 231 to 240 of about 35,828 (278)
Some of the next articles are maybe not open access.
Proceedings of the 13th International Conference on Extending Database Technology, 2010
So far, data warehousing has often been discussed in the light of complex OLAP queries and as reporting facility for operative data. We argue that business planning as a means to generate plan data is an equally important cornerstone of a data warehouse system, and we propose it to be a first-class citizen within an OLAP engine.
Franz Faerber +2 more
openaire +2 more sources
So far, data warehousing has often been discussed in the light of complex OLAP queries and as reporting facility for operative data. We argue that business planning as a means to generate plan data is an equally important cornerstone of a data warehouse system, and we propose it to be a first-class citizen within an OLAP engine.
Franz Faerber +2 more
openaire +2 more sources
Privacy Preserving OLAP and OLAP Security
2009The problem of ensuring the privacy and security of OLAP data cubes (Gray et al., 1997) arises in several fields ranging from advanced Data Warehousing (DW) and Business Intelligence (BI) systems to sophisticated Data Mining (DM) tools. In DW and BI systems, decision making analysts aim at avoiding that malicious users access perceptive ranges of ...
CUZZOCREA A, V. RUSSO
openaire +2 more sources
An architecture for stream OLAP exploiting SPE and OLAP engine
2015 IEEE International Conference on Big Data (Big Data), 2015Explosive increase of real-time data sources, so-called "data streams" (or just "steams") and increasing demands for real-time analysis over streams give rise to realtime analysis over streams. However, developing tailor-made systems for such applications is not always desirable due to high developing costs and long developing periods.
Toshiyuki Amagasa +4 more
openaire +2 more sources
Spreadsheets in RDBMS for OLAP
Proceedings of the 2003 ACM SIGMOD international conference on Management of data, 2003One of the critical deficiencies of SQL is lack of support for n-dimensional array-based computations which are frequent in OLAP environments. Relational OLAP (ROLAP) applications have to emulate them using joins, recently introduced SQL Window Functions [18] and complex and inefficient CASE expressions.
Gregory Dorman +7 more
openaire +2 more sources
An improved join‐free snowflake schema for ETL and OLAP of data warehouse
Concurrency and Computation, 2019The emergence of big data makes more and more enterprise change data management strategy, from simple data storage to OLAP query analysis; meanwhile, NoSQL‐based data warehouse receive more increasing attention than traditional SQL‐based database.
Jianmin Wang +4 more
semanticscholar +1 more source
Micro-architectural analysis of OLAP
Proceedings of the VLDB Endowment, 2019Understanding micro-architectural behavior is important for efficiently using hardware resources. Recent work has shown that in-memory online transaction processing (OLTP) systems severely underutilize their core micro-architecture resources [29 ...
Utku Sirin, A. Ailamaki
semanticscholar +1 more source
Detecting summarizability in OLAP
Data & Knowledge Engineering, 2014The industry trend towards self-service business intelligence is impeded by the absence, in commercially-available information systems, of automated identification of potential issues with summarization operations. Research on statistical databases and on data warehouses have both produced widely-accepted categorisations of measure attributes, the ...
Tapio Niemi +3 more
openaire +2 more sources
A Comprehensive Survey of OLAP: Recent Trends
2019 3rd International conference on Electronics, Communication and Aerospace Technology (ICECA), 2019A Multi-Dimensional Database (MDD) is a type of database for performing Data Warehousing and OLAP Operations. They are often made contribution for existing relational databases. The On-Line Analytical Processing (OLAP) is a Multidimensional database that
Adhish Nanda +2 more
semanticscholar +1 more source
Fusion OLAP: Fusing the Pros of MOLAP and ROLAP Together for In-Memory OLAP
IEEE Transactions on Knowledge and Data Engineering, 2019OLAP models can be categorized with two types: MOLAP (multidimensional OLAP) and ROLAP (relational OLAP). In particular, MOLAP is efficient in multidimensional computing at the cost of cube maintenance, while ROLAP reduces the data storage size at the ...
Yansong Zhang +3 more
semanticscholar +1 more source
A Holistic Approach for Query Evaluation andResult Vocalization in Voice-Based OLAP
SIGMOD Conference, 2019We focus on the problem of answering OLAP queries via voice output. We present a holistic approach that combines query processing and result vocalization. We use the following key ideas to minimize processing overheads and maximize answer quality. First,
Immanuel Trummer +2 more
semanticscholar +1 more source