• Asia pacific journal of information systems
• /
• v.6 no.1
• /
• pp.21-38
• /
• 1996

This paper investigates the performance improvement opportunities through a resiliency mechanism in the distributed primary/backup database system. Recognizing that a distributed transaction executes at several servers during its lifetime, we propose a resiliency mechanism which allows continuous transaction processing in distributed database server systems in the presence of a server failure. In order to perform continuous transaction processing despite failures, every state change of a transaction processing can be saved in the backup server. Obviously, this pessimistic synchronization may give more burdens than benefits to the system. Thus, the tracking needs not be done synchronously with the transaction progress. Instead, the state of all transaction processing in a system is saved periodically. This activity is referred to as a savepoint. Then, the question is how often the savepoint has to be done. We derive the optimal savepoint to identify the optimization parameters for the resilient transaction processing system.

• Proceedings of the Computational Structural Engineering Institute Conference
• /
• 2007.04a
• /
• pp.165-169
• /
• 2007

In order to develop VirtuAlmighty system, CPDM (construction project data management) and CPLM (construction project lifecycle management) model must be settled beforehand. Because most of information systems based on 3D-Design have its own database and business process. So, our team will develop collaboration management architecture of construction process for Decision Support based on PLM (Project Life-cycle Management). This architecture with business processes and Database can be used in process develop, process monitoring with many stakeholders of project, process change management, and so on.

• Journal of the Society of Naval Architects of Korea
• /
• v.46 no.1
• /
• pp.57-68
• /
• 2009

In automotive industries, reusability of product information is increasing through database construction of previous product data. The product data is stored by data quality management in product information systems. For naval ships, have the functional similarity by the ships of the same classification and class, that are built by series. Information of hull structures as well as embarked equipments are similar. So it would be effective to use database systems that are considered product information quality of previous ships in design and production processes. In this paper we discuss product information quality in database construction of naval ship product models. For this, we propose a basic concept and reference model for data quality verification. Based on this concept, A verification guideline is defined and it is applied for the case study of the digital naval ship which was built to the naval ship product model.

• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 1996.04a
• /
• pp.172-178
• /
• 1996

Databases are critical to business information systems, and RDBMS is most widely usded for the database system. Normalization has been designed to control various anomalies(insert, update, and delete anomalies). However, normalized databese design does not account for the tradeoffs necessary for the performance. In this research, we develop a model for database desin by denormalization of duplicating attributes in order to reduce frequent join processes. In this model, we consider insert, update, and delete costs. The anomalies are treated by additional disk I/O which is necessary for each insert and update transaction. We propose a branch and bound method for this model, and show considerable cost reduction.

• Journal of Environmental Impact Assessment
• /
• v.22 no.2
• /
• pp.183-194
• /
• 2013

The Ministry of Environment, Ministry of Agriculture, Fishery and Forestry, and Ministry of Construction, Transportation and Maritime Affairs are in charge of livestock manure management. There are national statistics regarding the livestock industry such as the National Pollution Source Survey, Livestock Statistic Survey, and Livestock-breeding Trend Survey. The current statistical data are focused on the scale of livestock breeding and the production of livestock manure using these data, but it is difficult to establish database due to lack of information. In order to plan relevant policies including management of livestock manure, the government established database systems such as the integrated information system of livestock manure, the integrated system of national infectious animal-disease prevention, and the Sae-ol public administrative system. We have tried to suggest improvements for the comprehensive environmental information system of livestock manure management by detecting problems in each level of the livestock manure life-cycle, making use of the existing systems, and considering the electronic transfer system of livestock manure. The services and functions of this comprehensive system include information of livestock farmers, the production, collection, transportation, and treatment of livestock manure, the area of agricultural land used for livestock manure, the report of approval and results on livestock manure products, management of statistical information, management of civil affairs, and relevant mobile application services. The system is made up of three processes: first, establishment of GIS-based management database of livestock manure; second, establishment of a history management system for livestock manure transactions; and third, development of a water quality assessment system.

