System and method for copying data
First Claim
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.
1 Assignment
0 Petitions
Accused Products
Abstract
The present invention relates to a system and method for copying data between environments in an information management system such as the copying of business data between production and test environments in a database system. The system has a relations database with a set of relations created outside the runtime environment which are derived from a first database and which provide a link between database tables in the first database. The system also has a service generator which extracts and copies database tables at runtime to form a predetermined service or product. When the service generator receives a request to copy a product or service, this is done only if the data in the database tables comprising the product or service is the subject of one or more relation in the relations database.
6 Citations
22 Claims
-
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, wherein the 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 Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. A method for copying data from a production environment to a test environment in an information management system, the method comprising:
-
creating 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 relations database is created outside a runtime environment; generating services by extracting and copying database tables at runtime to form a predetermined service or product, wherein upon receiving a request to copy data from the production environment to create a product or service in the test environment, a check is made of the relations database to determine whether the database tables within the product or service to be created by the service generator are indexed in the relations database and copies in the data to generate the product or service only if data in the database tables comprising the product or service is the subject of one or more relation as contained within the relations database including; a. wherein, one or more type of relation is present in the relations database, 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 Dependent Claims (13, 14, 15, 16, 17, 18, 19, 20, 21, 22)
-
Specification