Design and Implementaton of a Parts Lists Management System with a Client/Server Database

Christoph Steindl
Johannes Kepler University Linz
Institute for Practical Computer Science
Altenbergerstraße 69, A-4040 Linz
steindl@ssw.uni-linz.ac.at


Abstract

In factories the number of areas supported by the usage of computers is steadily increasing. These computers are
integrated by means of a powerful network for cooperation (CIM, Computer Integrated Manufacturing). Often databases play a central role by managing all the relevant data for planning and carrying out projects and make the information accessible for applications of all kinds.
One of these applications is the management of parts lists which means the quantitative registration of all individual parts necessary for a certain product. The creation of parts lists enables the system to automatically give advices for the storekeeping (When to buy what?) using the data of the planning of orders (What shall be produced?) and the data of the department of development (What do we need therefore?).
Within the framework of this diploma thesis the connection of commercially available databases to Oberon has been implemented. A user friendly interface for the administration of databases and for the manipulation of the data was designed using dialogues. Database queries can be issued interactively using the query language SQL.


Diploma thesis (in German) in Mechatronics at the Johannes Kepler University Linz, Austria, December 1996.
Advisor of this diploma thesis: Prof. Mössenböck.
Graduation in Mechatronics (Dipl.-Ing.): February 1997.
You can download the full diploma thesis in postscript (approximately 120 pages) or click here to browse online.