History of Pharma Research Data Warehousing

• WinMerlin / Pharma

  • Same front-end and architecture as Horus
  • Started with Ciba/Sandoz merger
  • Quickly combined pre-merger structure and global biology data sources
  • Focus on data mining
  • Add-ins for Pharon reports to provide forms reports
  • Reaches design limits
    • 1.1 GB of data + per session space approaches 2 GB
    • Server data model too inflexible to support data field navigation
    • Users prefer one, consistent tool over linked GUIs
    • 16 bit GUI causes limits extensibility

Notes: