• Title/Summary/Keyword: DB Design

Search Result 842, Processing Time 0.028 seconds

A Scheduling System based on DBMS for Shipbuilding (DATABASE 기반의 조선업 일정계획 시스템 구축)

  • Lee, Dong-Uk;Kim, Shun-Kyum;Lee, Ho-Yoon;Park, Sung-Kyu;Lee, Dae-Hyeong;Wang, Gi-Nam
    • Korean Journal of Computational Design and Engineering
    • /
    • v.17 no.1
    • /
    • pp.26-34
    • /
    • 2012
  • Assembly scheduling in shipbuilding is responsible for determine assembly process orders and departmental production schedule for the block, the basic composite unit of ships. It is necessary much more information to decide production scheduling as the characteristic of shipbuilding which has been more complex and more various and also, a lot of waste of time and of human power is generated in the course of data processing. The target shipbuilding manufacturer of this study use empirical techniques, based on the user's discretion, to compile and to apply data which are scattered in DB storages separately. Because of that reason, the user should not only be performed identification and screening operations but also modification and verification for vast amounts of data, so it is hard to keep the consistency of the data and also the operation time is not constant. Accordingly, the object in this study is by presenting an efficient DB framework to reduce wasting time and man-hour at experienced-oriented process, abate user's manual operations and support an efficient scheduling in assembly processes.

Design of User Interface on Decommissioning DB (연구로 해체 DB User Interface 설계)

  • 박희성;정관성;이근우;백삼태;이규일;박진호
    • Proceedings of the Korean Radioactive Waste Society Conference
    • /
    • 2003.11a
    • /
    • pp.681-686
    • /
    • 2003
  • It has been designed GUI(graphic user interface) to consult the convenience of a input data and the flexibility that can be retrieved dismantling information relation to decommissioning DB of KRR1&2. The GUI can proceed an input materials and a search and output of a saved data in server based on a facility code and also have a function of explorer which can find the lower dismantling objects in each facilities. It has added the structure of the multimedia that could be showed a series of dismantling activities with a Mpeg and pictures into the GUI. In the future work, Decommissioning DB and User Interface are intend to contribute a functions that could be evaluate and analyze for a dismantling activities with a engineering theory.

  • PDF

On the Construction of Requirements DB to Improve the Work Environment of Locomotive Cabs (철도차량 운전실의 작업환경 개선을 위한 요구사항 DB 구축에 관한 연구)

  • Sim, Sang-Hyun;Lee, Jae-Chon;Park, Chan-Woo
    • Journal of the Korea Safety Management & Science
    • /
    • v.13 no.4
    • /
    • pp.71-79
    • /
    • 2011
  • The work environment of locomotive cabs has long been an important issue in the design of railload systems since it is quite critical in terms of system's operational safety. It is getting more attention as the running speed of the trains goes up these days. To this end, this paper describes how to systematically construct a DB for the requirements set in the course of the improvement process for the aforementioned cab work environment. As a solution approach, we have adopted the requirement architecture concept to cover the whole activities required to do such as in requirements generation, DB construction, change management, and traceability management. Specifically, based on the requirement architecture framework a requirement process to collect requirements for improvement is discussed, and the guide lines are suggested for verification and validation of the developed requirements. In addition, a base schema and requirements templates are developed, which will be used in generating requirements and constructing a DB. Finally, it is demonstrated how the requirements DB for locomotive cabs can be constructed using a computer-aided tool in an integrated fashion.

A Prototype of the Map Viewer based Spatial DB for the Integrated Urban Flooded Area Management System (도시침수 통합관리 시스템 구축을 위한 공간DB기반 Map Viewer 프로토타입 설계)

  • Kim, Ki-Uk;Seo, Tae-Woong;Kim, Chang-Soo
    • 한국방재학회:학술대회논문집
    • /
    • 2008.02a
    • /
    • pp.339-342
    • /
    • 2008
  • Recently the life and property damage caused by urban inundation have increased. In order to prevent the damage by inundation the researches for displaying the flooded areas through integrating SWMM and GIS have been progressed. However most of flood analysis systems only have used the GIS to display the flooded areas, and don't provide the integration disaster information to prevent the inundation. In this paper, we design a prototype for the Map Viewer based Spatial DB for the integrated urban floooded area management system. And we implement the spatial DB conversion module.

  • PDF

