THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Microsoft OLAP by Mosha Pasumansky

WolframAlpha

Integration of BI and Search became a popular subject couple of years ago. No doubt, it was heavily influenced by the “Google revolution”. Search is a hugely successful application. It features simple and natural UI - free form text, yet it is extremely powerful and gives access to pretty much all of the world freely available information (i.e. on Internet). Sounds very close to the mission of the BI. So several of BI vendors tried to jump on the Search bandwagon, and integrate search-like functionality into the products. None were very successful with it – it didn’t catch up.

Having worked on BI for quite a while, and recently having worked on Search, I grew more and more skeptical that meaningful integration of BI and Search was possible. It just seemed too difficult to do anything non trivial. (and it didn’t help to remember English Query fiasco, even though its last version could talk to the SSAS cubes).

But then I saw today WolframAlpha, and I was completely awed by it. If it could do even half of the things that you see in the promotional video – it is pretty amazing. And with Stephen Wolfram genius behind it – I have no doubt it really can do all of that. It launches tomorrow, so we will have a chance to try it out for real, and in the meantime – watch this screencast video of what it promises to do: http://www.wolframalpha.com/screencast/introducingwolframalpha.html.


Published Thursday, May 14, 2009 11:52 PM by mosha

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

I am awed by Wolfrom|Alpha | 3DMX Consulting Blog said:

May 15, 2009 6:19 AM
 

WolframAlpha « SQL Kit said:

May 28, 2009 9:49 AM
 

Igor Krupitsky said:

I really liked Wolfram Alpha.  I wonder want it would take to create the same kind of web interface for Analysis Services... I guess it might look like the English Query (in SQL Server 2000) but with web interface and without the initial setup.  

It would have intellisense (like Google suggest) but would suggest names of dimensions, hierarchies, levels, measures and children or the most common queries.

If you enter just the name of the dimension you will see a grid with the default dimension hierarchy on the rows and the default measure on columns. If you enter two dimension names you will see a cross join the two dimensions or rows and the default measure on columns. You will still pick the cube to query.

Like Wolfram Alpha, it would explain assumptions and show the interpretation (MDX).

June 16, 2009 5:11 PM

Leave a Comment

(required) 
(optional)
(required) 
Submit
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement