Filters








51 Hits in 2.9 sec

Parallel querying of ROLAP cubes in the presence of hierarchies

Frank Dehne, Todd Eavis, Andrew Rau-Chaplin
2005 Proceedings of the 8th ACM international workshop on Data warehousing and OLAP - DOLAP  
In this paper, we present a hierarchy and caching framework that supports the efficient and transparent manipulation of attribute hierarchies within a parallel ROLAP environment.  ...  In practice, the difficulty of the indexing problem is exacerbated by the existence of attribute hierarchies that sub-divide attributes into aggregation layers of varying granularity.  ...  Algorithm 2 describes the new algorithm for querying multi-dimensional data in the presence of hierarchies.  ... 
doi:10.1145/1097002.1097019 dblp:conf/dolap/DehneER05 fatcat:hbbjdummzzhi5bsyf7dkiduase

A multidimensional data model with subcategories for flexibly capturing summarizability

Sina Ariyan, Leopoldo Bertossi
2013 Proceedings of the 25th International Conference on Scientific and Statistical Database Management - SSDBM  
MD aggregate query) in an EHM database, determines from which minimal subset of precomputed cube views it can be correctly computed.  ...  We present the algorithms for EHM dimensions previously announced, in particular, to determine from which precomputed cube views a cube view (i.e. aggregate query) can be correctly computed, for summarizability  ...  Acknowledgments: This research was funded by NSERC Discovery, an NSERC-IBM CRD, and the NSERC Strategic Network on Business Intelligence (BIN). L. Bertossi is a Faculty Fellow of IBM CAS.  ... 
doi:10.1145/2484838.2484857 dblp:conf/ssdbm/AriyanB13 fatcat:w7efhbenwbg7raoavam3x7vuou

A Conceptual Model for Combining Enhanced OLAP and Data Mining Systems

Muhammad Usman, Sohail Asghar, Simon Fong
2009 2009 Fifth International Joint Conference on INC, IMS and IDC  
In this paper, we reviewed the coupling of OLAP and data mining in the literature and identified their limitations.  ...  Furthermore, the proposed model offers directions to improving cube construction time and visualization over the data cube.  ...  They formalized the simultaneous presence of more than one query which was done in two layers, Presentation Layer and Logical Layer.  ... 
doi:10.1109/ncm.2009.354 dblp:conf/ncm/UsmanAF09 fatcat:uxxhnbm3vfdmnmu7agul6oii4i

Database technology for decision support systems

S. Chaudhuri, U. Dayal, V. Ganti
2001 Computer  
the past year, • total footwear sales in New York City within the past month by product family, • the 50 cities with the highest number of unique customers, and • one million customers who are most likely  ...  Data warehouses contain data consolidated from several operational databases and tend to be orders of magnitude larger than operational databases, often hundreds of gigabytes to terabytes in size.  ...  With a multidimensional data view, drill-down and roll-up queries are logical operations on the cube depicted in Figure 3 .  ... 
doi:10.1109/2.970575 fatcat:2il3danygbhxnanzwt33kfnpie

Business intelligence for small and middle-sized entreprises

Oksana Grabova, Jerome Darmont, Jean-Hugues Chauchat, Iryna Zolotaryova
2010 SIGMOD record  
Data warehouses are the core of decision support systems, which nowadays are used by all kind of enterprises in the entire world.  ...  Although many studies have been conducted on the need of decision support systems (DSSs) for small businesses, most of them adopt existing solutions and approaches, which are appropriate for large-scaled  ...  A cube stores the result of different calculations and aggregations. There are three variants of OLAP: MOLAP, ROLAP, Hybrid OLAP (HOLAP). We compare these approaches in table 2.  ... 
doi:10.1145/1893173.1893180 fatcat:5nod2wteynbd7ip5dvnturenia

Multidimensional Databases and Data Warehousing

Christian S. Jensen, Torben Bach Pedersen, Christian Thomsen
2010 Synthesis Lectures on Data Management  
Synthesis Lectures on Data Management is edited by Tamer Özsu of the University of Waterloo. The series will publish 50-to 125 page publications on topics pertaining to data management.  ...  The scope will largely follow the purview of premier information and computer science conferences, such as ACM SIGMOD, VLDB, ICDE, PODS, ICDT, and ACM KDD.  ...  We also thank Tamer for identifying problems such as typos and hard-to-follow prose in an earlier draft of the lecture, and for challenging us to find ways of using the noun "data" that comply with the  ... 
doi:10.2200/s00299ed1v01y201009dtm009 fatcat:okkbzn3ahzcfxkthg5zfhv7dhq

DWEB: A Data Warehouse Engineering Benchmark [article]

Jérôme Darmont, Omar Boussaïd
2007 arXiv   pre-print
A sample usage of DWEB is also provided in this paper.  ...  This is usually done with the help of benchmarks, which can either help system users comparing the performances of different systems, or help system engineers testing the effect of various design choices  ...  , the presence of a Having clause in the query, or the number of subsequent drill down operations.  ... 
arXiv:0705.1453v1 fatcat:lpht7u7gy5gvbk6rygbnohdjnu

