A decision support method for evaluating database designs | Zendy

Erki Eessaar | Zendy; Marek Soobik | Zendy

AI Assistant Blog Pricing

Home ZAIA Blog

Open Access

A decision support method for evaluating database designs

Author(s) -

Erki Eessaar,

Marek Soobik

Publication year - 2011

Publication title -

computer science and information systems

Language(s) - English

Resource type - Journals

SCImago Journal Rank - 0.244

H-Index - 24

eISSN - 2406-1018

pISSN - 1820-0214

DOI - 10.2298/csis100929039e

Subject(s) - computer science , database design , database , database transaction , sql , data mining , database testing , set (abstract data type) , database schema , pairwise comparison , context (archaeology) , relational database , artificial intelligence , programming language , paleontology , biology

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.

The content you want is available to Zendy users.

Already have an account? Click here to sign in.

Having issues? You can contact us here

Accelerating Research