Journal's Facebook pageA Decision Support Method for Evaluating Database Designs
- 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: 2406-1018 (Online)
Publisher: ComSIS Consortium
Full text
Available 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), https://doi.org/10.2298/CSIS100929039E
