• Journal of Service Research and Studies
• /
• v.8 no.2
• /
• pp.41-65
• /
• 2018

With the dawn of society where individuals or enterprises based on data generate infinite profits, the significance of database operation management is growing centering on data quality. However, there are not many South Korean public or private entities managing them systematically. Against this backdrop, this study sought to investigate the current status and problems and explore how to improve from the perspective of auditors. To implement this study, audit checklist was improved and, based on it, auditors and IT experts were surveyed. The final data were analyzed to test the study hypotheses empirically. As a result of the analysis, it was found that the auditors had been highly satisfied with all of the items on the improved audit checklist for data quality-based database operation management. Moreover, non-auditors were also found to regard them within their acceptable range. This study is expected to help improve information system operation audit and enterprises data operation management.

• The Transactions of the Korea Information Processing Society
• /
• v.6 no.9
• /
• pp.2281-2293
• /
• 1999

Many applications such as nuclear power plant monitoring, plant process control, stock market management, and network data management require a database system supporting both temporal data model and active rule processing. There have been some efforts to extend the temporal functionalities of the active database system, but an active database system based on temporal database, especially the one applied to the real application is rare. In this paper, we proposed an active temporal rule model based on bi-temporal database. And a rule language following the proposed rule model was described with its execution semantics. Then, how to apply to the nuclear power plant monitoring system was given as the examples.

• The Transactions of the Korea Information Processing Society
• /
• v.6 no.12
• /
• pp.3456-3468
• /
• 1999

Most of previous parallel join algorithms assume a database partition system(DPS), where each database partition is owned by a single processing node. While the DPS is novel in the sense that it can interconnect a large number of nodes and support a geographically distributed environment, it may suffer from poor facility for load balancing and system availability compared to the database sharing system(DSS). In this paper, we propose a dynamic load balancing strategy by exploiting the characteristics of the DSS, and then extend the conventional hash join algorithms to the DSS by using the dynamic load balancing strategy. With simulation studies under a wide variety of system configurations and database workloads, we analyze the effects of the dynamic load balancing strategy and differences in the performances of hash join algorithms in the DSS.

• Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
• /
• v.10 no.2
• /
• pp.31-36
• /
• 1992

Geo-Spatial Information Systems(GSIS) are being used in various urban municipalities as a tool in decision making. Efforts are being made to implement geo-spatial information system databases to systematically and effectively carry out planning, management and monitoring in various fields. This study is about the database establishment of geo-spatial information systems. The study was then applied to water supply facilities management, where the functions and data used in water management were identified through system analysis and the geo-spatial database was designed based on this analysis. Also four application programs were developed to support departments which used various maps and drawings.

• KSII Transactions on Internet and Information Systems (TIIS)
• /
• v.12 no.7
• /
• pp.3375-3400
• /
• 2018

With the advent of database-as-a-service (DAAS) and cloud computing, more and more data owners are motivated to outsource their data to cloud database in consideration of convenience and cost. However, it has become a challenging work to provide security to database as service model in cloud computing, because adversaries may try to gain access to sensitive data, and curious or malicious administrators may capture and leak data. In order to realize privacy preservation, sensitive data should be encrypted before outsourcing. In this paper, we present a secure and practical system over encrypted cloud data, called QSDB (queryable and secure database), which simultaneously supports SQL query operations. The proposed system can store and process the floating point numbers without compromising the security of data. To balance tradeoff between data privacy protection and query processing efficiency, QSDB utilizes three different encryption models to encrypt data. Our strategy is to process as much queries as possible at the cloud server. Encryption of queries and decryption of encrypted queries results are performed at client. Experiments on the real-world data sets were conducted to demonstrate the efficiency and practicality of the proposed system.

• Journal of the Korea Society of Computer and Information
• /
• v.3 no.4
• /
• pp.49-54
• /
• 1998

AS it takes a considerable time for database operations for processing the condition part of active rule, the operations have an important effect on the efficiency of active database system. The processing time of operations should be minimized in order to improve the efficiency of system. The previous works are limited to basic database operations and the partial aggregate functions. In this paper, the processing technique using the structuralization and the state table of relations is suggested. The processing time for basic database operations can be reduced with the structuralization of relations to classification tree and the introduction of deletion information table. With the introduction of binary search tree and relation state table, the aggregate function which has a big of processing cost can be processed effectively and the function of the active database system can be maximized.

• Journal of Korean Library and Information Science Society
• /
• v.33 no.2
• /
• pp.109-137
• /
• 2002

A literature analysis for the planning and realization of meta database system was carried out to establish the ocean electronic resources, the first in Korea. The study targeted from web resources and to oceanographic survey data. The focus of the analysis lies in the providing practical information retrieval service for ocean electronic resources based on the framework of effective Dublin Core metadata with network resources description. The analyses included ocean electronic resources, metadata descriptive elements, metadata classification, system organization and retrieval for planning and implementation of meta database system.

• Journal of the Korea Society of Computer and Information
• /
• v.20 no.1
• /
• pp.185-195
• /
• 2015

During hospital peak times of outpatients, an effective mechanism that informs the newly receipted patient information to corresponding medical departments is lacking in current hospital reception systems. Since every department repeatedly searches entire patient reception database in sequential manner to acquire its reception information, this is a significant performance degradation factor in hospital information system. To improve hospital reception system efficiency, we developed two web socket based systems, a primary key transmitting batch system and a reception information transmitting real time system. The former reduced database access time compared to sequential search system as well as kept search time low regardless of receipted patient number. The latter effectively reduced waiting list updating time in request/response patient reception system by eliminating database access.

• Journal of Korean Society of societal Security
• /
• v.2 no.1
• /
• pp.81-89
• /
• 2009

A web-based information management system to share engineering data of truss bridge is developed through construction of standardized database of truss bridge. 3D shape information is stored in database according to AP 203 of STEP, and 3D visualization on the web is implemented by using the web 3D technology that helps users to understand geometrical shape of structures, directly. AP209 is used to store structural analysis information such as finite elements, material properties, and analysis result into relational database. Based on the developed database, a prototype of integrated information management system for truss bridge is developed, and it provides additional information such as specifications and inspection information related with shape object to end users.

• The Journal of the Institute of Internet, Broadcasting and Communication
• /
• v.17 no.5
• /
• pp.137-142
• /
• 2017

The development of medical devices based on the theory of tranditional Korean medicine is increasing due to population aging and emerging demand for medical services. Various clinical trials are being conducted to ensure the clinical effectiveness of the developed medical devices, and the importance of systematic management of variously collected information in this process is increasing. In this paper, we designed and constructed the database that can systematically manage the medical information of the patient and the pulse measurement information in conducting clinical trials by using pulse analysis system which is a representative diagnostic method of traditional Korean medicine. The constructed database can be efficiently used for the verification of existing algorithms or developing new algorithms through the quality control of various information and measured data on clinical trials. It also has several advantages in the control of clinical data. The results of this study can contribute to the establishment of Korean medical device data standard for the construction of integrated database management system that can share information with different kind of pulse analysis system and other bio-signal measuring devices.