Oracle Essentials [Electronic resources] : Oracle Database 10g, 3rd Edition نسخه متنی

DAD (Data Access Descriptor)

data abstraction

Data Access Descriptor (DAD)

data cleansing

data cubes

data dictionary

AUD$ table

MTS data, views for

views

for evaluating performance

data divergence

tolerance

data extraction tools

Data Guard
2nd

data integrity problems

Data Manipulation Language (DML)

data mining
2nd

algorithms

functions

data modeling, OLTP vs. decision support

Data Pump

data redundancy via export of data

to flat files

data storage, table compression

data structures

clusters

hash clusters

partitioning

schemas and

sequences

server entities

statistics

synonyms

data transfer between databases

data warehouses

ad-hoc query tools

additional software resources

backups

causes of failure

characteristics

dangerous assumptions

data marts

data mining

design

design schemas

ETL tools

evolution

interMedia datatype storage

management

materialized views

multiple datatypes, storage of

ODS (operational data store)

OLTP systems, contrasted with
2nd
3rd

Oracle locking model, and

Partitioning option, uses

query optimization

read-only tablespaces, and

reporting tools

required capabilities

requirements for success

Spatial option data retrieval

summary tables

Warehouse Builder

warehouse servers

Data Workshop

database administration

extents

fragmentation

media failure, recovery from

security

segments

user accounts, management

database block size

Database Change Management (EM)

Database Configuration Management option (EM)

Database Diagnostics option (EM)

Database Resource Manager
[See DRM]

Database Tuning option (EM)

Database Upgrade Assistant

databases
[See also Oracle databases]2nd

administration
[See database administration]

application development

archives, isolation from

audit trails

availability

backups, isolation from

blocks, size of

buffer caches

performance, and

tuning

client processes, accessing with

client/server processes

components

constraints

control files, backup

creating

Oracle Database Configuration Assistant, with

scripts, using

data integrity, ensuring

data transfer between

design
2nd

directory structure, planning

disk space requirements, estimating

distributed

failures, types of

growth, planning for

hardware architecture

installation

mounting

normalization

object-relational

opening

Oracle

Oracle Data Guard
2nd

parallelization

physical files
2nd

control files

datafiles

redo log files

programming tools

RAID level, choosing

recovery from failure

relational

organization

shutting down

standby databases

starting

starting up

upgrades

datafiles
2nd

composition

extents

granularity

headers

checkpoint records

checkpoints

segment

structure

datatypes

AnyType, AnyData, AnyDataSet types

BFILE

character datatypes

character sets, non-native

comparisons

comparisons of

DATE

INTERVAL datatypes

large objects (LOBs)

NULL values

numeric datatypes

precision

scale

Oracle9i, user-defined

pseudocolumns

RAW and LONGRAW

type conversions

user-defined

user-defined, Oracle8

XMLType

DATE datatype

DB_BLOCK_BUFFERS

DB_BLOCK_BUFFERS parameter

DB_CACHE_SIZE parameter

DBA_ views

DBAs (database administrators)

roles and privileges

DBMS (database management systems)

evolution

hierarchical model

network model

relational model

DBMS_RLS package

DBMS_STAT_FUNCS package

DBMS_STATS package

DBWR (Database Writer) process

DCM (Distributed Configuration Management)

decision support queries, optimization

decision support systems (DSS)

dedicated processes

dedicated server process model

dedicated storage subsystems

power outages, vulnerability to

DEFAULT buffer pool

deferred constraints

deferred rollback

depth of indexes

dequeuing

descriptive statistics functions

dimension tables
2nd

direct path export

direct path load

dirty reads

disaster recovery

database and data redundancy

planning

preparation

Discoverer

disk arrays

disk deployment strategies

disk failure, recovery from

disk farms

disk layout, planning

disk redundancy

disk striping
2nd

host-based

disk technology

dispatchers

distibution fitting functions

Distributed Configuration Management (DCM)

distributed databases
2nd

data integrity, ensuring

data transfer

database connectivity types, Oracle and non-Oracle databases

publish and subscribe capabilities

queuing

replication

security

Streams

synchronization

distributed queries

distributed transactions

DLM (Distributed Lock Manager)

DM4J

DML (Data Manipulation Language)

documentation

books

OFA

Oracle, installation of

web sites

domain indexes

downtime, unplanned

causes

DRM (Database Resource Manager)
2nd
3rd

DSS (decision support systems)