- - , -. () : , - , , , , , , , . . , , , , . , - .
. 2.2.
, (Data Base) - , - (. 2.2).
" " , , . - .
, (Data Base Management System) - , . , .
" ". ( ) , ().
, , . . , , , . , .
:
- / - ;
- - .
:
- ;
- ;
- ;
- ;
- ;
- -;
- .
dbf- Excel, Access . , , - "", " ", "", "", " " . .
|
|
. . , - .
- , . "" "relation" ().
IBM 1970 . , , . , . . :
- , ("") ("");
- ;
- , , ;
- , ;
- , .
(Structured Query Language - SQL). , , . , SQL - , .
SQL . SQL :
- ;
- (Insert, Select, Update, Delete);
- .
:
- ( );
- ;
- ;
- ( , , ).
. 2.3.
(. 2.3):
- , ;
- , , , - ;
- , , ;
- ( ), .
, , -, -, .
|
|
:
- ( );
- ( ).
:
- -;
- -;
- ;
- .
- . " - " , . " - " , , . - . - . : Microsoft Access, MySQL ( 5.0).
- . ( ) . - , -, . , . - - ( - ) , . : Firebird, Interbase, MS SQL Server, Oracle, DB2, PostgreSQL, MySQL ( 5.0).
- . () , . . , , - , . , .
- , , "", . SQL . - , , - , (Geographic Informational System - GIS). : SQLite, BerkeleyDB, Firebird, MySQL.
" - -" (. 2.4).
, . - , , , , , . , - , . , "" , .
60- , " " .
|
|
. 2.4.
, , , , , :
- ;
- ;
- ;
- .
1980- , , , " " (Information Warehouse - IW). 1990- , () , " " (Data Warehouse - DW) [Inmon W.H. Building the Data Warehouse, QED/Wiley, 1991, 312 .].
"-, , , , , , , ".
:
- ( , , , ) ;
- , ;
- , () , , .
, , - , , ( 2.3).
2.3. | |
(-, - . .) , , , , , - | |
- | |
, -, | |
() , , , |
, - .
(Distributed Data Mart - DDM). ( ) .
. 2.5.
, ; , . (. 2.5).
|
|
:
- ;
- , ;
- - ;
- ;
- ;
- ;
- .
, , , , . , , "" , -. , , (On Line Transactional Processing - OLTP), , "" (On Line Analytical Processing - OLAP).