• Title/Summary/Keyword: relational database system

Search Result 361, Processing Time 0.028 seconds

Efficient Knowledge Base Construction Mechanism Based on Knowledge Map and Database Metaphor

  • Kim, Jin-Sung;Lee, Kun-Chang;Chung, Nam-Ho
    • Proceedings of the Korean Operations and Management Science Society Conference
    • /
    • 2004.05a
    • /
    • pp.9-12
    • /
    • 2004
  • Developing an efficient knowledge base construction mechanism as an input method for expert systems (ES) development is of extreme importance due to the fact that an input process takes a lot of time and cost in constructing an ES. Most ES require experts to explicit their tacit knowledge into a form of explicit knowledge base with a full sentence. In addition, the explicit knowledge bases were composed of strict grammar and keywords. To overcome these limitations, this paper proposes a knowledge conceptualization and construction mechanism for automated knowledge acquisition, allowing an efficient decision. To this purpose, we extended traditional knowledge map (KM) construction process to dynamic knowledge map (DKM) and combined this algorithm with relational database (RDB). In the experiment section, we used medical data to show the efficiency of our proposed mechanism. Each rule in the DKM was characterized by the name of disease, clinical attributes and their treatments. Experimental results with various disease show that the proposed system is superior in terms of understanding and convenience of use.

  • PDF

An Optimal Database Design Considering Denormalization in Relational Database (관계형 데이터베이스에서 비정규화를 고려한 최적 데이터베이스 설계)

  • 장영관;강맹규
    • The Journal of Information Technology and Database
    • /
    • v.3 no.1
    • /
    • pp.3-24
    • /
    • 1996
  • Databases are critical to business information systems, and RDBMS is most widely used for the database system. Normalization has been designed to control various anomalies(insert, update, and delete anomalies). However, normalized database design does not account for the tradeoffs necessary for the performance. In this research, we develop a model for database design by denormalization of duplicating attributes in order to reduce frequent join processes. In this mood, we consider insert, update, delete, and query costs. The anomaly and data inconsistency are removed by additional disk I/O which is necessary for each update and insert transaction. We propose a branch and bound method for this model, and show considerable cost reduction.

  • PDF

Design and Application of Database System for Dynamic Balancing Test of Helicopter Main Rotor Blade (헬리콥터 주로터 블레이드의 동적밸런싱 시험에 대한 데이터베이스 설계 및 적용)

  • Yoon, Byung-Il;Paek, Seung-Kil;Song, Keun-Woong;Kim, Deog-Kwan
    • Journal of the Korean Society for Aeronautical & Space Sciences
    • /
    • v.47 no.8
    • /
    • pp.582-589
    • /
    • 2019
  • The dynamic balancing test of helicopter main rotor blades is a blade rotation test conducted on the ground to make the track of each blade and the load on each pitch rod to a similar level before the flight tests. The purpose of the test is to reduce the vibration occurring on main rotor system as a result of dissimilarity of each blade. The RTB test has been performed for a long period at Whirl Tower Test Facility located in Goheung Flight Centre, accumulating its data. As the amount of the results has become increasingly enormous the needs for the development of database system has been raised to manage the data with effective method. This research aimed to describe the development of Dynamic-Balancing Database System for the RTB test results. For the design of the database system the informations of RTB test results have been categorized into properties, connecting each others according to its logical meaning, and comprised into a database system with relational elements. It has been shown in this paper that the Dynamic Balancing database system enables to effectively accumulate the RTB test data and to be utilized for the data analysis.

A Product Information system for Semantic Web (시맨틱 웹 환경을 위한 상품 정보 시스템)

  • Gong, Gi-Hyun;Lee, Dong-Joo;Lee, Sang-Goo
    • Proceedings of the Korea Database Society Conference
    • /
    • 2008.05a
    • /
    • pp.413-419
    • /
    • 2008
  • Product information system contains information concerning products such as classification, attributes and UOM. Product information system stores their product information to a Relational Database. However, they do not support interoperability between product systems since their database is designed and optimized for their services. We suggest a standard product model and the scenarios of web services based on our model.

  • PDF

A Study on Drawing Management System and Database Model for Design and Constructing of Steel Plates (강판 설계 및 제작을 위한 도면관리 시스템 및 데이터베이스 모델 연구)

  • Shin, Yoon-Ho;Lee, June-Hwan;Shin, Ye-Ho
    • Journal of the Korea Computer Industry Society
    • /
    • v.10 no.1
    • /
    • pp.1-12
    • /
    • 2009
  • In this thesis, founded on those considerings, plan the formula of media data for the information of drawing for the production of steel plate by establishing the concept of relational data model, plan the surroundings for query for the interface of user, and introduce the process materialized actually in detail as use the management system of drawing.

  • PDF

