搜索
1,2,3(11,201203;21,361005;31,215400):::OracleOWB,OLAP,:OLAP,,:,,,:;OLAP;;:RTP311:A:1002-2406(2008)02-0001-03:(60672018):(1978-),,,::2007-12-08:2008-01-061,,(HIS),,,,(On-lineAnalyticalPro2cessing,OLAP)[1]O2LAP,,[2]2,HIS5,,OLAP,,,,,,,,,,211,::,51:,5,,:5,:;;;,;212,(Dimension)12008252Vol125,No12,2008InformationonTraditionalChineseMedicine,,(units),,(Multi-dimension)(),();();(55141544455960);();()213,,,,,,,:,:(),,1()1SYNDROMEVISIT2IDVarchar220pkInp2noVarchar28SYNDROME2TYPEVarchar21SYNDROME2NONumber2pkSYNDROME2DESCVarchar280SYNDROME2DATEDateTREAT2DAYSNumber3,1SYNDROME2CODEVarchar216TREAT2RESULTVarchar24AccordVarchar26214OLAPHIS,O2LAP2005,111,:,,,,2InformationonTraditionalChineseMedicine2008252Vol125,No12,2008OLAP,,,,,3()(),,OWB(OracleWarehouseBuilder)10gETLOracleDiscov2ererOracleWorkflowOracle,WarehouseBuilder[3]311,,,,,,,,,:;,,[4],,,/[5],312,HIS,,:,,,,,;,,,,,,313(ETL),,,,,,,,4OLAP,,,,,,,,,:[1]1[M]1:,200212-31[2]1[M]1:,1999111-121[3]1OWB[J]1,2001,9(107):18-211[4],,1[J]1,2004,24(8):37-391[5],,1[J]1,2004,6(1):14-17132008252Vol125,No12,2008InformationonTraditionalChineseMedicine