弗林特山资源：AVEVA™ PI System™ 和图形数据库.pdf

1、AVEVA PI System and Graph DatabasesTyler SontagIT/OT Supervisor Kevin BrashearsSenior Software Engineer3 PI World 2020 presentationFHR BackgroundFHR and Graph Graph databases are a class of NoSQL databases thatleverage flexible data-modeling with an emphasis on the relationship between entities.Exam

2、ples use cases:Asset Management information Work orders Purchase orders Anomaly investigation systems Financial systemsFHR AVEVA StatisticsPISCES(PI System Change Events Service).NET Windows application 13 AF Servers 11 PI Servers Use the“eventing”provided by the AF SDK Real-time processing Process

3、the metadata/contextual data changes(AF SDK to JSON)and send to FHRs Event Bus Note:not sending time-series data to Graph,only metadata Template change will reprocess its derived Ingest(custom code)into FHRs Graph databaseAF SDK to JSONAFElementTemplateAFAttributereturn new Dictionary()categories,Id

4、NameDictionary(attribute.Categories),configString,string.IsNullOrWhiteSpace(attribute.ConfigString)?null:attribute.ConfigString,database,IdNameDictionary(attribute.Database),dataReference,attribute.DataReferencePlugIn?.Name?None,description,string.IsNullOrWhiteSpace(attribute.Description)?null:attri

5、bute.Description,displayDigits,attribute.DisplayDigits,element,IdNameDictionary(attribute.Element),enumerationSet,enumerationSet,id,attribute.ID.ToString(),isConfigurationItem,attribute.IsConfigurationItem,isExcluded,attribute.IsExcluded,isHidden,attribute.IsHidden,name,attribute.Name,parent,attribu

6、te.Parent=null?null:new Dictionary()id,attribute.Parent.ID.ToString(),name,attribute.Parent.Name,piPoint,pointResolved?new Dictionary()id,pointId,name,pointName,serverId,pointServerId,server,pointServerName,:null ,server,IdNameDictionary(attribute.PISystem),template,attribute.Template=null?null:new