Résumé
Practical Oracle 8l offers a real-life approach to constructing Oracle databases-one that is geared toward solving important business problems. This book will help you devise appropriate strategies for database design that take into account Oracles technical underpinnings, hardware and user limitations, and tradeoffs between simplicity and efficiency It discusses selecting the Oracle Matures needed to perform specific functions and demonstrates how to structure code most effectively for the features being implemented.
Practical Oracle 8i presents an overview of Oracle that clearly explains the central functions that are key to Oracles operation. In addition, the book presents the fundamentals of the system, covering the way in which data is stored, packed, and made visible, as well as the dynamic features involved in transactions and calculations. Specific topics covered include:
- A discussion of why Oracle projects fail a Leveraging table spaces a Partitioning - LOBs
o Autonomous transactions
o Row-level security for virtual private databases
o Parallel query and parallel server
o The new analytical functions introduced in Oracle 8.1.6
This book also provides a summary of the most useful new features of Oracle 8. 1.,5, practical tips for tuning performance and testing features, and information on the major space-management features of an Oracle database.
Written by one of the worlds most knowled-geable and experienced Oracle database designers and programmers, Practical Oracle 8i reveals the strategies, techniques, and insights that will enable you to understand the technology's full potential and put Oracle to work for successful database systems.
Contents
- Préface
- Acknowmedgment
- A Cautionary Tale
- Part I Overview
- Chapter 1 What is Oracle ?
- Chapter 2 Why Do projects Fail ?
- Chapter 3 How the Engine Works
- Chapter 4 Classifying Your Target
- Part II Data Storage
- Chapter 5 Making the Most of Tables
- Chapter 6 Basic Indexing
- Chapter 7 Enhanced Indexing
- Chapter 8 Leveraging Tablespaces
- Chapter 9 Temporary Space
- Chapter 10 Files, Raw, and Raid
- Chapter 11 Views
- Chapter 12 Introducing Partitioning
- Chapter 13 Using Partitioning
- Chapter 14 Index-Organized Tables
- Chapter 15 Simple Objects
- Chapter 16 Collection Objects
- Chapter 17 Handling Large Objects
- Chapter 18 Data Integrity
- Part III Data Manipulation
- Chapter 19 PL/SQL
- Chapter 20 Autonomous Transactions
- Chapter 21 Row-level Security
- Chapter 22 Parallel Query and Parallel Server
- Chapter 23 Number Crunching
- Chapter 24 Fallback
- Appendixes
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Addison Wesley |
Auteur(s) | Jonathan Lewis |
Nb. de pages | 637 |
Format | 18,8 x 23,4 |
Couverture | Broché |
Poids | 1000g |
Intérieur | Noir et Blanc |
EAN13 | 9780201715842 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse