2,047 Hits in 3.2 sec

Constructing OLAP cubes based on queries

Tapio Niemi, Jyrki Nummenmaa, Peter Thanisch
2001 Proceedings of the 4th ACM international workshop on Data warehousing and OLAP - DOLAP '01  
An On-Line Analytical Processing (OLAP) user often follows a train of thought, posing a sequence of related queries against the data warehouse.  ...  The method constructs complete but minimal cubes with low risks related to sparsity and incorrect aggregations. After the user has given queries, the system will suggest a cube design.  ...  CONCLUSIONS AND FUTURE WORK We have presented a method to construct OLAP cubes based on example queries.  ... 
doi:10.1145/512236.512238 dblp:conf/dolap/NiemiNT01 fatcat:qylutddgardgtotrdvqeegc5vu

Constructing an OLAP cube from distributed XML data

Tapio Niemi, Marko Niinimäki, Jyrki Nummenmaa, Peter Thanisch
2002 Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP - DOLAP '02  
The query is analysed to determine which data is required for the desired OLAP cube.  ...  Our system also has a facility, where the user may pose a query against a "universal" OLAP cube using the MDX language.  ...  We use a simplified version of the query based OLAP cube design method [10] .  ... 
doi:10.1145/583890.583894 dblp:conf/dolap/NiemiNNT02 fatcat:dzm7kt4gdzf7die5pzdmart6iu

H*-tree/H*-cubing-cubing: Improved Data Cube Structure and Cubing Method for OLAP on Data Stream
H*-tree/H*-cubing: 데이터 스트림의 OLAP를 위한 향상된 데이터 큐브 구조 및 큐빙 기법

Xiangrui Chen, Yan Li, Dong-Wook Lee, Gyoung-Bae Kim, Hae-Young Bae
2009 The KIPS Transactions PartD  
Since it is costly to construct data cube and execute ad-hoc OLAP queries, more research works should be done considering efficient data structure, query method and algorithms.  ...  Meeting on-line analysis requirements of data stream, several cube structures have been proposed for OLAP on data stream, such as stream cube, flowcube, S-cube.  ...  Reviewing H-cubing, it aims to answer OLAP queries based on the pre-materialized cuboids along popular-path.  ... 
doi:10.3745/kipstd.2009.16-d.4.475 fatcat:tubihilrojbdxniqzhkdrwsbua

A Practice of TPC-DS Multidimensional Implementation on NoSQL Database Systems [chapter]

Hongwei Zhao, Xiaojun Ye
2014 Lecture Notes in Computer Science  
IMPLEMENTATION STEPS  Base cuboid building with 4 stages: • Dimension constructing • Hive query • Aggregation • Saving  OLAP Query execution with 4 stages: • Loading dimension • Other cuboid  ...  TPC-DS data files Star schema Cube data User queries Cube Lattice Cube Instance Cuboid Instance CUBE MODEL ON KEY-VALUE STORES Cuboid Instance Dimension Instance Dimension Instance  ...  "d_moy" • Choice of cube model : • Demand-driven & data-driven • Generation for cube data: • Model-driven & requirement-driven Q U E S T I O N S A N S W E R S  ... 
doi:10.1007/978-3-319-04936-6_7 fatcat:qz4i46zuvjhchkekyggkhdkdii

Publishing OLAP Cubes on the Semantic Web [chapter]

Alejandro Vaisman
2016 Lecture Notes in Business Information Processing  
Query: 7/6/2015 Query Form: CONSTRUCT DW & OLAP on the Semantic Web 79 • Sub-queries and Aggregate Values • To combine the CONSTRUCT query form with aggregate values, a sub- query should be  ...  /INSERT WHERE: updates based on triples specified in the WHERE clause (as in SELECT and CONSTRUCT)  ...  DW & OLAP on the Semantic Web nw:stateName a qb4o:LevelAttribute ; rdfs:label "State Name"@en ; rdfs:range xsd:string . nw:englishStateName a qb4o:LevelAttribute ; rdfs:label "English State Name"@en ;  ... 
doi:10.1007/978-3-319-39243-1_2 fatcat:lhcif5ej3nftpoub6es25ihdae

A Formal OLAP Algebra for NoSQL based Data Warehouses

Shreya Banerjee, Sourabh Bhaskar, Anirban Sarkar, Narayan C. Debnath
2021 Annals of Emerging Technologies in Computing  
However, business analysts face challenges when performing On Line Analytical Processing (OLAP) queries on these NoSQL systems.  ...  The lack of uniform representation of various OLAP operations over different types of NoSQL based DWs is one of them.  ...  Further, the data cubes based on facts are mapped towards Collection layer. Attribute layer has its construct types -Attribute (AT).  ... 
doi:10.33166/aetic.2021.05.019 fatcat:34x2ijb6vvbvldbi25jupb3ory

HDW: A High Performance Large Scale Data Warehouse

Jinguo You, Jianqing Xi, Chuan Zhang, Gengqi Guo
2008 2008 International Multi-symposiums on Computer and Computational Sciences  
This paper presents a solution, called HDW, based on Google infrastructure such as GFS, Bigtable, MapReduce to build and manage a large scale distributed data warehouse for high performance OLAP analysis  ...  The results show that HDW achieves pretty good performance and high scalability, which has been demonstrated on at least 18 nodes with 36 cores.  ...  Panda constructs ROLAP data cubes mainly based on the pipesort algorithm, while HDW builds a MOLAP data cubes around the closed cube algorithm [9] .  ... 
doi:10.1109/imsccs.2008.16 dblp:conf/imsccs/YouXZG08 fatcat:t7g4zxr4ofc7toznethoa3dyiq

