A design of database system for STEP (AP203) data from express entities

From preliminary idea of a design until a fully functioned product, the use of data format is different in every stages of process. Data generated in design process is rich in geometry and topological format. Whereas, manufacturing process requires manufacturing feature-based data. Therefore, there...

Full description

Saved in:
Bibliographic Details
Main Authors: Yusof, Yusri, Chen , Wong Keong
Format: Conference or Workshop Item
Published: 2013
Subjects:
Online Access:http://eprints.uthm.edu.my/5198/
http://eprints.uthm.edu.my/5198/1/A_Design_of_Database_System_for_STEP.pdf
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:From preliminary idea of a design until a fully functioned product, the use of data format is different in every stages of process. Data generated in design process is rich in geometry and topological format. Whereas, manufacturing process requires manufacturing feature-based data. Therefore, there is a need o database which is not only able for storing and retrieving data, but also able to extract and separate the geometry and topological data for use of subsequent process. This paper proposes a database system for extracting and separating the geometry and topological data from STEP AP203 (drawing file) based on EXPRESS entities and stored in the STEP database. This database system is built by using Microsoft Access relational database system. The strength of Microsoft Access relational database system is the ability to store large amounts of data in a highly normalized, tabular form, and to perform efficient quires across large data sets. Relational systems use Structured Query Language (SQL) for both data definition and data manipulation. At this moment, the databases is developed by using Microsoft Access and the advantage of this database is the ability to migrate into other advanced RDBMS and this extracted geomerty and topological data is beneficial for advanced STEP feature-based manufacturing process.