• The Journal of Information Systems
• /
• v.27 no.4
• /
• pp.149-165
• /
• 2018

Purpose As Korean economy has been sluggish in recent years, firms' interest in publicly financed projects has increased due to the relatively increasing proportion in the economy. Since 1999, publicly financed projects in Korea need to undergo preliminary feasibility study to evaluate economic efficiency and policy quality if they are larger than a certain scale. The benefits of public projects are one of the most important factors in the preliminary feasibility study but are difficult to estimate due to their nature. Design/methodology/approach This study estimates the benefits of the agricultural soil information database, a public database in Korea. The method used in the study is the stated preference method which is formally used in Korea's preliminary feasibility study. Data are collected through surveys and a logit model is constructed to be estimated by the maximum likelihood estimation method. Findings As the first study evaluating a public database, this study can be used as a baseline in all public database projects developed in the future. In addition, this study can contribute to improving the understanding of both private companies and public organizations who are interested in the cost-benefit analysis and estimation procedure for the publicly financed projects.

• Journal of the Korean Geotechnical Society
• /
• v.18 no.6
• /
• pp.43-59
• /
• 2002

In this study, database systems which were used to select the waterproof method according to leakage patterns of underground structures were built by performing pilot tests, reviewing literatures, and analysing the gathered data statistically. The database was built by using check lists which consisted of 5 major items and 73 subdivided items, and 26 major parameters according to 4 classified grades were determined on the base of survey which considered various in-situ conditions. The database of waterproof methods was comprised of 10 methods which were applied in Korea. From the database of waterproof methods, application ranges and design conditions of waterproof methods were suggested. From the results of study, database system consists of parameters selection database, waterproof method database, and design condition database. From the results of pilot tests, when the database of waterproof methods was applied to design stage, saving time and reducing mistakes for selecting waterproof method were gained. In addition, when the database of waterproof methods was applied to construction stage, effects such as evaluation of applicability of waterproof method, improvement of constructability and post management were expected.

• Journal of Internet Computing and Services
• /
• v.12 no.6
• /
• pp.149-159
• /
• 2011

The current applications can be characterized as consisting of complex objects related by complex relationship. Therefore the relational database has been extended to object-relational database because of the complex objects. Accordingly, we need database design methodology for object-relational database. In this pager, we develop an integrated design methodology based on a extended UML class diagram for object-relational database. We make the extend UML class diagram by adding new stereotypes for object-relational database. Also we propose a guideline for transforming the extended UML class diagram to object-relational database schema. We use SQL:1999 as a object-relational data model and Oracle11g as a target object-relational database. We can build more easily and efficiently object-relational database for Oracle11g by using our methodology. Finally we applied our methodology on a computer classroom reservation system for evaluation the methodology.

• Journal of the Earthquake Engineering Society of Korea
• /
• v.10 no.3 s.49
• /
• pp.135-147
• /
• 2006

The essential information elements for the Earthquake Damage Evaluation System (EDES) of highway bridges are defined in this study, and a database construction method, which fits the circumstances of Korea, is proposed. The information elements for the EDES of highway bridges are categorized in two groups: structure related information, location related information. The structure related information is composed of the fragility curve information which is necessary for earthquake damage evaluation of highway bridges. The data structure of road network, which represents the location related information, is defined in more detail than the existing GIS-based data structure of road network for modeling of junctions. A pilot GIS-based EDES subjected to 110 bridges on expressway in Korea is developed, and it is verified that the proposed database construction method for the EDES can be used to develop a decision making system for quick retrofitting of the seismic damages of highway bridges and road network.

• Journal of Digital Convergence
• /
• v.15 no.10
• /
• pp.377-386
• /
• 2017

This study has developed a medical information management educational program that can improve the management ability of medical information. The educational medical information management program was developed for 8mnths uing VB. The database utilized the ACCESS Database, which allows learners to easily understand and understand the structure of the data. The learners enter data in the discharge analysis and the cancer registration program and the incomplete program after analyze the medical records. After entering and saving data, medical information management programs can be used to understand and analyze the structure of the database to generate medical information. The educational programs can improve the ability of learners to manage medical information by extracting the necessary data from the database directly through SQL and creating various medical information. However, although the medical information management program is an educational program, there is no evaluation system for the learners program operation. Accordingly, the next studies should develop the assessment system of the medical information management program for learners evaluation.

