Nonapplicable nulls (Q1822518): Difference between revisions
From MaRDI portal
Set profile property. |
Set OpenAlex properties. |
||
| Property / full work available at URL | |||
| Property / full work available at URL: https://doi.org/10.1016/0304-3975(86)90022-8 / rank | |||
Normal rank | |||
| Property / OpenAlex ID | |||
| Property / OpenAlex ID: W4213061376 / rank | |||
Normal rank | |||
Revision as of 22:22, 19 March 2024
scientific article
| Language | Label | Description | Also known as |
|---|---|---|---|
| English | Nonapplicable nulls |
scientific article |
Statements
Nonapplicable nulls (English)
0 references
1986
0 references
A nonapplicable null appears in a relation whenever the value of the corresponding attribute does not exist. In order to evaluate a query on a relation r involving such null values, the information contained in r is represented by a set of null-free instances, then the query on r - expressed in a user-friendly query language (Generalized Relational Calculus) - is translated into a set of queries on the null-free instances. Conversely, we define the operations on relations with nulls (Generalized Relational Algebra) and we proved an extension of Codd's completeness theorem.
0 references
relational database
0 references
nonapplicable null
0 references
Generalized Relational Calculus
0 references
Generalized Relational Algebra
0 references
