• Title/Summary/Keyword: Database schema

Search Result 359, Processing Time 0.026 seconds

Classification and Resolution of Conflicts for Integration of Heterogeneous Information Based on XML Schema (XML Schema 기반 이질 정보 통합의 충돌 분류와 해결 방안)

  • 권석훈;이경하;이규철
    • Journal of Information Technology Applications and Management
    • /
    • v.10 no.3
    • /
    • pp.55-74
    • /
    • 2003
  • Due to the evolution of computer systems and the proliferation of Internet, numerous information resources have been constructed. The deluge of information makes the need to integrate information, which are distributed on the internet and are handled in heterogeneous systems. Recently, most of the XML -based information integration systems use XML DTD(Document Type Definition) for describing integrated global schema. However, DTD has some limitations in modeling local information resources such as datatypes. Although W3C's XML Schema is more flexible and powerful than XML DTD in specifying integrated global schema, it has more complex problems in resolving conflicts than using DTD. In this paper, we provide a taxonomy of conflict problems in integration information resources using XML Schema, and propose conflict resolution mechanism using XQuery.

  • PDF

Transformation from XML DTD to OODB Schema using Object Model (객체모델을 이용한 XML DTD의 OODB 스키마로의 변환)

  • Choe, Mun-Yeong;Ju, Gyeong-Su
    • The KIPS Transactions:PartD
    • /
    • v.9D no.2
    • /
    • pp.195-202
    • /
    • 2002
  • 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 this parer, the transforming methods based on object model from XML DTD to object-oriented database schema is proposed. For this, we first introduce mapping methods that map XML DTD to object model and then we propose soem methods that transform from the object model to object-oriented database schema.

Design and Implementation of Contents Integration and Management System (컨텐츠 통합 관리 시스템의 설계 및 구현)

  • 이중화;김태석
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 2003.10a
    • /
    • pp.472-475
    • /
    • 2003
  • In this paper, we developed the content management system for managing and integrating contents stored in local databases. This system converts the local database schema to XML document and makes the galobal database schema using the transmitted XML document. The contents integration and management system developed in this paper purposes the effective method for integrating and managing contents which is stored and operated in various environments.

  • PDF

A Construction of an Ontology Server based Intelligent Retrieval using XMDR (XMDR을 이용한 지능형 검색 온톨로지 서버 구축)

  • Hwang Chi-Gon;Jung Gye-Dong
    • The Journal of Korean Institute of Communications and Information Sciences
    • /
    • v.30 no.8B
    • /
    • pp.549-561
    • /
    • 2005
  • As Internet and network technologies have been developed, e-commerces are getting more complex and more various. This paper, for meta-data and data exchange between heterogeneous database systems, uses XML schema proposed in W3C, and XML schema can present meta-data and data of relational database system as XML document format which is structural. It supports various primitive data formats, so that it uses the structure which reflects adequately data formats which relational database system offered. However, current e-commerces use heterogeneous platforms, so difficulties that is mutual interchange and management exist. For the solution for these problems, a standard ontology which defines relations of product classifications and the standard of property expression and the location ontology which offers e-commerce's information about products are constructed. Applying these ontology information to search system, by offering information which customers need efficient search is performed. Combining these ontologies and product classification category information, called XMDR, this XMDR is introduced into product search system, so this paper proposes to construct ontology server method for efficient search.

