• Title/Summary/Keyword: Database System

Search Result 7,032, Processing Time 0.037 seconds

A study of PL / SQL Procedure for the Automatic Generation of XML Documents (XML 문서 자동 생성을 위한 PL/SQL 프로시저 설계)

  • Kim, Chang-Su;Jung, Hoe-Kyung
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 2014.05a
    • /
    • pp.615-616
    • /
    • 2014
  • Currently, XML is a standard language used to exchange data. Most of the data in the file system is not stored in the database system. The data stored in an object-oriented database, the data can be represented by a hierarchical structure. However, in the case of a relational database table, each independently of the hierarchical structure data is present can not be expressed. In this paper, a hierarchical representation of data is difficult in traditional relational database without changing the data in the database, without having to build a new database, Define the structure of the existing data in the XML document for the automatic generation of a PL / SQL procedure is designed.

  • PDF

Spatiotemporal Aggregate Functions for Spatiotemporal Data

  • Shin, Hyun-Ho;Kim, Sang-Ho;Ryu, Keun-Ho
    • Proceedings of the Korean Institute of Intelligent Systems Conference
    • /
    • 2003.09a
    • /
    • pp.551-554
    • /
    • 2003
  • Aggregate operator which belongs to query operations are important in specialized systems such as geographic information system(GIS) and spatial database system. Most of data describing objects in the real world are characterized by space and time attributes. Till now, however, works on aggregate operations have only dealt with spatial or temporal aspect of object. The current demand of aggregate operations relates to spatiotemporal data which are contained both spatial and temporal data concurrently. Therefore, work on spatiotemporal operations is focused on database area. In this paper, we propose spatiotemporal aggregate functions that operate on spatiotemporal data. Above all, we support spatiotemporal aggregate functions on the basis of three dimensional spatiotemporal models that are defined with the linear one dimensional temporal domain. The proposed algorithms are evaluated through some implementation results. We are sure that the achievement of our work is useful and efficient.

  • PDF

DEVELOPMENT OF XML BASED PERSONALIZED DATAASE MANAGEMENT SYTEM FOR BIOLOGISTS

  • Cho Kyung Hwan;Jung Kwang Su;Kim Sun Shin;Ryu Keun Ho
    • Proceedings of the KSRS Conference
    • /
    • 2005.10a
    • /
    • pp.770-773
    • /
    • 2005
  • In most biological laboratory, sequences from sequence machine are stored into file disks as simple files. It will be hard work to store and manage the sequence data with consistency and integrity such as storing redundant files. It is required needed to develop a system which integrated and managed genome data with consistency and integrity for accurate sequence analysis. There fore, in this paper, we not only store gene and protein sequence data through sequencing but also manage them. We also make a integrate schema for transforming the file formats and design database system using it. As integrated schema is designed as a BSML, it is possible to apply a style language of XSL. From this, we can transfer among heterogeneous sequence formats.

  • PDF

Development of the Management Software and Construction of Database for the Genetic Resources of Silkworms (누에유전자원 관리프로그램 개발 및 정보 DB화)

  • 손봉희;강필돈;이상욱
    • Journal of Sericultural and Entomological Science
    • /
    • v.43 no.1
    • /
    • pp.29-32
    • /
    • 2001
  • At present, more than 300 races of the Silkworm are conserved and used as valuable genetic resources. But because of the uneffectiveness of manual data management, faster and systematic data base construction is needed. So, development of silkworm genetic resources management program has been begun and the result can be practically used. When developing the program, Visual basic was used for data input system construction, and MS Access for database. IIS(Internet Information System) and ASP(Active Server Page) was also used for searching data and information with Internet Web Server and Web Browser which is comfortable for constructing database and providing information. Data input item consists of 46 practical characteristics such as race name, moltinism, larval period and pupation percentage etc.. And these characteristics are classified with qualitative and quantitative character. Photographs of silkworm, cocoon and other related items were scanned and the image data was recorded on the database.

  • PDF

Visual Object-Oriented Database Design Support System(VODS) (시각적 객체 지향 데이타베이스 설계 지원 시스템에 관한 연구)

  • Ryu, Si-Guk;Gang, Hyeon-Seok
    • The Transactions of the Korea Information Processing Society
    • /
    • v.3 no.4
    • /
    • pp.745-756
    • /
    • 1996
  • In this paper, the design and implementation of VODS is described. VODS is an object-oriented database de-sign support system. VODS supports the whole database design steps according to the EOMT(extended OMT). EOMT as an object- oriented database design methodology is deviced by extending the object model of OMT(Object Modeling Technique) for supporting information navigations to manipulate hyperemia objects. Database designers can do the whole design steps by clicking mouse buttons on the appropriate icons or commands from the initial screen mode.

  • PDF

