Discover new selections
Buy used:
$33.32
FREE delivery April 25 - 30. Details
Used: Very Good | Details
Condition: Used: Very Good
Comment: May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less
Access codes and supplements are not guaranteed with used items.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the authors

Something went wrong. Please try your request again later.

Apache Derby: Includes Details of IBM Cloudscape

3.3 out of 5 stars 8 ratings

Built on the IBM Cloudscape code base, Apache Derby is lauded as the world's only enterprise class, open source, pure Java, fully transactional relational database. In this guide for developers, database experts from IBM explain how to make the most of Apache Derby. First are step-by-step instructions for installing the code on a Windows or Linux workstation for developmental purposes. The next section describes how each of the programming languages supported by Apache Derby interacts with the database engine. The final section is a tutorial, taking the reader through the construction of various features for a sample application. Annotation ©2006 Book News, Inc., Portland, OR (booknews.com)

Editorial Reviews

From the Back Cover

  • Learn installation, configuration, management, and security

  • Delve deeper with coverage on SQL, troubleshooting, application development, and more

Master Apache Derby: the only open source, pure Java™, fully transactional, small-footprint RDBMS

Apache Derby is the world's only enterprise class open source, pure Java, fully transactional relational database. It's small enough to be embedded directly into your Java applications, providing a local data store that requires no DBA support. Powerful enough to support a wide range of traditional applications, this database ships as the default database for WebSphere Application Server and more than fifty other IBM software products. Apache Derby is built on the mature IBM Cloudscape code base IBM recently contributed to the open source community. The IBM Cloudscape code was nominated and won Developer.com's Product of the Year 2005 award.

Now, IBM's own database experts have written a comprehensive guide to making the most of Apache Derby—and its commercial counterpart, IBM Cloudscape— in any development or production environment. This book systematically introduces the Apache Derby/IBM Cloudscape technology: where it fits and how to install and configure it—and how to build robust business applications and Web services with it, one step at a time.

Coverage includes

  • Comparing Apache Derby with the commercial IBM Cloudscape offering

  • Deploying Apache Derby/IBM Cloudscape to support development and production environments, client/server environments, multi-threaded applications, and Web servers

  • Integrating Apache Derby/IBM Cloudscape into a completely open source development environment

  • Specific instruction on installing Apache Derby/IBM Cloudscape on Windows® and Linux® workstations—with tips on how to install the code on any platform that has a supported JVM

  • Understanding how programming languages interact with Apache Derby/IBM Cloudscape

  • Building complete sample applications step-by-step in JDBC, Windows (ODBC and .NET), PHP, Perl, and Python

  • Managing and securing Apache Derby/IBM Cloudscape databases

  • Writing SQL code for creating, retrieving, and updating data

  • Troubleshooting installations, databases, and applications

This book has a companion Web site that contains links to the IBM version of Apache Derby and other downloadable code, documentation, articles, and other resources to give the reader a deeper understanding of some of the features available in Apache Derby.

ibmpressbooks.com/title/0131855255

www-306.ibm.com/software/data/awards/


© Copyright Pearson Education. All rights reserved.

About the Author

Paul C. Zikopoulos, BA, MBA, is an award-winning writer and speaker with the IBM Database Competitive Technology team. He has more than 10 years of experience with DB2 UDB and has written over 60 magazine articles and several books about it. Paul has co-authored the books DB2 Version 8: The Official Guide, DB2: The Complete Reference, DB2 Fundamentals Certification for Dummies, DB2 for Dummies, and A DBA’s Guide to Databases on Linux. Paul is a DB2 Certified Advanced Technical Expert (DRDA and Cluster/EEE) and a DB2 Certified Solutions Expert (Business Intelligence and Database Administration). In his spare time, he enjoys all sorts of sporting activities, running with his dog Chachi, and trying to figure out the world according to Chloë–his new daughter. You can reach him at paulz_ibm@msn.com.

George Baklarz, B Math, M Sc (Comp Science) is a senior manager in the DB2 Worldwide Pre-sales Support Group. He works closely with customers to help them understand new information management technology and to gain their feedback for improving DB2 products. He has more than 20 years of experience with DB2 and has co-authored a number of books, including DB2 UDB Version 8.1 Database Administration Certification Guide (Prentice Hall, 2003) and DB2 UDB Version 8: The Official Guide (Prentice Hall, 2003). In addition, he is a member of the International DB2 Users Group Speaker and Volunteer Hall of Fame. In his spare time, he lectures at the University of Guelph (database theory) and presents at a variety of user conferences, including the International DB2 Users Group. You can reach George when he’s not traveling at baklarz@gmail.com.

