• KIPS Transactions on Software and Data Engineering
• /
• v.5 no.5
• /
• pp.203-208
• /
• 2016

Information system audit is the requirement to configure the information system successfully. However, there is a problem with reduction of efficiency in the audit work when the system capacity is growing up. In the subsidiary field of information system audit, there is the same problem. In this paper, we will focus on the database audit, and implement an SQL audit tool in order to improve the performance of a database. During the designing phase of the SQL audit tool which aim to improve the performance of a database, we have analyzed the requirements of SQL audit work. Based on the aforementioned them, the process of the SQL audit tool has been designed with SQL audit features in accordance with information audit process. During the implementation phase, we have implemented 3 main function modules according to the output of the design phase. The main modules we implemented are the audit job definition module, audit job executing module and result reporting module. With the implemented tool, it applied to an Electric Power Corporation project in China and compared with other tools that are able to use SQL audit. In this paper, the implemented SQL audit tool is able to perform the general SQL audit work and to reduce the cost of the audit work for database performance and to raise the accuracy of result and to apply the extended inspection rule which need to use SQL parsing.

• Journal of the Korea Society of Computer and Information
• /
• v.3 no.3
• /
• pp.23-30
• /
• 1998

The ODBC(Open Database Connectivity) is particularly efficient in the dynamic client/server environment. Besides, the ODBC provides the functions that can handle multimedia data. Due to this feature, we are able to use the DBMS that supports the ODBC as a multimedia server. In this thesis, we describe the development of the ODBC driver for Relational DBMS. The Relational DBMS ODBC Driver consists of the client module and the server module. The client module is called the SRM(Server Request Module) and the server module is CSM(Client Service Module). These two modules are connected through the network module called the NSM(Network Service Module). We have conducted both the functional and the interoperability test of our ODBC Driver It turned out that the ODBC driver operated with these client DBMS tools successfully. In all, due to our development of the Relational DBMS ODBC Driver, DBMS is now capable of processing multimedia data and supporting the client applications including the DBMS tools.

• Proceedings of the KSME Conference
• /
• 2001.06d
• /
• pp.903-908
• /
• 2001

A web-based client/server program, MOVIDIK(Motor-Operated-Valve Integrated Database Information of KEPCO) has been developed to perform a design basis safety evaluation for a motor-operated-valve(MOV) in the nuclear power plant. The MOVIDIK consists of seven analysis modules and one administrative module. The analysis module calculates a differential pressure on the valve disk, thrust/torque acting at a valve stem, maximum allowable stress, thermal-overload-relay selection, voltage degradation, actuator output and margin. In addition, the administrative module manages user information, approval system and code information. MOVIDIK controls a huge amount of evaluation data and piles up the safety information of safety-related MOV. The MOVIDIK will improve the efficiency of safety evaluation work and standardize the analysis process for the MOV.

• Journal of the Korea Computer Industry Society
• /
• v.7 no.4
• /
• pp.281-292
• /
• 2006

A general purpose ERP system is often unsuitable to manage the products of a small and medium enterprise. Thus, it is necessary to develop and use a system which is suitable for characteristic of an enterprise. In this paper, we implement a raw and subsidiary materials management system which controls the many products of an enterprise producing electrical wire. First, we design a database of raw and subsidiary materials information for production process. Second, we develop an automatic calculation module which computes the necessary quantify of materials to produce goods ordered. Third, the proposed system manages purchasing and selling data of raw and subsidiary materials in production process. Finally, we implement not only a history management module of storage and delivery, but also a print module of history summary report.

• Transactions of the Korean Society of Mechanical Engineers B
• /
• v.27 no.3
• /
• pp.398-405
• /
• 2003

A fast response analyzer for measuring carbon dioxide concentration has been developed for transient characteristic and researches tested on internal combustion engine. The analyzer uses the well known NDIR(Non-Dispersive Infrared) method with miniaturized detection system, giving a time constant of approximately 30 microsecond, and sampling module consists of capillary tube. Since the transit time and the time constant of the sampling system depend on the sampling conditions, it is necessary to investigate the characteristics of sampling system before applied to exhaust gas measurement in engine. A unique method was designed to study the influence of the diameter of transfer sample line and operating conditions of the FRNDIR on transit time and time constant. A database of transit time and time constant was built up for different measured and simulated pressure conditions. The database can be used for correcting eventual $CO_2$ concentration measurement.

