Apparatus, system, method for enabling web-applications to access enterprise managed data

• US 20050192962A1
• Filed: 02/26/2004
• Published: 09/01/2005
• Est. Priority Date: 02/26/2004
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Nettles, William Benjamin, Xu, Tony H., Furrer, Patricia, Rao, Savur Anand, Lewis, Cecilia Carranza
• Application Number:
  US10/788,229
• Publication Number:
  US 20050192962A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation

Abstract

An apparatus, system, and method are provided for enabling web-applications to access enterprise managed data. The invention includes a recoverable resource manager (RRM), a transaction converter, an interface, and a results converter. The RRM provides transactional recovery and transactional access for a plurality of applications including the web-applications. The transaction converter, interface, and results converter cooperate such that relational data requests sent by the web-application access the non-relational data through the RRM and return relational results from non-relational results provided by the RRM. In one implementation, the present invention provides transactional access to web-applications for VSAM data accessible exclusively through a z/OS operating system.

Claims

1. An apparatus for web-applications to access enterprise managed data, the apparatus comprising:

a recoverable resource manager (RRM) for data, the RRM configured to provide transactional recovery and transactional access for a plurality of transactions concurrently accessing the data;

a transaction converter configured to convert a relational transaction request of a transaction involving the data managed by the RRM into one or more non-relational transaction requests;

an interface configured to send the non-relational transaction requests to the RRM to be executed in order to produce non-relational results that are received by the interface; and

a results converter configured to convert the non-relational results into relational results that can be sent to a web-application.

2. The apparatus of claim 1, wherein the RRM cooperates within an enterprise information system (EIS) to provide logging, locking, two-phase commit, back out and sharing of the data such that transactions accessing the data are recoverable.

3. The apparatus of claim 1, further comprising a web-application interface configured to receive the relational transaction from the web-application according to an industry-accepted application programming interface (API).

4. The apparatus of claim 1, wherein the RRM cooperates with a resource recovery service (RRS) and a Concurrent Access Facility (CAF) such that relational and non-relational transactions accessing the data are recoverable.

5. The apparatus of claim 4, wherein the RRM comprises Storage Management Subsystem for Virtual Storage Access data (SMS VSAM) and the CAF comprises a coupling facility (CF).

6. The apparatus of claim 1, wherein the RRM comprises a transactional Virtual Storage Access Method (VSAM) module that uses VSAM Record Level Sharing (RLS) module and the data comprises VSAM data.

7. The apparatus of claim 1, wherein the transaction converter is further configured to parse the relational transaction into relational expressions and map the relational expressions to non-relational expressions according to predefined metadata defined by a relational view and a non-relational view of the data.

8. The apparatus of claim 1, wherein the results converter is further configured to map the non-relational results to relational results according to predefined metadata defined by a relational view and a non-relational view of the data.

9. An apparatus for web-applications to access enterprise managed data, the apparatus comprising:

a first application server configured to interface with a web-application;

an enterprise information system (EIS) comprising a recoverable resource manager (RRM) for Virtual Storage Access Method (VSAM) data, the RRM configured to provide transactional recovery and transactional access for a plurality of transactions concurrently accessing the VSAM data; and

a connector configured to exchange one or more relational requests of a transaction involving the VSAM data and relational results between the first application server and the RRM of the EIS.

10. The apparatus of claim 9, wherein the connector comprises:

a transaction converter configured to convert the relational requests into one or more non-relational requests;

an interface configured to send the non-relational requests to the RRM to be executed in order to produce non-relational results, the interface receiving the non-relational results; and

a results converter configured to convert the non-relational results into relational results that the connector sends to the web-application via the first application server.

11. The apparatus of claim 9, wherein the connector comprises a Java Database Connectivity (JDBC) Application Programming Interface (API).

12. The apparatus of claim 9, further comprising a second application server in communication with the first application server, the apparatus further comprising a distributed connecter that interfaces between a distributed application component on the second application server and the connecter executing on the first application server such that the distributed application component has transactional access to the VSAM data in which the transactions are managed using transactional recovery.

13. The apparatus of claim 12, wherein the distributed connector comprises a JAVA programming language type-3 connecter and the connector comprises a JAVA programming language type-2 connector and wherein the distributed application component comprises an Enterprise Java Bean (EJB) configured to receive or execute relational transaction requests for VSAM data in a transaction and return relational results using the connector and the distributed connector.

14. The apparatus of claim 9, wherein the EIS comprises a Multiple Virtual Storage Recoverable Resource Management Service (MVS/RRMS), a coupling facility (CF) and a VSAM Record Level Sharing (RLS) module that each interact with the RRM to provide logging, locking, two-phase commit, back out and sharing of the VSAM data such that transactions accessing the data by way of the RRM are recoverable.

15. A system for web-applications to access enterprise managed data, the system comprising:

a client application configured to interface with a web-application executing on a first application server;

a database module configured to interface with the web-application to allow relational database access to non-relational data; and

an enterprise information system configured to provide concurrent transactional access to the non-relational data as well as transactional recovery for the web-application as well as batch programs and Customer Information Control Systems (CICS).

16. The system of claim 15, wherein the non-relational data comprises Virtual Storage Access Method (VSAM) data.

