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

3.2 avg rating
( 5 ratings by GoodReads )
 
9780137143931: The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability

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.

 

"synopsis" may belong to another edition of this title.

Product Description:

The Data Access Handbook 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 pro... Full description

About the Author:

John Goodson: As the executive leader of DataDirect Technologies, John is responsible for daily operations, business development, product direction, and long-term corporate strategy.

 

John was a principal engineer at Data General for seven years, working on their relational database product, DG/SQL. Since joining DataDirect Technologies in 1992, he has held positions of increasing responsibility in research and development, technical support, and marketing. John is a well-known and respected industry luminary and data connectivity expert. For more than 15 years, he has worked closely with Sun Microsystems and Microsoft on the development and evolution of database connectivity standards including J2EE, JDBC, .NET, ODBC, and ADO. John has been involved with the ANSI NCITS H2 Committee, which is responsible for building the SQL standard, and the X/Open (Open Group) SQL Access Group, which is responsible for building call-level interfaces into relational databases. He is actively involved in Java standards committees, including the JDBC Expert Group. In addition, John has published numerous articles and spoken publicly on topics related to data management. John is also a patent holder in the area of distributed transactions for Microsoft SQL Server Java middleware.

 

John holds a Bachelor of Science in computer science from Virginia Polytechnic Institute and State University in Blacksburg,Virginia.

 

Rob Steward: As vice president of research and development for DataDirect Technologies, Rob is responsible for the development, strategy, and oversight of the company’s data connectivity products, including the Shadow mainframe integration suite client software and the industry-leading DataDirect Connect family of database drivers and data providers: Connect for ODBC, Connect for JDBC, and Connect for ADO.NET. Additional product development responsibilities include DataDirect Sequelink and DataDirect XQuery, as well as the management of DataDirect’s Custom Engineering Development group.

 

Rob has spent more than 15 years developing database access middleware, including .NET data providers, ODBC drivers, JDBC drivers, and OLE DB data providers. He has held a number of management and technical positions at DataDirect Technologies and serves on various standards committees. Earlier in his career, he worked as lead software engineer at Marconi Commerce Systems Inc.

 

Rob holds a Bachelor of Science in computer science from North Carolina State University, Raleigh.

 

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Goodson, John; Steward, Robert A.
Published by Prentice Hall (2009)
ISBN 10: 0137143931 ISBN 13: 9780137143931
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description Prentice Hall, 2009. Paperback. Book Condition: New. book. Bookseller Inventory # 0137143931

More Information About This Seller | Ask Bookseller a Question

Buy New
19.76
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

2.

Goodson, John and Steward, Robert A.
Published by Prentice Hall 1, United States
ISBN 10: 0137143931 ISBN 13: 9780137143931
New Trade Paperback Quantity Available: 1
Seller
Powell's Books
(Portland, OR, U.S.A.)
Rating
[?]

Book Description Prentice Hall 1, United States. Trade Paperback. Book Condition: New. TRADE PAPERBACK Legendary independent bookstore online since 1994. Reliable customer service and no-hassle return policy. Science and Mathematics>Mathematics>General. Book: NEW, New. Bookseller Inventory # 64978013714393100. Bookseller Inventory # 64978013714393100

More Information About This Seller | Ask Bookseller a Question

Buy New
20.64
Convert Currency

Add to Basket

Shipping: 3.60
Within U.S.A.
Destination, Rates & Speeds

3.

John Goodson and Robert A. Steward
ISBN 10: 0137143931 ISBN 13: 9780137143931
New Quantity Available: 1
Seller
Castle Rock
(Pittsford, NY, U.S.A.)
Rating
[?]

Book Description Book Condition: Brand New. Book Condition: Brand New. Bookseller Inventory # 97801371439311.0

More Information About This Seller | Ask Bookseller a Question

Buy New
23.23
Convert Currency

Add to Basket

