Saturday, April 29, 2017

This Week

1. Database Truth of the Week

“… logic—is an analytical theory of the art of reasoning whose goal is to systematize and codify principles of valid reasoning. It has emerged from a study of the use of language in argument and persuasion and it is based on the identification and examination of those parts of language which are essential for these purposes. It is formal in the sense that it lacks reference to meaning. Thereby, it achieves versatility: it may be used to judge the correctness of a chain of reasoning (in particular, a “mathematical proof”) solely on the basis of the form (and not the content) of the sequence of statements, which make up the chain.” --R. R. Stoll

2. What's Wrong With This Database Picture?

"Constraints are categorized as follows:
  • Domain integrity Constraints
  • Entity integrity Constraints
  • Referential integrity Constraints
  • Not null
  • Unique
  • Foreign key
  • Check
  • Primary key
Constraints are always attached to a column not a table." --Daykar, SQL Constraints

3. To Laugh or Cry?

Question: "Can a database contain two identical records without a negative effect on the integrity of the database? Why or why not?"
Best Answer: "Sure, not an issue but it will mean you can get multiple hits for the same query. You have to take that into account in your program." --Identical records with Integrity (check all three answers)

 4. Publications


5. Oldies but Goodies

Schema, NoSQL & Database Management (presentation)

6. Housekeeping

I am overhauling the "And Now for Something Completely Different" (ANFSCD) section of the This Week posts.
  • Indications of the demise of Western civilization will be posted at to The PostWest blog, with a link posted to ANFSCD;
  • ANFSCD here will focus on the acceleration of the demise and dehumanization by malevolent corporate technology out of control.

7. Of Interest

And Now for Something Completely Different

The Demise of Western Civilization

This week @The PostWest

The Technology Dystopia

Reality Check

AI could build new drugs faster than any human team, but No one really knows how AI algorithms do what they do

Upside Down and Backwards

Technology Takes from the Poor and Gives to the Rich

Note: I will not publish or respond to anonymous comments. If you want to say something, stand behind it. Otherwise don't bother, it'll be ignored.

No comments:

Post a Comment

View My Stats