METHOD FOR PROVIDING ACCESS TO DATA STORED IN A DATABASE TO AN APPLICATION

• US 20090204583A1
• Filed: 04/05/2007
• Published: 08/13/2009
• Est. Priority Date: 06/08/2006
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Hechler, Eberhard, Seubert, Holger, Oberhofer, Martin
• Application Number:
  US12/303,531
• Publication Number:
  US 20090204583A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

Access to data stored in a database within a data processing system is provided to an application in the following manner. At least one criterion for providing data is determined based at least on a service level agreement. A provisioning and deployment description identifying at least data units of a database to be provided to the application is received, and a system description including status and resource usage information of possible target systems within the data processing system is maintained. A placement technology description describing properties of data placement technologies is received. At least one target system and at least one data placement technology are selected based on said at least one criterion and said descriptions. Access to said data units is provided for said application using said selected at least one target database system and said at least one data placement technology.

Claims

1. A computerized method for providing data stored in a database within a data processing system to an application, the method comprising:

determining at least one criterion for providing data to the application from the data processing system based at least on a service level agreement;

receiving a provisioning and deployment description identifying at least data units of a database to be provided to the application;

maintaining a system description including status and resource usage information of a plurality of possible target systems within the data processing system;

receiving a placement technology description describing properties of a plurality of data placement technologies supported within the data processing system;

selecting at least one target system and at least one data placement technology based on said at least one criterion, said provisioning and deployment description, said system description and said placement technology description; and

providing access to said data units for said application using said selected at least one target database system and said at least one data placement technology.

2. A method as defined in claim 1, comprising using the selected at least one data placement technology to deploy the data units to said selected at least one target system.

3. A method as defined in claim 1, wherein said provisioning and deployment description further identifies at least one application unit executable by said database and associated with said data units, said method comprising providing access to said at least one application unit for said application.

4. A method as defined in claim 3, comprising deploying said at least one application unit to said selected at least one database system.

5. A method as defined in claim 3, comprising storing said at least one application unit in an application deployment archive together with said provisioning and deployment description.

6. A method as defined in claim 3, comprising receiving an updated version of an application unit associated with said application, storing said updated version in the application deployment archive, and updating said provisioning and deployment description to refer to the updated version of the application unit.

7. A method as defined in claim 3, wherein said at least one application unit comprises at least one of the following:

computer executable code in compiled form, computer executable code in source form.

8. A method as defined in claim 3, comprising

receiving a logical name of an application unit from said application,

binding said logical name to an executable application unit based on said provisioning and deployment description, and

executing the deployment of the respective executable application unit in said selected at least one target database system.

9. A method as defined in claim 1, wherein said plurality of data placement technologies comprises at least one of the following data placement technologies:

direct read, materialized query tables, database replication, and storage replication.

10. A data processing program product for execution in a data processing system, said computer program product comprising software code portions for performing a method according to claim 1 when said data processing program product is loaded in said data processing system.

11. A data processing program product as defined in claim 10, embodied in a computer readable medium.

12. A data processing system comprising

a plurality of database systems for storing data units;

a placement technology description describing properties of a plurality of data placement technologies supported by the data processing system;

at least one interface for receiving

service level agreements associated with applications, and

provisioning and deployment descriptions identifying at least data units associated with respective application units, and

a controller configured to carry out a method as defined in claim 1 for providing access to data stored within the data processing system to an application.

13. A data processing system as defined in claim 12, comprising at least one server for running said applications.

14. A data processing system as defined in claim 12, wherein said provisioning and deployment description identify application units associated with respective applications, and the data processing system comprises storage facilities for storing said application units executable by said database systems.

15. A data processing system as defined in claim 12, wherein said controller comprises a data processing program installed on the data processing system.