• 제목/요약/키워드: Database Design Automation

검색결과 62건 처리시간 0.023초

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년도 ICCAS
    • /
    • 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

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

  • 현성용;차경애;홍원기
    • 한국산업정보학회논문지
    • /
    • 제20권4호
    • /
    • pp.11-23
    • /
    • 2015
  • 본 논문에서는 중앙관리 서버와 부착형 경량 단말기를 사용하는 HACCP(Hazard Analysis and Critical Control Point) 자동화 시스템에서, 효율적인 HACCP 데이터의 송수신을 위한 통신 미들웨어를 개발한다. 이를 위해서 HACCP 관리 규정을 토대로 경량 단말기에 최적화될 수 있는 HACCP 데이터를 위한 통신 메시지 규약을 설계한다. 또한 경량 단말기와 서버 간의 데이터 교환 및 데이터 통합 관리 기능을 수행하는 통신 미들웨어를 구현한다. 통신 미들웨어는 단말기의 경량화를 지원하기 위해서, 단말기가 필요로 하는 데이터를 능동적으로 갱신하며, 서버의 HACCP 데이터베이스를 관리한다. 또한 단말기와 서버의 일관적인 데이터 공유가 가능하도록 모니터링 기능을 제공하고 통신 메시지의 송수신을 담당하여 실질적으로 HACCP 자동화 업무를 수행한다. 이러한 HACCP 데이터 관리를 위한 통신 메시지 규약과 통신 미들웨어의 기능을 검증함으로써, 경량 단말기를 지원할 수 있는 HACCP 자동화 시스템 개발에 요소 기술로 활용될 수 있음을 보인다.

Integrated CAD System for Ship and Offshore Projects

  • Suh, Heung-Won;Lee, Sung-Geun
    • International Journal of CAD/CAM
    • /
    • 제6권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)

  • 정례화;이승우;추승연
    • 한국실내디자인학회논문집
    • /
    • 제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

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

  • 이양원
    • 한국정보통신학회논문지
    • /
    • 제9권4호
    • /
    • pp.871-876
    • /
    • 2005
  • 본 논문에서는 유비쿼터스 센서 네트워크의 핵심인 RFID에 대한 응용기술을 개발하기 위하여 대상을 놀이공원으로 잡고, 공원에 출입하는 입장객들이 각 놀이 기구에 입장한 시간과 나가는 시간을 자동으로 입력 받아서 데이터베이스에 저장한 후에 전체적인 놀이공원 인원 배치에 관한 합리적인 지시, 명령을 도출하도록 하는 프로그램을 개발하는 시스템을 개발하였다. 이를 위하여 본 논문에서는 13.25Mhz 대의 RFID 센서와 마이크로소프트사의 MSSQL 데이터베이스와 IIS 웹서버를 기반으로 하는 시스템 구축을 수행하였다. 이를 위하여 SkyeTek사의 RFID 리더를 기반으로 시스템을 구축하여 호스트 PC와 연동 프로그램을 C++ 언어를 이용하여 개발하였고, ASP.NET과 $C\#$을 이용한 웹사이트 구축하였으며, RFID 리더의 태그 인식 범위를 확장하기 위한 외장형 안테나를 제작한 $30\~40$ cm 수준의 인식 거리를 보장하는 동판형 안테나를 개발하였으며, 시스템에 적용한 결과 성능의 우수함을 확인하였다.

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

  • 손윤호;김인규;김남규
    • 한국정보시스템학회지:정보시스템연구
    • /
    • 제18권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
    • /
    • 제22권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)

  • 염태진;박재형;리자;김기봉;진성일
    • 한국전자거래학회지
    • /
    • 제4권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

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

  • 이규석;안승만;탁형렬
    • 한국측량학회지
    • /
    • 제15권2호
    • /
    • pp.141-148
    • /
    • 1997
  • 지속적인 PC의 발전 및 이에 반비례한 가격의 하락, Windows 95. Windows N/T로 이어지는 PC운영체제의 확장은 소규모 단지의 경우 PC에서도 도시기반시설관리정보체계의 운영가능성을 신중히 모색케 하고 있다. 이와 같은 점을 고려하여 AutoCAD를 이용하여 한국토지공사의 단지기반시설 업무인 pipe-based도시기반시설-상수, 우수, 오수-및 도로의 도면정보와 속성정보를 PC상에서 동시에 관리할 수 있는 자료자동화 시스템을 구축하였고, 향후 구축 방향 및 문제점을 논하였다.

  • PDF

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

  • 권혁홍
    • 한국생산제조학회지
    • /
    • 제8권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