基于数据仓库的c_s模式财务物流信息系统设计（design of c_s model financial logistics information system based on data warehouse）

基于数据仓库的C_S模式财务物流信息系统设计（DESIGNOFC_SMODELFINANCIALLOGISTICSINFORMATIONSYSTEMBASEDONDATAWAREHOUSE）RECEIVEDDATE20061026PROJECTSUPPORTEDBYTHENATURALSCIENCEFOUNDATIONOFANHUIPROVINCE2004KJ037,ANHUIPROVINCEHUMANITIESANDSOCIALSCIENCERESEARCHPROJECTOFEDUCATIONDEPARTMENT2006SK219ZDABOUTTHEAUTHORGUOXINGZHONG1962,MALE,ANHUI,FUYANG,MASTER,ASSOCIATEPROFESSOR,ENGAGEDINPEOPLERESEARCHONINDUSTRIALINTELLIGENCEANDCOMPUTERAPPLICATIONTECHNOLOGYDESIGNOFC/SMODELFINANCIALLOGISTICSINFORMATIONSYSTEMBASEDONDATAWAREHOUSEGUOXINGZHONG,FANGYONGSHENG,WANGYONGANHUIUNIVERSITYOFTECHNOLOGYANDSCIENCE,ANHUI,WUHU241000ABSTRACTTHEDATAWAREHOUSETECHNOLOGYANDC/SSCHEMADATABASETECHNOLOGYAREAPPLIEDTOTHEINTEGRATIONDESIGNOFUNIVERSITYLOGISTICS,FINANCEANDLOGISTICSINFORMATIONSYSTEM,ANDTHEEVENTDRIVENSYSTEMISADOPTEDSYSTEMSTRUCTUREANDBUSINESSANDINFORMATIONPROCESSINGINTEGRATIONMODEL,THEACCOUNTINGINFORMATIONCOLLECTION,STORAGE,PROCESSING,TRANSMISSIONEMBEDDEDINTHEBUSINESSPROCESSSYSTEM,DIRECTLYDERIVEDFROMTHEBUSINESSDATAACCOUNTINGINFORMATIONTHESYSTEMORGANICALLYCOMBINESDATAWAREHOUSE,METHODBASEANDMODELBASE,ANDUSESDATAWAREHOUSETECHNOLOGYTORECORDALLKINDSOFCHARACTERISTICDATAOFBUSINESSACTIVITY,TOMAXIMIZETHECOLLECTIONOFBUSINESSDATA,TOACHIEVETHEREORGANIZATIONOFTHEACCOUNTINGBUSINESSPROCESS,FORTHELOGISTICSGROUPTOPROVIDEMANAGEMENTANDDECISIONMAKINGSUPPORTKEYWORDSEVENTDRIVENDATAWAREHOUSECLIENT/SERVERINFORMATIONSYSTEMCLCNUMBERTP39C9316DOCUMENTIDENTIFIERNUMBERA,ARTICLENUMBER1673629X200708016904DESIGN,OF,C/S,MODEL,ACCOUNTING,AND,LOGISTICS,MANAGEMENTINFORMATION,SYSTEM,BASED,ON,DATA,WAREHOUSEGUO,XINGZHONG,FANG,YONGSHENG,WANG,YONGANHUI,UNIVERSITY,OF,ENGSCIAND,TECHN,WUHU,241000,CHINAABSTRACTBUSINESS,ACCOUNTING,DATA,WAS,DIRECTLY,FROM,BUSINESS,INFORMATION,WHICH,APPLY,DATA,IMPORTED,STORAGE,TECHNOLOGY,AND,DATABASETECHNOLOGY,BASED,ON,C/S,MODEL,THE,DESIGN,OF,INTEGRATION,OF,LOGISTICAL,AND,FINANCIAL,LOGISTICS,INFORMATION,SYSTEMS,FOR,AND,USE,INCIDENTDRIVEN,ARCHITECTURE,AND,INTEGRATED,OPERATIONAL,INFORMATION,PROCESSING,AND,EMBED,ACCOUNTING,INFORMATION,COLLECTION,STORAGE,PROCESSING,TRANSMISSION,INTO,THE,OPERATIONAL,PROCESSING,SYSTEMS,THIS,WAY,DATA,STORAGE,METHOD,STORAGE,THROUGH,AND,MODELS,STORAGE,ORGANICAL,WERELY,INTEGRATED,AND,THROUGH,THE,VARIOUS,OF,THE,DATA,RECORDED,FEATURES,USING,DATA,WAREHOUSE,TECHNOLOGY,MAXIMIZED,COLLECTION,OPERATIONAL,DATA,AND,ACCOUNTING,BUSINESS,PROCESSES,TO,THE,REORGANIZATION,WHICH,SUPPORT,THE,MANAGEMENT,AND,DECISIONMAKING,ACHIEVE,FOR,LOGISTICALGROUPSKEYWORDSEVENTDRIVENDATAWAREHOUSECLIENT/SERVERINFORMATIONSYSTEM0INTRODUCTIONWITHTHEDEEPENINGOFTHEREFORMOFUNIVERSITYLOGISTICSSOCIALIZATION,THELOGISTICSMANAGEMENTSYSTEMPROFOUNDCHANGESHAVETAKENPLACE,ANDEACHBUSINESSENTITYMUSTOPERATEINACCORDANCEWITHITSBUSINESSMODELMARKETORIENTEDMANAGEMENTANDMANAGEMENTTHISGIVESLOGISTICAL,FINANCIAL,ANDLOGISTICSMANAGEMENTPRESENTSNEWCHALLENGESTHETRADITIONALACCOUNTINGINFORMATIONSYSTEMISBASEDONASINGLELOANANDLOANTODESCRIBETHEECONOMICBUSINESS,REFLECTINGONLYECONOMICTRANSACTIONSFINANCIALASPECTSOFACTIVITIESITPASSIVELYACCEPTSTHENUMBEROFBUSINESSPROCESSINGSYSTEMSITISONLYUSEDTOCOLLECT,STOREANDMANAGEFINANCIALDATA,NOTFORPOLICYMAKERSPROVIDINGDECISIONSUPPORTDIRECTLYCANNOTMEETTHENEEDSOFREALTIMECONTROLMEANWHILETRANSACTIONINFORMATIONANDOTHERBUSINESSINFORMATIONRECORDEDBYTHETRADITIONALACCOUNTINGINFORMATIONSYSTEMTHEREISOVERLAPINTHERECORDEDINFORMATION,RESULTINGINDATAREDUNDANCY,ANDITSDATAORGANIZATIONANDMANAGEMENTOFDATAINTEGRATION,EFFICIENCY,HISTORICALDATA,DATAINTEGRATIONANDSOON,1,2INVIEWOFTHEABOVEPROBLEMS,THEAUTHORPROPOSESTOBUILDONTHEBUSINESSPARTDRIVENINFORMATIONSYSTEMINTEGRATINGLOGISTICS,FINANCEANDLOGISTICSINUNIVERSITYACCOUNTINGINFORMATIONCOLLECTION,STORAGE,PROCESSINGANDTRANSMISSIONAREEMBEDDEDINTOTHEBUSINESSDEPARTMENTINTHEMANAGEMENTSYSTEM,THEACCOUNTINGINFORMATIONISDIRECTLYDERIVEDFROMTHEBUSINESSDATAACCOUNTINGINFORMATIONTHESYSTEMISHIGHLYINTEGRATEDANDCOORDINATEDWITHOTHERBUSINESSSYSTEMSSIMULTANEOUSBASISINC/SMODE,ASYSTEMATICDATASTORAGEENVIRONMENTISBUILTTODISPERSETHEINCONSISTENTOPERATIONOFTHEDATAISCONVERTEDINTOINTEGRATED,UNIFIEDINFORMATIONTOITWILLEFFECTIVELYELIMINATETHE“INFORMATIONISOLATEDISLAND“ANDMEETTHEFINANCIALMANAGEMENTOFTHELOGISTICSGROUPNEEDFORBUSINESSDECISIONMAKING1SYSTEMDESIGNTHOUGHT11SYSTEMSTRUCTURETHESYSTEMADOPTSEVENTDRIVENARCHITECTUREITSBASICCONCEPTION25ITISTHERESOURCES,ECONOMICEVENTSANDPARTICIPANTSOFTHEUNIVERSITYLOGISTICSGROUPTHERELATIONSHIPISCOMPUTERIZEDANDOBJECTORIENTEDTHEFORMANDRESOURCESOFTHELOANENTRIES,WHICHAREINTERSEMANTICANDIMPERSONAL,AREPROCESSEDSEVENTEENTHVOLUME,EIGHTHISSUEINAUGUST2007,COMPUTERTECHNOLOGYANDDEVELOPMENTCOMPUTER,TECHNOLOGY,AND,DEVELOPMENT,VOL17,NO8AUG,2007EVENTSANDPARTICIPANTSRELATEDFINANCIALANDNONFINANCIALDATARECOGNITION,COLLECTIONANDSTORAGEINTHEEVENTDRIVENAPPROACH,THEUSEOFMODERNINFORMATIONTECHNOLOGYANDDATAWAREHOUSETECHNOLOGYTOACHIEVEFINANCIALANDNONFINANCIALINFORMATIONREALTIMEACQUISITION,REALTIMEPROCESSING,CENTRALIZEDSTORAGE,ANDCOMPREHENSIVESHARING,SOTHATTHEFINANCIALWORKFROMTHEACCOUNTINGTYPETOTHEMANAGEMENTTYPEOFACCOUNTING,TOPROVIDESUPPORTFORDECISIONMAKINGTHEARCHITECTUREOFTHESYSTEMISSHOWNINFIGURE1LOGISTICSINFORMATIONPROCESSINGBUSINESSEVENTSBYACCESSMANAGEMENT,PURCHASEMANAGEMENT,DISTRIBUTIONMANAGEMENT,INVENTORYMANAGEMENTMODULE,ASSHOWNINFIGURE2MAINMENTIONFORTHEPROCESSOFCIRCULATIONOFGOODS,TRANSACTIONPROCESSINGANDTHEOVERALLACCOUNTINGOFGOODSHOLDFORGOODSTOACHIEVEASINGLEPRODUCTACCOUNTING,THEDISTRIBUTIONOFAVARIETYOFFORMSTOPROVIDEFENGRICHSUPPORTPROVIDEENQUIRIESANDANALYSISOFDISTRIBUTIONDATAANDINVENTORYOFGOODSANDACCURATELYREFLECTTHEOPERATINGCONDITIONSOFVARIOUSGOODSACCORDINGTOTHENATUREOFBUSINESSPROCESSQUALITYANDFINANCIALSYSTEMSAREORGANICALLYINTEGRATEDANDDELIVEREDINREALTIMEACCORDINGTOANORIENTATIONORIENTEDFINANCIALSYSTEMDATASTRENGTHENSUPPLIERMANAGEMENTANDDETAILSOFFINANCIALTRANSACTIONSDURINGPURCHASINGACCOUNTSDOCKING,REALTIMERECONCILIATION,WITHOUTAFFECTINGTHECREDIBILITYOFTHELOGISTICSGROUPUNDERTHEPREMISEOFTHEUSEOFCOMMERCIALCREDITTOIMPROVETHEEFFICIENCYOFFUNDSGOODSINFLOWANDDISTRIBUTIONTHEDELIVERYLINKSARERELATIVETOTHEFINANCIALSETTLEMENTANDCOSTACCOUNTINGOFTHEFINANCIALSYSTEMTHELOGISTICSANDCAPITALFLOWSHOULDBECLOSELYINTEGRATEDWITHTHELOGISTICSOFTHELOGISTICSITISPOSSIBLETOCONTROLINADVANCEANDINEVENTSFAITHFULLYTIMEDMATERIALCOSTSTHEDATACANBECOMPAREDWITHTHEDAILYINCOMEOFCANTEENSOLDBYCAMPUSCARDSYSTEMYES,CALCULATETHEGROSSPROFITMARGINFORAPARTICULARPERIODOFTIMESTRICTMATERIALCOSTCONTROLINTHEMODEOFOPERATIONGUARANTEESTHEINTERESTSOFSTUDENTSACCORDINGTOTHECHARACTERISTICSOFLOGISTICSMANAGEMENTINCLUDETHEINFLOWANDOUTFLOWOFGOODSACCORDINGTOTHECHANNELROADSANDFLOWSARESUBDIVIDEDESPECIALLYTHEFRESHFOOD,BECAUSEOFTHEITSPARTICULARITYISSPECIALLYDEALTWITHTHEINFLOWANDOUTFLOWREALACTIONPHYSICALINVENTORYMANAGEMENT,WHICHCANBECARRIEDOUTATEACHTIMEDURINGTHEACCOUNTINGPERIODMONITORANDENSURETHEBALANCEOFACCOUNTATTHEENDOFTHEAUTOMATICCHECK,AUTOMATICCALCULATION,DISCAUTOMATICALLYGENERATERELEVANTACCOUNTINGDOCUMENTSACCORDINGTOTHEAGREEDRULESYES,TOTHEGOODSTHEFINANCIALSYSTEMOFTHERECEIPTISNOTAUTOMATICTHEACCOUNTISINLINEWITHTHEACCOUNT12BUSINESSANDINFORMATIONPROCESSINGMODELTHISARCHITECTUREUSESABUSINESSANDINFORMATIONPROCESSINGINTEGRATIONMODEL,THEACCOUNTINGINFORMATIONCOLLECTION,STORAGE,PROCESSINGANDTRANSMISSIONAREEMBEDDEDINTOTHEBUSINESSPROCESSINGSYSTEM,WHICHCANCOLLECTFINANCIALINFORMATIONINREALTIMEWHENBUSINESSOCCURSFIG1ARCHITECTUREOFEVENTDRIVENFINANCEANDLOGISTICSINFORMATIONSYSTEMFIG2MODELOFFINANCIALLOGISTICSINFORMATIONPROCESSINGANDNONFINANCIALINFORMATION,EXECUTION,PROCESSING,ANDCONTROLRULESHOWDOESITWORKWITHINTHESYSTEMTHEINTEGRATIONOFBUSINESSPROCESSANDINFORMATIONPROCESSINGISADIFFICULTPROBLEMINSYSTEMDESIGNTHEDIFFICULTYOFINTEGRATIONISHOWTOTRIGGERTHETRIGGERPOINTOFINFORMATIONPROCESSINGCONSIDERATIONSHOULDBEGIVENTOGROUPOPERATIONS,INSTITUTIONS,PLANS,INTERNALCONTROLS,COSTEFFECTIVENESSANDSOON,THROUGHTHERATIONALDIVISIONOFTHEBUSINESSPROCESSTODETERMINETHETRIGGERPOINTLETTERTHEPROCESSINGFLOWCANBEDESCRIBEDASALLRAWNUMBERSWHENBUSINESSEVENTSOCCURRECORDINGBUSINESSEVENTSACCORDINGTOTHESOURCEDATAAPPROPRIATELYPROCESSEDINTOSTANDARDCODEINDIVIDUALFEATURESANDATTRIBUTESAREINTEGRATEDINTOABUSINESSEVENTDATAWAREHOUSETRADETHEBUSINESSEVENTDATAWAREHOUSENOTONLYSTORESTHELOGISTICSINDUSTRYTHATMEETSTHEACCOUNTINGREQUIREMENTSTHEBASICINFORMATIONOFTHETRANSACTIONEVENTALSONEEDSTOSTORETHELINKSBETWEENTHEBUSINESSEVENTSOTHERBUSINESSINFORMATIONISGENERATEDAUTOMATICALLYTHROUGHTHEFINANCIALSYSTEMANDISAUTOMATICALLYDEPOSITEDINTOTHEBUSINESSEVENTDATAWAREHOUSECONVERSIONOFBUSINESSEVENTDATATOACCOUNTINGVOUCHERSTATEMENTSITISBASEDONTHEBASICDATATABLEINTHEBUSINESSEVENTDATAWAREHOUSEACCOUNTINGSTANDARDSDEFINITIONVIEW,TRADITIONALACCOUNTINGDOCUMENTS,GENERALLEDGER,ACCOUNTINGTHEREPORTBECOMESTHEOUTPUTVIEWOFTHEBUSINESSEVENTDATABASE,NOLONGERASPHYSICSTHEENTITYEXISTSINTHEDATABASEANYAUTHORIZEDUSERCANPASSTHEBUSINESSTHEDATASTOREDBYTHEEVENTDATAWAREHOUSETODEFINEANDOBTAINWHATISREQUIREDUSINGINFORMATION,CLASSIFICATION,SUMMARIZATIONANDBALANCECALCULATIONAREALLINCLUDEDINTHEREPORTQUERYOUTPUTPROCESSINTHISWAY,THETRADITIONALFINANCIALINFORMATIONSYSTEMBECOMESONEOFTHEBUSINESSEVENTDRIVENFINANCIALANDLOGISTICSINFORMATIONSYSTEMSUSEROUTPUTVIEWDIFFERENTUSERSOPERATIONLAYER,CONTROLLAYERANDTHEDECISIONLAYERCANDIRECTLYQUERYEACHOFTHERECORDEDEVENTSTHROUGHTHEVIEWPROPERTIESANDENSUREREALTIMECONTROLOFINFORMATIONPROCESSINGBUSINESSAFFAIRSAPROCESSINGUNITINADATAWAREHOUSETHATCAPTURESTHEBUSINESSWHENITOCCURSSERVICEDATA,NOTONLYCANTHEBUSINESSPLANANDCONTROLBEIMPLEMENTED,BUTALSOITCANBEADJUSTEDTHEACCURACYANDCOMPLETENESSOFTHEDATA13INTEGRATIONOFDATATHESYSTEMSETUPTHREEBASICLIBRARIESBUSINESSEVENTDATAWAREHOUSELIBRARIES,METHODSLIBRARIES,ANDMODELLIBRARIESTHETHREELIBRARYPASSESTHROUGHTHEMIDDLEINFORMATIONDESKTHEDATAINTEGRATIONISCARRIEDOUTTOELIMINATETHEORIGINALINFORMATIONISLANDS,170THESEVENTEENTHVOLUMEOFCOMPUTERTECHNOLOGYANDDEVELOPMENTPROVIDESTHEBASISFORGROUPFINANCIALOPERATION,CONTROLANDDECISIONMAKING1THEBUSINESSEVENTDATAWAREHOUSEISUSEDTOSTORETHEINTEGRATIONINTHEECONOMICACTIVITIESBASICBUSINESSINFORMATION,INCLUDINGHISTORICALDATA,CURRENTDATA,ANDCOMPOSITENUMBERSACCORDINGTOBUSINESSEVENTDATAWAREHOUSEINFORMATIONCOMESFROMDATAFROMDIFFERENTLOCATIONSLIBRARYOROTHERINFORMATIONSOURCEITSINFORMATIONSOURCESAREDISTRIBUTEDANDHETEROGENEOUSPOINT,WHERETHEPRIMARYINFORMATIONCANBEREGARDEDASANENTITYDEFINEDONTHEINFORMATIONSOURCESETOFMATERIALIZEDVIEWSAMATERIALIZEDVIEWISDIFFERENTFROMWHATISCOMMONLYCALLEDVIEWTRADETHENUMBEROFMATERIALIZEDVIEWSINADVANCEOFADATAWAREHOUSEMANAGEMENTSYSTEMITISEXTRACTEDFROMANINFORMATIONSOURCEANDSTOREDINABUSINESSEVENTDATAWAREHOUSE,THESEVIEWSBECOMEPHYSICALSTORAGEOFDATAENTITIESTHESYSTEMHASTWOMAINFUNCTIONSEXTRACTINGTHEDATANEEDEDFROMEACHINFORMATIONSOURCEANDPROCESSINGITAFTERSTORAGETOTHEBUSINESSEVENTDATAWAREHOUSEDIRECTLYINTHEBUSINESSEVENTDATAWAREHOUSETHELIBRARYHANDLESUSERQUERIESANDDECISIONANALYSISREQUESTS,SUCHASPROFITABILITYANALYSISOFDEBTPAYINGABILITY,ANALYSISOFCAPITALTURNOVER,COMPREHENSIVEANALYSIS,FINANCIALSTATEMENTSTATUS,ECONOMICINDICATORSANDCHANGES,ETC2METHODBASEISTHEFOUNDATIONOFFINANCIALDECISIONMAKINGSQUAREFAKUFORSTORAGEOFINFORMATIONEXTRACTION,BUSINESSPROCESSINGANDCONTROLRULES,ANDNOTTHESAMERULESOFIDENTIFICATIONANDMEASUREMENTINCLUDINGACCOUNTINGSTANDARDSANDNONGAAPRULESWHENACCOUNTINGINFORMATIONISUSEDBYUSERS,THESYSTEMCANBECLASSIFIEDACCORDINGTODIFFERENTITEMSTHECHOICEOFDIFFERENTVALIDATIONANDMEASUREMENTRULESISCOMBINEDWITHTHEUSERDECISIONMAKINGRELEVANTACCOUNTINGINFORMATIONCONTENT,RATHERTHANTHETRADITIONALACCOUNTINGINFORMATIONSYSTEMTHERULESARESOLIDIFIEDINTHEACCOUNTINGDATAFORINVOICING,THERANGEOFINVENTORYVALUATIONMETHODSTIPULATEDBYTHEACCOUNTINGSTANDARDSASREQUIREDBYTHEUSERWITHINTHESELECTION,THEUSERUSESTHEACTUALCOSTOFTHEVALUATION,THEREAREINDIVIDUALVALUATIONMETHOD,FIFOMETHOD,WEIGHTEDAVERAGEMETHOD,MOVINGAVERAGEMETHODANDLIFOFIVEOPTIONSAREAVAILABLEINADDITION,THEMETHODLIBRARYCANALSOCONTAINSOMEBASESTHEMATHEMATICALMETHOD,MATHEMATICALSTATISTICSMETHOD,ECONOMICMATHEMATICSMETHODANDPREDICTIONMETHOD,EVALUATIONMETHOD,OPTIMIZATIONMETHOD,DECISIONMETHOD,INPUTOUTPUTMETHOD,ETC3MODELBASEISTHEBASEOFANALYZINGPROBLEMANDPROVIDINGREASONABLEDECISIONSCHEMETHEMODELLIBRARYSTORESTHERELATIVELYINDEPENDENTONESTHATCONTAINDESCRIPTIONSOFDECISIONPROBLEMSSUBMODEL,ITSMANAGEMENTSYSTEMCANOPERATEACCORDINGTOTHEUSERSDESCRIPTIONOFTHEPROBLEMTHESUBMODELINTHEMODELLIBRARY,THUSCONSTRUCTINGTHEMODELOFTHEPROBLEM,HASTHEANALYTICALABILITYSOFTWAREMANAGEMENTCAPABILITYTHESEINTEGRATEDMODELSCONSTITUTEDECISIONSUPPORTSHAREDRESOURCESSUCHASMODELLIBRARYCANINCLUDECOSTACCOUNTINGMODEL,BENEFITPROFITANALYSISMODEL,MANAGEMENTCONTROLMODEL,FINANCINGDECISIONMODELANDINVESTMENTDECISIONMODEL,ENTERPRISEECONOMICVALUEEVALUATIONMODELANDSOON2SYSTEMIMPLEMENTATION21SYSTEMMODELTHEREARETWOSYSTEMPATTERNSINDATABASEAPPLICATIONSYSTEMS,NAMELY,C/SMODEANDB/SMODEINVIEWOFTHEHIGHSECURITYREQUIREMENTSOFTHESYSTEM,DATAPROCESSINGLARGE,INTERACTIVE,CONCURRENTUSERSLESS,THEUSEOFFIXEDLOCATION,SOCHOOSETWOLAYERSTRUCTUREOFTHEC/SMODELSYSTEMTOREDUCENETWORKTRAFFICANDIMPROVETHESYSTEMSYSTEMRUNNINGSPEEDCLIENTAPPLICATIONSINTHISMODEAREUSEDINTHESYSTEMTHEPARTOFASERVERTHATINTERACTSWITHDATA,ANDTHESERVERPROGRAMISRESPONSIBLEFORTHEEFFICIENTMANAGEMENTOFTHEDATATHEMAINJOBOFMANAGINGSYSTEMRESOURCESISTOREQUESTCONCURRENTREQUESTSFROMMULTIPLECLIENTSMANAGETHESERESOURCESOPTIMALLYWHENYOUHAVETHESAMERESOURCESONTHESERVERTHESCHEMAOFADATABASEISTHENUMBEROFTABLES,VIEWS,INDEXES,ANDSYNONYMSCOLLECTIONOFLIBRARYOBJECTSSTARSCHEMAISADOPTEDINDATAWAREHOUSEDESIGNINTHEFORMOFARELATIONALMODELTHATCONFORMSTOTHETHIRDPARADIGMTHISMODELITCANINCREASETHESPEEDOFDATAQUERYANDANALYSISSYSTEMDQAS,OPTIMIZINGQUERYPERFORMANCEINTHESTARSCHEMA,THEFACTTABLEFACT,TABLETABLECONTAINSDETAILSABOUTBASICTRANSACTIONS,DIMENSIONTABLESDIMENSIONTABLECONTAINSTEXTDESCRIPTIONSOFSUPPORTITEMSDATABASESERVERADOPTIONMSSQLSERVER2000SYSTEM22ESTABLISHMENTOFDATAWAREHOUSETHEBUSINESSEVENTDATAWAREHOUSEISDIFFERENTFROMTHETRADITIONALONLINETRANSACTIONPROCESSINGSYSTEMITISASUBJECTORIENTED,INTEGRATED,ANDCONSISTENTPROCESSTHATSUPPORTSDECISIONMANAGEMENTPROCESSESACOLLECTIONOFTIMEVARYINGANDPERSISTENTDATAEACHONLINETRANSACTIONPROCESSINGSYSTEMTHESYSTEMSERVESASTHERAWDATASOURCEOFTHEDATAWAREHOUSEANDPROVIDESTHELOGISTICSINTHEFORMOFDOCUMENTATIONTHEGROUPSCOLLECTIONOFDAILYLOGISTICSACTIVITIESINCLUDESWAREHOUSINGORDERS,STORAGEINVOICES,ANDALARGEAMOUNTOFDATA,INFORMATIONANDREPORTS,SUCHASPAYMENTS,TRANSACTIONS,TERMS,ETCTABLE,ANDALARGEAMOUNTOFEXTERNALINFORMATIONANDOTHERDATACREATEDATAWAREHOUSEINFACT,ITISONTHESERVERWHERETHEDATAWAREHOUSEMANAGEMENTSYSTEMISLOCATEDCREATEDATABASEWIZARDZISCREATEDINMSSQLSERVER2000ADATABASECONTAININGSTARSCHEMA,STRUCTURE,ANDDATADATAWAREHOUSEADOPTIONETTEXTRACTION,TRANSFORMATION,ANDTRANSMISSIONHANDLESTHESEINTERFACEFILESANDDOESNOTPRESSTHEMORGANIZE,STOREANDMANAGETHESECUSTOMERDATAINTHESAMEDOMAINDATAWAREHOUSETHEDATAINTHELIBRARYDOESNOTREQUIREREALTIMEINTERACTIONWITHTHEONLINETRANSACTIONPROCESSINGSYSTEMSTEP,SODATAEXTRACTIONCANBETIMED,BUTMULTIPLEDECIMATIONOPERATIONSAREPERFORMEDTHEVALIDITYOFTHEDATAWAREHOUSEINTHETIME,ORDER,SUCCESSANDFAILUREOFEACHOTHERISCRUCIALINDATAEXTRACTION,ITWILLFOCUSONSYSTEMINTEGRATIONONTHEOTHERHAND,ITINTEGRATESINTERCONNECTION,TRANSFORMATION,REPLICATION,SCHEDULINGANDMONITORINGINTOSTANDARDIZATIONUNIFIEDMANAGEMENTTOACCOMMODATETHEDATAWAREHOUSEITSELFORTHEPOSSIBLECHANGESINTHEDATASOURCEMAKETHESYSTEMEASIERTOMANAGEANDMAINTAINMSSQLSERVER2000THEREARETWOMAINTOOLSFORDATAEXTRACTIONANDLOADINGDATAREPLICATIONSYSTEMTECHNOLOGYANDDTSDATA,TRANSFORMATION,SERVICES,DATACONVERSIONSERVICETECHNOLOGYDATAREPLICATIONTECHNOLOGYAPPLIESTOLOGISTICSMANAGEMENTSYSTEMSANDNUMBERSACCORDINGTOTHEWAREHOUSEMANAGEMENTSYSTEM,THEDATABASEMANAGEMENTSYSTEMDBMSUSEDBYTHETWOTHESAMESITUATIONDTSISUSEDINLOGISTICSMANAGEMENTSYSTEMANDDATAWAREHOUSETHEDATABASEMANAGEMENTSYSTEMUSEDBYTHEMANAGEMENTSYSTEMDOESNOTUSE6ATTHESAMETIMEONCEADATAWAREHOUSEISCREATED,ACUBECANBECREATEDBODYDIMENSIONDIMENSIONISABUSINESSUNITOFMEASUREMENTTOACHIEVEACCURACYAVARIETYOFDIFFERENTMETHODSCANBEUSED,SUCHASTHEDIMENSIONTHATREPRESENTSTHEGRANULARITYOFTIMEDAY,MONTH,YEAR,ETCASETOFRELATEDMETRICSCANFORMADIMENSIONYOUCANBUILDAOLAPONLINEANALYSISOFFICEUSINGTHEATTRIBUTESOFTHEBUSINESSDIMENSIONCUBE,THEPROPERTYOFTHESEDIMENSIONSISTHECOORDINATEAXISOFACUBE,CUBEALSOCALLEDCUBEMANAGEMENTOFDATASOURCESANDCREATIONOFPEACEKEEPINGCUBESBUILTTHROUGHMSSQLSERVER2000INTHEANALYSISSERVICESSYSTEMCOMETRUE171,EIGHTH,GUOXINGZHONG,ETCDATAWAREHOUSEBASEDC/SMODEL,FINANCIALLOGISTICSINFORMATIONSYSTEMDESIGN,23DATAMININGANDDATAANALYSISTHEANALYSISMANAGERISAVAILABLEINMSSQLSERVER2000THETOOLCONTAINSTWOFORDATAMININGDMDATAMININGTHEMATHEMATICALMODEL,NAMELYTHEDECISIONTREEMODELANDTHECLUSTERANALYSISMODEL,ISANALYZEDACCORDINGTODEMANDSELECTABLEDIFFERENTMODELSSUCHASTHESYSTEMTOCREATEACUBEBASEDONDECISIONTREE,ADATAMININGMODELISESTABLISHEDTOHELPDECISIONMAKINGPOLICYMAKERSLOOKFORPOTENTIALASSOCIATIONSBETWEENDATAANDDISCOVERELEMENTSTHATHAVEBEENIGNOREDDATAANALYSISTAKESMSSQL,SERVER2000,ANALYSIS,SERVICESPIVOTTABLESERVICE,THATIS,PIVOTTABLESERVICEFORTHEINTERFACE,THROUGHMICROSOFT,EXCELCOMPONENTS,ANDCLIENTAPPLICATIONSANDADOOBJECTSTHEMODELISCONNECTEDTOAMULTIDIMENSIONALCUBE,ANDDATAANALYSISISPERFORMEDTORENDERTHEDATAINFRONTOFTHEUSER24CLIENTDEVELOPMENTCLIENTSOFTWAREDEVELOPMENTWORKEROFDATABASEAPPLICATIONSYSTEMINC/SMODETHEREAREMANYKINDSOFPOWERBUILDER90THATSHOULDBECHOSENASCLIENTSPROGRAMDEVELOPMENTTOOLSINTHEPROCESSOFPROGRAMMING,ITISMAINLYADOPTEDPB90BASEDVIEWBASEDDATAWINDOWTECHNOLOGYBUILDUPWITHMSSQLTHESERVER2000DATAWAREHOUSECORRESPONDSTOTHEODBCDATASOURCEANDUSESDATALIBRARYDESCRIPTIONFILESCANFACILITATESWITCHINGBETWEENINDIVIDUALDATABASECONNECTIONSPBDATAWINDOWOBJECTSAREPROVIDEDSPECIFICALLYFORTHISOPERATION,USINGTHEDATAWINDOWCOMMUNICATINGWITHTHEDATABASEISBOTHEFFICIENTANDCONVENIENTTHROUGHTHEDATAWINDOW,YOUCANDATABASEOPERATIONSCANBECONVENIENTLYHANDLED,NOTONLYFOREACHDATABASETABLELINE,QUERY,INSERT,DELETE,ANDUPDATE,YOUCANSPECIFYINPUTBARSFORTHEDATAFORMAT,OUTPUTFORMATANDDISPLAYSTYLE,ETCALSO,INTHEDATAWINDOW,YOUCANALSOADDVARIOUSOBJECTSTHEDATAWINDOWISTHEDATABASEOPERATORITISALSOANIMPORTANTCOMPONENTOFTHEINTERFACE73CONCLUSIONFACINGTHEFINANCEANDLOGISTICSMANAGEMENTOFUNIVERSITYLOGISTICSGROUP,THEUSEOFMODERNTHEINFORMATIONTECHNOLOGYISUSEDTOEMBEDTHEACCOUNTINGINFORMATIONSYSTEMINTOTHELOGISTICSBUSINESSINTHEPROCESS,ABUSINESSEVENTDRIVENMODELBASEDONC/SMODELISDESIGNEDFINANCIALANDLOGISTICSMANAGEMENTINTEGRATEDINFORMATIONSYSTEM,SOTHATTHELOGISTICSBUSINESSPROCESSINGTHESYSTEMANDTHEACCOUNTINGINFORMATI