The OPCHDB is comprised of following five components, OPC DA Client, Historical Database, OPC HDA Server, Quick Report and Quick Graph. The OPC DA Client interface allows data to be input to the Historical Database from OPC DA Servers and provides rescaling and OPC Tag Browsing. The Historical Database is an extremely efficient database using the 'flat file' model in which historical values are stored time-sequentially in 4-byte floating-point format. The Historical Database uses a separate file for each variable's historical data; the name of the file is derived from the variable's index in an 'Index File'. Name lookup simply uses an Indexed Sequential Access Method (ISAM); typical of any indexed database. The power of the flat-file database comes from the fact that values are stored in a time-sequential fashion so that access of a value at a particular time requires a simple calculation of the value's location in its data file. From that file position, a single read retrieves time-sequential values. The result is extremely fast access of large volumes of data. The OPC HDA Server interface provides stored historical data to OPC HDA Clients using the OPC HDA (Historical Data Access) 1.0 specification. The Quick Report and Quick Graph offers a simple way of reporting and viewing historical data.

Please visit our User Apps page to see a more powerful optional graphical trending software program and a easy-to-use Add-in for Microsoft Excel to build workbooks for data analysis and reports. The OPCHDB and optional User Apps are available for a thirty (30) day trial after download and installation. Please go to the "Download " page and submit a download registration form.

FEATURES

• Can collect data from OPC DA Servers.
• OPC Data Access 1.0a, OPC Data Access 2.0 specifications.
• Can browse for input sources.
• Supports the filtering and scaling of input tags, plus conversion to actual engineering values.
• Can define aliases for tag names.
• Provides the ability to select the time stamp from the process control system or local PC.
• Supports phase shifting input collection for load leveling.
• One thousand (1000) to ten thousand (10000) process tags licenses available.
• Provides one-second, one-minute, and one-hour databases.
• One-second  database has a history of one week.
• One-minute database has a history of one year.
• One-hour database has a history of two years.
• Transfers can be up to 5,000 files per minute.
• Can Stop/Start, Pause collection lists.

• Each database has its own set of files with the propagated database derived from other databases.

• Can provide data to OPC HDA Clients.

• Historical Data Access 1.0 specification.

• Provides OPC Tag Browsing.
• Automatically serves up all tags for all databases.
• Tag name, description, engineering units, high and low span values available for every variable.
• Read only access to all tag values.
• No configuration is required.
• Unlimited amounts of historical data can be previewed and printed.
• Report definitions can be saved and used again at a later time.
• Historical data can be exported to a CSV, HTML, or XLS file.
• An average, minimum, and maximum value for a defined time span is calculated and displayed.
• A simple graph of the historical data can be displayed and saved.
• Graph areas can be expanded or panned by a simple click and hold of a mouse button.
• Graphs can be printed in either portrait or landscape orientation.
• Legend of the points being graphed can be toggled on or off.
• All graphs can be displayed in a three dimensional mode.

System Specifications