Patent ID: 7822714

Claim:
A computer implemented method for extending a configuration management database, the computer implemented method comprising: receiving input from a user to extend the configuration management database, wherein the input includes a generic data type; mapping the generic data type to a database data type of the configuration management database, wherein mapping the generic data type is performed using a data mapping algorithm which obtains the database data type for the configuration management database based on the generic data type and size provided in the input; generating an SQL statement to create the database data type in the configuration management database, wherein generating an SQL statement is performed using a minimal table creation algorithm, wherein the minimal table creation algorithm comprises: ordering attributes associated with the database data type by size from smallest to largest; adding sizes of the attributes from smallest to largest until a page limit size is met; placing attributes within the page size limit into a first table; and placing attributes falling outside the page size limit into a second table; and responsive to a successful execution of the SQL statement, updating tables in the configuration management database with the database data type to reduce a number of tables created for the database data type, wherein the configuration management database comprises core configuration management database extensible markup language schema plugins, internal extension extensible markup language schema plugins, and customer extension extensible markup language schema plugins, wherein the plugins are linked by a common extensible markup language file, wherein the common extensible markup language file comprises schema information for the configuration management database; and responsive to updating tables in the configuration management database, updating the common extensible markup language file to include the database data type.