人寿保险销售决策支持系统的设计与实现.doc

上海大学硕士学位论文人寿保险销售决策支持系统的设计与实现姓名：张胤杰申请学位级别：硕士专业：软件工程指导教师：辛明军20090501AflR14fl SMEat fl*Y #tIW :)4ansIfflflflrjEnn flJ1tflLW fliflUflflnnimn -nWnneYac t3 1:I9Jffl41LkflflWflflYMfl1#flfl *4tW4Y flZ* Tfl1*fl(IItflWflX4ffl7fifl Wfl*ny gnwwY WYIrIi flJHWWWHM01 T t4+flItfl .tiifl*(tilt ABSTRACTInformation technology is regarded as the lifeline of the financial industry, over the past 10 years, in China, the information technology of insurance industry has been in the acceleration. The large insurance companies, such as the Peoples Insurance Company of China, the Life Insurance Company of China, the Ping An Insurance Company of China, and the new small and medium insurance companies spare no effort in information technology. From business data to knowledge-based technology, the development of decision support system that based on data mining and data warehouse, in the next few years, will be sought after by insurance companies.This article focused on the design and implementation of decision support system in life insurance sales, and the research of decision support system technology. Based on the analysis of development status quo and trends of insurance industry information technology in China, in this paper, it puts forward the overall design and implementation of decision support system in life insurance sales, then the family plan system is introduced as an example of decision support system in life insurance sales.In this paper, the main research and innovation summarized as follows:1. Based on the current Life insurance business system, it makes the overall design of life decision support system in life insurance sales, and it proposes the system framework.2. According to the system framework, it puts forward the design and implementation of the online analytical processing system, customer relationship management system and sales management system.3.The customer service and support functions of Customer relationshipmanagement system is achieved a system as the family plan system, through this system, customers can make decision to buy products.Keywords:decision support, life insurance, model,sales, family plan systemVIII:j:ni(U)o.f;:LI4WO*2YE fLoiy :y*ZF 4Tlw11I.z.T)_VIo_wic 1LuIX4op(ft(fu1ujq-(J)()fSSai($) ()fWf1 ssue(S/D 1iJS/wTp) ff/4S!A1s(MG U!IpU!)nO TA& WP)( sscu wis .ioddns uoTsTp:j i%j 080 Y( (SSG UIS(S i.ioddns UOTSTp)UIqjz1 ILIW *f4 06 24 O0wLr(SScII)f 06oz9r08OL 2T OfIoriiyr ww*,SSU(SSU)(SIN UJSS UO!WUUOJUIW I08OL T 0-J OL09 21T OZ (dG U!SS01d 1p MUOi1Dp)fZi1f409-0c 4 o1WWIJ1n)(2f WPJW 4&IrnNT %ff4 4J 1ifJW1*1WJWW*Jflfl WIWunn rnnnntn wmnm wm mrfH4 lfl* XfltkW2YflflNflt aVfltJSfuMfa3WcflcM,*Fflt1i:Ii0W I(!1liUWWft tlifl2EWfl Ufl *Wf)UflWn7 onnrflttM4I 4L*flfl WMfNFfl *14 WWkIfl i$fl*ZL4 U I Li I 4 coot F4aflx) WWD1flWP11 Hf YWfl0IM f(wfltVT.ioddns uoisioap-onaqia(s 4011)(SSUSN uiaisXs“iYiI fffMThflflY?1flnfl 1fl fl iausanq Ffl4flU (4WY (SSUS uiosAs 4.Ioddns uo!spap-3!4044U1Cs)!tZ flf*flWM WflWWflWfltna*J*tdiSftfl:fl41Xt, Tiflt&*;4nVPflfl:4kflh4,4uflit3(t; tIL aa!ZUflfl*RL LtTflFfl*II4V*1&L M t1*Ngflflw, anMfln1Rfl” iSW)1fiJfl,&ttEUW*1 fl”jfljfl*&WiflYuflVfl4*3tia iiat1ttni*-3E1thTfliflfl*u1tt0 flh*t9n1Hfl1U1Hfl?kfl*utflt4Nfl31* flaflT*RJrninrtuwhtntIflJb flTA&flflB, tTIflflnjtt&flNE*fl4k9Iifl, MWJflwjgH1 “1fl”flWJLTh*flJ4,MW4thth1MUfl*O khTflWfltLCi1fl ?fnyfflltS4cfl t nannia nnwawnnutyfliVyflcctcitn oo:afl7 (NU) fl4fl ()O(flfl)Mfln01munan*mnra win ntnt4kfl WdIg n*ns flHfl i4,1*UPjiPfl 4T*wmmiP*flfl4LIflHl*LIM Z+3fl34( *u-l4awfl.cfWWri flWk W”rfl1 W 1O(fl)fflfl tnrrt inn#ojMflfl#flilfl 44liV 4Yfl 11i*Ifl iflWflflWifltJWdfl WW*(W WW&NLI1YflW3 flflWWfUfltZE “t (It*tLflfl1ItYwwc nflitoNu*aux flqih2AMJflUt2.4.11. 4ittfl*Iffflflfl1t)Hti)flflff t#$flo tW*UJWIflflfflMffl, iflTiL0 Wflfltfltflb4th *flWifl, ifliWflflfl.Mt4 flflllt, rEnnM02. 4fltflfl1) &ff!flWMfl PJJFJLW0(1) 5ittflQLttWtT1LP iflitWtL&Tflgfljflt,WiiMIMtntnxetfjctgfl*WJfrit0(2) flJMf4iA*fJflLUWflfl (SIAJHcI)*W L (SNHU) flfl(SNHJN wa4sXs TUuionuflu osnq jGOUI)#tW*tflNflflXir 1rvzuaqi JfJ!,yj ffWHIHflflflfl4 flufltEMfl flLNHIU Uflfg3 flThWflnc:3* n w+nflnfWt1 Oflflfl4YWThW3 W4J%WW?i rLflYnfl (Sfxfltkfl L Ufl*flfl)42 osgnfny flflflnIwoflflfr (Ali wc 0nmnntViR3fl w1 *flWflTh1IHkflIL4flflf T k4flfl3 on11Zt ZWZflia tWflflWt1flWTh1f$ffllkfl ()Z1iWifltt mwiutus4nwnflflfl WWfl143 orj4W3 0flfl yfl3 :fl rW3 otflflfl9 :fl j fflflThP1 onn1 4kflflflflfl :fl 07frZ1fl3* $ZfflfiThwwww-a nmn tflThW$fl1- :fl ui1k (U ThfffWkfl flkfflWft6fl (1nan nntflflflhIt r+#ThIWkUM 4flW .h*fl flttt M1&WdtflkJfl,flNt*i*un tttU, Lflflffz*fitEfli;TftfR!9JiR*ThFFRftflflflJLhflfl1fl t#flIit03SkgMm3fflM,-flflfli?21UllRttiJJtI1fltLWt#E0 tfi3tifl#*, tflfl1*,flt#fl fl1tt#M0izirntIflJ#ThL1M0(3) mnnfl#fljtfltuWifttflRfltt4ji,fltWflJflflrIfl!S, WitflflftHkflSflfl#0PflflA*fl4t*fltJ:tflflItfltLfIflSit#flitinflfflflffl flZi1tcwt)ufltL (Ek9YUiiilfl*flW Uflfflflll?4 oflflfl wrcnc o9jUfl4 *IflHW ItHUWU4tflPbcfW ()gccflj4Jrfl flLJ WPflfldNS4jj9 OflU1 WY4t Yf4WW1fxIW4Jfl Y flfl oMnrgILIWmflItYLfl flP4WflW1i I WflWflLWcft fl4 l flflflRfl flWfr* zflf4Wfl WflWWfMn WUflflflPH ncnnwnnflflUfliT ukrn xflI4fl*nwac nnunin nnnc._wpI ftAtWkflftt 13*AwmJE*tt3.1flflL#flA*m*fltmflegA*floik4flflIt,*aw)(Ienftngah, M*$P*flfl 5afl*nflPflfliflflLfltfltflPWLYflPWi*!h M*M3.1.gpnnSPSPSPS5I+mIL*ftLIbW(OLAPMot*flWlt*flflWm 3.1 A*fllff*fltflfl*t*etsam*nt*nanww nia&ew, A*Wfflfl1. A*mnvtnnnssnnP1aa Mflpflfl186IflfYflNtI flflflYfl n1IraIaW3hiiiflWY flINU JillooyJpj wyn :n*t(flflnowjfl flWfl flJ2fHflfWItflflY 1flI4 $WWUf(_nc atflflflflflflYnan n uw4fltxfl 7flcfn? fflflflY zJflfl1Wflfli rIflflflflrJflW fl4*iSk1flflfl WflWYZJMti W#fldiWflBh$WYE44t r4.ft nil fl4c.fl n*+rn. u*vmfl7S*-I-RSY*Tw flS4)WYS#4*i4sSIItLeE Wfl$WWYEJf44iWfl-1E44m EflIflNV flWEWUIRFWL flWflNWY1 flflflflaflflw*W tIflk*4Ffl flfla iW44W f*Wl*i WIWLiIflWWflMtiWSYn*wnrarnnwvn wnwnn *nItZWWWMftMiOUtIfl fl*iWWWflW4Ia.a*n TW*WVWWflIflW4iNYflflUflWflWWflfflj( WILc(*fl UIidL*VflflWWLYfl flflffflS*Wc(tfl* W,flWi*IflItfl UflflitMWRffiIWI* YEfluflfl*t-MI.vnenan wanncit!JIjwYEflfljfl(W*1fiU4WEJPKWflSfliIt 1*Wwl*4jfl NWJ*4LWW*KIYWYiM41i4f41 fl!*4c 1* a4cnI*jwf* I*flfl44iflfl3.3tFllflit1.itjjiUtMtjt2g)*tV*NJ B/S Mt (Brows&ServerB/SInternet1tTh, t C/Ski1EflJ EiS1JT,ItfltwwwJfl*flWfl flfl (Browser) fl,i!flflfl (Server) flB/S t4JflTJL+ttL1) fl5I-fl4, T hHtlithitffflJ flSflb2) flt3nRPWt1nThflfl3) flttfThT4) JFflL#$fl2.flt4fl*tAtflN B/St*Y MVC3Qf4fttMVC tJEjEttModel-View-Controller”fltTh” t-flMW MVCEvent(Sf4)fl Controller Ji3! Model R View,F Controller flJ Modelsjf)tt,ViewibL tfl Controller ft31T View, View tYs. ModelMVC 4tifhfLt U*W5Foffj4J MVC L5&ztMCiEth tflL tQLk fli01) WSJ (View)Xtttfli Web SJfli5, flfli HTMLflMflfi?Qft Web SNftHTML WISEtflfflfltflit*BWT9L iSMacromedia Flash1 JSP441 XHTML, XML/XSL, WML -tijtqiW, S flflNi LISP fl22nn4flThwtwan 4#W) :3pJFbjJra1wgftJiflU*fl44,1a4f flUnhflsflTfl6U DAN cc Wa cctNflflJ DAP1o jflfl Wflhittfl* Mfl+Www n1owflIws+swyw*rnse fl Iall1flflr qWfl(13jj033U03) #1 (cc_flflnfl 4flWci2U NWkflfl1W&f&*i4,*fli Wt?W U+fl1 fuhiflWflWW *F,*4-U DAV(!POVC)7Wtt$T3.4 :iEflfi3.4.1Iflf*tAtW4 OracleEA Oracle1. Oracle 4t4%4fl14-SOracle fl fl-flfl)flflf0 Et3tfttfl tMtfliftfl*o tflit Oracle DB *ut Oracle Server flfflM0 tA thMtE*UtflI4N3tJLfl WFW2. $fltgNn dThVfiU SfQlLiflM0 Ffl ant Uflfl *i1kfl(Local Database); Et&W1CF, E#fl1* (Remote Database)flit DBtfl4nt,iflfl0OracleS Mt*UflMffj0 tU5fliOracle tt):1)2) Tflt3) flM04) tMtL3.4.2flW*tAE*flR BEA WebLogic ServerffiiIthEflo WebLocjIW*F tt25iiZJfli Java iiLffiflR* 14 JavaU Java Enterprise*LBEA WebLogic Server 4flkbJQW Web ffiflifl,XA1.WMtt2. t1Ufl3. fittJ4. 9W1*T*tE3.5*JMtiffTtFi,Tt flflbffiFiffTfli.Rfi JM).fl *1ftttt VU4.1AtZW*tBVt4fl 4.1BEA SERVER:2:a4.1 AtWlhktWtiEBEA WEBLOGIC SERVER *flflUtfX*tL ?4kfU (f) 45flflLWiP1Th WYflfflflmw44 1(4flfl nflytcnmi fYflWYWtWNi tYhfl14tJ4JVO flflflflyWYWflJif RflW fl4kcflflCU1flWMYPXfl3 *fl2flLflLf44f M4fl*f (JV1O thJ!SS000JJ sisXuuy aurJ-uo) pfzfJ*%flit T&fl_I.n&4I*YriStflEc fi fl4fltMW(f 2QJUrJt (Iu*fl1cfl nucnw 2 *flWJl flfl fl flWWflW afxas. nznwn L(flflhWHf fl fl4+WflifflYMLi flW ciU4PYEifl flflMflrJ fZ44W fl1Lflflfl *II 4flW3 onnn fl6fl3flWWUD fiuflI2fl)rJS fl!fl?*W ktJ*44% WUXfl flPTRW tii (naio IUQUIO8I3UUN dqsuoJa sowoisnj) kflW3$ 1*iflt(VflflfU)fl*I4( Ufl2unumin*w mnriwn wUW:+47 DANfl4&fl DAN U*flu& (tw*ccq wnwmw*flW *fl (JY1O)owycn (i444fl Tf ZNfl:flflflfl 4 qdnos$y wn6?WrJfXTifl fliIflfl4(QflTflWWtJ UIcfl VPili lit frlit#flWWI 4flJW 11 TflfltiI2Wfl rjfln*nsnnincr naaciaix wflflflflflflfloflefrw JxN9Wi Uaac A (flf Ifl4W*wrilitflf Wc*J (cn YtflJt (sWff*4Z Ik1fwr: (c+WMlW cin: tfthaE1thTh402) J&4tU3) Y5Nii-fl-i1WLEFflitfl)ffiktflfli,AYh*U FIflifl(ntwarJ,SFUflh1;flF*RflflF0 3flfl4 IflPWsnttni#nn4) flRS)WtAfl39fl,xtfl*m5n,nflQ4.2.3ThW*L 4flflrnninfltItn0 It-Li4tfli *14tTfl*Rt*flflWMZffUR*4 flf1fl$riUtT,*RIt5flfiMW,tfliff,flflAflU tIThkm cwun (UWY?i !ItN4t/AIWJM1( f4jfljfl flh*(LW17Wfl(tflh1flflIfJt gLflnwamnNwmsaw flrfl6tJ2*Nt 7tflflflWI1iflt41 !i4flflWIThinfl(Wfl!(tMfrfl fl4H?FflMfl tk7WkrWKThln-cnnsnnminui wccnacThin fUktfl Unicn4iflYfl flfl flfl flLfl 01tuflY9flgcy*n ri4JTflYTi4$flt r Rc?,w I-?u LUI,t!a4,-O w)nfussciwoisr4itht4SSayDIin&flMIfl_tufl nA14*4l4*4Nr(rA4 Wi! 4ffi44:tWSSU,WAt7ASSO9.,fl0flf4g flY?U RpJfly9F Wc.g oryj tI_/fl/n/*Jw cn4*n1i$flYt49flfl kmkU 4cflfl*kflThki7 uTh1c.wHn J-jcn?4fl 14f1 !icc *4k1Th14 M1f*fl bflfl fltli*IflYfl iIj1fldMTh44flflfl Oflyflyt,flflUnfl *YK9Wfl (JtfltElccrM ThIflfl fl $fl!tfl Yt4c