基于oracle的过程数据集成分析与应用

《基于oracle的过程数据集成分析与应用》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、摘要据集成平台中的Oracle数据库系统内存储实时数据，平台必须具有压缩功能模块，因此本文提出了基于Oracle数据库的逻辑压缩和物理压缩存储，且对这两种压缩方式采用Oracle数据库内部语言编程实现。(6)对建立好的数据平台，最后给出了在石化企业中的应用场景，主要是帮助化工企业进行软测量技术的应用，以及将集成后的数据对接到Excel中给以展示，并可为AspenOSE等化工应用软件提供数据源支持。关键字：Oracle制造执行系统数据集成实时数据库关系数据库数据压缩硕士学位论文ABSTRACTAlongwiththepromotionofmodement

2、erprisemanagementtechnology,computertechnologyandnetworktechnology,comprehensiveautomationandthecombinationofmanagementandcontrollingareveryimportantdevelopingdirectionincontinuousindustry(suchaSpetrochemicals)．Andmanufacturingexecutionsystem(MES)isanimportantcomponentofthedirec

3、tion．AsthefoundationofMESsystem，dataintegrationpossessesacertainvalueintheconstructionofinformationtoflowindustryenterprises．Howtoachievethedataintegrationintheenvironmentofheterogeneousnetwork，heterogeneousoperatingsystem，andheterogeneousdatabaseisverydifficult．Throughmainlyfoc

4、usedOllthecontinuousprocessindustry—thepetrochemicalindustry,basedontheprocessdateofreal-timedataandlaboratoryanalyzeddata,andcombinedtheprojectofControlEngineeringCenterofNanjingUniversityofTechnologyinalagerprocessenterprise，thispaperexploredtheconstructionofdataintegrationpla

5、tformintheenvironmentofheterogeneousdatabase，andtoldoftheapplicationscenesofthedataplatform．Thedirectionofthispaperfollowedandthemaincontentofthispaperfinishedarethefollowing：(1)Afterbriefstatementofthesubjectbackgroundandthesignificance，theresearchingcoRrseofCIPS(ComputerIntegr

6、atedProcessSystem)andMESwillbeoutlined．Basedonthepresentedtheory,wewillknowthatdataintegrationisthefoundationofMESsystem，SOthetheoreticalbasisispresented．(2)Thenthetheoryoftwodifferenttypedatabasesystems(real—timedatabasesystemandrelationaldatabasesystem)isdiscussedbriefly,appli

7、cationsofrelationaldatabaseOracleandreal-timedatabasePHDisalsointroduced．Finally,thecomparisonoftwodifferenttypedatabasesystemandfeasibilityanalysisofdataintegrationbyOracledatabasesystemispresented．(3)IntheusingofMicrosoftVisualStudio．NETdevelopmentenvironment，dataQbtainingsoft

8、wareisimplementedforintegratingdatafromPI-IDdat