Summary

Although Apache Derby is a zero- or low-maintenance database, there are scenarios where it makes sense to invest some effort in learning the administration capabilities that Apache Derby has to offer. In this chapter you have learned:

  • The importance of developing a backup and recovery strategy

  • How to back up and recover Apache Derby databases, with online and offline options for performing your backup operations

  • How to import data to and export data from tables in an Apache Derby database

  • How to investigate long, slow-running SQL statements through Apache Derby's runtime statistics utilities

  • How to reorganize your database tables to save disk space

With this knowledge, you can ensure that users of your Apache Derby databases—whether embedded ...

Get Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.