Granted Patent B2

US 7,054,891 · App. 10/100,518 · Granted May 30, 2006

Assignee: BMC Software, Inc.

Abstract

Claims (70)

1. A method executed by a computer system for comprising database data, comprising:

receiving a first determination by a user of first and second portions of database data, the first determination of the portions being specifiable by the user;

selecting the user-determined first portion of database data at a first time, the first portion comprising less than all the database data;

generating a first set of cyclical redundancy check values based directly on the first portion of database data;

selecting the user-determined second portion of database data at a second time, the second portion comprising less than all the database data;

generating second set of cyclical redundancy check values based directly on the second portion of database data;

comparing each cyclical redundancy check value in the first set of cyclical redundancy check values with a corresponding cyclical redundancy check value in the second set of cyclical redundancy check values;

receiving a second determination by a user of a first subset of the first portion and a second subset of the second portion of database data, the second determination of the subsets being specifiable by the user;

selecting the first subset of the first portion of database data;

selecting the second subset of the second portion of database data; and

displaying to the user the selected first and second subsets of database data along with differences between corresponding cyclical redundancy check values in the first and second sets.

2. The method of claim 1 , wherein the database data comprises an entire database.

3. The method of claim 2 , wherein the entire database comprises a plurality of database tables, each table having one or more rows and one or more columns.

4. The method of claim 3 , wherein the first and second portions comprise a column in one of the plurality of database tables.

5. The method of claim 3 , wherein the first and second portions comprise one of the plurality of database tables.

6. The method of claim 3 , wherein the first and second portions comprise a row in one of the plurality of database tables.

7. The method of claim 3 , wherein the first and second portions comprise one or more rows from a first table and one or more rows from a second table.

8. The method of claim 3 , wherein the first and second portions comprise one or more columns from a first table and one or more columns from a second table.

9. The method of claim 3 , wherein the first and second portions comprise one or more columns and one or more rows from one of the plurality of database tables.

10. The method of claim 3 , wherein the first and second portions comprise one or more columns and one or more rows from one or more of the plurality of database tables.

11. The method of claim 1 , wherein the first portion of database data comprises database data in a first database, and wherein the second portion of database data comprises database data in a second database.

12. The method of claim 11 , wherein the second database comprises a snapshot of the first database.

13. A system for comparing database data on a network, comprising:

a CPU coupled to the network;

a memory coupled to the CPU which stores the database data; and

a persistent memory coupled to the CPU, wherein the persistent memory stores one or more computer programs executable by the CPU;

wherein the computer programs are executable to:

receive a first determination by a user of first and second portions of database data, the first determination of the portions being specifiable by the user;

select the user-determined first portion of database data at a first time, the first portion comprising less than all the database data;

generate a first set of cyclical redundancy check values based directly on the first portion of database data;

select the user-determined second portion of database data at a second time, the second portion comprising less than all the database data;

generate a second set of cyclical redundancy check values based directly on the second portion of database data;

compare each cyclical redundancy check value in the first set of cyclical redundancy check values wit a corresponding cyclical redundancy check value in the second set of cyclical redundancy check values;

receive a second determination by a user of a first subset of the first portion and a second subset of the second portion of database data, the second determination of the subsets being specifiable by the user;

select the first subset of the first portion of database data;

select the second subset of the second portion of database data; and

display to the user the selected first and second subsets of database data along with differences between corresponding cyclical redundancy check values in the first and second sets.

14. The system of claim 13 , wherein the database data comprises an entire database.

15. The system of claim 14 , wherein the entire database comprises a plurality of database tables, each table having one or more rows and one or more columns.

16. The system of claim 14 , wherein the first and second portions comprise a column in one of the plurality of database tables.

17. The system of claim 14 , wherein the first and second portions comprise one of the plurality of database tables.

18. The system of claim 14 , wherein the first and second portions comprise a row in one of the plurality of database tables.

19. The system of claim 14 , wherein the first and second portions comprise one or more rows from a first table and one or more rows from a second table.

20. The system of claim 14 , wherein the first and second portions comprise one or more columns from a first table and one or more columns from a second table.

21. The system of claim 14 , wherein the first and second portions comprise one or more columns and one or more rows from one of the plurality of database tables.

22. The system of claim 14 , wherein the first and second portions comprise one or more columns and one or more rows from one or more of the plurality of database tables.

23. The system of claim 13 , wherein the first portion of database data comprises first data in a first database, and wherein the second portion of database data comprises second data in a second database.

24. The system of claim 23 , wherein the second database comprises a snapshot of the fast database.

25. A programmable storage device, readable by a programmable control device, comprising instructions stored thereon for causing the programmable control device to:

receive a first determination by a user of first and second portions of database data, the first determination of the portions being specifiable by the user;

select the user-determined first portion of database data at a first time, the first portion comprising less than all the database data;

generate first set of cyclical redundancy check values based directly on the first portion of database data;

select the user-determined second portion of database data at a second time, the second portion comprising less than all the database data;

generate a second set of cyclical redundancy check values based directly on the second portion of database data;

compare each cyclical redundancy check value in the first set of cyclical redundancy check values with a corresponding cyclical redundancy check value in the second set of cyclical redundancy check values;

receive a second determination by a user of a first subset of the first portion and a second subset of the second portion of database data, the second determination of the subsets being specifiable by the user;

select the first subset of the first portion of database data;

select the second subset of the second portion of database data; and

display to the user the selected first and second subsets of database data along with differences between corresponding cyclical redundancy check values in the first and second sets.

26. The programmable storage device of claim 25 , wherein the database data comprises an entire database.

27. The programmable storage device of claim 26 , wherein the entire database comprises a plurality of database tables, each table having one or more rows and one or more columns.

28. The programmable storage device of claim 26 , wherein the first and second portions comprise a column in one of the plurality of database tables.

29. The programmable storage device of claim 26 , wherein the first and second portions comprise one of the plurality of database tables.

30. The programmable storage device of claim 26 , wherein the first and second portions comprise a row in one of the plurality of database tables.

31. The programmable storage device of claim 26 , wherein the first and second portions comprise one or more rows from a first table and one or more rows from a second table.

32. The programmable storage device of claim 26 , wherein the first and second portions comprise one or more columns from a first table and one or more columns from a second table.

33. The programmable storage device of claim 26 , wherein the first and second portions comprise one or more columns and one or more rows from one of the plurality of database tables.

34. The programmable storage device of claim 26 , wherein the first and second portions comprise one or more columns and one or more rows from one or more of the plurality of database tables.

35. The programmable storage device of claim 25 , wherein the first portion of database data comprises database data in a first database, and wherein the second portion of database data comprises database data in a second database.

36. The programmable storage device of claim 35 , wherein the second database comprises a snapshot of the first database.

Assignments (11)

Continuity (1)