Staffordshire University logo
STORE - Staffordshire Online Repository

Identifying New Directions in Database Performance Tuning

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

[img]
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 License.

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
Faculty: School of Computing and Digital Technologies > Computing
Depositing User: Library STORE team
Date Deposited: 30 Jul 2018 10:04
Last Modified: 03 Sep 2018 15:02
URI: http://eprints.staffs.ac.uk/id/eprint/4617

Actions (login required)

View Item View Item

DisabledGo Staffordshire University is a recognised   Investor in People. Sustain Staffs
Legal | Freedom of Information | Site Map | Job Vacancies
Staffordshire University, College Road, Stoke-on-Trent, Staffordshire ST4 2DE t: +44 (0)1782 294000