PI數(shù)據(jù)庫大數(shù)據(jù)和商務(wù)智能

1、pi數(shù)據(jù)庫大數(shù)據(jù)和商務(wù)智能熊蓓麗osisoft大數(shù)據(jù)和商務(wù)智能-pi integrators 組件議程? pi與第三方應(yīng)用系統(tǒng)傳統(tǒng)集成方式? 新的業(yè)務(wù)背景? pi integrator for business analytics/sap hana? 商務(wù)模式? 客戶案例? 產(chǎn)品演示? 技術(shù)路線2pi與第三方應(yīng)用系統(tǒng)傳統(tǒng)集成方式3pi system access 讀取pi數(shù)據(jù)開發(fā)平臺新的業(yè)務(wù)背景5轉(zhuǎn)換數(shù)據(jù)的價值ge01_dt 7><409510395_wind speed qi-109 ge01_dt cooling fan-711.feed rate1-8.net volumec

2、oal motor load02f100.tot.ev03lba32ct001-2dc.sj.itload.pwrti-145 fr2001ti-178 ge04_osft9001 ft9001fr5001 af_noisedc.sj.pue ti-102 dc.zero dy-108 dc.sj.c1.z3.r3.pdu1.pf ge01_a_dtfic-144 02f100 fasttagfi-151 0_eng_aux_stsge05_energy c1:14at5ac03.air flow feedbin.cmtboiler cold reheat pressureb737_fg117

3、 dc.timeloadd-110.tank pressure.pvge04_dt qi-121 ge03_v_windc.rk07r dc.srv06r ge04_energy ti-121 ft9001fac.oak.power-kh-val.pvdy-131dc.sj.puefic1001.cge02_otge01_dt02f102.1hravg bgt001 pi-111 facility_outputdm-05:bw.r dc.sj.c1.z1.r1.rk06.s2.o03.pwrqi-111 finalproductbin.on94:grdidx.prodid boiler-209

4、.fuel gas flow fic1001.c fr50011-8.net volume coal motor load 02f100.tot.ev 3lba32ct001-2fi-101 bf5e1d1d-39c9-4b5b-b3d3-c2ce05fa3a26 dm-05:bw.r at<4010_clr_final_out_b_tmp f506_e990 339511775_clear sky global horiz ge01_dtfi-111ge01_con alarmtest.input.float32.1d-110.tank pressure.pv boiler feed

5、pump #1boiler-209.fuel gas flow dc.srv01r 94:grdidx.tr igger ac09.power<403511195_wind speeddc.c2z1.pwr.ripple ge01_a_dt1-16.net volume cb1992_ms 0_cmp_flow_total ge02_energyfeedbin.cmt dc.zone1.numberdailytriggerfrqprbcost_eralarmtest.input.float32.1 aqua2-ti-201.pv dc.sj.siterealtimeitload.pwrf

6、t9001ft9001dc.srv01r boiler-125.fuel gas volumeanacortes refinery.alkylation.asset problems b210_fg005.kpiexcursion1 | 數(shù)據(jù)ft9001fasttagat<401生產(chǎn)裝置draft pressure: -0.5 wc stack temp: 316 °f oxygen: 2.5%firebox temp: 860 °f outlet temp: 8<40 °f cold oil velocity: 6 ft/sec天氣情況relativ

7、e humidity: 34% current temp: 85 °f high: 92 °flow: 57 °fwind: 8 mph/n2 | 信息 3 | 智能$總產(chǎn)量能源效率停機(jī)時間實時決策支持 業(yè)務(wù)/運(yùn)營智能6itassets assets assetsscada dcsplchmisensors gatewaysot itassets assets assetsscada dcsplchmisensors gatewaysot此刻和未來的基礎(chǔ)設(shè)施78工廠運(yùn)營? 設(shè)備數(shù)目相對少? 多樣化數(shù)據(jù)類型? optimization? 數(shù)據(jù)多儲存在本地分部署的資產(chǎn)

