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

Freedom, Recognition and Non-Domination: A Republican Theory of (Global) Justice (Studies in Global Justice)
Freedom, Recognition and Non-Domination: A Republican Theory of (Global) Justice (Studies in Global Justice)

This book offers an original account of a distinctly republican theory of social and global justice. The book starts by exploring the nature and value of Hegelian recognition theory.  It shows the importance of that theory for grounding a normative account of free and autonomous agency.  It is this normative account of free agency...

Integrating PHP and XML
Integrating PHP and XML
Learn how to use SAX, XSLT, and XPath to manipulate XML documents, as well as use of XML-RPC protocol for accessing procedures on a remote computer, and much more.

PHP is a server-side scripting language used to create Web applications. XML is a markup language used to exchange data among Web applications. PHP can be...

Social Network Analysis for Startups: Finding connections on the social web
Social Network Analysis for Startups: Finding connections on the social web

Does your startup rely on social network analysis? This concise guide provides a statistical framework to help you identify social processes hidden among the tons of data now available.

Social network analysis (SNA) is a discipline that predates Facebook and Twitter by 30 years. Through expert SNA researchers, you'll...


Model-Based Design of Adaptive Embedded Systems
Model-Based Design of Adaptive Embedded Systems

This book describes model-based development of adaptive embedded systems, which enable improved functionality using the same resources. The techniques presented facilitate design from a higher level of abstraction, focusing on the problem domain rather than on the solution domain, thereby increasing development efficiency. Models are used to...

Sams Teach Yourself Programming with Java in 24 Hours (4th Edition)
Sams Teach Yourself Programming with Java in 24 Hours (4th Edition)
If you have been wanting to learn Java, check out the newly revised fourth edition of the best-seller Sams Teach Yourself Programming with Java in 24 Hours. This step-by-step tutorial will teach you how to create simple Java programs and applets. Comprised of 24 one-hour lessons, this new edition focuses on key...
Visual Studio 2005 All-In-One Desk Reference For Dummies (Computer/Tech)
Visual Studio 2005 All-In-One Desk Reference For Dummies (Computer/Tech)
If you're like me, you were probably a little perplexed by the announcement of the new Visual Studio and .NET platforms. My immediate reaction was, "Oh, no-not another set of tools to learn." Don't get me wrong. I embraced Visual Studio .NET and, like most of you, I looked forward to the stability of Visual Studio 2003 and version 1.1 of...
©2019 LearnIT (support@pdfchm.net) - Privacy Policy