METHOD AND SYSTEM FOR AUDITING TRANSACTION DATA FROM DATABASE OPERATIONS

• US 20100318858A1
• Filed: 06/15/2009
• Published: 12/16/2010
• Est. Priority Date: 06/15/2009
• Status: Active Grant

• Current Assignee: VeriSign, Inc.
• Original Assignee: VeriSign, Inc.
• Inventors: Chigurupati, Nageswararao, Essawi, Tarik R.
• Granted Patent: US 8,510,263 B2
• Time in Patent Office: Days
• US Class Current: 714/49
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A method for validating SRS registry transaction data includes receiving OLTP transaction data from a first database, parsing the OLTP transaction data, and comparing the parsed OLTP transaction data to one or more of a set of profiles. Each of the one or more of the set of profiles includes metadata in XML files. The method also includes caching the parsed OLTP transaction data in a first data cache, receiving log data associated with the OLTP transaction data; and caching the log data in a second data cache. The method further includes correlating the parsed transaction data cached in the first data cache with the log data cached in the second data cache.

Claims

1. A method for validating SRS registry transaction data, the method comprising:

receiving OLTP transaction data from a first database;

parsing the OLTP transaction data;

comparing the parsed OLTP transaction data to one or more of a set of profiles, wherein each of the one or more of the set of profiles comprises metadata in XML files;

caching the parsed OLTP transaction data in a first data cache;

receiving log data associated with the OLTP transaction data;

caching the log data in a second data cache; and

correlating the parsed transaction data cached in the first data cache with the log data cached in the second data cache.

2. The method of claim 1 further comprising:

determining a validation error; and

generating an alert related to the validation error.

3. The method of claim 2 wherein generating an alert comprises generating at least one report including the validation error.

4. The method of claim 3 wherein the at least one report comprises a detail report.

5. The method of claim 1 wherein the first database comprises an SRS registry database.

6. The method of claim 1 wherein the OLTP transaction data comprises transaction data associated with at least one of adding a domain name, deleting a domain name, or renewing a domain name.

7. The method of claim 6 wherein the set of profiles include profiles for at least one of adding a domain name, deleting a domain name, or renewing a domain name.

8. The method of claim 1 wherein the OLTP transaction data comprises transaction data associated with at least one of adding a domain name server, deleting a domain name server, or modifying a domain name server.

9. The method of claim 8 wherein the set of profiles include profiles for at least one of adding a domain name server, deleting a domain name server, or modifying a domain name server.

10. A method for validating transaction data, the method comprising:

receiving the transaction data from a first database;

parsing the transaction data;

comparing the parsed transaction data to one or more of a set of profiles;

receiving log data associated with the transaction data; and

correlating the parsed transaction data with the log data.

11. The method of claim 10 wherein the transaction data comprises online transaction processing data.

12. The method of claim 10 wherein each of the set of profiles comprises metadata.

13. The method of claim 12 wherein the metadata is provided in an XML file.

14. The method of claim 10 further comprising caching the parsed transaction data prior to correlating the parsed transaction data with the log data.

15. The method of claim 10 further comprising caching the log data prior to correlating the parsed transaction data with the log data.

16. The method of claim 10 further comprising determining a validation error.

17. The method of claim 16 further comprising providing at least one report based on the validation error.

18. A system for validating transaction data associated with an SRS registry database with transaction log files stored in a transaction log database, the system comprising:

a database reader operable to receive OLTP transaction data from the SRS registry database and parse the OLTP transaction data;

a database data validator coupled to the database reader and operable to compare the parsed OLTP transaction data with one or more of a set of profiles;

a transaction log file reader operable to receive transaction log files from the transaction log database; and

a data correlator coupled to the database data validator and the transaction log file reader and operable to correlate the parsed transaction data with the transaction log files.

19. The system of claim 18 wherein each of the one or more of the set of profiles comprises metadata in XML files.

20. The system of claim 18 further comprising a first data cache coupled to the database data validator.

21. The system of claim 18 further comprising a second data cache coupled to the transaction log file reader.

22. The system of claim 18 further comprising a report generator coupled to the data correlator.

23. A computer-readable medium storing a plurality of instructions for controlling a data processor to validate transaction data, the plurality of instructions comprising:

instructions that cause the data processor to receive the transaction data from a first database;

instructions that cause the data processor to parse the transaction data;

instructions that cause the data processor to compare the parsed transaction data to one or more of a set of profiles;

instructions that cause the data processor to receive log data associated with the transaction data; and

instructions that cause the data processor to correlate the parsed transaction data with the log data.

24. The computer-readable medium of claim 23 wherein the transaction data comprises online transaction processing data.

25. The computer-readable medium of claim 23 wherein each of the set of profiles comprises metadata.

26. The computer-readable medium of claim 25 wherein the metadata is provided in an XML file.

27. The computer-readable medium of claim 23 further comprising instructions that cause the data processor to cache the parsed transaction data prior to correlating the parsed transaction data with the log data.

28. The computer-readable medium of claim 23 further comprising instructions that cause the data processor to cache the log data prior to correlating the parsed transaction data with the log data.

29. The computer-readable medium of claim 23 further comprising instructions that cause the data processor to determine a validation error.

30. The computer-readable medium of claim 29 further comprising instructions that cause the data processor to provide at least one report based on the validation error.