scholarly journals A decision support method for evaluating database designs

2012 ◽  
Vol 9 (1) ◽  
pp. 81-106 ◽  
Author(s):  
Erki Eessaar ◽  
Marek Soobik

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.

Author(s):  
M. R. GHOLAMIAN ◽  
S. M. T. FATEMI GHOMI ◽  
M. GHAZANFARI

The establishment of the priorities from pairwise comparison matrices is the major constituent of the Analytic Hierarchy Process (AHP). However, the number of pairwise comparisons necessary in real problems often becomes overwhelming. In such cases, generally the experts are not able to answer all questions and consequently sparse judgment matrix is generated which caused "equal ranks" and "rank reversal" based on AHP method. In this paper, a new ranking system (FARSJUM) is developed for such sparse judgment matrix. The system is constructed on fuzzy rules and fuzzy reasoning methods. The numerical example of world cup soccer tournament is brought to clarify the performance of the developed system comparing with AHP method in ranking the sparse judgment matrices.


2013 ◽  
Vol 46 (9) ◽  
pp. 875-880
Author(s):  
Lucio Compagno ◽  
Diego D'Urso ◽  
Antonio G. Latora ◽  
Natalia Trapani

2019 ◽  
pp. 183-194
Author(s):  
Milena Lakicevic ◽  
Keith Reynolds ◽  
Bojan Srdjevic

This paper demonstrates the application of the Analytic Hierarchy Pro?cess (AHP) in assessing landscape plans using the option of abbreviated pair-wise comparisons to simplify the weight elicitation process for decision makers. Whereas the standard AHP elicitation procedure requires a full set of pairwise comparisons among all criteria at each node of the decision hierarchy in order to derive criterion weights for the decision model, the abbreviated pairwise method uses a minimal spanning set of pairwise comparisons, and remaining comparisons are then derived by transitivity rules. In this paper is presented the abbreviated pairwise method with a case study in which alternative management plans are evaluated for the Zvezdarska forest of Belgrade, Serbia. The analysis was performed with the Criterium DecisionPlus software, which fully implements the AHP methodology, and provides useful diagnostics on AHP decision models. As a conclusion, some of the key advantages and disadvantages of the abbreviated pairwise variant of the AHP method are demonstrated. One of the key qualities of the Criterium DecisionPlus software is a clear and easy graphical representation of the results.


2012 ◽  
pp. 377-392
Author(s):  
Jannes Slomp ◽  
Jos A.C. Bokhorst

One of the most important design decisions in a firm is the choice for a manufacturing layout type. This chapter shows which aspects have to be taken into account and suggests a systematic method for the decision problem. The method can be seen as a decision support framework, which links the various aspects. The framework is based on the AHP (Analytic Hierarchy Process) approach. A case study, concerning a Dutch firm, illustrates the applicability of the framework in a practical instance.


Author(s):  
Jannes Slomp ◽  
Jos A.C. Bokhorst

One of the most important design decisions in a firm is the choice for a manufacturing layout type. This chapter shows which aspects have to be taken into account and suggests a systematic method for the decision problem. The method can be seen as a decision support framework, which links the various aspects. The framework is based on the AHP (Analytic Hierarchy Process) approach. A case study, concerning a Dutch firm, illustrates the applicability of the framework in a practical instance.


2016 ◽  
Vol 1 (1) ◽  
pp. 088
Author(s):  
Wahyu Joni Kurniawan

This study was conducted to assist in the selection of martial assistant coach, to determine who is right. Its results will didadaptkan by comparing the two methods in the decision support system, by using the Analytic Hierarchy Process (AHP) and the Simple Additive Weight (SAW) in limiting the problems in producing the desired solution, using multiple criteria (multi-criteria). AHP and SAW has a different way of doing the calculation. This is done to determine which method is looking for help in making decisions. And in this study are the criteria Discipline, Knowledge, Leadership, Attitude, and Level. And there are sub criteria on Level, which Black (AND I) and Red Black II.


Sign in / Sign up

Export Citation Format

Share Document