1 / 44

High Performance Hyper – Historian

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

lynton
Download Presentation

High Performance Hyper – Historian

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. High Performance Hyper – Historian G64-304 DaveOravetz, US Habib Rehman, Australia Carl Harper, UK • Andre Scherpenzeel, UK ICONICS 2008 Worldwide Customer Summit Boston, MA

  2. 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

  3. 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

  4. 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

  5. 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

  6. Hyper Historian Editions ICONICS 2008 Worldwide Customer Summit – Boston, MA

  7. 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

  8. 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

  9. Comparison Diagram • Comparison ICONICS 2008 Worldwide Customer Summit – Boston, MA, April, 2008

  10. 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

  11. Architecture and Configuration

  12. Hyper-Historian Architecture Hyper-Historian Components Data Collector Data Logger Workbench Configuration 3D Chart Control SQL Query Interface 12

  13. 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

  14. 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

  15. 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

  16. 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

  17. 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

  18. Hyper-Historian Configuration Online Configuration Web Based Configuration Based on Web Workbench Toolkit Consistent Look-and-Feel to TrendWorX64 Configurator 18

  19. Configuration Demo

  20. Performance and Runtime

  21. 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

  22. GENESIS Historian Benchmarks AMD Athlon 64 X2 Dual Core, 2.86 GHz 8 GB Memory Windows Vista64 Business SP1

  23. GENESIS Historian Benchmarks AMD Athlon 64 X2 Dual Core, 2.86 GHz 8 GB Memory Windows Vista64 Business SP1

  24. Performance Hyper Historian Sample Benchmark Results

  25. Data Compression Deadband Filter Swinging Door Algorithm “Advanced” Filtering Small Data “Footprint” Low overhead Binary file store Aggregate Tags 25

  26. 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)

  27. 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

  28. 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

  29. 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

  30. Compression Demo

  31. Clients

  32. Hyper Historian Clients TrendWorX64 Chart Control SQL Query Interface ReportWorX BridgeWorX Productivity Analytics Third Party 32

  33. 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

  34. Summary View Paging (Fwd & Back) Zoom TrendWorX64 Chart Control

  35. Hyper-Historian SQL Query Look and Feel of SQL Server Various Output formats Select, Insert, Update, Delete Support 35

  36. Hyper-Historian SQL Query Advanced Data Query Support Time-in-State Best Fit Time-Weighted Average Integral Slope Counter 36

  37. 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

  38. Other Hyper-Historian Features Integrated into MonitorWorX TraceWorX Support GenEvents Support 38

  39. ClientDemo

  40. 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

  41. Hyper-Historian Questions ? 41

  42. TrendWorX64 vs. Hyper-Historian

  43. 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

  44. 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

More Related