Abstract: The invention relates to a method and apparatus for recording and maintaining stored information system object relationship information. Information contained within a stored information system (including system catalogs, referential constraints, triggers, table hierarchies, column references, indexes, stored program packages, system catalogs, stored procedures, stored queries, log/trace files of dynamically executed code, etc.) are searched to identify dependency relationships between objects. This object relationship information is stored and maintained in an information base. Information within the information based may be organized based upon subsets of objects that support a common application, service, or capability.

Abstract: A mechanism minimizes the management issues of the participant objects of the logical target set, such as an application set. The mechanism maps the current physical implementation. The mechanism then identifies the target and extraneous object set locations to facilitate isolation. Thereafter, the mechanism optimizes the logical target set placement for best manageability and performance. The mechanism minimizes the management issues by providing a small application footprint. This is accomplished by placing the object set on the fewest necessary volumes to facilitate both application performance and independence of administrative action.