Computer based system for monitoring and processing data collected at the point of sale of goods and services

• US 5,924,077 A
• Filed: 12/29/1995
• Issued: 07/13/1999
• Est. Priority Date: 12/29/1995
• Status: Expired due to Fees

• Current Assignee: Broadbase Analytics LLC
• Original Assignee: Broadbase Analytics LLC
• Inventors: Beach, David, George, Paul L., Meredith, Michael, Braden, Donald
• Primary Examiner(s): Tkacs, Stephen R.
• Application Number:
  US08/581,027
• Time in Patent Office: 1,292 Days
• Field of Search: 705/7, 705/10, 705/11, 705/16, 705/21, 705/24, 707/10, 707/101, 707/102, 707/104, 395/200.53, 395/200.54
• US Class Current: 705/7.29
• CPC Class Codes: G06Q 20/202 Interconnection or interaction of plural electronic cash registers [ECR] or to host computer, e.g. network details, transfer of information from host to ECR or from ECR to ECR
• CPC Class Codes: G06Q 30/0201 Market modelling; Market analysis; Collecting market data
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions
• CPC Class Codes: G07G 1/00 Cash registers alarm indicators G07G3/00
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation

Abstract

An electronic storage and computing system wherein raw point of sale data is transformed into a predefined standardized configuration from which object values representing select business activities are derived and compared to predefined reference values for the selected activities. The system includes an electronic storage device for storing raw point of sale data, a data interpreter for transforming the raw data into a predefined standardized configuration, and a processor for deriving object values from the transformed data according to a set of mathematical/relational functions, the object values being representative of selected business activities, and comparing the object values to predefined reference values for the selected business activities. The data interpreter operates according to a set of control programs to selectively transfer point of sale data from a set of raw databases into a set of standard databases having a predefined standardized configuration. The mathematical/relational functions are stored in a business rule execution database wherein each function defines an object value for each business activity. A business rule execution engine, which is operatively linked to the processor and the business rule execution database, allows the processor to compute the object values for each business activity according to the corresponding mathematical/relational function, compare the object values and the corresponding reference values, and identify a pass condition representative of an acceptable comparison, a fail condition representative of an unacceptable comparison, or a warn condition representative of a questionable comparison. The identified condition is outputted from the processor and displayed to the user.

Claims

1. A computer program product that can be used to direct a computer to monitor and process raw data collected by electronic point of sale terminals, the raw data being stored in a set of raw databases having a known configuration, the computer program product comprising:

a. a computer usable storage medium having computer readable program code embodied therein for monitoring and processing data collected by a plurality of point of sale terminals;

b. interpreter program code for causing the computer to transform raw databases into standard databases having a predefined standardized configuration; and

c. business rules program code for causing the computer to derive an object value from standard databases for each of one or more selected business activities and to compare the object values to corresponding predefined reference values for each selected business activity.

2. A computer program product according to claim 1, further comprising identification program code for causing the computer to identify a pass condition representative of an acceptable comparison, a fail condition representative of an unacceptable comparison, or a warn condition representative of a questionable comparison.

3. A computer program product according to claim 2, further comprising display program code for causing the computer to display the identified condition to a user.

4. A computer program product according to claim 1, wherein the interpreter program code comprises one or more control programs for causing the computer to selectively transfer raw data from the raw databases to the standard databases.

5. A computer program product according to claim 4, wherein the control programs contain information defining the configuration of the raw databases and the standard databases, each control program containing a part of the definition information, and the definition information having a first scheme representative of the configuration of the raw databases to allow the control programs to cause the computer to retrieve select raw data from the raw databases and a second scheme representative of the standard databases to allow the control programs to cause the computer to transfer data into the standard databases so that such data are accessible by the business rule program code.

6. A computer program product according to claim 5, wherein the interpreter program code further comprises configuration code for causing the computer to assign descriptions to select raw data, wherein the descriptions are used by the control programs to identify the raw data upon its transfer to the standard databases.

7. A computer program product according to claim 1, wherein the business rules program code comprises:

a. program code for causing the computer to store a set of mathematical/relational functions in a business rule execution database, wherein each mathematical/relational function defines an object value for each business activity;

b. program code for causing the computer to link a business rule execution engine to the business rule execution database and the standard databases, the business rule execution engine being configured therein to cause the computer to compute an object value for each business activity according to the corresponding mathematical/relational function and to compare the object values and the corresponding reference values.

8. A computer program product according to claim 7, wherein the business rule execution engine is further configured to identify a pass condition representative of an acceptable comparison, a fail condition representative of an unacceptable comparison, or a warn condition representative of a questionable comparison.

