Database Application Performance
Database: Principles, Programming, and Performance, Second Edition
A standard text for database designers and programmers, Database: Principles, Programming, and Performance is out in a new edition. This latest version of the detailed work of the O'Neils includes a new chapter on Object-Relational Structured Query Language (SQL) and its implementations in Oracle and Informix products. On top of that, the authors have revised their chapters on basic and advanced SQL, and added product- specific details (particularly having to do with Oracle, Informix, and IBM DB2 database products) to most areas of their coverage. As a result of these revisions, this book does a great job of balancing academic material with practical examples.
Configuring and Tuning Databases on the Solaris Platform
An engineer at Sun Microsystems describes database tuning for multiple databases, in contrast to the product-specific guides that are most common. Identifying aspects that are common across the major products, he considers such topics as database concepts, hardware architecture, the buffer cache, and the optimizer. He uses the Solaris Operating Environment, but says the principles and much of the detail should also apply to other UNIX systems.
Rapid Testing
A three-part approach is described here for streamlining the software testing process. The books covers the testing life cycle, including planning and test case design and development, bug tracking and reporting, verification and validation techniques, testing metrics, and test resource estimation. Principles and processes of rapid testing are explained, and tips and real-life examples are given, along with a complete set of sample test documentation. Culbertson has 25 years of experience in engineering, software development and testing, and project management.
SQL Performance Tuning
SQL Performance Tuning is a handbook of practical solutions for busy database professionals charged with managing an organization's critically important data. Covering today's most popular and widely installed database environments, this book is an indispensable resource for managing and tuning SQL across multiple platforms.
Oracle SQL High-Performance Tuning (2nd Edition)
A guide for Oracle developers and database administrators, covering 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, building indexes, identifying and resolving Oracle Server bottlenecks, fixing poorly performed SQL code, and leveraging Oracle's parallel query facility. Harrison is author of several books on Oracle.
Microsoft SQL Server 2000 Performance Tuning
MICROSOFT SQL SERVER 2000 PERFORMANCE TUNING TECHNICAL REFERENCE provides all the information that developers and database administrators need to configure Microsoft SQL Server 2000 for optimum performance and scalability. Unlike other SQL Server 2000 tuning books on the market, it teaches not just about the SQL Server relational database management system, but also about how to get the most out of the underlying operating system and hardware. The advanced information it presents is easy to grasp because the authors start with the basics and build upon information in previous chapters to teach the mechanics of performance tuning and how they affect the whole system. This title has been thoroughly revised since the last edition and includes new information throughout.
OCP Oracle9i Database: Performance Tuning Exam Guide
Prepare to pass the Oracle9i OCP DBA Performance Tuning exam using this focused, and complete guide. Covering all official exam objectives and containing over 300 practice questions, chapter self-tests, two minute drills, a glossary of key Oracle terms--plus a CD-ROM with a testing engine that simulates the actual exam--this is the best study tool available.
Database Performance Tuning and Optimization
Provides comprehensive coverage of database performance tuning using Oracle 8i and select 9i examples as the RDBMS. Combines theory with practical tools to address the tuning and optimization issues of DBAs and developers, irrespective of whether they use Oracle.
High-Performance Oracle: Proven Methods for Achieving Optimum Performance and Availability (PDF download)
Hands-on, loaded with tips and techniques for ensuring that the entire Oracle database system runs efficiently and doesn't break down. Written for Oracle developers and DBAs. Covers both Oracle 8i and Oracle9i.
Sybase ASE 12.5 Performance and Tuning
From benchmarking your system and optimizing storage procedures to indexing and using sp_sysmon to monitor your system, the authors thoroughly explain how to tune your server for maximum performance. A must for those who are responsible for maximizing server performance.
Oracle Performance Tuning
Whalen and Schroeter run a performance tuning company, and here explain how to configure the Oracle database software package to perform optimally. Tuning must be done holistically, they argue, and optimal performance cannot be achieved by focusing on one part of the system. So they explore all areas from SQL statements to the operation of the disk drive.
Oracle Applications Performance Tuning Handbook
A complete guide to resolving and troubleshooting complex Oracle system problems. The CD-ROM contains Tuning ToolKit featuring PC and networking utilities and Oracle support white papers.
Database Tuning: Principles, Experiments, and Troubleshooting Techniques
Tuning your database for optimal performance means more than following a few short steps in a vendor-specific guide. For maximum improvement, you need a broad and deep knowledge of basic tuning principles, the ability to gather data in a systematic way, and the skill to make your system run faster. This is an art as well as a science, and Database Tuning: Principles, Experiments, and Troubleshooting Techniques will help you develop portable skills that will allow you to tune a wide variety of database systems on a multitude of hardware and operating systems. Further, these skills, combined with the scripts provided for validating results, are exactly what you need to evaluate competing database products and to choose the right one.
Managing Reference Data in Enterprise Databases
This book describes the different aspects of managing reference data. It is the only book available on this topic and provides both a conceptual foundation and practical advice. It is oriented to a general audience and can be read by both IT professionals and anyone with an interest in how an enterprise should manage its information. Some data modeling notations are used, but these are explained at the beginning of the book. Reference data concepts are introduced and their importance is explored. The management consequences of the unique characteristics of reference data are then described, along with techniques for managing reference data.
Security Planning and Disaster Recovery
Proactively implement a successful security and disaster recovery plan--before a security breach occurs. Including hands- on security checklists, design maps, and sample plans, this expert resource is crucial for keeping your network safe from any outside intrusions.
Oracle Data Warehouse Tuning for 10g
There are thousands of installed Oracle data warehouses in operation today throughout the world. In general data warehouses are created to help alleviate performance pressure on over-stressed online Internet databases (OLTP databases). Tuning a data warehouse is vastly different to that of tuning OLTP databases (including client-server and transactional databases). Data warehouses store historical data, used for forecasting and planning.
It is likely that data warehouse databases will become more common than they are today and perhaps even exceed OLTP databases in number, if they do not already do so. As a result, a data warehouse tuning book applies to not only Oracle technical people but most importantly, to any type of Oracle users, on a global scale including end-users. This book will be second level for our series as Hobbs is a more basic book and this moves to more advanced issues.
Oracle Performance Tuning for 10gR2, Second Edition
The central theme of Oracle10gR2 Performance Tuning is four-fold: denormalize data models to fit applications; tune SQL code according to both the data model and the application in relation to scalability; create a well-proportioned physical architecture at the time of initial Oracle installation; and most important, mix skill sets to obtain the best results.
SQL Server 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Cert.
Hit the ground running with the street-smart training you'll find in this practical book. Using a "Year in the life" approach, it gives you an inside look at SQL Server 2005 database administration, with key information organized around the actual day-to-day tasks, scenarios, and challenges you'll face in the field. This valuable training tool is loaded with hands-on, step-by-step exercises covering all phases of SQL Server 2005 administration, including:
- Installing and configuring SQL Server
- High availability and disaster recovery
- Maintenance and automation
- Monitoring and troubleshooting
Physical Database Design
Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more.
The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability, and DBAs are under greater pressure than ever to optimize database structure for system performance and administration.
Physical Database Design discusses the concept of how physical structures of databases affect performance and includes specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations. Something as simple as improving the table index design has a profound impact on performance. Every form of relational database, such as Online Transaction Processing (OLTP), Enterprise Resource Management (ERP), Data Mining (DM), or Management Resource Planning (MRP), can be improved using these methods.
Seven Steps to Strategy Execution
Seven Steps to Strategy Execution gives organizations a logical framework to help them communicate strategy to the people and processes that make it a reality. And it further builds organizational capability by continually measuring performance against the organization's selected strategy performance metrics.
The collaborative work of J. Kent Crawford, founder and CEO of PM Solutions, Jeannette Cabanis-Brewin, editor-in-chief of the CBP, and Jim Pennypacker, director of the CBP, "Seven Steps to Strategy Execution" is a 316-page paperback offering practical advice for organizations struggling to effectively execute their corporate strategies. The book introduces an approach called Strategy Performance Management (SPM), which advocates the integration of governance and performance management in seven key areas: Strategy Management, Project Portfolio Management, Program and Project Management, Information Technology, Structure, Cultureand People.
Oracle PL/SQL: Expert Techniques For Developers and Database Administrators
This book takes you beyond the existing solutions found in other professional and reference texts or in online documentation. Starting from PL/SQL internals that include PL/SQL program structure, internal representation, compilation, and execution, users are taught PL/SQL concepts and techniques that go way beyond SQL, such as data structure management, error management, data management, application management, and transaction management.
