• Industrial Engineering and Management Systems
• /
• 제9권3호
• /
• pp.215-226
• /
• 2010

Since product design strongly depends on the experience and ability of the designers, and a long lead time is required for the product design stage, introducing a support system related to this experience and ability is an effective technique to reduce the lead time. In this paper, an information system is developed to support the development of engineering mechanisms with the evaluation of the assembly process on the basis of the abstract functions required for new products. The developed system is based on a database system involving the following data structure: (1) a hierarchical structure related to information about the product functions, (2) the relationship between the parts and engineering functions and/or mechanisms of products, and (3) the relationship between the parts and manufacturing characteristics. The system stores the relationships between the product functions, structure of parts, and assembly characteristics. This information can then be interactively retrieved using the data structure described in (1), (2), and (3). A procedure for designing new products is proposed that involves using the information about existing products. This paper presents the characteristics of the proposed procedure and the developed information system. In addition, a case study of the redesign of a simple structured robot by using the proposed procedure is discussed.

• 정보처리학회논문지:컴퓨터 및 통신 시스템
• /
• 제6권2호
• /
• pp.59-66
• /
• 2017

MySQL 데이터베이스는 현재 데이터베이스 시장 점유율에서 2위를 차지하고 있다. 특히 InnoDB 스토리지 엔진은 MySQL 5.5 버전부터 디폴트 스토리지 엔진으로 사용되어 왔으며, 많은 기업에서 InnoDB 스토리지 엔진으로 MySQL 데이터베이스를 사용하고 있다. 디지털 포렌식 분야에서 InnoDB 스토리지 엔진에 대한 구조적 특징과 로그에 관한 연구는 꾸준히 진행되어 왔으나, 삭제된 데이터에 대해 레코드 단위로 복구하는 방법에 대해서는 연구되지 않았다. 기업 조사 시 데이터베이스 관리자가 사전에 증거 인멸을 목적으로 데이터를 훼손하는 경우가 많으므로 이를 복구하는 것은 포렌식 수사 과정에서 중요하다. 본 논문에서는 MySQL InnoDB 스토리지 엔진의 구조를 분석하여 삭제된 데이터를 레코드 단위로 복구하는 기법을 제안하고 제작한 도구를 활용하여 이를 검증한다. 이는 디지털 포렌식 관점에서 데이터베이스 안티포렌식 행위에 대해 대비할 수 있으며, MySQL InnoDB 데이터베이스와 관련된 사건 발생시, 고의로 삭제된 데이터를 복구하는데 활용할 수 있다.

• 농촌계획
• /
• 제11권2호
• /
• pp.43-49
• /
• 2005

As information has been brought to public attention, information storage as well as information usability has been important. Rural information is produced in many areas and institutions. However, it is difficult to use rural information comprehensively. Since formats for management are various, it is difficult to have unified frame. In this research, a schema of database fer integrating rural data is designed to improve usability using dimensional modeling. First of all, rural data are analyzed for designing integrated rural database schema. Rural data used are 'National Agricultural Statistics' and 'Gun annual statistical report'. Analysis shows that there are three considerations; administrative district, time-dependency and classification of data. Considering these three requisite, we designed database schema using dimensional modeling. The reason of using dimensional modeling is to improve usability and effectiveness. If the database was designed using ER modeling, many tables have to be joined every searching time. Separately from integrated rural database schema, user's database schema is designed considering usability. Through user's database, users can modify data or generate new data and save these processes. These make it possible to use generated data repeatedly. We evaluate usability, contribution, and effectiveness of data manipulation on the integrated rural database. We propose an integrated rural database structure improving the accessibility and usability of rural data and information and verified the data model based on a practical example.

• 전산구조공학
• /
• 제23권2호
• /
• pp.21-26
• /
• 2010

• 한국환경복원기술학회지
• /
• 제20권1호
• /
• pp.143-150
• /
• 2017

In this study, we intend to integrate the database(DB) method into one logical structure that is related to damage such as cause and type of damages occurring in the DMZ area. We divided the DMZ members into two types, which are classified into qualitative and quantitative aspects based on the current status survey for three years as a study of database construction, So that the actual data can be utilized in future restoration. The database construction through each restoration direction regarding the type of DMZ corruption is as follows. First, we recognized the necessity of restoration of the damaged area of the DMZ, and approached it as a plan to select the damaged mark. Second, DMZ database reconstruction can be used as a restoration of damages, suggesting more information and restoration type through building an ecological database for education and research. Third, in order to maintain and restore restoration of damaged areas continuously at the national level, it is necessary to institutionalize guidelines for reasonable internal restoration in the national level as data that can be credited externally and can be acknowledged as the latest data.

• 산업공학
• /
• 제14권3호
• /
• pp.247-254
• /
• 2001

