Uniqueness is Global, Not Local
Everyone agrees that an identifier should be unique. But new database programmers often think that being locally unique is good enough. This leads them to cheerfully use a proprietary auto-increment or IDENTITY column as a PRIMARY KEY instead of as a proper relational key. Aristotles Law of Identity is usually stated as “A is A,” but there was a lot more to it than a formula. Every entity has a nature and follows its nature; every entity is separate and unique from all others in the universe.
This is neat. I had to have OmniWeb fib about which browser it is, but cool!
(Via Hoffman Labs.)
the ETL Guy
Welcome! You might be wondering, “What the heck is ETL?” If that’s the case, you’ve come to the right place. To participate in the conversations, please register and sign in.
DBMS – September 1996 – Data Warehouse Architect
Over the past year I have given many examples of fact tables in dimensional data warehouses. You should recall that fact tables are the large tables “in the middle” of a dimensional schema. Fact tables always have a multipart key, in which each component of the key joins to a single dimension table. Fact tables contain the numeric, additive fields that are best thought of as the measurements of the business, measured at the intersection of all of the dimension values.
If this site is maintained where it is currently my internal iSearch tools should work just fine, thank you.
It would seem that there isn’t much internal support for Manila at the U. I have a few, topical Manila sites that I probably want to preserve and/or migrate.
MT is a possibility…