A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2022; you can also visit the original URL.
The file type is application/pdf
.
Filters
Proteus: Autonomous Adaptive Storage for Mixed Workloads
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
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]
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
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]
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
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]
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
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
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
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
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
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
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
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]
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