Filters








611 Hits in 5.4 sec

Proteus: Autonomous Adaptive Storage for Mixed Workloads

Michael Abebe, Horatiu Lazu, Khuzaima Daudjee
2022 Proceedings of the 2022 International Conference on Management of Data  
for OLAP workloads.  ...  specialized for either type of workload.  ...  Ablation Study Figures Figure 9h shows the eects of the ablation study on OLAP latency.  ... 
doi:10.1145/3514221.3517834 fatcat:jdjuy2cbzjfyrhn2qusjcp5tgm

HyPer: Adapting Columnar Main-Memory Data Management for Transactional AND Query Processing

Alfons Kemper, Thomas Neumann, Florian Funke, Viktor Leis, Henrik Mühe
2012 IEEE Data Engineering Bulletin  
Two emerging hardware trends allow the consolidation of the two disparate workloads onto the same database state on one system: the increasing main memory capacities of several terabytes per server and  ...  The prevalent data representation of hybrid OLTP&OLAP main memory database systems is columnar in order to achieve best possible query execution performance for OLAP applications.  ...  Currently, users with high rates of mission-critical transactions have split their data into two separate systems, one database for OLTP and one so-called data warehouse for OLAP.  ... 
dblp:journals/debu/KemperNFLM12 fatcat:4ukbnnwt65clpm32p6gf34nj6y

Greenplum: A Hybrid Database for Transactional and Analytical Workloads [article]

Zhenghua Lyu, Huan Hubert Zhang, Gang Xiong, Haozhou Wang, Gang Guo, Jinbao Chen, Asim Praveen, Yu Yang, Xiaoming Gao, Ashwin Agrawal, Alexandra Wang, Wen Lin (+7 others)
2021 arXiv   pre-print
Greenplum database is traditionally known as an OLAP data warehouse system with limited ability to process OLTP workloads.  ...  In this paper, we augment Greenplum into a hybrid system to serve both OLTP and OLAP workloads.  ...  ACKNOWLEDGEMENTS We thank the entire VMware Greenplum team both current and alumni (Heikki Linnakangas, Ning Yu, Pengzhou Tang, etc.) for their valuable development contribution.  ... 
arXiv:2103.11080v3 fatcat:lzb4kdxaefd3rkddejrgq4fvj4

Workload management: a technology perspective with respect to self-* characteristics

Abdul Mateen, Basit Raza, Muhammad Sher, M. M. Awais, Norwatti Mustapha
2012 Artificial Intelligence Review  
The paper provides a summary of the structure and achievements of the database tools that exhibit Autonomic Computing or self-* characteristics in workload management.  ...  Finally the paper presents the research done in the database workload management tools with respect to the workload type and Autonomic Computing.  ...  Acknowledgments We are grateful to the Higher Education Commission (HEC) of Pakistan and International Islamic University, Pakistan who are supporting this research work.  ... 
doi:10.1007/s10462-012-9320-8 fatcat:h7snsxv6tfcxla53tn7ua7juxa

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 Cloud is fast gaining popularity as a platform for deploying Software as a Service (SaaS) applications.  ...  The storage system and the processing engine are loosely coupled, and have been designed to handle two types of workload simultaneously, namely data-intensive analytical jobs and online transactions (commonly  ...  for his valuable comments and the numerous discussions during the course of the implementation of epiC.  ... 
doi:10.1007/978-3-642-17616-6_1 fatcat:vxojjhaguzbn3bdiphoqnor5pi

Oracle Exalytics: Engineered for Speed-of-Thought Analytics

Gabriela GLIGOR, Silviu TEODORU
2011 Database Systems Journal  
questions with unmatched speed, intelligence, simplicity and manageability.  ...  The issue is further exasperated by the fact that most enterprise analytics solutions require dealing with a number of hardware, software, storage and networking vendors and precious resources are wasted  ...  Each processor supports 10 compute cores providing a total of 40 cores for computation. The compute power is matched with 1TB of memory to provide sufficient capacity for in-memory analytics.  ... 
doaj:6db64593b5444c9cb5e2e0b3e383f7b8 fatcat:3ejehxpfx5bc5lnk5dgkdy7gly

Monitoring Human Resources of a Public Health-Care System through Intelligent Data Analysis and Visualization [chapter]

Aleksander Pur, Marko Bohanec, Bojan Cestnik, Nada Lavra
2008 Data Mining in Medical and Biological Research  
Human resources are one of the main parts of this system. This paper is focused on the model for monitoring and planning of human resources in the Slovenian public HCS.  ...  Thus, this presentation can help planning the education system. The other process in this module provides a list of gynaecologists that are near retiring age.  ...  Conclusion The aim of the presented human resource monitoring system is to assess performance and provide information necessary for the planning and management of primary health-care network in Slovenia  ... 
doi:10.5772/6412 fatcat:ypr6ud2qtnhrpmp3df625nqt5y

On the Performance of Three In-Memory Data Systems for On Line Analytical Processing

Ionut HRUBARU, Marin FOTACHE
2017 Informatică economică  
This paper aims to test the performance of using such type of systems for TPCH analytical workloads.  ...  ) database systems.  ...  data systems must scale to handle huge amount of data and to support OLAP workloads.  ... 
doi:10.12948/issn14531305/21.1.2017.01 fatcat:xg3qzkh4wzfrxhh4dm2qji3jfm

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  
A typical data management system has to deal with real-time updates by individual users, and as well as periodical large scale analytical processing, indexing, and data extraction.  ...  Cloud computing represents a paradigm shift driven by the increasing demand of Web based applications for elastic, scalable and efficient system architectures that can efficiently support their ever-growing  ...  We would also like to thank the anonymous reviewers for their insightful comments.  ... 
doi:10.1109/icde.2011.5767881 dblp:conf/icde/CaoCGJLOVWX11 fatcat:jndlwocdvrfoljhacn5pdjypm4

