Method and an apparatus to define loyalty promotions

• US 20070239521A1
• Filed: 09/15/2004
• Published: 10/11/2007
• Est. Priority Date: 09/15/2004
• Status: Abandoned Application

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Oracle America, Inc. (Oracle Corporation)
• Inventors: Viswanathan, Rahul, Chau, Victor, Khadpe, Bhushan, Wo, Zhaogang, Thekkatte, Prakash
• Application Number:
  US10/942,293
• Publication Number:
  US 20070239521A1
• Time in Patent Office: Days
• US Class Current: 715/764
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G06Q 30/0226 Incentive systems for frequent usage, e.g. frequent flyer miles programs or point systems

Abstract

A method and an apparatus to define loyalty programs have been disclosed. In one embodiment, the method includes generating a graphical user interface (GUI) to allow a user to input information for defining a loyalty program (LP), wherein the information includes a name of the LP, a start date, an end date, a plurality of loyalty promotions, a plurality of attributes, a plurality of criteria, and a plurality of actions to be performed, receiving the information from the user, defining a plurality of rules based on the plurality of criteria and the plurality of actions, and defining the plurality of loyalty promotions using the information and the plurality of rules.

Claims

1. A method comprising:

generating a graphical user interface (GUI) to allow a user to input information for defining a loyalty program (LP), wherein the information includes a name of the LP, a start date, an end date, a plurality of attributes, a plurality of loyalty promotions, a plurality of criteria, and a plurality of actions to be performed;

receiving the information from the user;

defining a plurality of rules based on the plurality of criteria and the plurality of actions; and

defining the plurality of loyalty promotions using the information and the plurality of rules.

2. The method of claim 1, further comprising:

storing the plurality of rules in a database; and

mapping the plurality of attributes to a plurality of entries in one or more tables stored in the database, the one or more tables being associated with the LP.

3. The method of claim 2, wherein the one or more tables include at least one of a transaction table, a member table, and a tier table.

4. The method of claim 3, wherein the one or more tables are expandable.

5. The method of claim 2, further comprising:

generating a first user interface control to allow the user to activate one of the plurality of loyalty promotions; and

notifying a loyalty processing engine (LPE) upon the user activating the loyalty promotion to cause the LPE to load the plurality of rules from the database into a cache of a server and to apply the plurality of rules to transactions occurred between the start date and the end date, wherein the LPE is a server component running on the server.

6. The method of claim 5, further comprising:

using the LPE to query the database for records of the transactions after the loyalty promotion has been activated.

7. The method of claim 6, further comprising:

using the LPE to determine whether transactions associated with a member of the LP meet one or more of the plurality of criteria; and

performing one or more of the plurality of actions based on the plurality of rules if the transactions meet the one or more of the plurality of criteria.

8. The method of claim 5, further comprising:

generating a second user interface control to allow the user to deactivate the loyalty promotion; and

notifying the LPE upon the user deactivating the loyalty promotion to cause the LPE to remove the plurality of rules from the cache of the server.

9. The method of claim 2, wherein the plurality of rules comprises one or more promotion rules, wherein members of the LP are transferred to different tiers based on the one or more promotion rules.

10. The method of claim 1, wherein generating the GUI comprises:

generating a plurality of fields in the GUI, wherein each of the plurality of fields is operable to receive from the user one of the plurality of attributes or a constant value.

11. A machine-accessible medium that stores instructions which, if executed by a processor, will cause the processor to perform operations comprising:

generating a graphical user interface (GUI) to allow a user to input information for defining a loyalty program (LP), wherein the information includes a name of the LP, a start date, an end date, a plurality of loyalty promotions, a plurality of attributes, a plurality of criteria, and a plurality of actions to be performed;

receiving the information from the user;

defining a plurality of rules based on the plurality of criteria and the plurality of actions; and

defining the LP using the information and the plurality of rules.

12. The machine-accessible medium of claim 11, wherein the operations further comprise:

