The Open UniversitySkip to content
 

A Study into Best Practices and Procedures used in the Management of Database Systems

Holt, Victoria (2017). A Study into Best Practices and Procedures used in the Management of Database Systems. PhD thesis The Open University.

Full text available as:
[img]
Preview
PDF (Redacted Version of Record) - Requires a PDF viewer such as GSview, Xpdf or Adobe Acrobat Reader
Download (10MB) | Preview
Google Scholar: Look up in Google Scholar

Abstract

There has been a vast expansion of data usage in recent years. The requirements of database systems to provide a variety of information has resulted in many more types of database engines and approaches (such as cloud computing). A once simple management task has become much more complex. Challenges exist for database managers to make the best choices of practices and procedures to satisfy the requirements of organisations.

This research is aimed at understanding how the management of database systems is undertaken, how best practices and procedures form a part of the management process, and the complex nature of database systems. The study examined the adoption of best practices and how the complex interactions between components of the database system affect management and performance.

The research followed a mixed methods approach, using sequential explanatory design. The quantitative research phase, using an online survey, highlighted the breadth of issues relevant to database management. It concluded that existing practices and procedures were not optimal, and revealed some of the complexities. Based on the findings from the survey the qualitative research phase that followed utilized information from the quantitative survey to seek understanding of key areas, through a number of focus groups.

As part of this research, an innovative method was developed in which thematic analysis of the resulting data was deepened through the use of systems thinking and diagramming. Taking this holistic approach to database systems enabled a different understanding of best practices and the complexity of database systems. A ‘blueprint’, called a CODEX, was drawn up to support improvement and innovation of database systems. Based on a comprehensive assessment of the individual causal interactions between data components, a data map detailed the complex interactions.

Item Type: Thesis (PhD)
Copyright Holders: 2016 The Author
Extra Information: The version made available to the British Library is a redacted version due to third party copyright restrictions.
Keywords: database management; data usage
Academic Unit/School: Faculty of Science, Technology, Engineering and Mathematics (STEM)
Item ID: 50950
Depositing User: Victoria Emily Holt
Date Deposited: 16 Oct 2017 11:03
Last Modified: 16 Oct 2017 11:06
URI: http://oro.open.ac.uk/id/eprint/50950
Share this page:

Download history for this item

These details should be considered as only a guide to the number of downloads performed manually. Algorithmic methods have been applied in an attempt to remove automated downloads from the displayed statistics but no guarantee can be made as to the accuracy of the figures.

Actions (login may be required)

Policies | Disclaimer

© The Open University   contact the OU