145 Hits in 4.0 sec

External vs. Internal: An Essay on Machine Learning Agents for Autonomous Database Management Systems

Andrew Pavlo, Matthew Butrovich, Ananya Joshi, Lin Ma, Prashanth Menon, Dana Van Aken, Lisa Lee, Ruslan Salakhutdinov
2019 IEEE Data Engineering Bulletin  
To overcome this problem, recent research has explored using machine learning-based (ML) agents for automated tuning of DBMSs.  ...  The limitless number of possible ways to configure database management systems (DBMSs) has rightfully earned them the reputation of being difficult to manage and tune.  ...  Acknowledgments This work was supported (in part) by the National Science Foundation Intel Science and Technology Center for Visual Cloud Systems, Google Research Grants, AWS Cloud Credits for Research  ... 
dblp:journals/debu/PavloBJMMALS19 fatcat:oylv6b6kfzbc5flle4ddlf2bl4

Self-Managing Technology in Database Management Systems [chapter]

Surajit Chaudhuri, Benoit Dageville, Guy Lohman
2004 Proceedings 2004 VLDB Conference  
consistently Architectural Trade-Offs (1 of 2) • What granularity for such "autonomic elements"?  ...  ) • Dynamic storage provisioning • Performance tuning -How automate determination of poor performers? -How dynamically re-configure system in response to load changes?  ... 
doi:10.1016/b978-012088469-8.50116-9 dblp:conf/vldb/ChaudhuriDL04 fatcat:mp5e3vjtcfh4vbflajpj6z744m

Resource Selection for Autonomic Database Tuning