• Korean Management Science Review
• /
• v.17 no.2
• /
• pp.151-159
• /
• 2000

This study applies factor analysis of an author cocitation frequency matrix derived from a database file that consists of a total of 1095 cited reference records taken from 95 citing decision support systems articles published in Korean journals. This study identified the influence of social psychology, cognitive psychology, management information systems, strategic management, and organizational behavior/organizational design to the development of group support systems, user-interface, and executive information systems research subspecialties. This research establishes a benchmark to be used in the future research, which is necessary to account for the ongoing changes in the intellectual development and structure of DSS Research in Korea before solid conclusion can be reached about the maturity and on-going development of the DSS field in Korean.

• Proceedings of the Korean Society of Computer Information Conference
• /
• 2017.01a
• /
• pp.271-272
• /
• 2017

본 논문에서는 교통사고 데이터베이스 구축을 통해 교통사교 현황과 사고 당시의 여러 정황들을 파악할 수 있는 정보를 제공한다. 이 정보들에는 사고 당시의 기상상태, 도로형태, 차종, 연령, 성별 등의 데이터들이 포함되고 이러한 정보들을 바탕으로 데이터베이스 사용자들은 각 사고 별 종합적인 정보를 얻을 수 있다. 이를 통해 정부 당국 외에 보험사 등에 교통사고 관련 정책을 위한 유용한 정보들을 제공할 수 있다. 또한 운전자 개인들에게도 정보들을 제공해 교통사고를 보다 효율적으로 예방할 수 있다.

• Asia pacific journal of information systems
• /
• v.11 no.2
• /
• pp.181-203
• /
• 2001

As the Internet is used extensively, multimedia information becomes more prevailing and accessible. However, legacy decision support systems rarely mention how to put such multimedia contents into practical use for decision making and support. In particular, no proposals have yet been made on how to integrate the decision technologies and multimedia databases in model management systems. Hence, the aim of this paper is to propose a new model management method to integrating decision technologies and an image database management system to create a multimedia decision support. For this purpose, extended ARG and structured modeling techniques are adopted, to represent image contents and mathematical models respectively. A web-based prototype system is presented to illustrate the feasibility and usability of the methodology.

• Journal of the Korean Society of Systems Engineering
• /
• v.6 no.1
• /
• pp.61-68
• /
• 2010

Generally EPC management system was simply management concept through the normal S/W. Our LNG Plant R&D Center wanted to the excellent management system from the S/W. So We developed the R&D management S/W and EPC management S/W Built in the Microsoft Project Server. Our system made to the customer Requirements. It was just User Interface protocol. But User Interface has more Weak position, because it makes from the MS Project Servers. Ms Projector server make easy to treat the project on the WBS. EPC parts mixed WBS and normally Ms SQL Database. It has very complicated Structures. Now We planed to make the general Database and Ms Project Server, It' means to the S/W Developer and Schedule Manager ability. We will successfully integrate R&D management system and EPC system and other softwares.

• Korean Management Science Review
• /
• v.9 no.1
• /
• pp.53-65
• /
• 1992

Decision Support System(DSS) is an advanced information system concept prevailing since 1980s. It supports managers' decision making activities by providing not only information but decision alternatives. It essentially consists of the components of database, modelbase and dialogue systems. With the development of its databases, POSCO needs a number of modelbases in establishing DSSs in various areas such as production planning and investment. This research particularly focuses on establishment of a mid-and long-range investment DSS and investigates the necessity and the problems of an investment DSS and the decision criteria for investment priority. We (1) propose a modelbase which uses the concepts of Analytic Hierarchy Process(AHP) and Zero-Base Budgeting(ZBB), along with an appropriate scoring method, database and dialogue system to support the investment manager in evaluating investment proposals ; (2) implement the system using relational database management system ; and (3) discuss the results of implementing the investment DSS.