My company has finished the first phase of a data warehouse, with total size of about 100GB. The company then estimated that the warehouse would grow to about 3.75 terabytes of data, with the largest table being 100 million rows. After some research, the company identified the following RDBMS candidates for the task: NCR Teradata, Oracle 8i, IBM DB2. Can you make a recommendation or eliminate any candidates? The most important criteria include: performance and scalability, cost per transaction, total cost of ownership and ease of integration with other applications and data warehouse tools.
Douglas Hackney's Answer: All will do the job.
Oracle Upsides: lots of available talent, every tool works with it, everybody builds to Oracle first and then ports to other platforms, market share leader, definitely a long-term player - not going away
DB2/UDB Upsides: strong legacy knowledge in many firms, rising force in the market, strong performer, definitely a long term player - not going away
Sid Adelman's Answer: On your last criteria, "ease of integration with other applications and data warehouse tools," ask the application and tool vendors you are planning to use about the systems that are in production running with each of these RDBMS.
You will probably want to add support as another important criteria.
Total cost of ownership is more relevant than cost per transaction because even if you have a small number of queries, you still have to support the costly infrastructure of the data warehouse.
Both NCR and IBM can provide references for a number of installations with multiple terabyte data warehouses. When you talk with those references, be sure to ask the right questions. You want to know much more than just the number of terabytes they have on the floor.
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