Bazy_dannykh_Uchebnoe_posobie
.pdf. , ,
, ,
.
9.
.
|
|
|
N |
|
|
|
|
-412 |
|
1022 |
|
|
|
|
-216 |
|
4123 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-412 |
4 |
|
080801 |
|
|
-216 |
2 |
|
080801 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
080801 |
4 |
|
080801 |
4 |
|
080801 |
4 |
|
080801 |
2 |
|
080801 |
2 |
. |
080801 |
2 |
|
«» «» «».
. , «» «»,
, |
. |
,
-412 , ,
. ,
, -2011,
. ,
: «, ». , .
|
, |
, |
, |
|
. |
|
51 |
9:
: . , ,
, |
. |
|
it_date |
|
|
referer |
|
|
url |
|
|
visitor_id |
|
|
http_user_agent |
|
|
os |
|
|
browser |
|
|
browser_ver |
|
|
screen_w |
|
|
screen_h |
|
|
depth |
|
|
cookie |
|
|
java |
java |
|
js |
js |
|
lang |
|
|
ip |
IP, |
, |
ip_country ip_city
,
. |
, |
.
visitor_id cookie
,
. ,
{it_date, referer, url} visitor_id}
, (url) (it_date) (referer)
(visitor_id).
visitor_id os
52
,
.
.
visitor_id ,
,
.
, ,
.
visitor_id cookie ,
. .
.
, .
. , .
IP-, ,
IP . javascript, java ..).
_ (visitor_id, cookie, it_date)
/.
{it_date, referer, url} visitor_id}
,
, , yandex.ru/search... itsoft.ru
.
.
, |
, |
.
.
.
,
. ,
. ,
53
4: , , , -.
,
, , .
,
.
( «» ),
,
,
, ,
, - «»
.
54
6.
, |
, |
, ,
, .
.
:
()
().
. |
|
. |
. |
A comparison of Commercial and Military Computer |
|
Security Policies : |
, |
, |
|
|
, |
.
,
.
, ,
. |
, |
.
3 :
, ,
.
- ,
.
.
.
55
, , -
.
10:
,
.
:
17 .
, 1960 .
5 .
: .
:
.
, -, "-
" (Business Rules)
.
:
:
:
,
(Null),
;
,
,
.
11:
. MS Access ,
, :
YEAR(NOW())
56
NOW() , , YEAR(data)
, .
12:
,
, 1960
.
.
.
MS Access :
Between 1960 AND YEAR(NOW())
MS SQL Server 7.0 "-". ,
, :
YEAR_PUBL >= 1960 AND YEAR_PUBL <= YEAR(GETDATE())
GETDATE() MS SQL Server7.0,
, YEAR_PUBL , .
, .
,
,
-. , ,
MS SQL Server 7.0 |
, |
,
.
,
,
.
,
,
.
, ,
, , -,
, , .
, .
57
,
. ,
,
. ,
.
,
-. ,
.
.
(>NOT NULL>) (>NOT NULL>). MS Access MS SQL Server97 :
HOME_PHON IS NOT NULL OR WORK_PHON IS NOT NULL
, :
,
,
.
.
.
,
.
.
.
(. trigger) ,
, ,
.
(INSERT), (DELETE) (UPDATE) .
58
|
|
|
|
|
|
|
|
|
|
|
|
, |
|
|
|
|
|
|
|
. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
, |
|
|
. |
, |
|||||||
, |
|
|
|
|
|
|
|
|
|
. |
|
|
|
|
|
|
|
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
3 |
|
|
|
1 |
|
|
|
1 |
|
|
||
|
2 |
|
|
|
|
|
2 |
|
|
|
2 |
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|||||||||
|
|
|
|
|
|
|
|
|
|
|
3 |
|
|
|
1 |
|
|
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
5 |
|
|
|
1 |
|
|
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|||||
|
|
|
« |
» |
|
|
|
|
« |
». |
|
|
|||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
, |
|
|
|||
, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
, |
|
||
|
|
|
|
|
|
|
|
. |
|
|
, |
|
|
|
|
|
|||
|
|
|
|
, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
, |
|
- |
. |
|
|
, |
|
|
|
|
|
||||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
. |
|
|
|
|
, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
, |
|
|
|
|
|
|
|
|
|
|
|
|
, |
|
|
||||
. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||
, |
- |
. |
|
|
|
|
|
|
|
|
|
|
|
|
|||||
, |
|
|
|
|
|
|
( |
|
|
|
|
|
, |
|
|
|
|
|
|
) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
, |
|
|
|
. |
|
|
|
|
|
|
, |
|
|
|
|
|
|||
. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
, |
|||
|
|
|
|
|
|
|
|
. |
|
|
|
|
|
|
|
|
|||
|
|
|
, |
|
|
|
|
: |
|
|
|
|
|
|
|
|
|||
|
|
|
( |
) |
|
|
|
|
|
|
|
|
|
|
|
|
|||
|
|
|
|
, |
|
|
|
|
|
|
|
|
|
|
|
|
|||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
59 |
,
.
,
.
,
"" .
"" ,
(
, , ).
,
SQL.
,
. ,
,
SQL.
, ,
.
,
,
(. 13).
, Internet:
«
.
.
, ,
,
».
60