Master the three parts of 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 nNormalization and dDe-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 in performance problems and is expensive to rectify. However, tuning of SQL code is generally cheaper than changing the data model. SQL code tend to be contained inside independent blocks within applications or stored procedures.
Physical database tuning involves hardware resource usage, networking and various other Oracle components 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.
- 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
Trade Like Jesse Livermore (Wiley Trading) The secret to Jesse Livermore’s legendary trading success
Although he began his career in 1892, Jesse Livermore is still considered to be one of the world’s greatest traders. In life and in death, Livermore has always been a controversial figure and his methods held up as a model for traders of all generations. Through 45 years...
Laravel: Up & Running: A Framework for Building Modern PHP Apps
What sets Laravel apart from other PHP web frameworks? Speed and simplicity, for starters. This rapid application development framework and its ecosystem of tools let you quickly build new sites and applications with clean, readable code. Fully updated to cover Laravel 5.8, the second edition of this practical guide...
QuickBooks 2006: The Missing Manual f your company is ready to minimize paperwork and maximize productivity, control spending and boost sales, QuickBooks 2006 can help you make it happen--but only if you know how to use it. And it doesn't come with a manual. Lucky for you, there's QuickBooks 2006: The Missing Manual, the comprehensive, up-to-date... Code Centric: T-SQL Programming with Stored Procedures and Triggers
If you want to learn how to write stored procedures and triggers for Microsoft SQL Server, Code Centric: T-SQL Programming with Stored Procedures and Triggers is the book for you. Youll learn real-world coding and how to build non-trivial applications. All of the examples covered in the book are available for download, making it easier...
Materials that Change Color: Smart Materials, Intelligent Design
This book presents a design-driven investigation into smart materials developed by chemists, physicists, materials and chemical engineers, and applied by designers to consumer products. Introducing a class of smart materials, that change colors, the book presents their characteristics, advantages, potentialities and difficulties of...