Question: I have been asked to do a study of DW features of SQL 2K and Oracle 9i. How do I proceed with such an exhaustive study?
Sid Adelman’s Answer: Be sure you know why you have been asked to do the study. You need to know the answers to the following questions before you can begin your research:
Doug Hackney’s Answer: I would suggest the following steps:
Scott Howard’s Answer: The right way to conduct this study is to determine your users’ DW requirements, establish your own personal criteria that supports those requirements and finally assess how the products address those and only those established needs. Too often we fall prey to checklists of features, impressed with an apparent broader array of support only to later discover that the features important to us are not available or just don’t work as advertised. Is it really important that a RDBMS has 500 esoteric features, 490 of which don’t apply to the application needs?
Also don’t rely on the vendor input regardless of sincerity. Ask for references and talk to them. Be careful to ascertain whether the reference’s implementation truly mirrors your needs. Again, as in the past, I must ask why are you limiting your comparison? Two of the most feature-rich, scalable and best-performing RDBMSs are not in your short list.
Chuck Kelleys Answer: First I would find out what the purpose of the study is. Is it feature of the DBMS or the tools surrounding. For example SQL 2000 has DTS as part of its transformation services where Oracle has Warehouse Builder. Are these products to be included in the study? If it is just the database, then you would need to understand what features you would expect the DBMS to have to support your requirements of a data warehouse. Things such as table partitioning by data value, parallel loading of table, parallel index queries, bitmap indexes, etc. How important is performance in multidimensional model vs. a relational model database? So you need to come up with the purpose of the study and what features are important to your data warehouse before starting the study.
Clay Rehms Answer: The first step is to gather as much information from the Microsoft and Oracle Web sites. While you are there, download or request evaluation copies of the software. Other great (but somewhat biased) sources include the Professional Association of SQL Server (PASS) and the Oracle users group. However, the best evaluation is the one you perform based on the requirements of your project and/or organization. Consider hiring a consultant only after you have done your homework (the steps above).
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