340 likes | 469 Views
Dave Oravetz VP of Engineering. 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
E N D
Dave Oravetz VP of Engineering
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 2
Hyper-Historian Architecture Hyper-Historian Components Data Collector Data Logger Workbench Configuration 3D Chart Control SQL Query Interface 4
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 6
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 7
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 8
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 9
Hyper-Historian Configuration Online Configuration Web Based Configuration Based on Web Workbench Toolkit Consistent Look-and-Feel to TrendWorX64 Configurator 10
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 13
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
HH Logging Performance Hyper Historian Sample Benchmark Results (Beta5)
Data Compression Deadband Filter Swinging Door Algorithm “Advanced” Filtering Small Data “Footprint” Low overhead Binary file store Aggregate Tags 17
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
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 Hyper-Historian Trend Viewer 23
Summary View Paging (Fwd & Back) Zoom Hyper-Historian Trend Viewer
Hyper-Historian SQL Query Look and Feel of SQL Server Various Output formats Select, Insert, Update, Delete Support 25
Hyper-Historian SQL Query Advanced Data Query Support Time-in-State Best Fit Time-Weighted Average Integral Slope Counter Useful when tag always increments Useful when the signbooleanal is noisy Useful when the tag is a Rate Useful when the tag is a 26
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 27
Other Hyper-Historian Features Integrated into MonitorWorX TraceWorX Support GenEvents Support 28
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 Questions ? 32
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 33
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) 34