Abstract: Methods, apparatus, and computer program products are disclosed for optimizing a query to a database that includes identifying types of nodes in the database, identifying relationships among the types of nodes, and creating an access plan in dependence upon the types of nodes and the relationships among the types of nodes. Optimizing a query to a database may also include creating a representative node for each type. Optimizing a query to a database may also include identifying a relationship between a node of each type and a node of another type. Optimizing a query to a database may also include identifying a relationship between a node of each type and a node of the same type. Optimizing a query to a database may also include creating an access plan that excludes unrelated nodes.

Abstract: A computer implemented method, data processing system, and computer program product for enabling enterprise-wide queries by linking configuration management databases (CMDBs) together. A query and unique query key to access data stored in a CMDB is received. The query is processed against data internal to the CMDB. If the information is found from the query of the CMDB, the query results are sent to the requesting user. If the query does not produce any information from the CMDB, one or more infrastructure discovery tools registered with the CMDB are used to discover one or more compatible CMDBs in the enterprise. A communications link is established between the infrastructure discovery tools registered with the CMDB and the infrastructure discovery tools registered with the one or more compatible CMDBs. The query and the unique query key are then passed to the one or more compatible CMDBs via the communications link.