Method and System for Sending Changes in Information to a Central System

• US 20080307010A1
• Filed: 06/05/2007
• Published: 12/11/2008
• Est. Priority Date: 06/05/2007
• Status: Abandoned Application

• Current Assignee: Snap-On Incorporated
• Original Assignee: Snap-On Incorporated
• Inventors: Moore, John, Cummins, Christopher, Cullison, Shelby
• Application Number:
  US11/758,563
• Publication Number:
  US 20080307010A1
• Time in Patent Office: Days
• US Class Current: 707/201
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Abstract

A method and system is disclosed for sending changes in information to a central system. The method includes providing a first database having a plurality of information tables for storing information and providing a second database for tracking changes to the information in the information tables of the first database. The second database may include a link table containing links corresponding to the information tables in the first database. The changes in the information tables may be periodically extracted from the first database by using the second database. The changes may be extracted via a link of the link table which corresponds to the information table where an information change occurred. The extracted changes may be sent to a central server.

Claims

1. A method for sending changes in information to a central system, the method comprising:

providing a first database and a second database, wherein the first database comprises a plurality of information tables, and wherein the second database comprises a link table containing at least one link corresponding to at least one of the information tables in the first database, wherein one link corresponds to one information table in the first database;

receiving changes in information in at least one information table of the first database;

tracking, in the second database, at least one change in the information received in the at least one information table of the first database;

extracting the at least one change via a link of the link table corresponding to the at least one information table; and

sending the at least one change to a central system.

2. The method of claim 1, wherein the second database further comprises at least one status table, and wherein tracking at least one change in the information comprises adding a status indicator to the at least one status table, wherein the status indicator indicates that an information change has occurred in the first database.

3. The method of claim 2, wherein the plurality of information tables have at least one field, wherein each respective field of an information table is associated with a respective unique primary key, and wherein the status indicator that indicates that an information change has occurred in the first database is associated with the unique primary key for the field of the information table that has been changed in the first database.

4. The method of claim 3, wherein extracting the at least one change from the second database comprises:

for each status indicator associated with a unique primary key for a field of the information table that has been changed in the first database, accessing the field of the information table that has been changed in the first database via the link in the link table of the second database; and

extracting the information from the field of the information table that has been changed.

5. The method of claim 1, wherein extracting the at least one change from the second database and sending the at least one change to a central system is performed on a periodic basis.

6. The method of claim 5, wherein the periodic basis is once a day.

7. The method of claim 5, wherein tracking at least one change in information comprises tracking at least one change in the information since a previous extraction from the second database that was successfully sent to the central system.

11. The method of claim 1, further comprising:

forming a markup language data file comprising the extracted at least one change; and

encrypting the markup language data file,

wherein sending the at least one change to the central system comprises sending the encrypted markup language data file to the central system.

12. A method of sending changes in information to a central system, wherein a plurality of entities send changes in information to the central system, wherein each entity carries out the method of claim 1.

8. The method of claim 8, wherein the information is vehicle information.

9. The method of claim 8, wherein tracking, in the second database, at least one change comprises tracking at least one change in at least one specific information table of the first database.

10. The method of claim 9, wherein the at least one specific information table of the first database is an information table for vehicle information selected from the group consisting of vehicle repair history, number of miles driven, trouble codes, and diagnostic procedures.

13. A method for sending changes in information to a central system, the method comprising:

providing a first database and a second database, wherein the first database comprises a plurality of information sections, wherein the second database comprises a link table containing at least one link corresponding to at least one information section in the first database, wherein one link corresponds to one information section in the first database, and wherein the second database further comprises at least one status table;

receiving changes in information in at least one information section of the first database;

tracking, in the second database, at least one change in the information received in the at least one information section of the first database by adding a status indicator to the at least one status table, wherein the status indicator indicates that an information change has occurred in the first database;

extracting periodically the at least one change via a link of the link table corresponding to the at least one information section; and

sending the at least one change to a central system.

14. The method of claim 13, wherein the information section is an information table.

15. A system for sending changes in information to a central system, the system comprising:

a processor;

data storage, wherein data storage comprises a first database and a second database, wherein the first database comprises information tables, and wherein the second database comprises a link table containing links to the information tables in the first database; and

machine language instructions stored in the data storage executable by the processor to;

(i) receive at least one change in information in at least one information table of a first database,

(ii) track the at least one change in the second database,

(iii) extract the at least one change via a link of the link table corresponding to the at least one information table, and

(iv) send the at least one change to a central system.

16. The system of claim 15, wherein the second database further comprises at least one status table, and wherein the machine language instructions stored in data storage executable by the processor are further executable to add a status indicator to the at least one status table when a change has been made in an information table of the first database.

17. The system of claim 15, wherein the information tables comprise at least one field, and wherein the status indicator is associated with a unique primary key, wherein the unique primary key is associated with a field in the information table.

18. The system of claim 15, wherein the machine language instructions stored in data storage are executable by the processor to extract the at least one change via a link of the link table on a periodic basis.

19. The system of claim 15, wherein the machine language instructions stored in data storage are executable by the process to track at least one change in the information since a previous extraction from the database that was successfully sent to the central system.

20. The system of claim 15, wherein the machine language instructions stored in data storage are operable to:

form a markup language data file comprising the extracted at least one change;

encrypt the markup language data file; and

send the encrypted markup language data file to the central system.