• Title/Summary/Keyword: DB Schema

Search Result 54, Processing Time 0.023 seconds

A Study on the Design of XML Schema for the Metadata of Construction Information (건설공사정보 메타데이터의 XML 스키마 설계에 관한 연구)

  • Park, Jae-Won;Choi, Jae-Hwang
    • Journal of the Korean Society for Library and Information Science
    • /
    • v.36 no.3
    • /
    • pp.155-179
    • /
    • 2002
  • The purpose of this study is to extract metadata based on Dublin Core from national construction information DBs, to design XML schema from the extracted metadata and to apply the previous works to integrated information retrieval system. To extract metadata, co-work was performed with librarians in the field of construction information, and. as a result, twelve metadata elements from Dublin Core and one administrative metadata could be extracted. Based on the investigation and analysis of those thirteen metadata elements, XML schema design process was described in detail. finally, the service environments of integrated information retrieval system to which XML schema was applied was introduced. Further study was also provided.

Study on the Automatic Generation of DB Schema in URI Server (URI 서버 내 DB 스키마 자동 생성 연구)

  • Jung, Hanmin;Lee, MiKyung;Kang, In-Su;Sung, Won-Kyung
    • Annual Conference on Human and Language Technology
    • /
    • 2007.10a
    • /
    • pp.107-113
    • /
    • 2007
  • 본 연구는 시맨틱 데이터 정합성 검사와 RDF 트리플 생성 기능을 가진 URI 서버 내 DB 스키마의 자동 생성 방안을 기술한다. URI 서버는 시맨틱 웹 기술 기반 프레임워크 구성에 필요한 핵심 엔진으로서 인스턴스 생성 관리기, 검색 엔진, 추론 엔진 등과의 상호 작용을 통해 시맨틱 데이터를 서비스한다. 도메인이 바뀌거나 서비스가 변경되는 경우 DB 스키마를 전문가에 의해 수작업으로 생성함으로써 서비스 환경 변화에 즉각 대응하지 못하는 문제점을 가진 기존 URI 서버를, 적재되는 온톨로지에 따라 DB 스키마를 동적으로 자동 생성하는 방식으로 변경함으로써 다양한 응용 분야와 도메인에의 높은 이식성(Portability)을 보장할 수 있도록 한다. 기반정보 온톨로지, 응용 온톨로지, 개인화 온톨로지 등 3개 온톨로지 스키마와 11만 건 이상의 Citeseer Open Access Metadata로부터 추출된 인스턴스를 대상으로 한 실험을 통해 URI 서버 내 DB 스키마 자동 생성 가능성을 실증하였다.

  • PDF

On the Construction of Requirements DB to Improve the Work Environment of Locomotive Cabs (철도차량 운전실의 작업환경 개선을 위한 요구사항 DB 구축에 관한 연구)

  • Sim, Sang-Hyun;Lee, Jae-Chon;Park, Chan-Woo
    • Journal of the Korea Safety Management & Science
    • /
    • v.13 no.4
    • /
    • pp.71-79
    • /
    • 2011
  • The work environment of locomotive cabs has long been an important issue in the design of railload systems since it is quite critical in terms of system's operational safety. It is getting more attention as the running speed of the trains goes up these days. To this end, this paper describes how to systematically construct a DB for the requirements set in the course of the improvement process for the aforementioned cab work environment. As a solution approach, we have adopted the requirement architecture concept to cover the whole activities required to do such as in requirements generation, DB construction, change management, and traceability management. Specifically, based on the requirement architecture framework a requirement process to collect requirements for improvement is discussed, and the guide lines are suggested for verification and validation of the developed requirements. In addition, a base schema and requirements templates are developed, which will be used in generating requirements and constructing a DB. Finally, it is demonstrated how the requirements DB for locomotive cabs can be constructed using a computer-aided tool in an integrated fashion.

A Study on Efficiency of the EPCIS using Altibase DBMS (Altibase DB를 활용한 EPCIS 효율화 방안 연구)

  • Piao, Xue-Hua;Lee, Doo-Yong;Song, Young-Keun;Kwon, Dae-Woo;Jho, Yong-Chul;Lee, Hee-Nam;Lee, Chang-Ho
    • Journal of the Korea Safety Management & Science
    • /
    • v.12 no.2
    • /
    • pp.167-172
    • /
    • 2010
  • EPCIS(EPC Information Service) system is a core component of EPCglobal Architecture Framework offering information of the freights, the time of awareness and the location of awareness on the EPCglobal Network. EPCIS Repository continuously stores and manages mass EPCIS Event input data from a great number of RFID devices simultaneously. The Hybrid DBMS can deal efficiently mass necessary data. This study suggest the plan which can efficiently manage EPCIS Repository using Hybrid DBMS. We offer three schema and stores EPCIS Event data to Altibase DB that can efficiently manage EPCIS Repository using Hybrid DBMS and compare the performance about three schema through simulations.

Development of the Design Methodology for Large-scale Data Warehouse based on MongoDB

  • Lee, Junho;Joo, Kyungsoo
    • Journal of the Korea Society of Computer and Information
    • /
    • v.23 no.3
    • /
    • pp.49-54
    • /
    • 2018
  • A data warehouse is a system that collectively manages and integrates data of a company. And provides the basis for decision making for management strategy. Nowadays, analysis data volumes are reaching critical size challenging traditional data ware housing approaches. Current implemented solutions are mainly based on relational database that are no longer adapted to these data volume. NoSQL solutions allow us to consider new approaches for data warehousing, especially from the multidimensional data management point of view. In this paper, we extend the data warehouse design methodology based on relational database using star schema, and have developed a consistent design methodology from information requirement analysis to data warehouse construction for large scale data warehouse construction based on MongoDB, one of NoSQL.

