Viewing 6 posts - 1 through 6 (of 6 total)
Since I deal with different RDBMS's I use COUNT(1) or COUNT(primarykey).
In some SQL-compliant databases, COUNT(1) can return different results than COUNT(*).
January 30, 2015 at 3:39 am
I think you miss the most critical points of EAV data models:
a. "models" in general, not just data models, are abstractions that help humans understand a process or a system....
January 21, 2013 at 3:05 am
The auditing entity is asking for an ERD, or Entity Relationship Diagram. In database modeling terms, an ERD represents a Conceptual Model (this is the highest level in a...
June 30, 2011 at 3:57 am
Tom,
So you're "down" on Chris Date? Don't you give him credit for authoring the most widely used textbook on relational database structure and SQL?
Or is it that you liked...
March 8, 2010 at 8:52 am
I had never heard of a 'bridge' table in my 30 years of relational database design and modeling.
So I was surprised to see that the author, obviously a newcomer to...
March 4, 2010 at 9:34 am
You point out, with painful illustration, the "achilles heel" of using migrated primary keys in database design: the keys can multiply rapidly, making it very tiresome to construct "join...
September 8, 2009 at 12:21 pm
Viewing 6 posts - 1 through 6 (of 6 total)