• Title/Summary/Keyword: 데이타베이스 설계

Search Result 350, Processing Time 0.03 seconds

Temporal Database Management Testbed (시간 지원 데이타 베이스 관리 시험대)

  • Kim, Dong-Ho;Jeon, Geun-Hwan
    • The Transactions of the Korea Information Processing Society
    • /
    • v.1 no.1
    • /
    • pp.1-13
    • /
    • 1994
  • The Temporal Database Management Testbed supports valid and transaction time. In this paper, we discuss the design and implementation of a testbed of a temporal database management system in main memory. The testbed consists of a syntactic analyzer, a semantic analyzer, a code generator, and an interpreter. The syntactic analyzer builds a parse tree from a temporal query. The semantic analyzer then checks it for correctness against the system catalog. The code generator builds an execution tree termed ann update network. We employ an incremental view materialization for the execution tree. After building the execution tree, the interpreter activates each node of the execution tree. Also, the indexing structure and the concurrency control are discussed in the testbed.

  • PDF

Design and Implementation of a GML Document Management System (GML 문서 관리 시스템의 설계 및 구현)

  • 김동오;윤재관;한기준
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2001.10a
    • /
    • pp.85-87
    • /
    • 2001
  • 최근 지리 정보 시스템(GIS)이 전 국가적으로 대중화되면서 지리 정보가 다양한 분야와 다양한 서버 환경에서 사용되고 있다. 따라서, 이렇게 다양해진 지리 정보를 효율적으로 사용하기 위해선 지리 정보 시스템의 상호운용성은 필수적이다. 이를 지원하기 위해서 OGC(Open GIS Consortium)에서는 상호운용성에 대한 표준 명세인 OpenGIS(Open Geodata Interoperability Specification)를 제시하였으며, 또한 이를 웹 환경에서 검증하고 활용하기 위해 웹 매핑 테스트 베드에서 여러 가지 시도를 하고 있다 이러한 시도 중 하나로 웹 환경의 이질적인 지리 정보를 공통적으로 표현하기 위해 지리정보를 구조화된 문서인 XML(eXtensible markup Language)로 인코딩하는 GML(Geography Markup Language) 명세를 제시하였다. 본 논문에서는 다양한 환경에서 지리 정보를 표현하기 위한 GML 2.0 명세와 GML 2.0 에서 사용하고 있는 XML 스키마 명세를 분석하였다. 또한, 이를 토대로 사용자들이 GML 2.0 문서를 쉽게 생성, 디스플레이, 편집할 수 있도록 함은 물론 기존의 공간 데이타베이스 시스템의 지리 정보를 GML 2.0 문서로 변환하고, 반대로 GML 2.0 문서를 공간 데이타베이스로의 변환을 쉽게 할 수 있는 GML문서 관리 시스템을 설계 및 구현하였다.

  • PDF

Development of an OODBMS Functionality Testing Tool Prototype. (객체지향 DBMS 기능 시험 도구의 프로토타입 개발)

  • 김은영;이상호;전성택
    • The Journal of Information Technology and Database
    • /
    • v.2 no.2
    • /
    • pp.25-34
    • /
    • 1995
  • In this paper, we present design philosophy and implementation issues of a functionality testing tool for object-oriented database systems. A testing tool has been developed to validate UniSQL/X functionalities with C++ interface. A testing tool is designed under consideration of scaleability, simplicity and extendibility. The schema is deliberately constructed to verify the object-oriented functionalities such as abstraction, inheritance and aggregation. Each test item has been derived under various black box techniques such as equivalent partitioning and boundary-value analysis. The testing tool consists of six phases, namely, database creation, database population, construction of testindex, compilation and link, execution and result reporting, and final cleanup. The prototype provides more than 140 test items at 90 programs.

  • PDF

