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

Buy
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.)

Web Information Systems
Web Information Systems
The chapters of this book provide an excellent overview of current research
and development activities in the area of web information systems.
They supply an in-depth description of different issues in web information
systems areas, including web-based information modeling, migration between
different media types, web
...
Signal Processing for Wireless Communications
Signal Processing for Wireless Communications
Master the Signal Processing Concepts and Techniques Needed to Design and Operate Any Wireless Communications Network

Signal Processing for Wireless Communications offers communications engineers an application-focused guide to the essential concepts and techniques of wireless signal processing. This comprehensive...

Practical Computing on the Cell Broadband Engine
Practical Computing on the Cell Broadband Engine

Practical Programming in the Cell Broadband Engine offers a unique programming guide for the Cell Broadband Engine, demonstrating a large number of real-life programs to identify and solve problems in engineering, logic design, VLSI CAD, number-theory, graph-theory, computational geometry, image processing, and other subjects. This...


Delta-Sigma A/D-Converters: Practical Design for Communication Systems (Springer Series in Advanced Microelectronics)
Delta-Sigma A/D-Converters: Practical Design for Communication Systems (Springer Series in Advanced Microelectronics)

The emphasis of this book is on practical design aspects for broadband A/D converters for communication systems. The embedded designs are employed for transceivers in the field of ADSL solutions and WLAN applications. An area- and power-efficient realization of a converter is mandatory to remain competitive in the market. The right choice for...

LEGO Wind Energy: Green Energy Projects with Mindstorms EV3
LEGO Wind Energy: Green Energy Projects with Mindstorms EV3
?Build functioning wind turbines that generate electricity; we don’t mean LEGO models that look like miniature wind turbines. This book is for people who want to learn how real turbines work, and to build them using LEGO and Mindstorms EV3. 

You’ll find specific...
Raspberry Pi 3 Cookbook for Python Programmers: Unleash the potential of Raspberry Pi 3 with over 100 recipes, 3rd Edition
Raspberry Pi 3 Cookbook for Python Programmers: Unleash the potential of Raspberry Pi 3 with over 100 recipes, 3rd Edition

A recipe-based guide to programming your Raspberry Pi 3 using Python

Key Features

  • Leverage the power of Raspberry Pi 3 using Python programming
  • Create 3D games, build neural network modules, and interface with your own circuits
  • Packed with clear,...
©2019 LearnIT (support@pdfchm.net) - Privacy Policy