Archive
Oracle 12c Gives Fresh Life to the Relational Database Movement
FOR IMMEDIATE RELEASE
San Francisco (April 1, 2013) – In a dramatic move calculated to give fresh life to the moribund relational database movement, the latest version of Oracle Corporation’s flagship database has eliminated the famous “join penalty” by making it possible to store rows from multiple relational tables in the same database block. There are two flavors of the feature: …
Oracle 12c Gives Fresh Life to the Relational Database Movement
FOR IMMEDIATE RELEASE
San Francisco (April 1, 2013) – In a dramatic move calculated to give fresh life to the moribund relational database movement, the latest version of Oracle Corporation’s flagship database has eliminated the famous “join penalty” by making it possible to store rows from multiple relational tables in the same database block. There are two flavors of the feature: hash clusters and indexed clusters. Database aficionado Iggy Fernandez has this to say about the feature: “Even Homer Simpson and his Springfield buddies are aware that Oracle Database supports the relational model. However, it is not universally known that Oracle Database 12c also supports the document model. Hash clusters and indexed clusters are critical building blocks of Document/Relational duality, an extension of the physical data independence proposed by Dr. Edgar Codd (1923–2003), the creator of the relational model. Document/Relational duality means that data in an Oracle 12c database can be physically stored in one of the two ways—either as documents or as rows in tables depending on the primary use case—without compromising the ability to expose and manipulate data in the other way. Naysayers will no longer be able to call Oracle Corporation’s commitment to Document/Relational duality into question.” Iggy then ecstatically began singing the 1960s hit song “To everything there is a season and a time for every purpose under heaven,” a dead giveaway to his age.
Document/Relational duality means that data in an Oracle Database can be physically stored in one of the two ways—either as documents or as rows in tables depending on the primary use case—without compromising the ability to expose and manipulate data in the other way.
For more information about hash clusters and indexed clusters, please refer to the Oracle Concepts manual.
YouTube announces it will be shutting down after eight years in business
Explosive Revelations about Dr. Edgar Codd rock the NoSQL World
Explosive Revelations about Dr. Edgar (Ted) Codd rock the NoSQL World
FOR IMMEDIATE RELEASE
Explosive Revelations about Dr. Edgar (Ted) Codd rock the NoSQL World
San Francisco (April 1, 2012) – An explosive article titled A Relational Model of Data for Large Shared Data Banks published in the 100th issue of the NoCOUG Journal reveals that the late founder of the relational movement Dr. Edgar (Ted) Codd (August 23, 1923–April 18, 2003) also founded the NoSQL movement. On the last page of the article, we find the first ever exposition of the BASE paradigm (Basically Available, Soft State, Eventually Consistent) of NoSQL.
“There are, of course, several possible ways in which a system can detect inconsistencies and respond to them. In one approach the system checks for possible inconsistency whenever an insertion, deletion, or key update occurs. Naturally, such checking will slow these operations down. If an inconsistency has been generated, details are logged internally, and if it is not remedied within some reasonable time interval, either the user or someone responsible for the security and integrity of the data is notified. Another approach is to conduct consistency checking as a batch operation once a day or less frequently. Inputs causing the inconsistencies which remain in the data bank state at checking time can be tracked down if the system maintains a journal of all state-changing transactions. This latter approach would certainly be superior if few non-transitory inconsistencies occurred.”
Checking for possible inconsistency whenever an insertion, deletion, or key update occurs will slow these operations down.
An analysis of Dr. Codd’s writings from the last century also reveal Codd’s little concealed distaste for SQL. For example, he devotes the whole of Chapter 23 of The Relational Model for Database Management: Version 2 to a no-holds-barred criticism of SQL.
Dr. Codd did not win any followers during his lifetime but there are now more than 100 NoSQL products that espouse his principles.
For more on this breaking story, stay tuned to our sister station.
Obama Criticized For Living In Lavish Mansion While Most Americans Struggle To Make Ends Meet
Recent Comments