Jeong Seok Oh, Sang Ho Lee
2005 21st International Conference on Data Engineering Workshops (ICDEW'05)  
Database administrators should be aware of resource usages to maintain database system performance.  ...  Autonomic database tuning becomes more important than ever. This paper starts with an analysis on how resource usages respond by changing resource sizes in database systems.  ...  [18] proposed the RElational Database Workload AnalyzeR (REDWAR) that is a tool for analyzing workload characteristics in relational DBMSs.  ... 
doi:10.1109/icde.2005.274 dblp:conf/icde/OhL05 fatcat:w2sxrlkxyjbevkca4n7tklztbq

Using economic models to allocate resources in database management systems

Mingyi Zhang, Patrick Martin, Wendy Powley, Paul Bird
2008 Proceedings of the 2008 conference of the center for advanced studies on collaborative research meeting of minds - CASCON '08  
for the workloads.  ...  Resource allocation in database management systems is a performance management process in which an autonomic DBMS makes resource allocation decisions based on properties like workload business importance  ...  ., Toronto, Ontario, Canada, Natural Science and Engineering Council (NSERC) of Canada, and Ontario Centre of Excellence for Communication and Information Technology (OCE-CCIT). About the Author  ... 
doi:10.1145/1463788.1463814 dblp:conf/cascon/ZhangMPB08 fatcat:2cwxacmywbderhts7ao2gvs2wy

Implementation of an Agent Architecture for Automated Index Tuning

R.L. de Carvalho Costa, S. Lifschitz, M.F. de Noronha, M.A. Vaz Salles
2005 21st International Conference on Data Engineering Workshops (ICDEW'05)  
Finally, we explain the way our hypothetical indexes are integrated in PostgreSQL and how they can be used in practice for automated index tuning.  ...  We focus in this paper on the automatic tuning feature, particularly manipulation of indexes. The architectural approach considered here is based on software agents.  ...  We are mainly concerned here with a particular kind of autonomic behavior: automated index tuning.  ... 
doi:10.1109/icde.2005.228 dblp:conf/icde/CostaLNS05 fatcat:p3kqycevbvf2lcunbzu3ntitxy

Multi-Tier Buffer Management and Storage System Design for Non-Volatile Memory [article]

Joy Arulraj, Andy Pavlo, Krishna Teja Malladi
2019 arXiv   pre-print
Given this, we present a technique for adapting these optimizations to achieve a near-optimal buffer management policy for an arbitrary workload and storage hierarchy without requiring any manual tuning  ...  The design of the buffer manager in database management systems (DBMSs) is influenced by the performance characteristics of volatile memory (DRAM) and non-volatile storage (e.g., SSD).  ...  NVM-Aware Buffer Management in DBMSs: Renen et al. present a NVM-aware multi-tier buffer manager that eagerly migrates data from SSD to DRAM [56] .  ... 
arXiv:1901.10938v1 fatcat:rsycwz7pwnhj3ageoc2fx4ojpi

PULSATINGSTORE: An Analytic Framework for Automated Storage Management

Lin Qiao, D. Agrawal, A.E. Abbadi, B.R. Iyer
2005 21st International Conference on Data Engineering Workshops (ICDEW'05)  
In this paper, we present a novel analytic framework, PULSATINGSTORE, for autonomically managing the storage to balance the cost and performance in an online manner.  ...  Self-management of large information technology components, such as DBMSs, has emerged as one important problem in the area of autonomic computing.  ...  Therefore, the storage layer needs to respond to the workload from the higher layers in DBMSs, and adapt the data layout accordingly to achieve the required IO performance. • Online maintenance tasks.  ... 
doi:10.1109/icde.2005.271 dblp:conf/icde/QiaoAAI05 fatcat:kb3hscxt2fbirpcwfnmngxhisy

GPU-Accelerated Database Systems: Survey and Open Challenges [chapter]

Sebastian Breß, Max Heimel, Norbert Siegmund, Ladjel Bellatreche, Gunter Saake
2014 Lecture Notes in Computer Science  
Based on this survey, we present key properties, important trade-offs and typical challenges of GPU-aware database architectures, and identify major open challenges.  ...  Additionally, we survey existing GPU-accelerated DBMSs and classify their architectural properties. Then, we summarize typical optimizations implemented in GPU-accelerated DBMSs.  ...  We discuss eight GPU-accelerated DBMSs (GDBMSs) to review the stateof-the-art, collect prominent findings, and complement our discussion on a GPU-aware DBMS architecture. 2.  ... 
doi:10.1007/978-3-662-45761-0_1 fatcat:rpwqxejbkjh6dhzp27ppiawzsu

Distributed transactions in practice

Prabhu Ram, Lyman Do, Pamela Drew
1999 SIGMOD record  
We will show the performance costs associated with distributed transactions and discuss ways by which enterprises really manage their distributed data to circumvent this performance hit.  ...  In large enterprises, the model for distributed database applications has moved away from the client-server model to a multi-tier model with large database application software forming the middle tier.  ...  The DBMSs were tuned identically and the database and log size were set large enough to handle our workloads without causing extent allocation during the execution of our tests.  ... 
doi:10.1145/333607.333613 fatcat:pfbtpzikajdbxjcyg3dirngw6e

ARH_Db_Tuner: The GUI Tool to Monitor and Diagnose the SGA Parameters Automatically

2013 Database Systems Journal  
Autonomic database tuning becomes more important than ever. One of the major issues to address in regards to ORACLE database performance is the size of the database.  ...  Database administrators should be aware of resource usages to maintain database system performance.  ...  Other terms used in the literature for an autonomic DBMS are selftuning DBMSs [3] and no knobs operation [4] .  ... 
doaj:ab0f664dc869485fa9bb32fa0740ee66 fatcat:54htn7gxhvgg3djd43uvw2qcau

Power-Aware Throughput Control for Database Management Systems

Zichen Xu, Xiaorui Wang, Yi-Cheng Tu
2013 IEEE International Conference on Autonomic Computing  
Performance has been traditionally regarded as the most important design goal for database management systems (DBMSs).  ...  In this paper, we present Power-Aware Throughput control (PAT), an online feedback control framework for energy conservation at the DBMS level.  ...  Acknowledgement We would like to thank the anonymous reviewers for their valuable comments.  ... 
dblp:conf/icac/XuWT13 fatcat:qurdkramfbfp7k7uliulpleo3q

Toward autonomic computing with DB2 universal database

Sam S. Lightstone, Guy Lohman, Danny Zilio
2002 SIGMOD record  
the total cost of ownership (TCO) of DBMSs and improve system performance.  ...  This paper describes the self-managing or autonomic technology in IBM's DB2 Universal Database ® for UNIX and Windows to illustrate how self-managing technology can reduce complexity, helping to reduce  ...  These early results suggest that autonomic performance configuration is an achievable goal in the near future for an important class of database workloads.  ... 
doi:10.1145/601858.601873 fatcat:3ptnwhni2bepnf7ebhxgc5z3na


Vishal Sharma, Curtis Dyreson
2022 Proceedings of the 37th ACM/SIGAPP Symposium on Applied Computing  
There is a growing need for a database with an ability to learn and adapt to evolving workloads. This paper proposes Indexer++, an autonomous, workload-aware, online index tuner.  ...  Phase (ii) performs online, i.e., continuous or while the DBMS is processing workloads, index selection using a novel online deep reinforcement learning technique using our proposed priority experience  ...  DBI-1759965, Collaborative Research: ABI Development: Symbiota2: Enabling greater collaboration and flexibility for mobilizing biodiversity data.  ... 
doi:10.1145/3477314.3507691 fatcat:5r2zxxioybc7jausbethdkigfa

A Novel Optimized Case-based Reasoning approach with K-means Clustering and Genetic Algorithm for Predicting Multi-class Workload Characterization in Autonomic Database and Data Warehouse System

Nusrat Shaheen, Basit Raza, Ahmad Raza Shahid, Hani Alquhayz
2020 IEEE Access  
Performance of these systems can be improved by making the systems well-aware about the workload entering into the system.  ...  Due to increase in data volume, and its complexities, it has become more challenging job for workload management system to maintain its performance.  ...  Autonomic configuration and tuning of systems mainly depends upon workload characterization for the adjustment of parameters.  ... 
doi:10.1109/access.2020.3000139 fatcat:bnfgwqx6dvbqdexr4st4h3qzbm

The Lowell database research self-assessment

Serge Abiteboul, Dieter Gawlick, Jim Gray, Laura Haas, Alon Halevy, Joe Hellerstein, Yannis Ioannidis, Martin Kersten, Michael Pazzani, Mike Lesk, David Maier, Rakesh Agrawal (+17 others)
2005 Communications of the ACM  
that database researchers increase focus on: integration of text, data, code, and streams; fusion of information from heterogeneous data sources; reasoning about uncertain data; unsupervised data mining for  ...  First, current DBMSs have a large collection of tuning knobs. These allow an expert to extract the best performance from an operational system.  ...  Instead, they have seen many system configurations and workloads and carry a "crib sheet" of tuning parameters that had optimized other systems.  ... 
doi:10.1145/1060710.1060718 fatcat:naxq6qa3ovfophnd3o72pmbfyy
« Previous Showing results 1 — 15 out of 145 results