I developed a traditional Database application for my college's library using the .NET 2.0 framework, which is running fine.
Now, I want to see the power of Data Mining in general & OLEDB for DM in particular, to help me mine information & patterns from the mostly transactional data generated by the library daily, like the rush hours, the average issue duration for a book, books that are issued more frequently, books that are issued to students from multiple streams etc. etc.
Now, I have heard MSOLAP provider, ADOMD data provider, SQL Server Analytical Services, OLEDB for DM libraries etc. are required for Data Mining.
Now, what exactly is each of these tools? Are they independent servers for DW & DM like SQL Server for DBs, or they are libraries for extending SQL Server itself?
Moreover, are separate libraries required for OLAP & Mining?
I have SQL Server Express Edition. I believe that they are extensions for SQL Server. So, will they work with Express Edition? If not, are their Express Editions available (like OLEDB for DM Express!!!!) that are compatible with SQL Server Express.
Thanx in advance if you take time to answer so many questions...
Hi Rahul,
SQL Analysis Services is the core piece of all the technologies you're discussing (Data Mining, OLAP, ADOMD, etc.) and it is not included in SQL Express. There is no Express version of the Analysis Services line of products, but you can get the Trial version of SQL Server which includes all features, but is limited for Evaluation purposes and expires after 180 days. You can obtain the trial from http://www.microsoft.com/sql/downloads/trial-software.mspx.
MIke
|||But do I have to download & install libraries for each of them separately, or SQL Analysis Services encapsulates all of them?|||
hi,
the Trial edition includes "all features"... you cn select what to install while running the installation wizard..
regards
No comments:
Post a Comment