Re: drawbacks

You don't need to create a datawarehouse to mine your OLTP data. SQL Server
Data Mining allows you process your mining models directly from your source
database. You just need to create a data source object (in SQL 2005 you
would also create a data source view object in your project in Business
Intelligence Studio, where you can add calculated columns, etc) that point
to the source database.

>From a load-balancing perspective, note that Analysis Server will be making
connections to your source database server for each mining structure/model
processing operation so it will add to the querying load on your operational
database if you have multiple users processing mining models.

-Raman Iyer
SQL Server Data Mining
[This posting is provided "AS IS" with no warranties, and confers no
rights.]

"Tunga Torgal" <tungatorgal@xxxxxxxxxxx> wrote in message
news:uy93greZFHA.3320@xxxxxxxxxxxxxxxxxxxxxxx
> what are the drawbacks of using an existing OLTP database as a datasource
> for creating data mining models?
> I mean using the OLTP database without extracting its data to a data
> warehouse...
>
> thx in advance...
>
>


.

Relevant Pages

  • about "data mining with sql server 2005" book
    ... i bought a "data mining with sql server 2005" book.and i'm trying examples of the book. ... if you know,at first examples we use "movieClick" database. ...
    (microsoft.public.sqlserver.datamining)
  • Idiomatic Expressions to Operating System Architecture: Transforming Rigids
    ... <Subject: Re: Idiomatic Expressions to Operating ... <endpoint during a single session * DATABASE + by ... <statements is a new feature of SQL Server 2005. ...
    (sci.math)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)