• 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 Information Technology Services
• /
• v.21 no.4
• /
• pp.63-74
• /
• 2022

Globally researchers at medical institutions are actively sharing COHORT data of patients to develop vaccines and treatments to overcome the COVID-19 crisis. OMOP-CDM, a common data model that efficiently shares medical data research independently operated by individual medical institutions has patient personal information (e.g. PII, PHI). Although PII and PHI are managed and shared indistinguishably through de-identification or anonymization in medical institutions they could not be guaranteed at 100% by complete de-identification and anonymization. For this reason the security of the OMOP-CDM database is important but there is no detailed and specific OMOP-CDM security inspection tool so risk mitigation measures are being taken with a general security inspection tool. This study intends to study and present a model for implementing a tool to check the security vulnerability of OMOP-CDM by analyzing the security guidelines for the US database and security controls of the personal information protection of the NIST. Additionally it intends to verify the implementation feasibility by real field demonstration in an actual 3 hospitals environment. As a result of checking the security status of the test server and the CDM database of the three hospitals in operation, most of the database audit and encryption functions were found to be insufficient. Based on these inspection results it was applied to the optimization study of the complex and time-consuming CDM CSF developed in the "Development of Security Framework Required for CDM-based Distributed Research" task of the Korea Health Industry Promotion Agency. According to several recent newspaper articles, Ramsomware attacks on financially large hospitals are intensifying. Organizations that are currently operating or will operate CDM databases need to install database audits(proofing) and encryption (data protection) that are not provided by the OMOP-CDM database template to prevent attackers from compromising.

• Journal of Korea Society of Industrial Information Systems
• /
• v.17 no.7
• /
• pp.43-50
• /
• 2012

Database for the information of the shape accuracy is constructed with the finite element stamping analysis of the center pillar member. Analyses are carried out in order to investigate the effect of tool compensation on the product quality previously performed by an expert in the press shop. The compensation procedure is provided with three sequences for improving shape accuracy of the member by reducing the amount of springback. The analysis result shows that shape inaccuracy in the product is caused by sagging and twisting phenomena from displacement of the section part due to excessive amount of springback. From the database with springback analyses, design modification guidelines are proposed for improving the shape accuracy. The guideline is directly applied to a member with the similar shape and the sound product is obtained successfully reducing the amount of springback.

• Journal of Korea Society of Industrial Information Systems
• /
• v.5 no.4
• /
• pp.16-21
• /
• 2000

Role Based Access Control(RBAC) reduces the cost of administering access control policies as well as making the process less error-prone. Administration tool is most important component in the concept of RBAC. The administration tool for the RBAC security system must be maintain the integrity of user-role and role-role relationships in the RBAC Database. Therefor, it is required set functions, properties defining integrity of database. When it will be designed security systems which is applying RBAC policy on the Linux(server system environments, this paper defines integrity of database for user-role and role-role relationships, and we propose formal specification of operation in order to manage these relationships. The proposed formal specification leads to the consistency requirements for the RBAC database which are defined as a set of relationship. Also, this paper can easily derive the implementation of the RBAC administration tool by formal specification of operations. It leads us tn the minimal set for a more efficiently implementation of administration tool.

• Korean Institute of Interior Design Journal
• /
• v.16 no.2 s.61
• /
• pp.314-321
• /
• 2007

The statistical method of human sensibility ergonomics is widely used for analyzing interior design because it has standard processes and it can help to get quantifiable results. However applying this method demands repeated intense work and great time and effort is required. In this study, a tool applying Web and virtual reality techniques for statistical human sensibility ergonomic interior design analysis is proposed and the key parts of the tool including database and interface are implemented. The database contains the sensibility adjective table and the physical interior design factor table for analyzing the relationship between human sense and physical design factors. Interface of the tool is implemented using Web technologies, so testers can evaluate interior design samples via standard Web browsers. The 3D control which is an important component of the interface is also implemented. Employing the suggested tool can reduce effort and time for evaluating human sense in Interior design field.

• Proceedings of the Korean Society of Precision Engineering Conference
• /
• 1997.10a
• /
• pp.60-63
• /
• 1997

Recently, factory automation and shop floor control system need a web based remote monitoring technology to control effectively machine tool. This paper describes a web based remote monitoring system which is concerned with open architecture controller for machine tool. The environment of this system consists of a lot of elements such as web server, database, machine tool, pc based controller, client computers and script programs, also which is interconnected by network including intranet or internet. Designed script programs, also which is interconnected by network including intranet or internet. Designed script program service current status and faults information of machine to remote users who want to monitor machine tool. Additionally those have various functions to service we board for q&a, downloading data and information of after-service managers.

• Journal of the Korean Institute of Telematics and Electronics B
• /
• v.32B no.7
• /
• pp.966-973
• /
• 1995

In this paper, we compare several methods for implementing a VHDL design database through a case study on VHDL tool development system. We implemented three versions of the VHDL design database which the VHDL tool development system is based on. The first version was coded in the C programming language following value-oriented paradigm. The second one was coded in the C++ programming language following object-oriented paradigm. The third one was implemented using an existing object-oriented database. Based on our experience, we present quantitatively the pros and cons of each implementation method. The value-oriented version was most difficult to implement but showed good performance. Compared to the value- oriented version, the C++ version was twice as easy to implement and showed about the same performance. Using an existing object-oriented database allowed easiest implementation but resulted in a 1.5 to 6 times slower version.

• Journal of the Korea Institute of Information Security & Cryptology
• /
• v.25 no.5
• /
• pp.1143-1151
• /
• 2015

Extensible Storage Engine (ESE) database is a database developed by Microsoft. This database is used in web browser like Internet Explorer, Spartan and in Windows system with Windows Search, System Resource Usage Monitor. Previous ESE database viewer can display an incorrect result and can't read the file depending on collected environment and status of files. And the deleted record recovery tool is limited to some program and cannot recover all tables. This paper suggests the universal recovery method for deleted records and presents the experimental results through development of tool.

• Proceedings of the Korean Society of Machine Tool Engineers Conference
• /
• 2001.10a
• /
• pp.185-189
• /
• 2001

In order to prevent the production defects the optimum design of product, jig and fixture putting in the field is very significant manufacturing method. Drilling Jig is the device according to industrial demand for multi manufacturing products on the growing at alarming rate. In the field of design and making for machine tool working, welding, assembling with jig and fixture for mass production is a specific division. They require analysis of many kinds of important factors, theory and practice of machine tool operating process and jig & fixture structure, machining condition for tool making, tool materials, heat treatment of jig & fixture components, know-how and so on. In this study we designed and constructed a drilling jig of mass production and performed tryout under the Auto CAD, Auto Lisp database, that we made by database, and window environment. Especially this study is reveals with the analysis of part drawing, jig planning, jig design etc, and then the result of drill jig's making try out.

• The Journal of Information Technology and Database
• /
• v.2 no.2
• /
• pp.25-34
• /
• 1995

In this paper, we present design philosophy and implementation issues of a functionality testing tool for object-oriented database systems. A testing tool has been developed to validate UniSQL/X functionalities with C++ interface. A testing tool is designed under consideration of scaleability, simplicity and extendibility. The schema is deliberately constructed to verify the object-oriented functionalities such as abstraction, inheritance and aggregation. Each test item has been derived under various black box techniques such as equivalent partitioning and boundary-value analysis. The testing tool consists of six phases, namely, database creation, database population, construction of testindex, compilation and link, execution and result reporting, and final cleanup. The prototype provides more than 140 test items at 90 programs.