You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by bbobier <bo...@gmail.com> on 2007/09/18 21:03:40 UTC

Rollups and Linear Regression

Quick question:  Is it true that Apache Derby cannot handle Rollups and
linear regression functions?

Thanks!

-Bruce.
-- 
View this message in context: http://www.nabble.com/Rollups-and-Linear-Regression-tf4476360.html#a12763822
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Rollups and Linear Regression

Posted by bbobier <bo...@gmail.com>.

Last question: Materialized views are also not yet supported, correct?  (I'm
trying to do a quick evaluative comparison of derby and sql anywhere to see
which is best for me)



Bryan Pendleton wrote:
> 
>> I see that feature T431 etc (grouping, rollup, cube, and grouping sets)
>> are
>> included in the "todo" list for derby; Are linear regression and other
>> statistical functions also on this list?
> 
> I'd like to see Derby implement all of the SQL Standard OLAP features, but
> that's a large set and will take a lot of time.
> 
> The more people that join in the effort, obviously, the faster it will go!
> 
> thanks,
> 
> bryan
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Rollups-and-Linear-Regression-tf4476360.html#a12780689
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Rollups and Linear Regression

Posted by Bryan Pendleton <bp...@amberpoint.com>.

> I see that feature T431 etc (grouping, rollup, cube, and grouping sets) are
> included in the "todo" list for derby; Are linear regression and other
> statistical functions also on this list?

I'd like to see Derby implement all of the SQL Standard OLAP features, but
that's a large set and will take a lot of time.

The more people that join in the effort, obviously, the faster it will go!

thanks,

bryan

Re: Rollups and Linear Regression

Posted by bbobier <bo...@gmail.com>.

Thanks Bryan,

I see that feature T431 etc (grouping, rollup, cube, and grouping sets) are
included in the "todo" list for derby; Are linear regression and other
statistical functions also on this list?

Cheers,
Bruce. 

Bryan Pendleton wrote:
> 
> If you're referring to Features T611, T612, T431, and T433 of the SQL 2003
> standard, some efforts are underway to add that functionality to Derby,
> see these pages for more:
>    https://issues.apache.org/jira/browse/DERBY-581
>    https://issues.apache.org/jira/browse/DERBY-2998
>    https://issues.apache.org/jira/browse/DERBY-3002
>    http://wiki.apache.org/db-derby/OLAPOperations
> 
> We'd love to have additional members of the community join in this effort!
> 
> thanks,
> bryan
> 
-- 
View this message in context: http://www.nabble.com/Rollups-and-Linear-Regression-tf4476360.html#a12779995
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Rollups and Linear Regression

Posted by Bryan Pendleton <bp...@amberpoint.com>.

> Quick question:  Is it true that Apache Derby cannot handle Rollups and
> linear regression functions?

If you're referring to Features T611, T612, T431, and T433 of the SQL 2003
standard, some efforts are underway to add that functionality to Derby,
see these pages for more:
   https://issues.apache.org/jira/browse/DERBY-581
   https://issues.apache.org/jira/browse/DERBY-2998
   https://issues.apache.org/jira/browse/DERBY-3002
   http://wiki.apache.org/db-derby/OLAPOperations

We'd love to have additional members of the community join in this effort!

thanks,

bryan