Relational model

Use the mouse wheel or two fingers (on touchscreens) to zoom in and out of the map.

Export map as:

Research this topic

Explore the main themes, entities and connections around Relational model. Start with the topic map, then use the sections below for research and deeper semantic analysis.

Explore this topic

Start with a few of the strongest sections from the source topic. These are research directions, not a list of keywords you must use.

Examples

Relvars Design Candidate key Foreign keys Primary key

23 related topics

Conceptualization

Set Arity Cardinality Variables Database

12 related topics

Logical interpretation

Formal system Logical Propositions Relational algebra Validly

11 related topics

History

Chris Date Hugh Darwen Object-oriented Three-valued logic NULL

5 related topics

Topics to explore

Browse the full topic structure. Each item opens a new analysis centered on that subject.

Overview

Data
Structure Structure (mathematical logic)
First-order predicate logic First-order logic
Edgar F. Codd
Tuples Tuple
Relations Relation (database)
Relational database
Declarative Declarative programming
Database management system software Database management system
SQL
Table Table (database)
Database schema
Deviate from the relational model in many details Relational model
Subset
Projection Projection (relational algebra)

History

Chris Date Christopher J. Date
Hugh Darwen
Object-oriented Object-oriented programming
Three-valued logic
NULL Null (SQL)

Conceptualization

Set Set (mathematics)
Arity
Cardinality
Variables Variable (computer science)
Database
Information Information theory
Boolean expressions
Constraints Constraint (database)
Query Query language
Join Join (SQL)
Cartesian product
First normal form

Logical interpretation

Examples

Relvars Relvar
Design
Candidate key
Foreign keys Foreign key
Primary key
Preference
Alternate keys Alternate key
Identifier
Bag Bag (mathematics)
DBMS
Transaction Database transaction
Integrity constraint Database integrity
Integrity constraints Integrity constraint
Value Value (computer science)
Attribute set Attribute set?action=edit&redlink=1
Operation Operation (mathematics)
Information
Restriction condition Restriction condition?action=edit&redlink=1
Query Information retrieval
Database design
Many-to-many Many-to-many (data model)
Role
One-to-many relationship One-to-many (data model)

Application to relational databases

Data type Data domain
Columns Column (database)
Rows Row (database)
Standard Standardization
ISO International Organization for Standardization

Set-theoretic formulation

Alternatives

Models Database model
Hierarchical model Hierarchical database model
Network model
Systems System
Data centers Data center
Object-oriented databases Object database
Datalog
Logic programming

Advanced semantic analysis

Deeper signals for content research, entity SEO and topical coverage. The plain-language headings explain what each technical view is useful for.

Map overview Semantic statistics

Nodes95

Edges94

Triples86

Avg. degree1.98

Density0.021053

Components1

How this topic connects Entity context

See the strongest relationship patterns around the current topic before diving into the raw triples.

Relational model

Top relations

related to Further reading · 13

Relational model → Addison-Wesley, An Introduction, Boston, Christopher, Darwen, Database Systems, Date, Foundation, Hugh, ISBN, MA, Pearson Education, Reading

related to External links · 12

Relational model → Binary, C2, Childs, Codd's, Darwen, Feasibility, Handle, Hugh, Sun, The Third Manifesto, TTM, World Wide Web

related to Extensions · 10

Relational model → Applicable, Codd, Database Management Version, False, Inapplicable, Missing, Missing/NULL, Some, The Relational Model, True

related to history · 9

Relational model → Chris Date, Codd, Darwen, Date, Edgar, Hugh Darwen, In, The, The Third Manifesto

related to Logical interpretation · 9

Relational model → Boolean, Constraints, Each, False, If, Relational, The, These, True

related to SQL and the relational model · 9

Relational model → According, Because, In, Information Principle, ISO SQL, Null, Relation's, SQL, The

related to Alternatives · 5

Relational model → Also, Datalog, Other, Some, Whereas

related to Set-theoretic formulation · 5

Relational model → Another, Basic, Our, Person, We

related to Application to relational databases · 3

Relational model → An, Attributes, The

is a · 2

Relational model → formal system, relational database.The purpose of the relational model is to provide a declarative method for specifying data and queries

Important terminology Word statistics

Use these terms to understand the vocabulary surrounding the topic, not as a checklist for keyword stuffing.

Important terminology

database relational relation model set key tuple data attributes tuples id constraints relations sql databases table order query attribute name

Entity relationships Subject–Predicate–Object triples

Subject	Predicate	Object	Confidence	Src
Relational model	is a	relational database.The purpose of the relational model is to provide a declarative method for specifying data and queries	0.90	text
Relational model	is a	formal system	0.90	text
outer join	instance of	outer operators	0.80	text
outer union	instance of	outer operators	0.80	text
and various forms of division	instance of	outer operators	0.80	text
group	instance of	then operators	0.80	text
ungroup.The flexibility of relational databases allows programmers to write queries that were not anticipated by the database designers	instance of	then operators	0.80	text
this that would render the database inconsistent by a violation of an integrity constraint	instance of	The DBMS must reject a transaction	0.80	text
numbers	instance of	Another basic notion is the set of atomic values that contains values	0.80	text
strings.Our first definition concerns the notion of tuple	instance of	Another basic notion is the set of atomic values that contains values	0.80	text
which formalizes the notion of row or record in a table	instance of	Another basic notion is the set of atomic values that contains values	0.80	text
Relational model	related to Alternatives	Other	0.60	section

Related concept clusters Concept neighborhoods

These clusters group vocabulary that occurs around closely connected concepts in the source material.

Connections between topic areas Semantic bridges

Bridges can reveal useful research angles that are easy to miss in a flat list of related terms.

Min side: 3

Research this topic

Explore this topic

Examples

Conceptualization

Logical interpretation

History

Key facts & relationships

Topics to explore

Overview

History

Conceptualization

Logical interpretation

Examples

Application to relational databases

Set-theoretic formulation

Alternatives

Advanced semantic analysis

Map overview Semantic statistics

Relational model

How this topic connects Entity context

Relational model

Top relations

Important terminology Word statistics

Important terminology

Entity relationships Subject–Predicate–Object triples

Related concept clusters Concept neighborhoods

Connections between topic areas Semantic bridges