|
Fall,
2003 CS 6754, COA 8676E DESIGN AND ENGINEERING DATABASE MANAGEMENT Prof. C. Eastman Class Time: Tu-Th 3 – 4:30 PM Location: L1105 Environmental Science & Technology Bldg. OVERVIEW This course has been completely redesigned and updated. |
|
|
|
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 future 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 forward to the next generation of data management using the Semantic Web. It also presents an overview of XML, XML schemas, ontologies and description logic based mapping methods. 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 |
|
Required Textbook: The Semantic Web Primer, by Antoniou G, van Harmlen, F, MIT Press, 2004. |
|
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 managements, and other uses. (3.5 weeks) Lectures
Notes: For the lecture on
9/1, please read Lee, Eastman and Sacks Process Planning #4 (ISO 9000) Process Planning #4 (Bicycle Parts and
websites) Process Planning #4 (What is a good
process?) Process Planning #5 (State and Versions) |
|
Required ESPRIT 020408 - VEGA. A Model of Workflow. Specification of a Model for the Definition of Workflows in Virtual LSE Enterprises (.pdf) Kenneth Crow, DRM Associates, (2002) CONFIGURATION MANAGEMENT AND ENGINEERING CHANGE CONTROL (.pdf) Support Ghang Lee, Charles M.
Eastman, and Eastman,CM (1996) “Managing Integrity in Design Information Flows”, Computer Aided Design, (May, 1996), 28:6/7, pp.551-565.(.pdf) Case, M. and C-Y Lu, [1996], "Discourse Model for Collaborative Design", Computer-Aided Design, 28:5, pp. 333-345
|
|
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: |
|
Required Elmasri and Navathe:
Fundamantals of Database Systems 3rd Edition, Chapter 3 Elmasri and Navathe:
Fundamantals of Database Systems 3rd Edition, Chapter 4 Elmasri and Navathe: Fundamantals of
Database Systems 3rd Edition, Chapter 7 Elmasri and Navathe: Fundamantals
of Database Systems 3rd Edition, Chapter 8 Sec. 8.1 Elmasri and Navathe: Fundamentals of
Database Systems 3rd Edition, Chapter 9 Support B.
Chandrasekaran, Todd Johnson, Jack W. Smith, "Task Structure Analysis
for Knowledge Modeling," Communications of the ACM, 33-9, Sep, 1992, pp.
124-136.
|
|
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. (4 weeks) Lectures
Notes: Homework
Assignment: |
|
Required Eastman C, Building Product Models,
CRC Press, 1999, Chapter 5. Eastman C, Building Product Models,
CRC Press, 1999, Chapter 6 Support Schenck, ISO-STEP Part 11, EXPRESS Language
Manual 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
|
|
PART FOUR: XML and the Semantic Web Some limitations of the STEP model of integration. Historical evolution of XML for Web communication. The concepts behind the Semantic Web. The Semantic Web applied to engineering product modeling. Some Base concepts for Semantic Web Modeling of Engineering and design. The role of Description Logic in the Semantic Web. An overview of DL and how it works. (5 weeks) Lectures Notes: The evolution of XML markup systems Homework Assignment: |
|
Recommended Antoniou and van
Harmelen, A Semantic Web Primer, MIT Press, Chapter 1 Antoniou
and van Harmelen, A Semantic Web Primer, MIT Press, Chapter 4 Yolanda Gil and
Varun Ratnakar, 2002, A Comparison of (Semantic) Markup Languages
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
