R

Index

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

random numbers, using instead of system-generated values 2nd
range scans
     converting variable-length comparison to common case
     on clustered data
     reverse indexes and
     simple or range searching on dates
range-clustering (DB2)
range-partitioning
ranges
     aggregating by range (bands)
     importance of well-defined boundaries
ranking functions (SQL Server)
recovering databases
recursive with statement 2nd
     adjacency model, top-down tree walk
     propagating percentages across different tree levels
     substituting materialized path model for
redundant data
reference data in dimension tables
referencing tables, preventing insertions into
relational databases
     hierarchical databases vs.
     processing, confusing with object-oriented methods
     SQL and
relational model
     coherence of
     flexibility of, sacrificing by strongly structured data
     two-valued logic
     view of a tree
relational operations, reporting requirements vs.
relational theory
relations
     associating large numbers of possible characteristics in
     ordering information vs.
remote data
     querying
     transparent references to
remote data sources
remote validation checks
reorganizations of databases
reporting requirements
request type, partitioning by
requirements, evolution of
response times
result sets
     criteria defining
     difficulty of spotting incorrect data
     filtering conditions
         evaluation of
         large quantities of data
         meaning of
         proportions of retrieved data
     large
     obtained by aggregation
     predicated on absence of data
     size of 2nd
     small intersection of broad criteria
     small intersection, indirect broad criteria
     small result set, indirect criteria
     small, from direct, specific criteria
retrieval ratios
returning ... into ... clause
reverse indexes
     solving contention problems
right-padding function (rpad( ))
risk exposure in a financial structure
round-robin partitioning
row_number( ) OLAP function 2nd 3rd
rownums (Oracle) 2nd
rows
     associated with index key, physical closeness of
     columns that should have been rows
     emptying a table of all rows
     locking 2nd
     matching several list items, selecting
     ordering of, forcing
     physical location, finding with an index
     primary key, defining
     proportions of retrieved data
     that should have been columns
     updating and inserting, dedicated statements for
rpad( ) function (right-padding)