Java Database Best Practices (Paperback)

~ (Author)

Editorial Reviews

Product Description

Java Database Best Practices rescues you from having to slog through books on each of the various APIs before figuring out which method to use! This guide introduces each of the dominant APIs, explores the methodology and design components that use those APIs, and then offers practices most appropriate for different types and makes of databases, and different types of applications. Java Database Practices also examines database design, from table and database architecture to normalization, and offers a number of best practices for handling these tasks as well. Learn how to move through the various forms of normalization, understand when to denormalize, and even get detailed instructions on optimizing your SQL queries to make the best use of your database structure. Through it all, this book focuses on practical application of these techniques, giving you information that can immediately be applied to your own enterprise projects.

About the Author

George Reese is the founder of two Minneapolis-based companies, enStratus Networks LLC (maker of high-end cloud infrastructure management tools) and Valtira LLC (maker of the Valtira Online Marketing Platform). Over the past 15 years, George has authored a number of technology books, including MySQL Pocket Reference, Database Programming with JDBC and Java, Java Database Best Practices, and the upcoming Web Architecture and Programming in the Cloud. Throughout the Internet era, George has spent his career building enterprise tools for developers and delivering solutions to the marketing domain. He was an influential force in the evolution of online gaming through the creation of a number of Open Source MUD libraries and he created the first JDBC driver in 1996-the Open Source mSQL-JDBC. Most recently, George has been involved in the development of systems to support the deployment of transactional web applications in the cloud. George holds a BA in Philosophy from Bates College in Lewiston, Maine and an MBA from the Kellogg School of Management in Evanston, Illinois. He currently lives in Minnesota with his wife Monique and his daughters Kyra and Lindsey.

Product Details

• Paperback: 304 pages
• Publisher: O'Reilly Media; 1 edition (May 2003)
• Language: English
• ISBN-10: 0596005229
• ISBN-13: 978-0596005221
• Product Dimensions: 9.1 x 7 x 0.7 inches
• Shipping Weight: 1.1 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars  See all reviews (7 customer reviews)
• Amazon.com Sales Rank: #729,837 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #32 in

  Books > Computers & Internet > Databases > Java & Databases

Customer Reviews

Most Helpful Customer Reviews

13 of 13 people found the following review helpful:

5.0 out of 5 stars Good for intermediate Java guy aspiring to be senior, June 9, 2003

By	Sisu (Oakland, CA United States) - See all my reviews

This book hit the sweet spot for me: I had some knowledge of PL/SQL and database concepts already, and would classify myself as an "intermediate" Java developer. I'm almost done with this book, and it has been not only a pleasure to read, but it has really solidified my knowledge of what is important in database design. In a large workgroup setting, there's a tendency to focus on what has been mandated as the database programming API, so I found the author's overview of all major persistence approaches nice, providing some food for thought. I would say the performance tips, which often appear as boxed "Best Practices" throughout the book, are a key good feature of the book. I really like the author's style, which is clear and pragmatic. In the fashion of the famous 80/20 rule, he points out when there are differences in ways of doing things that exist, but don't make *that* much difference. My last observation will sound trivial, but to me it was another thing to like: the book is compact, a little more than half an inch thick, which makes it easy to just take with you whenever there's a bit of predictable downtime (commuting, lunch, etc).

9 of 9 people found the following review helpful:

4.0 out of 5 stars Points you in the right direction, June 9, 2003

By	Jason Menard - See all my reviews (REAL NAME)

JDO or EJB? JDBC? BMP or CMP? EJB BMP with JDBC and JDO on a RDMS?

Have you ever been caught up in the alphabet soup of Java database programming APIs? Have you ever questioned which approach might be best suited for your particular application? Sure you pride yourself on your skills in crafting some pretty mean EJBs, but is that the best path to head down with your latest project? O'Reilly's new book "Java Database Best Practices" attempts to answer these questions and more.

For such a relatively thin book (267pp), it touches on a wealth of topics vital to the subject at hand. Reese lends his insights concerning database architectures, database design, transaction management, and persistence methods using JDBC, EJB, and JDO. While this isn't intended to be an introductory tome, you are also not expected to be proficient with all these APIs. As such, the latter third of the book contains tutorials on relevant J2EE APIs, JDBC, JDO, and SQL.

Reese does not exhaustively go into detail on every topic, each of which could probably warrant its own book. Rather he arms us with just enough information to make informed decisions about which method might best serve our applications. Aside from merely determining which set of APIs might be best suited in a given situation, Reese also points out several "best practices" to help guide us in design and implementation (for example, "use join tables to model many-to-many relationships").

I do have a couple of small complaints about the book. For one, "best practices" are highlighted throughout the text, but they are not enumerated or indexed in any manner. An enumerated list of these "best practices" would be welcome. Secondly, MVC purists will likely cringe at the JSP examples. While the architecture shown (JSPs as view and control, database access through taglibs) may be valid for small web applications, I don't feel it should be highlighted as a "best practice", particularly for enterprise applications. None of these complaints are major however, and do not overly detract from the value of the book.

"Java Database Best Practices" accomplishes what it sets out to do. This is a book that might be handy to have to pass around your development team in the design phase to get you all on the same page when making some critical choices. This book could also well serve those, such as managers perhaps, seeking a broad survey of Java database programming. I also feel that this book would make an excellent companion text for a college database programming course using Java. While "Java Database Best Practices" won't make you an expert with all of these APIs, it will certainly point you in the right direction.

6 of 6 people found the following review helpful:

3.0 out of 5 stars Mixed, September 17, 2004

By	Shane Kirk (Cincinnati, Ohio USA) - See all my reviews (REAL NAME)

I have mixed feelings about this book. On one hand I really liked the discussion of persistence models using J2EE. It was a great tutorial on the various options a J2EE developer has when dealing with databases. On the other hand, I'm disappointed that there wasn't more lower level type discussions. I ended the book feeling as if the "best practice" in Java database development is to avoid direct database development altogether and let an application server deal with it for me.

I develop standalone client/server type database applications more than anything else. I very rarely touch an application server. And unfortunately, only 2 or 3 chapters in this book were useful to me. Everything else was application server specific.

If you're doing straight JDBC development, skip this book and go for a pure JDBC book, as you'll not really get anything new or useful here. If you develop web applications, this book is definitely right up your alley.