• Industrial Engineering and Management Systems
• /
• v.9 no.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.

• KIPS Transactions on Computer and Communication Systems
• /
• v.6 no.2
• /
• pp.59-66
• /
• 2017

MySQL database is the second place in the market share of the current database. Especially InnoDB storage engine has been used in the default storage engine from the version of MySQL5.5. And many companies are using the MySQL database with InnoDB storage engine. Study on the structural features and the log of the InnoDB storage engine in the field of digital forensics has been steadily underway, but for how to restore on a record-by-record basis for the deleted data, has not been studied. In the process of digital forensic investigation, database administrators damaged evidence for the purpose of destruction of evidence. For this reason, it is important in the process of forensic investigation to recover deleted record in database. In this paper, We proposed the method of recovering deleted data on a record-by-record in database by analyzing the structure of MySQL InnoDB storage engine. And we prove this method by tools. This method can be prevented by database anti forensic, and used to recover deleted data when incident which is related with MySQL InnoDB database is occurred.

• Journal of Korean Society of Rural Planning
• /
• v.11 no.2 s.27
• /
• 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.

• Computational Structural Engineering
• /
• v.23 no.2
• /
• pp.21-26
• /
• 2010

• Journal of the Korean Society of Environmental Restoration Technology
• /
• v.20 no.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.

• IE interfaces
• /
• v.14 no.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.

• Korean Journal of Construction Engineering and Management
• /
• v.6 no.4 s.26
• /
• pp.190-198
• /
• 2005

This study describes the digitalization of technical documents of construction projects using database for storage and XML for exchange format on the web. First, for this purpose, the requirements for effective digitalization are identified. Second, the strategies for using database and XML are presented. These strategies include the way to store and search for the technical documents, to draw up the XML document for some parts of the technical documents, to arrange the components in their proper hierarchy, to manage the graphics and mathematical expressions in database and XML documents. Finally we discussed the validities of the results of this study by partial implementation for structural design sheets which has all the characteristics of technical documents.

• The Journal of Society for e-Business Studies
• /
• v.7 no.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.

• Korean Management Science Review
• /
• v.19 no.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
• /
• v.9 no.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.