Monday, October 9, 2017

This Week

1. Database Truth of the Week

“A DBMS using the RDM for all its functionality would be very limited. The RDM only requires that the declarative data sub-language employed by users for data manipulation -- has power not more expressive than first order predicate logic (FOPL), which implies acceptance of certain limitations on what users can do directly in the language, in return for
Language declarativity and decidability;
Semantic correctness and system-guaranteed logical validity;
Physical and logical independence;
                                                  --David McGoveran

2. What's Wrong With This Database Picture?

"The term database design can be used to describe many different parts of the design of an overall database system. Principally, and most correctly, it can be thought of as the logical design of the base data structures used to store the data. In the relational model these are the tables and views. In an object database the entities and relationships map directly to object classes and named relationships. However, the term database design could also be used to apply to the overall process of designing, not just the base data structures, but also the forms and queries used as part of the overall database application within the database management system(DBMS).

The process of doing database design generally consists of a number of steps which will be carried out by the database designer. Usually, the designer must:

  • Determine the data to be stored in the database.
  • Determine the relationships between the different data elements.
  • Superimpose a logical structure upon the data on the basis of these relationships.
Within the relational model the final step above can generally be broken down into two further steps, that of determining the grouping of information within the system, generally determining what are the basic objects about which information is being stored, and then determining the relationships between these groups of information, or objects." 
                             --Halil Lacevic, What is a Relational Database?,

3. To Laugh or Cry?

"In database, lot of information is stored in the format of tables.
  • Whole table is called as Relation
  • A row is called as Tuple
  • A column is called as Attribute
  • Two or more tables are interlinked by means of a common key. Foreign key will be there to unify common fields
As more tables are interlinked in the above way, it is called relational database management system."

"A database which is capable to keep relationship between two or multiple sets of data."

"When one element of data has a relationship with another."
                                  --What is a relation in database?,

5. Housekeeping

  • The new site header better reflects its purpose and content.
  • I'm working on a workaround to Blogger's 200 character limit on the labels attached to each post which constrains the number of labels and, therefore, searches. It will be driven by a comprehensive list of fundamental terms to which I will add definitions and publish as THE DBDEBUNK DICTIONARY OF FUNDAMENTAL DATABASE MANAGEMENT TERMINOLOGY. More details in next week's post.

6. Publications


7. Oldies but Goodies

The Data Exchange Tail - Part 2

8. Elsewhere

9. Of General Interest

10. The Sillicon Valley State: Technology as Mechanism of Tyranny and Nonhuman Destruction of Free Civilized Society


And Now for Something Completely Different -- The PostWest: Western Civilization on the Wane

My Observation: The American Way: Do your worst, then apologize

Must Read

  • I Believe Some of Valerie Plame's Best Friends Are Jewish "The article “America’s Jews Are Driving America’s Wars” uses variants of the word “Jew” 22 times. The word “neocons” appears only twice. I believe Plame is telling the truth when she says the subtlety was lost on her."
  • The new Labor and Democratic Party "Since 2015, Britain has been one election away from having an antisemitic prime minister backed by antisemitic voters. If current trends in the Democratic Party continue, in the not-so-distant future, the United States might be in the same position."

  • The Republican Attack on Feeding the Hungry "The moral test of government is how that government treats those who are in the dawn of life, the children; those who are in the twilight of life, the elderly; and those who are in the shadows of life, the sick, the needy and the handicapped."

  • Speaking Ill of Hugh Hefner "Hugh Hefner, gone to his reward at the age of 91, was a pornographer and chauvinist who got rich on masturbation, consumerism and the exploitation of women, aged into a leering grotesque in a captain’s hat, and died a pack rat in a decaying manse where porn blared during his pathetic orgies."

Pinch Me

Upside Down and Backwards

Reality Check


Book of the Week (Order via this link to support this site)


Video of the Week

Abacus: Small Enough to Jail

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