Apache Derby -- Off to the Races
Includes Details of IBM Cloudscape
Published on 10. November 2005
Book
Hardback
600 pages
978-0-13-185525-0 (ISBN)
Description
* 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 JavaaA A , 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 WindowsA (R) and LinuxA (R) 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/ A A(c) Copyright Pearson Education. All rights reserved.
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 WindowsA (R) and LinuxA (R) 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/ A A(c) Copyright Pearson Education. All rights reserved.
More details
Language
English
Place of publication
Armonk
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 178 mm
Width: 242 mm
Thickness: 43 mm
Weight
1170 gr
ISBN-13
978-0-13-185525-0 (9780131855250)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
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 Chloe-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.
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.
Content
Preface.
Acknowledgments.
About the Authors.
I.
1. On Your Marks ... Get Set ... Go!!! An Introduction to the Apache Derby and IBM
II.
2. Deployment Options for Apache Derby Databases.
3. Apache Derby Databases.
4. Installing Apache Derby and IBM Cloudscape on Windows.
5. Installing Apache Derby and IBM Cloudscape on Linux.
6. Managing an Apache Derby Database.
7. Security.
8. SQL.
III.
9. Developing Apache Derby Applications with JDBC.
10. Developing Apache Derby Applications with Perl, PHP, Python, and ODBC.
IV.
11. "Your Momma Loves Drama" in JDBC.
12. "Your Momma Loves Drama" in Windows.
13. "Your Momma Loves Drama" in PHP.
14. "Your Momma Loves Drama" in Perl.
15. "Your Momma Loves Drama" in Python.
V.
Appendix A. Web Site Contents.
Appendix B. Apache Derby and IBM Cloudscape Resources.
Appendix C. Troubleshooting Hints and Tips.
Acknowledgments.
About the Authors.
I.
1. On Your Marks ... Get Set ... Go!!! An Introduction to the Apache Derby and IBM
II.
2. Deployment Options for Apache Derby Databases.
3. Apache Derby Databases.
4. Installing Apache Derby and IBM Cloudscape on Windows.
5. Installing Apache Derby and IBM Cloudscape on Linux.
6. Managing an Apache Derby Database.
7. Security.
8. SQL.
III.
9. Developing Apache Derby Applications with JDBC.
10. Developing Apache Derby Applications with Perl, PHP, Python, and ODBC.
IV.
11. "Your Momma Loves Drama" in JDBC.
12. "Your Momma Loves Drama" in Windows.
13. "Your Momma Loves Drama" in PHP.
14. "Your Momma Loves Drama" in Perl.
15. "Your Momma Loves Drama" in Python.
V.
Appendix A. Web Site Contents.
Appendix B. Apache Derby and IBM Cloudscape Resources.
Appendix C. Troubleshooting Hints and Tips.