Relate
|
Intelligent Data Comparison and Maintenance
The Relate family of products dynamically reads record definitions contained in DDL dictionaries or COBOL copybooks in order to perform field-level operations on Enscribe files. These operations include updates / insertions / deletions / comparisons / aggregations that can be performed globally across an entire file or constrained to a specified selection of records. The family of products consists of Relate Classic and Relate EnSQL. |
|
Relate Classic
Relate Classic is the collective name for the original Relate-branded products. It uses the native Enscribe file formats to enable the creation, viewing, updating, deletion and sophisticated comparison of records using a SQLCI-like syntax from within a command-line interface program.
Relate Classic provides advanced capabilities to assist with the processing of variable or nonstandard records and fields. Variably formatted records are those that do not follow a strict fixed format as indicated by a DDL or COBOL data definition. Instead, the records consist of fields (or groups of fields) which are either variable in length, or perhaps not even present in the record at all. Either situation will impact the placement of the later fields in the record. Such data formats are common in data-communication applications, where it is desirable to reduce the physical amount of data transferred in order to optimize transmission speeds and costs. An example of such records can be found within ACI's BASE24 Classic product; these Relate Classic features were developed with the assistance of ACI to assist with the QA testing of its Version 6.0 release.
Relate Classic can also be used to quickly and intelligently compare database files, using algorithms appropriate to the types of files being compared. Because it understands the record formats, field differences can be identified by name, or can even be excluded from the comparison process.
These value-added features make Relate Classic well suited for achieving rapid results in application testing, database maintenance and migration projects.
Relate Classic provides advanced capabilities to assist with the processing of variable or nonstandard records and fields. Variably formatted records are those that do not follow a strict fixed format as indicated by a DDL or COBOL data definition. Instead, the records consist of fields (or groups of fields) which are either variable in length, or perhaps not even present in the record at all. Either situation will impact the placement of the later fields in the record. Such data formats are common in data-communication applications, where it is desirable to reduce the physical amount of data transferred in order to optimize transmission speeds and costs. An example of such records can be found within ACI's BASE24 Classic product; these Relate Classic features were developed with the assistance of ACI to assist with the QA testing of its Version 6.0 release.
Relate Classic can also be used to quickly and intelligently compare database files, using algorithms appropriate to the types of files being compared. Because it understands the record formats, field differences can be identified by name, or can even be excluded from the comparison process.
These value-added features make Relate Classic well suited for achieving rapid results in application testing, database maintenance and migration projects.
Relate EnSQL
Relate EnSQL is the newest member of the Relate product family, and it takes a completely different approach to its sibling product in solving the Enscribe data maintenance problem. Relate EnSQL internally maps Enscribe data into a SQL-compatible form and uses a SQL parsing engine to provide access to the mapped data. This enables the creation, viewing, updating, deletion and query-oriented comparison of the underlying Enscribe records at the field-level using industry-standard SQL syntax. These operations can be performed directly from the NonStop server’s Guardian personality using a provided command-line interface, or locally from Java programs running on the OSS personality, or remotely from Java programs running on any other Java-enabled platform using a JDBC driver.
The ability to use standard SQL queries with its attendant rich expression handling enables personnel to use a familiar, flexible, and powerful toolset in their application testing, database maintenance and migration projects.
The ability to use standard SQL queries with its attendant rich expression handling enables personnel to use a familiar, flexible, and powerful toolset in their application testing, database maintenance and migration projects.
System Requirements:
- RELATE Classic will run on any HPE Integrity NonStop Server under the NonStop Kernel.
- Relate EnSQL runs on the HPE Integrity NonStop Server and requires a J or L series operating system release.
