Revenue sharing system with data filtering using history, periodic, and exclusion databases

• US 5,623,662 A
• Filed: 01/09/1996
• Issued: 04/22/1997
• Est. Priority Date: 12/15/1993
• Status: Expired due to Term

• Current Assignee: comScore, Inc.
• Original Assignee: Supercom SA
• Inventors: McIntosh, Matthew S.
• Primary Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US08/583,862
• Time in Patent Office: 469 Days
• Field of Search: 395/600
• US Class Current: 707/703
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03
• CPC Class Codes: Y10S 707/959 Network
• CPC Class Codes: Y10S 707/99955 Archiving or backup

Abstract

A method and system for extracting revenue information from a point-of-sale (POS) terminal for purposes of revenue sharing including the step of periodically selecting and extracting predetermined portions of revenue transaction data in a proprietary database. This system allows extrapolation of select data relating to revenue traffic in a rental system. Revenue stored in a proprietary database (40) by a proprietary point-of-sale operating program is periodically selected, extracted and stored in a periodic database (42). This data is compared to a history database (38) comprising the periodic database as it existed prior to a given time. The data is output from the periodic database that is not present in the history database at the given time. This data can be transmitted to a remote location. The proprietary point-of-sale operating program can be used to create a history report database from the revenue transaction data and the portions of the revenue transaction data can be selected and extracted from the history report database.

Claims

1. A method for accessing revenue transaction data from a proprietary database created by a proprietary program to selectively extract the revenue transaction data therefrom, the revenue transaction data having a unique format associated therewith, comprising the steps of:

periodically selecting and extracting predetermined and fixed portions of the revenue transaction data from the proprietary database at given times in accordance with a selection template that defines the predetermined portions in an operation that is independent of the operation of the proprietary program, which fixed portions constitute a predetermined type of data that can be updated by the proprietary program and which given times occur after processing of data by the proprietary program and creation or updating of the fixed portions of the proprietary database;

storing as a periodic database the selected predetermined portions of the revenue transaction data;

generating and storing a history database comprising the periodic database as it existed prior to each of the given times;

comparing the periodic database at the given time to the history database;

outputting as output data only the data in the periodic database that is not present in the history database at the given time; and

providing an exclusion database containing information corresponding to undesired data and outputting only the data in the periodic database that is not present in the history database and which does not correspond to the information in the exclusion database.

2. The method of claim 1 and further comprising the step of transmitting the output data to a remote location.

3. The method of claim 2 wherein the step of transmitting comprises transmitting the output data via a public telephone network.

4. The method of claim 1 wherein the step of periodically selecting occurs in response to a predetermined instruction that is executed during the operation of the proprietary program that generates the proprietary database.

5. The method of claim 4 wherein the predetermined instruction comprises the instruction that is executed when the proprietary program that generates the proprietary database is exited.

6. The method of claim 1 wherein the step of periodically selecting occurs at each of a number of predetermined times.

7. The method of claim 1 wherein the step of periodically selecting occurs in response to a menu selection from the proprietary program used to generate the proprietary database.

8. The method of claim 1 wherein the step of periodically selecting first translates the selected portions of the revenue transaction data to a second unique format and then selects the translation.

9. The method of claim 8 wherein the step of storing as a periodic data base the selected predetermined portions of the revenue transaction data further comprises storing the selected predetermined portions in the second unique format.

10. The method of claim 1 wherein the predetermined portions of the revenue transaction data include bar code, title, last rental date, turns and revenue.

11. A method for accessing revenue transaction data from a proprietary database created by a proprietary program to selectively extract the revenue transaction data therefrom, the revenue transaction data having a unique format associated therewith, comprising the steps of:

creating a history report database from the revenue transaction data using the proprietary program that created the revenue transaction proprietary database;

periodically selecting and extracting predetermined and fixed portions of the revenue transaction data from the history report database at given times in accordance with a selection template that defines the predetermined portions and in an operation that is independent of the operation of the proprietary program, which fixed portions constitute a predetermined type of data that can be updated by the proprietary program and which given times occur after processing of data by the proprietary program and creation or updating of the fixed portions of the proprietary database;

storing as a periodic database the selected predetermined portions of the history report database;

generating and storing a history database comprising the periodic database as it existed prior to each of the given times;

comparing the periodic database at the given time to the history database;

outputting as output data only the data in the periodic database that is not present in the history database at the given time; and

providing an exclusion database containing information corresponding to undesired data and outputting only the data in the periodic database that is not present in the history database and which does not correspond to the information in the exclusion database.

12. The method of claim 11 and further comprising the step of transmitting the output data to a remote location.

13. The method of claim 12 wherein the step of transmitting comprises transmitting the output data via a public telephone network.

14. The method of claim 11 wherein the step of periodically selecting occurs in response to a predetermined instruction that is executed during the operation of the proprietary program that generates the proprietary database.

15. The method of claim 14 wherein the predetermined instruction comprises the instruction that is executed when the proprietary program that generates the revenue proprietary database is exited.

16. The method of claim 11 wherein the step of periodically selecting occurs at each of a number of predetermined times.

