ME 6754: Engineering Database Management Systems

Offered Every Fall and Spring


Credit Hours: 3-0-3
Prerequisites: Graduate standing in engineering or related discipline
Catalog Description: Modeling and managing engineering information systems, integration of design and manufacturing functions in engineering product development, logical models of engineering product and processes. Crosslisted with CS 6754.
Textbooks: None
Instructors: Chris Paredis
References:

Selected books on database management, date modeling and database design; selected notes, papers, and handouts on engineering database management technology

  • C.J. Date; An Introduction to Database Systems, Vol I, Addison-Wesley
  • R.Elmasri, S.G. Navathe; Fundamentals of Database Systems, Benjamin/Cummings, 1989
  • C.Batini, S. Ceri, S.B. Navathe; Conceptual Database Design, Benjamin/Cummings, 1992
  • J.Martin; Computer Database Organization, Prentice-Hall, 1977
  • J.D. Ullman; Principles of Database Systems, Computer Science Press, MD, 1982
Goals: To improve engineering productivity, there is a critical need to advance technology for management of information in the analysis, design and manufacturing process. This course will provide an indepth study of methods and approaches to managing engine ering information. It will include the theory of database management concepts, approaches to designing databases for engineering applications and lab assignments on the use of the concepts in representative engineering and manufacturing tasks. Course will include a mixture of classroom lectures, outside reading and computer based projects.
Topics:
  1. Introduction
    1. What is information?
    2. Why engineering systems need it
    3. How important is information management to engineering functions?
  2. Engineering Product and Process Description
  3. Introduction to Databases
    1. Overview
    2. Three-Schema approach
    3. Data structures (Indexes, B-trees, etc.)
    4. Hierarchical DBMS
    5. Network DBMS
    6. Relational DBMS
  4. Modeling Engineering Systems
    1. Functional modeling (SAMM, IDEF0, DFD)
    2. Data modeling (ER, EER, IDEF1x, NIAM, Semantic nets, OO)
    3. Express modeling syntax
    4. Abstract data types
    5. Dynamic modeling (IDEF2)
    6. Knowledge modeling (Production rules, Frames)
    7. Data dictionary
    8. Requirements for modeling engineering systems
  5. Relational Data Model
    1. Introduction
    2. Relational algebra
    3. Normal forms
    4. EER Relational
    5. ORACLE
    6. SQL
    7. Views, triggers, transactions
    8. Data security
  6. Integration Approaches via DBMS
    1. Introduction
    2. A Framework for Information-Integration
    3. Generic Integration Model
  7. Mid-Term Exam
  8. Case Studies in Engineering Applications
    1. Methodology for Phased Implementation
    2. IPAD and TIGER projects
    3. Sheet Metal Design/Manufacturing
    4. Material Handling System Design
    5. Fiber Optic Cable Manufacturing
    6. PWB Design
  9. Product Data Models and Standards
    1. PDCM
    2. IGES
    3. PDES/STEP
    4. CALS
  10. Object-Oriented and Multimedia DBMS
    1. Introduction
    2. OO concepts
    3. Modeling methods
    4. Software systems
  11. Special Topics/Applications
Delivery Mode (%):

Lecture

60

Literature Study

20

Term Project

20

Grading Scheme (%):

Homework

20

Midterm

30

Term Project

50