×

System and method for copying data

  • US 9,946,778 B2
  • Filed: 09/09/2011
  • Issued: 04/17/2018
  • Est. Priority Date: 09/09/2010
  • Status: Active Grant
First Claim
Patent Images

1. A computer hardware based system for copying data from a production environment to a test environment in an information management system, the system comprising:

  • a storage device storing a relations database comprising a set of relations derived from a first database in the production environment, said relations providing a link between database tables in the first database, wherein the storage device storing the relations database is created outside a runtime environment;

    a service generator which extracts and loads database tables at runtime to form a predetermined service or product, whereinthe service generator, upon receiving a request to copy production environment data to create a product or service to be tested in the test environment, checks the storage device storing the relations database to determine whether the database tables within the product or service which are to be created by the service generator are indexed in the storage device storing the relations database and copies production environment data, only if data in the database tables comprising the product or service is a subject of one or more relation as contained within the storage device storing the relations database and wherein, one or more type of relation is present in the storage device storing the relations database, including;

    a. a referential integrity relation in which database tables are related as referential integrity parent and child such that data from both parent and child tables will be extracted;

    b. which database tables form a database service; and

    c. which database services form a product service.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×