SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
AutoAdmin “what-if” index analysis utility
SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
Proceedings of the 2002 ACM SIGMOD international conference on Management of data
Performance and scalability of EJB applications
OOPSLA '02 Proceedings of the 17th ACM SIGPLAN conference on Object-oriented programming, systems, languages, and applications
A smart hill-climbing algorithm for application server configuration
Proceedings of the 13th international conference on World Wide Web
Using probabilistic reasoning to automate software tuning
Proceedings of the joint international conference on Measurement and modeling of computer systems
Effective use of block-level sampling in statistics estimation
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Adaptive self-tuning memory in DB2
VLDB '06 Proceedings of the 32nd international conference on Very large data bases
Data Mining: Practical Machine Learning Tools and Techniques, Second Edition (Morgan Kaufmann Series in Data Management Systems)
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Model-driven data acquisition in sensor networks
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
A new approach to dynamic self-tuning of database buffers
ACM Transactions on Storage (TOS)
Automatic virtual machine configuration for database workloads
Proceedings of the 2008 ACM SIGMOD international conference on Management of data
SARD: A statistical approach for ranking database tuning parameters
ICDEW '08 Proceedings of the 2008 IEEE 24th International Conference on Data Engineering Workshop
Oracle Database 11g New Features
Oracle Database 11g New Features
Packing the most onto your cloud
Proceedings of the first international workshop on Cloud data management
iTuned: a tool for configuring and visualizing database parameters
Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
Xplus: a SQL-tuning-aware query optimizer
Proceedings of the VLDB Endowment
Predicting completion times of batch query workloads using interaction-aware models and simulation
Proceedings of the 14th International Conference on Extending Database Technology
MassConf: automatic configuration tuning by leveraging user community information
Proceedings of the 2nd ACM/SPEC International Conference on Performance engineering
Skyline and mapping aware join query evaluation
Information Systems
Static extraction of program configuration options
Proceedings of the 33rd International Conference on Software Engineering
Database scalability, elasticity, and autonomy in the cloud
DASFAA'11 Proceedings of the 16th international conference on Database systems for advanced applications - Volume Part I
Interaction-aware scheduling of report-generation workloads
The VLDB Journal — The International Journal on Very Large Data Bases
No one (cluster) size fits all: automatic cluster sizing for data-intensive analytics
Proceedings of the 2nd ACM Symposium on Cloud Computing
Low-overhead decision support for dynamic buffer reallocation
Computer Science - Research and Development
PerfXplain: debugging MapReduce job performance
Proceedings of the VLDB Endowment
Dynamic management of resources and workloads for RDBMS in cloud: a control-theoretic approach
PhD '12 Proceedings of the on SIGMOD/PODS 2012 PhD Symposium
Skew-aware automatic database partitioning in shared-nothing, parallel OLTP systems
SIGMOD '12 Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data
PARAS: a parameter space framework for online association mining
Proceedings of the VLDB Endowment
Rapid experimentation for testing and tuning a production database deployment
Proceedings of the 16th International Conference on Extending Database Technology
FIRE: interactive visual support for parameter space-driven rule mining
Proceedings of the 22nd ACM international conference on Conference on information & knowledge management
Proceedings of the 17th International Database Engineering & Applications Symposium
Proceedings of the Twenty-Fourth ACM Symposium on Operating Systems Principles
ACM SIGOPS 24th Symposium on Operating Systems Principles
Do not blame users for misconfigurations
Proceedings of the Twenty-Fourth ACM Symposium on Operating Systems Principles
Gunther: search-based auto-tuning of mapreduce
Euro-Par'13 Proceedings of the 19th international conference on Parallel Processing
Hi-index | 0.00 |
Database systems have a large number of configuration parameters that control memory distribution, I/O optimization, costing of query plans, parallelism, many aspects of logging, recovery, and other behavior. Regular users and even expert database administrators struggle to tune these parameters for good performance. The wave of research on improving database manageability has largely overlooked this problem which turns out to be hard to solve. We describe iTuned, a tool that automates the task of identifying good settings for database configuration parameters. iTuned has three novel features: (i) a technique called Adaptive Sampling that proactively brings in appropriate data through planned experiments to find high-impact parameters and high-performance parameter settings, (ii) an executor that supports online experiments in production database environments through a cycle-stealing paradigm that places near-zero overhead on the production workload; and (iii) portability across different database systems. We show the effectiveness of iTuned through an extensive evaluation based on different types of workloads, database systems, and usage scenarios.