Download In This Chapter

A
B
C
D
E
F
G
H
SMALLFLOAT 3-10
smart large objects 7-10
TEXT 3-22
VARCHAR 3-19
Data warehouse, description 10-4
Database
demonstration
sales_demo 10-18, 11-4
superstores_demo 7-3
naming 4-4
populating new tables in 4-15
views on external database 6-30
Database administrator (DBA) 6-7
Database-level privileges
Connect privilege 6-6
database-administrator
privilege 6-7
description 6-6
Resource privilege 6-7
Data-warehousing model. See
Dimensional data model.
DATE data type
description 3-13
display format 3-14
DATETIME data type
description 3-14
display format 3-16
DB-Access
creating database with 4-14
UNLOAD statement 4-17
DBA. See Database administrator.
DBDATE environment
variable 3-14
dbload utility, loading data 4-17
DBMONEY environment
variable 3-13
dbslice, role in fragmentation 5-5
dbspace
role in fragmentation 5-3
selecting 4-5
DBTIME environment
variable 3-17
DECIMAL data type
fixed-point 3-12
floating-point 3-11
Default locale Intro-4
Default value, of a column 3-25
Delete privilege 6-9, 6-34
DELETE statement
I
J
K
L
M
N
O
P
Q
R
applied to view 6-31
privilege 6-6
privilege for 6-9
Dependencies, software Intro-4
Derived data, produced by
view 6-26
Descriptor column 2-26
Dimension table
choosing attributes 10-27
description 10-15
Dimensional data model
building 10-16
dimension elements 10-13
dimension tables 10-15
dimensions 10-13
fact table 10-12
implementing 11-3
measures, definition 10-12
minidimension tables 10-29
Dimensional database,
sales_demo 11-4
Distinct data type
casting 9-4, 9-15
description 7-8
DISTINCT keyword, restrictions in
modifiable view 6-31
Distribution scheme
changing the number of
fragments 5-18
definition 5-3
expression-based 5-6
using 5-7
with arbitrary rule 5-8
with range rule 5-8
hybrid 5-7
using 5-12
range 5-7
using 5-10
round-robin 5-6
using 5-9
system-defined hash 5-7
using 5-11
Documentation notes Intro-10
Documentation notes, program
item Intro-11
Documentation, types of Intro-9
documentation notes Intro-10
machine notes Intro-10
release notes Intro-10
S
T
U
V
W
X
Y
Z
@
Domain
characteristics 2-25
column 3-3
defined 2-25
DROP CAST statement, using 9-17
E
Element type 7-15
Entity
attributes 2-17
criteria for choosing 2-8
definition 2-5
occurrence 2-19
represented by a table 2-26
telephone directory example 2-9
Entity-relationship diagram
discussed 2-20
reading 2-21
Environment variables Intro-6
Environment, Non-U.S.
English 1-10
en_us.8859-1 locale Intro-4
Even distribution 5-9
Existence dependency 2-10
EXISTS keyword, use in condition
subquery 6-33
Expression-based distribution
scheme
arbitrary rule 5-8
description 5-6
using 5-7
with range rule 5-8
Expression, cast allowed in 9-3
Extended 3-22
External tables, loading data
with 4-17, 5-4
F
Fact table
description 10-12
determining granularity 10-19
granularity 10-12
Feature icons Intro-8
Features in 9.3 Intro-6
Field, in row types 7-21
finderr utility Intro-11
Index 3