• Title/Summary/Keyword: Relational Database Management System

Search Result 185, Processing Time 0.029 seconds

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.

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.

Development of Hydrologic Data Management System Based on Relational Database (관계형 데이터베이스를 이용한 수문자료 관리시스템 개발)

  • Kim, Hak-Kwan;Park, Seung-Woo;Kim, Sang-Min
    • Journal of Korea Water Resources Association
    • /
    • v.39 no.10 s.171
    • /
    • pp.855-866
    • /
    • 2006
  • In this paper, the Hydrologic Data Management System (HDMS) was developed for the efficient management of hydrologic data. The applicability of the system was demonstrated using the hydrologic data of study watershed located in the southwest from Suwon city MySQL 5.0, relational database management system, and MS Visual Basic 6.0 were used for the development of MS windows based HDMS. The primary components of the HDMS are data search system, data management system, and data analysis system. Data search and management systems provide basic functions for the efficient data search, storage, update and export. Data analysis system enables the users to get the further and diverse hydrologic statistical information from the stored data. Furthermore, the accuracy and quality of hydrologic data was analyzed and evaluated through data analysis system.

SQL Tuning Techniques to Improve the Performance of Integrated Information Systems (정보시스템 성능 향상을 위한 SQL 튜닝 기법)

  • Kim, Yang-Jin;Joo, Bok-Gyu
    • The Journal of the Institute of Internet, Broadcasting and Communication
    • /
    • v.10 no.3
    • /
    • pp.27-33
    • /
    • 2010
  • One of the most critical success factor in introducing and operating an integrated information system is the performance management. In this study, we propose some SQL tuning techniques, applicable to optimize the performance of relational database systems. We showed effectiveness of the techniques by applying to a database system of a medium scale company.

Development of Integrated Design Methodology for Relational Database Application -Focusing on Object-Oriented Analysis and Design Methodology- (관계형 데이터베이스 응용시스템을 위한 통합 설계방법론 개발 -객체지향 분석.설계 방법론을 중심으로-)

  • Joo, Kyung-Soo;Jho, Do-Hyung
    • Journal of the Korea Society of Computer and Information
    • /
    • v.16 no.11
    • /
    • pp.25-34
    • /
    • 2011
  • In this paper we present an integrated design methodology for relational database based on object-oriented analysis and design. The integrated design methodology is based on business profile and has six phases. In the first phase, business use cases are identified and described by macroactivity diagrams and then the macroactivity diagrams are transformed to detailed business activity diagrams by using objects, object flows and business worker's responsibilities. In the third phase, the detailed business activity diagrams are transformed to business class diagrams that describe the static structure of the entire business system based on detailed business activity diagrams. In the four phase, the business class diagrams are transformed to class diagrams that represent the initial conceptual model of the target relational database. In the five phase, we add additional transformations on the class diagrams with generalization and specialization of associations, roles, activities, additional classes and redundant associations. Eventually, the final class diagrams are transformed to relational database schema. The methodology presented in this paper by applying that proposal for organic connection between object-oriented analysis and design methodology and relational database design methodology. And it will be able to deal with integration management. By the integrated design methodology, we can make more easily software systems based on relational database. In the case study, proposal integrated design methodology applied for a visa issuing system.

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

The design of Decision Support System for mid-and long-range investment planning (중장기 투자계획을 위한 의사결정지원 시스템의 설계)

  • 서의호;김원태;서창교;이석우
    • Korean Management Science Review
    • /
    • v.9 no.1
    • /
    • pp.53-65
    • /
    • 1992
  • Decision Support System(DSS) is an advanced information system concept prevailing since 1980s. It supports managers' decision making activities by providing not only information but decision alternatives. It essentially consists of the components of database, modelbase and dialogue systems. With the development of its databases, POSCO needs a number of modelbases in establishing DSSs in various areas such as production planning and investment. This research particularly focuses on establishment of a mid-and long-range investment DSS and investigates the necessity and the problems of an investment DSS and the decision criteria for investment priority. We (1) propose a modelbase which uses the concepts of Analytic Hierarchy Process(AHP) and Zero-Base Budgeting(ZBB), along with an appropriate scoring method, database and dialogue system to support the investment manager in evaluating investment proposals ; (2) implement the system using relational database management system ; and (3) discuss the results of implementing the investment DSS.

  • PDF

GOMS: Large-scale ontology management system using graph databases

  • Lee, Chun-Hee;Kang, Dong-oh
    • ETRI Journal
    • /
    • v.44 no.5
    • /
    • pp.780-793
    • /
    • 2022
  • Large-scale ontology management is one of the main issues when using ontology data practically. Although many approaches have been proposed in relational database management systems (RDBMSs) or object-oriented DBMSs (OODBMSs) to develop large-scale ontology management systems, they have several limitations because ontology data structures are intrinsically different from traditional data structures in RDBMSs or OODBMSs. In addition, users have difficulty using ontology data because many terminologies (ontology nodes) in large-scale ontology data match with a given string keyword. Therefore, in this study, we propose a (graph database-based ontology management system (GOMS) to efficiently manage large-scale ontology data. GOMS uses a graph DBMS and provides new query templates to help users find key concepts or instances. Furthermore, to run queries with multiple joins and path conditions efficiently, we propose GOMS encoding as a filtering tool and develop hash-based join processing algorithms in the graph DBMS. Finally, we experimentally show that GOMS can process various types of queries efficiently.

The method of using database technology to process rules of Rule-Based System

  • Zheng, Baowei;Yeo, Jeong-Mo
    • Journal of information and communication convergence engineering
    • /
    • v.8 no.1
    • /
    • pp.89-94
    • /
    • 2010
  • The most important of rule-base system is the knowledge base that determines the power of rule-base system. The important form of this knowledge is how to descript kinds of rules. The Rule-Base System (RBS) has been using in many field that need reflect quickly change of business rules in management system. As far, when develop the Rule-Based System, we must make a rule engine with a general language. There are three disadvantage of in this developed method. First, while there are many data that must be processed in the system, the speed of processing data will become very slow so that we cannot accept it. Second, we cannot change the current system to make it adaptive to changes of business rules as quickly as possible. Third, large data make the rule engine become very complex. Therefore, in this paper, we propose the two important methods of raising efficiency of Rule-Base System. The first method refers to using the Relational database technology to process the rules of the Rule-Base System, the second method refers to a algorithm of according to Quine McCluskey formula compress the rows of rule table. Because the expressive languages of rule are still remaining many problems, we will introduce a new expressive language, which is Rule-Base Data Model short as RBDM in this paper.

Design and Implemetation of an Object-Relational Geographic Information System based on a commercial ORDB (상용 ORDB를 하부구조로 갖는 객체관계형 지리정보 시스템의 설계 및 구현)

  • 윤지희
    • Spatial Information Research
    • /
    • v.5 no.1
    • /
    • pp.77-88
    • /
    • 1997
  • This paper presents the design and implementaion of an object-relational geographic information system. This system has been developed on top of a commercial object-relational database management system. It provides flexible spatial data model, spatial query language, visual user interface, and efficient spatial access methods(D0T) in which traditional primary-key access methods can be applied. We report on our design choices and describe the current status of Implementation. The conceptual model of the system is based on SDTS, and is mapped to the intemal obiect-oriented data model. Kevwords : object-oriented data model, GIS, spatial data model, spatial access method.

  • PDF