BI理念下人力资源数据集市的实现

上海交通大学硕士学位论文BI理念下人力资源数据集市的实现姓名：张红英申请学位级别：硕士专业：计算机技术指导教师：徐良贤;莫建林20080701IBIBIKPIKPIETLABSTRACTIIASTUDYONAHUMANRESOURCEDATAMARTUNDERTHEFRAMEWORKOFBUSINESSINTELLIGENCEABSTRACTFlowingthetechnologyofBusinessIntelligencedeveloping,enterprisesbuilddatawarehouseordata-martinordertosolvethepresentquestionswhicharehowtosharedataandinformation.Byanalyzingthepresentseveraldatabase,theHR-DatabaseisanODS(operationaldatastore),andtheHRDataMartisconstructedbyconceptmodel,logicmodel,physicalmodelandsoon.UsingtheMicrosoftsDTStool,themultidimensionaldatesourcearebuilt.HumanResourceisimportantforanenterprise,andithasbeenmanagingfortheorganizationbygaining,developing,maintaining,andutilityofemployees.Inthe21scentury,wehaveenteredknowledgesocial,andpersonwhohasknowledgehasbecomethepowerofimprovingthesocial.Itisanimportantsubjectthatenterprisesusetheartificialintelligencetomanagetheknowledgeableemployees.Realizingakindofartificialneuralnetmodel,itisaexploreforintelligencesHRManagement.KEYWORDS:datawarehouse,datamart,ETL,metadata,neuralnetIIIAbbreviationsFullspellingChineseexplanationAIArtificialIntelligenceBIBusinessIntelligenceETLExtractionTransformationLoadKPIKeyPerformanceIndication;11.1Fig.1-1MISmanagement1-12DecisionSupportSystem,DSSBIDSSAIOLAP.BI2001,ERP1MRPERP1,ERP61-2Fig.1-2HR-MISskeletonmapERP1.North-DBSouth-DBHRODSWorkingTimeRecorder1-2HR-MISHRMISHRMIS32.EXCEL3.??4.BI(KPI)1.22090(BusinessIntelligence)ITBI()BIOracleOLAPjavaXMLBIIBM,Microsoft,SAP,Brio,SASjavaBIAPIScoreCard,MondrianOLAPServerBIBIBIBIsybase,Oracle,Microsoft,SAS,BO2005BlueQueryEnterpriseVBIPower-BIBI41.3KPIETLKPIKPI/OLAP1-3.5HR-DMHR-ODSDTSWorkingTimeRecorderKPIDTS1-3Fig.1-3Neuralnetmodelbuiltflowchart1.4ODSOLAPKPIETLBIHR-DMDTSOLAPOLAPHR-DMETLOLAPBI6BI(DataWarehouse)(OLAP)(DataMining)OLAP2.1BI2.1.1BIBIBusinessIntelligence,GartnerGroup90BIBIWWWBI/(OLAP)OLAP(Extraction)(Transformation)(Load)OLAP()BI72.1.2BI2-1BI[1]OLAP2.1.3BI12ODS12EISOLTPOLAPBI82-1Fig.2-1BIdevelopingonecycle:(ETL)OLAP2-1BIBI92.22.2.1ODSW.H.Inmon[22]ODSOperationalDataStoreODSODSODSDWODSDWODSODSODSODSODSDWODS/3-4ODSODSODS/2-2ODSODSODSBI102.2.2.;;1RalPhKimball,.RalphKimbalBillInmonERPe-Hr112BI112-2Fig.2-2Starschema2-3Fig.2-3Snowflakeschema(2-4)SalesTime_keyItem_keyBranch_keyLocation_keyUnits_soldDollars_soldItemItem_keyItem_nameTimeTime_keyDaymonthBranchBranch_keyBranch_nameLocationLocation_keyStreetCitySalesTime_keyItem_keyBranch_keyLocation_keyUnits_soldDollars_soldItemItem_keyItem_nameSupplier_keyTimeTime_keyDaymonthBranchBranch_keyBranch_nameLocationLocation_keyStreetCity_keySupplierSupplier_keySupplier_typeCityCity_keyCityCountryBI12Fig.2-4Galaxyschema2..3.SalesFactCustomersDimAreaDimCustSnowDimDepartmentDimTypeDimProductSnowDimProductDimTimeDimYearQuarterMonthWeek2-4BI13.3NF.4RalphKimbal.()5.,BI14.2-52008/42008/32008/22008/12007/12006/12005/12-5Fig.2-5Onedatagranularity(),2-6Fig.2-6Doubledatagranularity2008/42008/32008/22008/142-6BI152.2.31:.(Metadata):dataaboutdata():(1)(2)(3)(4)(5)123456782:1;BI162.32.2.4ETLETLExtractionTransformationLoad,ETL60%-80%ETL(Cleaning).1.Extraction:1.(1)()223.2.(Transformation):BI17(1)OLTP(2)ETL(3)(4)(Normalization).:()()IBMEBCDICASCll3SQL:API:4.ETLIT:(TechnicalMetaBI18data)(BusinessMetadata):;;:(OLAP);:;;;ETL/2.3OLAPOLAP()(OLAP)E.F.Codd1993Codd(OLTP)SQLCoddOLAPOLAPOLAP.OLAP(1):OLAP5(2):OLAP(3):OLAP(4)::OLAP():OLAPBI192.42.4.1,SASStatisticsAnalysisSystem(KnowledgeDiscovery)(Associations)(Clustering)(ArtificialNeuralNetworks)(GeneticAlgorithms)(FuzzyLogic)Fig.2-7Knowledgediscoverysystemschema2-7BI202.4.2BP(Back-Propagation)BPBPBP2-82-8BPFig.2-8BPneuralnettopologychartBI212.4.3PP2.5BIBIOLAPETLOLAP22BillInmonRalphKimbalBillInmonRalPhKimbal..3.1BIODSBIBI3-1.Fig.3-1EnterpriseBIskeletonmapANOLAPKPIOLAPKPI1nMISOLTPODS3-1BI2233.2HR-DMBIKPIKPIOLAP3-2Fig.3-2HR-DMsystem&BIsystem3.3HR-DMBI3-3North-DBSouth-DBHRODSHRDMWorkingTimeRecorderHRIMSOLTPHRIMSOLTPOLAPKPI3-2HRDMBI243-3Fig.3-3Datawarehouserequirementanalysisschema3.3.1HRMIS/ODSHR-ODSOLTP,HR-MISHR-DMHR-MISKPI253.3.2HR-MISPOWERBUILDER8.0SQLServer2000HR-MISHR-DMDASDdirectaccessstoragedevice.DASD3.4HR-MISPOWERBUILDER8.0,SQLServer2000HR-DMbaseMicrosoftVisualStudio2005SQLSever2000.1.MicrosoftVisualStudio200512Microsoft2ETLETLAscentialDatastategeXESagentSolutionInformaticaOradeWarehouseBuilderMicrosoftSQLServer20(X)DTSIBMwarehouseManage:SQLServer2000DTSSQLServer2000ETLMicrosoftSQLserver2000DTS()ETL1OLEDBODBC(26)23DTS4.NETDTSETL.(5)SQLSever2000DTS(DTS)MetaDataServicesSQLServerSQLServerMetaDataServicesMetaDataServicesGUID(GUID)GUIDGUIDGUIDGUIDGUIDGUIDGUIDMetaDataServicesSQLServerSQLServerMetaDataServicesDTSSQLServerDTSMicrosoftVisualBasic®MicrosoftAccess3MatlabMatlabMatlabMatrixLaboratoryMatlabSimulink3.5HR-DM273.5.13-4North-DBSouth-DBWorkingTimeRecorderHR-ODSHR-DM3-4Fig.3-4Datamartconceptmodel3.5.21OLTP234OLTP283-53-5Fig.3-5Datamartlogicmodel3.5.3-3-1DatabaseSchema1Und-working2Web-userweb3DIM-object4DM-base5Sat-user6DM-kpKPIIDvarcharintchar(8)char(2)TimedatetimePers_IDvarcharDep_IDsmallintSaLe_IDsmallintSala_IDvarcharVaca_IDvar