.
, , , , . : , $30 . . , , , . . , , .
- , , , , , , .
. 2.3 .
. , , , . , : , , , , . , . , , .
. 2.3.
, . , .
, . , . , .
- - , , .
, - .
- , , .
|
|
, , SGML (Standart Generalised Markup Language), ISO 80- . , (), . , DTD-, . , . SGML , , , . SGML ( HTML), SGML- .
, SGML, HTML , . HTML - , . , HTML, , HTTP. , , HTML , , HTML .
HTML , . , , , , XML. ?
XML (Extensible Markup Language) - , , XML-. . XML , , .
- , , . -, . .
- , . - . , . , , , , , , , . , , , .
|
|
52. -. . .
- (ER-) (. entity-relationship model, ERM) , .
ER- () . , .
ER- (, , .).
ER- , . , ER-, - (ER-) (. entity-relationship diagram, ERD).
ER- ER- , ER-
ER- MMORPG
, . , . , . .[3]
Crow's Foot
Crow's Foot
(. Gordon Everest) Inverted Arrow ( ), Crow's Foot ( ) Fork ().[4]
, , , .[5] . , , . .
, , . , . . [5] : , . .; : , .. . , , . , .
, (, ). , .[5]
- Bachman notation
- EXPRESS
- IDEF1x
- Martin notation
- (min, max)-Notation
- UML ER-, :
* | ||
ARIS | ||
Avolution (.) | (EULA) | |
dbForge Studio for MySQL (.) | Microsoft Windows | / ( ) |
Devgems Data Modeler (.) | Microsoft Windows: 2000, XP, Vista | |
DeZign for Databases (.) | Microsoft Windows: NT, 2000, XP, Vista, Windows 7 [software 1] | |
Dia | (GNU GPL)[software 2] | |
ER/Studio (.) | Microsoft Windows | |
ERwin | Microsoft Windows: 2000, XP, Server 2003 [software 3] | |
Fujaba | ( Java) | (GNU LGPL) |
Innovator (.) | Microsoft Windows 2000, SuSE Linux 10.3, Solaris 8, Red Hat ( ) | |
MEGA International | Microsoft Windows, Web Platform [software 4] | |
Microsoft Visio | Microsoft Windows | |
MySQL Workbench | (GNU GPL) / (EULA) | |
OmniGraffle (.) | Mac OS X v10.5+ [software 5] | |
Oracle Designer (.) | Microsoft Windows | |
PowerDesigner (.) | Microsoft Windows | |
Rational Rose (.) | ||
RISE Editor (.) | Microsoft Windows | / [software 6] |
SiSy (.) | Microsoft Windows | |
Sparx Enterprise Architect (.) | Microsoft Windows, Linux, Mac OS X ( CrossOver) | [software 7] |
SQL Maestro | ||
SQLyog | Microsoft Windows: 4.10+, NT | / (EULA) [software 8] |
StarUML (.) | Microsoft Windows | ( GNU GPL) |
System Architect (.) | Microsoft Windows | |
Toad Data Modeler (.) | Microsoft Windows | |
Visual Paradigm (.) | / ( ) [software 9] |
^ "" - () ( ) , .
|
|
. . . .
. , .
, . - , . . . :
- , , ;
- , ;
- .
, , , .
. . .2.4.
.2.4.
. , , 1:1. , 1:n, . . . , .
|
|
. , . , (). , .
. , .. . , , (). , , .
(.. ). 5.5." ".
. , () () . , , , , , , . .
, . , . , , , .
54. . . . .
, ( . 2.3). CODASYL. () . ( ), .
:
1. .
:
- (FIFO first input, first output).
- (LIFO last input, first output).
- . (), ( ).
2. .
.
- , - . ( , - .)
-. , () .
3. .
. : , . . : , , . .
:
|
|
- : ;
- : ;
- : ;
- : ;
- : ;
- : ;
- : .
(.. , ). 5.5." ".
. , . . :
- ;
- , .
CODASYL. COBOL, .
. . . .
2.4.1.
.. (Codd E.F.) 1970 . , .
, . , (, , N ..).
D1, D2 ,, Dk (). :
, .
. D1 = (1,2), D2 = (A,B,C) D :
D = {(1,A), (1,B), (1,C), (2,A), (2,B), (2,C)}.
.
. . . 1 , 2 , n n-.
. .
:
1. , .. ;
2. .
, , (. 2.5, ).
1........ 2................ 3 ().............. 4........ 5
і72 | -12298 | 566.40 | ||
і91 | -12299 | 400.00 | ||
... | ||||
і72 | -14407 |
.2.5.
, . , . , .
, (, ). , , . . null, " ".
, . , . ( . 2.5 ). , . ; , . .
. . , ( ) . ( , , . 2.6). , . .., , . , (null).
, | ||
-12298 | 01.12.01 | |
-12298 | 01.12.01 | |
-12299 | 16.04.02 |
.2.6. "" ""
. , , ; .
. , . :
- : ( );
- : ;
- : ;
- : ( ).
CODASYL. 2.1. .
2.1. CODASYL
CODASYL | ( ) |
() | |
- | |
() | (, ) |
() | |
( ) | - |