- .
. , . , , , . .
, , , , . , , , . , , .
, , .
. - , , .
. . 15 , .
. 15.
. . . , , , .
. , , , . , . , Branch. (instance). , (. 16).
|
|
. 16. ,
, . , ( ). (inheritance) . , . (generalization), . . , , . . , , .
, . , - .
, , .
, , . , , .
.
- (). - . , , World Wide Web. , , 50%, .
. , - (), - () - ():
, , - ;
, () , ;
() .
- :
1. - = + + .
|
|
2. - Ĕ = - + .
, :
1. , .
2. , .
3. , , .
4. - Ĕ = - + 1, 2 3.
, :
- . - , Smalltalk, C++ Java. GemStone, .
- . . , , , , .. Ontos, Versant ObjectStore.
- . SQL - - . - , - . - SQL, SQL3.
. , , - . SIM (Semantic Information Manager), .
-
, , .
, 810 . . ( 25 . . ). 25% . , , - . ( 1996 150 . . ) 3% ( 1997 ), , World Wide Web. 50%, . , , , , .
|
|
- . - . , . , . , , .
, , - , , , , , , ( , ), . . , . , - , , , . , , ( , ) , .
. (Extended Relational DBMS ERDBMS). - Ĕ, (Object-Relational DBMS ORDBMS), . , (Universal Server), Ĕ, (Universal DBMS). - Ĕ, . , Oracle, Informix IBM, , . , , . , , 50% .
, SQL. SQL 1991 . SQL, SQL3. SQL3 .
|
|
1970- , -. , . , . , .
- -, OLTP- . , , , , , . , , . , , .
IBM , , . , -. - , , . , . (Bill Inmon), .
-, , , .
.
. ( ) (, , ), ( , ). , , - .
. , - , , , . , .
. , . , , , , .
. , , . , . , , .
|
|
, , . , , , .
, , , . , , , , . , , .
:
1. . , . 50 . 10 000 . . International Data Corporation (IDC), 1996 3 (ROI- Return On Investment) 401%, 90% , , ROI- 40%, 160%, 600%.
2. . , , , . , , , , , , .
3. , . , , , , - . , , , , , , . , , .
OLAP
, , , . / , . -, , - , , , . . OLAP-.
(OLAP) , .
OLAP 1993 , . OLAP- (multi-dimensional DBMS) . OLAP- . OLAP-, , .
. , : 1997 ?. (. 17, ), City () Time () (. 17, ). .
: , ? , , . : ? ?, .
a)
)
)
)
. 17.
, , . , 10 000 .
, , . , (.. erty_Type, , (Flat) (House)), (). (. 17, ). (. 17, ). , Property_Type, City Time. , .
OLAP- . , , , . .
, . , , . , :
___ = _ / _.
, . . . , () , . , . , , , , , , , . , , (drill-down) .
OLAP .
, () , . , , .
(drill-down). , , .
(slicing and dicing). ( ) . , . . .
OLAP- . , . (.. , ) (.. , ). , , , , , . . , . .
, OLAP- , , , , . , /.
, . , , .