• 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.

• Journal of Biosystems Engineering
• /
• v.27 no.2
• /
• pp.161-172
• /
• 2002

Database as a supporting system for decision-making is one of essential parts for realizing precision farming. Application models on constructing a database for precision farming, including collection of spatial and attribute data, were suggested using a GPS, DXF files, AutoCAD, a Java application program and PostgreSQL DBMS in this study. The constructed spatial database based on the schema design of spatial and attribute data table was evaluated as a supporting system for decision-making by a simulation of a virtual variable-rate chemical applicator. The applicator could extract the values of soil property at its consecutive location in the tested field in communication with the constructed database, and prescribe the corresponding variable-rate of chemicals. The results of the study suggested the possibility that the constructed database can function a supporting system for decision-making for precision farming.

• Journal of Korean Library and Information Science Society
• /
• v.39 no.4
• /
• pp.305-329
• /
• 2008

This study is to develop quality assessment module to apply database system quality assessment thus, recognizing necessity of database system quality improvement maturity model. To manage and improve of database system quality, assessment module is needed to assess database system quality systematically. This study is to perform for the purpose of follows. First, this study is to select quality characteristics and sub characteristics on based on ISO/IEC 9126 series and to develop assessment module for database system quality assessment. Second, this study is to compare and to analysis about quality assessment characteristics of two groups. This study is to have significance to apply quantitative assessment in theoretical and practical basis and is to applicate basic materials of study in database system quality assessment. Also, in succeeding study, it will be to develop of database system quality improvement maturity model.

• Proceedings of the Korean Institute of Information and Commucation Sciences Conference
• /
• 2007.06a
• /
• pp.645-648
• /
• 2007

This paper describes database server management system by mobile device. Our system can control database server immediately in any where by mobile device. We have developed the dataset server CE which interface with mobile device, database management system which rons in mobile device and web services which connect the mobile database with desktop database. External mobile device communicate with web service agent via wireless equipment. Our system includes dataset server CE client engine, web service server agent and mobile device management system. Through the test by an application program, we have confirmed that our system operates very well each others.

• 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.

• Journal of Institute of Control, Robotics and Systems
• /
• v.14 no.5
• /
• pp.473-482
• /
• 2008

In this paper we propose an expert system for content-based image retrieval with object database. The proposed system finds keyword by using knowledge-base and feature of extracted object, and retrieves image by using keyword based image retrieval method. The system can decrease error of image retrieval and save running time. The system also checks whether similar objects exist or not. If not, user can store information of object in object database. Proposed system is flexible and extensible, enabling experts to incrementally add more knowledge and information. Experimental results show that the proposed system is more effective than existing content-based image retrieval method in running time and precision.

• Journal of Welding and Joining
• /
• v.17 no.3
• /
• pp.44-49
• /
• 1999

Power and industrial plant use various welding processes and many kinds of materials. Thus, it is a difficult task to get the proper welding information. In this research, a welding information system was developed to solve the difficulty. It consists of database system, knowledge base system and diagram analysis programs. Database system contains a large database and various searching method corresponding to the kind of information. A large part of welding information is managed by this database system. Knowledge based system is used for decision of proper welding process and analysis of weld defects. It has conversion program from text to knowledge, and inference mechanism. Finally, Diagram analysis programs carry out the calculation of ferrite content in the weld metal. By the calculation, a crack occurrence can be avoided. The developed system can be a useful tool for welding in the field of power and industrial plant.

• The Transactions of the Korean Institute of Electrical Engineers A
• /
• v.48 no.7
• /
• pp.847-854
• /
• 1999

The setting of protective relays, which is critical to the power system security and reliability, requires a huge volume of data processing and repetitive calculation. Since it has been performed by relay engineers manually, it is vulnerable to human errors, its computerization has been pursued, in which the efficient management of the data is the key to the success. The database for power system protection must accommodate not only the power system network data but also a variety of protective devices. Also its information should be able to be viewed and updated with easy by operators and by computer programs. This paper describes several existing database designs for power system protection, their advantages and disadvantages. Also this paper has identified the required function and designed the database for the KEPCO power system data structure for the benefit of the relay setting process, etc..

• Proceedings of the Korean Society for Bioinformatics Conference
• /
• 2005.09a
• /
• pp.383-387
• /
• 2005

One of the most important issues in post-genome era is identifying functions of genes and understanding the interaction among them. Such interactions from complex biochemical pathways, which are very useful to understand the organism system. We present an integrated biochemical pathway database system with a set of software tools for reconstruction, visualization, and simulation of the pathways from the database. The novel features of the presented system include: (a) automatic integration of the heterogeneous biochemical pathway databases, (b) gene ontology for high quality of database in the integration and query (c) various biochemical simulations on the pathway database, (d) dynamic pathway reconstruction for the gene list or sequence data, (e) graphical tools which enable users to view the reconstructed pathways in a dynamic form, (f) importing/exporting SBML documents, a data exchange standard for systems biology.

• Proceedings of the KIEE Conference
• /
• summer
• /
• pp.683-685
• /
• 2004

This paper introduces a basic design for the short-term load forecasting system using a commercial data base. The proposed system uses a hybrid load forecasting method using fuzzy linear regression for forecasting of weekends and Monday and general exponential smoothing for forecasting of weekdays. The temperature sensitive is used to improve the accuracy of the load forecasting during the summer season. MS-SQL Sever has been used a commercial data base for the proposed system and the database is operated by ADO(ActiveX Data Objects) and RDO(Remote Data Object). Database has been constructed by altering the historical load data for the past 38 years. The weather iDormation is included in the database. The developed short-term load forecasting system is developed as a user friendly system based on GUI(Graphical User interface) using MFC(Microsoft Foundation Class). Test results show that the developed system efficiently performs short-term load forecasting.