Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability

Performance and scalability are more critical than ever in today’s enterprise database applications, and traditional database tuning isn’t nearly enough to solve the performance problems you are likely to see in those applications. Nowadays, 75-95% of the time it takes to process a data request is typically spent in the database middleware. Today’s worst performance and scalability problems are generally caused by issues with networking, database drivers, the broader software/hardware environment, and inefficient coding of data requests. In The Data Access Handbook, two of the world’s leading experts on database access systematically address these issues, showing how to achieve remarkable improvements in performance of real-world database applications.


Drawing on their unsurpassed experience with every leading database system and database connectivity API, John Goodson and Rob Steward reveal the powerful ways middleware affects application performance and guide developers with designing and writing API code that will deliver superior performance in each leading environment. In addition to covering essential concepts and techniques that apply across database systems and APIs, they present many API examples for ODBC, JDBC, and ADO.NET as well as database system examples for DB2, Microsoft SQL Server, MySQL, Oracle, and Sybase.

Coverage includes

  • Clearly understanding how each component of database middleware can impact performance and scalability
  • Writing database applications to reduce network traffic, limit disk I/O, optimize application-to-driver interaction, and simplify queries—including examples for ODBC, JDBC, and ADO.NET
  • Managing connections, transactions, and SQL statement execution more efficiently
  • Making the most of connection and statement pooling
  • Writing good benchmarks to predict your application’s performance
  • Systematically resolving performance problems—including eight start-to-finish case-study examples


If you’re a software architect, system designer, or database application developer, The Data Access Handbook will be your most indispensable database application performance resource. It’s the one book that focuses on the areas where you can achieve the greatest improvements—whether you’re designing new database applications or troubleshooting existing ones.


John Goodson is vice president and general manager of the DataDirect division of Progress Software, a leader in
data connectivity and mainframe integration. For 20 years, he has worked with Sun, Microsoft, and others to develop database connectivity standards such as J2EE, JDBC, ODBC, and ADO. He served on the ANSI H2 committee that built the SQL standard and now participates in the JDBC Expert Group and Java Rowsets standards committees.


Rob Steward, vice president of R&D at the DataDirect
division of Progress Software,
is responsible for the development, strategy, and oversight of the company’s data connectivity products. Rob has spent the past 15 years developing high-performing database driver and data providers, including ODBC, JDBC, and ADO.NET.

Both authors have spoken on database application performance at many industry events.


Visit www.dataaccesshandbook.com to get the code examples presented in this book and other supplemental information for DB2, MicrosoftSQL Server, MySQL, Oracle, and Sybase.


(HTML tags aren't allowed.)

Orchestrating Local Climate Policy in the European Union: Inter?Municipal Coordination and the Covenant of Mayors in Germany and France ... Energy Policy and Climate Protection)
Orchestrating Local Climate Policy in the European Union: Inter?Municipal Coordination and the Covenant of Mayors in Germany and France ... Energy Policy and Climate Protection)
Can we sidestep tedious climate policy negotiations and forge a coalition of the willing instead? Many international organizations and scholars hope to spur local climate action by orchestration, indirect and voluntary governance arrangements. Lena Bendlin looks beyond the apparent success of voluntary initiatives using the example of the...
Numerical Integration: on Advanced Computer Systems (Lecture Notes in Computer Science)
Numerical Integration: on Advanced Computer Systems (Lecture Notes in Computer Science)
This monograph is a comprehensive treatment of the theoretical and computational aspects of numerical integration.
The authors give a unique overview of the topic by bringing into line many recent research results not yet presented coherently; the extensive bibliography lists 268 items. Particular emphasis is given to the potential
Maya Feature Creature Creations (Graphics Series)
Maya Feature Creature Creations (Graphics Series)
When I was growing up, there were almost no learning resources at my disposal. Trial and error is extremely frustrating. Around the age of seven, I saw an interview with Ray Harryhausen on the making of Clash of the Titans. That was the first “making of ” I’d seen. He discussed making foam puppets from sculptures and placing...

Alfresco CMIS
Alfresco CMIS

Everything you need to know to start coding integrations with a content management server such as Alfresco in a standard way

About This Book

  • Understand what is unique about Alfresco's CMIS implementation and put your learning into practice
  • Talk to content management servers in a...
CiviCRM Cookbook
CiviCRM Cookbook

Improve your CiviCRM capabilities with this clever cookbook. Packed with recipes and screenshots, it's the natural way to dig deeper into the software and achieve more for your nonprofit or civic sector organization.


  • Take your CiviCRM skills to the next level and handle CiviCRM...
Practical Common Lisp
Practical Common Lisp

Lisp is often thought of as an academic language, but it need not be. This is the first book that introduces Lisp as a language for the real world.

Practical Common Lisp presents a thorough introduction to Common Lisp, providing you with an overall understanding of the language features and how they work. Over a third of the...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy