,,,
:
4 41-
0021-02014
0021-01931
. , 2009
I.
1.1
1.2
1.3
II.
2.1
2.2
2.3 -
III.
3.1
3.3
3.2
. , . :
- /
;
-
;
- , ,
;
- .
() Windows, , DOS. Windows, , . : Lotus Approach, Microsoft Access, Borland dBase, Borland Paradox, Microsoft Visual FoxPro, Microsoft Visual Basic, Microsoft SQL Server Oracle, , -. , , , , , . , , , , , , .., ( SQL / VBA) . , . , - RAD ( Rapid Application Development), , . Visual Basic 4.0 Visual C++, , , , . -.
, - , . , .
, . .
- , ( ), .
.
1. ;
2. ;
3. ;
, :
1. ;
2. ;
3. -.
, , . B -, --, , . , .
B . , , SQL QBE.
- , , .
:
1. ;
2. ;
3. ;
4. ;
5. ;
6. - ;
7. .
, , , . : .. , .. , .. , .. , .. , .. , .. , .. , ..
I.
1.1
( ). .1. (. .1.) () . /1 C . , . . (), , , . (, ) . , , . , , , , , (). .2. (. .2.)
, . () , (). .
B .
, (), (). . , . .
, . , IMS , Ļ , .
(.2.) , , .3. (. . 3.)
:
1. ( , );
2. (, ).
:
1. ;
2. ;
3. ;
4. ;
5. . .
B , , . : , . .
K . . , . , IMS, PC/Focus, m-Up Data dg, , .
1.2
, (. 4.). (KODASYL). (. .4.) : . : . . . . - -, - - ( ). .5. . (. .5.) B . , , , , . .
, .
K :
;
;
;
;
;
;
;
;
. .
. B .
, , . , .
. : IDMS, db_VistaIII, , .
1.3
IBM (relation).
, . . .
() (). . , - .
C , (, , .), , , . , . , , : , , , . , .
.
, . . .
: .
: DBaseIII Plus dBase IY ( Ashton-Tate), DB2 (IBM), R:BASE (Microrim), FoxFro EoxBase (Fox Software), rd dBASE for Windows (Borland), FoxFro , Visual FoxFro Access (Microsoft), Clarion (Clarion Software), Ingres (ASK Computer Systems) Oracle (Oracle).
: ( ), HyTech ().
, - . -. Oracle 8.. Oracle 7. .
II.
2.1
, . , . , .
, , . - , . , .
.6 () () . INVOICES () (INVNO) (CUSTNO). INVOICE.ITEMS (-) : (INVNO), (GOODS) (QTY). INVOICES INVOICE.ITEMS INVNO.(. .6.)
, , . .7 SELECT SQL () () . (. .7.)
( ). . . . .
. , .
, . , - .
( ), . , . , , . . . . uniVers. , , Bubba Dasdb.
2.2
, () . C 90- .
1993 . 1. B 12 OLAP (OnLine Analytical Processing - ), . .
B :
() ;
( ).
. B . ().
, . , : , .
. B : , -, , .
() , .
, , .
, . . , , , .
.
, .
, . .8 () () .(. .8.)
, (-, - ). . (, ) , .
, .
(Dimension) - , . , , . , , . B , .
(11) - , . . , , ( ) (, , ).
B .8, ( ) . . .9.(. .9.)
B () : .
B , . , , r1 Express Server.
B , . , . , ( ).
B , : , , .
(S1ice) , . , . , (.9) , .
(Rotate) . . , , .86, , X , Y - .
, . B , , .
(Dri11 Up) (Dri11 Down) .
, , , .9, : , , , . , ( ) : , , , , .
, 1995 . , , , , .
, . .
.
, , Essbase (Arbor Software), Media Mu1ti-matix (Speedware), Oracle Express Server (1) Cache (InterSystems). , Media/M R (Speedware), . B Cache, , : ( ), .
2.3 -
- . , - .
- ODMG-93 (Object Database Management Group - - ). ODMG-93 . - .
- , . (, - string) , ( class).
string . class , . - , . - . .
- .10.(. .10.)
- , . . , , ( ), isbn, , .
- . .
, - , , SQL (, ).
( ), .
, - .
, . ', , , , .
, , . , , , -: isbn, , . , (, ), abs. , 6wcem , . , , - 00015.
- . , ( ) . . - , , , . , .
- , , , . , - ( goal), . -, . , , .11. (. .11.)
- . - .
- , .
B 90-e - . B , , : POET (POET Software), Jasmine (Computer Associates), Versant (Versant Technologies), 02 (Ardent Software), ODB-Jupiter (- ), Iris, Orion Postgres.
III.
, , , .
3.1
, :
. B , , .
. .
. , , , .
.
.
. ( ), . , , .
3.2
.
. , (, ).
. , , .
.
. , .
.
.
3.3
.
. .
(, ).
.
, .. , .
.
, , , .
. , .
, .
, , , - , , , , .
, , . B , , , . ., .
( ) .
1. - .
2. - , .
3. - , , .
- , . / , , , , .
- , .
, , , , .
B . . , ().
1. .. .-.: , 2007
2. .. .. . .-.: . , 2005
3. .. .. .. .-.: , 2003
4. .. .. .. . .--: , 2004
5. http://www.finstat.ru
6. http://www.refer.ru
.1.
( .. .. .. . .--: , 2004)
.2.
( .. .. .. . .--: , 2004)
.3.
( .. .. .. . .--: , 2004)
.4.
( .. .. .. . .--: , 2004)
.5.
( .. .. .. . .--: , 2004
)
INVOICES
INVOICE.ITEMS
)
INVOICES
.6.
( .. .. .. . .--: , 2004)
)
SELECT
INVOICES.INVNO, CUSTNO, GOODS, QTY
FROM
INVOICES, INVOICE.ITEMS
WHERE
INVOICES.INVNO=INVOICE.ITEMS.INVNO$
)
SELECT
INVNO, CUSTNO, GOODS, QTY
FROM
INVOICES;
.7. SQL
( .. .. .. . .--: , 2004)
)
)
.8.
( .. .. .. . .--: , 2004)
.9.
( .. .. .. . .--: , 2004)
.10.
( .. .. .. . .--: , 2004)
.11. -
( .. .. .. . .--: , 2004)
- :
Copyright (c) 2024 Stud-Baza.ru , , , .