X hits on this document

Powerpoint document

C20.0046: Database Management Systems Lecture #1 - page 21 / 40

135 views

0 shares

0 downloads

0 comments

21 / 40

M.P. Johnson, DBMS, Stern/NYU, Sp2004

21

Data Models

Any DBMS uses a data model: collection of concepts for describing data

Schema: description of partic set of data, using some data model

Relational data model: most widely used (by far) data model

Oracle, DB2, SQLServer, other SQL DBMSs

main concept: relation ~ table of rows & columns

a rel’s schema defines its fields

Document info
Document views135
Page views135
Page last viewedThu Jan 19 12:01:05 UTC 2017
Pages40
Paragraphs688
Words2138

Comments