• Title/Summary/Keyword: Database Management Systems

Search Result 1,027, Processing Time 0.029 seconds

Development of Point of Production/Manufacturing Execution System to Manage Real-time Plant Floor Data (제품 실명제를 위한 POP/MES 시스템의 개발)

  • Gwon, Yeong-Do;Jo, Chung-Rae;Jeon, Hyeong-Deok
    • 연구논문집
    • /
    • s.27
    • /
    • pp.167-174
    • /
    • 1997
  • Point of Production/Manufacturing Execution Systems are an essential component of operations in today's competitive business environments, which require greater production efficiency and effectiveness. POP/MES focuses on the valuing-adding processes, helping to reduce manufacturing cycle time, improve product quality, reduce WIP, reduce or eliminate paperwork between shifts, reduce lead time and empowering plant operations staff. In this paper, we implement POP/MES to manage real-time plant floor data which is gathered by I/O server into database management system. I/O server is a software allows data exchange between factory real-time database and several hardware devices such as PLC, DCS, robot and sensor through ethernet TCP/IP protocol.

  • PDF

Development and Testing of Satellite Operation System for Korea Multipurpose Satellite-I

  • Mo, Hee-Sook;Lee, Ho-Jin;Lee, Seong-Pal
    • ETRI Journal
    • /
    • v.22 no.1
    • /
    • pp.1-11
    • /
    • 2000
  • The Satellite Operation System (SOS) has been developed for a low earth orbiting remote sensing satellite, Korea Multipurpose Satellite-I, to monitor and control the spacecraft as well as to perform the mission operation. SOS was designed to operate on UNIX in the HP workstations. In the design of SOS, flexibility, reliability, expandability and interoperability were the main objectives. In order to achieve these objectives, a CASE tool, a database management system, consultative committee for space data systems recommendation, and a real-time distributed processing middle-ware have been integrated into the system. A database driven structure was adopted as the baseline architecture for a generic machine-independent, mission specific database. Also a logical address based inter-process communication scheme was introduced for a distributed allocation of the network resources. Specifically, a hotstandby redundancy scheme was highlighted in the design seeking for higher system reliability and uninterrupted service required in a real-time fashion during the satellite passes. Through various tests, SOS had been verified its functional, performance, and inter-face requirements. Design, implementation, and testing of the SOS for KOMPSAT-I is presented in this paper.

  • PDF

Development of the System for Damage Assessment of Road Network after Seismic Excitation (지진 발생 후 도로망의 피해 산정을 위한 평가체계 개발)

  • Yi Jin-Hoon;Lee Hyeong-Cheol;Jeong Dong-Gyun;Lee Sang-Ho
    • Proceedings of the Computational Structural Engineering Institute Conference
    • /
    • 2006.04a
    • /
    • pp.216-221
    • /
    • 2006
  • This study provides a methodology for development of the Seismic Damage Evaluation System (SDES) in Korea. Major systems and status of database related to road networks in Korea are investigated to analyze the usability of the required information for developing the SDES. In this study, the SDES is composed of four components that are the road network component, the ground motion component, the fragile structure component, and the cost component. In addition, the procedures for the construction of database which support the SDES is proposed, and a prototype of the SDES for expressway of Korea is developed based on the developed methodology. The National Geospatial Information System (NGIS) and the National Earthquake Information System (NEIS) are used to develop the road network component and ground motion component, respectively. For the fragile structure component and the cost component, Highway Bridge Management System (HEMS) was used.

  • PDF

A Diagnosis Study on the Korea Transport Database for Stable Feasibility Analysis on Transportation Facilities (국가교통시설 안정적 타당성 평가를 위한 국가교통데이터베이스 관리체제 진단 연구)

  • Kim, Jin-Tae
    • International Journal of Highway Engineering
    • /
    • v.16 no.4
    • /
    • pp.97-110
    • /
    • 2014
  • PURPOSES: This study is to find the substantial shortcomings embedded in the government policies and practical administrative processes associated with the Korean Transportation Database (KTDB) and to propose preliminary approaches to overcome. METHODS: Administrative and socioeconomic issues on inefficiency in public and private investment and redemption was found from the literature review. Through the interview of sets of experts and practitioners, a set of faultiness embodied in the administrative procedure utilizing and managing KTDB was found and analyzed. RESULTS: This study found the erroneous administrative elements categorized into four groups: faulty socioeconomic data supporting local governors's optimistic will yielded overestimation of future traffic demand; faulty data incidentally introduced in KTDB burdened traffic demand analysis; unavoidable misuse of KTDB worsened the unstability of KTDB; and apathy to manage the KTDB data deviated systematic management. The proposed includes the alteration of the administrative and technical systems to overcome those shortcomings. CONCLUSIONS : Erroneous administrative elements associated with KTDB should be concerned prior to indicating subsequential faultiness in demand analysis.

Development of real-time database handling system for turning operation (선삭공정용 데이터베이스의 실시간 운용 시스템의 개발)

  • 이형국;이석희
    • 제어로봇시스템학회:학술대회논문집
    • /
    • 1990.10a
    • /
    • pp.170-174
    • /
    • 1990
  • The information with regard to the working range of lathe, cutting tool, cutting condition is managed as Database system for turning operation as one part of CAM system. Data with regard to the working range of lathe, cutting tool, cutting condition are stored by the DBMS(Data Base Management System) and can be added, modified, deleted and retrieved for realtime usages. Data stored in Database system are searched to select the most proper cutting tool and cutting condition with the input data fed from the design stage. Codes in regards to tool shape are displayed on graphic mode for easy selection for user and thus presents a good decision support for tool selection. The system developed in this work is operated by the pull down menu on the IBM PC/AT personal computer, or compatible series.

  • PDF