Design of Grinding Database by Taking Frame-Based Model (후레임 모델에 의한 연삭가공용 데이터 베이스의 설계)

  • 김건희
    • Journal of the Korean Society for Precision Engineering
    • /
    • v.15 no.2
    • /
    • pp.107-113
    • /
    • 1998
  • Grinding operation has difficulty in satisfying the qualitative knowledge based on the skilful expert as well as the quantitative data for all user. Design of grinding database based on the frame-based model is more effective method for utilizing the empirical and qualitative knowledge. In this paper. basic strategy to develop the grinding database by taking frame-based model, which is strongly dependent upon experience and intuition, is described. Grinding database based on the frame based model for designing the interaction and inference among the slots is accomplised by the object-oriented paradigm system.

  • PDF

A Comparative Study on Methods for Implementing VHDL Design Database (VHDL 설계 데이터베이스 구현 방법의 비교 연구)

  • 최승욱;최기영
    • Journal of the Korean Institute of Telematics and Electronics B
    • /
    • v.32B no.7
    • /
    • pp.966-973
    • /
    • 1995
  • In this paper, we compare several methods for implementing a VHDL design database through a case study on VHDL tool development system. We implemented three versions of the VHDL design database which the VHDL tool development system is based on. The first version was coded in the C programming language following value-oriented paradigm. The second one was coded in the C++ programming language following object-oriented paradigm. The third one was implemented using an existing object-oriented database. Based on our experience, we present quantitatively the pros and cons of each implementation method. The value-oriented version was most difficult to implement but showed good performance. Compared to the value- oriented version, the C++ version was twice as easy to implement and showed about the same performance. Using an existing object-oriented database allowed easiest implementation but resulted in a 1.5 to 6 times slower version.

  • PDF

The Efficient Query Evaluation Plan in the Spatial Database Engine

  • Liu, Zhao-Hong;Kim, Sung-Hee;Lee, Jae-Dong;Bae, Hae-Young
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2001.04b
    • /
    • pp.22-24
    • /
    • 2001
  • A new GIS software Spatial Database Engine(SDE) has been developed to integrated with spatial database that combines conventional and spatially related data. As we known well in the traditional relation database system, the query evaluation techniques are a well-researched subject, many useful and efficient algorithms have been proposed, but in the spatial database system, it is a litter difference with the traditionally ones. Based on the Query Graph Model(QGM), we implemented our own query evaulation plan in the SDE, which can deal with the full functionality query statement SELECT-FROM-WHERE_GROUPBY-HAVING, and treat the spatial data and non-spatial data seamlessly. We proposed a novel multi way join algorithm base on nest loop that may be attractive.

  • PDF

A Study on the Restructure of Multi-Platform Databases for MIRAS (메타 정보검색 에이전트 시스템을 위한 다중플랫폼의 데이터베이스 재구조화에 관한 연구)

  • Shin, Chang-Hoon;Ryu, Pyung-Mu
    • Asia pacific journal of information systems
    • /
    • v.13 no.1
    • /
    • pp.47-72
    • /
    • 2003
  • It is important to retrieve information that a user requires on the web. The web is an open system. The amount of information is increasing rapidly. While each of information was compiled into the database piece at a single platform in the past, it is now compiled into complicated structure at a multi-platform. Restructuring the multi-platform database is needed to efficiently retrieve information. MIRAS(Meta Information Retrieval Agent System) has a multi-platform database on web. This study applies the classification of the existent site's categories to restructure the database systematically. The empirical analysis shows that the suggested method is effective for information retrieval and multi-platform database restructuring. This study helps users to save on time-cost of searching information.

Query Operations for Fuzzy Spatiotemporal Databases (퍼지 시공간 데이터베이스를 위한 질의 연산)

  • Nhan Vu Thi Hong;Chi Jeong-Hee;Ryu Keun-Ho
    • 한국공간정보시스템학회:학술대회논문집
    • /
    • 2004.12a
    • /
    • pp.81-88
    • /
    • 2004
  • GIS (geographic information system) applications increasingly require the representation of geospatial objects with fuzzy extent and querying of time-varying information. In this paper, we Introduce a FSTDB (fuzzy spatiotemporal database) to represent and manage states and events causing changes of dynamic fuzzy objects using fuzzy set theory. We also propose the algorithms for the operators to be included in a GIS to make it able to answer queries depending on fuzzy predicates during a time interval and a method to identify the development process of objects during a certain period based on the designed database. They can be used in application areas handling time-varying geospatial data, including global change (as in climate or land cover change) and social (demographic, health, ect.) application.

  • PDF