A Decision Support Method for Evaluating Database Designs
Computer Science and Information Systems, Tome 9 (2012) no. 1.

Voir la notice de l'article provenant de la source Computer Science and Information Systems website

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.
Keywords: database design, decision support, Analytic Hierarchy Process, object-relational database, SQL
@article{CSIS_2012_9_1_a5,
     author = {Erki Eessaar and Marek Soobik},
     title = {A {Decision} {Support} {Method} for {Evaluating} {Database} {Designs}},
     journal = {Computer Science and Information Systems},
     publisher = {mathdoc},
     volume = {9},
     number = {1},
     year = {2012},
     url = {http://geodesic.mathdoc.fr/item/CSIS_2012_9_1_a5/}
}
TY  - JOUR
AU  - Erki Eessaar
AU  - Marek Soobik
TI  - A Decision Support Method for Evaluating Database Designs
JO  - Computer Science and Information Systems
PY  - 2012
VL  - 9
IS  - 1
PB  - mathdoc
UR  - http://geodesic.mathdoc.fr/item/CSIS_2012_9_1_a5/
ID  - CSIS_2012_9_1_a5
ER  - 
%0 Journal Article
%A Erki Eessaar
%A Marek Soobik
%T A Decision Support Method for Evaluating Database Designs
%J Computer Science and Information Systems
%D 2012
%V 9
%N 1
%I mathdoc
%U http://geodesic.mathdoc.fr/item/CSIS_2012_9_1_a5/
%F CSIS_2012_9_1_a5
Erki Eessaar; Marek Soobik. A Decision Support Method for Evaluating Database Designs. Computer Science and Information Systems, Tome 9 (2012) no. 1. http://geodesic.mathdoc.fr/item/CSIS_2012_9_1_a5/