.


:




:

































 

 

 

 



() , () .

 

, : , .

 

, . .

.

 

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:

  1. .
  2. .

:

  1. : , DML-, .
  2. : , , .

.

:

ü ();

ü ;

ü ( ) , , . , .

 



<== | ==>
| . .
:


: 2017-02-24; !; : 652 |


:

:

, , 1:10
==> ...

957 - | 915 -


© 2015-2024 lektsii.org - -

: 0.022 .