• Title/Summary/Keyword: Database Design Automation

Search Result 62, Processing Time 0.026 seconds

Development of DSI(Delivery Sequence Information) Database Prototype (순로정보 데이터베이스 프로토타입 개발)

  • Kim, Yong-Sik;Lee, Hong-Chul;Kang, Jung-Yun;Nam, Yoon-Seok
    • IE interfaces
    • /
    • v.14 no.3
    • /
    • pp.247-254
    • /
    • 2001
  • As current postal automation is limited to dispatch and arrival sorting, delivery sequence sorting is performed manually by each postman. It not only acts as a bottleneck process in the overall mailing process but is expensive operation. To cope with this problem effectively, delivery sequence sorting automation is required. The important components of delivery sequence sorting automation system are sequence sorter and Hangul OCR which function is to extract the address of delivery point. DSI database will be interfaced to both Hangul OCR and sequence sorter for finding the accurate delivery sequence number and stacker number. The objectives of this research are to develop DSI(Delivery Sequence Information) database prototype and client application for managing information effectively. For database requirements collection and analysis, we draw all possible sorting plans, and apply the AHP(Analytic Hierarchy Process) method to determine the optimal one. And then, we design DSI database schema based on the optimal one and implement it using Oracle RDBMS. In addition, as address information in DIS database consist of hierarchical structure which has its correspondence sequence number, so it is important to reorganize sequence information accurately when address information is inserted, deleted or updated. To increase delivery accuracy, we reflect this point in writing application.

  • PDF

Design of Integrated Database Program for Optimal Operation of Distribution Automation System (배전지능화시스템 최적 운영을 위한 통합 데이터베이스 프로그램 설계)

  • Choi, Yun-Hyuk;Jang, Moon-Jong
    • The Transactions of The Korean Institute of Electrical Engineers
    • /
    • v.67 no.8
    • /
    • pp.987-993
    • /
    • 2018
  • In the existing distribution automation system, the database is managed by each distribution office. But there is a high possibility to happened a problem during a fault processing because the representation of the connection switches between distribution offices are complicated. In addition, if a distribution office will be going to collapse due to disaster, for example, a big fire or earthquake, its own database may be lost. In order to solve this problem, it is necessary to have a structure of an integrated database management from an integration center to under the distribution office. To do this, the integration center must store and manage it as the database using the own office code.

An Automated Design System for Ball-joint Parts of Automobiles (솔리드 모델러 기반의 볼 조인트 부품설계 자동화 시스템)

  • Kang, Jae-Gwan;Lee, Gwang-Il
    • IE interfaces
    • /
    • v.16 no.spc
    • /
    • pp.138-143
    • /
    • 2003
  • In this paper, an automated design system for ball-joint parts based on 3-D solid modeler is developed. Parametric modeling and API provided by 3-D solid modeler is engaged to develope the system which consists of four main modules such as : 3-D part modeling, parts assembling, 2-D drafting, and database interfacing modules. The automated design system is implemented on a computer, and shows us that it shorten the design processing time which have taken over 5 hours to only few minutes.

Development of Automation System of Water-Hydraulic and Leakage Test for Pressure Vessel (압력용기 수압 및 기밀시험 자동화 시스템 개발)

  • 이원희;김동수;이승현;김광영
    • Proceedings of the Korean Society of Precision Engineering Conference
    • /
    • 2003.06a
    • /
    • pp.1672-1675
    • /
    • 2003
  • In this study, we developed full automation test system for pressure vessel. This pressure vessel containing oxygen, nitrogen and carbon is widely used in industrial field. The test items of pressure vessel are divided into three branches which is weight measurement, water-hydraulic, and leakage test. After leakage test is completed, cleaning and dry progress is carried out. And control system is consist of three controller which is PLC, monitoring system and database system. PLC is control all of system. Monitoring system measures weight, pressure, flow etc and display to all conditions. Database system stores tested data. we design system to control all test modules in communication by a second period with three control modules. Finally, we verified this system by field test.

  • PDF

Distribution Network Switching Automation Using Active Web Based Management

  • Choi, Sang-Yule
    • Journal of the Korean Institute of Illuminating and Electrical Installation Engineers
    • /
    • v.21 no.9
    • /
    • pp.81-86
    • /
    • 2007
  • Electric utility companies have the responsibility of providing good electricity for their customers. They have introduced the DAS(Distribution Automation System) to automate the power distribution networks. DAS engineers require state-of-the-art applications, such as a way to actively manage the distribution system and gain economic benefits from a flexible DAS architectural design. The existing DAS is not capable of handling these needs. It requires operator intervention whenever feeder overloading is detected while operator error could cause the feeder overload area to be extended. It also utilizes a closed architecture and it is therefore difficult to meet the system migration and future enhancement requirements. This paper represents a web based, platform-independent, flexible DAS architectural design and active database application. Recent advanced Internet technologies are fully utilized in this new DAS architecture allowing it to meet the system migration and future enhancement requirements. By using an active database, the DAS can minimize the feeder overloading area in the distribution system without operator intervention, thereby minimizing mistakes due to operator error.

