• Title/Summary/Keyword: relational schema

Search Result 145, Processing Time 0.026 seconds

Implemetation of STEP Standard Data Interface (SDAI) on Multiple Data Models (이종 데이터 모델에서의 STEP 표준 데이터 인터페이스(SDAI) 구현)

  • 권용국;유상봉
    • The Journal of Society for e-Business Studies
    • /
    • v.3 no.1
    • /
    • pp.1-22
    • /
    • 1998
  • SDAI (Standard Data Access Interface) is an interface specification of accessing various storage systems such as file systems and database management systems for STEP data. Using SDAI, both application program developers and CAD/CAM system developers can be relieved from dealing with STEP physical file or system dependent DBMS operations. In this paper, we present implementations of SDAI on different data models, i.e., relational, extended relational, and object-oriented. In order to implement SDAI, we need to translate the EXPRESS information model into target data models. The schema translation process for three different data models are compared and other implementation issues are discussed.

  • PDF

XML Type vs Inlined Shredding into Tables for Storing XML Documents in RDBMS

  • Jin, Min;Seo, Min-Jun
    • Journal of Korea Multimedia Society
    • /
    • v.10 no.12
    • /
    • pp.1539-1550
    • /
    • 2007
  • As XML is increasingly used for representing and exchanging data, relational database systems have been trying extend their features to handle XML documents XML documents can be stored in a column with XML data type like primitive types. The shredding method, which is one of the traditional methods for storing and managing XML documents in RDBMS, is still useful and viable although it has some drawbacks due to the structural discrepancy between XML and relational databases. This method may be suitable for data-centric XML documents with simple schema. This paper presents the extended version of the Association inlining method that is based on inlined shredding and compares the performance of querying processing to that of XML type method of conventional relational database systems. The experiments showed that in most cases our method resulted in better performance than the other method based on XML data type. This is due to the fact that our shredding method keeps and uses the order and path information of XML documents. The path table has the information of the corresponding table and column for each distinct path and the structure information of the XML document is extracted and stored in data tables.

  • PDF

Application Plan of Big Data and NoSQL (빅데이터와 NoSQL 활용방안)

  • Park, Sungbum;Lee, Sangwon;Ahn, Hyunsup;Jung, In-Hwan
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 2013.10a
    • /
    • pp.223-225
    • /
    • 2013
  • For a long time, Relational Databases have been widely used in many enterprises. Even though the Relational Databases have merits such as excellent power of data preservation, concurrency controlling as a standard model in databases, there are a demerit in the inconsistency of objects and relations. Against this backdrop, NoSQL is being magnified as a new solution for Big Data since it can be operated without any schema. In this paper, we research on not only merits and demerits of Relational Databases but also the comparison between application databases and integrated databases. And then, we define NoSQL for Big Data and check its characteristics.

  • PDF

Extracting Entity-Relationship Schema Using Form Model in Relational Database Systems (관계 데이터베이스 시스템에서 Form Model을 이용한 개체-관계 스키마의 추출)

  • 김미화;황태희;배석찬
    • Proceedings of the Korea Society for Industrial Systems Conference
    • /
    • 2000.11a
    • /
    • pp.425-429
    • /
    • 2000
  • 데이터 모델링 접근은 주로 순 공학을 사용하여 미래의 필요구조에 초점을 맞추고 있기 때문에 새로운 데이터베이스를 설계하기 위해서는 많은 시간과 노력, 개발비가 필요하다. 그러나 기존의 데이터베이스를 재사용 한다면 개발에 필요한 시간과 노력, 개발비를 줄일 수 있을 뿐 아니라 자료의 재활용면에서 효율적이다. 본 논문에서는 사용 가능한 데이터베이스 application을 재사용하기 위해 Form model을 이용하여 새로운 데이터베이스 설계의 바탕이 되는 개체-관계 스키마를 추출하는 방법에 대해 연구하였다.

  • PDF

Definition of Secure Relational Schema using an Object Relationship Model (객체-관련성 모델을 이용한 보안 관계 스키마 정의)

  • 김영균;이영록;노봉남
    • Proceedings of the Korea Institutes of Information Security and Cryptology Conference
    • /
    • 1992.11a
    • /
    • pp.247-256
    • /
    • 1992
  • 개념적 데이터 모델의 스키마를 논리적 스키마의 하나인 관계 스키마로의 변환 과정은 개체 무결성과 참조 무결성을 보장하여야 한다. 또한 안전한 데이터 베이스를 설계하고 구현하기 위해서는 보안성을 기존의 데이터 모델에 첨가시켜서 변환 과정에 보안성을 보장하기 위한 변환 규칙을 정의하여야 한다. 이 과정을 일관성 있고 효율적으로 하기 위해 변환 과정을 자동적으로 수행하는 도구가 필요하다. 본 논문에서는 보안 객체-관련성 모델을 이용하여 보안 관계 스키마로 변환하기 위한 변환 규칙을 정의하고, 변환 처리 과정을 자동적으로 수행하는 자동화 도구를 설계 및 구현하였다.

  • PDF

An RDF Ontology Access Control Model based on Relational Database (관계형 데이타베이스 기반의 RDF 온톨로지 접근 제어 모델)

  • Jeong, Dong-Won
    • Journal of KIISE:Databases
    • /
    • v.35 no.2
    • /
    • pp.155-168
    • /
    • 2008
  • This paper proposes a relational security model-based RDF Web ontology access control model. The Semantic Web is recognized as a next generation Web and RDF is a Web ontology description language to realize the Semantic Web. Much effort has been on the RDF and most research has been focused on the editor, storage, and inference engine. However, little attention has been given to the security issue, which is one of the most important requirements for information systems. Even though several researches on the RDF ontology security have been proposed, they have overhead to load all relevant data to memory and neglect the situation that most ontology storages are being developed based on relational database. This paper proposes a novel RDF Web ontology security model based on relational database to resolve the issues. The proposed security model provides high practicality and usability, and also we can easily make it stable owing to the stability of the relational database security model.

