Follow @DBDebunk Follow @ThePostWest


1.  Quote of the Week

I do not understand your first point. Even a database designed with only 1NF can have integrity if other methods are used to ensure that integrity. [Higher n]ormal forms can guarantee the absence of various integrity issues, but the lack of a normal form does not guarantee the presence of the integrity issue. I remember writing pages of code to do just that in the early days of RDBMS products before normal forms (i.e., referential integrity) was strictly enforced by the DBMS. --LinkedIn.com

Note: My (first) point was that the minimal relational mandate is 1NF, but that full normalization (5NF) is desirable for practical reasons.


2. To Laugh or Cry?

What is difference between storing data in traditional and modern way in database?

3. Online

What is Surrogate Key, why it is used, is it Primary Key?

Apropos my just published paper on keys.


4. Data management is important, after all.

Point-of-sale malware infecting Target found hiding in plain sight

(Note the last sentence in the article).

So is database design

Poor Data Management Blinded Chase to Madoff Fraud

5. And now for something completely different

• Why It Makes Sense to Pay Beautiful CEOs More 
• What are the Best Looking Data Models 
• THE VISUAL ORGANIZATION

Looks like a pattern.

Follow @DBDebunk Follow @ThePostWest

Pls see PAPERS page for the current version of this paper, when it becomes available.

Follow @DBDebunk Follow @ThePostWest


Conveying the theoretical foundation of database management to practitioners without losing either precision/rigor, or the audience is a non-trivial endeavor, the skill for, or interest in which very few possess. More often than not one or the other are lost.

In Relations and Relationships I referred to the following LinkedIn exchange:

AT: ... William Kent and his book "Data and Reality" [1978] ... is devoted to "attributes", and (in my words) William confesses that he can not distinct [sic] between "relationships" and "attributes". Thus, the later might be completely redundant. 

GE: This confusion of entities vs. attributes has been with us a long time. Several years ago [a student] ... discovered a paper ... that discussed this dilemma. He proposed calling the thing, which we could not determine whether it was an entity or an attribute, an "entribute." Beautiful, eh? That was in 1939.

Follow @DBDebunk Follow @ThePostWest


1.  Quote of the Week

As you might have gathered, I think NoSQL is technology to be taken very seriously. If you have an application problem that maps well to a NoSQL data model - such as aggregates or graphs - then you can avoid the nastiness of mapping completely. Indeed this is often a reason I've heard teams go with a NoSQL solution. This is, I think, a viable route to go - hence my interest in increasing our understanding of NoSQL systems. But even so it only works when the fit between the application model and the NoSQL data model is good ... And of course there are many situations where you're stuck with a relational model anyway. Maybe it's a corporate standard that you can't jump over, maybe you can't persuade your colleagues to accept the risks of an immature technology. In this case you can't avoid the mapping problem.
--martinfowler.com

2. To Laugh or Cry?

Which database type to use (one big database or many smaller)?

3. Online

Check out the last update's exchange--more comments have been posted since:

RELATIONAL DATABASE

4. Elsewhere

Set In Stone

5. And now for something completely different

Multivitamins Doctors Say Stop Taking Them

Half of U.S. adults take vitamins, supplements routinely

Draw your own conclusion.

Follow @DBDebunk Follow @ThePostWest


To all my readers and colleagues, happy holidays and a healthy and prosperous new year!

Follow @DBDebunk Follow @ThePostWest

I've finally found a concrete case to share that demonstrates most of the costly consequences of what happens when you engage in database practice without a good grasp of data fundamentals. A web application developer authored the article describing this case. The developer is competent enough to give an excellent post-facto description of the project that enables assessment but, as is usually the case, fails to associate problems with poor foundation knowledge. That's where I come in.

Follow @DBDebunk Follow @ThePostWest


1. Quote of the Week

If SQL is based on relational algebra which is based on set theory where the concept of null set (empty set) is an axiom of the theory. In this theory empty set is not the same thing as nothing. A point that confuses many people.

Relational algebra is based on 3VL predicates, that is, the answer to any predicate can have three states true, false or unknown. Unknown is caused by the use of a operator on an the absence of a value (null). Within relational algebra null is not to be treated as a value but merely a marker of unknown (absence of a value).

None of this is rocket science and I suggest doesn't result in bad implications. I suggest the so called "bad implications" are only introduced as people use null as a patch for problems for example the division by zero. indeterminate state, open ended ranges, data states to name a few. That is, the issue is not the concept of null but its abuse as a patch for other issues. 
--LinkedIn.com

2. To Laugh or Cry?

Why You Should Never Use MongoDB

3. Online debunking

RELATIONAL DATABASE

4. Elsewhere

Next gen NoSQL: The demise of eventual consistency

5. And now for something completely different

23andMe Is Terrifying, But Not for the Reasons the FDA Thinks