8、監(jiān)測? 設(shè)備數(shù)目較多? 數(shù)據(jù)類同 / 離散? 遠(yuǎn)程監(jiān)測? 企業(yè) / 云端internet of things and m2m ? 資產(chǎn)、設(shè)備數(shù)目龐大? 數(shù)據(jù)類型相對簡單? 分析 / 大數(shù)據(jù)? 多位于云端hybrid / cloud environment osisoft focus實時決策架構(gòu)支持回顧歷史數(shù)據(jù) &amp; 預(yù)測分析pi數(shù)據(jù)用于: 報表, 分析, 商業(yè)智能pi 數(shù)據(jù)用于: 過程監(jiān)測, 態(tài)勢感知, 工作流程企業(yè)數(shù)據(jù)基礎(chǔ)設(shè)施架構(gòu)gis 擔(dān)保crm合同市場財務(wù)天氣信息omsemsmescmms erp進(jìn)化中的it數(shù)據(jù)架構(gòu)1010大數(shù)據(jù)時代的高期望1185%64% 的大企業(yè)計劃實

9、施大數(shù)據(jù)項目。85%的項目會失敗/2014/04/the-sexiest-job-of-the-21st-century-is-tedious-and-that-needs-to-change/失敗成功數(shù)據(jù)分析數(shù)據(jù)準(zhǔn)備對數(shù)據(jù)進(jìn)行“清理和準(zhǔn)備”的任務(wù)，占用項目 50-80% 的時間和成本。大數(shù)據(jù)項目的困擾1. 數(shù)據(jù)校準(zhǔn)2. 大數(shù)據(jù)量&amp;可擴(kuò)展性3. 數(shù)據(jù)關(guān)聯(lián)性（context）4. 事態(tài)隨時間變化而變化5. 數(shù)據(jù)管理6. 安全7. 企業(yè)部門間的數(shù)據(jù)交流狀態(tài)這些都需要時間和$12客戶瓶頸：數(shù)據(jù)梳理 (理解數(shù)據(jù)&amp;合作)13數(shù)據(jù)分析師想要的 數(shù)

10、據(jù)庫中的數(shù)據(jù)代號 連云港一號廠二車間設(shè)備a的溫度lg_101101_314數(shù)據(jù)校準(zhǔn)風(fēng)機(jī)1號速度扭矩軸承溫度機(jī)油溫度制造商上次維護(hù)時間風(fēng)機(jī)2號速度扭矩軸承溫度機(jī)油溫度器具因素制造商上次維護(hù)時間時間vestassiemensjune 20, 2013february 5, 2015通訊中斷其他測量數(shù)據(jù)測量時間不平均分布量程外傳感器測量有誤不同的數(shù)據(jù)采集開始時間? 壓強(qiáng)? 流量? 溫度? 液位? ? ? 振動? 油量分析? 電機(jī)電流? 溫度記錄/熱譜分析? ? 15客戶瓶頸：數(shù)據(jù)結(jié)構(gòu) (以資產(chǎn)為中心組織數(shù)據(jù))16150億次計算，比較550萬個批次（batch-to-batch comparisons

11、）客戶瓶頸：數(shù)據(jù)計算 (以“事件/批次”為中心組織數(shù)據(jù))生產(chǎn)批次很多客戶在開始前就已經(jīng)放棄?17pi integrator for business analytics1819應(yīng)對數(shù)據(jù)洪流pi asset framework如何能應(yīng)用于多個站點(diǎn)/場站?保證數(shù)據(jù)分析的前后一致性?為不同崗位的人提供相應(yīng)所需數(shù)據(jù)?bge003 fi-111 02t100af_flow3 02:t103 at<401acedemo.unit1.output ti-178b352_w778 0_cmp_svlv_pct02f104 cd:f161 ge04_osasset1.problems qi-122 fi-