Development of an Object-Relational IFC Server

  • Hoon-sig Kang;Ghang Lee
    • International conference on construction engineering and project management
    • /
    • 2009.05a
    • /
    • pp.1346-1351
    • /
    • 2009
  • In this paper we propose a framework for an Object Relational IFC Server (OR-IFC Server). Enormous amounts of information are generated in each project. Today, many BIM systems are developed by various CAD software vendors. Industry Foundation Classes (IFC) developed by International Alliance for Interoperability (IAI) is an open standard data model for exchanging data between the various BIM tools. The IFC provides a foundation for exchanging and sharing of information directly between software applications and define a shared building project model. The IFC model server is a database management system that can keep track of transactions, modifications, and deletions. It plays a role as an information hub for storing and sharing information between various parties involved in construction projects. Users can communicate with each other via the internet and utilize functions implemented in the model server such as partial data import/export, file merge, version control, etc. IFC model servers using relational database systems have been developed. However, they suffered from slow performance and long transaction time due to a complex mapping process between the IFC structure and a relational-database structure because the IFC model schema is defined in the EXPRESS language which is object-favored language. In order to simplify the mapping process, we developed a set of rules to map the IFC model to an object-relational database (ORDB). Once the database has been configured, only those pieces of information that are required for a specific information-exchange scenario are extracted using the pre-defined information delivery manual (IDM). Therefore, file sizes will be reduced when exchanging data, meaning that files can now be effectively exchanged and shared. In this study, the framework of the IFC server using ORDB and IDM and the method to develop it will be examined.

  • PDF

Update Semantic Preserving Object-Oriented View (갱신 의미 보존 객체-지향 뷰)

  • 나영국
    • The KIPS Transactions:PartD
    • /
    • v.8D no.1
    • /
    • pp.32-43
    • /
    • 2001
  • Due to the limitation of data modeling power and the view update ambiguity, relational view is limitedly used for engineering applications. On the contrary, object-oriented database view would playa vital role in defining custom interface for engineering applications because the above two limitations of the relational view are overcome by the object-oriented view. Above all, engineering application data interface should fully support updates. More specifically, updates against the data interface needs to be unambiguously defined and its semantic behavior should be equal to base schema updates'. For this purpose, we define the notion of update semantic preserving which means that view updates displays the same semantics as base schema. Besides, in order to show the feasibility of this characteristics, specific and concrete algorithms for update preserving updates are presented for a CAD specialized object-oriented database view - MultiView. This paper finds that in order that virtual classes coudld form a schema with 'isa' relationships rather than just a group of classes, the update semantics on the virtual classes should be defined such that the implied meaning of 'isa' relationships between classes are not to be violated. Besides, as its sufficiency conditions, we derived the update semantics and schema constituable conditions of the virtual classes that make view schemas look like base schemas. To my best knowledge, this is the first research that presents the sufficiency conditions by which we could defined object-oriented views as integrated schemas rather than as separate classes.

  • PDF

A Case Study about Influence of Primary Mathematic Concepts on the Composition of Mathematic Concepts in 3rd Grade Prodigies of Elementary Schools -Focusing on Addition of Decimals- (수학의 1차적 개념이 초등학교 3학년 영재아의 수학적 개념구성 과정에 미치는 영향에 대한 사례연구 -소수의 덧셈을 중심으로-)

  • Kim, Hwa-Soo
    • The Journal of the Korea Contents Association
    • /
    • v.17 no.9
    • /
    • pp.437-448
    • /
    • 2017
  • This study was conducted as a qualitative case study for examining what transformed primary concepts and transformed schemas were formed for the addition of decimals and how they were formed, and how the relational understanding of the addition of decimals was in three 3rd grade elementary school children who had studied the primary concepts of division, fraction and decimal. That is, this study investigated how the subjects approached problems of decimal addition using transformed primary concepts and transformed schemas formed by themselves, and how the subjects formed concepts and transformed schemas in problem solving. According to the results of this study, transformed primary concepts and transformed schemas formed through the learning of the primary concepts of division, fraction, and decimal functioned as important factors for the relational understanding of decimal addition.

Semantic-based Keyword Search System over Relational Database (관계형 데이터베이스에서의 시맨틱 기반 키워드 탐색 시스템)

  • Yang, Younghyoo
    • Journal of the Korea Society of Computer and Information
    • /
    • v.18 no.12
    • /
    • pp.91-101
    • /
    • 2013
  • One issue with keyword search in general is its ambiguity which can ultimately impact the effectiveness of the search in terms of the quality of the search results. This ambiguity is primarily due to the ambiguity of the contextual meaning of each term in the query. In addition to the query ambiguity itself, the relationships between the keywords in the search results are crucial for the proper interpretation of the search results by the user and should be clearly presented in the search results. We address the keyword search ambiguity issue by adapting some of the existing approaches for keyword mapping from the query terms to the schema terms/instances. The approaches we have adapted for term mapping capture both the syntactic similarity between the query keywords and the schema terms as well as the semantic similarity of the two and give better mappings and ultimately 50% raised accurate results. Finally, to address the last issue of lacking clear relationships among the terms appearing in the search results, our system has leveraged semantic web technologies in order to enrich the knowledgebase and to discover the relationships between the keywords.