In Chapter 3, we introduced the relational model and its peculiar terminology which is based on known mathematical concepts, particularly the theory of matrices. In Chapter 4, we adopted a Relational Database Language (RDL) in order to discuss high level database software — RDL has now been proposed by the International Standards Organisation (ISO) as the industry standard for the design of relational databases. The aim of this chapter is to present the relational architecture [Codd, 1970, 1972] independent of any available software (e.g SEQUEL [Chamberlin et al, 1976], INGRESS [Stonebraker et al, 1976], and RDL [ANSI, 1986]), standards, modules, commands, etc. The emphasis here is on set-theoretic manipulation of relational tables, and also how trees and networks can be represented adequately, within the framework of the relational architecture.
KeywordsDatabase System Relational Algebra International Standard Organisation Logical Schema Relational Table
Unable to display preview. Download preview PDF.
- ANSI, X3H2 Technical Committee on Databases, ‘Relational Database Language’, 1986.Google Scholar
- Bachman, C. W., ‘Data Structure Diagrams’, Database, Vol 1, No. 2, pp. 4–10, 1969.Google Scholar
- Codd, E. F., ‘Relational Completeness of Database Sublanguages’, In: Database systems, Rustin R. (editor), Prentice-Hall, pp. 33–64, 1972.Google Scholar
- Hall, P. A. V., ‘Relational Algebras, Logic, and Functional Programming’, Proc. ACM SIGMOD Conf. on Management of Data, June 1984.Google Scholar
- Hall, P. A. V., Hitchcock, P. & Todd, S. J. P. P., ‘An Algebra of Relations for Machine Computation’, Conference Record, 2nd ACM Symposium on Principles of Programming Languages, 1975.Google Scholar
- Hitchcock, P., ‘Fundamental Operations on Relations’, IMB UKSC-0051, May 1974.Google Scholar