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

Celý popis

Uloženo v:
Podrobná bibliografie
Vydáno v:Computer Science and Information Systems Ročník 9; číslo 1; s. 81 - 106
Hlavní autoři: Eessaar, Erki, Soobik, Marek
Médium: Journal Article
Jazyk:angličtina
Vydáno: 2012
ISSN:1820-0214, 2406-1018
On-line přístup:Získat plný text
Tagy: Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
Popis
Shrnutí: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