• 제목/요약/키워드: Relational database.

Search Result 576, Processing Time 0.03 seconds

A Methode for Object-Relational Database Design with Extended UML Class Diagram (확장된 UML 클래스 다이어그램을 이용한 객체 관계형 데이터베이스 설계 기법)

  • Kim, In-Chul;Kim, Young-Ung
    • Proceedings of the Korea Information Processing Society Conference
    • /
    • 2005.11a
    • /
    • pp.91-94
    • /
    • 2005
  • 공학적 기반의 응용 프로그램에서는 복합관계(complex relationship) 및 복합객체(complex object)의 개념이 요구되는데, 이러한 개념들은 비즈니스 응용에 적합한 관계형 데이터베이스로 다루기에는 저장과 검색 시 많은 문제점을 야기한다. 이와 같은 문제점을 해결하기 위해서 객체 관계형 데이터베이스 시스템이 출현하게 되었다. 한편, 고전적인 데이터베이스 설계 기법은 개체 관계형 모델(Entity Relationship Model)과 같은 개념적 모델을 사용하며 데이터 중심의 구조적 관점(structural aspect)만을 고려하는 반면, UML(Unified Modeling Language)같은 객체지향형 설계 도구를 사용하여 데이터베이스를 설계할 경우 구조적 관점 및 행위적 관점(behavioral aspect)을 모두 포함한다. UML은 확장 가능한 언어로서, 특정 응용프로그램에 대한 새로운 스테레오타입(stereotype)의 사용이 가능하다. 데이터베이스 설계를 위한 확장된 UML의 스테레오타입이 제안되었지만, 대부분 관계형 데이터베이스에 초점이 맞추어져 있다. 본 논문에서는 객체 관계형 데이터베이스 설계를 위한 확장된 UML 스테레오타입을 기술하며, 복합관계 및 복합객체를 지원하기 위해 Aggregation, Composition, Association의 개념을 재정의한 설계기법을 제안하고, 제안한 설계기법을 지원하는 설계 도구(ORDesigner)의 구현에 대해서 기술한다.

  • PDF

Synthesis of Primary Studies Related to Clothing Involvement by Meta-analysis (의복관여 효과에 대한 메타분석)

  • Lee, Jongnam;Yu, Haekyung
    • Journal of the Korean Society of Clothing and Textiles
    • /
    • v.37 no.3
    • /
    • pp.386-398
    • /
    • 2013
  • This study analyzes the effect of clothing involvement using meta-analysis. Metal-analysis (the analysis of analyses) is widely used in various academic areas to integrate individual empirical studies and generalize the knowledge of a specific research field. Previous studies regarding clothing involvement published since 1990 were researched from the KISS database using clothing involvement and fashion involvement as a keyword; subsequently, 127 articles were identified. Studies that had insufficient statistics or included clothing involvement as a moderating (or intervening variable) were eliminated; subsequently, 36 articles provided a total of 75 data sets that were used for the final analysis. Dependent variables were grouped into 10 categories to compare the differences between high and low involvement groups. The effect size of clothing involvement was large in non-personal information source; however, it was small in utility, brand royalty and quality. In the 7 categories of relational studies that showed homogeneity, the relation size regarding conformity was smaller than the personal information source.

A Data Model for XML

  • LEE, Dae-Woo;CHOI, Ok;KIM, Young-Chan
    • Proceedings of the Korea Society of Information Technology Applications Conference
    • /
    • 2001.11a
    • /
    • pp.169-171
    • /
    • 2001
  • 본 논문에서는 XML(eXtensible Markup Language)을 위한 데이터 모델을 제시하기 위해 현재 광범위하게 사용되고 있는 관계형 데이터베이스(relational database) 개념을 적용한다. 관계형 데이터베이스는 업무 요구사항의 분석으로부터 고수준의 개념적 데이터 모델을 사용해서 데이터베이스에 대한 개념적 스키마(conceptual schema)를 생성한 다음, 고수준 개념적 데이터 모델을 구현 데이터 모델로 변환하여 논리적 데이터베이스 스키마를 생성한다. 이때, 고수준 개념적 데이터 모델링의 대표적인 방법으로 ER모델을 사용하고, 구현 데이터 모델로 관계 모델(relation model)을 사용한다. XML은 문서의 논리적 구조를 정의하는 DTD와 XML Schema 등을 갖는다. XML의 DTD와 정보 모델링 기법인 E/R 모델은 모두 작은 세계(real world)를 모델링하는 도구들이라고 할 수 있다. 본 논문에서는 XML의 DTD와 E/R 모델의 구성요소들을 분석하여 서로 사상(mapping)시키는 'XML을 위한 데이터 모델(A Data Model for XML)'을 제시한다. 최종적으로 제시된 XML을 위한 데이터 모델에 의해 작은 세계(real world)을 모델링하는 XML DTD에서 정의한 구조(XML Structure)을 따르는 유효한 XML문서(validate XML document)들은 관계형 데이터베이스에 저장할 수 있게 된다.

  • PDF

