Conference Schedule - PGConf.EU 2013

PostgreSQL for Rails

Date: 2013-10-30
Time: 11:10 - 12:00
Room: Leeson
Level: Beginner

Plea for database driven software in the enviroment of technical engineering.

Axleboxes (the package of wheels and axes) of railway wagons and locomotives have to proof their performance according to the norm DIN EN 12082. They are only allowed to be mounted, after they passed the required long running ( >600 000 km) approval tests on a test rig.

Lots of parameters have to be controlled, monitored and evaluated in a quite complex way. During the test, all maesurements, calculations and evaluations have to be available online.

This talk is about our database driven software solution. It treats the following topics:

  • Explanation of the application and specification of the required tests.
  • Database structure, mirroring the technical demands
  • Dataflow inside the database, giving all the required calculations and evaluations.
  • Implementation of the dataflow by triggers, procedures and views.
  • Benefits of a database driven software.
Using PostgreSQL as a smart database system - instead of a simple persistanace layer behind an ORM - simplifies software development and makes the application more reliable.

Speaker

Roland Sonnenschein

Platinum Sponsors

2ndQuadrant
EnterpriseDB

Gold Sponsors

Cybertec
Heroku

Silver Sponsors

Dalibo
Gilt
VMware
Zalando
EngineYard
Servoy
Vertabelo