Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  R  S  T  U  V  W  

Symbols

  • .so files
    • naming conventions 1

A

  • aggregate function, user-defined
    • analytic functions 1 , 2
    • analytic functions and external context 1
    • creating 1
    • defining 1 , 2
    • example 1
    • external context 1
    • external context and parallel aggregation 1
    • implementing 1
    • large aggregation contexts 1
    • ODCIAggregateDelete 1 , 2
    • ODCIAggregateInitialize 1 , 2
    • ODCIAggregate interface 1 , 2
    • ODCIAggregateIterate 1 , 2
    • ODCIAggregateMerge 1 , 2
    • ODCIAggregateTerminate 1 , 2
    • ODCIAggregateWrapContext 1 , 2
    • parallel evaluation 1
    • reuse for analytic functions 1
    • using 1
    • using materialized views 1
  • aggregate interface 1
  • Alias library 1
  • ALL_INDEXTYPE_COMMENTS view 1
  • analytic functions 1 , 2
  • ancillary binding 1
  • ANYTYPE type 1
  • Associating the Extensible Optimizer Methods with Database Objects 1
  • attributes of object type
    • referencing in method 1
  • autonomous transaction restriction 1

B

  • B+trees 1
  • binary large object, see BLOB 1
  • binding 1 , 2
  • BLOB
    • EMPTY_BLOB function 1
  • B-tree indexing algorithm 1

C

  • callback
    • restrictions 1
  • Callback Restrictions 1
  • C and C++
    • debugging DLLs 1
    • differences from PL/SQL 1
  • character large object, see CLOB 1
  • character sets
    • support for 1
  • CLOB
    • EMPTY_CLOB function 1
  • collection types 1
  • complex data objects 1
  • configuration files
    • naming conventions 1
  • configuration files for external procedures 1
  • constructor method 1
  • content 1
  • content of data cartridge 1
  • context
    • inline 1
    • WITH CONTEXT clause 1
  • conventions
    • naming 1
  • corruption of package 1
  • cost model 1
  • CREATE FUNCTION statement 1 , 2
  • CREATE LIBRARY
    • CREDENTIAL option 1
    • DIRECTORY object option 1
  • CREATE TYPE
    • syntax 1
  • CREATE TYPE BODY statement 1
  • CREATE TYPE with OID statement 1
  • Creating Statistics Table (PowerCartUserStats) 1

D

  • data cartridge
    • complex data objects 1
    • content 1
    • definition 1 , 2
    • development process 1
    • domains 1
    • external procedures (guidelines) 1
    • installation 1
    • interfaces 1
    • key characteristics 1
    • method 1
    • naming conventions 1
    • Oracle Multimedia 1
    • Oracle Spatial 1
    • Oracle Text 1
    • scope 1
    • suggested development approach 1
  • data objects 1
  • data types
    • collection 1
    • extensibility 1
    • REF (relationship) 1
    • reference 1
    • specifying 1
    • user-defined type 1
  • DBA_INDEXTYPE_COMMENTS view 1
  • DBA_SECONDARY_OBJECTS view 1
  • DBMS_LOB package
    • compared with OCI 1
  • DBMS_STATS package
    • used in optimizer 1
  • DBMS interfaces 1
  • DDL
    • for LOBs 1 , 2
  • DEBUG_EXTPROC, Using 1
  • debugging
    • C code in DLLs 1
    • common errors 1
    • PL/SQL 1
  • Debugging External Procedures 1
  • demo directory (PL/SQL) 1
  • demo file (extdemo1.sql)
    • extensible indexing in power demand example 1
  • directories
    • installation 1
  • DIRECTORY Object Option 1
  • DLL
    • debugging 1
    • naming conventions 1
  • domain index 1 , 2
  • domain indexes
    • creating
      • parallelizing, with table functions 1
    • definition 1
    • exporting and importing 1
    • loading 1
    • moving 1
  • domain of data cartridge 1

E

  • electric utility example 1
  • EMPTY_BLOB function 1
  • EMPTY_CLOB function 1
  • error messages
    • naming conventions 1
  • exception
    • raising (OCIExtProcRaiseExcp) 1
    • raising (OCIExtProcRaiseExcpWithMsg) 1
  • execution plan
    • defintition 1
  • extdemo1.sql demo file (extensible indexing in power demand example) 1
  • extensibility
    • data types 1
    • indexing 1
    • interfaces 1
    • optimizer 1
    • server execution environment 1 , 2
    • services
      • collections 1
      • data types 1 , 2
      • method 1
      • reference type 1
  • extensibility interfaces 1
  • extensibility services 1
  • extensible database 1
  • extensible indexing
    • necessary application processes 1
    • necessary database processes 1
    • queries benefitting 1 , 2
  • extensible indexing framework 1
  • extensible optimizer 1
  • external context 1
  • external context and parallel aggregation 1
  • external LOB 1
  • external procedure
    • configuration files for 1
    • guidelines 1
    • guidelines for using with data cartridge 1
    • how PL/SQL calls 1
    • LOBs in 1
    • OCI access functions 1
    • overview 1
    • PARAMETERS clause 1
    • passing parameters to 1
    • registering 1
    • specifying data types 1
    • WITH CONTEXT clause 1
  • External Procedures, Debugging 1
  • extproc process 1

F

  • foundational data cartridges
    • Oracle Multimedia 1
    • Oracle Spatial 1
    • Oracle Text 1

G

  • generic types
    • See: ANYTYPE type
  • Globalization Support 1
  • globals
    • naming conventions 1

H

  • hash index 1

