Re: sql-99 array type

Darnel Castnblast wrote:

Are there any databases that have implemented the
array type, found in the sql-099 spec?

Doesn't this (array types in sql) mean
relational tables could model many-to-one relations
in a more tree-like manner, where the attachee table
holds pointers to the attacher tables of a
many-to-one relationship?

If so, this would make automated GUI form
generation (matching a schema) almost trivial.

And everything else almost impossible.

(I forget what product implemented it, but I recall Dennis Shasha is fond of some product that supports something called an arrable. I found the idea a flawed pollution of the logical data model created solely for performance, but you might enjoy it.)
.

Relevant Pages

  • sql-99 array type
    ... array type, found in the sql-099 spec? ... Doesn't this (array types in sql) mean ... where the attachee table ...
    (comp.databases.theory)
  • Re: sql-99 array type
    ... array type, ... Doesn't this (array types in sql) mean ... in a more tree-like manner, where the attachee table ...
    (comp.databases.theory)
  • Re: API works fine, but returns no results to ASP front end
    ... You shouldn't use dynamic SQL for this, it will lead to over parsing ... and shared pool fragmentation. ... You already have the in list in an array type, hopefully a SQL one, so ...
    (comp.databases.oracle.server)