Joinutility seperatorLogin utility separator Infobright.com
   
 
Analysis Expressions other than SQL
Posted: 25 August 2010 07:53 AM   Ignore ]  
Newbie
Avatar
Rank
Total Posts:  5
Joined  2010-02-18

In Microsoft’s PowerPivot for Excel, the Data Analysis Expressions (DAX) language allows users to define custom expressions that boil down to powerful queries on the VertiPaq columnar database (embedded in SQL Server and Excel).  Creating a language with the same power on top of Infobright is inhibited by the need to first convert to SQL before accessing the internal hybrid-columnar structures.  Can/will Infobright provide a language/API with more power than SQL (perhaps something similar to Pig Latin in Apache Pig)?

Profile