CIM与SVG在智能电网调度系统中的集成应用

需积分: 20 43 下载量 186 浏览量 更新于2024-08-09 收藏 3.44MB PDF 举报
"CIM模型与SVG的结合应用-hy951180a_datasheet" CIM(Common Information Model)模型是一种标准化的电力系统建模方法,它使用面向对象的方式来描述电力系统的设备和它们之间的连接关系。在CIM模型中,每个设备都是一个对象,拥有特定的属性和行为,例如设备类型、状态等。设备通过端点连接到其他设备,形成电网的拓扑结构。例如,CIM模型中的稷山站2001.B刀闸有两个端点,这些端点与其他设备相连,定义了电网的连接路径。然而,CIM模型不包含设备的显示细节,如大小、坐标或连接线,这在需要可视化表示的场景中是不足的。 SVG(Scalable Vector Graphics)是一种用于描绘图形的XML语言,特别适合于绘制具有复杂形状和精确位置的图形。在电力系统中,SVG可以用来提供设备的图形化表示,包括位置信息、显示样式等。例如,SVG描述了稷山站2001.B刀闸的具体位置、形状和线条细节,使得用户能直观地看到设备的布局。 在智能电网调度系统中,CIM与SVG的结合应用至关重要。CIM提供了电网的逻辑结构和运行状态,而SVG则提供了这些信息的视觉呈现。这种结合可以解决传统电网系统中存在的信息孤岛问题,通过统一的标准提高信息交换的效率,减少数据冗余,简化数据库设计,并便于进行电网的分析和控制。 硕士论文作者徐世强在IEC61970标准背景下,设计了一个高效、模块化的接口平台,实现了CIM模型的建模与解析。他比较了DOM和SAX两种XML解析方式,选择了更适合项目需求的解析方法来处理CIM/XML文件。此外,他还建立了一个将CIM抽象模型映射到关系数据库的机制,遵循数据库设计的第三范式,确保数据的规范化。论文还涉及了拓扑关系的存储,结合SVG图形数据,提出了验证和存储电网拓扑关系的方法。 CIM模型和SVG技术在电力系统自动化中的结合使用,不仅提高了数据交换的效率,还增强了电网的可视化能力,对于智能电网调度系统的建设与优化起到了关键作用。通过深入研究CIM和SVG的特性,以及它们在实际项目中的应用,可以为未来电力系统的信息化发展提供有力的技术支持。

select lot_hs.lot_id as lot_id,lot_type,lot_hs.mainpd_id, created_time,COMPLETE_TIME, value(bank.banktime,0) as banktime , round ( ( 1.00*(days(COMPLETE_TIME)-days(created_time)) + (hour(COMPLETE_TIME)-hour(created_time))*1.00/24 + (minute(COMPLETE_TIME)-minute(created_time))*1.00/24/60 + (second(COMPLETE_TIME)-second(created_time))1.00/24/60/60) - value(bank.banktime,0),3) as use_days, customer_id, coalesce(cc.cust_id_define,lot_hs.customer_id) as cust_id2, cc.cycletime_target as ct_target, date,layer, round(count() over(partition by coalesce(cc.cust_id_define,lot_hs.customer_id),cc.cycletime_target)*0.9,0) cnt, row_number() over(partition by coalesce(cc.cust_id_define,lot_hs.customer_id),cc.cycletime_target order by ( ( days(COMPLETE_TIME)-days(created_time) + (hour(COMPLETE_TIME)-hour(created_time))*1.00/24 + (minute(COMPLETE_TIME)-minute(created_time))*1.00/24/60 + (second(COMPLETE_TIME)-second(created_time))*1.00/24/60/60) - value(bank.banktime,0))/layer) id From (select date(a.claim_time) as date, a.lot_id, a.lot_type,a.mainpd_id,a.prodspec_id,a.custprod_id, case when(date(b.created_time) <= '2009-01-05') then b.created_time + 21 days else b.created_time end as created_time, CASE WHEN A.CUST_id in ('MCA','NPA','SET') THEN a.COMPLETE_TIME ELSE a.COMPLETE_TIME END COMPLETE_TIME, a.cust_id as customer_id, a.ope_category, c.layer From f3rpt.F3_TB_DAILY_FABOUT a, f3rpt.fvlot b, (select mainpd_id, sum(masks)layer from f3rpt.ASMCRPT_VW_MAINPD_MASKS_ALL group by mainpd_id) as c, (select * from (select lot_id, max(claim_time)claim_time, count(case when(ope_category='Ship')then lot_id else null end) as LS, count(case when(ope_category='Unship') then lot_id else null end) as LUS from f3rpt.F3_TB_DAILY_FABOUT where substr(lot_id,1,2) not in('CA','CW','ES','E0','EM') and lot_type = 'Production' AND LOT_ID NOT LIKE 'H%' and substr(lot_id,7,4)='.00F' and ope_category in ('Ship','Unship') and year(claim_time) = year(current date - 1 days) and month(claim_time) = month(current date - 1 days) group by lot_id) as a where LS - LUS > 0 ) as lot Where a.lot_id = b.lot_id and b.mainpd_id = c.mainpd_id and a.lot_id = lot.LOT_ID and a.claim_time = lot.claim_time and a.ope_category = 'Ship' and a.cust_id in ('SM','BOE','GSC','NPA','GTA') ) as lot_hs left outer join (select lot_id,max(bankin_time) banktime from f3rpt.asmc_dpm where bankin_time>0 group by lot_id) bank on (lot_hs.lot_id = bank.lot_id) left join f3cim.f3cim_cfg_cust_rule cc on case when lot_hs.customer_id='WXM' THEN 'WII'||SUBSTR(lot_hs.mainpd_id,6,1) else lot_hs.customer_id end = cc.cust_id and locate(cc.mainpd_id,lot_hs.mainpd_id)>0 and locate(cc.prodspec_id,lot_hs.prodspec_id)>0 and locate(cc.custprod_id_45,substr(lot_hs.custprod_id,3,3))>0 where lot_hs.ope_category = 'Ship' ;以上sql如何优化

2023-06-07 上传