A Construction of Database System for Automation of Project Quantity Survey (공사물량 산출의 자동화를 위한 데이터베이스시스템 구성)

  • Lee, Min-Nam;Lee, Sang-Burm
    • The Transactions of the Korea Information Processing Society
    • /
    • v.2 no.2
    • /
    • pp.137-147
    • /
    • 1995
  • In the construction project, the design and the construction have been divided strictly. Because the design files of CAD library cannot be used directly in project quantity survey, we depend on manual handling.. It's because there has no interface between the system of the design and that of the construction. In this paper, by using the sizes and quantites of project design, we construct database model for automation of project quantity survey, and analyze the interface among the structure design files stored in design library of CAD system and the information of quantity survey, build a system which can survey the project quantity efficiently and evalulate the performance of this system.

  • PDF

Design of Grinding Datab ase Based on the Frame Model (후레임 모델에의한 연삭가공용 데이터베이스의 설계)

  • 김건희
    • Proceedings of the Korean Society of Machine Tool Engineers Conference
    • /
    • 1997.04a
    • /
    • pp.102-106
    • /
    • 1997
  • Grinding has difficulty in satisfying the qualitative knowledge based on the skilled expert as well as quantitative data for all user. Design of grinding database is based on the frame-based model for utilizing the empirical and qualitative knowledge. Inthis paper, basic strategy to develop the grinding database by frame-based model, which is strongly dependent upon experience and intuition, frame-base model, which is strongly dependent upon experience and intuition, is described. Design of grinding database is based on the frame-based model for utilizing the ambiguous knowledge and inference is accomplised by the object-oriented paradigm system.

  • PDF

Design of Postal Address File for Address Interpretation and Retrieval (주소해석 및 검색을 위한 우편주소파일 설계)

  • Chang, Tai-Woo;Kim, Ho-Yon;Lim, Kil-Taek
    • Journal of Korea Society of Industrial Information Systems
    • /
    • v.12 no.4
    • /
    • pp.74-88
    • /
    • 2007
  • In order to automate the process of mail sorting by delivery sequence, it is necessary to prepare a postal address database and to interpret written addresses on the mail-pieces with the database and OCR technology. The address database is a critical factor of automation and informatization of postal service since it could be used not only in address recognition but also in various mail processing. In this study, we design the schema of postal address database, design the postal address file based on it and explain the method of address interpretation and retrieval using it. We analyze infonnation requirements for transformation of postal address into the standardized format and consider them in the process of design. The postal address file can be used by address matching or retrieval system as well as by Hangul address recognition system for automation of delivery sequence mail-sorting.

  • PDF

Design of Grinding Database by Taking Frame-Based Model (후레임 모델에 의한 연삭가공용 데이터 베이스의 설계)

  • 김건희
    • Journal of the Korean Society for Precision Engineering
    • /
    • v.15 no.2
    • /
    • pp.107-113
    • /
    • 1998
  • Grinding operation has difficulty in satisfying the qualitative knowledge based on the skilful expert as well as the quantitative data for all user. Design of grinding database based on the frame-based model is more effective method for utilizing the empirical and qualitative knowledge. In this paper. basic strategy to develop the grinding database by taking frame-based model, which is strongly dependent upon experience and intuition, is described. Grinding database based on the frame based model for designing the interaction and inference among the slots is accomplised by the object-oriented paradigm system.

  • PDF

Automation Review of Road Design Standard using Visual Programming (비주얼 프로그래밍 기법을 활용한 도로설계기준 자동검토 방안)

  • Hyoun-seok Moon;Hyeoun-seung Kim
    • Journal of the Society of Disaster Information
    • /
    • v.18 no.4
    • /
    • pp.891-898
    • /
    • 2022
  • Purpose: There is not much time left for mandatory BIM implementation for all sectors and stages of the construction industry. Therefore, it is necessary to find a way to secure technology to substantially improve the productivity of BIM work. In the research, we proposed a method to automatically verify related construction standards for major objects produced by BIM modeling procedures so that engineers can verify construction standards in the BIM-based design process. Method: We defined a modeling work procedure for BIM-based road design work and prepared a method for constructing related design standards in a database. In addition, a process map for developing a BIM-based design basis review automation system was also presented. Result: A BIM-based design standard review automation module was developed using Civil3D and Dynamo. And it was confirmed by the test application that it is possible to quickly judge whether the BIM object manufactured in the design process conforms to the construction design standard. Conclusion: BIM-based design standard review automation technology can improve the productivity of BIM model production work and secure the quality of the BIM model.