UTHM Institutional Repository

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

Yusof, Yusri and Chen , Wong Keong (2013) A design of database system for STEP (AP203) data from express entities. In: Proceedings of the 2nd International Conference on Advanced Manufacturing (ICAM 2013), 12-13 December 2013, Ayodya Resort Bali, Indonesia .


Download (466kB)


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.

Item Type: Conference or Workshop Item (Paper)
Uncontrolled Keywords: database system; STEP AP203; geometry and topological data; microsoft access
Subjects: Q Science > QA Mathematics > QA76 Computer software
Divisions: Faculty of Mechanical and Manufacturing Engineering > Department of Manufacturing and Industrial Engineering
Depositing User: Normajihan Abd. Rahman
Date Deposited: 27 May 2014 08:07
Last Modified: 21 Jan 2015 07:37
URI: http://eprints.uthm.edu.my/id/eprint/5198
Statistic Details: View Download Statistic

Actions (login required)

View Item View Item


Downloads per month over past year