Index
For alphabetization purposes, (a) differences in fonts and case are ignored; (b) quotation marks are ignored; (c) other punctuation symbols—hyphens, underscores, parentheses, etc.—are treated as blanks; (d) numerals precede letters; (e) blanks precede everything else.
Numbers and Symbols
def¯¯¯¯¯¯¯¯¯¯ (is defined as),
121
!! (image relation reference),
33
→ (functional dependency),
51
(join dependency),
208
(join dependency),
208
(cyclic ordering),
459
A
with cyclic point type,
457
AND (aggregate operator),
53
application time (SQL),
355,
407
application time period (SQL),
407
maximum one per table,
407
Assignment Principle, The,
50,
438
B
base relvar,
with cyclic point type,
457
with cyclic point type,
458
bitemporal
both since and during relvars,
217-219
C
cartesian product,
See TIMES
Closed World Assumption, The
closure (relational algebra),
25
COLLAPSE
continuity assumption,
468
implied by redundancy,
80,
231
implied by circumlocution,
81,
232
COUNT
creeping delete problem,
215
D
database constraint,
53-56
domain,
Dumas, Alexandre
fils,
473
during (predicates, propositions),
65-67
E
empty scalar type,
98,
101
encapsulated,
with cyclic point type,
458
entity/relationship diagram,
199
equality,
with cyclic point type,
456
equivalence
essential tuple normal form,
207,
219
even integers (point type),
386-387
EXPAND
F
system-versioned table (SQL),
427-428
foreign key constraint,
52
fully temporal
functional dependency,
51
G
generalization by constraint,
377
regular operators a special case,
191-192
GENERATED ALWAYS (SQL),
425
Georgiadis, Panagiotis,
542
H
hidden attributes,
63,
294
historical row (SQL),
427
historical tables only (SQL)
horizontal decomposition,
199,
218
I
identity projection,
74,
224
IMMEDIATELY PRECEDES (SQL),
410
IMMEDIATELY SUCCEEDS (SQL),
410
with cyclic point type,
456
Information Principle, The,
63
Ingersoll, Robert G.,
143
intended interpretation,
18-19
INTERSECT
open
open
possible representations,
89
INTERVAL type generator,
93
irreducibility
irreducible component (vertical decomposition),
207
J
satisfied by relation,
209
K
system-versioned table (SQL),
427
Kollias, Vassiliki J.,
532
L
M
Manolopoulos, Yannis,
533
maximal interval,
83,
108
with cyclic point type,
458
membership algorithm,
210,
213
with cyclic point type,
458
MINUS
Mitsopoulos, Yannis G.,
532
most specific type,
See type
“moving point now, ”,
See NOW
multirelvar constraint,
54
N
Navathe, Shamkant B.,
535,
536
neither PACKED ON nor
Nicola, Matthias,
xv,
537
nonnegative remainder,
452
“null” (not in relational model),
17,
215
O
on (predicates, propositions),
65-67
operator
read-only vs. update,
system vs. user defined,
11-13
ordering
attributes (proscribed),
16
overlapping tuples,
80,
231
with cyclic point type,
457
P
PACK
on relation valued attribute,
479-481
with cyclic point type,
463
Papadimitriou, Christos H.,
521
partitioning (with PACK),
133
period predicand (SQL),
408
period predicate (SQL),
408
“period literal” (SQL),
408
“period reference” (SQL),
408
“period selector” (SQL),
408
pointers (not in relational model),
polymorphism,
possible representation,
9-11
Poulovassilis, Alexandra,
533
prime numbers (point type),
390
Principle of Interchangeability, The,
57,
439
Principle of Value Substitutability, The,
397
Principle of Variable Substitutability, The,
397
pseudovariable
Q
Query A
fully temporal (intervals),
130
fully temporal (no intervals),
83,
129
Query B
fully temporal (intervals),
130
fully temporal (no intervals),
84,
129
R
referential constraint,
52
referential integrity,
52
relation predicate,
18,
19,
44
RELATION type generator,
23
relation valued attribute,
17-18
relational algebra,
25-44
relational comparison,
39-40
relational completeness,
41
relational model, passim
Routh, Martin Joseph,
517
S
Saracco, Cynthia,
xv,
537
self reference, 554
Shaw, George Bernard,
487
since (predicates, propositions),
65-67
explicit future information,
203,
259
explicit historical information,
202-203
implicit future information,
203,
258
implicit historical information,
203
single-relvar constraint,
54
singleton scalar type,
98,
101
vs. snapshot of the database,
61
Snodgrass, Richard T.,
517,
519,
520,
522,
529,
535,
536,
539,
540,
543
specialization by constraint,
377
Sripada, Suryanaryan,
527
successor function,
91,
467
Sylvester, James Joseph,
25
system time period (SQL),
42
maximum one per table,
424
system-versioned table (SQL),
424-430
T
target relvar
referential constraint,
52
“temporal database, ”,
63
“temporal relation, ”,
63
temporal statement modifiers,
172
temporal upward compatibility,
524-525
THE_pseudovariable,
13,
325
Third Manifesto, The,
527
timestamping attributes,
522
Tsotras, Vassilis J.,
542
attribute,
expression,
generated vs. nongenerated,
21-23
operator,
parameter,
scalar vs. nonscalar,
system vs. user defined,
7-8
value,
variable,
U
U_equality dependency,
267
satisfied by relation,
211
UNION
uniqueness (key),
See key
UNPACK
with cyclic point type,
463
update propositions not tuples,
314
updates are set level,
313
user defined type,
See type
“user defined time, ”,
539
user defined type,
See type
V
value substitutability,
375
VAR statement,
Viqueira, Jose R. Rios,
534,
542
W
WITH
WITH SYSTEM VERSIONING (SQL),
425-430
WITHOUT OVERLAPS (SQL),
407,
413
Wittgenstein, Ludwig J. J.,
15,
218
Y
Z