Common configuration framework for applications to configure database objects and resources

• US 8,549,144 B2
• Filed: 08/31/2007
• Issued: 10/01/2013
• Est. Priority Date: 08/31/2007
• Status: Active Grant

• Current Assignee: ServiceNow Incorporated
• Original Assignee: International Business Machines Corporation
• Inventors: Khangaonkar, Manoj, Li, Wen Chao, Xu, Weixin, Zhang, Kai Mike
• Primary Examiner(s): Moore, Ian N
• Assistant Examiner(s): ZUNIGA ABAD, JACKIE
• Application Number:
  US11/849,201
• Publication Number:
  US 20090063563A1
• Time in Patent Office: 2,223 Days
• Field of Search: 709227-229
• US Class Current: 709/225
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

Provided are a method, system, and article of manufacture for a common configuration framework for applications to configure database objects and resources. configuration interfaces are maintained for a plurality of different database types, wherein each configuration interface implements a database configuration operation with respect to a database of one database type. A configuration request is received from an application indicating a database type, database name, and a database configuration operation. A determination is made of one of the configuration interfaces for the requested database type to implement the requested configuration operation with respect to the database having the database name. The determined configuration interface is invoked with the requested database name to perform the requested configuration operation with respect to the database name.

Claims

1. A method, comprising:

maintaining configuration interfaces for a plurality of different database types, wherein each configuration interface implements a database configuration operation with respect to a database of one database type;

maintaining a configuration request mapping providing configuration mappings, each configuration mapping indicating a configuration request name and at least one of the configuration interfaces for a database type to invoke to perform a configuration operation associated with the configuration request name for the database type, wherein configuration mappings are provided for different database types to perform the configuration operation associated with one configuration request name;

receiving a configuration request from an application indicating a configuration request name, database type, database name, and a generic database configuration operation not specific to a particular database type;

determining the configuration mapping in the configuration request mapping having a database type and configuration request name matching the requested database type and the requested configuration request name for the generic database configuration operation to implement the requested configuration operation with respect to the database having the database name;

determining the configuration interface for the determined configuration mapping; and

invoking the determined configuration interface with the requested database name to perform the requested configuration operation with respect to the database name.

2. The method of claim 1, wherein the configuration interfaces implement build time configuration operations to configure database resources for the database accessible to applications during runtime operations.

3. The method of claim 2, further comprising:

accessing, by a plurality of applications executing in a runtime environment, the built database resources to access and perform operations with respect to the databases of the different database types.

4. The method of claim 2, further comprising:

publishing services associated with the configuration interfaces that are called by the applications directly as a service for the database types; and

invoking, by the applications, the services with inputs comprising the configuration request to perform the requested generic configuration operation implemented by the services with respect to the requested database name of the database type and generic configuration operation associated with the configuration interface associated with the invoked service.

5. The method of claim 2, wherein the configuration requests called by the application include database create configuration requests indicating a database name and database type to create, wherein determining one of the configuration interfaces for the database create configuration request comprises determining one configuration interface that is invoked to create a database having the database name of the database type indicated in the database create configuration request.

6. The method of claim 2, wherein the configuration requests called by the application include table create configuration requests indicating a table name to create, a database name in which to create a table having the requested table name, and a database type of the database name, wherein determining one of the configuration interfaces for the table create configuration request comprises determining one configuration interface operation that is invoked to create a table having the table name in the database name of the database type indicated in the table create configuration request.

7. The method of claim 2, wherein the configuration requests called by the application include version upgrade configuration requests indicating a database element to upgrade, a version upgrade, a database name in which to upgrade the database element to the version upgrade, and a database type, wherein determining one of the configuration interfaces for the version upgrade configuration request comprises determining one configuration interface that is invoked to upgrade the database element to the version upgrade for the database type indicated in the version upgrade configuration request.

8. The method of claim 1, wherein the configuration requests called by the application include validation configuration requests indicating a database element to validate, a database name to be validated, and a database type of the database name, wherein determining one of the configuration interfaces for the validation configuration request comprises determining one validation configuration interface that is invoked to validate the database element for the database name of the database type indicated in the validation create configuration request.

9. The method of claim 8, wherein the determined database element to validate for use during runtime operations includes at least one of a password, database name, and database drivers.

10. The method of claim 1, wherein the database types include databases from different vendors having different database formats and configurations.

11. A system in communication with databases of different database types and applications, comprising:

a processor; and

a computer readable storage device storing;

configuration interfaces for a plurality of different database types, wherein each configuration interface implements a database configuration operation with respect to a database of one database type;

a configuration request mapping providing configuration mappings, each configuration mapping indicating a configuration request name and at least one of the configuration interfaces for a database type to invoke to perform a configuration operation associated with the configuration request name for the database type, wherein configuration mappings are provided for different database types to perform the configuration operation associated with one configuration request name;

a configuration program executed by the processor operations, the operations including;

receiving a configuration request from one of the applications indicating a configuration request name, database type, database name, and a generic database configuration operation not specific to a particular database type;

determining the configuration mapping in the configuration request mapping having a database type and configuration request name matching the requested database type and the requested configuration request name for the generic database configuration operation to implement the requested configuration operation with respect to the database having the database name;

determining the configuration interface for the determined configuration mapping; and

invoking the determined configuration interface with the requested database name to perform the requested configuration operation with respect to the database name.

