Subject | Re: [firebird-support] Re: How are foreign keys implemented, cascade update performance |
---|---|
Author | unordained |
Post date | 2010-06-11T21:57:45Z |
---------- Original Message -----------
From: "hvlad" <hvlad@...>
like in a REAL rdbms where the foreign key is actually a internal pointer to the
referenced table and cascades are "instant" no matter how big the database
Here you go:
http://en.wikipedia.org/wiki/Codd's_12_rules
Oh, but wait. Rules 1, 2, and 8 imply relational databases must use values, not
pointers? Oops!
</sarcasm>
-Philip
From: "hvlad" <hvlad@...>
> > One of my data models use natural keys that can change overtime. How areforeign keys and cascades implemented in the latest version of Firebird? Is it
like in a REAL rdbms where the foreign key is actually a internal pointer to the
referenced table and cascades are "instant" no matter how big the database
>------- End of Original Message -------
> Could you point us to the documentation to the such "REAL rdbms"
> where your statement is confirmed ?
>
> Regards,
> Vlad
Here you go:
http://en.wikipedia.org/wiki/Codd's_12_rules
Oh, but wait. Rules 1, 2, and 8 imply relational databases must use values, not
pointers? Oops!
</sarcasm>
-Philip