Dan Scott has been working for IBM on DB2 Universal Database since 1998, and currently holds the position of product manager. He has been involved in the intersection of DB2, Linux, and open source scripting languages as a user, author, public speaker, and occasionally a developer since 1999. In addition to authoring technical manuals for IBM and contributing articles to IBM developerWorks, Dan wrote the original “DB2 for Linux HOWTO” and tested and documented the PHP Data Objects (PDO) extension for www.php.net. Dan has presented internationally on the subject of developing applications with scripting languages that connect to Apache Derby, IBM Cloudscape, and IBM DB2 Universal Database. He lives in Toronto with his wife, cat, a coffee roaster, and a wide range of outdoor sporting equipment. You can reach him at dan.scott@acm.org.

Product details

  • Publisher ‏ : ‎ IBM Pr (January 1, 2005)
  • Language ‏ : ‎ English
  • Hardcover ‏ : ‎ 567 pages
  • ISBN-10 ‏ : ‎ 0131855255
  • ISBN-13 ‏ : ‎ 978-0131855250
  • Item Weight ‏ : ‎ 1.32 pounds
  • Dimensions ‏ : ‎ 7.5 x 1.75 x 10 inches
  • Customer Reviews:
    3.3 out of 5 stars 8 ratings

About the authors

Follow authors to get new release updates, plus improved recommendations.

Customer reviews

3.3 out of 5 stars
8 global ratings

Review this product

Share your thoughts with other customers

Top reviews from the United States

  • Reviewed in the United States on March 11, 2008
    The definitely guide to Derby. This offers much more explanation and information than the online documentation provided by Apache. But what do you expect... it comes from the minds at IBM themselves.

    However, unlike most of IBM's publications and documentation, this is actually readable and informative. You don't have to wade through a series of unknowns and missing pieces of the puzzle in order to figure out what IBM was trying to actually get at.

    This will not only help you define and work with Apache Derby, but also make your applications lighter, faster and easier to deploy.
    4 people found this helpful
    Report
  • Reviewed in the United States on September 22, 2012
    This book does not contain any helpful information for the current version of Derby 10.9 especially if like me you are looking to write java applets/applications to interface with the database. This books examples use Eclipse and Eclipse is no longer being maintained to work with Derby. The book does contain some basic information on Derby but you can get all of that for free on Derby's website and it pertains to the most recent version.
    One person found this helpful
    Report
  • Reviewed in the United States on January 29, 2019
    This was a 10+ year old reference on a still useful DBMS. Not easy to find anywhere else. I found it very useful.
  • Reviewed in the United States on November 28, 2005
    Apache Derby is a very promising package that is being freely offered, as both source code and binaries. This book is an aggressive promotion of its virtues. The authors stress many things about Derby, or its IBM sidekick, Cloudscape.

    Derby addresses a persistent need amongst many Java programmers for an easy to use SQL database. Often, a Java programmer has only cursory expertise in coding for a full database like IBM's DB2 or Oracle. Best usage of these often requires you to be a DBA.

    By contrast, Derby comes as a Java JAR file, and can be plonked into your programming environment just as any other JAR file. The book explains in depth how to then interact with Derby, at the level of your Java source code. You can see that you get a pretty powerful engine. Including features like stored procedures and user defined functions, that let you optimise for speed.

    Speaking of speed, that is perhaps the biggest possible drawback of Derby. It is run as Java bytecode in a jvm, which is not quite as fast as a package compiled into native binaries. The book seems to deprecate this aspect, but you should be aware of it.

    You might find Derby useful enough that you don't have to migrate to a full database like DB2. The book stresses that the code you write to interface with Derby will also do for DB2. There is a potential problem here for IBM, if it loses DB2 business to Derby. But maybe it feels that if it never promoted Derby, then sooner or later, an equivalent product would come along.

    Obviously, to use Derby, you still need to know basic SQL statements. And some understanding of how to develop related tables to hold your data. The text is not meant to teach you these skills.

    The first chapter also makes various cogent points about the advantages of using Derby. With sometimes unintentional hilarity. A passage says the intent is not to besmirch Microsoft. But despite this pious protestation, it proceeds immediately to do just that. By opining that Microsoft's SQL Server has a 5 year lag between upgrades - Server 2000 and Server 2005. While Derby has source code available, and a much faster cycle for introducing new capabilities.
    10 people found this helpful
    Report
  • Reviewed in the United States on June 11, 2015
    Great little db that can be embedded in your java app or run as a server. This book provides in depth coverage Derby and details on setup and configuration and using Derby with your applications.
  • Reviewed in the United States on September 10, 2014
    very helpful.
  • Reviewed in the United States on March 17, 2006
    Apache Derby is the only open source, pure Java RDBMS database and APACHE DERBY-OFF TO THE RACES comes from IBM's own database experts and tells how to make the most of Derby and its commercial counterpart IBM Cloudscape. Learn how to support development efforts, install Derby on both Windows and Linux systems, how to understand how programming languages interact with them, and build sample applications step-by-step: everything is here to learn the fundamentals and troubleshoot virtually any problem.
    6 people found this helpful
    Report