• Journal of the Korea Society of Computer and Information
• /
• v.9 no.2
• /
• pp.57-62
• /
• 2004

In these days, application systems for processing information using database is increasing. Enterprises holding a lot of data do not possess needed data but instead include unrelated, independent and individual data. As a result, it only contains disparate data. Disparate data is ambiguous and it does not support current integrated information. In response to the above problems, data warehouse may provide a solution. Building a data warehouse needs a systematic design because of its complexity. This paper describes an efficient design methodology using visual environment for data warehouse to cope with the requirements of end users. Also, the system is able to process existential SQL query.

• Asia pacific journal of information systems
• /
• v.16 no.4
• /
• pp.151-178
• /
• 2006

The objective of this research is to develop a formal framework and methodology to facilitate real-time data integration, thus enabling semantic interoperability among distributed and heterogeneous information systems. The proposed approach is based on the concepts of "ontology" and "semantic mediators." An ontology is developed and used to capture the intension (including structure, integrity rules and meta-properties) of the database schema. We also develop the agent communication protocol for semantic reconciliation, which is based on the theory of speech acts and agent communication language. This protocol is used by a set of semantic mediators, which automatically detect and resolve various semantic conflicts at the data- and schema-levels by referring to the ontology. A mediation-based query processing technique is developed to provide uniform and integrated access to the multiple heterogeneous information sources. Prototype tools are being implemented to provide proof of concept for this work.

• Proceedings of the Computational Structural Engineering Institute Conference
• /
• 2001.10a
• /
• pp.193-200
• /
• 2001

In this study, the methodology to develop a data model for steel box girder bridge based on STEP part 104 is presented. The concept of STEP and the schema of part 104 are briefly reviewed, and then the procedure of data model standardization is described. A new data model for steel box girder bridge is developed by incorporating with not only the geometric and topological representation schema of the part 42 but also the representation structure information of the part 43 and the detailed finite element analysis information of the part 104. The prototype of integrated finite element analysis(FEA) system by interfacing STEP physical file is also presented. The applicability of developed data model for FEA is verified by preprocessor system of FEA.

• Journal of the military operations research society of Korea
• /
• v.25 no.1
• /
• pp.87-106
• /
• 1999

There are many technical datum in related with design, test & evaluation and logistic support which will be exchanged between geographically isolated units and heterogeneous hardwares & softwares in developing and operating the weapon systems. The paper proposes the conceptual database schema to establish configuration management information systems in which these datum can be automatically interchanged, tracked, audited and status-accounted without errors under the various environments. The paper investigates how to identify and classify the data in accordance with document identification, task analysis, system development, logistic support, system test & evaluation and data management. Furthermore, the investigation includes drawing the subject areas and modeling the conceptual database schema to explain the relationships between these datum. Thus, the paper results in the conceptual framework and data models of configuration management information systems, while additional customization efforts be required in applying the models to a specific weapon systems R&D.

• Journal of Information Management
• /
• v.40 no.1
• /
• pp.217-234
• /
• 2009

In computer-based virtual lab, a bioscience researcher who wants to obtain bio information first uses a biodiversity-related database to retrieve information on species, ecology and distribution of an organism. The researcher also needs to access gene/protein databases such as GenBank or PDB to find information on the organism's genetic sequence and protein structure. Furthermore, the researcher should search for academic papers containing the information on the organism so that his research is based on comprehensive and accurate information. This series of activities often undermines research efficiency as it takes a lot of time and causes inconvenience on the part of researchers. To solve such inconvenience, we analyzed various methods for integrated search and chosen schema integration. In addition, we analyzed each databases and extracted metadata for designing schema integration. This paper introduces a biological information retrieval system(BIRS) using schema integration and it's interface that will increase research efficiency for bioscience.

• Proceedings of the Computational Structural Engineering Institute Conference
• /
• 2000.04b
• /
• pp.405-412
• /
• 2000

This paper is the study of methodology for development of interface structure modules for an integrated system or steel framework structures. For development of the modules, it is used that data translation for the Steel Detail Neutral File(SDNF) format and the methodology have contacted individual systems in integrated system. The point of methology is translated system interface data with ASCⅡ format of system output and is presented with EXPRESS-G schema model. In the future, these neutral format will use structural design, engineering, facilities management, fabrication, etc. Therefore such a series of neutral formants is valuable to development of all structure fields.

• 한국공간정보시스템학회:학술대회논문집
• /
• 2004.12a
• /
• pp.153-158
• /
• 2004

Nowadays, the demand of the output analyzed from the gridded data has been sharply increased as the remote sensing technologies and GIS related industry have been developed. Therefore, a metadata access system which fits the requirements of the users should be developed for better managing and utilizing gridded data. In this background, this study defined a common application schema through the analysis of the metadata built by numerous institutes based on the draft metadata standards proposed from the study which maily concentrated on establishing the standards of distributing metadata for the gridded data supported by ETRI at 2003. Also, XML based integrated system was developed to access metadata maintained by SaTReC as well as SIMC to facilitate more convenient data access for the grid data users. The results of the pilot system developed from this study can be expected to contribute to build an more efficient and enlarged integrated access system of the metadata for the gridded data.

• Proceedings of the Korean Society of Surveying, Geodesy, Photogrammetry, and Cartography Conference
• /
• 2004.11a
• /
• pp.197-202
• /
• 2004

Nowadays, the demand of the output analyzed from the gridded data has been sharply increased as the remote sensing technologies and GIS related industry have been developed. Therefore, a metadata access system which fits the requirements of the users should be developed for better managing and utilizing gridded data. In this background, this study defined a common application schema through the analysis of the metadata built by numerous institutes based on the draft metadata standards proposed from the study which maily concentrated on establishing the standards of distributing metadata for the gridded data supported by ETRI at 2003. Also, XML based integrated system was developed to access metadata maintained by SaTReC as well as SIMC to facilitate more convenient data access for the grid data users. The results of the pilot system developed from this study can be expected to contribute to build an more efficient and enlarged integrated access system of the metadata for the gridded data.

• Proceedings of the Computational Structural Engineering Institute Conference
• /
• 1998.10a
• /
• pp.342-351
• /
• 1998

The purpose of this study is to develop a central database and a database management system to store and manage information systematically from each module of an integrated structural design system. In order to efficiently express structural design process related to the data which is very complex, we used an object-oriented modeling methodology to propose the possibility to apply a database schema for application programs in an integrated system for reinforced concrete structural design. Based on this model, we developed an interface between each module and central database. After modeled by using object modeling technique, the database was mapped by the relational database table. Then the central database and the interface were programed by using Visual C/syo ++/, a windows environmental development tool.

• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 1996.04a
• /
• pp.179-182
• /
• 1996

Database management systems are now used in almost every organization to maintain and utilize important collections of information. Relational DBMSs have a firm theoretical base. However, it lacks important features needed for representing certain critical aspects of an entity. One alternatives to remedy this problem is to adopt the object-oriented approach to the data model development process. In this paper, we tried to show the advantages of object-oriented data model design process for the development of extended relational database schema needed for the integrated plant information system at H. Heavy Industry Co.