What is the advantage of using a dimensional data base rather than on-the-fly processing in OLAP?
Answer to relevant QuestionsWhy is online analytical processing usually conducted on warehoused data or dimensional data bases rather than on data in transactional databases?In general, what is the purpose of knowledge management in organizations?What does intelligence mean? Do you accept the use of the word in “business intelligence software tools,” or do you think the use of this word is exaggerated compared with what these tools provide?Companies would like to have systems that would allow them to store all the business related knowledge that their employees have accumulated. Do you expect that such systems will exist in your lifetime? Why or why not?The emergence of the web, social media, and mobile devices as vehicles for business increased the need for systems integration. How so?
Post your question