A Data Mining System for Supporting of Business Intelligence in e-Business (e-Business에서의 BI지원 데이타마이닝 시스템)

  • Lee, Jun-Wook;Baek, Ok-Hyun;Ryu, Keun-Ho
    • Journal of KIISE:Computing Practices and Letters
    • /
    • v.8 no.5
    • /
    • pp.489-500
    • /
    • 2002
  • As the interest in business interest is increased, data mining is increasingly used in BI as the core technique. To support Business Intelligence in e-business environment, the integrated data mining system which included in various mining operations should be able to flexibly integrate with database system and also it must provide the easy and efficient interface to implement the marketing process in various business applications. In this paper, we have implemented the EC-DaMiner system to support business intelligence in e-business area. The implemented system can be integrated with the conventional database system with the standard interface. Business applications can use MQL mining query language to discover the rules and mining result is modeled in marketing database, and the EC-DaMiner system make the implementation of business marketing process more easy.

Design and Implementation of an Open Object Management System for Spatial Data Mining (공간 데이타 마이닝을 위한 개방형 객체 관리 시스템의 설계 및 구현)

  • Yun, Jae-Kwan;Oh, Byoung-Woo;Han, Ki-Joon
    • Journal of Korea Spatial Information System Society
    • /
    • v.1 no.1 s.1
    • /
    • pp.5-18
    • /
    • 1999
  • Recently, the necessity of automatic knowledge extraction from spatial data stored in spatial databases has been increased. Spatial data mining can be defined as the extraction of implicit knowledge, spatial relationships, or other knowledge not explicitly stored in spatial databases. In order to extract useful knowledge from spatial data, an object management system that can store spatial data efficiently, provide very fast indexing & searching mechanisms, and support a distributed computing environment is needed. In this paper, we designed and implemented an open object management system for spatial data mining, that supports efficient management of spatial, aspatial, and knowledge data. In order to develop this system, we used Open OODB that is a widely used object management system. However, the lark of facilities for spatial data mining in Open OODB, we extended it to support spatial data type, dynamic class generation, object-oriented inheritance, spatial index, spatial operations, etc. In addition, for further increasement of interoperability with other spatial database management systems or data mining systems, we adopted international standards such as ODMG 2.0 for data modeling, SDTS(Spatial Data Transfer Standard) for modeling and exchanging spatial data, and OpenGIS Simple Features Specification for CORBA for connecting clients and servers efficiently.

  • PDF

Logical Design of Product Ontology in Relational Databases (상품 온톨로지 저장을 위한 관계형 데이터베이스 논리적 설계)

  • Lee, Hyun-Ja;Shim, Jun-Ho
    • The Journal of Society for e-Business Studies
    • /
    • v.14 no.1
    • /
    • pp.81-92
    • /
    • 2009
  • In order to use a RDBMS as the repository for product information, it is essential that the ontological query be processed effectively and answered properly, satisfying the user's expectations for an ontological query process. To be well-processed ontological queries, the key point is whether the various semantic relationships among the concepts of the product information are likewise well-processed. For feasibly processing a semantic query, we need to consider how the product ontology data is designed and stored in RDBMS. In this paper, we present how a RDB schema for the product ontology could be designed and queried.

  • PDF

Implementation of Analyzer of the Alert Data using Data Mining (데이타마이닝 기법을 이용한 경보데이타 분석기 구현)

  • 신문선;김은희;문호성;류근호;김기영
    • Journal of KIISE:Databases
    • /
    • v.31 no.1
    • /
    • pp.1-12
    • /
    • 2004
  • As network systems are developed rapidly and network architectures are more complex than before, it needs to use PBNM(Policy-Based Network Management) in network system. Generally, architecture of the PBNM consists of two hierarchical layers: management layer and enforcement layer. A security policy server in the management layer should be able to generate new policy, delete, update the existing policy and decide the policy when security policy is requested. And the security policy server should be able to analyze and manage the alert messages received from Policy enforcement system in the enforcement layer for the available information. In this paper, we propose an alert analyzer using data mining. First, in the framework of the policy-based network security management, we design and implement an alert analyzes that analyzes alert data stored in DBMS. The alert analyzer is a helpful system to manage the fault users or hosts. Second, we implement a data mining system for analyzing alert data. The implemented mining system can support alert analyzer and the high level analyzer efficiently for the security policy management. Finally, the proposed system is evaluated with performance parameter, and is able to find out new alert sequences and similar alert patterns.

