基于數(shù)據(jù)倉庫的CRM研究與實現(xiàn).pdf

1、上海海運學(xué)院碩士學(xué)位論文基于數(shù)據(jù)倉庫的CRM研究與實現(xiàn)姓名：王志翔申請學(xué)位級別：碩士專業(yè)：計算機應(yīng)用技術(shù)指導(dǎo)教師：楊麗萍20040101基于數(shù)據(jù)倉庫的CRM研究與實現(xiàn)AbstractCompetetionbetweencorporationshaschangedfromproducttocustomer.Withthedevelopmentandtheextendingofthechainofthesupplydemondsonthem

2、anagementoftheendcustomersarenowbecomingmoreandmoreimportant.Customerbecomesoneo#themostimportantresourcesofenterprises.Efficientmanagementforcustomershasalreadybecometheurgentrequirementofenterprises.Hencecustomerrelati

3、onshipmanagement(CRM)emergeswiththetideofthetimes.BasedondatawarehousetechnologythispaperdiscussesthetechnologytoconstructtheCRMapplicationsystemininsurancefieldaswellasthedevelopmentstepstechnologydifficultiesandtheways

4、ofhowtocarryouttheApplication.CRMsystemisappliedtoinsurancecompanymoreandmorewidely.Makinguseofdatawarehousetechnologyinsurancecompaniesimprovethetheirinformationlevelstomakebetteruseoftheirdata，toimplementdecisionsuppor

5、tsystem(DSS)andtomaintaintheircompanyscompetitiveedge.Theoperatingdataofinsuranceindustryisdiferentgreatlyfromothersbecauseitshistoricaldataismodifiedfrequently.SobuildingtheinsuranceCRMsystembasedondatawarehouseisaveryh

6、ardprojectFirstthispaperoutlinestheoriginingredients(makeup)developingconditionsofCRMtherequirementininsurancefieldandtheimportantworkthatauthorhaddoneinactualproject.SecondthepaperintroducestheconceptandtraitofCRMdatawa

7、rehouseandOLAPsystem.ThenforthemostpartthispaperintroducestheconstructionofallpartsofMTUMENULIFECRMandthemaintechnologyitusesThemaindeveloptoolsofthispaperareoracledatawarehouseandoracledatabase.Thedisplaytoolsthispaperu

8、seareBrioExplorer.ThedatasourceofthispaperisoracledatabaseofmenulifeinsurancecompanysOLTPsystem.ThispapertalksaboutthemaintechnologythatMTUMENULIFECRMsystemusesaswellasthecurrentsystemofmenulifeinsurancecompany.Sincethew

9、orkofETLaccountsmostpartofdatawarehouseprojectthepaperintroducesalotabouttheimplemento#ETL.Atthesametimethispapermakesoutawaymakinguseofassociationruletosolvetheproblemofinsurancepolicysinspection.TobespecificFirsttogett

10、hesupportandtheconfidencemakinguseofmachinelearning.Secondtoinspecttheriskofthenewpolicymakinguseofconfidence.Inanotherwordstherulethatweusetoinspectnewpolicyisdeducedfromclaimdatabefore.Inadditionthispapermakessomeefort

11、sinthewayofperformancerunningofdatawarehouse.Thequalityofcustomersdataisofvitalimportancetothesuccessofdatawarehouseproject.Firstthispaperintroduceacommonwayoncleaningdataofdatawarehouse.Secondthispaperintroducesawaybase

12、donclassicalgorithmtocleanthedataofCRM.Thisalgorithmincludingdatapreprocessdataaggregrationinadvanceandreducingthenumberofmatchingimprovestheperformanceofeliminatingduplicationofcustomerdata.Butthematchingoftheclassicalg