12、15194:bw.r ti-101 f723_e889369512185-tempcompressor-439.feed ratedc.ch.dce fic-172:210 fi-121 af_flow30_eng_mode_sts ge03_qdy-131:166 ge01_tdboiler-334.feed ratege01_dt <409510395_wind speed qi-109 ge01_dtcooling fan-711.feed rate1-8.net volume03lba32ct001-2dc.sj.itload.pwrti-145 fr2001ti-178 ge0

13、4_osft9001 ft9001fr5001 af_noisedc.sj.pue ti-102 dc.zero dy-108 dc.sj.c1.z3.r3.pdu1.pf ge01_a_dtge04_status02:f101.c tic-181fic-14402f100 fasttagfi-151 0_eng_aux_stsaqua2-si005.pv ge02_energy0_eng_mode_stsfi-151 02t103.q dc.z1r0_cmp_hdr_suc_prsge05_energy c1:14at5 ac03.air flow feedbin.cmt boiler co

14、ld reheat pressureb737_fg117 dc.timeloadd-110.tank pressure.pvge04_dt qi-121 ge03_v_windc.rk07r dc.srv06r ge04_energy ti-121 ft9001fac.oak.power-kh-val.pvdy-131dc.sj.puefic1001.c ge02_otge01_dt02f102.1hravgbgt001pi-111facility_outputdm-05:bw.r dc.sj.c1.z1.r1.rk06.s2.o03.pwrqi-111 finalproductbin.on

15、94:grdidx.prodidboiler-209.fuel gas flow fic1001.c fr5001ge01_a_dtfic1001.c02:f101.cfr2001 tic-121asoat<401dc.srv01rti-178 asset1_output active metersge01_a_dt aso dy-101 02:f101.caf_noise pi-115 dm-05:bw.rfi-101 80-13.net volumefi-101 bf5e1d1d-39c9-4b5b-b3d3-c2ce05fa3a26 dm-05:bw.r at<4010_cl

16、r_final_out_b_tmp f506_e990 339511775_clear sky global horiz ge01_dtfi-111% co2ge05_estge01_con alarmtest.input.float32.14-36.net volume ac04.air flow02t100 03lbb02ct001-2dc.ny.actual.pwr.day.totalarmtest.input.float32.10364511575-ac power80-5.net volume ge01_a_dt45-2.net volumeboiler-209.fuel gas f

17、low dc.srv01r 94:grdidx.trigger ac09.power<403511195_wind speeddc.c2z1.pwr.ripple ge01_a_dtaf_noise1-16.net volume cb1992_ms 0_cmp_flow_total ge02_energyft9001fasttagfeedbin.cmt dc.zone1.numberdailytriggerfrqprbcost_erft9001alarmtest.input.float32.1 aqua2-ti-201.pv dc.sj.siterealtimeitload.pwrft9

18、001ft9001dc.srv01r boiler-125.fuel gas volume1-13.net volume b045_fg978at<401anacortes refinery.alkylation.asset problems b210_fg005.kpiexcursiond-110.tank pressure.pv boiler feed pump #1風(fēng)機(jī) 7風(fēng)速: 200 °f煙道氣體出口溫度: 700°f 門道1 發(fā)動機(jī)電流: 6.3 a門道2 發(fā)動機(jī)電流: 6.2 a卡車 1狀態(tài)：運(yùn)營速度: 5 mph油溫: 200 °f蒸發(fā)機(jī) 1

19、 操作 1傳導(dǎo)性流入: <40%流入量 3 加侖/秒流入溫度: 120 華氏度蒸發(fā)機(jī) 1 操作 2傳導(dǎo)性流入: 43%流入量 3.8 加侖/秒流入溫度: 118 華氏度不斷進(jìn)化的數(shù)據(jù)目標(biāo): pi integrator for business analytics監(jiān)測實時狀態(tài)感知對標(biāo)企業(yè)級性能對比過程優(yōu)化對全局資產(chǎn)實時和歷史分析系統(tǒng)優(yōu)化綜合數(shù)據(jù)集實現(xiàn)系統(tǒng)智能實時決策支持 (ot)企業(yè)分析bi editionbig data edition*data warehouse edition*coming soon, stay tuned!and many morepi coresight pi

