A Decision Support Method for Evaluating Database Designs

Erki Eessaar1 and Marek Soobik1

  1. Department of Informatics, Tallinn University of Technology
    Raja 15, 12618 Tallinn, Estonia
    eessaar@staff.ttu.ee, mareksoobik@gmail.com

Abstract

It is possible to produce different database designs based on the same set of requirements to a database. In this paper, we present a decision support method for comparing different database designs and for selecting one of them as the best design. Each data model is an abstract language that can be used to create many different databases. The proposed method is flexible in the sense that it can be used in case of different data models, criteria, and designs. The method is based on the Analytic Hierarchy Process and uses pairwise comparisons. We also present a case study about comparing four designs of SQL databases in case of PostgreSQL� database management system. The results depend on the context where the designs will be used. Hence, we evaluate the designs in case of two different contexts � management of measurements data and an online transaction processing system.

Key words

database design, decision support, Analytic Hierarchy Process, object-relational database, SQL

Digital Object Identifier (DOI)

https://doi.org/10.2298/CSIS100929039E

Publication information

Volume 9, Issue 1 (January 2012)
Year of Publication: 2012
ISSN: 1820-0214 (Print) 2406-1018 (Online)
Publisher: ComSIS Consortium

Full text

DownloadAvailable in PDF
Portable Document Format

How to cite

Eessaar, E., Soobik, M.: A Decision Support Method for Evaluating Database Designs. Computer Science and Information Systems, Vol. 9, No. 1, 81-106. (2012)