• IE interfaces
• /
• v.16 no.4
• /
• pp.485-495
• /
• 2003

This paper reports on the application of the integration of mathematical programming model and database in a decision support system (DSS) for the planning of the multi-reservoir operating system. The DSS is based on a multi-objective, mixed-integer goal programming (MIGP) model, which can generate efficient solutions via the weighted-sums method (WSM). The major concern of this study is seamless, efficient integration between the mathematical model and the database, because there are significant differences in structure and content between the data for a mathematical model and the data for a conventional database application. In order to load the external optimization results on the database, we developed a systematic way of naming variable/constraint so that a rapid identification of variables/constraints is possible. An efficient database structure for planning of the multi-reservoir operating system is presented by taking advantage of the naming convention of the variable/constraint.

• IE interfaces
• /
• v.14 no.3
• /
• pp.247-254
• /
• 2001

As current postal automation is limited to dispatch and arrival sorting, delivery sequence sorting is performed manually by each postman. It not only acts as a bottleneck process in the overall mailing process but is expensive operation. To cope with this problem effectively, delivery sequence sorting automation is required. The important components of delivery sequence sorting automation system are sequence sorter and Hangul OCR which function is to extract the address of delivery point. DSI database will be interfaced to both Hangul OCR and sequence sorter for finding the accurate delivery sequence number and stacker number. The objectives of this research are to develop DSI(Delivery Sequence Information) database prototype and client application for managing information effectively. For database requirements collection and analysis, we draw all possible sorting plans, and apply the AHP(Analytic Hierarchy Process) method to determine the optimal one. And then, we design DSI database schema based on the optimal one and implement it using Oracle RDBMS. In addition, as address information in DIS database consist of hierarchical structure which has its correspondence sequence number, so it is important to reorganize sequence information accurately when address information is inserted, deleted or updated. To increase delivery accuracy, we reflect this point in writing application.

• Proceedings of the Korean Society of Surveying, Geodesy, Photogrammetry, and Cartography Conference
• /
• 2004.11a
• /
• pp.325-333
• /
• 2004

Since 1995, One of the NGIS(National Geographic Information System) projects, the underground utilities project has been finished in 2003. The 19 cities in korea for this project will use underground utilities management system using underground utilities database focusing on water and sewage system. However, special expert, technical and experience problem in computer environment has not been had in working department for water and sewage management and maintenance for each local government. The management and maintenance of underground utilities database by manual method is getting lowered a data quality of underground utilities database because of the data omitting, error in writing and securing of the lasted database. Therefore, in this study, Application test for field workers using a mobile tool and environment analysis of wireless communication in Korea and application test of GPS receiver for mobile tools had been processed and made a mobile working environment. The efficient management and maintenance method for underground utilities database has been developed an off- line method for modification and update of database about general work which has a high working frequency because of the limitation of wireless communication environment Also, the emergency working has been applied for on-line method.

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

Nowadays an information exchange on XML such as B2B electronic commerce is spreading. Therefore the systematic and stable management mechanism for storing the exchanged Information is needed. For this goal there are many research activities for connection between XML application and relational database. But because XML data have hierarchical structures and relational database can store only flat-structured data, we need to store XML data in object-oriented database that support hierarchical structure. Accordingly the modeling methodology for storing XML data in object-oriented database is needed. In order to build good quality application systems, modeling is an important first step. In 1997, the OMG adopted the UML as its standard modeling language. Since industry has warmly embraced UML, its popularity should become more important in the future. So a design methodology based on UML is need to develop efficiently XML applications. In this paper, we propose a unified design methodology for XML applications based on object- oriented database using UML. To this goal, first we introduce a XML modeling methodology to design W3C XML schema using UML and second we propose data modeling methodology for object-oriented database schema to store efficiently XML data in object-oriented databases.

• Journal of KIISE:Databases
• /
• v.31 no.4
• /
• pp.409-421
• /
• 2004

