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

2021 ◽  
Vol 11 (3) ◽  
pp. 119-129
Author(s):  
Rifqi Hammad ◽  
◽  
Azriel Christian Nurcahyo ◽  
Ahmad Zuli Amrullah ◽  
Pahrul Irfan ◽  
...  

University requires the integration of data from one system with other systems as needed. This is because there are still many processes to input the same data but with different information systems. The application of data integration generally has several obstacles, one of which is due to the diversity of databases used by each information system. Schema matching is one method that can be used to overcome data integration problems caused by database diversity. The schema matching method used in this research is linguistic and constraint. The results of the matching scheme are used as material for optimizing data integration at the database level. The optimization process shows a change in the number of tables and attributes in the database that is a decrease in the number of tables by 13 tables and 492 attributes. The changes were caused by some tables and attributes were omitted and normalized. This research shows that after optimization, data integration becomes better because the data was connected and used by other systems has increased by 46.67% from the previous amount. This causes the same data entry on different systems can be reduced and also data inconsistencies caused by duplication of data on different systems can be minimized.

2021 ◽  
Vol 11 (3) ◽  
pp. 119-129
Author(s):  
Rifqi Hammad ◽  
◽  
Azriel Christian Nurcahyo ◽  
Ahmad Zuli Amrullah ◽  
Pahrul Irfan ◽  
...  

University requires the integration of data from one system with other systems as needed. This is because there are still many processes to input the same data but with different information systems. The application of data integration generally has several obstacles, one of which is due to the diversity of databases used by each information system. Schema matching is one method that can be used to overcome data integration problems caused by database diversity. The schema matching method used in this research is linguistic and constraint. The results of the matching scheme are used as material for optimizing data integration at the database level. The optimization process shows a change in the number of tables and attributes in the database that is a decrease in the number of tables by 13 tables and 492 attributes. The changes were caused by some tables and attributes were omitted and normalized. This research shows that after optimization, data integration becomes better because the data was connected and used by other systems has increased by 46.67% from the previous amount. This causes the same data entry on different systems can be reduced and also data inconsistencies caused by duplication of data on different systems can be minimized.


Web Portals ◽  
2011 ◽  
pp. 252-269 ◽  
Author(s):  
Marko Bajec

Portal-based solutions have been proved in practice to be a promising technology that offers companies a way to transform and integrate their information systems more effectively and at lower cost. The main point of this paper is to discuss the use of portals in institutions of higher education. We examine the motivating factors that drive higher-education institutions to use portal-based solutions. As an example, we explain how the University of Ljubljana is taking advantage of portal technology and what benefits are to be expected from the use of portals as core components of the university’s new user-centric information system.


2021 ◽  
Author(s):  
Catherine A. Middleton

This paper presents a case study of an information system implementation. The system, a computerized student record system, was introduced into a small university when the university opened. Unlike many other case studies of systems implementation, there was no existing system to replace, thus it was expected that there would be little resistance to the system. Successful implementation was anticipated, particularly as the systems designers were also the primary users. An evaluation of the system shows this was not the case. Two groups of users are identified, one pleased with the system, the other dissatisfied. The secondary users did not display their dissatisfaction with the system by resistance, however. They used the system frequently, but were denied the full access they required to do their jobs. Ostensibly due to technical limitations of the system, the primary users acted as gatekeepers. An examination of the culture and management structure of the university reveals strong political motivations for the primary users to exert power over the secondary users. Markus’s (1983) interpretation of interaction theory is used to discuss the political implications of the system design. It is concluded that senior management must be aware of the importance of information systems to their organizations, and understand the potential for designers to use these systems as sources of power. The case study is reconstructed from the author’s experiences as a staff member at the university during the system implementation, initially as a primary user of the system (but not an active member of the system design team), and later as a secondary user. The case is evaluated from the perspective of both user groups, using a framework derived from the literature on information systems failure and successful systems implementation.


2016 ◽  
Vol 2 (1) ◽  
Author(s):  
Agus Setiawan

Abstract - Information technology was used in the world of education, needs to be done to eliminate the problem of distance, time, and place in the delivery of information. This study aims to identify and analyze the parents information system of the students based websites. The parents information system of the students is expected to provide accurate and reliable information for parents who had entrusted his son to the University of Muhammadiyah Magelang to go through the process of high-level formal education as a student. Parents are guardians of students in need of information on the progress of their children at any time in accordance with academic activities, even in relation to finance for regular payments each semester. The results of this research is a design model of parents information system of the students with integrated with KRS online system that is already running. Keywords: information systems , information systems academic , academic systems , information systems parent.


