On the Integration of Array and Relational Models in Databases

  • Array databases are a quickly expanding category of database management systems that treat large multidimensional arrays as first-class database citizens. Array data itself is almost always linked to additional, non-array information, but this is not adequately handled in today’s systems. Array databases specialize in the management of array data, while other systems, e.g. relational DBMS, have at best only very basic support for arrays. As a result, handling array data in practice most often requires either multiple DBMS with manual data integration and synchronization, or dedicated solutions constrained to a narrow domain. This thesis addresses this situation by extending the relatonal data model with support for multidimensional arrays in a non-intrusive way that is orthogonal to its set semantics. The array model itself is declarative, optimizable, and minimal, yet powerful enough for application domains in science, engineering, and business. The algebraic formalization is materialized into an official standard ISO SQL extension known as SQL/MDA. A proof of concept mediator implementation of SQL/MDA – utilizing a new array processing engine optimized for modern hardware and a standard relational DBMS – demonstrates practical feasibility of the established concepts. All in all, this thesis covers in completeness the topic of array / relation integration in databases and presents a theoretically sound and practically viable solution.

Download full text

Cite this publication

  • Export Bibtex
  • Export RIS

Citable URL (?):

Search for this publication

Search Google Scholar Search Catalog of German National Library Search OCLC WorldCat Search Catalog of GBV Common Library Network Search Catalog of Jacobs University Library Search Bielefeld Academic Search Engine
Meta data
Publishing Institution:IRC-Library, Information Resource Center der Jacobs University Bremen
Granting Institution:Jacobs Univ.
Author:Dimitar Mišev
Referee:Michael Sedlmair, Tore Risch, Heinrich Stamerjohanns
Advisor:Peter Baumann
Persistent Identifier (URN):urn:nbn:de:gbv:579-opus-1008050
Document Type:PhD Thesis
Language:English
Date of Successful Oral Defense:2018/05/15
Date of First Publication:2018/05/28
Academic Department:Computer Science & Electrical Engineering
PhD Degree:Computer Science
Focus Area:Mobility
Call No:Thesis 2018/8

$Rev: 13581 $