Skip to Content
The Relational Database Dictionary
book

The Relational Database Dictionary

by C.J. Date
August 2006
Intermediate to advanced
128 pages
3h 22m
English
O'Reilly Media, Inc.
Content preview from The Relational Database Dictionary

Chapter 1. The Dictionary

Table 1-1. 

0-adic

Niladic.

0-tuple

The empty tuple.

1NF

First normal form.

2NF

Second normal form.

2VL

Two-valued logic.

3NF

Third normal form.

3VL

Three-valued logic.

4NF

Fourth normal form.

5NF

Fifth normal form.

6NF

Sixth normal form.

A

A relationally complete, “reduced instruction set” version of relational algebra with only two operators—REMOVE (essentially projection over all attributes but one) and an algebraic analog of either NAND or NOR, q.v. The name is a doubly recursive acronym: it stands for ALGEBRA, which in turn stands for A Logical Genesis Explains Basic Relational Algebra. As this expanded name suggests, it is designed in such a way as to emphasize its close relationship to, and solid foundation in, the discipline of predicate logic, q.v.

ad hoc polymorphism

Overloading.

aggregate operator

A read-only operator that derives a single value (typically but not necessarily scalar) from the set or bag of values appearing as values of some attribute of some relation. Contrast summary. Note: If (a) the argument to some aggregate operator invocation is empty, and (b) that aggregate operator is essentially just shorthand for repeated invocation of some scalar operator (e.g., the scalar operator is “+” in the case of the aggregate operator SUM), and (c) an identity value exists for that scalar operator (the identity value is 0 in the case of “+”), then the result of that invocation is that identity value. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

The Relational Database Dictionary, Extended Edition

The Relational Database Dictionary, Extended Edition

C.J. Date

Publisher Resources

ISBN: 0596527985Errata Page