• Title/Summary/Keyword: Database Design Automation

Search Result 62, Processing Time 0.027 seconds

New Database Table Design Program of Real Time Network for High Speed Train

  • Cho, Chang-Hee;Park, Min-Kook;Kwon, Soon-Man;Kim, Yong-Ju;Kim, Sung-Shin
    • 제어로봇시스템학회:학술대회논문집
    • /
    • 2003.10a
    • /
    • pp.2164-2168
    • /
    • 2003
  • Real time control system such as in factory automation fields, defense field, aerospace, railway industries, financial trading and so forth, includes multiple computers on multiple nodes, and share data to process various actions and functions. This is similar to multitasking in a multiprocessor computer system. The task processing efficiency of such system is proportionally increased by process speed of each process computer. And also it is greatly influenced by communication latencies of each node. To provide proper operation of such real time system, a network that can guarantee deterministic exchange of certain amount of data within a limited time is required. Such network is called as a real time network. As for modern distributed control system, the timeliness of data exchange gives important factor for the dynamics of entire control system. In a real time network system, exchanged data are determined by off-line design process to provide the timeliness of data. In other word, designer of network makes up a network data table that describes the specification of data exchanged between control equipments. And by this off-line design result, the network data are exchanged by predetermined schedule. First, this paper explains international standard real time network TCN (Train Communication Network) applied to the KHST (Korean High Speed Train) project. And then it explains the computer program developed for design tool of network data table of TCN.

  • PDF

Design of Communication Middleware for HACCP Automation System using Lightweight Devices (경량 단말기를 사용하는 HACCP 자동화 시스템의 통신 미들웨어 설계)

  • Hyun, Sung-Young;Cha, Kyung-Ae;Hong, Won-Kee
    • Journal of Korea Society of Industrial Information Systems
    • /
    • v.20 no.4
    • /
    • pp.11-23
    • /
    • 2015
  • In this paper, we propose a communication middleware for development of HACCP(Hazard Analysis and Critical Control Point) automation system, which is composed of lightweight devices and a server, to support effective HACCP data management. To provide the proper HACCP data to lightweight devices, we design the communication message protocol based on HACCP management regulation model. Moreover, we develop the communication middleware that performs various functions, such as processing of communication protocols for HACCP data, analyzing of messages between devices and a server, and providing database managements tools. In addition, it takes a role to guarantee sharing consistent data among the devices and server, through the active updates for information on devices. Actually, the proposed communication middleware can be a part of critical system to develop a HACCP automation system with lightweight devices, because it implements the HACCP communication protocols making lightweight devices execute every HACCP task.

Integrated CAD System for Ship and Offshore Projects

  • Suh, Heung-Won;Lee, Sung-Geun
    • International Journal of CAD/CAM
    • /
    • v.6 no.1
    • /
    • pp.41-48
    • /
    • 2006
  • Nowadays major shipbuilding companies are trying to expand their business not only to shipbuilding but to offshore projects as well. DSME is one of them. DSME is trying to set up a flexible design and construction environment for shipbuilding and offshore construction in a single shipyard. The shipbuilding and offshore projects, however, have their unique technology but they need to be designed and constructed in one site. To support this new requirement, DSME has developed an integrated CAD system for ship and offshore projects. In this integrated design environment, the designers can design commercial ships and offshore projects in a flexible manner. Concurrent design is very important for ship and offshore design. As compared to the complexity of the product, the design period is quite short. In effect, the design system for the ship and offshore project has to support concurrent design. One essential point of concurrent design environment is a product model based design system. DSME has developed and implemented the 3D product model concurrent design environment based on Tribon M3. Tribon is a widely used CAD system in shipbuilding area that is developed by Tribon Solutions. DSME has both customized the Tribon system and developed in-house application systems to support its own design and production procedures. All the design objects are modeled in one common database to support concurrent design and accurate production. The major in-house development focused on the modeling automation and automatic drawing generation. During the drawing generation process many of the additional production information are also extracted from the 3D product model. In addition, several applications and functionalities have been developed to apply the shipbuilding based Tribon M3 system to offshore projects. The development of shape nesting, tubular connection, isometric drawing, grating nesting systems are the typical.

