CIMS信息集成中的数据完整性及其实现2

:100021220(2002)1021222204:2000212215:863(:863251189()092).:,,CIMS,BPR.CIMS1221(,210013)2(,210016):CIMS,CIMS,,,DBMS,CIMS.:;;CIMS;;:TP311.52:A1CIMSCIMS,:().:,,.CIMS(MRPIIöERPPDMCADöCAM),,.CIMS,,.,CIMSCIMS.1CIMSCIMS,CIMS.,,.,,,.,CIMS.1CIMS,,.22.1CIMS(CADöCAMPDMMRPIIöERP),,,,,.,,,..,,.,,,.,,2310200210MINI-MICROSYSTEMVol123No110Oct.2002©1995-2004TsinghuaTongfangOpticalDiscCo.,Ltd.Allrightsreserved.DBMS,.2.2DBMS:DBMS.DBMSDBMS,.().,.(),,,,.2.3CIMS,CIMS,:.CIMS,CIMS,CIMS,CIMS.CIMS,..,,,..,..DBMSOS,(),(),,,.3,.,DBMS,2.2,DBMS,:DBMS.2.2DBMS.DBMS,DBMS.,DBMS;DBMS,,;,,,DBMS,DBMS..()DBMS(,).,DBMS:.(SQL),322110:CIMS©1995-2004TsinghuaTongfangOpticalDiscCo.,Ltd.Allrightsreserved.,,;DBMSACID(),,,,DBMSDBMS,,,DBMS.4CIMS8632CIMS,,.4.1,CIMS.CIMS,,:CADöCAPP,PDM,MRPII(ERP).CADöCAPP,PDMMRPIIDBMS,DBMS(MicrosoftSQLServer).4.2,CIMS,:CAD,3CIMS(BOM),PDMMRPII;PDM;BOMMRPIIMRP(),MRPII;,MRPIIPDM(MRPIIPDM),PDMMRPII.3(:).4.3,,,.2.22.3,3CIMS,4.4CIMS4,PowerBuilderSQLServer(),,,.5CIMS,,DBMS,CIMS.,CIMS,.CIMS42212002©1995-2004TsinghuaTongfangOpticalDiscCo.,Ltd.Allrightsreserved.,,CIMSDBMS.1RogersS.Pressman.Softwareengineering2apractitioner’sap2proachM.PrenticeHall,19992VictoriaStavridou.IntegrationinsoftwareintensivesystemsJ.TheJournalofSystemsandSoftware,1999.48:911043XueJin2song,SongHong.ConceptualdesignofCIMSM.Bei2jing:MachineIndustryPress.1997(,.CIMSM.:,1997)4BaoJu2wuetal.CasestudiesofcomputersystemsintegrationM.Bejing:BejingTechnologicalUniversityPress.1999(.M.:,1999)DataIntegrityofCIMSInformationIntegrationanditsImplementationSHENYan2sen,DINGQiu2lin,WANGBing2yang(ComputerApplicationInstituteofNanjingUniversityofAernautics&Astronautics,Nanjing210016,China)AbstractFirstly,throughthediscussionofrelationbetweenCIMSsystemintegration,informationintegrationanddatain2tegrity,theimportanceofdataintegrityinCIMSisemphasized.Then,theconceptandconnotationsofdataintegrity,hierar2chyofdataintegrity,andotherrelativeproblemsarealsodiscussed.Afterthat,wediscussandpresentimplementingmecha2nismsfordataintegrityofinformationsystemsbasedonDBMS.Intheend,theparadigmofdataintegritydesignandimple2mentationofoneCIMSsystemispresented.Keywordsinformationintegration;systemsintegration;CIMS;dataintegrity;dataconsistency,20021146:http:ööncmt02.cs.tsinghua.edu.cn:CSCW:1.,2.6000,A4,3.()4.:,:[e-mail]::[phone],13501202297:[e-mail]@mail.tsinghua.edu.cn522110:CIMS©1995-2004TsinghuaTongfangOpticalDiscCo.,Ltd.Allrightsreserved.