17. The method of claim 11 wherein the step of periodically selecting occurs in response to a menu selection from the proprietary program used to generate the proprietary database.

18. The method of claim 11 wherein the step of periodically selecting first translates the selected portions of the revenue transaction data to a second unique format and then selects the translation.

19. The method of claim 18 wherein the step of storing as a periodic database the selected predetermined portions of the revenue transaction data further comprises storing the selected predetermined portions in the second unique format.

20. The method of claim 11 wherein the predetermined portions of the transaction data include bar code, title, last rental date, turns and revenue.

21. A system for accessing revenue transaction data from a proprietary database created by a proprietary program to selectively extract the revenue transaction data therefrom, the revenue transaction data having a unique format associated therewith, comprising:

a selection and extraction device for periodically selecting and extracting predetermined and fixed portions of the revenue transaction data from the proprietary database at given times in accordance with a selection template that defines the predetermined portions in an operation that is independent of the operation of the proprietary program, which fixed portions constitute a predetermined type of data that can be updated by the proprietary program and which given times occur after processing of data by the proprietary program and creation or updating of the fixed portions of the proprietary database;

a first storage device for storing as a periodic database said selected predetermined portions of the revenue transaction data;

a first processing device for generating a history database comprising said periodic database as it existed prior to each of the given times;

a second storage device for storing said history database;

a second processing device for comparing said periodic database at the given time to said history database and outputting as output data only said data in the periodic database that is not present in said history database at the given time; and

an exclusion database containing information corresponding to undesired data and outputting only the data in said periodic database that is not present in said history database and which does not correspond to the information in said exclusion database.

22. The system for accessing revenue transaction data of claim 21, further comprising a transmitting device for transmitting said output data to a remote location.

23. The system for accessing revenue transaction data of claim 22, wherein said transmitting device transmits said output data via a public telephone network.

24. The system for accessing revenue transaction data of claim 21, wherein said selection and extraction device operates in response to a predetermined instruction that is executed during the operation of the proprietary program that generates the proprietary database.

25. The system of claim 24 wherein said predetermined instruction comprises the instruction that is executed when the proprietary program that generates the proprietary database is exited.

26. The system for accessing revenue transaction data of claim 21, wherein said selection and extraction device operates at each of a number of predetermined times.

27. The system for accessing revenue transaction data of claim 21, wherein said selection and extraction device operates in response to a menu selection from the proprietary program used to generate the proprietary database.

28. The system for accessing revenue transaction data of claim 21, wherein said selection and extraction device first translates said selected portions of the revenue transaction data to a second unique format and then selects said translation.

29. The system for accessing revenue transaction data of claim 28, wherein said first storage device stores said selected predetermined portions in a second unique format.

30. The system for accessing revenue transaction data of claim 21, wherein the predetermined portions of the revenue transaction data include bar code, title, last rental date, turns and revenue.

31. A system for accessing revenue transaction data from a proprietary database created by a proprietary program to selectively extract the revenue transaction data therefrom, the revenue transaction data having a unique format associated therewith, comprising:

a history report database created from the revenue transaction data by the proprietary program;

a selection and extraction device for periodically selecting and extracting predetermined and fixed portions of the revenue transaction data from said history report database at given times in accordance with a selection template that defines said predetermined portions in an operation that is independent of the operation of the proprietary program, which fixed portions constitute a predetermined type of data that can be updated by the proprietary program and which given times occur after processing of data by the proprietary program and creation or updating of the fixed portions of the proprietary database;

a first storage device for storing as a periodic database said selected predetermined portions of said history report database;

a first processing device for generating a history database comprising said periodic database as it existed prior to each of the given times;

a second storage device for storing said history database;

a second processing device for comparing said periodic database at the given time to said history database and outputting as output data only the data in said periodic database that is not present in said history database at the given time; and

an exclusion database containing information corresponding to undesired data and outputting only data in said periodic database that is not present in said history database and which does not correspond to the information in said exclusion database.

32. The system for accessing revenue transaction data of claim 31, further comprising a transmitting device for transmitting said output data to a remote location.

33. The system for accessing revenue transaction data of claim 32, wherein said transmitting device transmits said output data via a public telephone network.

34. The system for accessing revenue transaction data of claim 31, wherein said selection and extraction device operates in response to a predetermined instruction that is executed during the operation of the proprietary program that generates the proprietary database.

35. The system of claim 34 wherein said predetermined instruction comprises the instruction that is executed when the proprietary program that generates the proprietary database is exited.

36. The system for accessing revenue transaction data of claim 31, wherein said selection and extraction device operates at each of a number of predetermined times.

37. The system for accessing revenue transaction data of claim 31, wherein the selection and extraction device operates in response to a menu selection from the proprietary program used to generate the proprietary database.

38. The system for accessing revenue transaction data of claim 31, wherein said selection and extraction device first translates said selected portions of the revenue transaction data to a second unique format and then selects the translation.

39. The system for accessing revenue transaction data of claim 31, wherein said first storage device stores said selected predetermined portions in a second unique format.

40. The system for accessing revenue transaction data of claim 31, wherein said predetermined portions of said revenue transaction data include bar code, title, last rental date, turns and revenue.