Skip to main content
U.S. flag

An official website of the United States government

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

A Database Design for the Machine Shop Information Model



Yung-Tsun Lee, Yan Luo


This report describes a database model currently under development at the Manufacturing System Integration Division (MSID) of the National Institute of Standards and Technology (NIST). The database model contains a set of tables that are mapped onto the machine shop information model developed by MSID. The information model provides neutral data interfaces for integrating machine shop software applications with simulation. The interface data include organizations, calendars, work, resources, schedules, parts, process plans, and layout within a machine shop environment. The database model is implemented using Microsoft Access; it is used to support the integration of manufacturing applications and simulations for machine shops. The database?s structures, relationships, and usages are presented in this report.
NIST Interagency/Internal Report (NISTIR) - 7077
Report Number


data structures, database, information model, machine shop operations, simulation


Lee, Y. and Luo, Y. (2004), A Database Design for the Machine Shop Information Model, NIST Interagency/Internal Report (NISTIR), National Institute of Standards and Technology, Gaithersburg, MD, [online],, (Accessed April 24, 2024)
Created December 31, 2003, Updated October 12, 2021