A relational model of data for large shared data banks

Dados Bibliográficos

ID23347394
AutoresE F Codd (IBM Research Lab, San Jose, CA, autor correspondente)
Ano1970
Volume13
Fascículo6
Páginas377-387
Data de publicação1970-06-01
Peer ReviewedSim
Open AccessSim
TipoARTICLE
PeriódicoCommunications of the ACM (JOURNAL)
Identificadores do periódicoISSN: 0001-0782 • E-ISSN: 1557-7317
EditoraAssociation for Computing Machinery (ACM) (PUBLISHER)
DOI10.1145/362384.362685
OpenAlexW2185907055
IdiomaEN
Citações recebidas64
Referências citadas2

Future users of large data banks must be protected from having to know how the data is organized in the machine (the internal representation). A prompting service which supplies such information is not a satisfactory solution. Activities of users at terminals and most application programs should remain unaffected when the internal representation of data is changed and even when some aspects of the external representation are changed. Changes in data representation will often be needed as a result of changes in query, update, and report traffic and natural growth in the types of stored information. Existing noninferential, formatted data systems provide users with tree-structured files or slightly more general network models of the data. In Section 1, inadequacies of these models are discussed. A model based on n -ary relations, a normal form for data base relations, and the concept of a universal data sublanguage are introduced. In Section 2, certain operations on relations (other than logical inference) are discussed and applied to the problems of redundancy and consistency in the user's model.

Data mining · Data model (GIS) · Data modeling · Data redundancy · Database · External Data Representation · Inference · Information retrieval · Logical data model · Programming language · Relational database · Representation (politics) · Sublanguage · Advanced Database Systems and Queries · Artificial Intelligence · Computer Science · Distributed systems and fault tolerance · Semantic Web and Ontologies · Theoretical Computer Science