Oracle essentials

Oracle is an enormous system, with myriad technologies, options, and releases. Most users-even experienced developers and database administrators-find it difficult to get a handle on the full scope of the Oracle database. And, as each new Oracle version is released, users find themselves under incr...

Descripción completa

Detalles Bibliográficos
Autor principal: Greenwald, Rick (-)
Otros Autores: Stackowiak, Robert, Stern, Jonathan
Formato: Libro electrónico
Idioma:Inglés
Publicado: Sebastopol, California : O'Reilly 2008.
Edición:4th ed
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627462106719
Tabla de Contenidos:
  • Oracle Essentials, 4th Edition; Audience for This Book; About the Fourth Edition (Oracle Database 11g); Structure of This Book; Conventions Used in This Book; How to Contact Us; Using Code Examples; Safari® Books Online; Acknowledgments; 1. Introducing Oracle; How Oracle Grew; The Oracle Database Family; Summary of Oracle Database Features; Database Application Development Features; PL/SQL; Java; Oracle and web services; Large objects; Object-oriented programming; Third-generation languages (3GLs); Database drivers; The Oracle Call Interface; National Language Support; Database Extensibility
  • Oracle content managementOracle search capabilities; Oracle Spatial Option; XML DB; Database Connection Features; Oracle Internet Directory; Oracle Connection Manager; Oracle Application Server; Distributed Database Features; Heterogeneous Services; Data Movement Features; Advanced Queuing and Oracle Streams; Extraction, Transformation, and Loading; Database Performance Features; Data Warehousing and Business Intelligence; Star query optimization; Materialized views; Analytic functions; OLAP Option; Data Mining Option; Business intelligence tools; Database Management Features
  • Information Lifecycle Management and ILM AssistantBackup and Recovery; Incremental backup and recovery; Oracle Secure Backup; Database Availability; Data Guard; Fail Safe; Oracle Real Application Clusters; Data Guard and RAC; Automated Storage Management; Real Application Testing Option; Database Security Features; Label Security Option; Database Vault Option; Audit Vault Server; Oracle Development Tools; Oracle SQL Developer; Oracle Forms Developer; Oracle Reports Developer; Oracle Designer; Oracle Discoverer Administration Edition; Oracle Portal; Embedded Databases; Oracle Berkeley DB
  • Oracle Lite2. Oracle Architecture; Files of a database; Database Initialization; Deploying Physical Components; Datafiles; Extents and segments; Redo Log Files; How Oracle uses the redo logs; Naming conventions for redo logs; Archived redo logs; ARCHIVELOG mode and automatic archiving; Instance Memory and Processes; Shared pool; Redo log buffer; Other pools in the SGA; Automatic PGA management; Background Processes for an Instance; The Data Dictionary; 3. Installing and Running Oracle; Supporting Multiple Oracle Versions on a Machine; Upgrading an Oracle Database; Creating a Database
  • The Value of EstimatingTools for Creating Databases; Configuring Oracle Net; Oracle Net Manager; Auto-Discovery and Agents; Oracle Net Configuration Files; Starting Up the Database; Shutting Down the Database; Accessing a Database; Client process; Application Servers and Web Servers As Clients; Oracle Net and Establishing Network Connections; The Shared Server/Multi-Threaded Server; Data dictionary information about the shared server; Oracle at Work; Flashback; A Transaction, Step by Step; 4. Oracle Data Structures; Numeric Datatype; Date Datatype; Other Datatypes; Type Conversion
  • Concatenation and Comparisons