Enterprise applications are about data-whether it is information about a product, the details of a user's credit card, or the color that customers prefer for their auto purchases. And as the importance of data has grown, so has the complexity of accessing that data. Java programmers now must choose between an alphabet soup of APIS and technologies - EJB, JDO, JDBC, SQL, RDBMS, OOIDMBS, and more on the horizon.
Until now, developers have been loft on their own to determine which model best suits their application, and how best to use their chosen API. Java Database Best Practices rescues developers from having to wade through books on each of the various APIS before they figure out which method to use! This comprehensive guide introduces each of the dominant APIs (Enterprise JavaBeans, Java Data Objects, the Java Database Connectivity API (JDBC) as well as other, lesser-known options), explores the methodology and design components that use those APIS, and then offers practices most appropriate for different types and makes of databases, as well as different types of applications.
Java Database Best Practices also examines database design, from table and database architecture to normalization, and offers a number of best practices for handling these tasks. You'll 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.