HyPer: A hybrid OLTP&OLAP main memory database system based on virtual memory snapshots

Alfons Kemper, Thomas Neumann
2011 2011 IEEE 27th International Conference on Data Engineering  
Currently, customers with high rates of mission-critical transactions have split their data into two separate systems, one database for OLTP and one so-called data warehouse for OLAP.  ...  as 100000 per second and very fast OLAP query response times on a single system executing both workloads in parallel.  ...  For a default page size of 4 KB, a TB database has to manage a page table with 250 mil entries, summing up to 4 GB in size.  ... 
doi:10.1109/icde.2011.5767867 dblp:conf/icde/KemperN11 fatcat:vpn63e2w7rcf3dia3ievzf7oj4

GPU-accelerated data management under the test of time

Aunn Raza, Periklis Chrysogelos, Panagiotis Sioulas, Vladimir Indjic, Angelos Christos Anadiotis, Anastasia Ailamaki
2020 Zenodo  
Data management systems are riding the wave by using GPUs to accelerate query execution, mainly for analytical workloads.  ...  We demonstrate that the standard PCIe interconnect substantially limits the performance of state-of-the-art GPUs and we propose a hybrid materialization approach which combines eager with lazy data transfers  ...  The snapshot manager of Aeolus, pre-faults memory chunks sizing to main-data size in order to provide fresh snapshots to OLAP. For the scope of this study, we execute all OLTP workloads on CPUs.  ... 
doi:10.5281/zenodo.3827489 fatcat:wi4xpncbgjdino7r67rxoouhla

DATA WAREHOUSING APPLICATIONS: AN ANALYTICAL TOOL FOR DECISION SUPPORT SYSTEM

MOHAMMED SHAFEEQ AHMED
2014 International Journal of Computer Science and Informatics  
Both are essential elements of decision support, which has increasingly become a focus of the database industry.  ...  Data warehouses provide on-line analytical processing (OLAP) tools for the interactive analysis of multidimensional data of varied granularities, which facilitates effective data mining.  ...  Designing and rolling out a data warehouse is a complex process, consisting of the following:  Define the architecture, do capacity planning, and select the storage servers, database and OLAP servers,  ... 
doi:10.47893/ijcsi.2014.1163 fatcat:nmnqaxlhu5b2zfmzo5e7ht7fqi

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.  ...  that is sufficient for the planned work on parallel databases.  ... 
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.  ...  that is sufficient for the planned work on parallel databases.  ... 
doi:10.1145/564879.564882 fatcat:mnye3ud3krc77f3jlwmh4cr7hi

Energy and Performance-Can a Wimpy-Node Cluster Challenge a Brawny Server? [article]

Daniel Schall, Theo Härder
2014 arXiv   pre-print
A cluster of small (wimpy) servers, where the number of nodes can dynamically adjust to the current workload, might offer better energy characteristics for these workloads.  ...  Traditional DBMS servers are usually over-provisioned for most of their daily workloads and, because they do not show good energy proportionality, waste a lot of energy while underutilized.  ...  Therefore, the query plan for transactional workloads is much more rigid than OLAP queries. In summary, it is comprehensible, that a cluster of nodes is better suited for OLAP workloads than OLTP.  ... 
arXiv:1407.0386v2 fatcat:77xidtkktvfi3nxorsebc2entm
« Previous Showing results 1 — 15 out of 611 results