• Title/Summary/Keyword: relational database system

Search Result 361, Processing Time 0.025 seconds

Structural Analysis and Performance Test of Graph Databases using Relational Data (관계형데이터를 이용한 그래프 데이터베이스의 모델별 구조 분석과 쿼리 성능 비교 연구)

  • Bae, Suk Min;Kim, Jin Hyung;Yoo, Jae Min;Yang, Seong Ryul;Jung, Jai Jin
    • Journal of Korea Multimedia Society
    • /
    • v.22 no.9
    • /
    • pp.1036-1045
    • /
    • 2019
  • Relational databases have a notion of normalization, in which the model for storing data is standardized according to the organization's business processes or data operations. However, the graph database is relatively early in this standardization and has a high degree of freedom in modeling. Therefore various models can be created with the same data, depending on the database designers. The essences of the graph database are two aspects. First, the graph database allows accessing relationships between the objects semantically. Second, it makes relationships between entities as important as individual data. Thus increasing the degree of freedom in modeling and providing the modeling developers with a more creative system. This paper introduces different graph models with test data. It compares the query performances by the results of response speeds to the query executions per graph model to find out how the efficiency of each model can be maximized.

Developing an End-User Computing PDM System for Small and Medium Business (중소기업을 위한 최종 사용자 컴퓨팅 PDM 시스템 개발)

  • Do, Namchul
    • Journal of Korean Institute of Industrial Engineers
    • /
    • v.41 no.2
    • /
    • pp.162-172
    • /
    • 2015
  • This paper proposes a Product Data Management (PDM) system architecture that supports end-user computing for small and medium businesses (SMBs) in Korea to build and maintain efficient and sustainable information systems for their product development. Its open database with relational tables enables existing common application programs such as Microsoft office suites to access product data in PDM systems. In addition, the interactive query processor provided by database management systems helps design engineers to build ad hoc queries in standard SQL database language to response different data requirements during their product development. The PDM architecture with the open database allows design engineers or technical staffs in SMBs to build and maintain their application programs for product development by themselves. To show the feasibility of the proposed architecture, this study implemented a prototype PDM system based on the architecture and database, and represents real-world product data with the implemented PDM system.

Development and Implementation of Design Object Model for Integrated Structural Design System (통합 구조설계 시스템을 위한 설계 객체 모델의 개발과 구현)

  • 천진호;이창호;이병해
    • Proceedings of the Computational Structural Engineering Institute Conference
    • /
    • 2001.10a
    • /
    • pp.151-158
    • /
    • 2001
  • This paper describes an example of developing an integrated design system, Integrated Structural Design System for Reinforced Concrete Buildings(INDECON). INDECON incorporates a central database and three design modules: a preliminary design module(PDM), a structural analysis module(SAM), and a detailed design module(DDM). The development of INDECON begins with the development of design models including Design Object Model(DOM) which describes design data during the structural design process. The Design Object Model is transformed to Design Table Model(DTM) for the central database, and is specified to be in detail for the three design modules. Then the central database is implemented and managed by relational database management system(RDBMS), and the three design modules are implemented using C++ programming language. The central database in the server computer communicates with the design modules in the client computers using TCP/IP internet protocol. The developing procedure for INDECON in this paper can be applied for developing more comprehensive integrated structural design systems.

  • PDF

Load Flow Analysis using Object-oriented Database (객체지향 데이터베이스를 이용한 전력조류계산)

  • Park, Ji-Ho;Baek, Young-Sik
    • Proceedings of the KIEE Conference
    • /
    • 2003.11a
    • /
    • pp.275-277
    • /
    • 2003
  • This paper deals with Object-oriented Database(OODB) which is designed for power system analysis, and describes load flow analysis using OODB. Database management systems are widely used and achieve high reliability of data management in the engineering fields. However conventional database systems, relational database system, have disadvantages in application to power system analysis. This paper presents advantages of OODB for modeling complex data of a power system analysis. The OODB supports data modeling requirements of GUI applications and the performance is well acceptable for GUI applications.

  • PDF

Development of Database System for T-50 Flutter/Vibroacoustic Flight Test Data (T-50 플러터/진동소음 비행시험 데이터베이스 시스템 개발)

  • Gwak, Dong-Il;Baek, Seung-Gil;Park, Geum-Dang;Kim, Yeong-Ik
    • Journal of the Korean Society for Aeronautical & Space Sciences
    • /
    • v.34 no.2
    • /
    • pp.82-89
    • /
    • 2006
  • The flutter/vibroacoustic characteristics can be acquired by conducting flight tests with various conditions for a long period of test. Accordingly it is indispensable to build a specially designed database system to efficiently accumulate the enormous data obtained from flight tests. Hence, T-50 Flight Test Database System(FTDS) based on MS-Access is developed to handle the flutter/vibroacoustic environment data obtained from flight tests. The developed system is structured with the items related to aircraft flight test, the tables composed of the relevant items and a relational database logically connecting the tables. The T-50 FTDS is implemented with data searching GUI(Graphic User Interface) programed with Visual Basic and Structured Query Language to make intuitive searches over the stored data. The developed system has been used for accumulating the flutter/vibroacoustic data and verifying vibroacoustic Specifications.

