Autore	Fiorillo Ciro
Edizione	[1st edition]
Pubbl/distr/stampa	Birmingham, U.K., : Packt Enterprise, 2012
Descrizione fisica	1 online resource (543 p.)
Disciplina	005.75/85 005.7575
Soggetto topico	Relational databases Database management
Soggetto genere / forma	Electronic books.
ISBN	1-283-45344-4 9786613453440 1-84968-261-5
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Starting with Performance Tuning; Introduction; Reviewing the performance tuning process; Exploring the example database; Acquiring data using a data dictionary and dynamic performance views; Analyzing data using Statspack reports; Diagnosing performance issues using the alert log; Analyzing data using Automatic Workload Repository (AWR); Analyzing data using Automatic Database Diagnostic Monitor (ADDM); A working example Chapter 2: Optimizing Application DesignIntroduction; Optimizing connection management; Improving performance sharing reusable code; Reducing the number of requests to the database using stored procedures; Reducing the number of requests to the database using sequences; Reducing the number of requests to the database using materialized views; Optimizing performance with schema denormalization; Avoiding dynamic SQL; Chapter 3: Optimizing Storage Structures; Introduction; Avoiding row chaining; Avoiding row migration; Using LOBs; Using index clusters; Using hash clusters Indexing the correct wayRebuilding index; Compressing indexes; Using reverse key indexes; Using bitmap indexes; Migrating to index organized tables; Using partitioning; Chapter 4: Optimizing SQL Code; Introduction; Using bind variables; Avoiding full table scans; Exploring index lookup; Exploring index skip-scan and index range-scan; Introducing arrays and bulk operations; Optimizing joins; Using subqueries; Tracing SQL activity with SQL Trace and TKPROF; Chapter 5: Optimizing Sort Operations; Introduction; Sorting-in-memory and on-disk; Sorting and indexing; Writing top n queries and ranking Using count, min/max, and group-byAvoiding sorting in set operations: union, minus, and intersect; Troubleshooting temporary tablespaces; Chapter 6: Optimizing PL/SQL Code; Introduction; Using bind variables and parsing; Array processing and bulk-collect; Passing values with NOCOPY (or not); Using short-circuit IF statements; Avoiding recursion; Using native compilation; Taking advantage of function result cache; Inlining PL/SQL code; Using triggers and virtual columns; Chapter 7: Improving the Oracle Optimizer; Introduction; Exploring optimizer hints; Collecting statistics; Using histograms Managing stored outlinesIntroducing Adaptive Cursor Sharing for bind variable peeking; Creating SQL Tuning Sets; Using the SQL Tuning Advisor; Configuring and using SQL Baselines; Chapter 8: Other Optimizations; Introduction; Caching results with the client-side result cache; Enabling parallel SQL; Direct path inserting; Using create table as select; Inspecting indexes and triggers overhead; Loading data with SQL*Loader and Data Pump; Chapter 9: Tuning Memory; Introduction; Tuning memory to avoid Operating System paging; Tuning the Library Cache; Tuning the Shared Pool Tuning the Program Global Area and the User Global Area
Record Nr.	UNINA-9910461486803321