A Study on Development of SGML Repository System Based on DTD-dependent Schema (DTD 의존 스키마에 기반한 SGML 문서 저장 시스템 개발에 관한 연구)

  • Kim, Hyeon-Gi;No, Dae-Sik;Gang, Hyeon-Gyu
    • The Transactions of the Korea Information Processing Society
    • /
    • v.6 no.5
    • /
    • pp.1153-1165
    • /
    • 1999
  • In various fields of information technology, it is growing up the needs about dynamic content management systems to store and manage SGML(Standard Generalized Markup language) documents in a database system. In this paper, we consider the issue of storing SGML documents that having complex hierarchical structure into a database system, and then propose a data model based on ODMG(Object Database Management Group) object model in order to store SGML documents without loss of information. Because the proposed data model reflects physical element structure and logical entity structure of SGML documents, it is able to store the SGML document in a database system at the system at the element- level granularity without any information loss. And also the proposed data model can be adapted among ODMG-compliant object database management systems. Finally, we will discuss on the implementation details of SGML repository system supports the functionality of automatic database schema creation for any DTD(Document Type Definition0, the functionality of storing the SGML document, the functionality of dynamic document assembly from stored database objects to SGML document, and the functionality of indexing and searching for database objects.

  • PDF

Performance improvement study for MRP part explosion in ERP environment (ERP 환경에서 MRP 부품전개의 성능향상을 위한 연구)

  • Lee H.G.;Na H.B.;Park J.W.
    • Proceedings of the Korean Society of Precision Engineering Conference
    • /
    • 2005.06a
    • /
    • pp.187-190
    • /
    • 2005
  • There have been many studies to improve the performance of a database system focused on modifying data structure, data partitioning, and materializing strategy. The main contribution of this study is to propose a new alternative towards improving database performance by designing single table schema or processing queries virtually in main memory space. Material Requirement Planning(MRP) part explosion process has shown almost 2 times shorter under DB schema we suggested, and even more than 10 times shorter when separating and filtering policy of DB archiving process are assumed. Several experimental results are shown to illustrate the excellence of our solution.

  • PDF

A Study on XML Development Support System for DB Integration (데이터베이스 통합을 위한 XML 개발 지원 시스템에 관한 연구)

  • Cho, Chong Duck;Park, Young Soo
    • Journal of Korea Society of Digital Industry and Information Management
    • /
    • v.6 no.2
    • /
    • pp.39-53
    • /
    • 2010
  • In this paper, we suggest an XML Development Support(XDS) System as a good developing tool to solve the problems that related with the database integration, increased to the developing terms and costs when the developing of XML programming base on the web server. XDS System is designed for the purpose of easily coding the XML program, of simply changing the programming structure and of completely maintaining the program environment. According to the predefined policy, XDS System provides necessary informations such as tables, columns, or relational keys from Database for developer. The developer step by step selects or sets what he needs. And XDS System creates an XML Tree with the result of selected information. The XML Tree includes all information of making an XML Schema and some XML Stylesheet. XDS System creates an XML Schema for all clients and creates many XML Stylesheets for each client using the XML Tree.

A Multi-Tier Application Architecture Independented on Database Schema (데이터베이스 도식에 비 의존적인 다 계층 어플리케이션 구조)

  • 박병석;한영태;민덕기
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2000.04b
    • /
    • pp.66-68
    • /
    • 2000
  • 기업의 전사적인 자원 관리(ERP)의 필요성이 급증하면서 이에 따른 광범위한 데이터베이스 관리의 중요성이 점차 부각되고 있다. 이러한 이유로 말미암아 데이터베이스의 확장 즉, Schema의 변화에 따른 데이터 베이스 접근을 위한 응용프로그램으로써 Multi-Tier 구조가 제시된 바 있다. 그러나 또 다른 시스템에 적용하는 경우 데이터베이스의 접근을 제 변경해야 하는 등, 여전히 많은 문제점이 드러나고 있다. 본 고에서는 이러한 문제점을 해결하기 위한 방법으로써 데이터 베이스의 Schema에 독립적으로 접근할 수 있는 새로운 Multi-Tier 구조를 제시한다.

  • PDF

Schema Integration Using XML in Multi-Database (멀티데이터베이스에서 XML을 이용한 스키마 통합)

  • 탁우현;류영호;이종환;김경석
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 1999.10a
    • /
    • pp.78-80
    • /
    • 1999
  • 멀티데이터베이스를 구축하기 위해서는 전역스키마 (global schema) 구축이 필수적이며, 지역스키마(local schema) 간 충돌 해결과 스키마 통합 정보는 질의 처리 및 질의 결과를 사용자에게 보여주기 위해 필요하다. 전역스키마 생성 및 충돌 해결 방법은 많이 연구가 되어 왔다. 하지만, 스키마 통합을 위한 정보가 어떻게 표현되고, 어떻게 사용되는지에 대한 연구는 부족하다. 본 논문에서는 지역스키마와 전역스키마를 XML DTD 및 XML 문서로 표현하고, 이를 이용하여 멀티데이터베이스를 위한 스키마 통합 방법을 제안한다. 스키마 통합정보와 멀티데이터베이스와 지역데이터베이스들간 데이터교환을 XML을 이용함으로써 이기종간 데이터 교환이 쉽고, 멀티데이터베이스 시스템의 확장 및 다른 시스템으로의 전환이 용이하게 된다.

  • PDF

Product Model for the Integration of Design and Manufacturing Information in Shipbuilding (선박의 설계 및 생산 정보의 통합을 위한 Product Model 의 구축)

  • S.B. Yoo;J.W. Lee
    • Journal of the Society of Naval Architects of Korea
    • /
    • v.30 no.2
    • /
    • pp.1-12
    • /
    • 1993
  • The role of product model in CIM environemt(where such heterogenous application programs as CAD, CAE, CAM, Database, and Expert Systems are included) is system integration. Product model manages all the information related to manufacuring activities. This information includes shapes, operation, process, scheduling, quality, and mangement. Product model architecture includes product model kernel, object schema, model manipulation language, and user interface. Objects to be shared are defined using the model manipulation luage and the defintions are saved in the object schema. In this paper, we present the design and implementation of a prototype. In this prototype, application programs for CAPP(Computer Aided Process Planning) are used.

  • PDF