Impedance Mismatch?

#1

On Sep 30, 8:17*am, Tegiri Nenashi <tegirinena... (AT) gmail (DOT) com> wrote:

Quote:

On Sep 30, 3:32*am, Tony Andrews <tony.andrew... (AT) gmail (DOT) com> wrote:

*create table applications_with_immobolisers (application_id
references applications primary key);
... etc.

That may be the right approach in a theoretical true RDBMS, but I'm
pretty sure it would get me sacked as a lunatic in any SQL-based DBMS
team!

Ah, this is why one don't usually find any unary relation in SQL Dbms!
This is very odd from theoretical perspective as one might expect
there are many more unary relations than binary ones, many more binary
than ternary and so on (akin to Zipfian distribution). Well SQL made
creating a table more expensive than adding an column, that is one of
its many implementational sins.

Expanded this idea a little:
http://vadimtropashko.wordpress.com/...ance-mismatch/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Impedance Mismatch?

comp.databases.theory comp.databases.theory

Impedance Mismatch? - 09-30-2010 , 12:09 PM