SQL access to IMS/DB mainframe databases. (Database and Network News & Products).

NEON Systems. have enhanced its Shadow mainframe integration technology to enable rapid development of distributed applications to the complex IMS/DB (Information Management System/Database) mainframe database utilising SQL via standard development APIS, such as J2CA, JDBC and ODBC, without compromising performance, security or data integrity.

Comment:

Despite the proliferation of relational databases, an enormous amount of data still resides within non-relational mainframe databases such as IMS/DB, which continue to support--critical business processes. The addition of a viable SQL interface broadens the appeal of IMS/DB; by enabling distributed applications direct access using industry standard AP1s, while maintaining the performance and scalability characteristics of conventional access methods.

The Shadow Interface for IMS/DB provides application developers with an array of options for reaching into IMS databases, using either simplified SQL access or invoking RPCs (Remote Procedure Calls) through industry--standard APIS, such as J2CA, JDBC or ODBC. The enhanced server functionality of the Shadow Interface for IMS/DB exploits standard IMS APIs (CCTL/DBCTL and ODBA) with performance, security, and transactional capabilities to accommodate high volume, high concurrency distributed application requests to the mainframe.

Additionally, Shadow's Interface for IMS/DB supports two-phase commit technology, which uses IBM's RRS facility within IMS to expand the transaction scope in order to maintain data integrity with other data sources, both on and off the mainframe, in one unit-of-work. This capability is critical when data updates need to occur simultaneously at multiple databases within a distributed system.

www.neonsystems.com