Re: Difference between Datamining and OLAP

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



That's a good definition, one way to think about it is that OLAP gives you
the power to quickly find patterns in your data through dimensional
modeling/fast query response/drill down/etc., whereas Data Mining explores
the data for you and extracts the siginificant patterns that can be used, as
Dejan says, for predictive analysis.

--

-Jamie MacLennan
SQL Server Data Mining
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@xxxxxxxxxx> wrote in
message news:urPGY5lPFHA.688@xxxxxxxxxxxxxxxxxxxxxxx
>> I'm pretty new to these terms.Just wondered if there is any difference
>> between OLAP and Datamining?
>
> Yes. OLAP is model-driven analysis, best suited for quick analyses of
> large
> quantity of data. Model (dimensions, fact tables) is prepared in advance,
> data structures are optimized for fast retrieval. Data Mining is
> data-driven
> analysis. It means you explore your OLTP or OLAP data, find patterns and
> rules, and then use them for predictions, for OLAP dimension, for OLTP
> soft
> constraints...
>
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>


.



Relevant Pages

  • Re: Analyst Services Question
    ... The decision of which storage mode to use ... OLAP because your data changes throughout the day, ... 3)You should use shared dimensions whenever possible instead of Private ... > that can only be used in certain OLAP cubes or OLAP databases. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Analyst Services Question
    ... > OLAP because your data changes throughout the day, ... > storage space, ... > 3)You should use shared dimensions whenever possible instead of Private ... >> that can only be used in certain OLAP cubes or OLAP databases. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Data Warehouse - Analyst Servervices question
    ... The beginning of the book mentions concepts such as OLAP databases and ... Another cocept mentioned at the start of the book is "private" dimensions ... that can only be used in certain OLAP cubes or OLAP databases. ...
    (microsoft.public.sqlserver.olap)
  • Re: File write error on pipe export
    ... OLAP and Data Mining options ... With the Partitioning, OLAP and Data Mining Scoring Engine options ...
    (comp.databases.oracle.server)
  • Re: Please help!
    ... MVP SQL - Colombia ... >>>>>Thousands of fact tables and dimensions, wow, impressive. ... anything more than that would be nightmare for OLAP ... >>>>>those cubes as updated as possible, ...
    (microsoft.public.sqlserver.datawarehouse)