• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.20 no.44
• /
• pp.123-128
• /
• 1997

A data base design framework for predictive a preventive-maintenance system is presented in this paper in order to effectively control machines and reduce accident rates in the workplace. The data base is designed to meet general management requirements to evaluate different maintenance strategies. There are seven data files: the equipment list maintenace pesonnel, maintenance history, maintenance specification, spare part, maintenance equipment, and maintenance schedules. Each data base file has several record based upon data acquisition.

• IE interfaces
• /
• v.16 no.2
• /
• pp.229-239
• /
• 2003

The On-Line Analytical Processing (OLAP) tools access data from the data warehouse for complex data analysis, such as multidimensional data analysis, and decision support activities. Current research has lead to new developments in all aspects of data warehousing, however, there are still a number of problems that need to be solved for making data warehousing effective. View maintenance, one of them, is to maintain view in response to updates in source data. Keeping the view consistent with updates to the base relations, however, can be expensive, since it may involve querying external sources where the base relations reside. In order to reduce maintenance costs, it is possible to maintain the views using information that is strictly local to the data warehouse. This process is usually referred to as "self-maintenance of views". A number of algorithm have been proposed for self maintenance of views where they keep some additional information in data warehouse in the form of auxiliary views. But those algorithms did not consider a consistency of materialized views using view self-maintenance. The purpose of this paper is to research consistency problem when self-maintenance of views is implemented. The proposed "conveyor algorithm" will resolved a complete consistency of materialized view using self-maintenance with considering network delay. The rationale for conveyor algorithm and performance characteristics are described in detail.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.21 no.48
• /
• pp.279-289
• /
• 1998

This study deals with the schemes of design, plan and operate maintenance management support systems and with the engineering approach for the solutions to build the maintenance management for the production efficiency. Maintenance Management Information System(MMIS) is the task that must focus on machinery historical data and planned maintenance action. Also the efficient supporting system in a maintenance management is achieved by database which is based on process of machinery's failure history. Designing method of maintenance management information system, maintenance modules are consisted of six factors ; machinery's historical data, lubrication control, check sheet, repair work, availability report, and performance report(control board and detailed reports), and then operators can rapidly utilize data in work place. In the implementation of designed model, program coding has been developed by Visual Basic 3.0. Data insertion, deletion and updating which perform menu screen is implemented by reading data from database. Implementation model based on LAN environment and related data is stored in Microsoft DBMS.

• Journal of the Korean Institute of Educational Facilities
• /
• v.19 no.5
• /
• pp.21-28
• /
• 2012

Current maintenance costs of the educational facilities have been determined by the years of services according to their foundation year. However, these maintenance costs have not considered maintenance and repairing. Therefore, this study suggests a new method to recalculate the years of services of schools by using the data of maintenance and repairing which is stored in the CAD drawing of the educational facilities. Also, since the data of maintenance and repairing has to be kept only for 5 years, the data is limited for the BTL project which has a maintenance period of 20 years. Thus, this study developed a new model to expand 5 years' data to the period of 20 years. This proposed model is expected to contribute in the maintenance and repairing of the BTL project.

• Proceedings of the Computational Structural Engineering Institute Conference
• /
• 1990.10a
• /
• pp.105-110
• /
• 1990

Effective maintenance system for national highway bridges has been requested due to increasing numbers of bridges. In this study, bridge data base is established in accordance with rating criteria for the structural conditions and functions of bridges. Maintenance system using PC-80386 hardware and ORACLE software is developed to rank the priority of either reconstruction or repairing of bridges and to provide with those information to bridge maintenance staff in order to perform bridge maintenance effectively. With this pre-establised data base and computerized maintenance system, data and information for planning of bridge construction could be obtained in times.

• Proceedings of the KSR Conference
• /
• 2000.05a
• /
• pp.503-510
• /
• 2000

Recently, many kinds of research has been actively developing for a standardization and information related to the construction works. These works include the general field of design, construction, supervision, maintenance and management on facilities. The works of database construction for a standardization and information were chiefly propelled centering around the present conditions related to the design, construction work. The field related to maintenance and management on facilities lags behind in the works of database construction. The establishment of standard classification system(SCS) on facilities and inspection data is most important among the things related to maintenance and management to have a efficiently maintenance and management. This paper suggests SCS on facilities and inspection data according to that of facilities. On the basis of SCS of facilities and inspection data, code work with classification system and input work for a data of maintenance and management was practised. The purpose of this paper is to suggest a kind of statistics data and investigate a characteristics of inspection using statistic data on tunnel structures

• Journal of the Korea institute for structural maintenance and inspection
• /
• v.4 no.4
• /
• pp.129-140
• /
• 2000

Retaining wall is a constructed structure in order to construct road, rail, building for effective use and obtainments of the limited ground. Recently, many kinds of research have been actively developed for a standardization and information to the maintenance and management of bridge, tunnel, road. With the works of database construction of that, many kinds of data with respect to statistics is cumulated. Database work of retaining wall is wholly lacking and lagged behind in the works of database construction. This paper suggests classification system on inspection data. On the basis of that, code work with classification system was practised and DB program of inspection data of retaining wall was developed. And input work for a data of maintenance and management was practised. The purpose of this paper is to suggest a kind of statistics data and investigate a characteristics of inspection using statistic data on retaining wall.

• Korean Journal of Construction Engineering and Management
• /
• v.13 no.4
• /
• pp.69-77
• /
• 2012

The construction data should be controlled from the life-cycle perspective. The current PMIS (Project Management Information System) usually focuses on the construction operation stage. The PMIS does consider the utilization of the construction in the maintenance of constructed facilities. This paper tries to interface the construction data with the maintenance data for effective use of construction data in the life-cycle perspective. To achieve the research objective, a maintenance breakdown structure is established and connected to the work breakdown structures. The connection of the two breakdown structures provide a structured utilization of construction data for efficient maintenance work activities. A prototype suggests that the interface of maintenance and work breakdown structures can help provide a construction and maintenance data in a more efficient way for maintenance activities.

• Journal of Cadastre & Land InformatiX
• /
• v.47 no.1
• /
• pp.237-250
• /
• 2017

This study focuses on the maintenance of the registration details of the cadastral study (drawings, chiefs) in relation to Uiwang city real estate administration information unification project by the data maintenance business. The purpose of this study is to provide high quality data and improve the efficiency of data maintenance business in the unification of real estate administration information together with the intellectual study diffusion maintenance model in the future. In this study, based on the results of the intellectual study data maintenance project and the effectiveness of institutional, temporal and cost aspects, it was able to show the effect of the data maintenance project. And analyzed the current situation, typed the error shown here, and developed the maintenance plan and maintenance result.

• Journal of the military operations research society of Korea
• /
• v.22 no.1
• /
• pp.142-155
• /
• 1996

In this research, our objective is to develop a model which could evaluate the maintenance capability for a maintenance battalion in the mechanized division. To analyze the maintenance system, we obtained various data related to maintenance capability and described the maintenance process as a network type. This network type model is then translated to SLAM-II network model to simulate the system. The simulation model can be operated by using appropriate input data and simulation results are obtained. The simulation model can be applied in various way. Through the simulation we could find the bottle neck point in the maintenance process. Also the maximum capability of maintenance with on hand asset and the wartime supportability can be evaluated. The mode provides sensitivity analysis by changing various imput data such as the number of repairmen, repair time, failure rate and so on.