Outer-Tuning: an integration of rules, ontology and RDBMS
Authors: 
Rafael Pereira de Oliveira, Fernanda Baião, Ana Carolina Almeida, Daniel Schwabe, Sérgio LifschitzAuthors Info & Claims
Rafael Pereira de Oliveira, Fernanda Baião, Ana Carolina Almeida, Daniel Schwabe, Sérgio LifschitzAuthors Info & ClaimsArticle No.: 60, Pages 1 - 8
Abstract
Database tuning is a crucial task to address the performance of information systems that deal with a considerable amount of information stored in databases. Current tuning tools are very platform-specific and do not provide adequate support for the database administrator to reason about performance improvement suggestions. In this paper, we discuss several architectural and implementation decisions of Outer-Tuning, our framework that supports database tuning. Outer-Tuning follows a model-driven development and a modular architecture design, which enabled several benefits. This paper contributes with: (i) the architectural design model adopted in Outer-Tuning, which combines imperative and declarative programming; (ii) the discussions and steps to integrate several software components; and (iii) the actual framework implementation. We assess our framework with an experiment using the TPC-H benchmark. The results evidence that Outer-Tuning infers useful tuning actions and supports the DBA by providing a more semantic environment to create and adapt tuning heuristics using concepts closer to his/her domain, and also relevant information on the rationale of the tuning actions through a friendly web interface.
References
[1]
Sanjay Agrawal, Eric Chu, and Vivek Narasayya. 2006. Automatic physical design tuning. In Proceedings of the 2006 ACM SIGMOD international conference on Management of data - SIGMOD '06. ACM Press, NY, USA, 683.
[2]
Ana Carolina Almeida. 2013. Framework para apoiar a sintonia fina de banco de dados. Ph.D. Dissertation. Pontifícia Universidade Católica do Rio de Janeiro -PUC-RIO.
[3]
Kamel Aouiche, Pierre-Emmanuel Jouve, and Jérôme Darmont. 2006. Clustering-based Materialized View Selection in Data Warehouses. In 10th E.E. Conf. on Advances in Databases and Information Systems (ADBIS'06). Springer-Verlag, Berlin, Heidelberg, 81--95.
[4]
Leonardo Azevedo, Fernanda Baião, Flávia Santoro, Jairo Souza, Kate Revoredo, Vinícios Pereira, and Isolda Herlain. 2009. Identificação de Serviços a partir da Modelagem de Processos de Negócio. Anais SBSI 3 (10 2009).
[5]
Melyssa Barata, Jorge Bernardino, and Pedro Furtado. 2015. An Overview of Decision Support Benchmarks: TPC-DS, TPC-H and SSB. In New Contributions in Information Systems and Technologies, Alvaro Rocha, Ana Maria Correia, Sandra Costanzo, and Luis Paulo Reis (Eds.). Springer, Cham, 619--628.
[6]
A W Brown and K C Wallnau. 1996. Engineering of Component Based Systems. In Component-Based Software Engineering. Symposium on Component-Based Software Engineering (CBSE), Sweden, 7--15.
[7]
G.K.Y. Chan, Q. Li, and L. Feng. 2001. Optimized Design of Materialized Views in a Real-Life Data Warehousing Environment. International Journal of Information Technology 7, 1 (2001), 30--54. http://doc.utwente.nl/63232/
[8]
Surajit Chaudhuri and Gerhard Weikum. 2006. Foundations of Automated Database Tuning. In Proceedings of the 32Nd International Conference on Very Large Data Bases (VLDB '06). VLDB Endowment, Seoul, Korea, 1265.
[9]
Roozbeh Derakhshan and FKHA Dehne. 2006. Simulated Annealing for Materialized View Selection in Data Warehousing Environment. In IASTED Intl. Conf. on Database and applications. 89--94.
[10]
Mohamed Fayad, D C Schmidt, and R E Johnson. 1999. Building application frameworks: object-oriented foundations of framework design. Wiley, NY, USA.
[11]
Tom Gruber. 2009. Ontology. Springer US, Boston, MA, 1963--1965.
[12]
AY Halevy. 2001. Answering queries using views: A survey. The VLDB Journal 294, August 1999 (2001), 270--294.
[13]
ISO. 2018. ISO: Database languages - SQL. http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=53681
[14]
Michael Lawrence. 2006. Multiobjective genetic algorithms for materialized view selection in OLAP data warehouses. In GECCO '06. ACM Press, 699.
[15]
Xin Li, Xu Qian, Junlin Jiang, and Ziqiang Wang. 2010. Shuffled Frog Leaping Algorithm for Materialized Views Selection. Intl. Workshop Education Technology and Computer Science (2010), 7--10.
[16]
Alexander Maedche and Steffen Staab. 2001. Ontology Learning for the Semantic Web. IEEE Intelligent Systems 16, 2 (2001), 72--79.
[17]
Juliano Lopes De Oliveira, Luiz Fernando, Batista Loja, Sofia Larissa, Valdemar Vicente, and Graciano Neto. 2011. Um Componente para Gerência de Processos de Negócio em Sistemas de Informação. VII Simpósio Brasileiro de Sistemas de Informação 1, VII (2011), 250--261.
[18]
Rafael Pereira Oliveira. 2015. Sintonia Fina Baseada em Ontologia: o caso de visões materializadas. Master's thesis. Pontifícia Universidade Católica do Rio de Janeiro - PUC-RIO.
[19]
Jiratta Phuboon-ob and Raweewan Auepanwiriyakul. 2007. Selecting Materialized Views Using Two-Phase Optimization with Multiple View Processing Plan. Intl. Journal of Computer & Information Science & Engine (2007), 166--171.
[20]
R Ramakrishnan and J Gehrke. 2003. Database Management Systems. McGraw-Hill Education, New York, NY, USA.
[21]
Johannes Sametinger. 1997. Software Engineering with Reusable Components. Springer-Verlag, Berlin, Heidelberg. http://link.springer.com/10.1007/978-3-662-03345-6
[22]
D Shasha and P Bonnet. 2002. Database Tuning: Principles, Experiments, and Troubleshooting Techniques (1 ed.). Elsevier Science, New York, NY, USA.
[23]
Rada Shirkova. 2011. Materialized Views. Foundations and Trends® in Databases 4, 4 (2011), 295--405.
[24]
A Silberschatz, H F Korth, and S Sudarshan. 2010. Database System Concepts. McGraw-Hill Higher Education, New York, NY, USA.
[25]
Xia Sun and Ziqiang Wang. 2009. An Efficient Materialized Views Selection Algorithm Based on PSO. In Intl. Intelligent Systems and Applications. Ieee, 1--4.
[26]
S.H. Talebian and S. Abdul Kareem. 2009. Using Genetic Algorithm to Select Materialized Views Subject to Dual Constraints. In 2009 International Conference on Signal Processing Systems. 633--638.
[27]
Transaction Processing Performance Council. 2018. TPC-H. http://www.tpc.org/tpch/
[28]
T.V. Vijay Kumar and Santosh Kumar. 2012. Materialized View Selection Using Genetic Algorithm. In Contemporary Computing. Vol. 306. Springer Berlin Heidelberg, 225--237.
[29]
T.V. Vijay Kumar and Santosh Kumar. 2013. Materialized View Selection Using Iterative Improvement. In Advances in Computing and Information Technology. Vol. 178. Springer Berlin Heidelberg, 205--213.
[30]
T V Vijay Kumar, Mohammad Haider, and Santosh Kumar. 2010. Proposing Candidate Views for Materialization. Information Systems, Technology and Management 54 (2010), 89--98.
[31]
Zhang Yuhang, Liu Qi, and Yang Wei. 2010. Materialized view selection algorithm CSSA VSP. In Computational Intelligence and Natural Computing Proceedings (CINC), Vol. 1. 68--71.
[32]
Lijuan Zhou, Min Xu, Qian Shi, and Zhongxiao Hao. 2008. Research on Materialized Views Technology in Data Warehouse. 2008 IEEE International Symposium on Knowledge Acquisition and Modeling Workshop -, - (dec 2008), 1030--1035.
Index Terms
- Outer-Tuning: an integration of rules, ontology and RDBMS
Recommendations
Design of the Outer-tuning framework: self-tuning and ontology for relational databases
SBSI '15: Proceedings of the annual conference on Brazilian Symposium on Information Systems: Information Systems: A Computer Socio-Technical Perspective - Volume 1In this paper, we discuss the architectural project and construction of a framework called Outer-Tuning, which supports (semi) automatic tuning of database systems through a specific ontology. The architectural aspects componentbased, interface design, ...
Demonstrating λ-Tune: Exploiting Large Language Models for Workload-Adaptive Database System Tuning
SIGMOD/PODS '24: Companion of the 2024 International Conference on Management of DataWe demonstrate λ-Tune, a tool that leverages Large Language Models (LLMs) for automated, workload-adaptive database system tuning. λ-Tune harnesses the ability of LLMs to process and comprehend arbitrary textual data in a zero-shot manner, employing a ...
Comments
Information & Contributors
Information
Published In
May 2019
623 pages
ISBN:9781450372374
DOI:10.1145/3330204
Copyright © 2019 ACM.
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]
In-Cooperation
- SBC: Brazilian Computer Society
Publisher
Association for Computing Machinery
New York, NY, United States
Publication History
Published: 20 May 2019
Check for updates
Author Tags
Qualifiers
- Research-article
- Research
- Refereed limited
Conference
SBSI'19
Acceptance Rates
Overall Acceptance Rate 181 of 557 submissions, 32%
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- 0Total Citations
- 65Total Downloads
- Downloads (Last 12 months)6
- Downloads (Last 6 weeks)0
Reflects downloads up to 11 Aug 2024
Other Metrics
Citations
Cited By
View allView Options
Get Access
Login options
Check if you have access through your login credentials or your institution to get full access on this article.
Sign in