O'Reilly Open Source Convention
Books Safari Bookshelf Conferences O'Reilly Network
   


Arrow Home
Arrow Registration
Arrow Speakers
Arrow Keynotes
Arrow Tutorials
Arrow Sessions
Arrow At-a-Glance
Arrow Wiki
Arrow BOFs
Arrow Events
Arrow Exhibitors
Arrow Sponsors
Arrow Hotel/Travel
Arrow Venue Map
Arrow See & Do
Arrow Tips for
 Attending
Arrow Press
Arrow Mail List

OSCON.

Session

Flexible Data Acquisition and Analysis
Joseph Conway

Track: PostgreSQL
Date: Thursday, July 29
Time: 11:35am - 12:20pm
Location: Salon H

TrackBackTrackBack

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.



O'Reilly Home | Privacy Policy

© 2004, O'Reilly Media, Inc.