20、processbookpi datalink20pi integrator for business analytics21篩選補(bǔ)充 建模轉(zhuǎn)換數(shù)據(jù)質(zhì)量模型標(biāo)準(zhǔn)化數(shù)據(jù)兼容性數(shù)據(jù)聚合商業(yè)智能 &amp; 可視化分析數(shù)據(jù)倉庫大數(shù)據(jù)統(tǒng)籌資產(chǎn)及與特定資產(chǎn)相關(guān)聯(lián)的時間序列數(shù)據(jù)智能分析與優(yōu)化運(yùn)營相結(jié)合的基礎(chǔ)設(shè)施架構(gòu)22數(shù)據(jù)展板 &amp; 運(yùn)營分析移動端商務(wù)智能bimetadata/系統(tǒng)集成機(jī)器學(xué)習(xí)/預(yù)測分析地理信息分析大數(shù)據(jù)/hadoop 分析/bi/ei 可視化分析sas數(shù)據(jù)倉庫ot23支持哪些系統(tǒng)？pi integrator for business analytics: 加速，分析，

21、行動pi integrator for business analyticsbusiness intelligence （bi）商務(wù)智能版本 所有支持odbc的bi工具tableau spotfiresasmsft bipi server數(shù)據(jù)記錄層面可視化 &amp; 分析數(shù)據(jù)準(zhǔn)備和集成層面pi integrator for business analyticsbusiness intelligence 版本enterprise data warehouse architecture25pi serverpi integrator for badata warehouse 數(shù)據(jù)倉庫版本

22、tableau spotfire數(shù)據(jù)記錄層面可視化&amp;分析數(shù)據(jù)準(zhǔn)備和集成層面oracle dw, sql server, teradata數(shù)據(jù)倉庫/ 數(shù)據(jù)中心/ 數(shù)據(jù)湖定制程序sas msft bi定制或第三方數(shù)據(jù)管理和etleamsalescrmerp hr hadoop26business intelligence applicationsodbc*pi systemsqlafda程序交互流向1) web ui data designer(網(wǎng)頁版的數(shù)據(jù)配置工具）a) 用戶在web ui data designer中，通過pi integrator服務(wù)，創(chuàng)建pi6><

23、;#00aa00'>viewb) <#00aa00'>view 定義/配置保存于pi系統(tǒng)中（asset framework）c) 如需要，<#00aa00'>view數(shù)據(jù)可被保存于af管理的sql數(shù)據(jù)庫中d) pi integrator服務(wù)用于管理 pi<#00aa00'>view的更新2) 第三方通過odbc層向pi <#00aa00'>view提取數(shù)據(jù)pi <#00aa00'>viewweb ui data designerpi integrator for business

24、analytics1a)1b)1c)2)2)pi integrator service1d)sap產(chǎn)品領(lǐng)域27maintenance, production planning, quality (rlink)regional seminars 2015sap 應(yīng)用 &amp; 解決方案架構(gòu)28eamsales數(shù)據(jù)集合(aggregation)pi serversap hana iot adapter by osisoft數(shù)據(jù)記錄層面可視，分析&amp;商業(yè)流程應(yīng)用數(shù)據(jù)準(zhǔn)備和集成層面sap hana企業(yè)分析和應(yīng)用層面sap hana enterprise information

25、management and data provisioning agent合作伙伴應(yīng)用pi integrator frameworkcrmerp hr sap bwsap lob 解決方案&amp; 應(yīng)用lumira gisbobjhana sdaaggregation pi serverdata archive microsoft sqlpi asset framework (af)應(yīng)用交互流程web ui data designera) 用戶通過pi integrator framework，在web ui shape designer上創(chuàng)建pi <#00aa00'

