Goodreads helps you keep track of books you want to read.

Start by marking “The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability” as Want to Read:

Other editions

Enlarge cover

Rate this book

Clear rating

1 of 5 stars 2 of 5 stars 3 of 5 stars 4 of 5 stars 5 of 5 stars

Open Preview

The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability

by John Goodson, Robert A. Steward

3.2 · Rating Details · 5 Ratings · 0 Reviews

The Data Access Handbook" Achieving Optimal Database Application Performance and Scalability John Goodson Robert A. Steward Drive breakthrough database application performance by optimizing middleware and connectivity Performance and scalability are more critical than ever in today s enterprise database applications, and traditional database tuning isn t nearly enough to s The Data Access Handbook" Achieving Optimal Database Application Performance and Scalability John Goodson Robert A. Steward Drive breakthrough database application performance by optimizing middleware and connectivity 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. ...more

Paperback, 333 pages

Published March 1st 2009 by Prentice Hall PTR (first published 2009)

More Details... edit details

Get a copy:

Or buy for

Friend Reviews

To see what your friends thought of this book, please sign up.

Reader Q&A

To ask other readers questions about The Data Access Handbook, please sign up.

Be the first to ask a question about The Data Access Handbook

Lists with This Book

This book is not yet featured on Listopia. Add this book to your favorite list »

Community Reviews

(showing 1-16 of 16)

filter | sort: default (?) | Rating Details

Dragos Comaneci marked it as to-read
Aug 12, 2016

Vasiliy Sushko marked it as to-read
Aug 06, 2016

Wil rated it liked it
May 28, 2016

Jennifer Lill marked it as to-read
Nov 13, 2015

0x3044 added it
Dec 08, 2015

Spazzycat rated it really liked it
May 02, 2015

Todd Everett added it
Oct 17, 2014

Fábio Nonato marked it as to-read
Sep 30, 2014

John rated it really liked it
Sep 30, 2014

Steven Engelhardt rated it it was ok
Jun 14, 2014

Hertzel Karbasi added it
May 13, 2013

Rado added it
Apr 23, 2013

Claude Gill added it
Feb 28, 2013

Yossi rated it liked it
Jun 12, 2012

Ben added it
Aug 31, 2011

Alain marked it as to-read
Aug 25, 2011

new topic
Discuss This Book

There are no discussion topics on this book yet. Be the first to start one »

Recommend It | Stats | Recent Status Updates

Books by John Goodson

Star Wars: The Force Awakens: The Visual Dictionary

Star Wars: Episode III - Revenge of the Sith: The Visual Dictionary

Star Wars : Le Réveil de la Force : L'encyclopédie illustrée

More…

Share This Book

+ Share on your website

Trivia About The Data Access H...

No trivia or quizzes yet. Add some now »

title link	preview: The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability
avg rating	preview: The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability Goodreads rating: 3.20 (5 ratings)
small image	preview: click here [close]
med image	preview: click here [close]
BBCode	[url=https://www.goodreads.com/book/show/7047042-the-data-access-handbook?utm_medium=api&utm_source=blog_book][img]https://d.gr-assets.com/books/1348078254l/7047042.jpg[/img][/url] [url=https://www.goodreads.com/book/show/7047042-the-data-access-handbook?utm_medium=api&utm_source=blog_book]The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability by John Goodson[/url]

See a Problem?

Preview — The Data Access Handbook by John Goodson

The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability

Friend Reviews

Reader Q&A

Lists with This Book

Community Reviews

new topic
Discuss This Book

Books by John Goodson

Share This Book

Share on your website

Trivia About The Data Access H...

See a Problem?

Preview — The Data Access Handbook by John Goodson

The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability

Friend Reviews

Reader Q&A

Lists with This Book

Community Reviews

new topicDiscuss This Book

Books by John Goodson

Share This Book

Share on your website

Trivia About The Data Access H...

new topic
Discuss This Book