COMMON CONFIGURATION FRAMEWORK FOR APPLICATIONS TO CONFIGURE DATABASE OBJECTS AND RESOURCES

• US 20090063563A1
• Filed: 08/31/2007
• Published: 03/05/2009
• Est. Priority Date: 08/31/2007
• Status: Active Grant

• Current Assignee: ServiceNow Incorporated
• Original Assignee: International Business Machines Corporation
• Inventors: Xu, Weixin, Li, Wen Chao, Zhang, Kai Mike, Khangaonkar, Manoj
• Granted Patent: US 8,549,144 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• 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;

receiving a configuration request from an application indicating a database type, database name, and a database configuration operation;

determining 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; 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 the database name to perform the configuration operation implemented by the services with respect to the database name of the database type 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 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.

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 1, wherein the determined information 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:

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 program to perform operations, the operations including;

receiving a configuration request from one of the applications indicating a database type, database name, and a database configuration operation;

determining 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; 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 the database name to perform the configuration operation implemented by the services with respect to the database name of the database type 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 11, wherein the determined information 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 including code 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;

receiving a configuration request from the application indicating a database type, database name, and a database configuration operation;

determining 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; 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 the database name to perform the configuration operation implemented by the services with respect to the database name of the database type 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 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.

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 21, wherein the determined information 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.