Flexibility in Data Management
With the ongoing expansion of information technology, new fields of application requiring data management emerge virtually every day. In our knowledge culture increasing amounts of data and work force organized in more creativity-oriented ways also radically change traditional fields of application...
Main Author: | |
---|---|
Other Authors: | |
Format: | Doctoral Thesis |
Language: | English |
Published: |
Saechsische Landesbibliothek- Staats- und Universitaetsbibliothek Dresden
2014
|
Subjects: | |
Online Access: | http://nbn-resolving.de/urn:nbn:de:bsz:14-qucosa-136681 http://nbn-resolving.de/urn:nbn:de:bsz:14-qucosa-136681 http://www.qucosa.de/fileadmin/data/qucosa/documents/13668/Dissertation-Hannes_Voigt.pdf |
id |
ndltd-DRESDEN-oai-qucosa.de-bsz-14-qucosa-136681 |
---|---|
record_format |
oai_dc |
spelling |
ndltd-DRESDEN-oai-qucosa.de-bsz-14-qucosa-1366812014-05-17T03:35:02Z Flexibility in Data Management Voigt, Hannes Datenverwaltung Datenbanksysteme relationale Datenbanksysteme Schemaflexibilität Selbstverwaltung Indizierung Partitionierung logisches Schema physisches Schema data management database systems relational database systems schema flexibility self-management partitioning indexing logical schema physical schema ddc:004 rvk:ST 270 With the ongoing expansion of information technology, new fields of application requiring data management emerge virtually every day. In our knowledge culture increasing amounts of data and work force organized in more creativity-oriented ways also radically change traditional fields of application and question established assumptions about data management. For instance, investigative analytics and agile software development move towards a very agile and flexible handling of data. As the primary facilitators of data management, database systems have to reflect and support these developments. However, traditional database management technology, in particular relational database systems, is built on assumptions of relatively stable application domains. The need to model all data up front in a prescriptive database schema earned relational database management systems the reputation among developers of being inflexible, dated, and cumbersome to work with. Nevertheless, relational systems still dominate the database market. They are a proven, standardized, and interoperable technology, well-known in IT departments with a work force of experienced and trained developers and administrators. This thesis aims at resolving the growing contradiction between the popularity and omnipresence of relational systems in companies and their increasingly bad reputation among developers. It adapts relational database technology towards more agility and flexibility. We envision a descriptive schema-comes-second relational database system, which is entity-oriented instead of schema-oriented; descriptive rather than prescriptive. The thesis provides four main contributions: (1)~a flexible relational data model, which frees relational data management from having a prescriptive schema; (2)~autonomous physical entity domains, which partition self-descriptive data according to their schema properties for better query performance; (3)~a freely adjustable storage engine, which allows adapting the physical data layout used to properties of the data and of the workload; and (4)~a self-managed indexing infrastructure, which autonomously collects and adapts index information under the presence of dynamic workloads and evolving schemas. The flexible relational data model is the thesis\' central contribution. It describes the functional appearance of the descriptive schema-comes-second relational database system. The other three contributions improve components in the architecture of database management systems to increase the query performance and the manageability of descriptive schema-comes-second relational database systems. We are confident that these four contributions can help paving the way to a more flexible future for relational database management technology. Saechsische Landesbibliothek- Staats- und Universitaetsbibliothek Dresden Technische Universität Dresden, Fakultät Informatik Prof. Dr.-Ing. Wolfgang Lehner Dr.-Ing. Christof Bornhövd 2014-03-07 doc-type:doctoralThesis application/pdf http://nbn-resolving.de/urn:nbn:de:bsz:14-qucosa-136681 urn:nbn:de:bsz:14-qucosa-136681 PPN404303455 http://www.qucosa.de/fileadmin/data/qucosa/documents/13668/Dissertation-Hannes_Voigt.pdf eng |
collection |
NDLTD |
language |
English |
format |
Doctoral Thesis |
sources |
NDLTD |
topic |
Datenverwaltung Datenbanksysteme relationale Datenbanksysteme Schemaflexibilität Selbstverwaltung Indizierung Partitionierung logisches Schema physisches Schema data management database systems relational database systems schema flexibility self-management partitioning indexing logical schema physical schema ddc:004 rvk:ST 270 |
spellingShingle |
Datenverwaltung Datenbanksysteme relationale Datenbanksysteme Schemaflexibilität Selbstverwaltung Indizierung Partitionierung logisches Schema physisches Schema data management database systems relational database systems schema flexibility self-management partitioning indexing logical schema physical schema ddc:004 rvk:ST 270 Voigt, Hannes Flexibility in Data Management |
description |
With the ongoing expansion of information technology, new fields of application requiring data management emerge virtually every day. In our knowledge culture increasing amounts of data and work force organized in more creativity-oriented ways also radically change traditional fields of application and question established assumptions about data management. For instance, investigative analytics and agile software development move towards a very agile and flexible handling of data. As the primary facilitators of data management, database systems have to reflect and support these developments. However, traditional database management technology, in particular relational database systems, is built on assumptions of relatively stable application domains. The need to model all data up front in a prescriptive database schema earned relational database management systems the reputation among developers of being inflexible, dated, and cumbersome to work with. Nevertheless, relational systems still dominate the database market. They are a proven, standardized, and interoperable technology, well-known in IT departments with a work force of experienced and trained developers and administrators.
This thesis aims at resolving the growing contradiction between the popularity and omnipresence of relational systems in companies and their increasingly bad reputation among developers. It adapts relational database technology towards more agility and flexibility. We envision a descriptive schema-comes-second relational database system, which is entity-oriented instead of schema-oriented; descriptive rather than prescriptive. The thesis provides four main contributions: (1)~a flexible relational data model, which frees relational data management from having a prescriptive schema; (2)~autonomous physical entity domains, which partition self-descriptive data according to their schema properties for better query performance; (3)~a freely adjustable storage engine, which allows adapting the physical data layout used to properties of the data and of the workload; and (4)~a self-managed indexing infrastructure, which autonomously collects and adapts index information under the presence of dynamic workloads and evolving schemas. The flexible relational data model is the thesis\' central contribution. It describes the functional appearance of the descriptive schema-comes-second relational database system. The other three contributions improve components in the architecture of database management systems to increase the query performance and the manageability of descriptive schema-comes-second relational database systems. We are confident that these four contributions can help paving the way to a more flexible future for relational database management technology. |
author2 |
Technische Universität Dresden, Fakultät Informatik |
author_facet |
Technische Universität Dresden, Fakultät Informatik Voigt, Hannes |
author |
Voigt, Hannes |
author_sort |
Voigt, Hannes |
title |
Flexibility in Data Management |
title_short |
Flexibility in Data Management |
title_full |
Flexibility in Data Management |
title_fullStr |
Flexibility in Data Management |
title_full_unstemmed |
Flexibility in Data Management |
title_sort |
flexibility in data management |
publisher |
Saechsische Landesbibliothek- Staats- und Universitaetsbibliothek Dresden |
publishDate |
2014 |
url |
http://nbn-resolving.de/urn:nbn:de:bsz:14-qucosa-136681 http://nbn-resolving.de/urn:nbn:de:bsz:14-qucosa-136681 http://www.qucosa.de/fileadmin/data/qucosa/documents/13668/Dissertation-Hannes_Voigt.pdf |
work_keys_str_mv |
AT voigthannes flexibilityindatamanagement |
_version_ |
1716667331629809664 |