• Journal of Korea Society of Digital Industry and Information Management
• /
• v.12 no.3
• /
• pp.11-24
• /
• 2016

The purpose of this study is to develop a recruiting platform resolving the mismatch between corporate job and job finder's competence in recruitment market. For this, we investigated technological trends and limitation on recruit platform. Based on the findings, this study investigates the trends and directions related to recruiting platform evolution and identified critical success factors and development strategies for successful development of recruiting platform. Two development strategies include employment of online resume and construction of database assessing job finder's competence. We also proposed target system architecture incorporating job database, competency assessment form, capability oriented resume. To analyze user requirement national competency standards and core job capability evaluation model were analyzed. Next, we designed integrated database, user interfaces, and dynamic functionalities using the forms developed in earlier stage. Finally, we assessed the fidelity of form item, integrity of database, and the usability of interface to evaluate the effectiveness of the system.

• Proceedings of the KSME Conference
• /
• 2001.06a
• /
• pp.126-131
• /
• 2001

Materials property data are necessary to secure the reliability of failure prevention techniques such as inspection and remaining life assessment of civil infrastructure and industrial facilities. However, there is no properly collected data in Korea, and those foreign data are hard to use because of the scattering of the sources, the difference of standards, etc. In this paper, materials property database system which has been constructed at Korea Research Institute of Standards and Science is introduced. Constructed database contains 145,000 numeric data of materials property for 600 kinds of metals and can be retrieved on the internet. The database system provides graphical user interface-based information searching functions necessary for the life evaluation and safety analysis.

• Journal of Information Technology Applications and Management
• /
• v.9 no.1
• /
• pp.27-44
• /
• 2002

Performance evaluations of database algorithms are usually conducted on a set of queries for a given test database. For more detailed evaluation results, it is often necessary to use different query workloads several times. Each query workload should reflect the querying patterns of the application domain in real world, which are non-uniform in the usage frequencies of attributes in queries of the workload for a given database. It is not trivial to generate many different query workloads manually, while considering non-uniform distributions of attributes'usage frequencies. In this paper we propose a technique to generate non-uniform distributions, which will help construct query workloads more efficiently. The proposed algorithm generates a query-attribute usage distribution based on given constraints on usage frequencies of attributes and qreries. The algorithm first allocates as many attributes to queries as Possible. Then it corrects the distribution by considering attributes and queries which are not within the given frequency constraints. We have implemented and tested the performance of the proposed algorithm, and found that the algorithm works well for various input constraints. The result of this work could be extended to help automatically generate SQL queries for various database performance benchmarking.

• Journal of the Korea Institute of Information Security & Cryptology
• /
• v.17 no.1
• /
• pp.109-113
• /
• 2007

With increasing the mont of processed information over the network, the importance of database system increases rapidly. There are two types of security system for database, access control and data encryption. However, it is hard to evaluate security of database systems using the Common Criteria(CC) as there is no protection profile(PP) for these systems. In this paper, we propose a protection profile for secure database systems which can be used in formal evaluation using the Common Criteria. The proposed protection profile can be used by both developer and consumer to evaluate security of database systems.

• Proceedings of the KSME Conference
• /
• 2001.06d
• /
• pp.903-908
• /
• 2001

A web-based client/server program, MOVIDIK(Motor-Operated-Valve Integrated Database Information of KEPCO) has been developed to perform a design basis safety evaluation for a motor-operated-valve(MOV) in the nuclear power plant. The MOVIDIK consists of seven analysis modules and one administrative module. The analysis module calculates a differential pressure on the valve disk, thrust/torque acting at a valve stem, maximum allowable stress, thermal-overload-relay selection, voltage degradation, actuator output and margin. In addition, the administrative module manages user information, approval system and code information. MOVIDIK controls a huge amount of evaluation data and piles up the safety information of safety-related MOV. The MOVIDIK will improve the efficiency of safety evaluation work and standardize the analysis process for the MOV.