PgConf.Russia 2017 talks
Optimized use of PostgreSQL in real world production
Roland Sonnenschein
Hesotech GmbH, CEO
Roland develops solutions to control and document technical processes since more than 25 years. PostgreSQL is the backbone for all these applications. Currently he is working on "Industry 4.0" and on an optical camera based system to detect landslides.
Often it is enforced by the customer or even by law, to document the circumstances of the production of parts or lots. This talk is about the automated generation and storage of the corresponding administrative data and their correlation to measurements. Administrative data are entities like suppliers batch, article, serial number or production date. They are often to be exchanged with ERP systems.
Our aproach of this optimations will be discussed by means of a currently implemented project to trace cages, filled up with bulk goods, going through a flow production. Each cage successively passes about 50 places and the facts of each step are to be documented. A live simulation will give more illustrations.
