History of Pharma Research Data Warehousing

Avalon
- Built based on lessons learned from WinMerlin/Pharon Reports
  - Provide ISISBase-like functionality
  - Shift of emphasis from data mining/exporting to reporting and workflow support
  - Saved forms, queries, sessions
  - Support for data field navigation
  - Oracle-based => designed for 10-100 times more data
  - Qualified values (e.g. IC50: ‘< 5 M’ vs. ‘1.1 M’ )
  - Data integrity/quality needs to be addressed
- Uses chemistry data cartridge to perform structure searches
- On-the-fly ‘grouping by structure’
- WAN performance => saved mirror servers
- Using the warehouse must be easier than collecting and reporting data on the desktop

Avalon