17. The system of claim 15, wherein the web-application comprises one or more distributed middleware components executing on one or more application servers.

18. The system of claim 15, wherein the first application server executes on a z/OS operating system.

19. The system of claim 15, further comprising a second application server executing on an operating system that is not a z/OS operating system, the second application server in communication with the first application server, the system further comprising a distributed connecter that interfaces between a distributed application component on the second application server and the connecter executing on the first application server such that the distributed application component has transactional access to the VSAM data in which the transactions are managed using transactional recovery.

20. A method for web-applications to access enterprise managed data, the method comprising:

providing a recoverable resource manager (RRM) for data, the RRM configured to provide transactional recovery and transactional access for a plurality of transactions concurrently accessing the data;

converting a relational transaction involving the data managed by the RRM into a non-relational transaction;

communicating the non-relational transaction to the RRM to be executed in order to produce non-relational results; and

converting the non-relational results into relational results that are sent to a web-application.

21. The method of claim 20, wherein the RRM cooperates within an enterprise information system (EIS) to provide logging, locking, two-phase commit, back out and sharing of the data such that transactions accessing the data are recoverable.

22. The method of claim 20, further comprising receiving the relational transaction from the web-application according to an industry-accepted application programming interface (API).

23. The method of claim 20, wherein the RRM cooperates with a resource recovery service (RRS) and a Concurrent Access Facility (CAF) such that relational and non-relational transactions accessing the data are recoverable.

24. The method of claim 23, wherein the RRM comprises Storage Management Subsystem for Virtual Storage Access data (SMS VSAM) and the CAF comprises a coupling facility (CF).

25. The method of claim 20, wherein the RRM comprises a transactional Virtual Storage Access Method (transactional VSAM) module that uses VSAM Record Level Sharing (RLS) module and the data comprises VSAM data.

26. The method of claim 20, wherein converting the relational transaction comprises parsing the relational transaction into relational expressions and mapping the relational expressions to non-relational expressions according to predefined metadata defined by a relational view and a non-relational view of the data.

27. The method of claim 20, wherein converting the non-relational results comprises mapping the non-relational results to relational results according to predefined metadata defined by a relational view and a non-relational view of the data.

28. An article of manufacture comprising a program storage medium readable by a processor and embodying one or more instructions executable by a processor to perform a method for web-applications to access enterprise managed data, the method comprising:

providing a recoverable resource manager (RRM) for data, the RRM configured to provide transactional recovery and transactional access for a plurality of transactions concurrently accessing the data;

converting a relational transaction involving the data managed by the RRM into a non-relational transaction;

communicating the non-relational transaction to the RRM to be executed in order to produce non-relational results; and

converting the non-relational results into relational results that are sent to a web-application.

29. The article of manufacture of claim 28, wherein the RRM cooperates within an enterprise information system (EIS) to provide logging, locking, two-phase commit, back out and sharing of the data such that transactions accessing the data are recoverable.

30. The article of manufacture of claim 28, further comprising receiving the relational transaction from the web-application according to an industry-accepted application programming interface (API).

31. The article of manufacture of claim 28, wherein the RRM cooperates with a resource recovery service (RRS) and a Concurrent Access Facility (CAF) such that relational and non-relational transactions accessing the data are recoverable.

32. The article of manufacture of claim 31, wherein the RRM comprises Storage Management Subsystem for Virtual Storage Access data (SMS VSAM) and the CAF comprises a coupling facility (CF).

33. The article of manufacture of claim 28, wherein the RRM comprises a transactional Virtual Storage Access Method (transactional VSAM) module that uses VSAM Record Level Sharing (RLS) module and the data comprises VSAM data.

34. The article of manufacture of claim 28, wherein converting the relational transaction comprises parsing the relational transaction into relational expressions and mapping the relational expressions to non-relational expressions according to predefined metadata defined by a relational view and a non-relational view of the data.

35. The article of manufacture of claim 28, wherein converting the non-relational results comprises mapping the non-relational results to relational results according to predefined metadata defined by a relational view and a non-relational view of the data.

36. An apparatus for web-applications to access enterprise managed data, the method comprising:

means for providing a recoverable resource manager (RRM) for data, the RRM configured to provide transactional recovery and transactional access for a plurality of transactions concurrently accessing the data;

means for converting a relational transaction involving the data managed by the RRM into a non-relational transaction;

means for communicating the non-relational transaction to the RRM to be executed in order to produce non-relational results; and

means for converting the non-relational results into relational results that are sent to a web-application.

37. The apparatus of claim 36, wherein the RRM cooperates within an enterprise information system (EIS) to provide logging, locking, two-phase commit, back out and sharing of the data such that transactions accessing the data are recoverable.

38. The apparatus of claim 36, further comprising receiving the relational transaction from the web-application according to an industry-accepted application programming interface (API).

39. The apparatus of claim 36, wherein the RRM cooperates with a resource recovery service (RRS) and a Concurrent Access Facility (CAF) such that relational and non-relational transactions accessing the data are recoverable.

40. The method of claim 36, wherein converting the relational transaction comprises parsing the relational transaction into relational expressions and mapping the relational expressions to non-relational expressions and mapping the non-relational results to relational results where both mappings are accomplished according to predefined metadata defined by a relational view and a non-relational view of the data.