I

  • implementation type 1
  • index
    • domain
      • creating 1
    • metadata for 1
  • indexing
    • extensible
      • queries benefitting 1
      • queries not benefitting 1
  • index-organized table 1
  • index scan 1
  • indextype
    • definition 1 , 2
  • indextype implementation methods 1
  • indextypes
    • operators and 1
  • initialization, ODCIAggregate 1
  • inline, context 1
  • installation directory
    • naming conventions 1
  • installation of data cartridge 1
  • interfaces
    • data cartridge 1
    • DBMS 1
    • extensibility 1
    • service 1
  • internal LOB 1
  • iteration, ODCIAggregate 1

J

  • join order 1

K

  • Knuth 1

L

  • large aggregation contexts 1
  • large object, see LOB 1
  • library
    • alias 1
    • shared 1 , 2
  • LOB
    • DDL for 1 , 2
    • external 1
    • external procedure use 1
    • internal 1
    • OCI use with 1
    • triggers and 1
    • value 1
  • LOBs
    • overview 1
  • local domain indexes 1 , 2

M

  • Maintaining Context - Java 1
  • map methods 1
  • materialized views
    • user-defined aggregate function 1
  • member method 1 , 2
  • merge, ODCIAggregate 1
  • message files
    • naming conventions 1
  • metadata
    • index 1
  • method
    • constructor 1
    • implementing 1
    • invoking 1
    • map 1
    • member 1 , 2
    • order 1
    • referencing attributes 1

N

  • naming conventions
    • configuration files 1
    • error messages 1
    • globals 1
    • installation directory 1
    • message files 1
    • name format 1
    • need for 1
    • schema 1
    • shared libraries 1
  • national language support (NLS). See Globalization Support 1
  • NCLOB 1
  • NLS (national language support). See Globalization Support 1

O

  • object identifier (OID)
    • with CREATE TYPE 1
  • object type
    • attributes 1
    • comparisons 1
    • methods 1
  • OCI
    • LOB manipulation functions 1
  • OCIExtProcAllocMemory routine 1
  • OCIExtProcRaiseExcp routine 1
  • OCIExtProcRaiseExcpWithMsg routine 1
  • OCILob...() functions 1
  • ODCIAggregateDelete 1 , 2
  • ODCIAggregateInitialize 1 , 2
  • ODCIAggregate interface
    • ODCIAggregateDelete 1
    • ODCIAggregateInitialize 1
    • ODCIAggregateIterate 1
    • ODCIAggregateMerge 1
    • ODCIAggregateTerminate 1
    • ODCIAggregateWrapContext 1
    • overview 1
  • ODCIAggregateIterate 1 , 2
  • ODCIAggregateMerge 1 , 2
  • ODCIAggregateTerminate 1 , 2
  • ODCIAggregateWrapContext 1 , 2
  • ODCIGetInterfaces method 1
  • ODCIIndexClose method 1
  • ODCIIndexCreate method 1
  • ODCIIndexDelete method 1
  • ODCIIndexDrop method 1
  • ODCIIndexFetch method 1
  • ODCIIndexGetMetadata method 1
  • ODCIIndexInsert method 1
  • ODCIIndexStart method 1 , 2
  • ODCIIndexUpdate method 1
  • OID
    • with CREATE TYPE 1
  • operator 1
  • Oracle Extensibility Architecture 1
  • Oracle Mutimedia 1
  • Oracle Spatial cartridge 1
  • Oracle Text 1
  • order methods 1
  • overview 1 , 2

P

  • package body 1
  • packages
    • corruption 1
    • in PL/SQL 1
    • privileges required to create procedures in 1
  • package specification 1
  • parallel aggregation and external context 1
  • Parallel evaluation of user-defined aggregates 1
  • PARAMETERS clause with external procedure 1
  • partitioning method
    • HASH 1
    • RANGE 1
  • PL/SQL
    • DBMS_LOB package compared with OCI 1
    • debugging 1
    • demo directory 1
    • differences from C and C++ 1
    • packages 1
  • power demand cartridge example
    • demo file (extdemo1.sql) 1
  • pragma RESTRICT_REFERENCES 1
  • primary binding 1
  • privileges
    • required to create procedures 1
  • purity level 1

R

  • reference type 1
  • REF operator 1
  • registering an external procedure 1
  • RESTRICT_REFERENCES pragma 1
  • Restrictions on Callbacks 1
  • routine
    • service 1
  • RPC time out 1
  • R-trees 1

S

  • schema
    • naming conventions 1
  • scope 1
  • scope of data cartridge 1
  • selectivity 1
  • SELF parameter 1 , 2
  • service routine
    • examples 1
  • shared library
    • naming conventions 1
  • side effect 1
  • signature 1
  • signature mismatch 1
  • statistics type
    • definition 1
  • suggested development approach for data cartridge 1

T

  • table functions
    • parallel execution of 1 , 2
    • partitioning input 1
    • pipelined 1 , 2 , 3
    • querying 1
  • tables
    • index-organized 1
  • termination, ODCIAggregate 1
  • transient types
    • See: ANYTYPE type
  • triggers
    • with LOBs 1

U

  • USER_INDEXTYPE_COMMENTS view 1
  • user-defined operator 1
  • user-defined type 1

V

  • view
    • ALL_INDEXTYPE_COMMENTS 1
    • DBA_INDEXTYPE_COMMENTS 1
    • DBA_SECONDARY_OBJECTS 1
    • USER_INDEXTYPE_COMMENTS 1

W

  • WITH CONTEXT clause and external procedure 1