Filters








467 Hits in 4.6 sec

FAS — a Freshness-Sensitive Coordination Middleware for a Cluster of OLAP Components [chapter]

Uwe Röhm, Klemens Böhm, Hans-Jörg Schek, Heiko Schuldt
2002 VLDB '02: Proceedings of the 28th International Conference on Very Large Databases  
It schedules and routes updates and queries to cluster nodes, aiming at a high throughput of OLAP queries.  ...  With our approach, clients submit a query together with an explicit freshness limit as a new Quality-of-Service parameter. Our architecture is a cluster of databases.  ...  This work is part of the PowerDB cluster project currently conducted by the database research group at ETH Zurich. This project is partially sponsored by Microsoft Research.  ... 
doi:10.1016/b978-155860869-6/50072-x dblp:conf/vldb/RohmBSS02 fatcat:r7hlxsbxhzaotoqms7fsmjuqfe

ES2: A cloud data storage system for supporting both OLTP and OLAP

Yu Cao, Chun Chen, Fei Guo, Dawei Jiang, Yuting Lin, Beng Chin Ooi, Hoang Tam Vo, Sai Wu, Quanqing Xu
2011 2011 IEEE 27th International Conference on Data Engineering  
Intrigued by such an observation, we have designed and implemented epiC, an elastic power-aware data-itensive Cloud platform for supporting both data intensive analytical operations (ref. as OLAP) and  ...  While such operations may take place in the same domain, the design and development of the systems have somehow evolved independently for transactional and periodical analytical processing.  ...  ACKNOWLEDGMENT The work in this paper was in part supported by the Singapore Ministry of Education Grant No. R-252-000-394-112 under the project name of Utab.  ... 
doi:10.1109/icde.2011.5767881 dblp:conf/icde/CaoCGJLOVWX11 fatcat:jndlwocdvrfoljhacn5pdjypm4

OLAP Query Evaluation in a Database Cluster: A Performance Study on Intra-Query Parallelism [chapter]

Fuat Akal, Klemens Böhm, Hans-Jörg Schek
2002 Lecture Notes in Computer Science  
Moreover, we provide a classification of OLAP queries, which is used to decide, whether and how a query should be parallelized.  ...  In the first phase, the coordination infrastructure decomposes a query into subqueries and ships them to appropriate cluster nodes.  ...  Fig. 2 Query Evaluation in a Database Cluster This section describes our investigation of the parallelization characteristics of OLAP queries.  ... 
doi:10.1007/3-540-45710-0_18 fatcat:tem2be3ihvfj7ojgzjlt57h4w4

Providing Scalable Database Services on the Cloud [chapter]

Chun Chen, Gang Chen, Dawei Jiang, Beng Chin Ooi, Hoang Tam Vo, Sai Wu, Quanqing Xu
2010 Lecture Notes in Computer Science  
The processing of large-scale analytical jobs in epiC adopts a phase-based processing strategy, which provides a fine-grained fault tolerance, while the processing of queries adopts indexing and filter-andrefine  ...  referred as OLAP and OLTP respectively).  ...  Acknowledgement: We would like to thank other team members from National University of Singapore and Zhejiang University for their valuable contributions, and we would also like to thank Divyakant Agrawal  ... 
doi:10.1007/978-3-642-17616-6_1 fatcat:vxojjhaguzbn3bdiphoqnor5pi

Memory-aware sizing for in-memory databases

Karsten Molka, Giuliano Casale, Thomas Molka, Laura Moore
2014 2014 IEEE Network Operations and Management Symposium (NOMS)  
We combine these approximations with a non-linear optimization program to minimize memory swapping in in-memory database clusters.  ...  In-memory database systems are among the technological drivers of big data processing. In this paper we apply analytical modeling to enable efficient sizing of in-memory databases.  ...  in inmemory database clusters.  ... 
doi:10.1109/noms.2014.6838359 dblp:conf/noms/MolkaCMM14 fatcat:yhhsklbnqzbm7fr5easpjgja6m

Towards scalable real-time analytics

Anil K. Goel, Wolfgang Lehner, Jeffrey Pound, Nathan Auch, Peter Bumbulis, Scott MacLean, Franz Färber, Francis Gropengiesser, Christian Mathis, Thomas Bodner
2015 Proceedings of the VLDB Endowment  
We advocate the decoupling of core database components such as query processing, concurrency control, and persistence, a design choice made possible by advances in highthroughput low-latency networks and  ...  We present an overview of our work on the SAP HANA Scale-out Extension, a novel distributed database architecture designed to support large scale analytics over realtime data.  ...  We would also like to thank Adrian Nicoara for valuable discussions and contributions during his internship.  ... 
doi:10.14778/2824032.2824069 fatcat:l5e333puhveknacqp2bc2r75t4

Operational analytics data management systems

