• Journal of Industrial Technology
• /
• v.18
• /
• pp.343-353
• /
• 1998

Effective design of a database is essential for operating application systems efficiently. This paper discusses database design for a geographic information system. This goals of database design are multiple: to satisfy the information content requirements of the specified users and applications; to provide a natural and easy-to-understand structuring of the information; and to support processing requirements and any performance objectives such as response time, processing time, and storage space. Database design is a very complex process and is decomposed in three phases: conceptual, logical, and physical design. In this paper, we first collect and analyze the requirements for a geographic information system. We also perform database design for these requirements through the three design phases systematically. Our results would contribute to the effective construction of a database for a geographic information system.

• The Transactions of the Korea Information Processing Society
• /
• v.7 no.2S
• /
• pp.692-700
• /
• 2000

As the multimedia application services have been getting various in Internet, need of multimedia database management system which can manage various multimedia information effectively has been increased. The multimedia application generally needs the features to store, manage, retrieve the multimedia data. We need a database management system framework that may be easily integrated with these features. This paper proposes th database management system framework providing the easy integration with various multimedia information retrieval. The framework uses OQL as the retrieval interface, so that user can use it easily. It can be integrated dynamically and easily with various multimedia retrieval method as a loosely coupled system. In addition there is no performance degradation caused in a loosely coupled system.

• Journal of the Korea Society for Simulation
• /
• v.9 no.3
• /
• pp.27-41
• /
• 2000

As the application domains of rule-based systems become larger and more complicated, the integration of rule-based systems within the database systems has become the topic of many research works. This paper suggests a simulation modeling using expert system and database. The integration methods employed in this research are as follows. First, we defined new states and state transition functions to interrelate simulation model and expert system. Second, we designed and implemented FCL(Fact Class Library) as a interface of expert system and database. FCL has facilities of filtering data from database, and assigning a meaning to the filtered data. Also, FCL detects the violation of the integrity rules in database, as the result of inference is reflected. Some implementation problems are pointed out and the methods to solve these problems are discussed in this paper, We developed a simulation model of the grating production line and executed it to validate the functions of the proposed method.

• Proceedings of the KSRS Conference
• /
• 2003.11a
• /
• pp.499-501
• /
• 2003

As semiconductor memory becomes cheaper, the memory capacity of computer system is increasing. Therefore computer system has sufficient memory for a plentiful spatial data. With emerging spatial application required high performance, this paper presents a GIS database system in main memory. Memory residence can provide both functionality and performance for a database management system. This paper describes design of DBMS for storing, querying, managing and analyzing for spatial and non-spatial data in main-memory. This memory resident GIS DBMS supports SQL for spatial query, spatial data model, spatial index and interface for GIS tool or applications.

• Asian Pacific Journal of Cancer Prevention
• /
• v.17 no.2
• /
• pp.639-641
• /
• 2016

Purpose: To establish a database for breast cancer patients to save and manage clinical data and to preliminarily investigate its clinical application. Materials and Methods: Information on breast cancer patients hospitalized in our department from 2008.01 to 2013.01 were input into our breast cancer management system. SPSS 16.0 software was used as a convenient reference to evaluate the accuracy of the newly built database. Results: A database of 2403 breast cancer patients was successfully established. Information in the database clearly displayed capabilities of storage, addition, retrieval, statistical analysis and other functions. As the continuously updated database showed, the distribution of age, sex, nationality, allergy history, pausimenia and marriage of patients was identical to that achieved by SPSS analysis, indicating reliable and accurate data analysis. Conclusions: The described database is easy and convenient to operate and manage, and should prove suitable for application in clinical research and treatment.

• The Transactions of the Korea Information Processing Society
• /
• v.7 no.6
• /
• pp.1753-1765
• /
• 2000

As the areas of computer application are expanded, real-time application environments that must process as many transactions as possible within their deadlines, such as a stock transaction systems, ATM switching systems etc, have been increased recently. The reason why the conventional database systems can't process soft real-time applications is the lack of prediction and poor performance on processing transaction's deadline. If transactions want to access data stored at the secondary storage, they can not satisfy requirements of real-time applications because of the disk delay time. This paper designs a main-memory database prototype systems to be suitable to real-time applications and then this system can produce rapid results without disk i/o as all of the information are loaded in main memory database. In thesis proposed the improved techniques with respect to logging, checkpointing, and recovering in our environment. In order to improve the performance of the system, a) the frequency of log analysis and redo processing is reduced by the proposed redo technique at system failure, b) database consistency is maintained by improved fuzzy checkpointing. The performance model is proposed which consists of two parts. The first part evaluates log processing time for recovery and compares with other research activities. The second part examines checkpointing behavior.

• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 1995.09a
• /
• pp.46-58
• /
• 1995

Although numerous distributed database design models and solution algorithms have been developed, very few have been validated. Validation is critical to the successful application of such models to distributed database design. In this paper, we develop a simulation system for distributed database design. We then analyze and validate an average response time model using simulation. The simulation results demonstrate that the average response time model is reasonably accurate.

• Journal of Korea Society of Industrial Information Systems
• /
• v.24 no.6
• /
• pp.43-53
• /
• 2019

In recent years, there have been many cases of damage to indoor air hazardous materials, and major damage due to the lack of quick action. In this regard, the system is intended to establish for sending push messages to the user's mobile when the concentration of hazardous substances is exceeded. This system extracts data with IoT system such as Arduino and Raspberry Pi and then constructs database through MongoDB and MySQL in cloud computing system. The database is imported through the application server using NodeJS and sent to the application for visualization. Also, when receiving signals about a dangerous situation in IoT system, push message is sent using Google FCM library. Mobile application is developed using Android Web view, and page to enter Web view is developed using HTML5 (HTML, Javascript CSS). The application of this system enables real-time monitoring of indoor air-dangerous substances. In addition, real-time information on indoor/outdoor detection location and concentration can be sent to the user's mobile in case of a risk situation, which can be expected to help the user respond quickly.

• Proceedings of the Korean Society of Precision Engineering Conference
• /
• 1995.10a
• /
• pp.227-231
• /
• 1995

This paper describes a basic programming and interfacing modele which can link DataBase form experiments and dynamic analysis program of chock absorber within the limit of adequate reliability. The system developed can provid a user specific Database of shock absorber within the required damping performance and endurable tolerance, thus show a good application possibilities in commercial vehicle design.

• Proceedings of the Computational Structural Engineering Institute Conference
• /
• 1999.10a
• /
• pp.444-451
• /
• 1999

The purpose of this study is to Propose data models for central database in integrated system for structural design building. In order to efficiently express data related to structure, I analyzed the structure design process and classified data considering design step. 1 used an object-oriented modeling methodology for logical data model and relational modeling for physical data model. Based on this model, we will develop an integration system with several applications for structure design. Each application will communicate through the central database.