• Title/Summary/Keyword: automated relational database

Search Result 8, Processing Time 0.021 seconds

Mining Information in Automated Relational Databases for Improving Reliability in Forest Products Manufacturing

  • Young, Timothy M.;Guess, Frank M.
    • International Journal of Reliability and Applications
    • /
    • v.3 no.4
    • /
    • pp.155-164
    • /
    • 2002
  • This paper focuses on how modem data mining can be integrated with real-time relational databases and commercial data warehouses to improve reliability in real-time. An important Issue for many manufacturers is the development of relational databases that link key product attributes with real-time process parameters. Helpful data for key product attributes in manufacturing may be derived from destructive reliability testing. Destructive samples are taken at periodic time intervals during manufacturing, which might create a long time-gap between key product attributes and real-time process data. A case study is briefly summarized for the medium density fiberboard (MDF) industry. MDF is a wood composite that is used extensively by the home building and furniture manufacturing industries around the world. The cost of unacceptable MDF was as large as 5% to 10% of total manufacturing costs. Prevention can result In millions of US dollars saved by using better Information systems.

  • PDF

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.

An Approach to Automatic Generation of Fourth Normal Form for Relational Database

  • Park, Sung-Joo;Lee, Young-Gun;Cho, Hyung-Rae
    • Journal of the Korean Operations Research and Management Science Society
    • /
    • v.13 no.1
    • /
    • pp.51-64
    • /
    • 1988
  • A new approach to the logical design of 4NF database shceme, which can be easily automated, is proposed. The main features of the approach are : introduction of a single attribute right hand side, extension of the concept of independent relations, semantic analysis, and adaoption of dependency matrix. The underlying viewpoints of functional relationships of the approach are different from Fagin's in that we distinguish functional and multivalued dependency in terms of cardinality. An algorithm for automatic generation of fourth normal form is presented and implemented.

  • PDF

IMPLEMENTATION OF A DECISION SUPPORT SYSTEM FOR INTEGRATED RIVER BASIN WATER MANAGEMENT IN KOREA

  • Shim Soon-Do;Shim Kyu-Cheoul
    • Water Engineering Research
    • /
    • v.5 no.4
    • /
    • pp.157-176
    • /
    • 2004
  • This research presents a prototype development and implementation of Decision Support System (DSS) for integrated river basin water management for the flood control. The DSS consists of Relational Database Management System, Hydrologic Data Monitoring System, Spatial Analysis Module, Spatial and Temporal Analysis for Rainfall Event Tool, Flood Forecasting Module, Real-Time Operation of Multi Reservoir System, and Dialog Module with Graphical User Interface and Graphic Display Systems. The developed DSS provides an automated process of alternative evaluation and selection within a flexible, fully integrated, interactive, centered relational database management system in a user-friendly computer environment. The river basin decision-maker for the flood control should expect that she or he could manage the flood events more effectively by fully grasping the hydrologic situation throughout the basin.

  • PDF

A Logical Design Methodology for Relational Databases Using the MAO (Multiple Aspects-based Object) Model (MAO 모델을 사용한 관계 데이타베이스의 논리적 설계방법론)

  • Cho, Dong-Young;Baik, Doo-Kwon;Hwang, Chong-Sun
    • Journal of the Korean Operations Research and Management Science Society
    • /
    • v.16 no.2
    • /
    • pp.49-64
    • /
    • 1991
  • In this paper, we present a stepwise design methodology for relational databases using a new conceptual data model, the MAO(Multiple Aspects-based Object) model. Our methodology consists two steps : first, data requirements are conceptualized using the MAO model with concepts such as objects types and aspect types : second, the MAO model is transformed into the third normal form inn the relational model supported by commercial DBMs. A top-down approach is used for the MAO modelling in the first, step, and the transformation process in the second step can be automated. Our methodology supports easier and more database design of real world than other methodologies using existing data models.

  • PDF

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

A Study on the Construction of Database contains Knowledge for the Structural Design using the Natural Language Processing (자연어처리를 이용한 구조물 설계지식정보 데이터베이스 구축에 관한연구)

  • 이민호;이정재;김한중;윤성수
    • Proceedings of the Korean Society of Agricultural Engineers Conference
    • /
    • 1999.10c
    • /
    • pp.245-251
    • /
    • 1999
  • In this study, by using the natural language processing of the field artificial intelligence, automated index was performed . And then, the Natural Language Processor for Constructing Database (NALPDB) has been developed. Furthermore, the Design knowldege Information Relational DataBase (DIREDB) has been also developed, which is designed to interlock the knowledge base. DIREDB processes both the documented design-data , like a concrete standard specification, and the design knowledge frrom an expert. DIREDB is also simulates the design space of structures accordance with the production rule, and thus it is determined that DIREDB can be used as a engine to retrieve new knowledge and to implement knowldege base that is necessary to the development of automatic design system.

  • PDF

Development of Virtual Simulator and Database for Deep Learning-based Object Detection (딥러닝 기반 장애물 인식을 위한 가상환경 및 데이터베이스 구축)

  • Lee, JaeIn;Gwak, Gisung;Kim, KyongSu;Kang, WonYul;Shin, DaeYoung;Hwang, Sung-Ho
    • Journal of Drive and Control
    • /
    • v.18 no.4
    • /
    • pp.9-18
    • /
    • 2021
  • This study proposes a method for creating learning datasets to recognize obstacles using deep learning algorithms in automated construction machinery or an autonomous vehicle. Recently, many researchers and engineers have developed various recognition algorithms based on deep learning following an increase in computing power. In particular, the image classification technology and image segmentation technology represent deep learning recognition algorithms. They are used to identify obstacles that interfere with the driving situation of an autonomous vehicle. Therefore, various organizations and companies have started distributing open datasets, but there is a remote possibility that they will perfectly match the user's desired environment. In this study, we created an interface of the virtual simulator such that users can easily create their desired training dataset. In addition, the customized dataset was further advanced by using the RDBMS system, and the recognition rate was improved.