• Proceedings of the Korean Society for Noise and Vibration Engineering Conference
• /
• 2003.05a
• /
• pp.303-312
• /
• 2003

This paper suggests a fuzzy expert system for fault diagnosis of rotating machinery, based on modulated databases. In the proposed system, alarm and trip levels are set based on ISO, considering operating condition, machinery type and maintenance history. Input signals for diagnosis, such as sub- and super-harmonic components of vibration and mean value, are normalized from 0 to 1 under the threshold level and otherwise equal to one so that chronic faults slightly below the threshold level can be monitored. The database for diagnosis consists of two modules: the well-known Sohre's chart module and if-then type rules. The Sohre's chart is utilized for the most common problems of high-speed turbomachinery, while the rule-based module, which was collected from many papers and reports, is for diagnosing peculiar faults according to the type of machinery. To infer the results from two modules, a fuzzy operation of Yager sum was adopted. Using a simulator constructed in laboratory, experimental verification was performed for the cases of resonance and housing looseness which were intended. The experimental results show that the proposed fuzzy expert system has feasibility in practical diagnosis of rotating machinery.

• Journal of the Korean Institute of Intelligent Systems
• /
• v.7 no.4
• /
• pp.1-8
• /
• 1997

In this paper, we propose a new intelligent query processing system for relational database !systems. By analyzing previous research results related with fuzzy queries, a new intelligent query processing sysytem is developed and the role of each module including intelligent query processor is defined and :some algorithms for parser, query translation module, inference engine, semantic DB and result com-poser are suggested. By applying a typical example to the proposed intelligent query processing liysytem, reasonable results for the ambiguous query are drawn, and therefore it shows a promising model returning ordered result for both the ambiguous queries and general queries.

• Journal of the Korean Society for Precision Engineering
• /
• v.17 no.12
• /
• pp.157-162
• /
• 2000

The object of this work is to develop an assessment system for pipeline integrity. the system consists of four module applications for internal algorithm; the effect of corrosion in pipeline, crack, stress corrosion crack (SCC) and fatigue modules. Presently, the module of the external corrosion has been developed and the internal algorithm for the effect of corrosion in pipeline and the database of the system are described in this paper. The database of the system is separated to mainly four parts; geometry of pipeline, material properties, boundary conditions and general properties. Each components of the system are designed by user-friendly concept. This system may give a guideline for maintenance and modifications for the pipeline at the industrial sight. Furthermore, a procedure to evaluate an inspection interval is also provided.

• Proceedings of the Korean Institute of Industrial Safety Conference
• /
• 2000.06a
• /
• pp.25-30
• /
• 2000

The object of this work is to develop an assessment system for pipeline integrity The system consists of four module applications for internal algorithm; the effect of corrosion in pipeline, crack, stress corrosion crack (SCC) and fatigue modules. Presently, the module of the external corrosion has been developed and the internal algorithm for the effect of corrosion in pipeline and the database of the system are described in this paper, The database of the system is separated to mainly four parts; geometry of pipeline, material properties, boundary conditions and general Properties. Each components of the system are designed by user-friendly concept. This system may give a guideline for maintenance and modifications for the pipeline at the industrial sight. Furthermore, a procedure to evaluate an inspection interval is also provided.

• Proceedings of the Korean Society of Precision Engineering Conference
• /
• 2001.04a
• /
• pp.307-310
• /
• 2001

In this paper, development of TIM Module for constructing PDM will be introduced. Technical information relevant product data influences cost, quality, precision and productivity. One of the very important feature of product data is organizing not by oneself but very closed to many technical information such as document, file, image and analysis sheet. To manage various technical information, several kinds of management system are used in multi level of production system. PDM and TIM systems are being developed for suitable purpose and are in need of Network technology, Information Technology, Database, sharing and distributing information. Developed TIM system is based on Web environment. By using this system, we can manage systematic technical information and reduce cost for constructing PDM system. And also we will put to practical use another technical information management system for mold plant.