QSAM
The Arbutus technology provides direct access to any QSAM file, regardless of its complexity, for use in a variety of
applications. Arbutus provides the LegacyLink™ middleware
that connects your Windows applications directly with your QSAM and other data.
As well, Arbutus offers query, migration and data warehouse prototyping solutions.
Our technology is unique because of its ability to not only access
QSAM, but to join it with disparate data from
IMS, DB2, ISAM,
VSAM and other QSAM files with
no additional infrastructure. Users can benefit from one
view of the requested data, even when multiple
sources are involved.
In fact, the Arbutus technology allows virtually any file, regardless
of complexity, to be accessed and combined in any manner as if they were part of a database or data warehouse.
As a result, using our LegacyLink™ middleware, any SQL query can be executed directly against the source data.
In addition, Arbutus includes the ability to create external indexes for any QSAM file. This allows them to
essentially behave like a VSAM file and to participate in star schema data models and query optimization.
Key features:
- Supports SQL queries directly against QSAM
data using our LegacyLink™ middleware
- Combines your QSAM data with DB2, IMS, VSAM, ISAM and
AS/400 based data
- Allows QSAM files to be automatically defined using
existing COBOL or PL/1 record definitions
- Presents QSAM files of any complexity as a normal table
to other applications
- Allows data definitions to be easily modified at any
time
- Allows keyed access to QSAM files by using special
Arbutus indexes
- Ensures security/integrity by providing read-only access
to the data
- Displays only those files and columns chosen to be
accessible by the administrator
- Allows table and column names that the user sees to
be easily modified for readability or usability
- Supports the creation of dynamic "virtual" columns
based on the contents of the data without requiring any
changes to the QSAM file itself, by utilizing over 80
built in functions
- Enables QSAM files to be joined with any tables,
either via SQL or star schema relationships
|