COLLABORATIVE PROCESS PLANNING AND FLOW ANALYSIS FOR AUTOMOTIVE ASSEMBLY SHOPS

  • Noh, S.D.;Kim, G.
    • International Journal of Automotive Technology
    • /
    • v.7 no.2
    • /
    • pp.217-226
    • /
    • 2006
  • To maintain competitiveness in the modern automotive market, it is important to carry out process planning concurrently with new car development processes. Process planners need to make decisions concurrently and collaboratively in order to reduce manufacturing preparation time for developing a new car. Automated generation of a simulation model by using the integrated process plan database can reduce time consumed for carrying out a simulation and allow a consistent model to be used throughout. In this research, we developed a web-based system for concurrent and collaborative process planning and flow analysis for an automotive general assembly using web, database, and simulation technology. A single integrated database is designed to automatically generate simulation models from process plans without having to rework the data. This system enables process planners to evaluate their decisions quickly, considering various factors, and easily share their opinions with others. By using this collaborative system, time and cost put into the assembly process planning can be reduced and the reliability of the process plan would be improved.

Internet Based for Computer Integration Manufacturing System

  • Suesut, T.;Hankarjonsook, C.;Tipsuwanporn, V.;Tammarugwattana, N.;Tirasesth, K.
    • 제어로봇시스템학회:학술대회논문집
    • /
    • 2003.10a
    • /
    • pp.260-263
    • /
    • 2003
  • This paper has developed the computer integration manufacturing system and Internet based tele-operations. The functions of CIMS include production planing, material requirement planning, work order generation, process control, quality control, shipping planning, warehouse and inventory management and material cost accounting.[1] In this paper focuses on the automatic warehouse control and inventory management by developing the information system as well as the Internet-based integration. The system overview is divided into three parts, the mechanical system, the computer and developed software to control and manage the information and the communication system. The mechanical system consists of the warehouse machine and forklift mobile robot controlled by programmable logic controller (PLC). The computer works on many functions such as control station interfaces with PLC, managing database and inventory, and Internet server to broadcast the inventory database to users via World Wide Web and monitoring the operation on web camera. Our scheme the inventory database can be checked easily anywhere and anytime when the users connect to the Internet. In this article, the lead-time and inventory level can be reduced therefore the holding cost and operating time is also decreased.

  • PDF

Development of Advanced Vehicle Tracking System Using the Uncertainty Processing of Past and Future Locations

  • Kim Dong Ho;Kim Jin Suk
    • Proceedings of the IEEK Conference
    • /
    • 2004.08c
    • /
    • pp.729-734
    • /
    • 2004
  • The e-Logistics means the virtual business activity and service architecture among the logistics companies based on the Internet technology. The management of vehicles' location in most conventional vehicle tracking system has some critical defects when it deals with data which are continuously changed. It means the conventional vehicle tracking system based on the conventional database is unable eventually to cope with the environment that should manage the frequently changed location of vehicles. The important things in the evaluation of the vehicle tracking system is to determine the threshold of cost of database ,update period and communication period between vehicles and the system. In other words, the difference between the reallocation of vehicle and the data in database can evaluate the overall performance of vehicle tracking systems. Most of the previous works considers only the information that is valid at the current time, and is hard to manage efficiently the past and future information. To overcome this problem, the efforts on moving objects management system(MOMS) and uncertainty processing have been started from a few years ago. In this paper, we propose an uncertainty processing model and system implementation of moving object that tracks the location of the vehicles. We adopted both linear-interpolation method and trigonometric function to chase up the location of vehicles for the past time as well as future time, respectively. We also explain the comprehensive examples of MOMS and uncertainty processing in parcel application that is one of major application of e-Logistics domain.

  • PDF

A Study on the Informatization Planning of Postal Address (우편주소 정보화 방안 수립에 관한 연구)

  • Chang, Tai-Woo;Jeong, Han-Il;Park, Chank-Won
    • IE interfaces
    • /
    • v.18 no.1
    • /
    • pp.104-116
    • /
    • 2005
  • In this paperm we provide a plan of construction, employment and management of the Korean postal address database and discuss the design of to-be models for it. For the purpose, we adopt and modify the information strategy planning methodology to fit it into our study. We examine the managerial environments and limitations of the postal services and define the requirements as a result. The U.S. Postal Service (USPS) was chosen as the best practice for a benchmarking and gap analysis with its advanced management of address information. After analyzing the current status of the postal business processes and information systems used, we classify the products and the services of USPS by the process to which they are applied and propose a deployment plan. In order to design a to-be model, we define the operating and managing functions for the address database and specify the scenario according to the functions. By managing the address database and supporting the postal services, it could be possible to make the business competitive and satisfy the customer demands.

Usability Evaluation of Text-based Search and Visual Search of a Multidisciplinary Library Database (상용 학술데이터베이스의 텍스트 기반 검색과 비주얼검색의 사용성에 관한 연구)

  • Kim, Jong-Ae
    • Journal of the Korean Society for information Management
    • /
    • v.26 no.3
    • /
    • pp.111-129
    • /
    • 2009
  • This study examined the usability of text-based search and visual search of a large multidisciplinary library database to provide an empirical analysis of the acceptability of visual systems in the information retrieval environment. It also examined if there are differences in the usability assessment based on experimental order. The results indicated that the text-based search supported users' search behaviors more efficiently than the visual search. Also the text-based search was rated higher than the visual search in terms of user perceptions of four usability factors.