When should we use a DBMS? And what is the future of data warehousing data management?
Unless you’re taking a very narrow view of what a DBMS is, such as strictly a multipurpose, row-based, non-appliance-model database management system, then you will use a DBMS for your data warehouse as a matter of course – at least for now.
The future of data warehousing data management has promising changes coming in the form of triple stores, solid state disks and phase-change memory systems. The vendors of those systems and devices will begin to argue that they are not tied to a DBMS in order to differentiate them from current technology.
However, at present, you would definitely put your data warehouse on a DBMS. From there, the data warehouse architecture can easily extend into all manner of storage technologies for data marts as well as business intelligence, data mining and analytics systems.
Dig Deeper on Data warehouse software
Related Q&A from William McKnight
There are loads of business intelligence tools out there on the market today. Our business intelligence expert provides some valuable resources for ... Continue Reading
Find out how Oracle’s acquisition of Sun may affect Oracle data warehouse strategy and what it means for users. Also, see what role packaged BI ... Continue Reading
Find out if business intelligence (BI) analysis should tie in exactly with operational reports in source systems, and learn how to maximize BI's ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.