Pengembangan Basis Data Sistem Informasi Manajemen Rumah Sakit Berbasis Linguistic-based Schema Matching

Abstract

Prof. Soeparwi veterinary hospital is one of the medical institutions focused on providing medical services for animals. In its daily operations, the flow of informations among various departments has yet to be supported by management information systems (MIS) which enables efficiency of business process and a better management of the data. Previous researches have been conducted to develop MIS, which resulted in three independent MIS for managing registration, medical records, and patient bills. Each MIS is using their own database to store the data, thus causing duplicates of information and inconsistencies, and also increasing complexity in accessing the data. The goal of this research is to redesign the said database into a single database that will be used by various MIS. Three independent databases are merged by applying a technique that uses linguistic information as the basis for the matching-called linguistic-based schema matching. This method's accuracy is evaluated by calculating precision, recall, and F-measure-which we obtained scores of above 50% for all three indicators. Requirement analysis is performed to further develop the database for supporting further needs of the hospital. The new database system is tested using black-box technique under few test cases to see if its functionality corresponds with the specifications defined. Result of this test proves that the new database could handle valid, invalid, and redundant inputs as expected by a score of 100% success rate.

Integragsi Technology Acceptance Model Dan Unified Theory of Acceptance and Use of Technology 2 Untuk Mengukur Minat Pengguna Aplikasi Pospay Di Banda Aceh

“…2.2 Unified Theory of Acceptance and Use of Technology 2 (UTAUT 2) UTAUT 2 merupakan sebuah modelpenerimaan teknologi terkini yang dikembangkan olehVenkatesh dkk. Dalam penelitian ini terdapat variabel pengukur Behavioral Intention dan use behavior serta dipengaruhilangsung oleh tujuh konstruk utama yaitu ekpektasi kinerja(Performance Expectancy), ekspektasi usaha (Effortexpectancy), faktor sosial (Social Influence), dan kondisi yangmemfasilitasi (Facilitating Conditions), motivasi hedonic(hedonic motivation), nilai harga (Price Value), Kebiasaan (Habbit) (Puspitasari, 2013).…”

Optimization of data integration using schema matching of linguistic-based and constraint-based in the university database

“…This can cause data duplication and data redundancy. Data duplication can cause data inconsistency [1] and also take up space in the database where it can be used to store other data. Data duplication is caused by the process of entering the same data in different information systems where the process can allow data inconsistencies to occur.…”

Optimization of data integration using schema matching of linguistic-based and constraint-based in the university database

“…The use of information technology currently plays an important role in the success of an organization. Digital information storage can assist organizations in accessing information and processing it quickly [1]. One form of the use of information technology is the use of information systems for various organizational activities.…”

“…Technology plays a role in demanding organizations have information systems that can support management in decision making [2]. Information systems that are supported by integrated data can produce useful information for their users [1]. Data integration is a process carried out to combine data from various sources to support information management [3].…”

“…From several experiments that have been carried out by considering conflicting elements in the identification of the schema, schema matching uses a hybrid approach that can be used for rewriting queries on multiple databases [14]. Another research showed that the linguistic method is one of the schema matching methods that can be used to find similarities between schemes and can be used as material for optimizing database development [1]. Research conducted by Sutanta and colleagues combines two-hybrid schema matching methods to overcome database integration problems caused by database diversity [15].…”