Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Welcome to the 141st edition of Log Buffer, the weekly review of database blogs. The Oracle bloggers were especially chatty this week, so let’s start with them.
Rob van Wijk wrote a fine post about choosing between SQL and PL/SQL, defending his choice of straight-up SQL for logic. Naturally, this triggered a lot of discussion, as well as a few responses from other blogs. Chen Shapira framed her response in a question about code life-cycle: would you rather maintain SQL or PL/SQL?
[Read more]I am passing this along — I am not sure if most folks reading this can make it, as it is last-minute and in the Boston area, but I figured I’d let people know that the New England Database Society exists. It’s free, sponsored by Sun (and has been for years, long before Sun bought MySQL), and is hosted by my college database professor, Mitch Cherniack. (To that end, I should probably make sure to promote the Boston User Group here more often! I keep forgetting…)
You can find information on how to be a part of the mailing list at http://www.cs.brown.edu/sites/neds/
The next New England Database Society will be held on Friday, March 27 and the speaker is Christian Jensen of Aalborg University.
===================================================================
[N]ew [E]ngland [D]atabase …
This is the 140th edition of Log Buffer, the weekly review of database blogs. Welcome.
Let us begin with Oracle this week. Dan Norris illustrates how to start database services automatically after instance startup. He says, “Services are an essential component for managing workload in a RAC environment. If you’re not defining any non-default services in your RAC database, you’re making a mistake.”
Vivek Sharma published his tale of, Latch: Row Cache Objects causing huge performance issue. Clever detective …
[Read more]In about 15 minutes, Giuseppe Maxia will begin a webinar in which the main focus is a presentation on “How to have a good presentation”. Talk about meta!
Giuseppe posted how to join the free webinar.
The slides can be found at http://datacharmer.org/downloads/2009_03_Presentation.pdf.
The Oracle gateway for ODBC provides an almost seamless data integration between Oracle and other RDBMS. I won’t argue about its performance, limits, or relevance. It serves a few purposes; set it up and you’ll be able, for example, to create database links between Oracle and MySQL. After all, wouldn’t it be nice if you could run some of the following SQL statements?
select o.col1, m.col1 from
oracle_tab
o, mysql_tab@mysql m where
o.col1=m.col1;
insert into oracle_tab (select * from
mysql_tab@mysql);
This post is intended to share, the same way Karun did it for SQL Server …
[Read more]Welcome to the 139th edition of Log Buffer, the weekly review of database blogs. Let us begin with a look at the best from the Oracle ’sphere.
Oracle
Many of you might be considering some more training or certification. Coskan Gundogar has already been there, and has returned with the tale to tell, What I learned during Oracle SQL Expert Exam Study Part-1.
In Jared Still’s Ramblings a discussion of the evils of encoding meaning into data.
…
[Read more]Welcome to the 138th edition of Log Buffer, the weekly review of database blogs. If you aren’t aware of who I am, my name is Nick and I am a Senior DBA at The Pythian Group. This is my second run at hosting Log Buffer, and I hope you will enjoy it as much as I did creating it.
As we see winter giving way to summer, I thought I would start
with Informix.
Over at Informix-technology Fernando
talks about FUD for thought where he talks about the
future of Informix vs. DB2.
Sticking with IBM, I thought that we …
[Read more]This is the 137th edition of Log Buffer, the weekly review of database blogs. Dave Edwards is enjoying a week off, and so as part of my plot to take over the world, I am writing this week’s Log Buffer.
First, the fun stuff: Josh Berkus tells us that the American English Translation of the Manga Guide to Databases is available in Japanese Fairies and Third Normal Form.
Then, the basics:
Giri
Mandalika points to an article on Using MySQL with Java Technology. This is a
basic article on how to connect, and …
This is the 136th edition of Log Buffer, the weekly review of database blogs. Welcome.
Let’s start with the bad news first. The relational database is doomed. Or is it? That is the line of inquiry taken by the item by Tony Bain on ReadWriteWeb. “Recently, a lot of new non-relational databases have cropped up both inside and outside the cloud. One key message this sends is, ‘if you want vast, on-demand scalability, you need a non-relational database’. . . . Is this a sign that relational databases have had their day and will decline over time?”
Whether or not you believe that your beloved relational DB’s days are numbered, you will be …
[Read more]I don’t want to post the link to this (perhaps, it was left public unintentional?) but here is what I stumbled upon recently. This is a log of production maintenance of IT systems in Perth, Western Australia (as far as I could say):
Good idea but shouldn’t companies keep this sort of information private?