A database sharing system (DSS) couples a number of computing nodes for high performance transaction processing, and each node in DSS shares database at the disk level. In case of node failures in DSS, database recovery algorithms are required to recover the database in a consistent state. A database recovery process in DSS takes rather longer time compared with single database systems, since it should include merging of discrete log records in several nodes and perform REDO tasks using the merged lo9 records. In this paper, we propose a two version caching (2VC) algorithm that improves the cache fusion algorithm introduced in Oracle 9i Real Application Cluster (ORAC). The 2VC algorithm can achieve faster database recovery by eliminating the use of merged log records in case of single node failure. Furthermore, it can improve the performance of normal transaction processing by reducing the amount of unnecessary disk force overhead that occurs in ORAC.

• Journal of Korean Public Health Nursing
• /
• v.18 no.1
• /
• pp.154-166
• /
• 2004

The purpose of this study was to design and implementation of database for school health activity. This database system was designed stand-alone application for college school health center without a hospital affiliation and the database system was made of relational database management system, Microsoft access 2000 to be made GUI (Graphic user interface) type design and made up 7 tables: patients. symptoms. departments, income and outgo. medical cures. and medicine. The construction of this database system was patient management. code management. medicine management. and statistics management. The results of the database system were as follows; 1) This database system could be used for college school health center. 2) This database system could be made correct statistic data. 3) This database system could be managed income and outgo. 4) This database system could be changed for the better activity of community health service. 5) This database system could be simply attired administrative system. This database system will be used for students and employees to protect and promote health to measure for health level and quality of health service. In conclusion. this database system can be applied for unit health center to manage the college school health activity and advanced data management can be applied for health profession to do quality improvement. cost containment. management information system. and decision support system.

• Proceedings of the Korea Database Society Conference
• /
• 1994.09a
• /
• pp.105-129
• /
• 1994

The information system of corporations are facing a new environment expressed by miniaturization, decentralization and Open System. It is therefore of utmost importance for corporations to adapt flexibly th such new environment by providing for corresponding changes to their existing information systems. The objectives of this study are to identify this new environment faced by today′s information system and develop effective methods for data resource management under this new environment. In this study, it is assumed that the new environment faced by information systems can be specified as Distributed Computing Environment, and in order to achieve such system, presents Client/server architecture as its representative computing structure, This study defines Client/server architecture as a computing architecture which specialize the fuctionality of the client system and the server system in order to have an application distribute and perform cooperative processing at the best platform. Furthermore, from among the five structures utilized in Client/server architecture for distribution and cooperative processing of application between server and client this study presents two different data management methods under the Client/server environment; one is "Remote Data Management Method" which uses file server or database server and. the other is "Distributed Data Management Method" using distributed database management system. The result of this study leads to the conclusion that in the client/server environment although distributed application is assumed, the data could become centralized (in the case of file server or database server) or decentralized (in the case of distributed database system) and the data management method through a distributed database system where complete responsibility and powers with respect to control of data used by the user are given not only is it more adaptable to modern flexible corporate environment, but in terms of system operation, it presents a more efficient data management alternative compared to existing data management methods in terms of cutting costs.

• Proceedings of the Korean Society of Surveying, Geodesy, Photogrammetry, and Cartography Conference
• /
• 2003.10a
• /
• pp.257-262
• /
• 2003

This study is aimed to research the management methodology for the process of GIS database construction. In general, used methodologies are made for the purpose of application program development. And the methodologies reflected GIS characteristics are also applied for GIS software development. But the software methodologies are never introduced to construction of GIS database. In this study, various common methodologies are investigated and analyzed, and the methodology which include the characteristic of GIS database construction process as work steps and detail paths is developed and suggested.

• Proceedings of the Korea Database Society Conference
• /
• 1994.09a
• /
• pp.49-69
• /
• 1994

A client/server system has become the computing architecture for the business organization which seeks competitive edges. Technically, a client/server system places application processing close to the user and thus increases performance. This paper's two primary goals are (i) to present a performance model for client/server database systems and (ii) to demonstrate analytically the effectiveness of client/server computing in comparison with other computing architectures via an illustrative example. The model is most likely to be used as a practical performance guide for client/server computing.

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