450 likes | 754 Views
High Performance Hyper – Historian. G64-304. Dave Oravetz, US Habib Rehman, Australia Carl Harper, UK Andre Scherpenzeel, UK. Background. To provide not just a ‘data logger’, but a ‘data historian’ Provide easy integration of data historian with other applications
E N D
High Performance Hyper – Historian G64-304 DaveOravetz, US Habib Rehman, Australia Carl Harper, UK • Andre Scherpenzeel, UK ICONICS 2008 Worldwide Customer Summit Boston, MA
Background • To provide not just a ‘data logger’, but a ‘data historian’ • Provide easy integration of data historian with other applications • Provide competitive historian for large projects • Compete with the specialist products ICONICS 2008 Worldwide Customer Summit – Boston, MA, April, 2008
Design Goals for User Benefits • High Performance • Large tag quantities at high rates • Small ‘data value’ footprint • Efficient long duration storage • 64 bit & .NET Technology • Extendable platform allowing for future growth ICONICS 2008 Worldwide Customer Summit – Boston, MA, April, 2008
Design Goals for User Benefits • Easier data access/interaction • OPC UA for ICONICS products • API for custom applications • SQL interface • Integrate into database systems • Query from any OLE-DB client ICONICS 2008 Worldwide Customer Summit – Boston, MA, April, 2008
Competitive Products • ICONICS - Hyper Historian • Competition • GE – Proficy • Rockwell – Factory Talk • OSI – Echo Data Historian • AspenTech – Info Plus • Wonderware – Historian 9 • Simatic – IT Historian ICONICS 2008 Worldwide Customer Summit – Boston, MA, April, 2008
Hyper Historian Editions ICONICS 2008 Worldwide Customer Summit – Boston, MA
SCADA Competitors • Hyper Historian Provides • Equal or better throughput performance • Equal or better maximum tag counts • Extensive client connectivity features • OPC UA, OPC HDA, OLE-DB, Excel, SQL Server, native API, ICONICS Native • Extensive use of recent technologies • Vista 64/2008 Server 64/.NET ICONICS 2008 Worldwide Customer Summit – Boston, MA, April, 2008
Data Historian Competitors • Hyper Historian Provides • Extensive client connectivity features • OPC UA, OPC HDA, OLE-DB, Excel, SQL Server, native API, ICONICS Native • Extensive use of recent technologies • Vista 64/2008 Server 64/.NET ICONICS 2008 Worldwide Customer Summit – Boston, MA, April, 2008
Comparison Diagram • Comparison ICONICS 2008 Worldwide Customer Summit – Boston, MA, April, 2008
Hyper-Historian Key Benefits Efficient High Performance High Compression Reliable Redundancy Store and Forward Data Accessibility TrendWorX64 Viewer SQL Query Interface Data Editing Easy to Configure Remote Configure-ability Web-based Online Flexible, Automated Archiving Scalable Flexible Architecture 10
Hyper-Historian Architecture Hyper-Historian Components Data Collector Data Logger Workbench Configuration 3D Chart Control SQL Query Interface 12
ICONICS Workbench BizViz Solutions Third Party Solutions Operator Controls System Configuration & Administration • Reports • Productivity Analytics • Enterprise Bridging • Custom Portals • Mobile & Wireless Custom Applications • TrendWorX 2D & 3D Charts • Manually Entered Data • Operator Comments • Configuration • Archive Management Standard SQL Query OPC-UA Real-time Data Logger Auto Archiving Historical Data Storage Real-time Data SQL 2005 SQL 2008 On Event Configuration Database External Storage Disk RAM Remote Data Collectors Remote Data Collectors Store & Forward . . . Store & Forward • OPC DA • OPC UA • OPC XML DA • SNMP • BACnet • Databases
Hyper-Historian Collector Collects Data From: OPC DA Servers OPC XML DA Servers OPC UA Servers GenBroker Plugins SNMP BACnet Databases Portable XP 64-Bit Vista 64-Bit Server 2003 64-bit Server 2008 64-bit 14
Hyper-Historian Collector Local or Remote Deadband Filtering Advanced Filtering Maximum Minimum Average Standard Deviation Totalizer Running Maximum Running Minimum Running Average Moving Maximum Moving Minimum Moving Average Most Recent On Time Redundant Collectors Store and Forward 15
Hyper-Historian Logger Logging Options High Performance Disk Based RAM Memory-Based Persistent Data Raw Advanced Filtered Aggregates Data Types Boolean Integer Float String Filtering None Deadband Swinging Door 16
Hyper-Historian Logger Conditional Logging UDM Trigger Based Memory Persistent Logging Configurable Logging Period Option to Log to Disk upon Event Configurable Pre and Post Event Store Aggregate Logging Summary Tags for High-speed playback of Summary Portable XP X64 Vista X64 Server 2003 X64 Server 2008 X64 Redundant Loggers 17
Hyper-Historian Configuration Online Configuration Web Based Configuration Based on Web Workbench Toolkit Consistent Look-and-Feel to TrendWorX64 Configurator 18
Hyper-Historian Performance 50,000+ Values Logged per Second 150,000+ Tags Collection Resolution to 10 MS Immediate playback of Logged data No wait for Database writes 21
GENESIS Historian Benchmarks AMD Athlon 64 X2 Dual Core, 2.86 GHz 8 GB Memory Windows Vista64 Business SP1
GENESIS Historian Benchmarks AMD Athlon 64 X2 Dual Core, 2.86 GHz 8 GB Memory Windows Vista64 Business SP1
Performance Hyper Historian Sample Benchmark Results
Data Compression Deadband Filter Swinging Door Algorithm “Advanced” Filtering Small Data “Footprint” Low overhead Binary file store Aggregate Tags 25
Swinging Door Efficiency 102 Raw Values (per cycle) Deadband filter: 31% (32 values) Swinging Door filter: 12% (12 values) Aggressive Deadband filter: 12% (12 values)
Deadband Filter Limitations Swinging Door Deadband Filter 1 4 17 21 18 3 20 19 2 16 5 15 6 14 7 9 11 10 8 12 13 • Stores unneeded samples (6, 7, 15, 16) • Misses inflection samples (4, 13) • Higher Compression • Better accuracy
Data Footprint TrendWorX32 / TrendWorX64 ~28 Bytes / 32-bit Float 100 Tags @ 1s for 1 day ~300 Mbytes Hyper Historian ~7 Bytes / 32-bit Float 100 Tags @ 1s for 1 day ~70 Mbytes
Hyper-Historian File Archiving Advanced file maintenance and Archiving Control of Disk Space Use Backup of Data Easy Re-attachment of Backup Archiving Based on UDM Trigger File Size Age of Data 29
Hyper Historian Clients TrendWorX64 Chart Control SQL Query Interface ReportWorX BridgeWorX Productivity Analytics Third Party 32
3D Charting Capabilities Real-time And Historical Trend Data Rotate to Change Perspective Out-of-the-box Chart Categories Plug-in New Chart Types Combine Charts for Analysis TrendWorX64 Chart Control 33
Summary View Paging (Fwd & Back) Zoom TrendWorX64 Chart Control
Hyper-Historian SQL Query Look and Feel of SQL Server Various Output formats Select, Insert, Update, Delete Support 35
Hyper-Historian SQL Query Advanced Data Query Support Time-in-State Best Fit Time-Weighted Average Integral Slope Counter 36
Hyper-Historian Data Editing API to Edit Logged Data Edited data is Marked Original data is kept HDA Playback Options Original data only Original data with edited data Combination – showing both GUI for Manual Edits API for bulk edits 37
Other Hyper-Historian Features Integrated into MonitorWorX TraceWorX Support GenEvents Support 38
Hyper-Historian Key Benefits Efficient High Performance High Compression Reliable Redundancy Store and Forward Data Accessibility TrendWorX64 Viewer SQL Query Interface Data Editing Easy to Configure Remote Configure-ability Web-based Online Flexible, Automated Archiving Scalable Flexible Architecture 40
Hyper-Historian Questions ? 41
Future Goals – V10.5 HDA Server / GENESIS32 Integration 32-bit Collector Standalone Installation for Collector Redundancy & Store and Forward Data Insert Grid Data Insert Utility Swinging Door at Collector Optimizations (>100,000 values/sec) MS Cluster Aware 43
Future Goals – Part II Twx32 Configuration Import SQL Query Interface Extensions Quality Filter SQL Server Logger Dynamic Calculations Ability to monitor health via SNMP Data Collection from more sources OPC AE Support for more tags (>500,000) 44