*Targets the no.1 Oracle performance bottleneck: SQL and PL/SQL *For all releases through Oracle 8i *Detailed case studies and performance measurements *Large-volume queries, Oracle clusters, Java, parallel query tuning, and much more Your one-stop resource for all Oracle SQL and PL/SQL tuning and optimization! Optimizing SQL code is the no.1 factor in improving Oracle database performance, yet most guides to Oracle tuning virtually ignore SQL. Oracle SQL High Performance Tuning, Second Edition zeroes in on SQL and PL/SQL, demonstrating how to achieve performance gains of 100% or more in many applications. Expert Oracle developer Guy Harrison gives Oracle developers and DBAs a single source for guidance on every aspect of Oracle 8/8i SQL and PL/SQL tuning, with specific recommendations, detailed case studies, and real benchmarks. Coverage includes: *Designing applications to maximize efficiency right from the start *Building indexes that support high-performance queries *Identifying and resolving Oracle Server bottlenecks *Fixing poorly performing SQL code *Identifying opportunities to substitute PL/SQL or Java for SQL *Making the most of Oracles tuning tools, including tkprof and

Oracle SQL High-Performance Tuning

Computers & Technology

Harrison, Guy

Software

Pearson P T R

A succinct manual for those already familiar with the software package but need reminders now and then on some of the more arcane features. Harrison, who has written extensively about Oracle, explains all SQL commands, functions, operators, datatypes, and hints; the data definition language; export, import, and other utilities; Oracle Java; and other aspects. He lists Internet resources but includes no bibliography. Annotation c. Book News, Inc., Portland, OR (booknews.com)

Oracle Desk Reference

Prentice Hall PTR

A guide to using Oracle's parallel query facility for large volume queries focusing on SQL and PL/SQL. Harrison, an Oracle developer and consultant, overviews SQL processing and introduces guidelines to improve applications, including execution plans, work with joins, nulls and ranges search, index building, hierarchical queries, table scans, GROUP BY, updates, and distributed SQL. The accompanying CD-ROM features a set of tools for detecting and correcting SQL bottlenecks. Annotation c. by Book News, Inc., Portland, Or.

Oracle Performance Survival Guide A Systematic Approach to Database Optimization The fast, complete, start-to-finish guide to optimizing Oracle performance Oracle Performance Survival Guide offers a structured, systematic, start-to-finish methodology for optimizing Oracle performance as efficiently as possible. Leading Oracle expert Guy Harrison shows how to maximize your tuning investment by focusing on causes rather than symptoms, and by quickly identifying the areas that deliver the greatest “bang for the buck.” Writing for DBAs and developers with all levels of experience, Harrison covers every area of Oracle performance management, from application design through SQL tuning, contention management through memory and physical IO management. He also presents up-to-the-minute guidance for optimizing the performance of the Oracle 11g Release 2. You’ll start by mastering Oracle structured performance tuning principles and tools, including techniques for tracing and monitoring Oracle execution. Harrison illuminates the interaction between applications and databases, guides you through choosing tuning tools, and introduces upfront design techniques that lead to higher-performance applications. He also presents a collection of downloadable scripts for reporting on all aspects of database performance. Coverage includes • “Tuning by layers,” the most effective, highest-value approach to Oracle performance optimization • Making the most of Oracle’s core tools for tracing, monitoring, and diagnosing performance • Highly efficient database logical and physical design, indexing, transaction design, and API use • SQL and PL/SQL tuning, including the use of parallel SQL techniques • Minimizing contention for locks, latches, shared memory, and other database resources • Optimizing memory and physical disk IO • Tuning Real Application Cluster (RAC) databases guyharrison.net informit.com/ph

Oracle Performance Survival Guide: A Systematic Approach to Database Optimization

Programming

PRENTICE/HALL

