|
Fall,
2007 CS 6754, COA 8676E, ME6754 DESIGN AND ENGINEERING DATABASE MANAGEMENT Prof. C. Eastman Class Time: Tu-Th 3 – 4:30 PM Location: L5 OVERVIEW |
|
|
|
Design and engineering organizations are undergoing dramatic changes, based on IT and Web technologies. This course is constructed to review current technologies and to explore emerging technologies for design and engineering data integration and exchange. It provides a review of the field from the earliest days of CAD, through the current period using ISO-STEP technologies, and looks forward to the next generation of data management using the Semantic Web. The course does not make assumptions
regarding student's background in databases per sec, but does assume
background in engineering and design applications, and some knowledge
of software development
|
|
|
|
PART ONE: Engineering Processes and Process Modeling A process and what it produces are symbiotic; change one and the other needs to change too. We start by examining engineering processes, identifying what makes them unique and special; We also examines various tools to formalize process, for quality assurance, for workflow management and other uses. (3.5 weeks) Lectures
Notes: BPMN – bicycles high level- other
processes BPMN
Implementation Links: Links to
High Level Bicycle Models |
|
Required ESPRIT 020408
- VEGA. A Model of Workflow. Specification of a Model for the Definition of
Workflows in Virtual LSE Enterprises (.pdf) Introduction
to BPMN Stephen White, IBM (pdf) Process Modeling
Notations and Workflow Patterns, Stephen White, IBM (pdf) BuildingSMART Quickguide to BPMN Kenneth Crow, DRM Associates, (2002) CONFIGURATION MANAGEMENT AND ENGINEERING CHANGE CONTROL (.pdf) OMG BPMN Specification Version 1.0 Support Eastman,CM (1996) “Managing Integrity in Design Information Flows”, Computer Aided Design, (May, 1996), 28:6/7, pp.551-565.(.pdf)
|
|
PART TWO: Standard Database Concepts and Technology What are the unique characteristics and capabilities of a database that distinguish it from other computer tools and/or environments? The evolution and development of the current relational database standard model; the relational data model and operators; relational database design; normalization, data modeling. Major issues in databases: integrity, concurrency control, transaction management, interfaces to applications, authorization, backup and recovery. Application of relational models to engineering applications; representation of geometry, project data and the handling of configuration management of design data; some apparent limitations. (4.5 Weeks) Lectures
Notes: Introduction to Data Modeling and ER
Modeling Early Databases and the Development of
the Relational Model The Mapping from ER to relational |
|
Required Introduction to Entity-Relationship Modeling Extended
Relationship Modeling Integrity
management in Design - Eastman Function in Device representation- B.
Chandrasekaran and John R. Josephson, Computers in Engineering, 2000 (pdf) |
|
PART THREE: Data and Process Integration and Exchange Using STEP History of the data exchange problem; review of IGES and DXF. Data modeling of engineering products; ISO-STEP, the current international effort in developing data exchange models; the overall structure of STEP; the EXPRESS language and its graphical representation in EXPRESS-G; development of industry-specific and domain-specific product models developing an EXPRESS interface. (6 weeks) Lectures
Notes: |
|
Required Overview of EXPRESS and Related
modeling Languages Introduction to the STEP Methodology Support Access to Some of the STEP Application Protocols: IFC:
Industry Foundation Classes Part 42: Geometry and Topology Part 203: configuration_control_3d_design Part 204: Mechanical design using boundary
representation Part 205: Mechanical Design Using Surface
Representation Part 208:
Life-cycle management – change process Part 227: Plant Spatial Configuration
Application Protocol Product Data Management draft
report: Electro-Mechanical Parts |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
