SQL Server Gems

Thursday, June 14, 2007

BI on Windows Mobile

Recently, I have been sharing about the merits of using SQL Server Compact Edition, and how it provides a unified data storage solution for both mobile devices as well as desktop scenarios. In addition, one of the advantages of using SQL Server Compact Edition is how it can support applications which are occasionally connected.

Was thinking if we could push a scaled-down version of Analysis Services (light-weight data mining algorithms) onto the SQL Server Compact Edition, it will provide BI on the move!

The key idea is to use SQL Server Compact Edition as the data store, and have an Analysis Services-like layer that can stores the light-weight data mining model in SQL Server Compact Edition. The data mining model can then used to make predictions. Whenever SQL Server Comapct Edition is connected, it can make use of Sync Services to sync with the data mining model residing in SQL Server.

Just some thots...

0 Comments:

Post a Comment

<< Home