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.
Sid Adelman's Answer: Before you commit to implementing anything with billions of rows, you better be sure your RDBMS and hardware platforms can perform. Don't rely on vendor representations of what they can do theoretically. Talk to organizations that are already implementing systems that have your volumes. If you can't find any running with billions of rows, you should consider and research other high performance databases (DB2, Informix and Teradata).
Don't forget there's a lot more to performance than just the query response time.
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
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access