Log Buffer #14: A Carnival of the Vanities for DBAs
Oct 13, 2006 / By David Edwards
Welcome to the fourteenth Log Buffer, the weekly review of the database blogosphere.
We start with a couple pieces on Oracle’s purchase of Sunopsis (news item on ZDNet), the latest in a series of purchases for them. On Andy on Enterprise Software offers Andy Hayler‘s analysis: Sunopsis’s Data Conductor product is superior to Oracle’s Warehouse builder, and will supersede it.
Peter Scott on Pete-s random notes has a couple things to say about it. In the first piece, that Sunopsis’s products will play a key role in Oracle’s placement of its offerings in heterogeneous environments; in the second, Peter congratulates them on their being, in his opinion, not locked into marketing-driven, one-vendor approaches.
Lenz Grimmer observes that conference season is heating up again, and he appears to be right. He’s keeping his eye on the MySQL Northern Europe Customer Conference, the MySQL Central Europe Customer Conference, and he spoke on MySQL and Open Source software at the Linux Business Day yesterday in Luebeck, Germany.
Of course, the 800-pound gorilla of database conferences is Oracle Open World (OOW). There’s going to be a lot of blog coverage of this event, before, during, and after it. I’ll be looking for the best of it for Log Buffer, especially items by bloggers with their critical faculties turned on. I have a handful this week.
And on Radio Free Tooting, Andrew Clarke begins with a little OOW orientation concerning in-conference networking, and an item with the highlights of the keynotes as he sees them: “one of the advantages of attending Open World is the opportunity to see most of the big beasts of the IT savanna”. (Gorillas, 800-pound or otherwise, do not live on the savanna, Andrew, but I’ll let it slide.)
Personal networking is probably the principle business of OOW or any other conference. On the OracleAppsBlog, there’s a piece by Michael Siebert about an opportunity for some of this activity, the 5th Annual OAUG Oracle Users Forum taking place alongside OOW.
Crossing the RDBMS gulf, at Getting the Most out of DB2…, Willie Favero has a couple recommendations for IBM’s Information On Demand (IOD) event (the DB2 Tech Conference).
Incidentally, if you’re of a mind to choose a conference to attend based only on the surrounding froth, I notice that OOW is in San Francisco and features Sir Elton John (“Sir”, mind you), while IOD takes place in Anaheim with Gladys Knight (a Knight but not a “Sir”). It’s too bad the events are separated by a couple days, they could have done a video link-up networked version of “That’s What Analyses of Perfomance Trends Are For”… Well, maybe it’s for the best after all. … IOD also has Wayne Brady. Whose conference is it, anyway?
Pete Finnigan‘s Oracle security weblog has a summary of changes Oracle will make in their critical patch updates, beginning on the 17th. Pete thinks the changes will make it easier to stay on top of Oracle’s updates.
Chris Foot‘s Oracle10g Blog continues its series, The Non-Technical Art of Being a Successful DBA, with an item on third party product evaluations. His guidelines are methodical and thorough. Do read them if you think you’ll be asked to put new technology to the test in your shop.
A short item on data breach expectations on Craig Mullins‘s Perspectives on Database Management, poses the question, if your organization deals with data, is it also prepared to takes the steps required to protect it?.
Chris Eaton on An Expert’s Guide to DB2 Technology offers a comparison of DB2‘s Self-Tuning Memory Manager and Oracle’s equivalent. He suggests that, all things being equal, the DB2 way is superior.
At My-ess-queue-ell vs. My-see-quell, Sheeri Kritzer introduces SQL Hacks, a book for which she served as technical editor. It’s part of O’Reilly’s Hacks series, which aims to, “(reclaim) the term ‘hacking’ for the good guys–innovators who explore and experiment, unearth shortcuts, create useful tools, and come up with fun things to try on their own.” The book is due in November. Congratulations, Sheeri!
Magnus Hagander‘s PostgreSQL Blog announces the 1.0-release of Npgsql, a Free/Open Source .Net data provider for Postgresql. Here’s Npgsql’s homepage.
Lucas Jellema on the AMIS Technology Blog has a useful item on finding tables with multiple foreign keys to the same referenced table, in Oracle.
There’s an excellent piece on the relationships between databases and systems on Blogging About Oracle, by Piet de Visser. To use his nutshell, “It comes down to this: Should there be many databases on a single system (m:1, the traditional approach), or should there be many systems underneath one database (1:m, grid)? And when is 1:1 appropriate?”
That’s all for this edition. Adam Machanic is standing by to edit one in the near future (he’s kind of busy these days, I’m sure he’ll explain why), and Guy Bowerman is going to take the reins for LB#16 on the 27th. Next week is up for grabs, so please read the Log Buffer homepage if you’d like to try your hand.
‘Til next time!
Leave a Reply