9. A computer program product according to claim 8, wherein the business rules execution engine comprises:

a. read means for causing the computer to read a record from the business rule execution database wherein each record contains one of the mathematical/relational functions and the corresponding reference value;

b. processor means for causing the computer to compute an object value in accordance with the mathematical/relational function;

c. comparison means for causing the computer to compare the object value to the reference value; and

d. identification means for causing the computer to identify the comparison of the object value to the reference value as a pass condition representative of an acceptable comparison, a fail condition representative of an unacceptable comparison, or a warn condition representative of a questionable comparison.

10. A computer program product according to claim 9, further comprising write means for causing the computer to write the object value to a summary database.

11. A computer program product according to claim 9, further comprising display means for causing the computer to alert the user to the comparison as a pass, fail or warn.

12. A computer program product according to claim 7, further comprising configuration program code for allowing the user to modify the mathematical/relational functions to re-define the relationship between the raw data and the business activities.

13. A computer system for monitoring and processing raw data collected by a plurality of electronic point of sale terminals, the system comprising:

a. a central processing unit (CPU);

b. storage means, electronically coupled to the CPU, for storing data, the storage means being partitioned into a plurality of memory partitions and wherein the raw data is stored in a first one of the memory partitions and a set of predefined reference values for selected business activities are stored in a second one of the memory partitions;

c. interpreter means, electronically coupled to the CPU, for transforming the raw data into one or more databases having a predefined standardized configuration and for storing the transformed data in a third one of the memory partitions;

d. computing means, electronically coupled to the CPU, for deriving object values from the transformed data, each object value being representative of one of the selected business activities; and

e. comparing means, electronically coupled to the CPU, for comparing object values and corresponding reference values.

14. A computer system according to claim 13, further comprising input means, electronically coupled to the CPU, for polling each of the electronic point of sale terminals and for storing raw data retrieved therefrom in the first one of the memory partitions.

15. A computer system according to claim 13, further comprising identification means, electronically coupled to the CPU, for identifying a pass condition representative of an acceptable comparison, a fail condition representative of an unacceptable comparison or a warn condition representative of a questionable comparison.

16. A computer system according to claim 15, further comprising output means, electronically coupled to the CPU, for outputting the identified condition.

17. A computer system according to claim 15, further comprising display means, electronically coupled to the CPU, for displaying the identified condition to a user.

18. A computer system for monitoring and processing raw data collected by electronic point of sale terminals, the raw data being stored in a set of raw databases having a known configuration, the system comprising:

a. a central processing unit (CPU);

b. a data interpreter, electronically coupled to the CPU, comprising means for transforming raw databases into standard databases having a predefined standardized configuration; and

c. a business rules subsystem, electronically coupled to the CPU and operative on the standard databases, comprising means for computing an object value for each of one or more select business activities and for comparing the object values and corresponding predefined reference values for each selected business activity.

19. A system according to claim 18, wherein the business rules subsystem further comprises means for identifying a pass condition representative of an acceptable comparison, a fail condition representative of an unacceptable comparison or a warn condition representative of a questionable comparison.

20. A system according to claim 19, further comprising display means, electronically coupled to the CPU, for displaying the identified condition to a user.

21. A system according to claim 18, wherein the data interpreter further comprises one or more computer control programs for selectively transferring raw data from the raw databases to the standard databases.

22. A computer system according to claim 21, wherein the control programs contain information defining the configuration of the raw databases and the standard databases, each control program containing a part of the definition information, and the definition information having a first scheme representative of the configuration of the raw databases to allow the control programs to retrieve select raw data from the raw databases and a second scheme representative of the standard databases to allow the control programs to transfer data into the standard databases so that such data are accessible for the business rules subsystem.

23. A computer system according to claim 21, wherein the data interpreter further comprises one or more configuration data files for assigning descriptions to select raw data, said descriptions being used by the control programs to identify the raw data upon its transfer to the standard databases.

24. A computer system according to claim 18, further comprising a storage means, electronically coupled to the CPU, for storing data, the storage means being partitioned into a plurality of memory partitions, a first one of the memory partitions having a directory structure therein for storing the raw databases according to the date on which the raw data was polled.

25. A computer system according to claim 18, further comprising a storage means, electronically coupled to the CPU, for storing data, the storage means being partitioned into a plurality of memory partitions, a first one of the memory partitions having a directory structure therein for storing the raw databases according to the store from which the raw data was polled.

26. A computer system according to claim 18, wherein the business rules subsystem further comprises:

a. a business rule execution database for storing a set of mathematical/relational functions, wherein each mathematical/relational function defines an object value for each business activity; and