As current postal automation is limited to dispatch and arrival sorting, delivery sequence sorting is performed manually by each postman. It not only acts as a bottleneck process in the overall mailing process but is expensive operation. To cope with this problem effectively, delivery sequence sorting automation is required. The important components of delivery sequence sorting automation system are sequence sorter and Hangul OCR which function is to extract the address of delivery point. DSI database will be interfaced to both Hangul OCR and sequence sorter for finding the accurate delivery sequence number and stacker number. The objectives of this research are to develop DSI(Delivery Sequence Information) database prototype and client application for managing information effectively. For database requirements collection and analysis, we draw all possible sorting plans, and apply the AHP(Analytic Hierarchy Process) method to determine the optimal one. And then, we design DSI database schema based on the optimal one and implement it using Oracle RDBMS. In addition, as address information in DIS database consist of hierarchical structure which has its correspondence sequence number, so it is important to reorganize sequence information accurately when address information is inserted, deleted or updated. To increase delivery accuracy, we reflect this point in writing application.

• 한국건설관리학회논문집
• /
• 제6권4호
• /
• pp.190-198
• /
• 2005

본 연구의 목적은 건설프로젝트에 관련된 기술문서(technical document)를 효율적으로 저장하고 웹(web)을 통하여 신속하고 정확하게 교환할 수 있도록 전자화(digitalization)하는 방안을 제시하는 것이다. 이를 위해 본 연구에서는 먼저 전자화 측면을 고려하여 기술문서의 여러 특성을 분석하였고 이를 바탕으로 저장에는 데이터베이스(database)를, 웹을 통한 교환에는 XML을 적용하여 기술문서를 전자화할 수 있는 방안을 도출하였다. 여기에는 기술문서의 저장과 검색, 부분적인 XML문서의 작성, 기술문서에 적합한 구성항목과 구성체계 설정, 웹에서의 수식과 그래픽 처리 방안이 포함된다. 마지막에는 전형적인 기술문서 중의 하나인 구조계산서(structural design sheets)를 대상으로 하여 데이터베이스에 저장하기 위한 자료구조(data structure) 정의, 실제 XML문서의 작성 및 웹을 통한 교환 등을 부분적으로 구현하여 본 연구에서 제안한 데이터베이스와XML에 기반한 기술문서 전자화 방안의 적정성을 검토하였다.

• 한국전자거래학회지
• /
• 제7권1호
• /
• pp.153-166
• /
• 2002

Nowadays an information exchange on Bn such as B2B electronic commerce is spreading. Therefore the systematic and stable management mechanism for storing the exchanged information is needed. For this goal there are many research activities for connection between XML application and relational database. But because XML data have hierarchical structures and relational database can store only flat-structured data, we need to store XML data in object-relational database that support hierarchical structure. Accordingly the modeling methodology for storing XML data in object-relational database is needed. In order to build good quality application systems, modeling is an important first step. In 1997, the OMG adopted the UML as its standard modeling language. Since industry has warmly embraced UML its popularity should become more important in the future. So a design methodology based on UML is need to develop efficiently XML applications. In this paper, we propose a unified design methodology for In applications based on object-relational database using In. To this goal, first we introduce a XML modeling methodology to design W3C XML schema using UML and second we propose data modeling methodology for object-relational database schema to store efficiently XML data in object-relational databases.

• 경영과학
• /
• 제19권1호
• /
• pp.129-142
• /
• 2002

Data fusion Is a technique used for creating an Integrated database by combining two or more databases that include a different set of variables or attributes. This paper attempts to apply data fusion technique to customer relationships management (CRM), in that we can not only plan a database structure but also collect and manage customer data In a more efficient way In particular our study Is useful when no s1n91e database Is complete, i.e., each and every subject in the pre-integrated database contains somewhat missing observations. According to the way of treating the common variables, donors can be differently selected for the substitution of the missing attributes of recipients. One way is to find the donor that has the highest correlation coefficient with the recipient by. treating common variables metrically The other is based on the closest distance by the correspondence analysis in case of treating common variables nominally. The predictability of data fusion for CRM can be evaluated by measuring the correlation of the original database and the substituted one. A Monte Carlo Simulation analysis is used to examine the stability of the two substitution methods in building an integrated database.

• Journal of Information Technology Applications and Management
• /
• 제9권1호
• /
• pp.85-96
• /
• 2002

Nowadays an information exchange on XML such as B2B electronic commerce is spreading. Therefore the systematic and stable management mechanism for storing the exchanged Information is needed. For this goal there are many research activities for connection between XML application and relational database. But because XML data have hierarchical structures and relational database can store only flat-structured data, we need to store XML data in object-oriented database that support hierarchical structure. Accordingly the modeling methodology for storing XML data in object-oriented database is needed. In order to build good quality application systems, modeling is an important first step. In 1997, the OMG adopted the UML as its standard modeling language. Since industry has warmly embraced UML, its popularity should become more important in the future. So a design methodology based on UML is need to develop efficiently XML applications. In this paper, we propose a unified design methodology for XML applications based on object- oriented database using UML. To this goal, first we introduce a XML modeling methodology to design W3C XML schema using UML and second we propose data modeling methodology for object-oriented database schema to store efficiently XML data in object-oriented databases.