The DB structure for Standard Criteria of Urban Transit Facilities (도시철도시설 표준화기준을 위한 DB구축방안 연구)

  • Lee, Woo-Dong;Kim, Jin-Ho;Han, Seok-Youn;Sin, Won-Sik
    • Proceedings of the KIEE Conference
    • /
    • 2008.10c
    • /
    • pp.213-214
    • /
    • 2008
  • Since standardization project is composed of complicate system, such as vehicle, signal, electric power and railway, how to build management system of the project has influence on the success of the project for the first stage of the project. The computer system design tool supports to carry out requirement analysis, DB construction, and history and follow-up management efficiently. Therefore, the aim of this study is to investigate the method to optimize schema using computer system design tool.

  • PDF

The Design of Data Grid Wrapper for Integrated Retrieve based on XMDR (XMDR 기반의 통합 검색을 위한 데이터 그리드 Wrapper 설계)

  • Hwang, Chi-Gon;Jung, Kye-Dong;Choi, Young-Keun
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.12 no.5
    • /
    • pp.921-929
    • /
    • 2008
  • Recently, many researches have been conducted to solve data heterogeneity as a way for data integration. The elements of the system that we suggest are an XMDR wrapper and XMDR Repository. XMDR wrapper solves the heterogeneity of the existing system by creating the interface based on the standard information of XMDR, and performing the inter-conversion between global XMDR query and local query using mapping data on standard information and local schema. XMDR Repository are composed of XMDR which manages the mapping data on standard information and local schema, and of Proxy DB which saves the accomplished results. With XMDR wrapper and XMDR Repository, users can use the same interface, and they need not conduct repeated queries since XMDR wrapper not only solves the heterogeneity of the schema using the meta-semantic ontology of XMDR, but also considers the heterogeneity accompanying the meaning of the value through instance semantic ontology. Therefore, in this paper we suggest the grid wrapper for the solution of data heterogeneity and efficient data integration.

Database Schema Design for Integrated Missile Design and Optimization (유도무기 통합최적설계를 위한 데이터베이스 설계 연구)

  • Lee, Jae-Woo;Lee, Seung-Jin;Choi, Seok-Min;Cho, Guk-Hyun;Kim, Kwang-Sik;Lee, Jeong-Oog;Jung, Karp-Joo
    • Journal of the Computational Structural Engineering Institute of Korea
    • /
    • v.21 no.6
    • /
    • pp.563-569
    • /
    • 2008
  • In this paper, the missile database system for the multidisciplinary design and optimization framework has been designed and investigated. The requirements of the missiles database are analyzed and the database design concept has been defined first. The data flow among the analysis disciplines is investigated and the Entity-Relation diagram is constructed to develop the database table and to define the database schema. The developed database system is integrated into the missile design framework to perform the store, search and management of the design data during the design and analysis of the missile development, hence the efficiency and validity of the database designed in this study has been demonstrated.

On the Development of Pipe Equipment in 3D Ship CAD (3차원 선박 CAD를 위한 배관 의장품의 Part Master 정보 구축)

  • Lee, Jang-Hyun;Lee, Hwang-Beom;Hwang, Se-Yun;Ha, Sung-Cook;Lee, Chan-Woo
    • Proceedings of the Computational Structural Engineering Institute Conference
    • /
    • 2007.04a
    • /
    • pp.819-824
    • /
    • 2007
  • Outfitting system in ship design has huge kinds of standard part. Data base of and automatic design procedure of part master should be included in ship cad in order to reduce the design time. Present study shows an process of part master DB construction of pipe equipments using 3-dimensional CAD environment Attribute and properties of part masters are chosen from JIS standard. As the schema of part masters are stored in data base, 3D geometric model is parsed from the schema.

  • PDF

Design and Implementation of Real-time 3D Geo-spatial Information Rendering System based on OpenGL/OpenGL|ES and Image DB Schema (영상 DB 스키마와 OpenGL/OpenGL|ES 기반 실시간 3D 공간정보 렌더링 시스템 설계 및 구현)

  • Kim Seung-Yeb;Lee Ki-Won
    • Proceedings of the KSRS Conference
    • /
    • 2006.03a
    • /
    • pp.41-44
    • /
    • 2006
  • 본 연구에서 3차원 지형공간정보의 구축 및 처리, 가시화를 위하여 개인용 PC와 임베디드 단말기의 포켓 PC환경에서 자료 호환 및 동시 운영이 가능한 실시간 3차원 GIS의 Prototype의 설계 및 구현과 적용 실험을 하고자 한다 OpenGL(Open Graphic Library)과 OpenGL|ES (Embedded System)를 활용하여 도시경관을 구성하는 주요객체인 지형, 건물, 교통, 식생 등을 통합적으로 저작 및 3D 객체 모델링 및 렌더링이 통합 및 개별 운영 시스템을 설계하고 구현하였다. 구현 단계에서 개인용 PC 운영환경에서는 기능성 향상에 중점을 두어 공간 데이터베이스 설계, 텍스처 영상 매핑처리, 대용량의 3차원 공간정보 처리 및 관리, 가시화, 렌더링, 모델링 기능들을 제공하며, PDA 휴대용 단말운영환경을 지원하는 모바일 시스템에서는 실시간 모바일 저작기능과 렌더링 기능에 주안점을 두어 개발하였다. 한편 연구 결과로 구현된 시스템은 원도우 XP 기반의 개인용 PC와 PDA 단말기 상에서 3D 객체 자료구조가 호환되어 향후 다양한 응용이 가능할 것으로 생각된다.

  • PDF