A Film-Defect Inspection System Using Image Segmentation and Template Matching Techniques (영상 세그멘테이션 및 템플리트 매칭 기술을 응용한 필름 결함 검출 시스템)

  • Yoon, Young-Geun;Lee, Seok-Lyong;Park, Ho-Hyun;Chung, Chin-Wan;Kim, Sang-Hee
    • Journal of KIISE:Databases
    • /
    • v.34 no.2
    • /
    • pp.99-108
    • /
    • 2007
  • In this paper, we design and implement the Film Defect Inspection System (FDIS) that detects film defects and determines their types which can be used for producing polarized films of TFT-LCD. The proposed system is designed to detect film defects from polarized film images using image segmentation techniques and to determine defect types through the image analysis of detected defects. To determine defect types, we extract features such as shape and texture of defects, and compare those features with corresponding features of referential images stored in a template database. Experimental results using FDIS show that the proposed system detects all defects of test images effectively (Precision 1.0, Recall 1.0) and efficiently (within 0.64 second in average), and achieves the considerably high correctness in determining defect types (Precision 0.96 and Recall 0.95 in average). In addition, our system shows the high robustness for rotated transformation of images, achieving Precision 0.95 and Recall 0.89 in average.

퍼스날 컴퓨터용 수문데이타베이스(PCHISS)의 개발

  • Sin, Hyeon-Min;Kim, Seung;Seo, Byeong-Ha
    • Proceedings of the Korea Water Resources Association Conference
    • /
    • 1991.07a
    • /
    • pp.5-12
    • /
    • 1991
  • 수자원 관련 연구 및 설계는 대부분 수문자료의 분석으로보터 출발하며, 따라서 수문자료의 효율적 관리 및 제공시스템의 필요성이 강조되어 왔다. 또한 설계회사 또는 학계, 연구소 등에서 수문자료의 분석시 퍼스날 컴퓨터를 이용하는 경우가 상당히 많으며, 단위 프로젝트에 필요한 비교적 적은 양 - 예를 들어 전국 중 특정 수계만을 대상으로 하는 경우 - 의 수문자료는 퍼스날 컴퓨터로도 처리가 가능하므로, 프로젝트 단위 수문자료의 검색, 출력 및 기본적 분석기능을 제공하는 퍼스날 컴퓨터용 수문데이타베이스의 개발 필요성이 제기되었다. PCHISS(Personal Computer Hydrological Information Support System)는 이러한 필요성에 의해 폭넓게 보급, 사용되고 있는 퍼스날 컴퓨터 - MS-DOS로 운영되는 IBM 호환 16비트 AT 또는 XT - 를 대상으로 상기한 수문자료의 검색, 출력 및 기본적 분석기능과 관측소 정보의 출력기능을 제공하도록 개발되었다. 개발에 사용된 언어는 C언어이며, C언어 프로그램에 의해 색인화된 자료처리기능을 제공하는 C-ISAM(C-Indexed Sequential Access Method)이라는 라이브러리를 사용하였다. 개발된 수문데이타베이스는 반복되는 수문자료의 검색, 출력 및 분석업무의 효율성 제고를 기할 수 있으며, 퍼스날 컴퓨터 및 보조기억장치를 포함한 주변장치의 성능이 계속 향상되고, 반면 가격은 상대적으로 낮추어지고 있으므로 프로젝트 단위의 수문자료관리시스템의 역할을 충분히 수행할 수 있을 것으로 기대된다.

  • PDF

Design and Implementation of Multimedia Retrieval a System (멀티미디어 검색 시스템의 설계 및 구현)

  • 노승민;황인준
    • Journal of KIISE:Databases
    • /
    • v.30 no.5
    • /
    • pp.494-506
    • /
    • 2003
  • Recently, explosive popularity of multimedia information has triggered the need for retrieving multimedia contents efficiently from the database including audio, video and images. In this paper, we propose an XML-based retrieval scheme and a data model that complement the weak aspects of annotation and conent based retrieval methods. The Property and hierarchy structure of image and video data are represented and manipulated based on the Multimedia Description Schema (MDS) that conforms to the MPEG-7 standard. For audio contents, pitch contours extracted from their acoustic features are converted into UDR string. Especially, to improve the retrieval performance, user's access pattern and frequency are utilized in the construction of an index. We have implemented a prototype system and evaluated its performance through various experiments.