26、>view。b) pi <#00aa00'>view 的定義和配置儲存在pi系統(tǒng)中(af). c) 如需要，pi <#00aa00'>view也可保存在af管理的sql服務(wù)器中.d) hana用戶通過基于hana sda的hana studio 以及（osisoft開發(fā)的）sap hana iot adapter by osisoft來編輯virtual tables（虛擬表格）a) sap hana iot adapter by osisoft 通過在pi integrator framework中的rest層，控制對pi <#00aa00

27、'>view的訪問b) iot adapter 通過pi jdbc driver從在sql服務(wù)器中的pi <#00aa00'>view處調(diào)取數(shù)據(jù)sap data provisioning agentlinuxlinux 或windowssap hana iot adapter by osisoftsap hana hana studiopi integrator frameworkweb ui shape designerwindows由sap銷售 由osisoft銷售核心版本包含由osisoft開發(fā)的sap hana （無費(fèi)用）windows商務(wù)模式30pi

28、 integrator for business analyticsbi editiondata warehouse editionsap hana editionopen connectivity （開元連接性）-客戶端的 odbc x xnative connectivity （和特定系統(tǒng)的定制連接性）-sql server x-flat file x-sap hana xdata flow 數(shù)據(jù)流-bulk load &amp; scheduled updates x x x功能-創(chuàng)建 asset views x x x-通過event frames 過濾數(shù)據(jù) x x x-清理，

29、集成，塑造，傳送 x x x-automatic dimensionally modeled data x x xlaunch pricingbi版本launch pricingpi integrator for business analyticsbi editiondata warehouse editionsap hana editionopen connectivity （開元連接性）-客戶端的 odbc x xnative connectivity （和特定系統(tǒng)的定制連接性）-sql server x-flat file x-sap hana xdata flow 數(shù)據(jù)流-bulk

30、load &amp; scheduled updates x x x功能-創(chuàng)建 asset views x x x-通過event frames 過濾數(shù)據(jù) x x x-清理，集成，塑造，傳送 x x x-automatic dimensionally modeled data x x x數(shù)據(jù)倉庫版本pi integrator for business analyticsbi editiondata warehouse editionsap hana editionopen connectivity （開元連接性）-客戶端的 odbc x xnative connectivity（和特定

31、系統(tǒng)的定制連接性）-sql server x-flat file x-sap hana xdata flow數(shù)據(jù)流-bulk load &amp; scheduled updates x x x功能-創(chuàng)建 asset views x x x-通過event frames 過濾數(shù)據(jù) x x x-清理，集成，塑造，傳送 x x x-automatic dimensionally modeled data x x xhana版本商務(wù)模式34pi integrator for business analyticsbi editiondata warehouse editionsap hana

32、editionpi views-access data via odbc x xnative connections-sql server x-flat file x-sap hana xdata flow-by calendar times x x xcommon features-create asset views x x x-cleanse and filter data using event frames x x x-automatic dimensionally modeled data x x xpi integrator for business analyticsoutpu

33、t data streamsbi editiondatawarehouse editionsap hanaedition1000 talk - -2500 to - -5000 - your -10000 - osisoft sold by20000 - account sap 50000 - manager -100000 - today -客戶案例3536先期體驗用戶merckregeneron（制藥）edf-re（風(fēng)電）cemexalcoa grp （制造）freeport mcmoran（礦業(yè)）devon energynoble energynov （能源）巴斯福（化工）南方電網(wǎng)sdg&amp;efreeport mcmoran 礦業(yè)公司 (成功案例）37freeport （礦業(yè)）it戰(zhàn)略架構(gòu)pi 系統(tǒng)? 實時，時間序列數(shù)據(jù)基礎(chǔ)架構(gòu)? 實時決策? “流”分析（streaming analytics）hadoop ? 大數(shù)據(jù)? 深挖分析? 預(yù)測模型teradata? 關(guān)系型 / 數(shù)據(jù)倉庫? 集成離散的數(shù)據(jù)源? 報表和數(shù)據(jù)展板數(shù)據(jù)清理和準(zhǔn)備工作占用50-80% 的時間和成本/2014/04/the-sexiest-job-o