Author(s):  
Laila Niedrite ◽  
Darja Solodovnikova

The measuring of research results can be used in different ways e.g. for assignment of research grants and afterwards for evaluation of project’s results. It can be used also for recruiting or promoting research institutions’ staff. Because of a wide usage of such measurement, the selection of appropriate measures is important. At the same time there does not exist a common view which metrics should be used in this field, moreover many existing metrics that are widely used are often misleading due to different reasons, e.g. computed from incomplete or faulty data, the metric’s computation formula may be invalid or the computation results can be interpreted wrongly. To produce a good framework for research evaluation, the mentioned problems must be solved in the best possible way by integrating data from different sources to get comprehensive view of academic institutions’ research activities and to solve data quality problems. We will present a data integration system that integrates university information system with library information system and with data that are gathered through API from Scopus and Web of Science databases. Data integration problems and data quality problems that we have faced are described and possible solutions are presented. Metrics that are defined and computed over these integrated data and their analysis possibilities are also discussed.


1989 ◽  
Vol 28 (04) ◽  
pp. 281-284 ◽  
Author(s):  
D. Protti

Abstract:This paper discusses the teaching of a course which simulates what a hospital goes through when it conceptualizes the need for a Hospital Information System, identifies its goals and objectives for the system, prepares a Request for Proposal (RFP), and selects a particular system. The course is. taught entirely in simulation and role playing modes. Students are taken on site visits, vendors come to the University to demonstrate their systems, and consultants are brought in to give advice. The pros and cons of this particular style of teaching are discussed.


2019 ◽  
Vol 9 (1) ◽  
pp. 1
Author(s):  
Rifqi Hammad

University is one of the agencies that use information technology to support various business processes. University requires data integration between the systems so that the data available in one system can be used in other systems to support data management.In forwarding data integration there are several obstacles that occur one of the causes is schema heterogeneity used by each information system. linguistic method is one of the schema matching methods used to overcome the problem of schema heterogeneityBased on the analysis of database schemes with the linguistic method, the values of precision, recall and f measure are 0.75. This value indicates that the application of the matching schema has been quite good. But there are still some of the same data between the schemes so that the integration of the data owned is not maximal. So that optimization is still needed to maximize the data integration


2021 ◽  
Vol 15 ◽  
pp. 96-102
Author(s):  
Martin Blaha ◽  
Ladislav Potužák

The Czech Republic, as a member of international organizations (NATO, EU, UNO), with respect to current global security environment, employs the units of the army both at its own state territory and outside the Czech Republic in multinational forces operations. The article focuses on preparation of meteorological reports of future Automated Command, Control, and Information system (C2I) in conditions of the Army of the Czech Republic. The issue of automated command, control, and information systems is of high importance in the solving of asymmetrical operations tasks today and in the upcoming future. Define the basic resources for creation of meteorological reports of NATO standards in Network Enabled Capabilities (NEC) conditions. The authors define group of meteorological report for designing a new and by the Army of the Czech Republic required sophisticated Automated Fire Support Control System of Artillery meeting NATO standards in Network Enabled Capabilities (NEC) conditions. The article represents section of a huge defensive research project of Ministry of Defence of the Czech Republic and the Army of the Czech Republic solved by leading scientists of the University of Defence in Brno.


Author(s):  
Olimpia Małecka ◽  
Mariusz Polarczyk

Place and Tasks of the Main Library of the Poznań University of Life Sciences in arrangement university–information system for higher education POL-onThe paper presents the tasks performed in the Main Library of the Poznań University of Life Sciences, which are associated with the System of information on higher education POL-on. The leading role of the Main Library is to create and update the database Bibliography of publications of the Poznań University of Life Sciences. Collecting data in the database Bibliography was discussed here, as well as organizational solutions implemented after starting POL-on System. The scope of work related to updating the database structure and adapting it to export data to the Reporting Module of Polish Scholarly Bibliography was presented. Another task entrusted to the Main Library is to collect data entry about conferences, awards and honors, patents and protection rights and to introduce it to the POL-on system. The article also presents difficulties arising during the work and their solutions. All work was carried out in close cooperation with the University authorities on the basis of the Rector’s regulations.


Sign in / Sign up

Export Citation Format

Share Document