|
|
|
|
| |
DBAZone
|
|
| |
Comparenicus is the only database tool to offer unique and innovative
solutions to common, yet unresolved DBA daily tasks.
Copy Selective Data from Production to Test DB
The Business Scenario
Often when a defect is found in a production system, it is essential to
reproduce it in a test environment. This requires copying the relevant
portions of the production database to a test database.
The Challenge
As stated above, the relevant production data needs to be copied to a
test database. This seemingly simple procedure, however, becomes
a complicated task for two reasons:
1. Most likely, the entire business ‘tree’ of objects needs to be copied
in order to reproduce the problem. For example, to test a problem found
in the ACCOUNT_TRANSACTIONS table you also need to copy the
relevant records from ACCOUNTS, CUSTOMERS, RATES, and other
related tables. Often, there can be as many as fifteen tables connected
to a single business 'tree'.
2. The records of the business 'tree' are connected through a myriad of
business relations (often expressed as foreign-keys) that are
cumbersome to track down manually. Sometimes, foreign-keys do not
even exist, which makes this an even more challenging task.
As a consequence, DBAs frequently resort to copying significant
portions of the production database to the test environment. Since
production databases are inherently large, the resulting mass
duplication of records has a negative impact on disk space, server CPU
usage and DBA workload.
The Solution
Comparenicus' innovative Relational Object Graph technology maps the
database relations and copies only the relevant records, starting from a
root entity and a single user-defined filter.
The solution is generic and flexible, yet intuitive and simple to use.
Copying a Customer and its related records to another database can
take you less than 30 seconds, assuming your database has relevant
foreign-keys defined. In the lack of foreign-keys, you can easily create
the equivalent ad-hoc relations (this may take you an additional two
minutes).
You can learn more about this innovative solution in the Copy Relational
Object Graph walk-through.
Compare and Sync of Large Tables
The Business Scenario
After copying data from one database to another (by simple DML
manipulation, export/import, advanced replication, etc), DBAs often want
to ensure the data integrity of the copied tables. This may be due to the
sensitivity of the data or the requirement to safeguard against process
malfunction or failure.
The Challenge
Verifying data integrity of database tables containing hundreds of
thousands of records (and more), requires a different approach than
the one used for smaller tables.
Using simple SQLs (such as Oracle's SELECT MINUS) is not effective
for larger table comparison, because:
- The client application cannot effectively display all of the table
records.
- Results are displayed only at the end of the query - after a
relatively long period of time.
- No query progress information is displayed – the application
appears to be 'stuck'.
- Handling of the differences that were found is tedious and
error-prone.
Consequently, most of the comparison tools on the market can handle
only tables of 20,000 records or less.
The Solution
Comparenicus provides a complete solution for the comparison and
synchronization of large tables:
- Tables of any size can be compared.
- Large tables are compared in the background.
- Differences between the tables are displayed as soon as they
are detected.
- Differences can be edited and saved to the database while
comparison is still in progress.
- Multiple large (and small) tables may be compared
simultaneously.
All of the above assures efficient and simplified handling of large tables.
To see relevant application screens, take the Large Tables walk-
through.
|
|
|
|
|
|
|