User interface to a CIM-database

Abstract

“Low Cost” modular CIM concepts especially for small and medium sized companies will be of great interest in future. In this paper a new module of the user interface between the users at the CAD working place and the CIM database and the main tasks of the interface are described. The “low cost” modular CIM solution is established in order to embed all its components into the existing infrastucture of the company, according to their demands. Therefore physical and logistic connections of the existing PPS system as well as the installed CAD workstations with the working places have to be established. These parts have to be included into the superior systems of recording data of the plant and of operating. The realization of this solution is accomplished by using the C — programming language, Informix database and Informix — SQL as database query language, in order to create the custom applications with database management. With these tools, the structure of a relational database and the ANSI — standard Structured Query Language (SQL) are provided.