Autore	Ruiz Jose R
Pubbl/distr/stampa	Birmingham, U.K., : Packt Enterprise, 2012
Descrizione fisica	1 online resource (400 p.)
Disciplina	005.75 005.75/85 005.7585
Soggetto topico	Database management
Soggetto genere / forma	Electronic books.
ISBN	1-283-45346-0 9786613453464 1-84968-327-1
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Cover; Copyright; Credits; About the Author; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1:Understanding and Modifying Data Sources; Introduction; Setting up an Account or Measure dimension with a parent-child reference; Setting up dimensions with a generation reference; Adding columns for outline formulas; Adding the solve order column to tables that have ASO formulas; Adding and populating the Sort Order Column; Adding tables for varying attributes; Determining hierarchies in relational tables; Using the Essbase Outline Extractor to extract dimensions Using Star Analytics to build your star schema from existing Essbase cubesChapter 2:Using Essbase Studio; Introduction; Creating TBC sample database and connecting to the data source; Adding user-defined tables; Building your minischema; Setting up joins in a minischema; Adding tables to a minischema; Using a text file data source; Working with Common Platform Language (CPL); Using Sort Order on data elements; Chapter 3: Building theBSO Cube; Introduction; Creating hierarchies using a parent-child reference table; Creating hierarchies using a generation reference table Adding attribute dimensions to hierarchiesBuilding a Calendar dimension; Creating date elements; Creating Alias tables; Developing cube schema and an Essbase model; Setting Essbase properties; Deploying a cube; Creating an OLAP Model in EIS; Creating an OLAP metaoutline in EIS; Chapter 4:Building the ASO Cube; Introduction; Using the Connection Wizard to set up an ASO cube; Building a Measures dimension from the fact table; Creating an ASO Cube Schema and an Essbase Model; Understanding Essbase Model properties for the ASO cube; Designing a drill-through report Using the View dimension for Dynamic Time Series reportingChapter 5:Using EAS for Development; Introduction; Adding an application and database on an Essbase Server; Using the outline editor to add dimensions; Using dimension build rules to add the parent-child dimension; Creating dimension build rules to add a base and attribute dimensions; Using dimension build rules to add user-defined attributes and associate dimensions; Creating load rules for flat file data loads; Creating substitution variables; Using If/Else logic and substitution variables in outline formulas Using Text measures on a BSO cubeUsing Date measures on a BSO cube; Using different outline formula logic at parent level; Creating a load rule for SQL data load using substitution variables; Using MDX in aggregate storage applications; Chapter 6:Creating Calculation Scripts; Introduction; Using Essbase Set function commands and Calc All to calculate cubes; Using control flow commands, conditional, and logical operators; Using substitution variables in calculations script; Using UDAs and Calc Two Pass in calculation scripts; Using Attributes in calculation scripts Clearing data and using the cross- dimensional operators in a calculation script
Record Nr.	UNINA-9910457519603321