Design and Implementation of Sensor Information Management System based on Celery-MongoDB (Celery-MongoDB 를 활용한 센서정보 관리시스템 설계 및 구현)

  • Kang, Yun-Hee
    • Journal of Platform Technology
    • /
    • v.9 no.2
    • /
    • pp.3-9
    • /
    • 2021
  • The management of sensor information requires the functions for registering, modifying and deleting rapidly sensor information about various many sensors. In this research, Celery and MongoDB are used for developing a sensory data management system. Celery supplies a queue structure based on asynchronous communication in Python. Celery is a distributed simple job-queue but reliable distributed system suitable for processing large message. MongoDB is a NoSQL database that is capable of managing various informal information. In this experiment, we have checked that variety of sensor information can be processed with this system in a IoT environment. To improve the performance for handling a message with sensory data, this system will be deployed in the edge of a cloud infrastructure.

A COMPARATIVE STUDY ON BLOCKCHAIN DATA MANAGEMENT SYSTEMS: BIGCHAINDB VS FALCONDB

  • Abrar Alotaibi;Sarah Alissa;Salahadin Mohammed
    • International Journal of Computer Science & Network Security
    • /
    • v.23 no.5
    • /
    • pp.128-134
    • /
    • 2023
  • The widespread usage of blockchain technology in cryptocurrencies has led to the adoption of the blockchain concept in data storage management systems for secure and effective data storage and management. Several innovative studies have proposed solutions that integrate blockchain with distributed databases. In this article, we review current blockchain databases, then focus on two well-known blockchain databases-BigchainDB and FalconDB-to illustrate their architecture and design aspects in more detail. BigchainDB is a distributed database that integrates blockchain properties to enhance immutability and decentralization as well as a high transaction rate, low latency, and accurate queries. Its architecture consists of three layers: the transaction layer, consensus layer, and data model layer. FalconDB, on the other hand, is a shared database that allows multiple clients to collaborate on the database securely and efficiently, even if they have limited resources. It has two layers: the authentication layer and the consensus layer, which are used with client requests and results. Finally, a comparison is made between the two blockchain databases, revealing that they share some characteristics such as immutability, low latency, permission, horizontal scalability, decentralization, and the same consensus protocol. However, they vary in terms of database type, concurrency mechanism, replication model, cost, and the usage of smart contracts.

Design & Implementation of Extractor for Design Sequence of DB tables using Data Flow Diagrams (자료흐름도를 사용한 테이블 설계순서 추출기의 설계 및 구현)

  • Lim, Eun-Ki
    • Journal of Korea Society of Industrial Information Systems
    • /
    • v.17 no.3
    • /
    • pp.43-49
    • /
    • 2012
  • Information obtained from DFD(Data Flow Diagram) are very important in system maintenance, because most legacy systems are analyzed using DFD in structured analysis. In our thesis, we design and implement an extractor for design sequence of database tables using DFD. Our extractor gets DFDs as input data, transform them into a directed graph, and extract design sequence of DB tables. We show practicality of our extractor by applying it to a s/w system in operation.

Traffic Data Calculation Solution for Moving Vehicles using Vision Tracking (Vision Tracking을 이용한 주행 차량의 교통정보 산출 기법)

  • Park, Young ki;Im, Sang il;Jo, Ik hyeon;Cha, Jae sang
    • The Journal of The Korea Institute of Intelligent Transport Systems
    • /
    • v.19 no.5
    • /
    • pp.97-105
    • /
    • 2020
  • Recently, for a smart city, there is a demand for a technology for acquiring traffic information using an intelligent road infrastructure and managing it. In the meantime, various technologies such as loop detectors, ultrasonic detectors, and image detectors have been used to analyze road traffic information but these have difficulty in collecting various informations, such as traffic density and length of a queue required for building a traffic information DB for moving vehicles. Therefore, in this paper, assuming a smart city built on the basis of a camera infrastructure such as intelligent CCTV on the road, a solution for calculating the traffic DB of moving vehicles using Vision Tracking of road CCTV cameras is presented. Simulation and verification of basic performance were conducted and solution can be usefully utilized in related fields as a new intelligent traffic DB calculation solution that reflects the environment of road-mounted CCTV cameras and moving vehicles in a variable smart city road environment. It is expected to be there.

A Study on the Customers Emotional DB and Interface Design for Sports Shoes (스포츠화에 대한 소비자의 감성 DB 및 Interface 구축에 관한 연구)

  • 윤훈용;임기용
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.25 no.3
    • /
    • pp.34-40
    • /
    • 2002
  • In the past, the important factors of buying the sports shoes for the customers were price and comfort. However these days, the sports shoes are considered as a part of fashion and may not satisfy the customers because their emotional preference have not been properly considered in design phase. The customers' desire and expectation for unique design are growing. Thus, the development of sports shoes not only considering the anthropometric foot characteristics but also satisfying the customers emotional preference is needed. In this study, the basic data on the customer's emotional preference to the design of sports shoes were obtained using human sensibility ergonomics approach and formed a data base. Also, we developed ail interface that can be used for the customers to select the emotionally preferred sports shoes.