The implementation of stored procedures in MySQL 5.0 a hugemilestone -- one that is expected to lead to widespread enterprise adoption ofthe already extremely popular MySQL database. If you are serious aboutbuilding the web-based database applications of the future, you need toget up to speed quickly on how stored procedures work -- and how tobuild them the right way. This book, destined to be the bible of storedprocedure development, is a resource that no real MySQL programmer canafford to do without. In the decade since MySQL burst on the scene, it has become thedominant open source database, with capabilities and performancerivaling those of commercial RDBMS offerings like Oracle and SQLServer. Along with Linux and PHP, MySQL is at the heart of millions ofapplications. And now, with support for stored procedures, functions,and triggers in MySQL 5.0, MySQL offers the programming power neededfor true enterprise use. MySQL's new procedural language has a straightforward syntax, making iteasy to write simple programs. But it's not so easy to write secure,easily maintained, high-performance, and bug-free programs. Few in theMySQL world have substantial experience yet with stored procedures, butGuy Harrison and Steven Feuerstein have decades of combined expertise. In MySQL Stored Procedure Programming, they putthat hard-won experience to good use. Packed with code examples and coveringeverything from language basics to application building to advancedtuning and best practices, this highly readable book is the one-stopguide to MySQL development. It consists of four major sections:
<ul>
<li>MySQL stored programming fundamentals -- tutorial, basicstatements, SQL in stored programs, and error handling</li>
<li>Building MySQL stored programs -- transaction handling,built-in functions, stored functions, and triggers</li>
<li>MySQL stored programs in applications -- using storedprograms with PHP, Java, Perl, Python, and .NET (C# and VB.NET)</li>
<li>Optimizing MySQL stored programs -- security, basic andadvanced SQL tuning, optimizing stored program code, and programmingbest practices</li>
</ul>
A companion web site contains many thousands of lines of code, that youcan put to use immediately.
Guy Harrison is Chief Architect of Database Solutions at Quest Softwareand a frequent speaker and writer on MySQL topics. Steven Feuerstein isthe author of Oracle PL/SQL Programming, the classic reference for Oracle stored programming for more than ten years. Both have decades of experience as database developers, and between them they have authored a dozen books.

MySQL Stored Procedure Programming: Building High-Performance Web Applications in MySQL

Feuerstein, Steven

Web Development & Design

O'Reilly Media

Get the lowdown on CockroachDB, the distributed SQL database built to handle the demands of today's data-driven cloud applications. In this hands-on guide, software developers, architects, and DevOps/SRE teams will learn how to use CockroachDB to create applications that scale elastically and provide seamless delivery for end users while remaining indestructible. Teams will also learn how to migrate existing applications to CockroachDB's performant, cloud native data architecture. 
If you're familiar with distributed systems, you'll quickly discover the benefits of strong data correctness and consistency guarantees as well as optimizations for delivering ultra low latencies to globally distributed end users. 
You'll learn how to: Design and build applications for distributed infrastructure, including data modeling and schema design Migrate data into CockroachDB Read and write data and run ACID transactions across distributed infrastructure Plan a CockroachDB deployment for resiliency across single region and multi-region clusters Secure, monitor, and optimize your CockroachDB deployment

CockroachDB: The Definitive Guide: Distributed Data at Scale

Seldess, Jesse

Darnell, Ben

Programming Languages

Reid, Rob

"It’s not easy to find such a generous book on big data and databases. Fortunately, this book is the one." Feng Yu. Computing Reviews. June 28, 2016. This is a book for enterprise architects, database administrators, and developers who need to understand the latest developments in database technologies. It is the book to help you choose the correct database technology at a time when concepts such as Big Data, NoSQL and NewSQL are making what used to be an easy choice into a complex decision with significant implications. The relational database (RDBMS) model completely dominated database technology for over 20 years. Today this "one size fits all" stability has been disrupted by a relatively recent explosion of new database technologies. These paradigm-busting technologies are powering the "Big Data" and "NoSQL" revolutions, as well as forcing fundamental changes in databases across the board. Deciding to use a relational database was once truly a no-brainer, and the various commercial relational databases competed on price, performance, reliability, and ease of use rather than on fundamental architectures. Today we are faced with choices between radically different database technologies. Choosing the right database today is a complex undertaking, with serious economic and technological consequences. Next Generation Databases demystifies today’s new database technologies. The book describes what each technology was designed to solve. It shows how each technology can be used to solve real word application and business problems. Most importantly, this book highlights the architectural differences between technologies that are the critical factors to consider when choosing a database platform for new and upcoming projects.
<ul>
<li>Introduces the new technologies that have revolutionized the database landscape 
</li>
<li>Describes how each technology can be used to solve specific application or business challenges 
</li>
<li>Reviews the most popular new wave databases and how they use these new database technologies 
</li>
</ul>

Next Generation Databases: NoSQLand Big Data

Computer Science

Apress

Product Description 
Intermediate-Advanced user level 
 From the Back Cover 
Use this fast and complete guide to optimize the performance of MongoDB databases and the applications that depend on them. You will be able to turbo-charge the performance of your MongoDB applications to provide a better experience for your users, reduce your running costs, and avoid application growing pains. MongoDB is the world’s most popular document database and the foundation for thousands of mission-critical applications. This book helps you get the best possible performance from MongoDB.\nMongoDB Performance Tuning takes a methodical and comprehensive approach to performance tuning that begins with application and schema design and goes on to cover optimization of code at all levels of an application. The book also explains how to configure MongoDB hardware and cluster configuration for optimal performance. The systematic approach in the book helps you treat the true causes of performance issues and get the best return on your tuning investment. Even when you’re under pressure and don’t know where to begin, simply follow the method in this book to set things right and get your MongoDB performance back on track.\nYou will:\nApply a methodical approach to MongoDB performance tuning 
Understand how to design an efficient MongoDB application 
Optimize MongoDB document design and indexing strategies 
Tune MongoDB queries, aggregation pipelines, and transactions 
Optimize MongoDB server resources: CPU, memory, disk 
Configure MongoDB Replica sets and Sharded clusters for optimal performance\nAbout the Author 
​ 
Guy Harrison is CTO at ProvenDB, a partner at Toba Capital, and a software professional with more than 20 years of experience in database design, development, administration, and optimization. He is the author of 
Next Generation Databases (Apress) and other books and articles on database technology. He is a MongoDB certified DBA and developer, and an Oracle ACE. \nMichael Harrison is the lead developer at ProvenDB, working intimately with MongoDB from both an application and database perspective. He is a co-author of 
The MongoDB Workshop as well as senior developer of DBKoda, an open-source development environment for MongoDB.

MongoDB Performance Tuning: Optimizing MongoDB Databases and their Applications

HARRISON, Michael

Elegant and descriptive, SQL has long been the essential language for relational databases, but it’s a complex language to learn and use. Ideal for experienced programmers, analysts, and database administrators, this comprehensive reference guide clearly documents every SQL command and reference with practical examples that illustrate important concepts and uses. It's a wealth of information packed into a succinct, comprehensive, and easy-to-use format.The updated fourth edition of SQL in a Nutshell explains how to implement SQL in leading commercial and open source database products, such as Oracle, DB2, SQL Server, and MySQL.

SQL in a Nutshell: A Desktop Quick Reference Guide

Kline, Kevin

Kline, Daniel

Douglas, Richard

Hunt, Brand

Reference

See the best price to sell, buy, or rent books by Harrison, Guy. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Harrison, Guy

See the best price to sell, buy, or rent books by Harrison, Guy. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Oracle SQL High-Performance Tuning

Oracle Desk Reference

Oracle SQL High-Performance Tuning

Oracle Performance Survival Guide: A Systematic Approach to Database Optimization

MySQL Stored Procedure Programming: Building High-Performance Web Applications in MySQL

CockroachDB: The Definitive Guide: Distributed Data at Scale

CockroachDB: The Definitive Guide: Distributed Data at Scale

Next Generation Databases: NoSQLand Big Data

MongoDB Performance Tuning: Optimizing MongoDB Databases and their Applications

SQL in a Nutshell: A Desktop Quick Reference Guide