Alexander Böhm, Jens Dittrich, Niloy Mukherjee, Ippokratis Pandis, Rajkumar Sen
2016 Proceedings of the VLDB Endowment  
MemSQL is a distributed database designed to handle OLTP, OLAP and real-time streaming workloads with subsecond processing times in a single scalable database.  ...  This includes, among others: • Physical data storage (row-based, column-oriented, or hybrid) and different access paths • Design choices for corresponding runtime systems (e.g. efficient query execution  ... 
doi:10.14778/3007263.3007319 fatcat:njsofcfmhjcxpgxvzolzogc53u

Scalability and resource usage of an OLAP benchmark on clusters of PCs

Michela Taufer, Thomas Stricker, Roger Weber
2002 Proceedings of the fourteenth annual ACM symposium on Parallel algorithms and architectures - SPAA '02  
Designing clusters of PCs for distributed databases processing OLAP (On Line Analytical Processing) workloads in parallel with good scalability remains a particular challenge as we are lacking a deep understanding  ...  A systematic performance evaluation constitutes a solid basis for architectural decisions and system optimization in clusters of PCs that are dedicated to large parallel database systems.  ...  In our first approach for a parallel processing of OLAP database workloads, we used the mechanism of ORACLE database links to ship data from the nodes to the coordinator in the cluster.  ... 
doi:10.1145/564870.564882 dblp:conf/spaa/TauferSW02 fatcat:a6tf6fejmzabrfa7gcz2nbnc3a

Scalability and resource usage of an OLAP benchmark on clusters of PCs

Michela Taufer, Thomas Stricker, Roger Weber
2002 Proceedings of the fourteenth annual ACM symposium on Parallel algorithms and architectures - SPAA '02  
Designing clusters of PCs for distributed databases processing OLAP (On Line Analytical Processing) workloads in parallel with good scalability remains a particular challenge as we are lacking a deep understanding  ...  A systematic performance evaluation constitutes a solid basis for architectural decisions and system optimization in clusters of PCs that are dedicated to large parallel database systems.  ...  In our first approach for a parallel processing of OLAP database workloads, we used the mechanism of ORACLE database links to ship data from the nodes to the coordinator in the cluster.  ... 
doi:10.1145/564879.564882 fatcat:mnye3ud3krc77f3jlwmh4cr7hi

Minimizing the MOLAP/ROLAP Divide: You Can Have Your Performance and Scale It Too

Todd Eavis, Ahmad Taleb
2013 Journal of Computing Science and Engineering  
Specifically, it utilizes an OLAP algebra coupled with a domain specific query optimizer, to map user queries directly to the storage and indexing framework.  ...  Based upon a combination of R-trees and bitmap indexes, the storage engine has been integrated with a robust OLAP query engine prototype that is able to fully exploit the efficiency of the proposed storage  ...  Specifically, its query optimizer is designed http://jcse.kiise.org to accept and optimize native OLAP operations (as described in the next section).  ... 
doi:10.5626/jcse.2013.7.1.1 fatcat:26pyagf7wzcdfox2rlbpxlacsy

Relax and Let the Database Do the Partitioning Online [chapter]

Alekh Jindal, Jens Dittrich
2012 Lecture Notes in Business Information Processing  
This is because the DBA has to understand the physical query execution plans for each query in the workload very well to make appropriate design decisions.  ...  This means, the physical design cannot be changed without human intervention.  ...  Introduction Physical database designs have been researched heavily in the past [23, 3, 2, 5, 6, 31, 7, 22, 26, 12] .  ... 
doi:10.1007/978-3-642-33500-6_5 fatcat:xut3lhp6abdl5kiev7hi4badb4

Securing Manufacturing Intelligence for the Industrial Internet of Things [article]

Hussain Al-Aqrabi and Richard Hill and Phil Lane and Hamza Aagela
2019 arXiv   pre-print
In conclusion, a hybrid security model is proposed where security controls are segregated into a multi-cloud architecture.  ...  Often, analytics processing for Business Intelligence (BI) is an intensive task, and it also presents both an opportunity for competitive advantage as well as a security vulnerability in terms of the potential  ...  necessary query brokering and routing services.  ... 
arXiv:1901.07284v1 fatcat:3jik4arbczcz7ggtwfbfzwfw3y

Adaptive HTAP through Elastic Resource Scheduling [article]

Aunn Raza, Periklis Chrysogelos, Angelos Christos Anadiotis, Anastasia Ailamaki
2020 arXiv   pre-print
We propose an in-memory system design which is non-intrusive to the current state-of-art OLTP and OLAP engines, and we use it to evaluate the performance of our approach.  ...  HTAP systems typically consider data freshness at design time, and are optimized for a fixed range of freshness requirements, addressed at a performance cost for either OLTP or OLAP.  ...  ACKNOWLEDGMENTS We would like to thank the reviewers and the shepherd for their valuable feedback.  ... 
arXiv:2004.05437v2 fatcat:ymqitu6q2rbetiwsbgosatamxe

The OLAP-Enabled Grid: Model and Query Processing Algorithms

M. Lawrence, A. Rau-Chaplin
2006 20th International Symposium on High-Performance Computing in an Advanced Collaborative Environment (HPCS'06)  
We show how a Grid computing infrastructure can be used to store and manage expensive to compute data aggregations and to answer OLAP queries in a fully distributed manner.  ...  In this paper, we present a model and algorithmic framework for an "OLAP-Enabled Grid" whose goal is the efficient support of OLAP operations.  ...  The reason is that a well designed caching strategy will not cache data from local OLAP servers, since it is much easier to get and as a result much less valuable than data from remote OLAP servers.  ... 
doi:10.1109/hpcs.2006.45 dblp:conf/hpcs/LawrenceR06 fatcat:jvxk3hqxcbhgtlau2izdvhyja4

Parallel data intensive computing in scientific and commercial applications

Mario Cannataro, Domenico Talia, Pradip K Srimani
2002 Parallel Computing  
Applications that explore, query, analyze, visualize, and, in general, process very large scale data sets are known as Data Intensive Applications.  ...  The integration of parallel and distributed computational environments will produce major improvements in performance for both computing intensive and data intensive applications in the future.  ...  Gerhard Joubert for many helpful suggestions that improved the contents and the presentation of this paper.  ... 
doi:10.1016/s0167-8191(02)00091-1 fatcat:qetjnt73xrbf3eil5p6suwx4ua
« Previous Showing results 1 — 15 out of 467 results