A Practical Study of Unified Management System for Irrigation and Drainage Facilities (수리시설물 통합관리시스템 실용화 연구)

  • 김선주;박성삼
    • Magazine of the Korean Society of Agricultural Engineers
    • /
    • v.40 no.3
    • /
    • pp.42-53
    • /
    • 1998
  • About 50 percent of irrigation and drainage facilities in our country are deteriorated as they were constructed over 40 years ago. Worsening the problems in function might be caused by these facilities' constant exposure to the elements. With these reason, efficient maintenance and management of irrigation and drainage facili- ties are required. A computerized system is tailored on the basis of the each characteristics'data of irrigation and drainage facilities. The unified management system to be introduced in this study is a package program consisting of three subprograms. Facility Management(FM) system, the first component, is a relational database system for image processing and registering the characteristics of irrigation and drainage facilities. The objective of this program is to manage the ledger of each facilities and to scan the characteristics of facilities. Telemeter(TM) system, the second component, monitors and processes the data from the sensors statistically. This system is preprogramed for the complete design of TC/TM system. Hydrological Data Management(HDM) system, the third component, executes the hydrological analysis using meteorological data. The unified management system can provide the latest information, such as image data, lists and items of facilities, and items of reforming and rebuilding etc., of the facilities to the manager. At the same time, this system can manage hydrological and meteorological data in realtime.

  • PDF

Development of a Patient Monitoring System Overall Architecture and Specifications (환자모니터링시스템의 개발 : 전체구조 및 기본사양)

  • 우응제;박승훈
    • Journal of Biomedical Engineering Research
    • /
    • v.18 no.1
    • /
    • pp.17-24
    • /
    • 1997
  • We have developed a patient monitoring system including module-based bedside monitors, interbed network, central stations, clinical workstations, and DB servers. A bedside monitor with a color LCD can accommodate up to 3 module cases and 21 different modules. Six different physiological parameters of ECG, respiration, invasive blood pressure, noninvasive blood pressure, body temperature, and arterial pulse oximetry with plethysmoyaph are provided as parameter modules. In a single bedside monitor, modules and a module controller communicate with IMbps data rate through an intrabed network based on RS-485 and HDU protocol. At the same time, it communicates with other bedside monitors and central stations through interbed network based on 1 OMbps Ethernet and TCP/IP protocol. Central stations using 20" color CRT monitors can be connected with many bedside monitors and they display 18 channels of waveforms simultaneously. Clinical workstations are used mainly for the review of patient datE In order to accommodate more advanced data management capabilities such as 24-hour full disclosure, we have developed a relational database server dedicated to the patient monitoring system. Software for bedside monitor, central station, and clinical workstation fully utilizes graphical user interface techniques and all functions are controlled by a rotate/push button on the bedside monitor arid a mouse on the central station and clinical workstation. The entire system satisfies the requirements of AAMI and ANSI standards in terms of electrical safety and performances.nces.

  • PDF

Efficient Continuous Skyline Query Processing Scheme over Large Dynamic Data Sets

  • Li, He;Yoo, Jaesoo
    • ETRI Journal
    • /
    • v.38 no.6
    • /
    • pp.1197-1206
    • /
    • 2016
  • Performing continuous skyline queries of dynamic data sets is now more challenging as the sizes of data sets increase and as they become more volatile due to the increase in dynamic updates. Although previous work proposed support for such queries, their efficiency was restricted to small data sets or uniformly distributed data sets. In a production database with many concurrent queries, the execution of continuous skyline queries impacts query performance due to update requirements to acquire exclusive locks, possibly blocking other query threads. Thus, the computational costs increase. In order to minimize computational requirements, we propose a method based on a multi-layer grid structure. First, relational data object, elements of an initial data set, are processed to obtain the corresponding multi-layer grid structure and the skyline influence regions over the data. Then, the dynamic data are processed only when they are identified within the skyline influence regions. Therefore, a large amount of computation can be pruned by adopting the proposed multi-layer grid structure. Using a variety of datasets, the performance evaluation confirms the efficiency of the proposed method.

