Follow @DBDebunk Follow @ThePostWest

See series starting at:

The Principle of Orthogonal Database Design Part I

Follow @DBDebunk Follow @ThePostWest

1.
A link to my latest All Analytics column was posted on the FP ONLINE page.

2.
A new Quote was posted on the QUOTES page.

3.
A new To Laugh or Cry? item was posted on the LAUGH/CRY? page. Here's a discussion of it. Of course, strictly speaking, our objection is to XML databases/DBMSs. But see if you can figure out what else is wrong with other claims made for it.

4. 
C. J. Date's new book VIEW UPDATING AND RELATIONAL THEORY was added to the recommended books widget on the Home page. Please support this site by ordering via it.

Follow @DBDebunk Follow @ThePostWest

1.
For various reasons I postponed the European tour to the October-December timeframe. Anybody interested in organizing a seminar or presentation, or can put me in touch with somebody who is, please email me. (This applies to the US too).

2.
This week's Quote and Laugh or Cry? item (video) continue the saga of Erik's Meijer ACM article and the letter in response to it by David McGoveran and Chris Date (see Site Update 12/29/12).

Carl Hewitt (in the video) submitted his own letter, Relational Model Considered Obsolete, in response to David's and Date's, defending Meijer's argument. I substituted the link to it, as I could not drop anything from the letter. Here's a discussion of it.

David, who submitted the video, comments:

Carl Hewitt is pushing his trademarked "DirectLogic(TM)" which he asserts "tolerates inconsistency" (i.e., no law of the excluded middle, no proof by contradiction) which he asserts is essential for large systems (e.g., cloud computing). According to him, the relational model is based on logical consistency, so it must go. He asserts that we need a new kind of database built on his DirectLogic(TM) and Actors (his model of highly concurrent computing for which he is famous and which I admire). "Train software engineers to embrace inconsistency" he says! "We have to get over the fact that inconsistency is a bad word."

The esteemed Prof. Hewitt's complaints about the relational model demonstrates his astounding ignorance of it and his recklessness. Every bullet in his CACM letter (a) has nothing to do with, and (b) are not weaknesses of the relational model. (Frankly, it makes me now question my prior opinions of his Actor work. Was it just as bad as this and I simply did not notice?)

Those of us with knowledge of the relational model and real experience in data modeling know every well how to handle inconsistencies - without giving up on the goal of consistency where it is appropriate. Hewitt likes to point to contradictory opinions as an example of inconsistency to be tolerated. Or temporary inconsistencies. We can model these just fine using relational - in fact, trivially. And, by the way, Carl, systems based on the relational model do more with data provenance than any other data model in existence. How does "DirectLogic(TM)" - which "embraces contradictions" - even detect inconsistencies let alone resolve those that can and should be resolved? Is its data provenance contradictory too?

"Tolerating inconsistencies by designing the logic underlying your systems to permit it"? That's just insane! Anyone who has built a real-time control system (think defibrillator, aircraft flight control, nuclear power plant, or crane operations at a port) knows this. The suggestion that the financial industry (banks, trading systems, etc.) should ever permit inconsistent transactions is simply absurd. I sure don't want these people touching (let alone building) the systems I depend on for life, safety, money management, etc. If Hewitt, Meijer, et al are the new architects of cloud computing, then maybe the new name for cloud computing should be "#@!* in the sky" computing! Ever hear of GIGO, Carl?

I think by large systems Meijer and Hewitt think Google, Facebook, Twitter, Zynga and the like, but they really don't realize it. The damage from inconsistencies in their software causes little damage. They simply cater to the spreading delusion that emulating the software of these companies -- which already exhibit serious problems--they will be as successful as them, no matter what their business is and what is the value of data for it.

This is hardly surprising giving the increasingly blurred line between academia and industry.

3.
Speaking of which, Toon Koppelaars writes:

Academia first created the problem, by advocating all logic be removed from the dbms-layer. And now they come up with research to fix that.

• StatusQuo: Making Familiar Abstractions Perform Using Program Analysis
• StatusQuo: Automatically Refactoring Database Applications for Performance

The paper could have been a one-liner: don't not use the dbms-layer.

This is such a profitable business that is SOP in the IT industry. The academia, which is increasingly just a branch of the industry, has caught up. To get funded for research with such results--it's good work if you can get it.

It's been a while since I predicted that we are going back to the apps+files days. Almost everything that's happening is some aspect of that.

3.
An interesting and not unrelated LinkedIn discussion: Software Structural Erosion The Shame, The Heartbreak & The Cost. Which explains the following from a friend in response to my reluctance to upgrade to the latest Word version:

I can guarantee that you will hate the UI of the new version. It needs a huge screen to be usable. I like to work split screen as I have to do a lot of comparison between text and website which is why I have a 2560 x 1650 monster here. Word is just about usable in half of the screen but at my customers with slightly less screen real estate it's no longer possible. Resizing a GUI so that the toolbar works but text occupies only a third of  the screen says an awful lot about software development over the last ten years.

It's probably better for Dijkstra that he did not live to see all this, which he predicted.

Follow @DBDebunk Follow @ThePostWest

1.
A new Quote of the Week, by two MIT professors, no less, was posted on the QUOTES page. If you believe the second paragraph, I have a bridge in Brooklyn to sell you. Read the whole article that puts the hype in perspective for a reality check.

Apropos which, more validation of the deterioration of education:

Don't Let Math Pull the Wool Over Your Eyes


2.
A new To Laugh or Cry? item was posted on the LAUGH/CRY? page. A good example of howone becomes a database professional.

3.Sima Ilic (via email): 

I had the opportunity to play with SIRA_PRISE for the past month or so and it's a fantastic TRDBMS. In my opinion it deserves to be mentioned as a TRDBMS software on DBDebunk.

Follow @DBDebunk Follow @ThePostWest

See Integrity Is Not Only Referential.

Follow @DBDebunk Follow @ThePostWest

1.
The new Quote of the Week posted on the QUOTES page is a complement to the previous quote and is by the same author.

2.
Both the quote and the new To Laugh or Cry? item posted to the LAUGH/CRY? page have to do with the author referenced in my prvious post, The Clouding Syndrome. Does he really think that titling his article the way he did elevates him to Codd's level?

My friend David McGoveran has some comments forthcoming, but in the meantime perhaps this is closer to reality.

3.
Added to FP ONLINE page:

• My latest All Analytics column.
• A LinkedIn exchange in which I participated (as of this writing my comments are not posted yet). One of the participants recommended the very same article by Meijer mentioned in 1.

4.
For quite a while I just could not display a LinkedIn Share button after each post, next to the other buttons provided by Blogger, no matter what I did and neither Google, nor LinkedIn helped. I was finally able to display it at the bottom of posts, but not exactly where I wanted. I am working on relocating it, but in the meantime it is usable where it is.

Follow @DBDebunk Follow @ThePostWest

Over the years I got enormous and nasty flak for my arguments about the sorry state of foundation knowledge in the industry, the contamination of academia by it and the increasing deterioration in both.  On one occasion, my claim that the designers of SQL did not really understand the relational model was dismissed as utter nonsense. But if that made me a crank, so were Ted Codd and Chris Date.

My friend Jim Lowden emailed me:

Last month [there] was a hopeless article All Your Database Are Belong to Us about DBMSs [in CACM] so badly mistaken, that it was too dreary even to reply. [The author] managed to get the Closed World Assumption pretty much backwards, if that's possible.