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
Are business intelligence certifications worth it? Get certification advice from our business intelligence expert, William McKnight. Continue Reading
There are loads of business intelligence tools out there on the market today. Our business intelligence expert provides some valuable resources for ... Continue Reading
Get examples of how data mining is used in vertical industries, such as retail, manufacturing, healthcare, financial and telecommunications. 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.