Autore	Powell Gavin
Edizione	[2nd ed.]
Pubbl/distr/stampa	Burlington, MA, : Digital Press, c2007
Descrizione fisica	1 online resource (955 p.)
Disciplina	005.75/85
Altri autori (Persone)	PowellGavin
Soggetto topico	Relational databases
Soggetto genere / forma	Electronic books.
ISBN	1-281-00716-1 9786611007164 0-08-049202-9
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Front Cover; Oracle ® Performance Tuning for 10gR2; Copyright Page; Contents; Preface; Introduction; Part I: Data Model Tuning; Chapter 1. The Relational Database Model; 1.1 The Formal Definition of Normalization; 1.2 A Layperson's Approach to Normalization; 1.3 Referential Integrity; Chapter 2. Tuning the Relational Database Model; 2.1 Normalization and Tuning; 2.2 Referential Integrity and Tuning; 2.3 Optimizing with Alternate Indexes; 2.4 Undoing Normalization; Chapter 3. Different Forms of the Relational Database Model; 3.1 The Purist's Relational Database Model 3.2 Object Applications and the Relational Database ModelChapter 4. A Brief History of Data Modeling; 4.1 The History of Data Modeling; 4.2 The History of Relational Databases; 4.3 The History of the Oracle Database; 4.4 The Roots of SQL; Part II: SQL Code Tuning; Chapter 5. What Is SQL?; 5.1 DML and DDL; 5.2 Transaction Control; 5.3 Parallel Queries; Chapter 6. The Basics of Efficient SQL; 6.1 The SELECT Statement; 6.2 Using Functions; 6.3 Pseudocolumns; 6.4 Comparison Conditions; Chapter 7. Advanced Concepts of Efficient SQL; 7.1 Joins; 7.2 Using Subqueries for Efficiency 7.3 Using Synonyms7.4 Using Views; 7.5 Temporary Tables; 7.6 Resorting to PL/SQL; 7.7 Object and Relational Conflicts; 7.8 Replacing DELETE with TRUNCATE; Chapter 8. Common-Sense Indexing; 8.1 What and How to Index; 8.2 Types of Indexes; 8.3 Types of Indexes in Oracle Database; 8.4 Tuning BTree Indexes; 8.5 Summarizing Indexes; Chapter 9. Oracle SQL Optimization and Statistics; 9.1 What Is the Parser?; 9.2 What Is the Purpose of the Optimizer?; 9.3 Rule-Based versus Cost-Based Optimization; Chapter 10. How Oracle SQL Optimization Works; 10.1 Data Access Methods; 10.2 Sorting 10.3 Special CasesChapter 11. Overriding Optimizer Behavior Using Hints; 11.1 How to Use Hints; 11.2 Hints: Suggestion or Force?; 11.3 Classifying Hints; 11.4 Influencing the Optimizer in General; 11.5 10g Naming Query Blocks for Hints; Chapter 12. How to Find Problem Queries; 12.1 Tools to Detect Problems; 12.2 EXPLAIN PLAN; 12.3 SQL Trace and TKPROF; 12.4 TRCSESS; 12.5 Autotrace; 12.6 Oracle Database Performance Views for Tuning SQL; Chapter 13. Automated SQL Tuning; 13.1 Automatic Gathering of Statistics; 13.2 The AWR and the ADDM; 13.3 Automating SQL Tuning Part III: Physical and Configuration TuningChapter 14. Tuning Oracle Database File Structures; 14.1 Oracle Database Architecture and the Physical Layer; 14.2 Tuning and the Logical Layer; 14.3 Automating Database File Structures; Chapter 15. Object Tuning; 15.1 Tables; 15.2 Indexes; 15.3 Index-Organized Tables and Clusters; 15.4 Sequences; 15.5 Synonyms and Views; 15.6 The Recycle Bin; Chapter 16. Low-Level Physical Tuning; 16.1 What Is the High-Water Mark?; 16.2 Space Used in a Database; 16.3 What Are Row Chaining and Row Migration?; 16.4 Different Types of Objects 16.5 How Much Block and Extent Tuning?
Record Nr.	UNINA-9910451455903321

Autore	Vieira Robert
Edizione	[1st edition]
Pubbl/distr/stampa	Indianapolis, IN, : Wiley Pub., 2009
Descrizione fisica	1 online resource (938 p.)
Disciplina	005.75/85
Collana	Wrox professional guides Professional Microsoft SQL server 2008 programming
Soggetto topico	Client/server computing Database management
Soggetto genere / forma	Electronic books.
ISBN	0-470-63209-7 1-282-12225-8 9786612122255 0-470-50845-0
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Professional Microsoft® SQL Server® 2008 Programming; Contents; Introduction; Chapter 1: Being Objective: Re-Examining Objects in SQL Server; Chapter 2: Tool Time; Chapter 3: Asking a Better Question: Advanced Queries; Chapter 4: XML Integration; Chapter 5: Daring to Design; Chapter 6: Core Storage and Index Structure; Chapter 7: More Advanced Index Structures; Chapter 8: Views; Chapter 9: Scripts and Batches; Chapter 10: Advanced Programmability; Chapter 11: Transactions and Locks; Chapter 12: Triggers; Chapter 13: SQL Cursors; Chapter 14: Reporting Services Chapter 15: Buying in Bulk: The Bulk Copy Program (BCP) and Other Basic Bulk OperationsChapter 16: Getting Integrated; Chapter 17: Replication; Chapter 18: Looking at Things in Full: Full-Text Search; Chapter 19: Feeling Secure; Chapter 20: A Grand Performance: Designing a Database That Performs Well; Chapter 21: What Comes After: Forensic Performance Tuning; Chapter 22: Administration; Chapter 23: SMO: SQL Management Objects; Chapter 24: Data Warehousing; Chapter 25: Being Well Connected; Appendix A: System Functions; Appendix B: Going Meta: Getting Data About Your Data Appendix C: The BasicsIndex
Record Nr.	UNINA-9910454403303321