A Study on the Model Development for Production of Interior Drawings and estimation of Quantities (실내도면 작성과 물량산출을 위한 모델 개발에 관한 연구)

  • 정례화;이승우;추승연
    • Korean Institute of Interior Design Journal
    • /
    • no.19
    • /
    • pp.30-37
    • /
    • 1999
  • This study presents a methods on the construction of integrated system for the purpose of automation of design plans, calculation of quantity of materials and estimation by abstracting information on building materials which is produced on the course of three dimension modeling by using computer. Therefore, an object oriented methodology is introduced to compose design informations in three dimension, space for unifying building informations, and expressing properties of building factors and materials, and to construct a database for computers to recognize architecture informations. An object indicates a conceptual individual existing in real world or existence of individual and necessity in composing a building could be called as objects such as column, wall, beam, slab, door and window and these contain materiality and immateriality. It is systemized to which properties of these building's objects are installed by the user of computer and by API(Application Programming Interface), chosen informations automatically converse to each unit work such as design plan structure plan, calculation of amount of materials, etc.

  • PDF

Development of Theme Park Management Automation System Using RFID (RFID를 이용한 공원관리 자동화 시스템 개발 연구)

  • Lee, Yang-Weon
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.9 no.4
    • /
    • pp.871-876
    • /
    • 2005
  • Theme park automation system is developed by using the RFID sensor reader, IIS web server, ASP.NET and MSSQL database in this paper. Its operation is that park entrance people checked automatically when he who possessed the ta8 passed the reader acquisition bound and its tag information is sent to the host computer through the RS-232 data acquisition system. Tag information and time data will be stored in the RFID database tables and reused to extract and distribute the entrance people for the purpose of each arrangement of each entertainment devices. First of all, we developed interface program between host and reader and then, programmed the related web site and database connection function using ASP.NET with $C\#$ and MSSQ. We also design and make an production of external Ant. to extend the acquisition range up to $30\~40$ cm using copper PCB plate. We confirmed the performance through the RFID test bed site.

Automated Conceptual Data Modeling Using Association Rule Mining (연관규칙 마이닝을 활용한 개념적 데이터베이스 설계 자동화 기법)

  • Son, Yoon-Ho;Kim, In-Kyu;Kim, Nam-Gyu
    • The Journal of Information Systems
    • /
    • v.18 no.4
    • /
    • pp.59-86
    • /
    • 2009
  • Data modeling can be regarded as a series of processes to abstract real-world business concerns. The conceptual modeling phase is often regarded as the most difficult stage in the entire modeling process, because quite different conceptual models may be produced even for similar business domains based on users' varying requirements and the data modelers' diverse perceptions of the requirements. This implies that an object considered as an entity in one domain may be considered as an attribute in another, and vice versa. However, many traditional knowledge-based automated database design systems unfortunately fail to construct appropriate Entity-Relationship Diagrams(ERDs) for a given set of requirements due to the rigid assumption that an object should be classified as an entity if it has been classified as an entity in previous applications. In this paper, we propose an alternative automation system which can generate ERDs from business descriptions using association rule mining technique. Our system can be differentiated from the traditional ones in that our system can perform data modeling only based on business description written by domain workers, rather than relying on any kind of knowledge base. Since the proposed system can produce various versions of ERDs from the same business descriptions simultaneously, users can have the opportunity to choose one of the ERDs as being the most appropriate, based on their business environment and requirements. We performed a case study for personnel management in a university to evaluate the practicability of the proposed system This paper summarizes the result of it in the experiment section.

Web-Enabled Collaborative Design Environment

  • Kim, Hyun;Yoo, Sang-Bong;Lee, Hyun-Chan
    • ETRI Journal
    • /
    • v.22 no.3
    • /
    • pp.27-40
    • /
    • 2000
  • Recently, advanced information technologies have opened new possibilities for collaborative designs. In this paper, a web-enabled collaborative design environment is proposed, where the product data based on STandard for the Exchange of Product model data (STEP) is managed in a hierarchical database and the product metadata is used to efficiently search and utilize information scattered over the network. Several integrity constraints are depicted using EXPRESS to validate the combination of data from different sources. The knowledge represented as metadata and constraints on the interacting features differentiate this environment from previous ones. The collaborative conferencing system is also introduced to communicate and collaborate simultaneously among the related designed. As a result, the proposed environment allows the distributed designers to more efficiently obtain, exchange and communicate the design information throughout the design process.

  • PDF

