Patent ID: 7720884

Claim:
A method comprising: receiving master database schema information defining attributes of a master database for storing storage area network resource information; based on the master database schema information, initiating generation of staging database schema information associated with a staging database for storage of the storage area network resource information prior to being copied to the master database, the staging database including a subset of resources in the master database; and in accordance with the staging database schema information and the master database schema information, via a processor device in a computer system, initiating generation of a corresponding set of routines for managing the staging database; accessing a repository to obtain a definition of the master database; receiving input from a database manager specifying tables in the master database for replication and inclusion in the staging database, the staging database configured to at least temporarily store the storage area network resource information prior to the storage area network resource information being copied to the master database; based on master database schema information and the input from the database manager; generating staging database schema information that defines a relational storage structure associated with the staging database for temporarily storing the storage area network resource information; wherein generation of the corresponding set of routines comprises: generating the corresponding set of routines to include a set of callable database routines for use by a database manager application to manage storage of storage area network resource information in the staging database and the master database, the database manager application at least temporarily storing the storage area network resource information in the staging database schema for subsequent copying of the storage area network resource information from the staging database to the master database; and deriving the corresponding set of routines for managing the staging database based on the staging database schema.