SAW-TOPSIS Implementation To Determine An Appropriate DBMS Software
Keywords:
Database Management System, Decision Support, SAW, TOPSIS,Abstract
Selection an appropriate Database Management Software, is a crucial part to ensure operational excellence businesses firm. Database management software used to organize and manage the company’s data so that they can be efficiently accessed and used to improve operational and decision quality. However, a senior manager as decision maker sometimes lacks the comprehensive knowledge to choose a suitable database management software which meets with business needs. Then, The manager determines a database management software based on a consultant or vendor offer. On the other hand, a consultant or vendor has an interest in to sell their product, so they tend to lead manager to choose their product even though it is not fulfilling business needs. We present a decision support application to help the manager to select an appropriate database management software (DBM) for their company, using Simple Additive Weighting (SAW) and Technique for Order Preference by Similarity to Ideal Solution (TOPSIS) method. We observe SQL Server, MySQL, Oracle, DB2, and PostgreSQL as five top database management software and investigate the detail about cost, storage capacity, security, supported the operating system and supported programming language as key criteria to select best database management software from their official website. Then, we combining SAW and TOPSIS method to choose the best appropriate DBM software based on user requirement through computation program and validate our application performance includes the user interface, usability and accuracy result to 50 database engineers expert as respondent. The results are as follows; 1) 86 % of respondents are satisfied with application user interface, 2) 94% are happy with application usability and 3) 86% are pleased with the accuracy of the computation. Overall, this study provides a decision support application to determine an appropriate database management software based on business needs by combining SAW and TOPSIS methods.Downloads
Published
How to Cite
Issue
Section
License
TRANSFER OF COPYRIGHT AGREEMENT
The manuscript is herewith submitted for publication in the Journal of Telecommunication, Electronic and Computer Engineering (JTEC). It has not been published before, and it is not under consideration for publication in any other journals. It contains no material that is scandalous, obscene, libelous or otherwise contrary to law. When the manuscript is accepted for publication, I, as the author, hereby agree to transfer to JTEC, all rights including those pertaining to electronic forms and transmissions, under existing copyright laws, except for the following, which the author(s) specifically retain(s):
- All proprietary right other than copyright, such as patent rights
- The right to make further copies of all or part of the published article for my use in classroom teaching
- The right to reuse all or part of this manuscript in a compilation of my own works or in a textbook of which I am the author; and
- The right to make copies of the published work for internal distribution within the institution that employs me
I agree that copies made under these circumstances will continue to carry the copyright notice that appears in the original published work. I agree to inform my co-authors, if any, of the above terms. I certify that I have obtained written permission for the use of text, tables, and/or illustrations from any copyrighted source(s), and I agree to supply such written permission(s) to JTEC upon request.