|
Showing 1 - 4 of
4 matches in All Departments
Tuning of SQL code is generally cheaper than changing the data
model. Physical and configuration tuning involves a search for
bottlenecks that often points to SQL code or data model issues.
Building an appropriate data model and writing properly performing
SQL code can give 100%+ performance improvement. Physical and
configuration tuning often gives at most a 25% performance
increase.
Gavin Powell shows that 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.
* Fully updated for version 10gR2 and provides all necessary
transition material from version 9i
* Includes all three aspects of Oracle database tuning: data model
tuning, SQL & PL/SQL code tuning, physical plus configuration
tuning
* Contains experienced guidance and real-world examples using large
datasets Emphasizes development as opposed to operating system
perspective
Database professionals will find that this new edition aids in
mastering the latest version of Microsoft's SQL Server. Developers
and database administrators (DBAs) use SQL on a daily basis in
application development and the subsequent problem solving and fine
tuning. Answers to SQL issues can be quickly located helping the
DBA or developer optimize and tune a database to maximum
efficiency.
Basic questions are easily located on the topics of filtering,
sorting, operators, conditionals, pseudo columns, single row
functions, joins, grouping functions, sub queries, composite
queries, hierarchies, flashback queries, parallel queries,
expressions and regular expressions. Assistance on DML, data types
(including collections), XML, DDL for basic database objects such
as tales, views and indexes, partitioning, and security is also
considered.
* Identifies the most common issues DBAs face day to day for easy
reference
*Provides DBAs with solutions actually used by the authors in
enterprise environments to resolve common and specialized problems
to optimization issues.
* Addresses issues that have been introduced by new features which
can add more control but reduce performance.
"This book should satisfy those who want a different perspective
than the official Oracle documentation. It will cover all important
aspects of a data warehouse while giving the necessary examples to
make the reading a lively experience."
- Tim Donar, Author and Systems Architect
for Enterprise Data Warehouses
Tuning a data warehouse database focuses on large
transactions, mostly requiring what is known as throughput.
Throughput is the passing of large amounts of information through a
server, network
and Internet environment, backwards and forwards, constantly! The
ultimate objective of a data warehouse is the production of
meaningful and useful reporting, from historical and archived data.
The trick is to make the reports print within an acceptable time
frame.
A data model contains tables and relationships between tables.
Tuning a data model involves Normalization and Denormalization.
Different approaches are required depending on the application,
such as OLTP or a Data Warehouse. Inappropriate database design can
make SQL code impossible to tune. Poor data modeling can have a
most profound effect on database performance since all SQL code is
constructed from the data model.
* Takes users beyond basics to critical issues in running most
efficient data warehouse applications
* Illustrates how to keep data going in and out in the most
productive way possible
* Focus is placed on Data Warehouse performance tuning
Developers and DBAs use Oracle SQL coding on a daily basis, whether
for application development, finding problems, fine-tuning
solutions to those problems, or other critical DBA tasks. Oracle
SQL: Jumpstart with Examples is the fastest way to get started and
to quickly locate answers to common (and uncommon) questions. It
includes all the basic queries: filtering, sorting, operators,
conditionals, pseudocolumns, single row functions, joins, grouping
and summarizing, grouping functions, subqueries, composite queries,
hierarchies, flashback queries, parallel queries, expressions and
regular expressions, DML, datatypes (including collections), XML in
Oracle, DDL for basic database objects such as tales, views and
indexes, Oracle Partitioning, security, and finally PL/SQL.
* Each of the hundreds of SQL code examples was tested on a working
Oracle 10g database
* Invaluable everyday tool that provides an absolute plethora of
properly tested examples of Oracle SQL code
* Authors have four decades of commercial experience between them
as developers and database administrators
|
You may like...
Midnights
Taylor Swift
CD
R425
Discovery Miles 4 250
Loot
Nadine Gordimer
Paperback
(2)
R398
R330
Discovery Miles 3 300
|