Published By
Created On
13 Nov 2020 05:53:17 UTC
Transaction ID
Cost
Safe for Work
Free
Yes
More from the publisher
125684
Author: John Goodson
File Type: pdf
The Data Access HandbookAchieving Optimal Database Application Performance and ScalabilityJohn Goodson Robert A. StewardDrive breakthrough database application performance by optimizing middleware and connectivity Performance and scalability are more critical than ever in todays enterprise database applications, and traditional database tuning isnt 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. Todays worst performance and scalability problems are generally caused by issues with networking, database drivers, the broader softwarehardware environment, and inefficient coding of data requests. In The Data Access Handbook, two of the worlds 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 includesullClearly understanding how each component of database middleware can impact performance and scalability llWriting database applications to reduce network traffic, limit disk IO, optimize application-to-driver interaction, and simplify queriesincluding examples for ODBC, JDBC, and ADO.NET llManaging connections, transactions, and SQL statement execution more efficiently llMaking the most of connection and statement pooling llWriting good benchmarks to predict your applications performance llSystematically resolving performance problemsincluding eight start-to-finish case-study exampleslulIf youre a software architect, system designer, or database application developer, The Data Access Handbook will be your most indispensable database application performance resource. Its the one book that focuses on the areas where you can achieve the greatest improvementswhether youre 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 companys 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.**
Transaction
Created
1 year ago
Content Type
Language
application/pdf
English