?????? OLAP

1
??????OLAP

• ???? ???
• ?? U134089012 ???
• U134089030 ???
• U134089048 ???

2
????

• OLAP??????????????????????,???????????????????????
  ?????????,????????????????,??????????????,????????
  ??????????????,?????????,????????

3
??OLAP????????

• ??? (fast)
• ??? (analysis)
• ??? (shared)
• ??? (multidimensional)
• ??? (information)

4
??OLAP?????

• ????????????,??????(Cubes)???,?????????????
• 1.??(Dimension)???????,??????????????
• 2.??(Measure)????????,?????????????????????

5
?????

• ????????????????(Dimension)?,??????????????????,??
  ????,?????????????,?????,??????????????,??????????
  ?????????,????????????????????????????????
  ???????????????????????,?????????????(Cube),?????
  ??????????????????

6
??????????

• ?OLAP???????,cubes?dimension?hierarchies ??
  measures ??????????????????????????,??????????????
  ??????????????????????????????????????????????????
  ??????

7
??OLAP???
MOLAP ROLAP DOLAP
?? 1.Multidimensional OLAP 2.Cube?????????Server ? 3.?????????????Cube 1.Relational OLAP 2.????????????? (RDBMS) 3.?????? 1.Desktop OLAP 2.Cube?????? Client PC ? 3.????????????? Cube
?? 1.?????? 2.????????? 3.???Web Base 1.?????? 2.???????? 1.?????? 2.?????
?? ???????? 1.?????? 2.????? 1.?????? 2.? User ???
???? Crystal Holos Oracle Express Oracle Discover Business Objects Corvu
8
?.OLAP ???

• 1.????????????
• 2.????????
• 3.?? IT ?????

9
?.???????

• ?????e?.??????????
• ??????????????????????????,??????????????????????,
  ???????????,?????????????,???????????????????????,
  ???????????????????????,??????????????????????????
  ?

10
???????????????

• ???????????????????????????,??????????????????????
  ?????????????????,??????????????????,?????????????
  ??????????,????????????????????????????????HL7????
  ?????,??????????????????????????,??????,??????????
  ???,????????????????,??????????,????????????

11
???????????Web?????????????????

• ?????????????????????????,????????????????????????
  ?????????????????????,????????????????????,???????
  ??????????,???????????????,????????????????

12
?????????????Sybase ????????

• ????????????????,????????????????????Sybase
  PowerBuilder(IDE Tool)?Sybase PowerDesigner (CASE
  Tool)?Sybase Enterprise Application Server
  (?????),???????Sybase ASE?????????????????,??Sybas
  e????????????????

13
????

• ???????????,??????????????????????????????????????
  ????????????,?????????????????,??????????????,????
  ?????????????????????