() , () .
, : , .
, . .
.
SQL
DISTRIBUTE TABLE <table-name> HORIZONTALLY INTO
<name> WHERE <predicate> IN SEGMENT <segment-name site>
.
.
<name> WHERE <predicate> IN SEGMENT <segment-name site>
DISTRIBUTE TABLE <table-name> VERTICALLY INTO
<name> WHERE <column-name-list> IN SEGMENT <segment-name site>
.
.
<name> WHERE <column-name-list> IN SEGMENT <segment-name site>
.
. , , , - .
. , , . , , , .
, . . ( ) , . , .
:
1. . , . , ,
. , , , .
|
|
2. . , . .
3. . , .
4. . , , , .
5. . (. . ) , . : . , . .
6. .
, .
7. . , , SQL.
8. . , . .
9. . , .
10. . , .
11. . , , .
. . , .
. , , . .
. , .
:
() ,
|
|
,
.
() . , . , . , .
. . , , . .
. , . , . . , , . , .
. .
. : , .
, .
, (, , ).
, , .
2 :
I. 1 ().
begin_commit . PREPARE.
-.
II. 2 ( ).
ABORT: abort ; GLOBAL_ABORT (-).
-, , .
COMMIT, commit . GLOBAL_COMMIT .
: end_transaction .
, .
. SQL LINK. .
SALES:
CREATE PUBLIC DATABASE LINK < > USING < >;
:
CREATE DATABASE LINK < > CONNECT TO < > IDENTIFIED BY <>;
- .
Oracle:
- .
- .
:
|
|
- : , DML-, .
- : , , .
.
:
ü ();
ü ;
ü ( ) , , . , .