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.
Related Q&A from William McKnight
Are business intelligence certifications worth it? Get certification advice from our business intelligence expert, William McKnight.continue reading
Get examples of how data mining is used in vertical industries, such as retail, manufacturing, healthcare, financial and telecommunications.continue reading
Learn the advantages and disadvantages of data mining tools and of implementing data mining technology.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.