Abstract
A relation is a mathematical term for a two-dimensional table such as a collection of records (for example, see figure 2.14). It is characterised by rows and columns, each entry there being an attribute value. The reason for calling this a relation rather than a matrix lies in the lack of homogeneity in its entries — the entries are homogeneous in the columns but not in the rows. A relational database consists of such relations which can be stored on a physical device in a variety of ways.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
References
Codd, E. F. (1970). A relational model of data for large shared data banks. Communications of the ACM, Vol. (13:6), June
Codd, E. F. (1971a). Further normalisation of the database relational model. IBM Research Report RJ909, August
Codd, E. F. (1971b). A database sublanguage founded on the relational calculus. IBM Research Report RJ893, July
Codd, E. F. (1974). Recent investigations in relational database systems. Proceedings of the 1974 IFIP Congress, North-Holland, p. 1017
Date, C. J. (1981). Introduction to Database Systems. Vol. 1, 3rd edition, Addison-Wesley
Date, C. J. (1983). The outer join. Proceedings of ICOD-2, edited by S. M. Deen and P. Hammersley, Wiley, p. 76
Deen, S. M. etal. (1981). Design of a canonical database system (PRECI). Computer Journal, Vol. (24:3), August
Deen, S. M. et al. (1985). Data integration in distributed databases. Department of Computing Science, University of Aberdeen, Aberdeen (to be published)
Mercz, I. (1979). Issues in building a relational interface on a Codasyl DBMS. Data Base Architecture, edited by G. Bracchi and G. M. Nijssen, North-Holland, p. 191
Robinson, K. (1978). The Computer Weekly
Sharman, G. C. H. (1975). Technical Report TR12.136, IBM Laboratory, Hursley, Winchester
Stonebraker, M. R. et al. (1976). Design and Implementation INGRES. ACM TODS, Vol. (1:3), September
Zaniolo, C. (1979). Design of relational views over network schemas. Proceedings ACM SIGMOD Conference 1979
Author information
Authors and Affiliations
Copyright information
© 1985 S. M. Deen
About this chapter
Cite this chapter
Deen, S.M. (1985). Basic Relational Model. In: Principles and Practice of Database Systems. Macmillan Computer Science Series. Palgrave, London. https://doi.org/10.1007/978-1-349-17958-9_6
Download citation
DOI: https://doi.org/10.1007/978-1-349-17958-9_6
Publisher Name: Palgrave, London
Print ISBN: 978-0-333-37100-8
Online ISBN: 978-1-349-17958-9
eBook Packages: Computer ScienceComputer Science (R0)