• Title/Summary/Keyword: Database Design Automation

Search Result 62, Processing Time 0.033 seconds

A Study on the Data Extraction and Formalization for the Generation of Structural Analysis Model from Ship Design Data (선체 구조설계로부터 구조해석 모델 생성에 필요한 데이타의 추출과 정형화에 관한 연구)

  • Jae-Hwan Lee;Yong-Dae Kim
    • Journal of the Society of Naval Architects of Korea
    • /
    • v.30 no.3
    • /
    • pp.90-99
    • /
    • 1993
  • As the finite element method has become a considerable and effective design tool in ship structural analysis, modeling of three dimensional finite element mesh is more necessary than before. However, the unique style and complexity of a ship usually make the modeling be hard and costly. Although most pre-processor of FEM software and geometric modeler provides modeling function, the capability is quite limited for complicated structure. In order to perform FEM modeling quickly, it is necessary to extract, rearrange, and formalize data from ship design database for partially automatic mesh generation. In this paper, the process of designing relational data tables from design data is shown as a part of analysis automation with the application of engineering database concept.

  • PDF

Data Transformation System Implementation for the Automation of PCB Product (PCB 생산 자동화를 위한 데이터 변환 시스템 구현)

  • Lee Seung-Hyuk;Kim Gui-Jung;Han Jung-Soo
    • The Journal of the Korea Contents Association
    • /
    • v.5 no.5
    • /
    • pp.17-25
    • /
    • 2005
  • In this paper, we design data transformation interface for the automation of PCB product. The data designed to CAD does not exchange itself for the assembly line, so we construct an automation system which is exchangeable. To do this, we analyze the information of PCB components and construct the Information of IC components as database. We also develope two kinds of algorithm; one is to detect human error and another is to exchange itself for the data which is suitable for PCB assembly line. We design data transformation interface to do addition and revision of the information for PCB assembly line. By automating existing manual processing, we are able to shorten access time and enhance reliability of the data and the efficient assembly line of PCB.

  • PDF

Planning of Part Feeder and Design of a Data Base for Part Feeder Planning System (자동 부품 정렬기 응용계획과 전용 DB 설계)

  • Guk, Geum-Hwan;Park, Yong-Taek
    • Journal of the Korean Society for Precision Engineering
    • /
    • v.19 no.7
    • /
    • pp.116-124
    • /
    • 2002
  • The planning of part feeder and other manufacturing automation equipments is almost always underestimated. Planning ahead for those crucial pitfalls can permit steps to take to minimize heir impacts, especially if the problems can be discovered in the planning phase, not on the shop floor. Planning process is an engineering process, namely a series of trade-offs. The effective trade-offs in the shortest amount of time can be possible with the help of a computer-aided ngineering (CAE) technique. The main parts of CAE fur part feeder are database system of fabricated workpiece parts, part feeders, part feeder components. In this study, a planning process of part feeder is presented. Especially, a systematic analysis of workpiece parts and part feeders is performed for the design of databases of CAE system.

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.

Roll Pass Design System for Round Bars to Design Rolling Equipment (압연 설비 설계를 위한 봉재 압연의 롤 패스 설계 시스템)

  • 윤성만;박승희;신상엽
    • Transactions of Materials Processing
    • /
    • v.9 no.2
    • /
    • pp.112-119
    • /
    • 2000
  • The roll Pass design is one of the most important processes to design the whole equipment of the rods and bars rolling system. In this study, the roll pass design program named TollRo(Rolling Factory Organizer) was developed. conventional methods to design roll pass were analyzed and a new algorithm to design the dimension of the intermediate groove was introduced. Object oriented programming technology was implemented in this design program. It comprises GUI(Graphic User Interface), function of automatic pass design, function of modifying pass schedule and database of material properties. The developed program can be used to design roll pass with consistency for the rods and bars rolling system. The man-hours for the whole design can be drastically reduced. The design parameters of rolling system can be extracted quickly by this program.

  • PDF

Development of the Tolerance Design System for a Gear Drive (치차 장치를 위한 공차 설계 시스템 개발)

  • 정태형;정진욱
    • Transactions of the Korean Society of Mechanical Engineers A
    • /
    • v.24 no.11
    • /
    • pp.2713-2722
    • /
    • 2000
  • When designing a gear drive, designers should specify tolerances reasonably considering accuracy, cost, and manufacturing capability. In field design, however, designers mostly assign adequate tolerance without correlations between parts and assembly, resulting in iterative design dependent on experts know-how. In order to resolve this, the tolerance design system for a cylindrical gear drive is developed both to support tolerance design automation and to synthesize design processes of part and assembly tolerances. In this research, part tolerances are designed with the databases constructed by ISO, Ks, JIS and bearing catalogue, Assemble tolerance, that is, backlash tolerance is designed by synthesizing part design tolerances stochastically using the formulated assembly relations. This system can include part tolerance and fitting accuracy of shaft adn bearing in practical design. In addition, this system provides field-designers with a synthetic guideline for tolerance design of a gear drive.

