Bazy_dannykh_Uchebnoe_posobie
.pdf
10. 
(Distributed DataBase - DDB) 
, |
, |
, 
,
.
,
. 
,
; 
, 
. |
- |
. |
, 
.24. 
"
" 
, 
. ("
" 
).
.25. 
.
(DDB) 
(C.J. Date. 
12 
DDB:
(local autonomy)
(no reliance on central site)
(continuous operation)
(location independence)
(fragmentation independence)
(replication independence)
(distributed query processing)
111
(distributed transaction processing)
(hardware independence)
(operationg system independence)
(network independence)
(database independence)
,
.
, 
, 
;
.
, 
. 
- 
.
, 
. 
"
, 
".
. 
,
DDB, 
,
. 
. 
.
(
) 
, 
.
: 
. 
(
, 
112
). 
.
70:
(
, 
, 
)
. 
, 
. 
. 
,
(
, 
). 
"
" 
:
@
, 
@
ORDER BY 
;
"
" 
. FROM 
@ 
_
@
ORDER BY 
;
:
, 
.
, 
_
.
, 
@
,
(
)
.
,
SQL. 
, 
.
71:
.
, 
.
, 
.
,
.
@
, 
@
.
= 
.
;
(INSERT, UPDATE, DELETE),
.
,
.
, 
.
- 
.
, 
, 
.
, 
1-2, 
. 
-
, 
- 
. 
- 
,
. 
DDB
.
.
(
) 
, 
, |
. |
, |
, 
. 
114
. 
, 
.
, 
.
.
, 
COMMIT_POINT_STRENGTH (
). 
, 
.
CA-OpenIngres,
Informix, Microsoft SQL Server, Oracle, Sybase.
. 
. 
Oracle.
72:
, 
.
, 
.
. 
(database link),
(london_unix), 
IP-
.
CREATE PUBLIC DATABASE LINK london.com
CONNECT TO london_unix USING oracle_user_ID;
, 
, 
, 
SELECT 
, 
:
SELECT 
.
, 
.
FROM 
@london.com, 
WHERE 
.
= 
.
;
115
, 
, 
,
, 
. 
SQL CREATE SYNONYM, 
. 
.
@london.com 
:
CREATE SYNONYM 
FOR 
@london.com;
:
SELECT 
.
, 
.
FROM 
, 
WHERE 
.
= 
.
(Distributed Query -DQ) - 
,
, 
- 
.
73:
, 
. 
, |
- |
. |
- 10000 
, 
- 100 
(
). 
, 
:
SELECT 
.
, 
.
,
.
FROM 
, 
WHERE 
.
= 
.
;
|
, |
|
. |
( |
) |
. |
( |
). |
- |
|
, |
, 
.
. 
, 
. 
, 
, 
.
116
|
, |
|
|
, |
, |
, |
, |
|
, |
, |
, |
|
|
, |
, |
|
|
|
. . |
.
|
|
|
|
. |
- |
, - |
, |
|
|
|
|
. |
|
: |
|
|
|
, |
|
|
, |
XML. |
|
|
- |
, |
- |
|
|
|
|
|
|
, |
|
|
. |
|
|
Microsoft |
|
ODBC |
Open Database Connectivity Overview |
|
|
- |
. |
|
, |
|
|
: Excell, |
Access, Foxpro |
. |
«
», 
, 
SQL-
. 
.
, |
, |
.
- 
, 
.
, 
,
- 
, 
(
CA-OpenIngres 
Sybase). 
MS Access 
«
», 
.
117
11. 
-
«
»,
: 
, 
, 
.
-
.
.
-
26.
:
, 
, 
.
(
), 
. 
25.
.
,
/
.
.
,
,
, 
(
).
(
) 
.
.
, 
,
.
, 
(
)
, 
.
118
. 26. 
-
-
, 
.
.
, 
, 
.
,
. |
, |
.
.
, 
, 
.
-
,
, 
;
, 
.
.
119
"
-
". 
27.
:
, 
, 
.
(
), 
.
.
, 
, 
, 
/
. 
SQL, 
.
. 
.
,
.
, 
,
. 
.
, 
, 
.
. 27. 
«
-
».
120