Welcome to the 164th edition of Log Buffer, the weekly review of database blogs.

SQL Server

We have a delicious assortment of technical posts from the SQL Server world this week.

Piotr Rodak writes, “While I always knew and imagined that ON DELETE CASCADE may be useful, I wondered, what scenarios would be suitable for ON UPDATE CASCADE. I still don’t have this answer, but I came across some interesting behavior which kept me occupied for quite a bit more time that I had intended to.”

On In Recovery…, Paul S. Randall pursued the answers to …

Image by plαdys via Flickr

The following is a list of interesting DBMS related links for the week:

• Ellison's Impatience Over Sun
• Intel squeezes one million IOPS from desktop
• Is the RDBMS doomed (yada yada yada) ?
• EDS brand is no more (not DBMS but interesting)

…

Welcome, readers, to the 163rd edition of Log Buffer, the weekly review of database blogs, your sieve

Oracle

First, the ghastly news—Tom Kyte said “I’m not a DBA anymore.” Say it ain’t so, Tom! “After nine years and nine months of running the database that hosts asktom, I’ve retired . . . not from answering questions, but rather from being the DBA and semi-SA for the machine that was asktom.oracle.com.” Okay, so he said it ain’t so.

Meanwhile, Tom’s Oak Table colleague, Jonathan Lewis, played no head games on us, but he has been at the hash …

1. Milestones in the History of Thematic Cartography -- This resource provides a comprehensive view of the history of cartography, with examples of maps created throughout the ages and background information about the contexts within which those maps, visualizations and map making technologies were created. Explore each time period, click on the images and stories found throughout each time line, and read more about the history of creating thematic maps as a means of visualizing data. (via Titine on Delicious)
2. Interview with Larry Ellison (Infoworld) -- Asked about MySQL, "No, we're not going to spin it off," even if asked to by the EU, Ellison said. Lots of detail and …

This Thursday (September 24th, 14:00 UTC), Heikki Tuuri, the father of InnoDB, will give a session on Concurrency Control: How It Really Works. He'll describe how InnoDB manages concurrency control, so that the system protects data integrity. Beginning with the basics of transaction management, Heikki will include a discussion of the ACID (atomicity, consistency, isolation, and durability) properties, and explain various transaction modes, locking, deadlocks, and more advanced topics such as the impact of next-key (gap) locking, referential integrity, XA (distributed transaction management) support, and more. While the discussion will focus on the InnoDB implementation, many of the concepts presented apply to other database systems and storage engines.

For MySQL …

This Thursday (September 24th, 14:00 UTC), Heikki Tuuri, the father of InnoDB, will give a session on Concurrency Control: How It Really Works. He'll describe how InnoDB manages concurrency control, so that the system protects data integrity. Beginning with the basics of transaction management, Heikki will include a discussion of the ACID (atomicity, consistency, isolation, and durability) properties, and explain various transaction modes, locking, deadlocks, and more advanced topics such as the impact of next-key (gap) locking, referential integrity, XA (distributed transaction management) support, and more. While the discussion will focus on the InnoDB implementation, many of the concepts presented apply to other database systems and storage engines.

For MySQL …

This Thursday (September 24th, 14:00 UTC), Heikki Tuuri, the father of InnoDB, will give a session on Concurrency Control: How It Really Works. He'll describe how InnoDB manages concurrency control, so that the system protects data integrity. Beginning with the basics of transaction management, Heikki will include a discussion of the ACID (atomicity, consistency, isolation, and durability) properties, and explain various transaction modes, locking, deadlocks, and more advanced topics such as the impact of next-key (gap) locking, referential integrity, XA (distributed transaction management) support, and more. While the discussion will focus on the InnoDB implementation, many of the concepts presented apply to other database systems and storage engines.

For MySQL …

Oracle is keeping MySQL. Yahoo is selling Zimbra. Linus is feeling bloated. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

# Larry Ellison reportedly said Oracle has no intention of spinning off MySQL.

# Yahoo is trying to sell Zimbra, according to All Things D.

# Linus Torvalds said Linux is “bloated and huge”.

# GroundWork Open Source released GroundWork Monitor 6.0.

# Zend launched Simple API for Cloud Application …

Image by Snooch2TheNooch via Flickr

I was speaking with Michael Stonebraker this morning.  I mentioned that lately many have been referencing comments he has made over the last couple of years.  And I also mentioned that many had interpreted them as he was implying the RDBMS is “doomed”.  Mike has been saying the same thing for years, but the current NoSQL movement seems to have picked up on this and highlighting one of the RDBMS's own pioneers is predicting its …

Oracle Open World 2009 is just few weeks away and I firmed up my presentation schedule now. I will present three “normal” presentations and couple unconference sessions. I’m arriving in San Francisco few days before the conference (7th of October) get to the Oracle ACE Directors briefing so I’ll spend the first few day in Redwood Shores and then off to Moscone Center.

Before I get to the schedule, if you want to catch up with me during OOW — tweet me @alexgorbachev. You are likely to see me in the OTN Lounge or in “The Cave” if you know what I’m talking about.

Here is a quick summary of my presentations: