• 한국산업정보학회:학술대회논문집
• /
• 한국산업정보학회 2007년도 춘계학술대회
• /
• 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.

• 한국CDE학회논문집
• /
• 제18권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.

• 전기학회논문지
• /
• 제65권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.

• 한국안전학회지
• /
• 제28권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.

• Spatial Information Research
• /
• 제11권1호
• /
• pp.33-40
• /
• 2003

본 논문에서는 도로 및 도로시설물의 신설과 보완에 관련된 정보의 효과적인 관리를 위해 CCD(Charge-Coupled Device) 카메라, GPS(Global Positioning Systems), INS(Inertial Navigation Systems)와 같은 3개의 위치관측센서를 통합한 차량을 이용하여 시범지역을 측량하고 이를 통해 획득된 자료를 구조적으로 Photo Database에 저장할 수 있는 방안을 제시하였다. 저장된 Database를 이용한 도로시설물관리시스템의 프로토타입(Prototype)은 해당지점에 대한 실제사진을 이용해서 사용자의 대상물에 대한 인식성을 높이고 속성정보와의 연계를 통해서 해당 시설물에 대한 정성적인 정보추출과 관리가 가능함을 보여주었다.

• 한국정밀공학회지
• /
• 제17권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.

• 한국디지털정책학회:학술대회논문집
• /
• 한국디지털정책학회 2004년도 춘계학술대회
• /
• 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).

• 경영과학
• /
• 제17권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.

• 대한전자공학회논문지TC
• /
• 제43권2호
• /
• pp.49-55
• /
• 2006

본 논문은 이동전화 번호이동성을 위한 세상에서 가장 진화된 데이터베이스 관리 시스템에 관한 것이다. 데이터베이스 관리 시스템은 번호이동 절차를 30분안에 완료할 수 있고, 그것은 현재 세상에서 가장 빠른 것이다. 이동전화번호이동성 데이터베이스 관리시스템은 두개의 기능 블락으로 구성되어 있는데, 하나는 호처리시스템이고 하나는 이동전화번호이동성의 가입자들이다. 하드웨어와 처리구조가 본 논문에 제시되어 있다. 호처리를 위한 DB 는 각각의 이동전화 사업자망에 위치하고 있으며 L-NPDB라고 불리운다. 이동전화 번호이동성의 가입자를 다루는 DB는 L-NPDB와 한국통신사업자연합회에 있는 maste-NPDBT로 구성되어 있다 이동전화 번호이동성을 위한 하드웨어는 NPCDB와 L-NPDB와 M-NPDB간의 상호접속으로 구성되어 있다. master 데이터베이스는 L-NPDB와 전용선으로 연결되어 있으며, MNP 서비스를 실시간으로 처리할 수 있다. 본 논문에서 제안하는 이동전화 번호이동성 구조는 한국에서 실제로 구현되었고 이동전화 번호이동성을 위한 세계에서 가장 효율적이고 진화된 데이터베이스 관리 시스템이 되었다.

• 대한조선학회논문집
• /
• 제51권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.