Staffordshire University logo
STORE - Staffordshire Online Repository

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

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

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