I am working on designing a CRM database. This warehouse is going to be billions of rows because we are tracking clickstream and other data for individual customer across call centers, Web, personal and other channels. Any advice regarding design and implementation of this VLDB warehouse? I have experience with partitioning, parallelism features in Oracle. Should I be looking at other object db's for this kind of storage and performance? I am thinking we should be able to pull this through with Oracle8 with all the high performance/storage features.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access