Shipping: 3.20
Within U.S.A.
Destination, Rates & Speeds

4.

Goodson, JohnSteward, Robert A.
Published by Prentice Hall
ISBN 10: 0137143931 ISBN 13: 9780137143931
New Quantity Available: > 20
Seller
INDOO
(Avenel, NJ, U.S.A.)
Rating
[?]

Book Description Prentice Hall. Book Condition: New. Brand New. Bookseller Inventory # 0137143931

More Information About This Seller | Ask Bookseller a Question

Buy New
31.78
Convert Currency

Add to Basket

Shipping: 2.81
Within U.S.A.
Destination, Rates & Speeds

5.

Goodson, John, Steward, Robert A.
Published by Prentice Hall (2009)
ISBN 10: 0137143931 ISBN 13: 9780137143931
New Paperback Quantity Available: 3
Seller
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Prentice Hall, 2009. Paperback. Book Condition: New. Bookseller Inventory # P110137143931

More Information About This Seller | Ask Bookseller a Question

Buy New
35.81
Convert Currency

Add to Basket

Shipping: 2.40
Within U.S.A.
Destination, Rates & Speeds

6.

Robert A.; Steward
Published by Prentice Hall Computer (2009)
ISBN 10: 0137143931 ISBN 13: 9780137143931
New Taschenbuch Quantity Available: 1
Seller
unifachbuch
(Köln, NRW, Germany)
Rating
[?]

Book Description Prentice Hall Computer, 2009. Taschenbuch. Book Condition: Neu. Gebraucht - Wie neu Unbenutzt. Schnelle Lieferung, Kartonverpackung. Abzugsfähige Rechnung. Bei Mehrfachbestellung werden die Versandkosten anteilig erstattet. - Sehr guter Zustand - UNBENUTZT - schnelle Lieferung, abzugsfähige Rechnung liegt bei 333 pp. Deutsch. Bookseller Inventory # INF1000037654

More Information About This Seller | Ask Bookseller a Question

Buy New
17.79
Convert Currency

Add to Basket

Shipping: 22.08
From Germany to U.S.A.
Destination, Rates & Speeds

7.

John Goodson, Robert A. Steward
Published by Prentice Hall (2009)
ISBN 10: 0137143931 ISBN 13: 9780137143931
New Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Prentice Hall, 2009. Paperback. Book Condition: New. 1. Bookseller Inventory # DADAX0137143931

More Information About This Seller | Ask Bookseller a Question

Buy New
37.77
Convert Currency

Add to Basket

Shipping: 3.20
Within U.S.A.
Destination, Rates & Speeds

8.

Goodson, John; Steward, Robert A.
Published by Prentice Hall (2009)
ISBN 10: 0137143931 ISBN 13: 9780137143931
New Softcover Quantity Available: > 20
Seller
Palexbooks
(Sanford, NC, U.S.A.)
Rating
[?]

Book Description Prentice Hall, 2009. Book Condition: New. Brand new! Please provide a physical shipping address. Bookseller Inventory # 9780137143931

More Information About This Seller | Ask Bookseller a Question

Buy New
55.29
Convert Currency

Add to Basket

Shipping: 2.41
Within U.S.A.
Destination, Rates & Speeds

9.

Goodson, John/ Steward, Robert A.
Published by Prentice Hall (2009)
ISBN 10: 0137143931 ISBN 13: 9780137143931
New Paperback Quantity Available: 1
Seller
Revaluation Books
(Exeter, United Kingdom)
Rating
[?]

Book Description Prentice Hall, 2009. Paperback. Book Condition: Brand New. 1st edition. 600 pages. 9.25x7.00x1.25 inches. In Stock. Bookseller Inventory # zk0137143931

More Information About This Seller | Ask Bookseller a Question

Buy New
53.23
Convert Currency

Add to Basket

Shipping: 6
From United Kingdom to U.S.A.
Destination, Rates & Speeds