Identifying New Directions in Database Performance Tuning

COLLEY, Derek and STANIER, Clare (2017) Identifying New Directions in Database Performance Tuning. Procedia Computer Science, 121. pp. 260-265. ISSN 1877-0509

Preview

Text New Directions in Database Tuning Accepted Version.pdf - AUTHOR'S ACCEPTED Version (default) Available under License Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International (CC BY-NC-ND 4.0). Download (224kB) | Preview

Abstract or description

Database performance tuning is a complex and varied active research topic. With enterprise relational database management systems still reliant on the same set-based relational concepts that defined early data management products, the disparity between the object-oriented application development model and the object-relational database model, called the object-relational impedance mismatch problem, is addressed by techniques such as object-relational mapping (ORM). However, this has resulted in generally poor query performance for SQL developed by object applications and an irregular fit with cost-based optimisation algorithms, and leads to questions about the need for the relational model to better adapt to ORM-generated queries. This paper discusses database performance optimisation developments and seeks to demonstrate that current database performance tuning approaches need re-examination. Proposals for further work include exploring concepts such as dynamic schema redefinition; query analysis and optimisation modelling driven by machine learning; and augmentation or replacement of the cost-based optimiser model.

Item Type:	Article
Uncontrolled Keywords:	Database; SQL; performance tuning; cost-based optimiser; object-relational mapping; object-relational impedance mismatch
Faculty:	School of Digital, Technologies and Arts > Computer Science, AI and Robotics
Event Title:	Centeris17 9th International Conference on Enterprise Information Systems
Event Location:	Barcelona
Event Dates:	8-10 Nov 2017
Depositing User:	Library STORE team
Date Deposited:	30 Jul 2018 10:04
Last Modified:	24 Feb 2023 13:51
URI:	https://eprints.staffs.ac.uk/id/eprint/4617

Actions (login required)

View Item