, . , ( 5.2). , .
, , . - , . , .
2.6 () () . INVOICES () (INVNO) (CUSTNO). INVOICE.ITEMS (-) : (INVNO), (GOODS) (QTY). INVOICES INVOICE.ITEMS INVNO.
2.6.
) INVOICES | INVOICE.ITEMS | ) INVOICES | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
, , . :
) SELECT INVOICES.INVNO, CUSTNO, GOODS, QTY FROM INVOICES, INVOICE.ITEMS
WHERE INVOICES.INVNO=INVOICE.1TEMS.INVNO
) SELECT INVNO, CUSTNO, GOODS, QTY FROM INVOICES
( ). . . . .
. , .
, . , - .
|
|
( ), . , . , , .
. .
.
uniVers. , , Bubba Dasdb.
19. .
, () . 90- .
1993 . . 12 OLAP (Online Analytical Processing - ), . .
:
() ;
( ).
. . ().
, . , : , .
. : , -, , .
() , .
, , .
, . . , , , .
|
|
.
, .
. 2.8 () () .
2.8. () ()
) |
| ) |
|
, (-, - ). . "" (, "") , .
, .
(Dimension) - , . , , . , , . , .
(Cell) - , . . , , ( ) (, , ).
2.8() . .
() : .
, . , , Oracle Express Server.
, . , . , ( ).
, : "", "", .
"" (Slice) , . "" , . , "", .
|
|
"" (Rotate) . . , "" , . 2.8(), , , Y - .
"" , . , , .
"" (Drill Up) "" (Drill Down) .
, . .
.
, , Essbase (Arbor Software), Media Multi-matrix (Speedware), Oracle Express Server (Oracle) Cache (InterSystems). , Media/ MR (Speedware), . Cache, , : ( ), .