Query Optimization with Knowledge Management in Relational Database (관계형 데이타베이스에서 지식관리에 의한 질의 최적화)

  • Nam, In-Gil;Lee, Doo-Han
    • The Transactions of the Korea Information Processing Society
    • /
    • v.2 no.5
    • /
    • pp.634-644
    • /
    • 1995
  • In this paper, we propose a mechanism to transform more effective and semantically equivalent queries by using appropriately represented three kinds of knowledge. Also we proposed a mechanism which transforms partially omitted components or expressions into complete queries so that users can use more simple queries. The knowledges used to transform and optimize are semantic, structural and domain knowledge. Semantic knowledge includes semantic integrity constraints and domain integrity constraints. Structural knowledge represents physical relationship between relations. And domain knowledge maintains the domain information of attributes. The proposed system optimizes to more effective queries by eliminating/adding/replacing unnecessary or redundant restrictions/joins.

  • PDF

Construction of Street Trees Information Management Program Using GIS and Database (GIS와 데이터베이스를 이용한 가로수정보 관리프로그램 구축)

  • Kim, Hee-Nyeon;Jung, Sung-Gwan;Park, Kyung-Hun;You, Ju-Han
    • Current Research on Agriculture and Life Sciences
    • /
    • v.26
    • /
    • pp.45-54
    • /
    • 2008
  • The purpose of this research is to develope street trees management program for more an effective street trees management. The principal point of this program is to relate spatial data and attribute data that is the main concept in GIS(Geographic Information System). To do this function, MapObjects which is ESRI's mapping and GIS components was used to process spatial data and Access which had been developed by MS was used to manipulate attribute data in this program. Visual Basic also was used to design and develop user interfaces and procedures, relate two sort of data, and lastly complete Application. Relational data model was adopted to design tables and their relation, Antenucci's GIS development model was selected to design and complete this program. The configuration of this application is composed of management data and reference data. The management data includes the location of street tree, a growth condition, a surrounding environment, the characters of tree, an equipments, a management records and etc. The reference data include general information about tree, blight and insects.

  • PDF

RDF and OWL Storage and Query Processing based on Relational Database (관계형 데이타베이스 기반의 RDF와 OWL의 저장 및 질의처리)

  • Jeong Hoyoung;Kim Jungmin;Jung Junwon;Kim Jongnam;Im Donghyuk;Kim Hyoung-Joo
    • Journal of KIISE:Computing Practices and Letters
    • /
    • v.11 no.5
    • /
    • pp.451-457
    • /
    • 2005
  • In spite of the development of computers, the present state that a lot of electronic documents are overflowing makes it more difficult for us to get appropriate information. Therefore, it's more important to focus on getting meaningful information than processing the data quickly In this context, Semantic Web enables an intelligent processing by adding semantic metadata on yow web documents. Also, as the Semantic Web grows, the knowledge resources as well as web resources are getting more and more importance. In this paper, we propose an OWL storage system aiming at an intelligent Processing by adding semantic metadata on your web documents, plus a system aiming at an OWL-QL Query Processing.

W3C XQuery Update facility on SQL hosts (관계형 테이블을 이용한 W3C XQuery 변경 기능의 지원)

  • Hong, Dong-Kweon
    • Journal of the Korean Institute of Intelligent Systems
    • /
    • v.18 no.3
    • /
    • pp.306-310
    • /
    • 2008
  • XQuery is a new recommendation for XML query. As an efforts for extending XQuery capabilities XML insertion and deletion are being studied and its standardization are going on. Initially XML databases are developed simply for XML document management. Now their functions are extending to OLTP. In this paper we are adding updating functions to XQuery processing system that is developed only for XQuery retrievals. We suggest the structure of tables, numbering schemes for hierarchical structures, and the methods for SQL translations for XQuery updates.