Oracle and Open Source: Tools and Applications (Paperback)

~ (Author), (Author)

Editorial Reviews

Amazon.com Review

Oracle made a big decision a couple of years ago. The company decided to open certain aspects of its relational database management system (RDBMS) to manipulation by outside software. That architectural decision enabled a whole community of specialized software developers to thrive. In Oracle & Open Source, Andy Duncan and Sean Hull explore the universe of open source (that is, modifiable and largely free) software for Oracle applications. The authors approach the subject from two angles: that of database administrators who simply want to locate, download, and use tools that others have created, and that of the software developer who wants to learn about and take advantage of the hooks Oracle has built into its products.

The downloaders will be pleased with documentation of Orac, Oddis, Karma, Oracletool, GNOME-DB, and other ready-to-run administration and design tools. The book explains what each tool does, where it comes from, how to install it, and how to use it (complete with hallmark O'Reilly options lists in most cases). The programmer set, eager to contribute to the collection of open-source Oracle tools, will learn a lot from documentation of Oracle-specific libraries for various languages, including Oratcl for Tcl/Tk, several Perl modules, DCOracle for Python, and the Java Database Connectivity (JDBC) classes for Java. Some programmers may find the introductory sections too general in focus, but they'll be pleased by sections that explain the use of specific methods and functions. --David Wall

Topics covered: The collection of libraries that have come into existence to facilitate interaction with Oracle databases from within home-grown software, as well as programs that others have written to take advantage of those libraries.

Product Description

Oracle & Open Source is the first book to tie together the commercial world of Oracle and the free-wheeling world of open source software. Today, there are many excellent and freely available software tools that Oracle developers and database administrators can use, at no cost, to improve their own coding productivity and their system's performance. Oracle & Open Source describes close to 100 open source tools you can use for Oracle development and database administration, from large and widely known open source systems (like Linux, Perl, Apache, TCL/Tk and Python) to more Oracle-specific tools (like Orasoft, Orac, OracleTool, and OraSnap). This book shows you how to obtain the software, how to adapt it to best advantage, and how to go about releasing your own software to the open source community. The book abounds with code examples, download and installation instructions, and helpful usage hints.

See all Editorial Reviews

Product Details

• Paperback: 424 pages
• Publisher: O'Reilly Media; illustrated edition edition (April 15, 2001)
• Language: English
• ISBN-10: 0596000189
• ISBN-13: 978-0596000189
• Product Dimensions: 9.1 x 7.1 x 0.9 inches
• Shipping Weight: 1.5 pounds (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars  See all reviews (6 customer reviews)
• Amazon.com Sales Rank: #866,693 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

4 of 4 people found the following review helpful:

5.0 out of 5 stars Oracle and Open Source - an Oxymoron?, May 18, 2001

By	Jared Still (Beaverton, OR United States) - See all my reviews (REAL NAME)

Hardly, and after taking a look at this book you will agree.

This book is perfect for anyone that wants to investigate the use of Open Source tools with their Oracle databases.

Finding out what is available, what is useful, what is available, where to get it and how to install it can take a great deal of time.

There is a lot of useful Open Source software available for use with your Oracle database, and though I am a proponent of Open Source software, I will readily admit that it is not all good.

I've given up in exasperation with more than one Open Source tool that would not compile, promised more than it delivered, or simply did not work.

There is though a large collection of Open Source tools that do work, and work well.

What Andy Duncan and Sean Hull have done is compiled an encyclopedia of Open Source tools that do work, and work with the Oracle database.

This book is much more than just a list of Open Source software. Sean and Andy tell you where to find each application, how to install and configure it, and how to use it.

Need to know the different connection methods for Oracle and JDBC? You'll find it here.

How about using Oracle, Apache and JServ? It's in this book.

I thought myself fairly well versed in what Open Source tools were available for Oracle, that is prior to seeing this book.

Some excellent Oracle specific tools are here that I was not aware of previously. In fairness to me though, I know of at least one not in the book. :)

Oracle & Open Source is a well thought out and well executed guide that belongs on the desk of every Oracle DBA, Architect and developer that wants to get a jump start on using Open Source software with Oracle.

2 of 2 people found the following review helpful:

5.0 out of 5 stars An eye opener for Oracle lovers, June 19, 2001

By	vad roytman (Northbrook, il USA) - See all my reviews

Found this book very useful and a real eye opener for those who like myself believed that all your Oracle goodies coming from Oracle Corp. A set of Open Source tools and applications described in this book is amazing. In particular, DB Prism/Cocoon is something that I jumped in right away. Whether you are DBA, developer or just a plain user of Oracle databases, you will find something that will benefit you/your business. Money well spent.

2 of 2 people found the following review helpful:

5.0 out of 5 stars Excellent Resource, June 13, 2001

By	Todd Hawley (San Francisco CA) - See all my reviews (TOP 500 REVIEWER)    (REAL NAME)

Oracle for quite some time now has embraced Open Source technology and as a result there are a number of Open Source tools that can be used with Oracle databases. This book takes a look at all of them. Starting off with a brief "history" of how Oracle and Open Source software have combined to build a number of Oracle applications, how Tcl, Perl, and Python have played a part and how to install them, building web-based Oracle apps, how Java, GNOME, and GTK+ also are involved with Oracle software, even a brief mention of how Linux & Oracle work together.

There is a wealth of good open source programs around for use with Oracle and this book gives a detailed explanation of how to install and use all of them to your advantage.