File list

From PostgreSQL wiki

Jump to: navigation, search

This special page shows all uploaded files.

File list
Items per page:
Search for media name:

descDate Name Thumbnail Size User Description Versions
09:52, 17 April 2014Rsunny pgconfnyc 2014.pdf (file)(thumbnail)1.82 MBRsunny 1
12:09, 30 October 2012Pgeu2012.pdf (file)(thumbnail)4.51 MBRsunny (In technical applications, databases are rarely used to store measurements and metadata. This talk is about 3 technical projects with PostgreSQL as the core software component. - Wind Energy: Testing of large size bearings of wind mills. - Automotive Industry: Test center to improve corrosion behaviour. - Plant genetics: Automated mass phenotyping by machine vision. Details are discussed.)2
15:24, 26 October 2012Pgeu2012 rsunny.pdf (file)(thumbnail)5.96 MBRsunny (In research and development a reliable and stable storage of measured data and metadata is essential. Up to now these data are mostly stored in simple files. Metadata concerning the specimens are often handled by hand or calculation sheets. This talk is about three success stories of three different big technical projects. In these projects PostgreSQL is the core software component for storing all the data. Wind Energy: Testing of large size bearings of wind mills. Recently, Astraios – the most modern, largest, and highest performing large-size bearing test rig in the world - started operation. PostgreSQL has to store more then 3 Million measurement points every second continously over a periode of several weeks. In parallel, PostgreSQL has to retrieve the data for evaluation. We explain our technology in effiently handling these hugh amounts measurements. Automotive Industry: Test center to improve corrosion behaviour The AUDI INKA test simulates the whole life of a car within 19 weeks. This is achieved by a well defined sequence of special intensive treatments. The timestamps of all the treatments of the all cars are also stored in the database. Special functionalities of PostgreSQL makes evaluation mutch faster and easier compared to other solutions. Plant genetics: Automated mass phenotyping by machine vision At the Gregor-Mendel-Institute in Vienna, the relation between apearance and genetics of plants is investigated. In each experiment, the data of more then thousend individual plants have to be administrated. A robotic system takes pictures of each plant at least twice a day. Beside the climatic data and the results of the online machine vision evaluation, all taken images are stored in PostgreSQL. PostgreSQL makes it possible to setup an efficient statistical evaluation of the experiment, considering all the relations between the aquired data and metadata. )1

Personal tools