A decision support method for evaluating database designs

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...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:Computer Science and Information Systems Jg. 9; H. 1; S. 81 - 106
Hauptverfasser: Eessaar, Erki, Soobik, Marek
Format: Journal Article
Sprache:Englisch
Veröffentlicht: 2012
ISSN:1820-0214, 2406-1018
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung: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. nema
ISSN:1820-0214
2406-1018
DOI:10.2298/CSIS100929039E