Everything2
Near Matches
Ignore Exact
Full Text
Everything2

relational database model

created by rp

(thing) by rp (1.4 d) (print)   ?   (I like it!) Sun Nov 14 1999 at 9:05:12

A formal model of databases proposed by E.F. Codd in 1970.

A database is a set of tables (mathematically speaking, relations). Queries on the tables can now be posed using standard mathematical logic. Tables can also be manipulated in whole, with the relational algebra.

There is no explicit notion of object in this model. But the rows (tuples) or cells (values) in the tables often represent real world objects.

This is known as the object identity problem.


(idea) by psydereal (2.3 y) (print)   ?   (I like it!) Tue Mar 12 2002 at 16:32:01

In the relational database model, data can be visualized as being stored in a number of tables, where each table represents a relation. Columns in the table are attributes of each relation, while the rows in the table consist of tuples that describe each instance of the relation.

The relation schema is defined as R(A1, A2...An) where R is the name of the relation and each attribute Ai is the role a domain (for example, the set of all 9-digit integers as a domain for social security number) plays in the relation. The degree of R is the number of attributes in its schema.

An instance, or relation state of a relation, r(R) consists of a set of n-tuples r{t1, t2, .... , tn}.

Tables in the relational database model are manipulated through relational algebra.


printable version
chaos

relational algebra object identity The best interview advice I received Bad Programmers
RDBMS Fundamentals of Database Systems E.F. Codd relation
tuple database Am I gay? MySQL
Database Nation 1970 denormalization relational structure
Join Everything 1 vlookup Prosopography
query optimization primary key Writing HTML is not coding C.J. Date
Y'know, if you log in, you can write something here, or contact authors directly on the site. Create a New User if you don't already have an account.
  Epicenter
Login
Password

password reminder
register

Everything2 Help

Cool Staff Picks
Just another sprinkling of indeterminacy
Why do Christians bring their kids up as Christians?
How to DJ
a snapshot of time
Requirements for good wine fermentation
Giving Your Cat a Pill (and your little dog, too!)
1977 Fonseca Vintage Port
Jesus Christ Trigonal Planar
penis captivus
Trieste
Admission essay
An Intelligent Woman
Baking bread
Mardi Gras celebrations in the US other than New Orleans: an observation
New Writeups
SubSane
Making Love to a 9-Foot Woman(person)
Ouzo
Thoughts(idea)
antigravpussy
I fall silent, listening. The breadcrumbs are talking about us(person)
calgon
Buffalo Bill by the pool(poetry)
gate
Anarchy is Order(idea)
ushdfgakjasgh
Scribeling(thing)
XWiz
Trism(review)
artman2003
Briefcase Full of Souls - Part I(fiction)
Dreamvirus
Alan Ladd(person)
waverider37
Harold Holt(person)
The Debutante
Until death do us part(fiction)
Ysardo
a brother to a sister(personal)
antigravpussy
your warm whispers(personal)
Clarke
Multiculturalism(idea)
aneurin
Earl of Landaff(person)
This affordable entertainment brought to you by The Everything Development Company