12. The system of claim 11, wherein the configuration interfaces implement build time configuration operations to configure database resources for the database accessible to applications during runtime operations.

13. The system of claim 12, wherein the applications executing in a runtime environment access the built database resources to access and perform operations with respect to the databases of the different database types.

14. The system of claim 12, configuration program operations further comprise:

publishing services associated with the configuration interfaces that are called by the applications directly as a service for the database types, wherein the applications invoke the services with inputs comprising the configuration request to perform the generic configuration operation implemented by the services with respect to the requested database name of the database type and generic configuration operation associated with the configuration interface associated with the invoked service.

15. The system of claim 12, wherein the configuration requests called by the application include database create configuration requests indicating a database name and database type to create, wherein determining one of the configuration interfaces for the database create configuration request comprises determining one configuration interface that is invoked to create a database having the database name of the database type indicated in the database create configuration request.

16. The system of claim 12, wherein the configuration requests called by the application include table create configuration requests indicating a table name to create, a database name in which to create a table having the requested table name, and a database type of the database name, wherein determining one of the configuration interfaces for the table create configuration request comprises determining one configuration interface operation that is invoked to create a table having the table name in the database name of the database type indicated in the table create configuration request.

17. The system of claim 12, wherein the configuration requests called by the application include version upgrade configuration requests indicating a data base element to upgrade, a version upgrade, a database name in which to upgrade the database element to the version upgrade, and a database type, wherein determining one of the configuration interfaces for the version upgrade configuration request comprises determining one configuration interface that is invoked to upgrade the database element to the version upgrade for the database type indicated in the version upgrade configuration request.

18. The system of claim 11, wherein the configuration requests called by the application include validation configuration requests indicating a database element to validate, a database name to be validated, and a database type of the database name, wherein determining one of the configuration interfaces for the validation configuration request comprises determining one validation configuration interface that is invoked to validate the database element for the database name of the database type indicated in the validation create configuration request.

19. The system of claim 18, wherein the determined database element to validate for use during runtime operations includes at least one of a password, database name, and database drivers.

20. The system of claim 11, wherein the database types include databases from different vendors having different database formats and configurations.

21. An article of manufacture comprising a computer readable storage device storing code executed to configure resources for databases of different database types for applications, wherein the code causes operations, the operations comprising:

maintaining configuration interfaces for a plurality of different database types, wherein each configuration interface implements a database configuration operation with respect to one of the databases of one database type;

maintaining a configuration request mapping providing configuration mappings, each configuration mapping indicating a configuration request name and at least one of the configuration interfaces for a database type to invoke to perform a configuration operation associated with the configuration request name for the database type, wherein configuration mappings are provided for different database types to perform the configuration operation associated with one configuration request name;

receiving a configuration request from the application indicating a configuration request name, database type, database name, and a generic database configuration operation not specific to a particular database type;

determining the configuration mapping in the configuration request mapping having a database type and configuration request name matching the requested database type and the configuration request name for the requested generic database configuration operation to implement the requested configuration operation with respect to the database having the database name;

determining the configuration interface for the determined configuration mapping and

invoking the determined configuration interface with the requested database name to perform the requested configuration operation with respect to the database name.

22. The article of manufacture of claim 21, wherein the configuration interfaces implement build time configuration operations to configure database resources for the database accessible to applications during runtime operations.

23. The article of manufacture of claim 22, wherein the applications executing in a runtime environment access the built database resources to access and perform operations with respect to the databases of the different database types.

24. The article of manufacture of claim 22, wherein the operations further comprise:

publishing services associated with the configuration interfaces that are called by the applications directly as a service for the database types; and

invoking, by the applications, the services with inputs comprising the configuration request to perform the requested generic configuration operation implemented by the services with respect to the requested database name of the database type and generic configuration operation associated with the configuration interface associated with the invoked service.

25. The article of manufacture of claim 22, wherein the configuration requests called by the application include database create configuration requests indicating a database name and database type to create, wherein determining one of the configuration interfaces for the database create configuration request comprises determining one configuration interface that is invoked to create a database having the database name of the database type indicated in the database create configuration request.

26. The article of manufacture of claim 22, wherein the configuration requests called by the application include table create configuration requests indicating a table name to create, a database name in which to create a table having the requested table name, and a database type of the database name, wherein determining one of the configuration interfaces for the table create configuration request comprises determining one configuration interface operation that is invoked to create a table having the table name in the database name of the database type indicated in the table create configuration request.

27. The article of manufacture of claim 22, wherein the configuration requests called by the application include version upgrade configuration requests indicating a database element to upgrade, a version upgrade, a database name in which to upgrade the database element to the version upgrade, and a database type, wherein determining one of the configuration interfaces for the version upgrade configuration request comprises determining one configuration interface that is invoked to upgrade the database element to the version upgrade for the database type indicated in the version upgrade configuration request.

28. The article of manufacture of claim 21, wherein the configuration requests called by the application include validation configuration requests indicating a database element to validate, a database name to be validated, and a database type of the database name, wherein determining one of the configuration interfaces for the validation configuration request comprises determining one validation configuration interface that is invoked to validate the database element for the database name of the database type indicated in the validation create configuration request.

29. The article of manufacture of claim 28, wherein the determined database element to validate for use during runtime operations includes at least one of a password, database name, and database drivers.

30. The article of manufacture of claim 21, wherein the database types include databases from different vendors having different database formats and configurations.