Joseph Conway
Track: PostgreSQL
Date: Thursday, July 29
Time: 11:35am - 12:20pm
Location: Salon H
TrackBack
Many times, data collection applications are written to serve a specific purpose. Initially this approach serves well. It is simple to understand, and simple to mine for the purposes of analysis and discovery. Invariably however, the data collection requirements evolve due to design or process changes, or perhaps because of expansion into new areas of the business. Once this occurs, the downside of an inflexible data model becomes apparent.
In this presentation, you will see how to develop a PostgreSQL-based data model for flexible data collection. The proposed model allows the acquisition of arbitrary attributes of hierarchically nested objects. Additionally, you will be shown how to successfully extract data from such a structure in order to facilitate analysis and discovery of relationships, thus transforming data into useful information.