Database Structure and Information Exchange System of KEPCO's EMS SYSTEM (한전(韓電)EMS의 데이터베이스 및 정보교환체제(情報交換體制))

  • Lee, Kyung-Jae;Yu, Sung-Chul;Kim, Yeong-Han;Lee, Hyo-Sang
    • Proceedings of the KIEE Conference
    • /
    • 1988.11a
    • /
    • pp.87-91
    • /
    • 1988
  • For the electric power system operation, the information to monitor the operation status of power plants and transmission lines is very important factor in the view point of system security and economic operation. This paper presents the logical and physical structures of database used by KEPCO's EMS. The adopted DataBase Management System (DBMS) of a relational model type offers many advantages such as easy maintenance of database. In addition, this paper briefly introduces the data exchange system between application programs and database.

  • PDF

An XML Data Management System and Its Application to Genome Databases (XML 데이타 관리시스템과 유전체 데이타베이스에의 응용)

  • 이경희;김태경;김선신;이충세;조완섭
    • Journal of KIISE:Databases
    • /
    • v.31 no.4
    • /
    • pp.432-443
    • /
    • 2004
  • As the XML data has been widely used in the Internet, it is necessary to store and retrieve the XML data by using DBMSs. However, relational DBMSs suffer from the model difference between graph structure of the XML data and table forms in relational databases. We propose an ORDBMS-based DTD-dependent XML data management system Xing. Xing stores XML data in a DTD-dependent form in an object database. Since the object database schema has a graph structure and supports multi-valued attributes, mapping from an XML data model and queries into an object data model and OQLs is a simple problem. For rapid storing of large quantities of the XML data, we use SAX parser with customized Xing-tree which requires a small memory space compared with the DOM-tree. Xing also returns the query result in an XML document form. We have implemented the Xing system on top of UniSQL object-relational DBMS for the validity checking and performance comparison. For XML genome data from GenBank, and experimental evaluation shows that Xing can provide significant performance improvement (maximum 10 times) compared with the relational approach.

A Storage Scheme for Logging and Indexing B2Bi XML Messages (기업간통합 XML 메시지의 기록과 색인을 위한 저장 방식)

  • Song Ha-Joo;Kim Chang-Su;Kwon Oh-Heum
    • Journal of KIISE:Computing Practices and Letters
    • /
    • v.11 no.5
    • /
    • pp.416-426
    • /
    • 2005
  • A B2Bi system needs a message storage subsystem that efficiently logs and searches XML messages which have been sent from orreceived by it. XML database systems and XML enabled relational databases systems are not adequate as a message storage system because of their expensiveness and excessiveness in functionality. Storage schemes that split XML messages into database records are also unacceptable because of either low performance or implementation hardness. In this paper, we propose a storage scheme that can be applied to implement a message storage system based on a relational database system. In this scheme, messages are examined only through the index fields that have been registered for each message types. Therefore, the proposed storage scheme cannot support such a powerful search facility like XQL, but it provides high performance message legging and restricted search facility. There are three alternative database schemas to store the index fields. This paper compares the advantages and disadvantages of the three schemas through experimental tests.

HBase based Business Process Event Log Schema Design of Hadoop Framework

  • Ham, Seonghun;Ahn, Hyun;Kim, Kwanghoon Pio
    • Journal of Internet Computing and Services
    • /
    • v.20 no.5
    • /
    • pp.49-55
    • /
    • 2019
  • Organizations design and operate business process models to achieve their goals efficiently and systematically. With the advancement of IT technology, the number of items that computer systems can participate in and the process becomes huge and complicated. This phenomenon created a more complex and subdivide flow of business process.The process instances that contain workcase and events are larger and have more data. This is an essential resource for process mining and is used directly in model discovery, analysis, and improvement of processes. This event log is getting bigger and broader, which leads to problems such as capacity management and I / O load in management of existing row level program or management through a relational database. In this paper, as the event log becomes big data, we have found the problem of management limit based on the existing original file or relational database. Design and apply schemes to archive and analyze large event logs through Hadoop, an open source distributed file system, and HBase, a NoSQL database system.

A Conceptual Model for Automated Cost Estimating Using Work Information Classification System of Apartment House (공동주택의 공사정보분류체계를 활용한 적산 자동화 개념 모형 개발)

  • Lee, Yang Kyu;Park, Hong Tae
    • Journal of the Society of Disaster Information
    • /
    • v.10 no.1
    • /
    • pp.15-24
    • /
    • 2014
  • The study presents work information classification system of apartment house which can organize all construction management services throughout the planning and management of a construction such as the decomposition of the design process, the assembly of construction process and cost estimating, etc. In addition, the study suggested a way to connect work information classification system based on a relational database in working order and built a conceptual model for automated cost estimating by utilizing established data base. A conceptual model for automated cost estimating will resolve the fundamental problems of the existing cost estimating system and will be able to take advantage of scientific cost estimating system at the construction site of apartment house.