 |
| |
BUSINESS ISSUE...
|
|
There are two major reasons for extracting production data :
- To rapidly construct a set of representative test data,
- To reproduce an error in production.
|
|
| Extracting data manually is not an option: either you retrieve the full database and run into disk space problems and excessive processing times, or you extract file by file. This can give rise to worse data integrity issues. |
Click to enlarge
|
THE ARCAD SOLUTION...
The Extract module solves this problem by building extraction queries that respect referential integrity. The system relies on the use of database links, stored in the ARCAD repository, that are also used to produce the database diagrams in the ARCAD-Observer suite. This is an example of the added value of the integrated architecture of the ARCAD suites. Disk space requirements are estimated and the queries are run as often as necessary. The data itself can be downloaded onto a given system or onto a remote partition.
|
ADVANTAGES...
Result : stable disk space and improved productivity in reproducing bugs. The user-friendly GUI makes Extract simple to implement and exceptionally easy to use.
|
|