Establishing Generic Soil Suitability Evaluation Model Using A Relational Database Geographical Information System (관계형 데이타베이스 토지정보체계를 이용한 포괄적인 토양적지 평가모델 수립)

  • Lee, Kyoo-seock
    • Korean Journal of Remote Sensing
    • /
    • v.7 no.1
    • /
    • pp.1-12
    • /
    • 1991
  • 토양의 특성은 토지이용에 제한을 가하는 물리적 요소로 활용되고 있으며, 이러한 토양 특성정보는 전통적으로 전문가에 의한 해석에 기초하여 토양도에 서류 형태로 저장, 보관되어 왔 다. 최근에 널리 쓰이기 시작하는 토지정보체계(Geographical Information System, GIS)는 종래의 자료저장, 해석기법을 digital database라는 특성을 이용하여, 새로운 자료분석이 가능한 도구를 제공하게 되었다. 본 연구에서는 위상적으로 체계화된(topologically structured) vector형 토지정 보체계의 관계형 Database Management System(DBMS)과 토양 전문가의 지식을 결합하여 포괄 적인 토양적지 평가모델을 수립한 후, 전문가에 의한 평가, 토양도에 수록된 평가와 각각 비교하 였다. 비교한 결과, 본 연구에서 수립된 토양적지 평가모델은 전문가에 의한 평가와 크게 다르지 않았으며, 이는 토양도의 평가와 비교하여서도 마찬가지였다. 따라서, 본 연구에서 시도된 포괄적 인 토양적지 분석모델은 계속 발전하여 토지정보체계에서의 전문가 기법으로 활용이 가능하다고 판단되어진다.

Modeling Components for mapping from XML DTD to RDB schema (XML DTD의 관계형 데이터베이스 스키마로의 자동변환을 위한 컴포넌트 모델링)

  • 이정수;방승윤;주경수
    • Journal of Internet Computing and Services
    • /
    • v.2 no.5
    • /
    • pp.81-91
    • /
    • 2001
  • XML is a standard markup language for exchange and storage of formed or well-formed information in World Wide Web, Because the source data of XML message for exchange of information in World Woo Web Is stored in legacy database systems. it is necessary the easier connection between XML application and database systems, In Oracle8i. 9i. informix and SQL2000. DBMS vendors extend their DBMSs for XML. This approach for the connection between XML application and database system is Platform-dependent and DBMS-dependent. Therefore it is necessary the platform- and DBMS-independent approach for the connection between XML application and database system, In this paper. we modeled a set of middleware components for relational database design based on XML DTD is modeled, Those components are modeled on object-based algorithm for connection between XML application and database system.

  • PDF

Development of Integrated Application System using Technical Information of Agriculture based on Relational Database Management System (관계형 데이터베이스를 이용한 농업기술정보 업무처리 시스템의 개발)

  • 신일섭;이대희;이정재
    • Proceedings of the Korean Society of Agricultural Engineers Conference
    • /
    • 1999.10c
    • /
    • pp.381-386
    • /
    • 1999
  • In this study , the system was developed for design procecure of agriultural engineering. For development of the system, design reports of Rural Development Corporation were analyzed, the components using in system were searched, and the user interface was developed. It was found that the development of this system would be used for design procedure using design information based on RDBMS.

  • PDF

Comparative Evaluation of Data Processing Performance between MySQL and Redis (MySQL과 Redis의 데이터 처리 성능 비교 평가)

  • Hyeok Bang;Seo-Hyeon Kim;Sanghoon Jeon
    • Journal of Internet Computing and Services
    • /
    • v.25 no.3
    • /
    • pp.35-41
    • /
    • 2024
  • As online activities have rapidly increased due to recent digital changes and the impact of COVID-19, the importance of large-scale data processing and maintenance is increasing. This study compares the performance of the two main types of databases widely used for data storage and management: Relational Database Management Systems (RDBMS) and Non-Relational Databases (NoSQL). Specifically, we measured and evaluated the execution time of data insertion, query, and deletion functions using MySQL, a representative example of RDBMS, and Redis, a representative example of NoSQL. The experimental results showed that Redis showed performance about 5.84 times faster in data insertion, 6.61 times faster in query, and 12.33 times faster in deletion than MySQL. These results demonstrate that Redis provides superior performance, especially in environments requiring large-scale data processing and maintenance. Therefore, companies and online service providers can choose NoSQL databases such as Redis to ensure more efficient data management solutions. We hope this study will be an essential reference when selecting a database based on data processing performance.

Improving Database System Performance by Applying NoSQL

  • Choi, Yong-Lak;Jeon, Woo-Seong;Yoon, Seok-Hwan
    • Journal of Information Processing Systems
    • /
    • v.10 no.3
    • /
    • pp.355-364
    • /
    • 2014
  • Internet accessibility has been growing due to the diffusion of smartphones in today's society. Therefore, people can generate data anywhere and are confronted with the challenge that they should process a large amount of data. Since the appearance of relational database management system (RDBMS), most of the recent information systems are built by utilizing it. RDBMS uses foreign-keys to avoid data duplication. The transactions in the database use attributes, such as atomicity, consistency, isolation, durability (ACID), which ensures that data integrity and processing results are stably managed. The characteristic of RDBMS is that there is high data reliability. However, this results in performance degradation. Meanwhile, from among these information systems, some systems only require high-performance rather than high reliability. In this case, if we only consider performance, the use of NoSQL provides many advantages. It is possible to reduce the maintenance cost of the information system that continues to increase in the use of open source software based NoSQL. And has a huge advantage that is easy to use NoSQL. Therefore, in this study, we prove that the leverage of NoSQL will ensure high performance than RDBMS by applying NoSQL to database systems that implement RDBMS.