METHOD AND SYSTEM FOR ANALYSIS OF DATABASE RECORDS

• US 20130024480A1
• Filed: 07/18/2011
• Published: 01/24/2013
• Est. Priority Date: 07/18/2011
• Status: Abandoned Application

• Current Assignee: Justin A. Okun, Michael Alan Gale
• Original Assignee: Justin A. Okun, Michael Alan Gale
• Inventors: Okun, Justin A., Gale, Michael Alan
• Application Number:
  US13/184,851
• Publication Number:
  US 20130024480A1
• Time in Patent Office: Days
• US Class Current: 707/802
• CPC Class Codes: G06F 11/324 Display of status information
• CPC Class Codes: G06F 11/3409 for performance assessment
• CPC Class Codes: G06F 11/3452 Performance evaluation by statistical analysis

Abstract

Method, system, and programs for analyzing data records, to easily identify problems with saved data, facilitate data retrieval and file report optimization. In an embodiment, the user is presented with a visual representation of the data records to alert the user of any problems, omissions, or errors in the data.

Claims

1. A method for analyzing data files on a management server having at least one processor, storage, and a communication platform, the method comprising:

retrieving data records from a database to the storage in the management server,

analyzing the retrieved records utilizing the at least one processor;

creating a map of the retrieved records utilizing the management server'"'"'s at least one processor;

displaying the map of the retrieved records to a user,

wherein the map visually indicates the status of the retrieved data records to be at least one of the following;

all records present, unexpected break in the records, missing records, records not requested, ignored records, no activity, and auditing information unavailable.

2. The method of claim 1 wherein the user selects to ignore the missing records.

3. The method of claim 1 further comprising the steps of

requesting missing data records stored in the database;

retrieving the missing data records from the database;

combining the retrieved records and the missing data records;

recreating the map based on the combining; and

redisplaying the map.

4. The method of claim 1 further comprising the steps of:

requesting previously un-requested records from a server via the communications platform;

receiving the previously un-requested records from the server via the communications platform;

storing the previously un-requested records in the database

combining the retrieved records and the previously un-requested records;

recreating the map based on the combining; and

redisplaying the map.

5. A machine readable non-transitory and tangible medium having information recorded thereon for analyzing data files on a management server having at least one processor, storage, and a communication platform, to causes the machine to perform the following:

retrieving data records from a database to the storage in the management server,

analyzing the retrieved records utilizing the at least one processor;

creating a map of the retrieved records utilizing the management server'"'"'s at least one processor;

displaying the map of the retrieved records to a user,

wherein the map visually indicates the status of the retrieved data records to be at least one of the following;

all records present, unexpected break in the records, missing records, records not requested, ignored records, no activity and auditing information unavailable.

6. The medium of claim 5 wherein the user can select to ignore the missing records.

7. The medium of claim 5 further comprising the steps of

requesting missing data records stored in the database;

retrieving the missing data records from the database;

combining the retrieved records and the missing data records;

recreating the map based on the combining; and

redisplaying the map.

8. The medium of claim 5 further comprising the steps of:

requesting previously un-requested records from a server via the communications platform;

receiving the previously un-requested records from the server via the communications platform;

storing the previously un-requested records in the database

9. A system for visually displaying the status of data records comprising:

a data management server for requesting data records via a communications link from a plurality of servers;

a memory for storing the data records from the plurality of servers; and

wherein the data management server processes the data records using a processor and generates a visual representation of the status of the requested data records for display on a user terminal.

10. The system of claim 9 wherein the data management server can request missing data records via the communications from the plurality of servers.

11. The system of claim 9 wherein a part of the data management server, the memory, and the plurality of servers may be implemented in a cloud computing environment.