Categories
Miscellaneous

Identifiers and the Properties of Relational Keys

IntelligentEnterprise : Celko On SQL: Identifiers and the Properties of Relational Keys printable version

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.

Categories
Miscellaneous Tools

gotAPI/HTML – Instant search in HTML and other developer documentation

gotAPI/HTML – Instant search in HTML and other developer documentation:

This is neat. I had to have OmniWeb fib about which browser it is, but cool!

(Via Hoffman Labs.)

Categories
Miscellaneous

the ETL Guy

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.

Categories
Miscellaneous

Factless Fact Tables

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.

Categories
Miscellaneous

Searchable Contents

If this site is maintained where it is currently my internal iSearch tools should work just fine, thank you.

Searchable

Categories
Miscellaneous

Replacement for Manila

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…