DWEB: A Data Warehouse Engineering Benchmark [chapter]

Jérôme Darmont, Fadila Bentayeb, Omar Boussaïd
2005 Lecture Notes in Computer Science  
A sample usage of DWEB is also provided in this paper.  ...  This is usually done with the help of benchmarks, which can either help system users comparing the performances of different systems, or help system engineers testing the effect of various design choices  ...  , the presence of a Having clause in the query, or the number of subsequent drill down operations.  ... 
doi:10.1007/11546849_9 fatcat:3logrdqjabgznbim3nzmrwxrwa

The cgmCUBE project: Optimizing parallel data cube generation for ROLAP

Frank Dehne, Todd Eavis, Andrew Rau-Chaplin
2006 Distributed and parallel databases  
Various sequential algorithms for the efficient generation of the data cube have appeared in the literature.  ...  Central to the OLAP paradigm is the data cube, a multi-dimensional hierarchy of aggregate values that provides a rich analytical model for decision support.  ...  , with the goal of building a parallel system for ROLAP data cube construction.  ... 
doi:10.1007/s10619-006-6575-6 fatcat:re7lym34srgyhcdvuwfupmgvti

An overview of data warehousing and OLAP technology

Surajit Chaudhuri, Umeshwar Dayal
1997 SIGMOD record  
In addition to surveying the state of the art, this paper also identifies some promising research issues, some of which are related to problems that the database research community has worked on for years  ...  Many commercial products and services are now available, and all of the principal database management system vendors now have offerings in these areas.  ...  Acknowledgement We thank Goetz Graefe for his comments on the draft.  ... 
doi:10.1145/248603.248616 fatcat:ssiegmooy5bujdawwxoseke2my

An Architecture for Integrated Online Analytical Mining

Muhammad Usman, Sohail Asghar
2011 Journal of Emerging Technologies in Web Intelligence  
We enhanced the performance of OLAP in terms of cube construction time and visualization by providing interactive visual exploration of data cube.  ...  In this paper, a variety of OLAM architectures in the literature were reviewed and the limitations in the previously reported work have been identified.  ...  They formalized the simultaneous presence of more than one queries which was done in two layers (Presentation Layer and Logical Layer).  ... 
doi:10.4304/jetwi.3.2.74-99 fatcat:ppkarvwrojho5ftwdwqqok2m6m

Benchmarking data warehouses

Jerome Darmont, Fadila Bentayeb, Omar Boussaid
2007 International Journal of Business Intelligence and Data Mining  
The full specifications of DWEB, as well as experiments we performed to illustrate how our benchmark may be used, are provided in this paper.  ...  These tools can either help system users comparing the performances of different systems, or help system engineers testing the effect of various design choices.  ...  Acknowledgements The authors would like to thank Sylvain Ducreux, Sofiane Guesmia, Bruno Joubert, Benjamin Mouton and Pierre-Marie Penin for their important contribution to DWEB's implementation and testing  ... 
doi:10.1504/ijbidm.2007.012947 fatcat:3jcktbjylncqph3gzjmx63ygoe

ROLAP implementations of the data cube

Konstantinos Morfonios, Stratis Konakas, Yannis Ioannidis, Nikolaos Kotsis
2007 ACM Computing Surveys  
In this article, we focus on Relational-OLAP (ROLAP), following the majority of the efforts so far.  ...  and NIKOLAOS KOTSIS Capgemini UK Implementation of the data cube is an important and scientifically interesting issue in On-Line Analytical Processing (OLAP) and has been the subject of a plethora of related  ...  Size reduction increases when the number of dimensions grows but decreases in the presence of skew.  ... 
doi:10.1145/1287620.1287623 fatcat:ehpb66objzhqrlfr2x3e67repq

Business Intelligence for Small and Middle-Sized Entreprises [article]

Oksana Grabova, Jean-Hugues Chauchat, Iryna Zolotaryova
2011 arXiv   pre-print
Data warehouses are the core of decision support sys- tems, which nowadays are used by all kind of enter- prises in the entire world.  ...  Although many studies have been conducted on the need of decision support systems (DSSs) for small businesses, most of them adopt ex- isting solutions and approaches, which are appropriate for large-scaled  ...  It consists in a se-mantic compression by partitioning the set of cells of a cube into equivalent classes, while keeping the cube's roll-up and drill-down semantics and lattice structure [25] .  ... 
arXiv:1102.0115v1 fatcat:txl22x52g5eh3pjymrb4l4ckyq

Hierarchies in a multidimensional model: From conceptual modeling to logical representation

E. Malinowski, E. Zimányi
2006 Data & Knowledge Engineering  
We also present the mapping of such hierarchies to the relational model, as well as their implementation in commercial DW products.  ...  In this paper, we formally define the MultiDimER model, a conceptual multidimensional model that allows to represent facts with measures as well as the different kinds of hierarchies already classified  ...  , and (2) the support of some type of hierarchies in current DWs and ROLAP (relational OLAP) systems 2 .  ... 
doi:10.1016/j.datak.2005.08.003 fatcat:o7lzwffdgrdt3mnftbmysy4d4y
« Previous Showing results 1 — 15 out of 51 results