Базы данных и СУБД

  • Published on
    16-Apr-2017

  • View
    6.362

  • Download
    1

Embed Size (px)

Transcript

.

.

Attribution-ShareAlike (by-sa) stanislav.katsko.name

Informatics.ssga.ru

1. . .2. .3. .4. .5. .6. .7. SQL. .

.



.

:

.

:

.

.

.1. .2. .3. .

=>

() ,, , , - , .

() ,
. () , , .

: ; ; ; .

= +


( ): (desktop) ; :) - ,
) - ,


( ): (desktop) ;


( ): - ,


( ): - ,


: ,
,


: -
- ,




(, )


:


(): ( )


( ANSI)

1. . , .

2. , , , . ( ), . , , .

3. , , .


( 1 2) ( 2 3) .

: , , .

1. .

2. .

3. , (12), .

4 5. .

6 7. .

8. , .

9. .

10. .

11. , , .

.: ; ; ; -; -.

: ()

( ),




( ),
.

.: ; ; ; ;

:: ; ; ; ;

"" (), .

60- - 70- . XX . . : Information Management System (IMS) IBM. 1968 .; ; Windows.

( ) ( )







:

A:

D:


: ; () ,

. () () .

:
; /
( /, /)
,

( CODASYL) , .

: , (), .

: -, . CODASYL. .

: , .
.

1970 . A Relational Model of Data for Large Shared Data Banks .. relation . , () .

. : ; ; ; ; .

: . , . () ; . , () ; , ( ):
;
.

_
_

123-34454-34233-65232-39243-01. 1200010000500011000300

()

4781453254324677442183746537837432113642......... .. .

837423097780251312252023

, .1. .

2. , , , .

200620073200560012001500

_-

200620071232001500

12

!

!

.

1. -- (1:1)2. -- (1:)3. -- (:).

-- (1:1)

, , , .

"--" (1:)

.: .

"--" (:)

- .

SQL.

SQL

SQL (Structured Query Language) .

70- IBM Research. SQL 1989 . (SQL1)SQL2 1992 .SQL3 1999 .

SQL

SQL ; , , ..; , ; SQL .

SQL

SELECT ( ) ;INSERT () ;UPDATE () ;DELETE () .

SQL

: .SELECT _, FROM .

, , ?SELECT *FROM WHERE = '' .

SQL

: , 5 .SELECT _, FROM WHERE = ''AND < 5 .

Recommended

View more >