Re: [GENERAL] Database INNOVATION

2010-10-20 Thread Brent Wood
Gotcha. Apologies for the digression, off your exact topic but consistent with the subject :-) I'm interested in both, PL/R & representational graphics from an analytical perspective, doing more than just retrieving raw or accumulated data with SQL. & also from the (mathemetical) graphic persp

Re: [GENERAL] Database INNOVATION

2010-10-19 Thread Joe Conway
On 10/19/2010 10:12 PM, Craig Ringer wrote: > On 10/20/2010 12:35 PM, Brent Wood wrote: >> Have a look at PL/R. > In this case, when I say "graph" or "tree" I'm referring to the concept > in the graph theory sense, not the "plot" sense. "object graph" not > "image representation of data". Analysi

Re: [GENERAL] Database INNOVATION

2010-10-19 Thread Darren Duncan
Craig Ringer wrote: On 20/10/10 13:12, Darren Duncan wrote: Never mind JSON. You can fix the outer joins problem and other issues simply by supporting relation-valued attributes, or in other words, row field values that are rowsets. You can for trees/forests yes. How would you handle more gen

Re: [GENERAL] Database INNOVATION

2010-10-19 Thread Craig Ringer
On 20/10/10 13:12, Darren Duncan wrote: > Never mind JSON. You can fix the outer joins problem and other issues > simply by supporting relation-valued attributes, or in other words, row > field values that are rowsets. You can for trees/forests yes. How would you handle more general graphs with

Re: [GENERAL] Database INNOVATION

2010-10-19 Thread Craig Ringer
On 10/20/2010 12:35 PM, Brent Wood wrote: > Have a look at PL/R. > > You can embed a command to generate a graphic using R via a user defined > SQL function, In this case, when I say "graph" or "tree" I'm referring to the concept in the graph theory sense, not the "plot" sense. "object graph" not

Re: [GENERAL] Database INNOVATION

2010-10-19 Thread Darren Duncan
Craig Ringer wrote: Now, personally, if we're talking "database innovation" what I'd like to see is a built-in way to get query results straight from the database as graphs of tuples and their relationships. Tabular result sets are poorly suited to some kinds of workloads, including a few incre

Re: [GENERAL] Database INNOVATION

2010-10-19 Thread Brent Wood
Have a look at PL/R. You can embed a command to generate a graphic using R via a user defined SQL function, This example from http://www.varlena.com/GeneralBits/Tidbits/bernier/art_66/graphingWithR.html HTH Brent Wood ===

Re: [GENERAL] Database INNOVATION

2010-10-19 Thread Craig Ringer
On 19/10/2010 10:12 PM, Mauricio Chamati wrote: > I am recomming to you guys to have an special "Section" for Audit tables. As we separate sequence in another seq, we should do the same for Audit tables. They have their own behavior, are less used, and so on. As a senior software architect, yo

Re: [GENERAL] Database INNOVATION

2010-10-19 Thread Scott Marlowe
On Tue, Oct 19, 2010 at 1:17 PM, Greg Smith wrote: > Scott Marlowe wrote: >> >> On a side note, MySQL is GPL licensed and cannot simply be taken.  The >> commercially licensed version is owned by Oracle / Sun, but the GPL >> code is quite free to be hacked and released and use according to the >>

Re: [GENERAL] Database INNOVATION

2010-10-19 Thread Chris Browne
mcham...@gmail.com (Mauricio Chamati) writes: > Postgree is the most amazing DB, even more it will be the only one that will > remain free (the good ones) as MySQL has been taken. In order to move on with > this project, as an Java Senior Architect, I am recomming to you guys to have > an special "

Re: [GENERAL] Database INNOVATION

2010-10-19 Thread Greg Smith
Scott Marlowe wrote: On a side note, MySQL is GPL licensed and cannot simply be taken. The commercially licensed version is owned by Oracle / Sun, but the GPL code is quite free to be hacked and released and use according to the GPL. As the MySQL documentation is not GPL licensed, such hacks w

Re: [GENERAL] Database INNOVATION

2010-10-19 Thread Scott Marlowe
On Tue, Oct 19, 2010 at 8:12 AM, Mauricio Chamati wrote: > Folks, > Postgree is the most amazing DB, even more it will be the only one that will > remain free (the good ones) as MySQL has been taken. On a side note, MySQL is GPL licensed and cannot simply be taken. The commercially licensed vers

[GENERAL] Database INNOVATION

2010-10-19 Thread Mauricio Chamati
Folks, Postgree is the most amazing DB, even more it will be the only one that will remain free (the good ones) as MySQL has been taken. In order to move on with this project, as an Java Senior Architect, I am recomming to you guys to have an special "Section" for Audit tables. As we separate sequ