LzHierarchical™ is an implementation of a hierarchical database, based on PostgreSQL. It enables legacy applications, originally written to access IMS™ DB using the DL/1 access language, to work without source-code changes or recompilation on Linux. LzHierarchical enables PostgreSQL-skilled IT professionals to manage an organization's critical data, hitherto locked away in an impenetrable legacy database
Compatible Database
Enables applications developed to use data stored in IMS™ DB to be migrated to Linux on x86 without source-code changes or recompilation.


Relational Transformation
Hierarchical data is transformed into a relational format and stored in PostgreSQL. All parent/child relationships are maintained using native relational features. Once in PostgreSQL the data can be accessed and exploited by a variety of modern systems.
Blistering Performance
A number of factors combine within the SDM to enable re-hosted applications to enjoy the type of performance characteristics traditionally only found on the very largest mainframes. Specifically, the parallel nature of PostgreSQL ensures today’s multi-core Xeon processors are exploited to the maximum extent possible. Additionally, PostgreSQL provides scope to optimize settings to exploit the availability of large memory configurations, and modern storage subsystems. These features enable an access performance profile that meets, and in many cases exceeds, that experienced on the original legacy mainframe.


Modernized Access
With SDM data in PostgreSQL, normalized to take advantage of relational features in logical way, it becomes possible to integrate hierarchical data with other systems in ways that were all-but impossible previously. SQL-oriented access from JDBC and ODBC environments, and asynchronous publishing of data to analytics environments, are just two of the ways this data is opened up to modern environments once migrated to SDM.
Specifications
-
DL/1 Support
Support for both macro-level and command-level DL/1 calls.
-
Logical Relationships
Support for logical relationships, managed through standard relational foreign key mechanisms.
-
Secondary Indexes
Support for secondary indexes, and a range of index-based optimisations implemented within PostgreSQL.
-
Database recoverability
Transactional integrity is maintained by leveraging the native transaction management capabilities of PostgreSQL.
-
Preserves hierarchy navigation
Ensures that the hierarchy navigation, implied by the dataset organization specified in the DBD, is honoured during DL/1 processing.
-
Mapping and migration tools
Streamlines the conversion to PostgreSQL with powerful tools to create relational schemas from DBDs and incremental migration of databases.
More Information
Product Data Sheets
Visit our download portal for immediate access to our Product Data Sheets. Please note that Data Sheets are available for download in English language only at present.
Visit Download Portal