Solve the Oracle Database murder mystery and win a free ticket for yourself and a friend to the NoCOUG conference
You may remember this children’s song from kindergarten or you can listen to this YouTube video:
“Ten green bottles hanging on the wall
Ten green bottles hanging on the wall
And if one green bottle should accidentally fall
There’ll be nine green bottles hanging on the wall.”
In this Oracle Database murder mystery, there were no green bottles left hanging on the wall after the first bottle fell.
- “From digits 10 if 1 falls, remains is 0 (ZERO).”
- “It’s a Cascade delete issue … If Main record is deleted, then any corresponding foreign records too would be deleted.”
- “Oracle does not keep any spot for the “Accidental” fall of bottles. If one bottle can fall accidently, then all ten bottles can also fall accidently. There should not be any scope for accidental falls.”
- “Perhaps Jack connected to a CDB and since he didn't specify a PDB name, the commands impacted all PDBs contained therein?”
- “Since STARTUP FORCE does an SHUTDOWN ABORT/STARTUP—did he do it on a ASM Instance (NetApp storage) shared by 9 other running instances? There can only be one ASM instance per server. Other instances crashed and were restarted automatically with Oracle Restart (Oracle Grid Infrastructure)?”
See also : What’s so sacred about relational anyway?
The opinions of relational theoreticians C. J. Date and Hugh Darwen about SQL are well known but they have not previously commented on the NoSQL phenomenon and so their interview in the latest issue of the NoCOUG Journal—the official publication of the Northern California Oracle Users group—makes for interesting reading. In my opinion, their comments are right on the mark even though Date admits that he knows almost nothing about NoSQL products.
Books to the ceiling, Books to the sky,
My pile of books is a mile high.
How I love them! How I need them!
I’ll have a long beard by the time I read them”
—Lobel, Arnold. Whiskers and Rhymes. William Morrow & Co, 1988.
To celebrate Independence Day, I freed myself from several hundred pounds of old books and manuals, most in new condition, that I had accumulated over the years but never read. Here is a picture of me with some of the books before they went into the recyling bin. A complete set of Ingres 6.4 manuals still in shrink wrap also went into the recycling bin. You can clearly see some of them in the middle of the pile if you click on the picture and zoom in.