From: | Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> |
---|---|
To: | David Fetter <david(at)fetter(dot)org> |
Subject: | Re: Fabian Pascal and RDBMS deficiencies in fully implementing |
Date: | 2006-06-13 20:28:27 |
Message-ID: | 448F1FEB.80201@cheapcomplexdevices.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
David Fetter wrote:
> On Tue, Jun 13, 2006 at 12:51:57PM -0400, Merlin Moncure wrote:
>> On 6/13/06, David Fetter <david(at)fetter(dot)org> wrote:
>>>> SQL was a quick and dirty hack...
>
> If there are better alternatives, they will need to show some
> real-world attributes, not mathematically-inspired fantasies, because
> they're not "better" unless actual people in real-world situations can
> use them.... that you can point to in real-world software that's
> actually deployed, please show it.
KDB [1] from KX Systems has both terse mathematical notations
to access data directly as well as an awkwardly(?) extended
SQL syntax to handle queries not easily handled by SQL alone.
Time-series related queries are one such case [2,3].
Examples can be seen various places on the web [3].
It has plenty of real-world usage on large databases at places
including Deutsche Bank, Fidelity Investments, JP Morgan,
Merrill Lynch, the US Army, etc.
>> the terse mathematical notation commonly used...
>
> Again, if you have a piece of software you can point to that does this
> thing, please do so.
I seriously doubt it follows Date or Pascal religiously, but
it does have a convenient and very terse mathematical notation
so might count as a real-world piece of software that you were
asking for.
[1] http://www.kx.com/news/press-releases/arthur-interview.php
[2] http://www.kx.com/news/in-the-news/sql-timeseries.php
[3] http://www.intelligententerprise.com/010327/celko_online.jhtml;jsessionid=NDIHEWXGL4TNKQSNDBNSKHSCJUMEKJVN
[4] http://www.cs.nyu.edu/courses/fall02/G22.3033-007/kintro.html
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2006-06-13 20:40:54 | Re: Short circuit evaluation of expressions in query |
Previous Message | Qiao Yang | 2006-06-13 19:13:11 | MAX() across partition tables |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-06-13 20:35:24 | Re: postgresql and process titles |
Previous Message | Lukas Smith | 2006-06-13 19:55:50 | Re: Proposal for debugging of server-side stored procedures |