Sunday, November 23, 2014

Weekly Update UPDATE 2

Housekeeping: I have added a link to Nijssen's paper The Entity-Relationship Model Considered Harmful to FUNDAMENTALS on the HOME page. UPDATE 2: The paper is fine if read with a PDF viewer other than
Adobe Reader XI (11.0.09).

1. Quotes of the Week
Platfora’s mission is to empower customers to transform their businesses into fact-based enterprises. Platfora's Big Data Analytics Platform masks the complexity of Hadoop, making it easy for customers to understand all the facts in their business...
Q: I don't know what the different between detect inference in database and prevent it, any help?
A: Why would you want to prevent inferences that a DMBS makes? That's where the power of it is.
2. To Laugh or Cry?
Graphs: A Better Database Abstraction
3. Online debunkings

4. Interesting elsewhere
You Too May Be A Victim Of Developaralysis
H/t Will Sisson.

5. And now for something completely different 
  • About The PostWest
If they do this:
Fatah official calls for blood to 'purify' Jerusalem of Jews
PA airs 'anti-Semitic' film as tensions mount in Jerusalem
Four killed in terror attack at Jerusalem synagogue
then obviously we should do this:
Croatia likely to recognize Palestine as a state MidEast
Sweden To Recognize State Of Palestine
Spanish Parliament Calls on Rajoy to Recognize Palestine
UK lawmakers vote to recognize Palestine as a state
and this
EU threatens 'further action' to protect two-state solution
EU considering 'sanctions' against Israel over settlements
Makes perfect sense. So what else is new?

Sunday, November 16, 2014

Natural, Programming and Data Language

William Sisson writes:
Thank you for posting the Dijkstra piece On the foolishness of natural language programming. It is a very interesting read.

I agree completely with Dijkstra that using natural language as a programming language is neither feasible nor desirable. It is not possible to pose precise questions in natural language and if you pose an imprecise question then you cannot expect a precise answer.

Sunday, November 2, 2014

Weekly Update

1. Quote of the Week
Those who argue for natural keys typically do so from a position of philosophical purity, as is the case in the Simple Talk article you cited. In my (25+) years of experience, people who argue from this position are long on education and short on real-world experience. In the real world just about every natural key I've ever come across is subject to duplication and/or redefinition. There are very few cases outside of smallish code tables where it is practical to take the philosophical high ground regarding natural keys.

2. To Laugh or Cry?
R2G a Tool for Migrating Relations to Graphs
H/t Erwin Smout.

3. Online debunkings

4. Interesting elsewhere
The Delusions of Big Data
Must read.

5. And now for something completely different
Ebola-- Failures of Imagination
Not to worry, America, Ebola will go to India first.
Can you detect the stealth animals hiding in all these pictures?

About The PostWest:
Jihadism is OK as long as it kills Jews. Nice people. Let's ...
Irish parliament calls on government to recognize Palestine
... give them a state. Really?
Pat Condell: 'Boo Hoo Palestine'

Sunday, October 26, 2014

Weekly Update

1. Quote of the Week
Q: What's the key technical skills for Data Modeling? 
A: Erwin or Rational or phycial [sic] modelling or conceptual modelling or Logical modelling. 
NULL means data is not available, nothing
In case you were wondering.

2. To Laugh or Cry?

Oldie, but goodie from old dbdebunk:
On a Pile of ... what?

3. Online debunkings

4. Elsewhere

5. And now for something completely different
CDC blames cuts for Ebola response, pays millions in bonuses

About The PostWest:
Never again? Think again: they're at it again, to finish the job.
The Bible's Buried Secrets

Sunday, October 19, 2014

Precision, Procedurality and SQL, Part 1

 by Erwin Smout and Fabian Pascal

"To be as precise as we possibly can is not a luxurious mannerism that the academic prig can afford himself in his (supposedly!) sheltered environment; for people facing the problems of "the real world" it is a Must." --E.W. Dijkstra, An Open Letter to L. Bass

From In Some Cases illustrating drawbacks of SQL in data computing and analytics
The computing power of SQL for mass structured data is complete, that is to say, it is impossible to find anything that SQL cannot compute. But its support layer is too low, which can lead to over-elaborate operation in practical application.
One of the four aspects of this "over-elaboration" is "computation without substep", but before we comment on it, the article glosses over an important matter.

Sunday, October 12, 2014

Weekly Update

Housekeeping: I have added FUNDAMENTALS links on HOME page to:

 1. Quote of the Week
I am teaching a database design course next year. What do you think should be covered in an introductory course?
I have a requirement for an ERwin data modeler (Logical, Physical, 3NF and Star Schema).

2. To Laugh or Cry?
What would be key entities in Automotive Industry MDM

3. Online debunkings

4. Must read elsewhere
Out of the Tar Pit

5. And now for something completely different
Ig Nobel Prize Winners
Cry, don't laugh.
Hey There Little Electron, Why Won't You Tell Me Where You Came From
Israel is holding back channel talks with the 'Palestinian Authority' relating to Gaza, in which it is making concessions and receiving nothing in return.
The Tower cites a Wall Street Journal report that indicates that Western negotiators are so desperate for a deal with Iran that they are offering more significant sanctions relief for a deal that would not stop Iran from developing nuclear weapons.
Why the West is PostWest: The Blackmailer Paradox (Aumann is Nobel laureate in economics).