• Proceedings of the Korea Society for Industrial Systems Conference
• /
• 2007.02a
• /
• pp.163-167
• /
• 2007

We propose an XML document storage system, called XDMS (XML Document Management System), by using an object-relational DBMS. XDMS generates object database schema from XML Schema and stores the XML documents in an object-relational database. SAX parser is used for understanding the structure of the XML documents, and XDMS transforms the documents into objects in the database. Experiment shows that object-relational databases provide more efficient storage and query model compared with relational databases.

• Korean Journal of Computational Design and Engineering
• /
• v.18 no.6
• /
• pp.407-416
• /
• 2013

Acting an important risk management tool for main contractors, pre-qualification has served a key marketing tool for subcontractors in various industries. Current industrial environment has required the time intensive pre-qualification ability to small and medium-size subcontractors as a matter of competitive business. In order to support the subcontractors, this paper proposes a database model for pre-qualification management system (PQMS) that automates the pre-qualification process by using information technologies. The modeling process consists of specifications for its requirements, functional modules, and a database model for the PQMS.

• The Transactions of The Korean Institute of Electrical Engineers
• /
• v.65 no.3
• /
• pp.469-476
• /
• 2016

Relational Database Management Systems have become de facto database model among most developers and users since the inception of Data Science. From IoT devices, sensors, social media and other sources, data is generated in structured, semi-structured and unstructured formats, in huge volumes, thereby the difficulty of data management greatly increases. Organizations that collect large amounts of data are increasingly turning to non relational databases - NoSQL databases. In this paper, through experiments with real field data, we demonstrate that MongoDB, a document-based NoSQL database, is a better alternative for building a Telco Subscriber Data Management System which hitherto is mainly built with Relational Database Management Systems. We compare the existing system in various phases of data flow with our proposed system powered by MongoDB. We show how various workloads at some phases of the existing system were either completely removed or significantly simplified on the new system. Based on experiment results, using MongoDB for managing telco subscriber data turned out to offer performance better than the existing system built with MSSQL Server.

• Journal of the Korean Society of Safety
• /
• v.28 no.1
• /
• pp.40-46
• /
• 2013

In the chemical process industries, accidents have a high potential and large effects on catastrophic results. Therefore the safety management for accident prevention plays a crucial role to guarantee the process safety. For these reasons, many systematic methods for safety management system have been widely employed in the fields of chemical processes. PSM (Process safety management) is one of most representative methods. The audit system, which is one of PSM system components, evaluates the performance of PMS system. However, most existing safety audit systems are not systematic and these are performed based on knowledges and experiences of various specialist. Moreover, the safety audit is only performed based on each independent technical component. So, the results of safety audit are not a quantitative index but only a series of commentaries. Finally, it is very difficult to obtain the comparison with other plants or industries. In this study, the novel systematic method and index-based accident database of auditing safety management systems for quantitative assessment are proposed. First, the elements of safety audit replace technical methods to categories of accident database. The F-N curve of each category for accident database is employed to derive the index for quantitative assessment. The Accidental Factor Risk Index (AFRI) is suggested for evaluating the effect of each element in accident database and safety audit system. The safety audit can be modified according to the proposed index.

• 한국디지털정책학회:학술대회논문집
• /
• 2004.05a
• /
• pp.575-592
• /
• 2004

In modern dynamic management environment, there is growing recognition that? information & knowledge management systems are essential for CEO's efficient/effective decision making. As a key component to cope with this current, we suggest the management performance analysis syystem based on Knowledge Discovery in Database (KDD). The system measures management performance that is considered with both VA(Value- Added), which represents stakeholder's point of view and EVA(Economic Value-Added), which represents shareholder's point of view. The relation ship between management performance and some 80 financial ratios is analyzed, and then important financial ratios are drawn out. In analyzing the relationship, we applied KDD process which includes such as multidimensional cube, OLAP(On-Line Analytic Process), data mining and AHP(Analytic Hierarchy Process). To demonstrate the performance of the system, we conducted a case study using financial data over the 16-years from 1981 to 1996 of Korean automobile industry which is taken from database of KISF AS(Korea Investors Services Financial Analysis System).

• Spatial Information Research
• /
• v.11 no.1
• /
• pp.33-40
• /
• 2003

For effective management of information about establishment and repair of road and road facilities, we built GPS-Van mapping system that CCD Cameras, GPS receivers and INS are integrated and using it surveyed test area. Suggested a scheme that possible put acquired data into photo database systematically. Prototype of road facilities management system using the database shows us that extraction of qualitative information and management are possible through relation attribute information. And it raise cognitive faculty of user about objects using field photographs.

• Journal of the Korean Society for Precision Engineering
• /
• v.17 no.10
• /
• pp.89-94
• /
• 2000

Engineering database for CIM of injection mold production has been developed to manage design information and parameters of injection mold. The database has direct connection with product data management system and management database. Design specifications are generated in initial stage of mold design with integration of management information. Design parameters and bill of materials for mold base parts are generated during the CAD process and transferred to the manufacturing database and procurement system. Standard modules for parts and mold base are constructed using national standard and legacy data of industries. The engineering database provides important information route for CIM of injection mold design and production.

• Korean Management Science Review
• /
• v.17 no.2
• /
• pp.97-113
• /
• 2000

The introduction of client server systems raises some serious IS control concerns. Although client server systems increase system flexibility and compatibility, and facilitates system downsizing and process restructuring, multiple operating systems, database management systems, and platforms of client-server system increase th potential exposures and risks of the system. It is needed to recommend the effective control framework to mitigate risks. This paper suggests risks and control framework for client server system. The results of two case studies indicate that program and database management are important as program and data should be located and maintained in client and servers. It becomes difficult to manage divided programs and data logic that are distributed across clients and servers that have different platforms. The case studies of two banks show that the extent of distribution of program and data logic affects the importance of program and database management controls.

• Journal of the Institute of Electronics Engineers of Korea TC
• /
• v.43 no.2 s.344
• /
• pp.49-55
• /
• 2006

This paper describe the most advanced database management system for the mobile number portability(MNP) in the world The database management system can process the procedure of porting_out and porting_in in 30 minutes and it is the shortest time in the world. The MNP DB management system consists of two functional blocks, one is for the call processing system and the other is for the management of subscriber of MNP. The hardware and processing algorithm are presented in this paper. The DB for call processing is located at each mobile operator and be called local number portability database (L-NPDB). The DB for the management of subscriber of MNP consist of L-NPDB and master database which is located at the Korea telecommunications operators association(KTOA). The hardware database system for MNP consists of the interconnection system of master-NPCDB (NP customer database, M-NPCDB), local-NPCDB, M-NPDB and L-NPDB. The master database is interconnected to the local database through dedicated line and can process any MNP service in real time. The presented MNP structure in this paper has been implemented in Korea and became the most effective and advanced DB management system for MNP in the world.

• Journal of the Society of Naval Architects of Korea
• /
• v.51 no.1
• /
• pp.51-57
• /
• 2014

In the KIOST MOERI model ice basin, a lot of experiments to find the material properties of model ice and model ship tests are being performed. And therefore many data information was produced, yet it was saved as excel data format. In order to manage and use the data more effectively and systematically, a proper database management is required. To make realistic engineering DBMS(database management system), understanding of test process, the usage of data, design of data schema and computer language and system management are required. In this paper, basic design process and usage of DBMS based on network and multiple user concept is introduced.