Oracle High Performance Tuning for 9i.and.10g

There are three parts to tuning an Oracle database: data modeling,
SQL code tuning and physical database configuration.

A data model contains tables and relationships between tables.
Tuning a data model involves normalization and de-normalization.
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.

Poorly written SQL code is often a culprit of performance problems
and is expensive to rectify. However, tuning of SQL code is
generally cheaper than changing the data model. SQL code tends to
be contained inside independent blocks within applications or
stored procedures.

Physical database tuning involves hardware resource usage,
networking and various other Oracle things such as configuration
and file distribution. Physical configuration is often a culprit of
poor performance where Oracle is installed with defaults, and never
altered by an expert.

Download Here

First Look 2007 Microsoft Office System

Book Description:

What�s inside the newest release of the Microsoft Office system? How will the new interface change the way you work and make you more self-sufficient and effective? How can your business put the new workflow capabilities to work right away in this new world of work? With FIRST LOOK 2007 MICROSOFT OFFICE SYSTEM, well-known author and columnist Katherine Murray gives you an special introduction to the next generation of Microsoft Office. You�ll get an expert overview of new and enhanced applications, features, and capabilities in addition to advance insights and straight talk from the Office product group, Discover the new user interface and revolutionize the way you use Office; learn about the Live Preview feature that allows you to see how a format will look before you make a change; introduce yourself to the new collaboration products and services, including Microsoft Office Groove. In addition, learn about enhancements to existing Office applications, including new graphics capabilities in Microsoft Office PowerPoint, easier database creation with Microsoft Office Access, easier time-management capabilities in Microsoft Office Outlook, and improved charting capabilities in Microsoft Office Excel.

It�s an exclusive, guided preview for business decision makers, early adopters, and users�and anyone else who wants to start planning and hit the ground running with the next generation of Office.

Download e-book