storing the plurality of rules in a database; and

mapping the plurality of attributes to a plurality of entries in one or more tables stored in the database, the one or more tables being associated with the LP.

13. The machine-accessible medium of claim 12, wherein the one or more tables include at least one of a transaction table, a member table, and a tier table.

14. The machine-accessible medium of claim 13, wherein the one or more tables are expandable.

15. The machine-accessible medium of claim 12, wherein the operations further comprise:

generating a first user interface control to allow the user to activate one of the plurality of loyalty promotions; and

notifying a loyalty processing engine (LPE) upon the user activating the loyalty promotion to cause the LPE to load the plurality of rules from the database into a cache of a server and to apply the plurality of rules to transactions occurred between the start date and the end date, wherein the LPE is a server component running on the server.

16. The machine-accessible medium of claim 15, wherein the operations further comprise:

using the LPE to query the database for records of the transactions after the loyalty promotion has been activated.

17. The machine-accessible medium of claim 16, wherein the operations further comprise:

using the LPE to determine whether transactions associated with a member of the LP meet one or more of the plurality of criteria; and

performing one or more of the plurality of actions based on the plurality of rules if the transactions meet the one or more of the plurality of criteria.

18. The machine-accessible medium of claim 15, wherein the operations further comprise:

generating a second user interface control to allow the user to deactivate the loyalty promotion; and

notifying the LPE upon the user deactivating the LP to cause the LPE to remove the plurality of rules from the cache of the server.

19. The machine-accessible medium of claim 12, wherein the plurality of rules comprises one or more promotion rules, wherein members of the LP are transferred to different tiers based on the one or more promotion rules.

20. The machine-accessible medium of claim 11, generating the GUI comprises:

generating a plurality of fields in the GUI, wherein each of the plurality of fields is operable to receive from the user one of the plurality of attributes or a constant value.

21. A system comprising:

a database to store a plurality of transaction records;

a client machine operable to generate a graphical user interface (GUI) to allow a user to input information to define a loyalty program (LP), the information including a name of the LP, a start date, an end date, a plurality of loyalty promotions, a plurality of attributes, a plurality of criteria, and a plurality of actions to be performed, wherein a plurality of rules defined using the plurality of criteria and the plurality of actions are stored in the database; and

a server coupled between the client machine and the database, the server comprising at least one loyalty processing engine (LPE) operable to apply the plurality of rules to one or more of the plurality of transaction records retrieved from the database.

22. The system of claim 21, wherein the server further comprises a cache.

23. The system of claim 22, wherein the GUI further comprises a first user interface control to allow the user to activate one of the plurality of loyalty promotions.

24. The system of claim 23, wherein the LPE is operable to load the plurality of rules from the database into the cache after the loyalty promotion has been activated.

25. The system of claim 24, wherein the GUI further comprises a second user interface control to allow the user to deactivate the loyalty promotion.

26. The system of claim 25, wherein the LPE is operable to remove the plurality of rules from the cache after the loyalty promotion has been deactivated.

27. An apparatus comprising:

a graphical user interface (GUI) to allow a user to enter information for defining a loyalty program (LP), the information including a name of the LP, a start date, an end date, a plurality of loyalty promotions, a plurality of criteria, and a plurality of actions to be performed, wherein a plurality of rules are defined using the plurality of criteria and the plurality of actions; and

a first user interface control to allow the user to activate one of the plurality of loyalty promotions to cause a loyalty processing engine (LPE) to retrieve a plurality of transaction records from a database, to apply the plurality of rules to the plurality of transaction records, and to perform one or more of the plurality of actions if the plurality of transaction records meet the corresponding criteria.

28. The apparatus of claim 27, wherein the GUI comprises a plurality of fields to receive one of a plurality of attributes or a constant value.

29. The apparatus of claim 27, further comprising a second user interface control to allow the user to deactivate the loyalty promotion.