System and method for implementing privacy preferences and rules within an e-business data warehouse

• US 7,533,113 B1
• Filed: 11/16/2001
• Issued: 05/12/2009
• Est. Priority Date: 11/16/2001
• Status: Active Grant

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: NCR Corporation (NCR Voyix Corporation)
• Inventors: Haddad, Sylvie Feghali
• Primary Examiner(s): AL HASHEMI, SANA A
• Application Number:
  US09/990,411
• Time in Patent Office: 2,734 Days
• Field of Search: 707/104.1, 707/9, 707/100, 707/2, 707/201, 705/51, 713/156, 709/217
• US Class Current: 1/1
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising

Abstract

A computer implemented method of and apparatus for collecting and managing customer related information within an E-Business customer relationship management system. The customer relationship management system includes a database in which customer-related information, as well as privacy policy and privacy consent information governing the collection and use of customer related information, is stored and organized. The database includes tables containing privacy consent default values for customers of the E-Business retailer high-level privacy consent values selected by the customers; specific privacy consent values selected by the customers for a plurality of privacy categories defined by the Platform for Privacy Preference (P3P); and privacy consent values selected by the customers for different customer addresses. In the situation where customer or potential customer include minor children, the database includes a database table containing parental privacy consent values for said children under thirteen years of age.

Claims

1. A database system for storing and managing information for an E-Business retailer, said information including information obtained from and about customers and potential customers of said E-Business retailer, said information being organized within said database system in accordance with a logical data model, said logical data model including:

a subject area including a plurality of entities and relationships defining the manner in which privacy policy and privacy consent information governing the collection and use of information from and about customers and potential customers by said E-Business retailer is stored and organized within a database;

wherein said subject area includes;

an entity including attributes relating to privacy consent default values for customers and potential customers of said E-Business retailer;

an entity including attributes relating to high-level privacy consent values selected by said customers and potential customers of said E-Business retailer;

an entity including attributes relating to privacy consent values selected by said customers and potential customers for a plurality of privacy categories defined by the Platform for Privacy Preference (P3P); and

an entity including attributes relating to privacy consent values selected by said customers and potential customers for different addresses of said customers and potential customers.

2. The database system in accordance with claim 1, wherein said customers and potential customers includes children under thirteen years of age, said subject area further including:

an entity including attributes relating to parental privacy consent values for said children under thirteen years of age.

3. The database system in accordance with claim 2, wherein said parental privacy consent values comprise Collection and Use Consent, Disclosure Consent and No Consent.

4. The database system in accordance with claim 1, wherein said privacy consent values selected by said customers and potential customers for different addresses of said customers and potential customers comprise:

different consent values for different postal mail addresses of a customer;

different consent values for different phone numbers of a customer; and

different consent values for different email addresses of a customer.

5. The database system in accordance with claim 1, said subject are further comprising:

an entity including attributes relating to a history of changes to said privacy consent default values for said customers and potential customers of said E-Business retailer;

an entity including attributes relating to a history of changes to said high-level privacy consent values selected by said customers and potential customers of said E-Business retailer;

an entity including attributes relating to a history of changes to said privacy consent values selected by said customers and potential customers for a plurality of privacy categories defined by the Platform for Privacy Preference (P3P); and

an entity including attributes relating to a history of changes to said privacy consent values selected by said customers and potential customers for different addresses of said customers and potential customers.

6. The database system in accordance with claim 2, said subject are further comprising:

an entity including attributes relating to a history of changes to said parental privacy consent values for said children under thirteen years of age.

7. A database system for storing and managing information for an E-Business retailer, said information including information obtained from and about customers and potential customers of said E-Business retailer, database system comprising:

a logical data model including a plurality of entities and relationships defining the manner in which privacy policy and privacy consent information governing the collection and use of information from and about customers and potential customers by said E-Business retailer is stored and organized within a database;

a database table within said database containing privacy consent default values for customers and potential customers of said E-Business retailer;

a database table within said database containing high-level privacy consent values selected by said customers and potential customers of said E-Business retailer;

a database table within said database containing privacy consent values selected by said customers and potential customers for a plurality of privacy categories defined by the Platform for Privacy Preference (P3P); and

a database table within said database containing privacy consent values selected by said customers and potential customers for different addresses of said customers and potential customers.

8. The database system in accordance with claim 7, wherein said customers and potential customers includes children under thirteen years of age, said database system further comprising:

a database table within said database containing parental privacy consent values for said children under thirteen years of age.

9. The database system in accordance with claim 7, further comprising:

a database table within said database containing a history of changes to said privacy consent default values for customers and potential customers of said E-Business retailer;

a database table within said database containing a history of changes to said high-level privacy consent values selected by said customers and potential customers of said E-Business retailer;

a database table within said database containing a history of changes to said privacy consent values selected by said customers and potential customers for a plurality of privacy categories defined by the Platform for Privacy Preference (P3P); and

a database table within said database containing a history of changes to said privacy consent values selected by said customers and potential customers for different addresses of said customers and potential customers.

10. The database system in accordance with claim 8, further comprising:

a database table within said database containing a history of changes to said parental privacy consent values for said children under thirteen years of age.

11. A customer relationship management system for storing and managing information for an E-Business retailer, said customer relationship management system comprising:

a database for storing and organizing information obtained from and about customers and potential customers of said E-Business retailer;

a logical data model defining the manner in which said information is stored and related within said database; and

a subject area within said logical data model including a plurality of entities and relationships defining the manner in which privacy policy and privacy consent information governing the collection and use of information from and about customers and potential customers by said E-Business retailer is stored and organized within a database;

wherein said subject area includes;

an entity including attributes relating to privacy consent default values for customers and potential customers of said E-Business retailer;

an entity including attributes relating to high-level privacy consent values selected by said customers and potential customers of said E-Business retailer;

an entity including attributes relating to privacy consent values selected by said customers and potential customers for a plurality of privacy categories defined by the Platform for Privacy Preference (P3P); and

an entity including attributes relating to privacy consent values selected by said customers and potential customers for different addresses of said customers and potential customers.

12. The customer relationship management system in accordance with claim 11, wherein said customers and potential customers includes children under thirteen years of age, said subject area further including:

an entity including attributes relating to parental privacy consent values for said children under thirteen years of age.

13. The customer relationship management system in accordance with claim 12, wherein said parental privacy consent values comprise Collection and Use Consent, Disclosure Consent and No Consent.

14. The customer relationship management system in accordance with claim 11, wherein said privacy consent values selected by said customers and potential customers for different addresses of said customers and potential customers comprise:

different consent values for different postal mail addresses of a customer;

different consent values for different phone numbers of a customer; and

different consent values for different email addresses of a customer.

15. A customer relationship management system for storing and managing information for an E-Business retailer, said customer relationship management system comprising:

a database for storing and organizing information obtained from and about customers and potential customers of said E-Business retailer;

a logical data model defining the manner in which said information is stored and related within said database, said logical data model including a plurality of entities and relationships defining the manner in which privacy policy and privacy consent information governing the collection and use of information from and about customers and potential customers by said E-Business retailer is stored and organized within said database;

a database table within said database containing privacy consent default values for customers and potential customers of said E-Business retailer;

a database table within said database containing high-level privacy consent values selected by said customers and potential customers of said E-Business retailer;

a database table within said database containing privacy consent values selected by said customers and potential customers for a plurality of privacy categories defined by the Platform for Privacy Preference (P3P); and

a database table within said database containing privacy consent values selected by said customers and potential customers for different addresses of said customers and potential customers.

16. The customer relationship management system in accordance with claim 15, wherein said customers and potential customers includes children under thirteen years of age, said customer relationship management system further comprising:

a database table within said database containing parental privacy consent values for said children under thirteen years of age.

17. The customer relationship management system in accordance with claim 15, further comprising:

a database table within said database containing a history of changes to said privacy consent default values for customers and potential customers of said E-Business retailer;

a database table within said database containing a history of changes to said high-level privacy consent values selected by said customers and potential customers of said E-Business retailer;

a database table within said database containing a history of changes to said privacy consent values selected by said customers and potential customers for a plurality of privacy categories defined by the Platform for Privacy Preference (P3P); and

a database table within said database containing a history of changes to said privacy consent values selected by said customers and potential customers for different addresses of said customers and potential customers.

18. The customer relationship management system in accordance with claim 16, further comprising:

a database table within said database containing a history of changes to said parental privacy consent values for said children under thirteen years of age.

19. A method for managing information for an E-Business retailer, said method comprising the steps of:

establishing a database for storing and organizing information obtained from and about customers and potential customers of said E-Business retailer; and

establishing a logical data model defining the manner in which said information obtained from and about said customers and potential customers is stored and related within said database; and

establishing within said logical data model a plurality of entities and relationships defining the manner in which privacy policy and privacy consent information governing the collection and use of information from and about said customers and potential customers by said E-Business retailer is stored and organized within a database;

wherein said plurality of entities includes;

an entity including attributes relating to privacy consent default values for customers and potential customers of said E-Business retailer;

an entity including attributes relating to high-level privacy consent values selected by said customers and potential customers of said E-Business retailer;

an entity including attributes relating to privacy consent values selected by said customers and potential customers for a plurality of privacy categories defined by the Platform for Privacy Preference (P3P); and

an entity including attributes relating to privacy consent values selected by said customers and potential customers for different addresses of said customers and potential customers.

20. The method in accordance with claim 19, wherein said customers and potential customers includes children under thirteen years of age, said plurality of entities further including:

an entity including attributes relating to parental privacy consent values for said children under thirteen years of age.

21. The method in accordance with claim 20, wherein said parental privacy consent values comprise Collection and Use Consent, Disclosure Consent and No Consent.

22. The method in accordance with claim 19, wherein said privacy consent values selected by said customers and potential customers for different addresses of said customers and potential customers comprise:

different consent values for different postal mail addresses of a customer;

different consent values for different phone numbers of a customer; and

different consent values for different email addresses of a customer.