A Repository for Workflow Management on Distributed Object Environment (분산객체 환경에서의 워크플로우 관리를 위한 정보저장소)

  • Yeom, Tae-Jin;Park, Jae-Hyung;Ri, Ja;Kim, Ki-Bong;Jin, Sung-Il
    • The Journal of Society for e-Business Studies
    • /
    • v.4 no.1
    • /
    • pp.1-19
    • /
    • 1999
  • Workflow management system provides automation of job processes by maintaining shareability on information about various job process schedules and persons related to those schedules. Existing workflow management systems use file or database to store the information generated in those systems. However, file or database system could manage only non-complicated information for the workflow but not the information resources of an enterprise which is complicated and of various formats. Therefore, we need a data management system that could control those information resources. This system should manage the data which are distributed at several places geographically. Information Repository could meet those requirements. Information Repository may integrate, store and manage information resources requested by application systems. We have an international standard for the information repository, Information Resources Dictionary System(IRDS). The IRDS, however, does not support distributed environment. In this paper, we design and implement an information repository based on IRDS that may be operated in distributed environment. We verify that this information repository is more effective and is more effective than any other file or database system.

  • PDF

Establishing Automated Mapping/Facilities Management System Using PC-CAD (PC용 CAD를 이용한 단지기반시설 정보화)

  • 이규석;안승만;탁형렬
    • Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
    • /
    • v.15 no.2
    • /
    • pp.141-148
    • /
    • 1997
  • Continuous development of Personal Computer(PC) combined with the decrease of price and the expansion of operating system in PC like Windows 95, and Windows N/T makes it possible for the user to consider PC-bas-ed Automated Happing/Facilities Management (AM/FM) system. Therefore, the purpose of this study is to establish a PC-based data automation system of pipe infrastructures-water, sewer, and drainage-and road in Korea Land Corporation. In order to achieve this goal, relevant literature survey was done first. Secondly, the study site was determined by discussion with Korea Land Institute. Thirdly, PC-based CAD software for AM/FM in the world market were surveyed, and AutoCAD Map was selected because KLC had been using hundreds of AutoCAD copies already. After that user needs assessment was done to visit on-site office, local branch office, and the corresponding city office for the system design and database design. After the graphic data were digitized and the attribute data were entered into the batabase, the data automation system was established, and tested for application. Finally, the guidelines and problems for PC-based data automation in AM/FM was discussed.

  • PDF

Oil Cooler Design Automation on the Cooling of Machine Tool Cutting Oil (공작기계 절삭유 냉각용 오일쿨러 설계 자동화)

  • 권혁홍
    • Journal of the Korean Society of Manufacturing Technology Engineers
    • /
    • v.8 no.1
    • /
    • pp.89-99
    • /
    • 1999
  • The automatic design of shell & tube type oil cooler can be used in real industrial environments. Since the automatic design system is intended to be used in small companies, it is designed to be operated well under environments of CAD package in the personal computer. It has adopted GUI in design system, and has employed DCl language. Design parameters to be considered in the design stage of shell and tube type oil cooler are type of oil cooler, outer diameter, thickness, length of tube, tube arrangement, tube pitch, flow rate, inlet and outlet temperature, physical properties, premissive pressure loss on both sides, type of baffle plate, baffle plate cutting ratio, clearance between baffle plate outer diameter and shell inner diameter and clearance between baffle plate holes. As a result, the automatic design system of shell & tube type oil cooler is constructed by the environment of CAD software using LISP. We have built database of design data for various kinds of shell & tube type oil coolers. The automatic design system have been assessed and compared with existing specification of design. Good agreement with Handbook of heat exchanger and design dta of real industrial environments has been found.

  • PDF