Automation of Fatigue Durability Analysis for Welded Bogie Frame Using a Multi-Agent Based Engineering Framework (멀티 에이전트 기반 엔지니어링 프레임워크를 이용한 용접대차틀 피로내구해석의 자동화)

  • Bang, Je-Sung;Han, Seung-Ho;Lee, Jai-Kyung;Park, Seong-Whan;Rim, Chae-Whan;Song, See-Yeob
    • Korean Journal of Computational Design and Engineering
    • /
    • v.12 no.4
    • /
    • pp.308-320
    • /
    • 2007
  • A multi-agent and web based engineering framework concerning the automation of fatigue durability analysis for welded bogie frame of railway vehicles is presented. Mostly, this kind of design or analysis includes complex workflow, huge amounts of information processing, and problem solving. Macro programs of I-DEAS, APDL of ANSYS, and in-house fatigue code are utilized for parametric geometry representation, automatic mesh generation, static stress analysis, fatigue durability analysis, post-processing, and data sorting. The engineering framework is implemented on the JADE. Since every task requires a fairly complex process and specialized knowledge, the multi-agent based framework is very useful to keep the independency among several disciplines or tasks and to use distributed hardware and software resources. All engineering programs are integrated by XML wrapper. Related database of the engineering framework and web based user interfaces are also developed. A parametric study is carried out to take into account the effect of geometrical change of transom support bracket on its cumulative fatigue damage. The developed engineering framework reduced remarkably the time and costs required in designing and solving engineering problems.

A Bit of Factory Automation : Manufacturing Cost Estimation Using Group Technology (공장 자동화에 관한 소고 : 그룹 테크놀로지를 이용한 생산원가 추정)

  • Lee, Sung-Youl
    • Journal of Korean Institute of Industrial Engineers
    • /
    • v.15 no.2
    • /
    • pp.77-86
    • /
    • 1989
  • A fully automated cost estimation system(FACES) has been developed. Since speed, accuracy, and consistency are essential factors in automating a cost estimation, the use of computers in cost estimation system(CES) has grown rapidly in the last few years. FACES is a micro computer based cost estimation system that employs a manufacturing knowledge base. A Group Technology(GT) based part classification and coding(C&C) scheme is used to automate the process planning aspects of cost estimation. Variant process planning methods are employed to generate workstation routings from form features of the part. The system has been tested for an assembly of six machined parts. Results indicate that the system could provide a substantial improvement in accuracy, productivity, and performance over the more traditional full dialog approach to cost estimation. It also provides a good foundation for a factory automation by using a common GT based database through design to production.

  • PDF

Data Transformation Interface Design for Automation of PCB Product (PCB 생산의 자동화를 위한 데이터 변환 인터페이스 설계)

  • Lee, Seung-Hyuk;Han, Jung_Soo
    • Proceedings of the Korea Contents Association Conference
    • /
    • 2004.11a
    • /
    • pp.412-416
    • /
    • 2004
  • In this paper, we designed data transformation interface for automation of PCB product. For this, information of PCB components designed to CAD is analyzed and human error detect algorithm is developed. Also we constructed information of IC components in database and designed the interface and algorithm for data transformation. Thersfore Did so that can shorten time of degree to be 1-2 days within several minutes by automating existent manual processing.

  • PDF

Development of Adaptive Electronic Approval System(EAS) Based on Workflow Control (흐름제어 기반의 적응형 전자결재 시스템 개발)

  • Gwon, Yeong-Do;Sin, Dong-U
    • 연구논문집
    • /
    • s.30
    • /
    • pp.169-176
    • /
    • 2000
  • The Evolution of Workflow Managment consists of rhe automation of business procedures or "workflows" during which documents, information or tasks are passed from one participant to another in a way that is governed by rules or procedures. Workflow technologies have evolved from image management system, document management system, relational or object database systems, and electronic mail system. Workflow Management system has the benefits to improve better efficiency, process control,flexibility, business process. Automation of many business processes results in the elimination standdardizing working methods. Consistency in the processes leads to greater predictability in levels of response to customers and software control over processes enables their re-design in line with changing business needs, In this present study, we implement Electronic Approval System which is a kind of Workflow Management system using static and dynamic flow control information on the web environment.

  • PDF