Application Developer Question:
Download Questions PDF

Please explain the difference between OLAP and Data Mining?

Answer:

OLAP - On line Analytical processing is a reporting tool configured to understand your database schema ,composition facts and dimensions . By simple point-n-clicking, a user can run any number of canned or user-designed reports without having to know anything of SQL or the schema. Because of that prior configuration, the OLAP engine "builds" and executes the appropriate SQL.
Mining is to build the application to specifically look at detailed analysis, often algorithmic; even more often misappropriate called "reporting.

Download Application Developer Interview Questions And Answers PDF

Previous QuestionNext Question
Can an ERP such as SAP help a business owner learn more about how business operates?Explain Extended Star Schema? How did it emerge?