• Proceedings of the KIEE Conference
• /
• 2002.11b
• /
• pp.193-195
• /
• 2002

This paper presents the methods to solve the problem about Power System Protection Program(PROSET) and describe the database relation and schema with UML. PROSET is a overall program system to protect power system and correct it. In the context of the PROSET it is so difficult to edit database data when topology is changed. When the renewal of data is performed. all changed values are disappeared. Therefore, it will not be expected to know the present situation by using the information of the databases data. So it is necessary to solve this problem. Solution is copy of the user. Only E.R diagram is used to express database schema and relation. So, in this paper, UML(Unified Modeling Language) will be used to express PROSET and database of MCD-H and MDT-H.

• Proceedings of the Korean Geotechical Society Conference
• /
• 1999.10a
• /
• pp.337-344
• /
• 1999

A database program, named Geoscope, was developed to effectively manage the enormous boreholes log data produced during the geotechnical investigation works in construction and mining Industry This program was designed to give a maximum conveniences to the end users when dealing with the geotechnical data obtained. Most of the values related to geotechnlcal attributes can be selected by a simple click of the mouse in list boxes or small windows provided by the program. Logging chart is automatically created at the same time as the input of the data in the form designated by the user. The made file format and the relational database system adopted in this program, furthermore, can allow the data to be associated with other GIS programs.

• Journal of KIISE:Databases
• /
• v.31 no.5
• /
• pp.445-456
• /
• 2004

The database schema is assumed to be stable enough to remain valid even as the modeled environment changes. However, in practice. data models are not nearly as stable as commonly assumed by the database designers. Even though a rich set of schema change operations is provided in current database systems, the users suffer from the problem that schema change usually impacts existing application programs that have been written against the schema. In this paper, we are exploring the possible solutions to overcome this problem of impacts on the application programs. We believe that for continued support of the existing programs on the old schema, the old schema should continue to allow updates and queries, as before. Furthermore, its associated data has to be kept up-to-date. We call this the program independency property of schema change tools. For this property. we devise so-called program independency schema evolution (PISE) methodology. For each of the set of schema change operations in the relational schemas, the sketch of the additional algorithms due to the PISE compliance is presented in order to prove the comprehensiveness and soundness of our PISE methodology.

• 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 Korean Society of Forest Science
• /
• v.88 no.1
• /
• pp.63-72
• /
• 1999

In this study, a relational database program to manage the data involved in forest planning was developed in such a way to simulate the whole process of 'Younglim' planning in Korean National Forest System. Using the pull-down menu system of various functions required for developing 'Younglim' plan, the database program can handle the data of forest inventory, 10-year working plans, annual working plans and the history of forest operations automatically and simultaneously. The model was designed to run under the environment of Korean version of Windows 95. Visual Basic 5.0 was used as the basic tool for programming and Microsoft ACCESS as the basic engine of the database system. In this paper, the process of designing the structure of database program following the process of 'Younglim' plan and the structure of the model are discussed. In addition, the functions of menu system are presented using the screen-mode output windows of the model.

• Proceedings of the Korean Society of Agricultural Engineers Conference
• /
• 1998.10a
• /
• pp.395-400
• /
• 1998

This paper presents a geotechnical information system(HGIS) developed for Korea Highway Corporation. To make a database for boring information, characterization study of boring data is carried out. Based on tile study, the HGIS database is developed as a relational database. The HGIS database consists of 23 tables including 13 reference tables. For an effective database management, a boring log program called GEOLOG is developed. GEOLOG can print boring log and store those data to tile HGIS database.

• Proceedings of the KIEE Conference
• /
• 2003.07a
• /
• pp.302-304
• /
• 2003

This paper presents the methods to solve the problem about Power System Protection Program(PROSET). PROSET is a overall program system to protect power system and correct it. In the context of the PROSET, it is so difficult to edit database data when topology is changed. When the renewal of data is performed, all changed values are disappeared. Therefore, it will not be expected to know the present situation by using the information of the databases data. So it is necessary to solve this problem. Solution is copy of the user. Database of GRL,GRZ,KYP2D1,KYD2X1,L90 Relay module were developed. We made a database management system for PROSET, therefore I will show this management system briefly.

• Korean Management Science Review
• /
• v.17 no.2
• /
• pp.97-113
• /
• 2000

The introduction of client server systems raises some serious IS control concerns. Although client server systems increase system flexibility and compatibility, and facilitates system downsizing and process restructuring, multiple operating systems, database management systems, and platforms of client-server system increase th potential exposures and risks of the system. It is needed to recommend the effective control framework to mitigate risks. This paper suggests risks and control framework for client server system. The results of two case studies indicate that program and database management are important as program and data should be located and maintained in client and servers. It becomes difficult to manage divided programs and data logic that are distributed across clients and servers that have different platforms. The case studies of two banks show that the extent of distribution of program and data logic affects the importance of program and database management controls.

• Proceedings of the Korean Geotechical Society Conference
• /
• 2000.11a
• /
• pp.151-158
• /
• 2000

A database program, named SLOPMAN, was developed to collect all the information on the slopes with potential hazard around railroad and to setup the effective management system. SLOPMAN is composed of three modules: data control, search and analysis. The program is able to store both text and image data and operated with tabs for the users' ability and convenience. Drop-down menu is equipped to reduce errors and the number of key strokes when inputting data. Searching data is made by codes automatically given to slopes or key words. In the analysis module, RMR and SMR values can be obtained to estimate the stability of slopes.

• Proceedings of the KIEE Conference
• /
• 2005.07e
• /
• pp.100-102
• /
• 2005

This paper is purpose to introduce the database management program of insulation tests for high voltage rotating machines. KEPRI has carried out insulation tests for high voltage equipment since 1998, the number of tests grow larger every year. It is difficult to manage the numerous test results, so we developed the insulation diagnostic database program. The features of this program are an easy-search test result and making a graph of AC, tan${\Delta}$ test. the most useful function is the trend management. Using the trend function, we can find the aging deterioration for high voltage machines easily.