OLAP and data mining are various data access methods, which use query language to access data in a data store. One such data store is a data warehouse, which is usually hosted on a relational database management system (DBMS).
The primary query language in use today is structured query language (SQL). Most data access tools are simply SQL generators. Though SQL could potentially get rewritten/optimized by the DBMS, effective SQL generation by the tool still is extremely important to the efficacy of the tool. This is an area well worth exploring with data access tools during selection, in addition to the user interface and other factors.
OLAP is almost meaningless as a concept. Historically, it meant access to dimensional data stores, which are organized as metrics surrounded by "dimensions." The data access was really "built in" to the data model of the data store. It's not to be confused with MOLAP, or multidimensional OLAP, which is a physical implantation of a denormalized dimensional data model.
Dig Deeper on Business intelligence data mining
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
Should operational reporting come out of a data warehouse? Get an expert's take, plus learn about the relationship between operational systems, ... Continue Reading
Find out how you can learn business intelligence (BI), get business intelligence training and discover why analytics is the key to marketing efforts ... Continue Reading