• The KIPS Transactions:PartD
• /
• v.13D no.1 s.104
• /
• pp.1-10
• /
• 2006

This paper introduces the development XPERT(XML Query Processing Engine using Relational Technologies) which is based on relational model. In our system we have used a decomposed approach to store XML files in relational tables. XML queries are translated to SQLs according to the table schema, and then they are sent to the relational DBMS to get the results back. Our translation scheme produces AST(Abstract Syntax Tree) by analyzing XQuery expressions at first. And on traversing AST proper SQLs are generated. Translated SQLs can reduce the number of joins by using path information and utilize dewey number to preserve document originated orderings among compoments in XML. In addition we propose the efficient algorithms of XPath and XQuery translation. And finally we show the implementation of our prototype system for the functional evaluations.

• Proceedings of the Korean Society of Agricultural Engineers Conference
• /
• 1998.10a
• /
• pp.176-179
• /
• 1998

In structural analysis using FEM or BEM, pre_ and post_processor is necessary pre_ and post_processor and analyzer use same structural model. But many other tasks related to structural design, such as optimization, design of layout, etc, do not share that model in spite of their resemblance of requiring data. So, a pre_ and post_ processor was developed using a relational database managing system. Developed system uses the DBMS as a data storage and interacts with it using SQL interface. In this way, many other tasks that uses same structural data can be developed.

• Journal of Computing Science and Engineering
• /
• v.4 no.4
• /
• pp.276-290
• /
• 2010

The join operator is fundamental in relational database systems. Evaluating join queries on large tables is challenging because records need to be efficiently matched based on a given key. In this work, we analyze join queries in SQL with large tables in which a foreign key may be null, invalid or valid, given a referential integrity constraint. We conduct an extensive join performance evaluation on three DBMSs. Specifically, we study join queries varying table sizes, row size and key probabilistic distribution, inserting null, invalid or valid foreign key values. We also benchmark three well-known query optimizations: view materialization, secondary index and join reordering. Our experiments show certain optimizations perform well across DBMSs, whereas other optimizations depend on the DBMS architecture.

• Journal of the Korean Institute of Intelligent Systems
• /
• v.16 no.1
• /
• pp.101-107
• /
• 2006

In this research, we propose a hybrid inference architecture for medical diagnosis based on dynamic knowledge map (DKM) and relational database (RDB). Conventional expert systems (ES) and developing tools of ES has some limitations such as, 1) time consumption to extend the knowledge base (KB), 2) difficulty to change the inference path, 3) inflexible use of inference functions and operators. To overcome these Limitations, we use DKM in extracting the complex relationships and causal rules from human expert and other knowledge resources. The DKM also can help the knowledge engineers to change the inference path rapidly and easily. Then, RDB and its management systems help us to transform the relationships from diagram to relational table.

• 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.

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

JDBC는 Java 프로그램에서 표준 SQL을 사용하여 데이터베이스에 접근하기 위한 응용 프로그램 인터페이스이다. 응용 프로그램 개발자는 JDBC API를 사용하여 다양한 종류의 DBMS에 적용 가능한 응용 프로그램을 쉽게 작성할 수 있을 뿐만 아니라 JDBC API를 사용하여 작성된 기존의 응용 프로그램들을 재사용하는 것이 가능하다. 본 논문에서는, 객체 관계형 데이터베이스 관리 시스템인 오디세우스를 위한 JDBC 드라이버를 설계하고 구현한다. 본 JDBC 드라이버는 DBMS와 직접 연결하여 통신하므로 질의 결과 처리 성능이 좋고, 모두 Java 언어로 구현되기 때문에 웹 환경에서 사용하기 적합하다는 특징을 가진다.

• Proceedings of the Korean Information Science Society Conference
• /
• 2002.10d
• /
• pp.250-252
• /
• 2002

정보가전에 대한 연구가 현재 활발히 진행 중에 있고 정보가전이 실현 되었을 때 다양한 서비스와 연계가 가능하고, 사람들의 생활 환경에 많은 변화가 일어날 것으로 전망된다. 본 논문에서는 정보가전 기반의 건강관리 멀티 에이전트 시스템을 설계와 구현을 기술하였다. 홈 제어 네트워크로는 전력선 기반의 LonWorks를 이용하고, OSGI(Open Services Gateway Initiative)를 이용하여 LonWorks기반의 디바이스들을 제어한다. 멀티에이전트 시스템으로는 FIPA(The Foundation for Intelligent Physical Agents) Specification을 따르고, 이 플랫폼 위에서 건강관리 에이전트, 가전제품관리 에이전트, 건강관리 Library, 요리 Library, 운동 Library를 구현하였다.

• ETRI Journal
• /
• v.9 no.2
• /
• pp.118-133
• /
• 1987

본고는 TDX 전전자교환기 개발에 따른 시스팀 형상관리를 효율적이고 체계적으로 수행하기 위한 자동화 도구, $CMI^2S$(Interactive Information System for TDX Configuration Managements)의 개발에 관한 연구결과이다. $CMI^2S$는 menu-driven 방식을 기본으로 하는 네가지 도구 (CCT/RDT/SPRT/DSMT)들로 구성되어 있으며, 주요 개발환경중의 하나인 데이터베이스 시스팀은 VAX-l1/750 컴퓨터 시스팀의 Troll/USE Relational DBMS 이다. 그리고 $CMI^2S$의 주목적은 형상관리 활동인 형상인식, 형상통제, 형상상태 기록의 수행을 자동화하여 TDX 시스팀의 integrity를 향상시키는데 있다.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.6 no.4
• /
• pp.37-50
• /
• 2003

In the paper, we describe the query extension techniques for spatiotemporal query functionalities on object-relational DBMS. The spatial objects in real world change the shapes over time. Spatiotemporal databases support to manage a temporal dimension as well as a spatial dimension for history of the objects. The proposed techniques can make conventional object-relational databases to support spatiotemporal databases system by the implementation and inheritance of abstract data types. We define and implement spatial and temporal classes as superclass. And, spatiotemporal classes inherits and extends the classes. The proposed extensions make it easy that conventional database systems not only are transformed into the spatiotemporal database systems, but also do not need to be changed to support spatiotemporal applications.

• The Transactions of the Korea Information Processing Society
• /
• v.4 no.1
• /
• pp.1-10
• /
• 1997

In this paper, for useful administration of the data which have ambiguities meaningfully and hard to treat, a new relation database model using an integrated fuzzy sets and rough sets relational database one. After proposing Fuzzy-rough relational database model on the base of integrated Fuzzy and Rough sets, Application of the examples of arithmetic is analyzed through the Access DBMS and the visual basic by composing and representing database based on fuzzy and rough sets which are characterized as fuzzy sets and rough sets on Pentium computer(166Mhz). This paper was induced to reduce the data incompleteness.