Sunday, October 22, 2017

This Week

1. Database Truth of the Week

"The original normal form and the later First Normal Form (1) are distinct. In the early 1969 RDM there was only "the normal form" of relations [a term Codd borrowed from FOPL]. It was based on the initial version of the join operation, which was different than today's join. Had 1NF and further normalization to at least 2NF had been introduced then, the normal form would have made no sense, as there would have been then multiple normal forms, which make sense only with the post-1970 join definition currently in use. Thus, there is no way to answer "what is the difference between the original normal form and 1NF?" without taking into account the definition of join, and -- if defined as we now do -- no way to understand the original normal form, except to say that in the context of the original join definition it would correspond to today's Fifth Normal Form (5NF). This is why a relation is really in 5NF by definition, not in 1NF as per current understanding." --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?

"A relational database is one where entities (a.k.a. tables) have the ability to establish associations with other entities. These relationships are conceived by associating the foreign key of one entity to the primary key of another. For instance, say I have an Employee entity and a Company entity. Both tables would have a primary key that is used to identify each record in the table. The Company table’s primary key field might be called CompanyID or just simply ID. It can be named anything as long as it’s designated as a unique value (usually an auto incrementing integer) that identifies a specific record."

"A relational database is a database (storage of data) that separates data into its component parts for efficient examination, while continuing to connect them together in something called a relation."

"A relational database is a way of organising data tables that is efficient in terms of storage used."

"A relational database is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables."
"A relational database stores information in a structured format called a schema. This schema is defined according the rules or database normalization. These rules are meant to ensure the integrity of the data." --What is a Relational Database?,

5. Housekeeping

Due to a newly overhaul of this site planned for 2018 (1) the DICTIONARY OF DATA FUNDAMENTALS project is being revised for integration with it and (2) the TERMINOLOGY page has been renamed FUNDAMENTALS.

Details about the overhaul and how the DICTIONARY and FUNDAMENTAL page fit into it will be provided in a future post.

6. Publications

7. Oldie but Goodie

The Future of RDBMS - Part I (links may be dead)

8. Elsewhere

9. Of General Interest

10. The Sillicon Valley Dystopia: Technology as Mechanism of Tyranny and Non-human Destruction of Civilized Free Society

And Now for Something Completely Different: The Sinking Western Civilization and the PostWest


My Take 

Coding is not education, but the opposite thereof; and education is not job training
For what education is, see my comments (as sgeneris) to I'm a 19 year old high school dropout

Must Read

"The American empire is coming to an end. The U.S. economy is being drained by wars in the Middle East and vast military expansion around the globe. It is burdened by growing deficits, along with the devastating effects of deindustrialization and global trade agreements. Our democracy has been captured and destroyed by corporations that steadily demand more tax cuts, more deregulation and impunity from prosecution for massive acts of financial fraud, all the while looting trillions from the U.S. treasury in the form of bailouts. The nation has lost the power and respect needed to induce allies in Europe, Latin America, Asia and Africa to do its bidding. Add to this the mounting destruction caused by climate change and you have a recipe for an emerging dystopia. Overseeing this descent at the highest levels of the federal and state governments is a motley collection of imbeciles, con artists, thieves, opportunists and warmongering generals. And to be clear, I am speaking about Democrats, too." --The End of Empire

"We live in the most technologically connected age in the history of civilization, yet rates of loneliness have doubled since the 1980s. [It is] an “epidemic,” [with] employees being overworked in his essay." --Work and the Loneliness Epidemic
"Nevertheless, by making capital accumulation synonymous with progress, money-based metrics have turned human betterment into a secondary concern. By the early 21st century, American society’s top priority became its bottom line, net worth became synonymous with self-worth, and a billionaire businessman who repeatedly pointed to his own wealth as proof of his fitness for office was elected president." --How Money Became the Measure of Everything

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


Video of the Week

A Subprime Education

Evidence of Internal Collapse

Evidence of External Demise

Upside Down and Backwards

Systemic Hypocrisy

Anti-semitism, the Myth of a "Palestinian Nation" and the Illusion of a "Peace Process"

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.

Do you like this post? Please link back to this article by copying one of the codes below.

URL: HTML link code: BB (forum) link code:

No comments:

Post a Comment