b. a business rule execution engine linked to the business rule execution database and the standard databases, the business rule execution engine being adapted to (i) compute an object value for each business activity according to the corresponding mathematical/relational function, (ii) compare the object values and the corresponding reference values, and (iii) identify a pass condition representative of an acceptable comparison, a fail condition representative of an unacceptable comparison, or a warn condition representative of a questionable comparison.

27. A computer system according to claim 26, wherein the business rules execution engine comprises:

a. means for reading a record from the business rule execution database wherein each record contains one of the mathematical/relational functions and the corresponding reference value;

b. means for computing an object value in accordance with the mathematical/relational function;

c. means for comparing the object value to the reference value; and

d. means for identifying the comparison of the object value to the reference value as a pass condition representative of an acceptable comparison, a fail condition representative of an unacceptable comparison, or a warn condition representative of a questionable comparison.

28. A computer system according to claim 27, further comprising means for writing the object value to a summary database.

29. A computer system according to claim 27, further comprising means for alerting the user to the comparison as a pass, fail or warn.

30. A computer system for displaying anomalous business activities, comprising:

a. storage means for storing user data;

b. interpreter means operative on the user data for transforming the user data into a predefined standardized configuration; and

c. processing means operative on the transformed user data for processing the user data according to business rule functions, wherein object values representative of selected business activities are derived from the transformed user data, and for comparing the object values to predefined reference values for the selected business activities.

31. A computer system according to claim 30, further comprising identification means operatively coupled to the processing means for identifying one from the group consisting of a pass condition, the pass being representative of an acceptable comparison of the object value and the reference value, a fail condition, the fail condition being representative of an unacceptable comparison of the object value and the reference value, and a warn condition, the warn condition being representative of a questionable comparison of the object value and the reference value.

32. A computer system according to claim 31, further comprising display means operatively coupled to the identification means for displaying the identified condition to the user.

33. In an electronic database storage and computing system, a method for monitoring and processing raw data collected by electronic point of sale terminals, the raw data being stored in a set of raw databases having a known configuration, the method comprising the steps of:

a. selectively transferring raw data from the raw databases to standard databases having a predefined standardized configuration according to one or more computer control programs;

b. deriving one or more object values from standard databases, each object value being representative of a selected business activity;

c. defining reference values for each of the selected business activities;

d. comparing the object values to the corresponding reference values; and

e. wherein the computer control programs contain information that defines the configuration of the raw databases and the standard databases, each control program containing a part of the definition information and the definition information having a first scheme representative of the configuration of the raw databases to allow the control programs to cause the computer to retrieve select raw data from the raw databases and a second scheme representative of the standard databases to allow the control proarams to cause the computer to transfer data into the standard databases so that such data are accessible for deriving object values.

34. A method according to claim 33, further comprising the step of identifying a pass condition representative of an acceptable comparison, a fail condition representative of an unacceptable comparison, or a warn condition representative of a questionable comparison.

35. A method according to claim 34, further comprising the step of displaying the identified condition to a user.

36. A method according to claim 33, further comprising the steps of:

a. storing a set of mathematical/relational functions in a business rule execution database, wherein each mathematical/relational function defines an object value for each business activity; and

b. linking a business rule execution engine to the business rule execution database and the standard databases, the business rule execution engine being configured to cause the computer to compute an object value for each business activity according to the corresponding mathematical/relational function and to compare the object values and the corresponding reference values.

37. A method according to claim 36, further comprising the steps of:

a. reading a record from the business rule execution database wherein each record contains one of the mathematical/relational functions and the corresponding reference value; and

b. computing an object value in accordance with the mathematical/relational function.

38. A method according to claim 37, further comprising the step of writing the object value to a summary database.

39. A method according to claim 37, further comprising the step of identifying the comparison of the object value to the reference value as a pass condition representative of an acceptable comparison, a fail condition representative of an unacceptable comparison, or a warn condition representative of a questionable comparison.

40. A method according to claim 39, further comprising the step of alerting the user to the comparison as a pass, fail or warn.

41. A method for identifying and displaying anomalous business activities for business activities that are reflected in data collected at a point of sale of goods and services, the method using a programmable computer for performing the steps of:

a. storing user data collected at the point of sale;

b. processing the user data according to predefined business rule functions whereby the user data is transformed into object values for select business activities;

c. comparing the object values to predefined reference values for each selected business activity;

d. identifying one from the group consisting of a pass condition, the pass being representative of an acceptable comparison of the object value and the reference value, a fail condition, the fail condition being representative of an unacceptable comparison of the object value and the reference value, and a warn condition, the warn condition being representative of a questionable comparison of the object value and the reference value; and

e. displaying the identified condition to the user.