"Java Database Best Practices rescues you from having to wade through books on each of the various APIs before figuring 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 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.
Enterprise applications in today's world are about data-- whether it be information about a product to buy, a user's credit card information, or the color that a customer prefers for their auto purchases. And just as data has grown in importance, the task of accessing that data has grown in complexity. Until now, you have been left on your own to determine which model best suits yourapplication, and how best to use your chosen API. "Java Database Practices is the one stop reference book to help you determine what's appropriate for your specific project at hand. Whether it's choosing between an alphabet soup of APIs and technologies--EJB, JDO, JDBC, SQL, RDBMS, OODBMS, and more on the horizon, this book is an indispensable resource you can't do without.
Preface Part I. Data Architecture 1. Elements of Database Applications Database Application Architectures Component Models Persistence Models 2. Relational Data Architecture Relational Concepts Modeling Normalization Denormalization Object-Relational Mapping 3. Transaction Management Transactions Concurrency JDBC Transaction Management Transaction Management Paradigms Part II. Persistence Models 4. Persistence Fundamentals Patterns of Persistence A Guest Book Application 5. EJB CMP Which CMP Model to Use? The EJB 1.0 CMP Model The EJB 2.0 CMP Model Beyond CMP 6. EJB BMP EJBs Revisited BMP Patterns State Management Exception Handling 7. JDO Persistence JDO or EJB? Basic JDO Persistence EJB BMP with JDO 8. Alternative Persistence Frameworks Why Alternative Frameworks? Persistence Approach Persistence Operations Searches Beyond the Basics Part III. Tutorials 9. J2EE Basics The Platform Java Naming and Directory Interface JavaServer Pages Remote Method Invocation Enterprise JavaBeans 10. SQL Background Database Creation Table Management Data Management 11. JDBC Architecture Simple Database Access Advanced JDBC 12. JDO Architecture Enhancement Queries Changes Transactions Inheritance Index
George Reese has taken an unusual path into business software development. After earning a B.A. in philosophy from Bates College in Lewiston, Maine, George went off to Hollywood where he worked on television shows such as "The People's Court" and ESPN's "Up Close". The L.A. riots convinced him to return to Maine where he finally became involved with software development and the Internet. George has since specialized in the development of Internet-oriented Java enterprise systems and the strategic role of technology in business processes. He is the author of Database Programming with JDBC and Java, 2nd Edition and the world's first JDBC driver, the mSQL-JDBC driver for mSQL. He currently lives in Minneapolis, Minnesota with his wife Monique and three cats, Misty, Gypsy, and Tia. He makes a living as the National Practice Director of Technology Strategy for digital@jwt in Minneapolis.