• The Journal of Society for e-Business Studies
• /
• v.1 no.1
• /
• pp.173-194
• /
• 1996

In order to adapt today's short product life cycle and rapid technology changes., integrated systems should be extended to support PDM (Product Data Management) or CE(Concurrent Engineering). A PDM/CE environment has been developed and a prototype is Presented in this paper. Features of the PDM/CE environment are 1) integrated product information model (IPIM) includes both data model and integrity constraints, 2) database systems are organized hierarchically so that working data C8Mot be referenced by other application systems until they are released into the global database, and 3) integrity constraints written in EXPRESS are validated both in the local databases and the global database. By keeping the integrity of the product data, undesirable propagation of illegal data to other application system can be prevented. For efficient validation, the constraints are distributed into the local and the global schemata. Separate triggering mechanisms are devised using the dependency of constraints to three different data operations, i.e., insertion, deletion, and update.

• Proceedings of the Computational Structural Engineering Institute Conference
• /
• 1991.04a
• /
• pp.50-55
• /
• 1991

This paper presents database technique for an computer-integrated structural design system of buildings. Network database designed to support all the processes of structural design, such as, planning, modelling, analysis, member design and redesign processes etc. stores all information from user input and system results effectively and so provides centeral communication area between applications. The user interface wi th interactive and batch modes plays roles of building modeler including conventional pre-processor and post-processor. The concepts of 'Planar Surface Modeling' and 'Geometry Zoning' are defined for easy construction of building model. The concept presented in this paper will save the time and memory required for model generation and contribute to data consistency, thus leave a designer more time actually performing the analyses and interpreting the results. The formulation of automating the process of bulilding model ins and structural analysis is the key to study.

• Journal of Korea Multimedia Society
• /
• v.9 no.6
• /
• pp.720-727
• /
• 2006

In this paper, we propose a method which allows the SuperSQL query processor to share as much code as possible among various, generators, each of which is responsible for the output of a certain medium. SuperSQL is an enhanced query-processing system that converts database records into a variety of formats such as XML, HTML, PDF and etc. However, the existing SuperSQL media generator would require creation of a different processor for each medium, causing duplicated development cost. This research makes three main contributions: First, it analyzes the structures of various media, examining any possibility of integration based on their common structure. Second, it also facilitates the addition of a new output media generator by separating constructors and decorators from each medium. Last, it provides an integrated user interface to each media by method of the Media Abstraction Table Concept. We also show the performance and feasibility of our system using experimental results.

• The Transactions of the Korea Information Processing Society
• /
• v.7 no.2S
• /
• pp.692-700
• /
• 2000

As the multimedia application services have been getting various in Internet, need of multimedia database management system which can manage various multimedia information effectively has been increased. The multimedia application generally needs the features to store, manage, retrieve the multimedia data. We need a database management system framework that may be easily integrated with these features. This paper proposes th database management system framework providing the easy integration with various multimedia information retrieval. The framework uses OQL as the retrieval interface, so that user can use it easily. It can be integrated dynamically and easily with various multimedia retrieval method as a loosely coupled system. In addition there is no performance degradation caused in a loosely coupled system.

• Proceedings of the Korean Information Science Society Conference
• /
• 2000.10a
• /
• pp.113-115
• /
• 2000

A GIS software GEO Millennium SystemTM has been developed to integrated with spatial database that combines conventional and spatially related data. As we known well the standard query language lacks the support of spatial data type and predicate, and can not serve as the query language in the spatial database directly; some extended strategies have been proposed, but some of them need their own storage manager, some introfuce new clause into the SELECT-FROM-WHERE structure, and some is very complex and available to us. So we designed our own query language on the conventional storage manager system. It supports the Spatial Data Type and predicate, and provides the full query capabilities of SQL on the non-spatial part of the database while being tightly integrated with the spatial part, without changing the standard SQL structure.

• International Journal of Automotive Technology
• /
• v.7 no.2
• /
• pp.217-226
• /
• 2006

To maintain competitiveness in the modern automotive market, it is important to carry out process planning concurrently with new car development processes. Process planners need to make decisions concurrently and collaboratively in order to reduce manufacturing preparation time for developing a new car. Automated generation of a simulation model by using the integrated process plan database can reduce time consumed for carrying out a simulation and allow a consistent model to be used throughout. In this research, we developed a web-based system for concurrent and collaborative process planning and flow analysis for an automotive general assembly using web, database, and simulation technology. A single integrated database is designed to automatically generate simulation models from process plans without having to rework the data. This system enables process planners to evaluate their decisions quickly, considering various factors, and easily share their opinions with others. By using this collaborative system, time and cost put into the assembly process planning can be reduced and the reliability of the process plan would be improved.

• Proceedings of the Computational Structural Engineering Institute Conference
• /
• 1993.04a
• /
• pp.71-78
• /
• 1993

This study serves as a part for the development of an integrated structural design system. Efficient data management is essential in engineering computer applications where the volume of data is large and the data flow and sharing are required. From a viewpoint of computer application, building structures can be considered to be a mass ofdata. The centralized database(CDB) and database management system frees the application from the details of managing data storage and retrieval while providing a common pool of information. For this, systematic information analysis and modeling have to be preceded. In this paper we described the result of database modeling of building structure.

• The Journal of the Institute of Internet, Broadcasting and Communication
• /
• v.10 no.3
• /
• pp.27-33
• /
• 2010

One of the most critical success factor in introducing and operating an integrated information system is the performance management. In this study, we propose some SQL tuning techniques, applicable to optimize the performance of relational database systems. We showed effectiveness of the techniques by applying to a database system of a medium scale company.

• Proceedings of the KIEE Conference
• /
• 2003.11a
• /
• pp.128-130
• /
• 2003

Recently, with the increasing use of power semiconductors and microprocessors which are very sensitive to little change of power quality and power market being formed according to the reorganization of the power market, power providers and consumers show much interest in the power quality problem. This situation makes the demand creation of integrated system for power quality analysis and monitoring based on speedy and powerful functions by the growth of computer hardware and information technology, and besides advanced corporation already have created and employed power quality analysis and monitoring system. In this papers, it will be introduced that power quality database design-database is essential to integrated system-for managing effectively and confidently data from the power quality meters(PQM).

• Journal of Korean Society of Rural Planning
• /
• v.12 no.4 s.33
• /
• pp.53-61
• /
• 2006

Rural amenity resources consist of natural, cultural and social resources. Some of resources have been surveyed in other institutes and organizations and information system about these resources has been constructed. Integrating with information of existing system or database is helpful to produce useful rural amenity resources information to users. This integration of distributed information is based on semantic integration. In this paper, we used ontology for semantic integration and introduced the method of external information integration using ontology. We designed ontology table to represent ontology in database and integrated distributed information using ontology. To examine the improvement of information service efficiency and the applicability, rural amenity resources information and tourist attraction information database were constructed and integrated. Also, the information service efficiency with information integration was evaluated using recall ratio and compared to the information service efficiency without information integration.