- Shopping Bag ( 0 items )
From Barnes & Noble
b>The Barnes & Noble ReviewThe Oracle database is emphatically not open source: just try to imagine Larry Ellison giving anything away for free! However, a thriving community of open source developers has sprung up around Oracle. Oracle has been ported to Linux. What's more, Oracle Corporation has incorporated certain open source technologies into its own product lines.
Until now, however, it's been difficult for Oracle developers to get a good fix on the open source resources available to them. Open source newsmedia rarely focus on Oracle-oriented projects; Oracle information sources tend to focus on commercial products.
In Oracle & Open Source, all that changes. Andy Duncan and Sean Hull -- themselves developers of open source Oracle tools -- profile nearly 100 open source tools for Oracle development and database administration. You'll learn where to get the software, how to install it, and how to adapt it to your specific needs. The breadth of these software tools will be an enormously pleasant surprise to most Oracle professionals.
If the existing tools aren't enough, Duncan and Hull also demonstrate exactly how to use open source languages such as Perl, Tcl/Tk, and Python to build your own solutions (which they gently encourage you to share with the community!)
The authors start with an in-depth look at the Oracle Call Interface (OCI), the Oracle API used by open source software to connect with the Oracle database. They present a full chapter on a classic example of open source database connectivity: the Perl Database Interface (DBI) module and its Oracle-specific driver, DBD::Oracle.
Next, they introduce scripted GUI solutions for Oracle administration and development -- solutions built with Perl/Tk, Tcl/Tk, and Python. In the Tcl community, the solution of choice is Oratcl, which has actually been adopted by Oracle itself as an interface to the Oracle Enterprise Manager. In Python, it's DCOracle; in Perl/Tk, it's the aforementioned DBI and DBD::Oracle.
What can you do with these tools? Oracle & Open Source presents two excellent examples. There's Orac, built in Perl/TK by co-author Andy Duncan as a tool for database management and performance tuning; and Oddis, a similar tool built with Tcl/Tk, and offering robust SQL tuning capabilities.
Next, the authors offer a practical overview of the key open source (and quasi-open-source) tools used to build web applications that draw upon Oracle databases, notably Apache and PHP. Again, after introducing the relevant tools and platforms, they show you what's been done with them.
For example, there's Karma -- a powerful Oracle database monitoring application that helps you track multiple databases at once, and notifies you by email whenever there's a problem. There's OraSnap, a sophisticated, browser-based tool for performance monitoring and statistics gathering -- kind of like Oracle's utlbstat and utlestat on steroids. There's WWWWdb, which lets you quickly search for text inside database tables; Big Brother, a general network monitoring tool that includes Oracle-specific support; and more.
Java isn't quite open source, but it has gained extensive support from Oracle open source developers. The authors present key Java technologies for Oracle developers, including servlets, JavaServer Pages, and Apache JServ. Next, they introduce key Oracle open source tools built with Java, including the jDBA administration suite; and ViennaSQL, a nifty substitute for SQL*Plus built with the latest Java Swing components.
Perhaps the most exciting of these are DB Prism and Cocoon. On its own, DB Prism is a powerful servlet engine. When plugged into Cocoon, it can generate dynamic XML from an Oracle database. Together, the two packages act as a complete publishing framework, allowing organizations to manage content creation and delivery far more effectively.
The book concludes with a look at the GTK+ graphical toolkit, which is taking off as a platform for Oracle open source development. You'll learn about the GTK+-based Orasoft applications suite; the GNOME-DB framework for building GTK+ database applications; gaSQL, a highly visual tool for understanding the structure of your database; and more.
Whether you're an Oracle DBA or developer, this book will turn you on to tools you can use in production -- and extend at will -- without draining your checkbook.(Bill Camarda)
--Bill Camarda is a consultant, writer, and web/multimedia content developer with nearly 20 years' experience in helping technology companies deploy and market advanced products and services. He served for nearly ten years as vice president of a New Jersey-based marketing company, where he supervised a wide range of graphics and web design projects. His 15 books include Special Edition Using Word 2000
Overview
Oracle & Open Source is the first book to tie together the commercial world of Oracle and the free-wheeling world of open source software. As this book reveals, these two worlds are not as far apart as they may seem. 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. Moreover, many of the finest Oracle developers are now making their source code ...