Design and Implementaton of a Parts Lists Management System with a Client/Server Database
Johannes Kepler University Linz
Institute for Practical Computer Science
Altenbergerstraße 69, A-4040 Linz
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.