On-line analytical processing on large databases managed by computational grids

B. Fiser, U. Onan, I. Elsayed, P. Brezany, A.M. Tjoa
2004 Proceedings. 15th International Workshop on Database and Expert Systems Applications, 2004.  
The OLAP components were implemented in Java on top of the software toolkit Globus 3.  ...  However, so far, no effort was devoted to On-Line Analytical Processing (OLAP), an essential support for modern decision support systems.  ...  The Sequential OLAP Engine From a global point of view, our sequential OLAP server currently consists of the data cube structure, an index database and function blocks for cube construction, querying and  ... 
doi:10.1109/dexa.2004.1333533 dblp:conf/dexaw/FiserOEBT04 fatcat:jgsvsesmcbf6pmddubnudqs4xu

Privacy Preserving OLAP over Distributed XML Data: A Theoretically-Sound Secure-Multiparty-Computation Approach

Alfredo Cuzzocrea, Elisa Bertino
2011 Journal of computer and system sciences (Print)  
In order to fulfill this gap, we propose a novel Secure Multiparty Computation (SMC)-based privacy preserving OLAP framework for distributed collections of XML documents.  ...  Privacy Preserving Distributed OLAP is becoming a critical challenge for next-generation Business Intelligence (BI) scenarios, due to the "natural suitability" of OLAP in analyzing distributed massive  ...  one of data cube cells, like in conventional perturbation-based privacy preserving OLAP techniques.  ... 
doi:10.1016/j.jcss.2011.02.004 fatcat:ut45awj5qfayzmagxwiq4g5fga

High Performance OLAP and Data Mining on Parallel Computers [chapter]

Sanjay Goil, Alok Choudhary, Paul Stolorz, Ron Musick
1997 Scalable High Performance Computing for Knowledge Discovery and Data Mining  
Precomputed aggregate calculations in a Data Cube can provide efficient query processing for OLAP applications.  ...  We present two methods, sort-based and hash-based for loading the base cube and compare their performances.  ...  For example, for a 3D cube, ABC, interestingness measure will be calculated between A and B, A and C and between B and C.  ... 
doi:10.1007/978-1-4615-5669-5_3 fatcat:h4dkh4j655fqjirev4f5nmibbq

Olap Cube Representation For Objectoriented Database

Vipin Saxena
2012 International Journal of Software Engineering & Applications  
For testing purpose, some sample queries are also performed on the object-oriented database.  ...  UML class model, sequence diagram and star schema of object-oriented database are designed along with the OLAP cube.  ...  Schema Designing for OLAP Cube To construct an OLAP cube, one needs to think about the measures and the dimensions.  ... 
doi:10.5121/ijsea.2012.3209 fatcat:lnmg62pywnb2bo4uq7fu3mf7uu

SETLBI: An Integrated Platform for Semantic Business Intelligence

Rudra Pratap Deb Nath, Katja Hose, Torben Bach Pedersen, Oscar Romero, Amrit Bhattacharjee
2020 Companion Proceedings of the Web Conference 2020  
(S)he creates any TBox constructs using panel 1 and a cube using panel 2.  ...  Users can create slice and dice queries adding conditions on selected levels. Internally, we translate the OLAP query generated from the selections into an equivalent SPARQL query.  ... 
doi:10.1145/3366424.3383533 dblp:conf/www/NathHP0B20 fatcat:ej4k656t4jc6hiw5wvgag4c7fq

Efficacious Data Cube Exploration by Semantic Summarization and Compression [chapter]

Laks V.S. Lakshmanan, Jian Pei, Yan Zhao
2003 Proceedings 2003 VLDB Conference  
Data cube is the core operator in data warehousing and OLAP.  ...  Its efficient computation, maintenance, and utilization for query answering and advanced analysis have been the subjects of numerous studies.  ...  , "Can we construct a quotient cube useful for general-purpose OLAP?", and "What are the effects on quotient cubes if hierarchies appear in some dimensions?"  ... 
doi:10.1016/b978-012722442-8/50121-x dblp:conf/vldb/LakshmananPZ03 fatcat:yi6ybikpeff5np6zjhzlfvm73i

A Parallel and Distributed Method for Computing High Dimensional MOLAP [chapter]

Kongfa Hu, Ling Chen, Qi Gu, Bin Li, Yisheng Dong
2005 Lecture Notes in Computer Science  
Using dimension hierarchical encoding and pre-aggregated results, OLAP queries are computed online by dynamically constructing cuboids from the fragment data cubes.  ...  Data cube has been playing an essential role in fast OLAP(on-line analytical processing) in many multidimensional data warehouse.  ...  Using inverted hierarchical encoding indices and pre-aggregated results, OLAP queries are computed online by dynamically constructing cuboids from the fragment data cubes.  ... 
doi:10.1007/11577188_30 fatcat:zvsy5oml7respho6ejnh6yvssy

On-line analytical processing based on formal concept analysis

A.V. Korobko, T.G. Penkova
2010 Procedia Computer Science  
An approach to analytical decision making support based on integration of OLAP technology and Formal Concept Analysis is suggested in this paper. The base of domain OLAP modeling is considered.  ...  The construction of an analytical model with expert knowledge as a lattice of formal cube-concepts is described formally.  ...  OLAP-modeling of domain OLAP-modeling of the domain is constructed based on the integral schema of multidimensional data. The model score is a vocabulary of special terms.  ... 
doi:10.1016/j.procs.2010.04.259 fatcat:l7vbsv47gzd2hnsrthqbyp4pnu
« Previous Showing results 1 — 15 out of 2,047 results