REVIEW - Perl for Oracle DBAs


Perl for Oracle DBAs


Andy Duncan, Jared Still



O'Reilly (2002)




Joe McCool


December 2004



clear, jovial and a pleasure to read.

Perl, Oracle and Database Administration, along with the world wide web, go together like "horses and carriages". The ability of Perl to enable quick, knock-together, yet rugged scripts suits the tasks of the DBA admirably well.

My own exposure to Oracle has been limited. I am much more familiar with MySQL, but this does not at all limit my appreciation of the current efforts. Indeed the similarities are immediately obvious. A complete munging example is given where data is sucked from a MySQL database and poked into an equivalent Oracle one.

Perl's strength derives from the availability of Modules - ready built blocks of code that can be seamlessly incorporated into user programs. This is particularly true in the area of databases. The Perl DBI (database interface) is one of the most popular. (It is currently maintained by a friend of mine from Belfast). Modules can be pulled down from the web and installed effortlessly - there is even a module available to do this. All this is described fully.

Part III describes a complete DBA Toolkit developed by the authors in Perl. It is available for both Win32 and Unix operating systems.

Another area of covered is the user interface, again implemented by modules. One being the Perl/Tk module, which enables the user to build professional Oracle DBA GUI's with little heartache. All explained well, especially GUI's for DB tuning.

Another thing that that I found useful about this book was an appendix on regular expressions - not just the technical aspects, but the historical development. I had no idea that Alan Turing played a part, nor that Godel was involved. It seems that the mathematics department at Princeton was central to the development of regexes. Godel, Turing, Stephen Kleene and Alonzo Church all lent a hand there at some stage.

Yes, I can thoroughly recommend this work. I got a lot out of it. The style is clear, jovial and a pleasure to read.

Book cover image courtesy of Open Library.

Your Privacy

By clicking "Accept Non-Essential Cookies" you agree ACCU can store non-essential cookies on your device and disclose information in accordance with our Privacy Policy and Cookie Policy.

Current Setting: Non-Essential Cookies REJECTED

By clicking "Include Third Party Content" you agree ACCU can forward your IP address to third-party sites (such as YouTube) to enhance the information presented on this site, and that third-party sites may store cookies on your device.

Current Setting: Third Party Content EXCLUDED

Settings can be changed at any time from the Cookie Policy page.