Method and apparatus for dynamic discovery of data model allowing customization of consumer applications accessing privacy data

• US 6,438,544 B1
• Filed: 10/01/1999
• Issued: 08/20/2002
• Est. Priority Date: 10/02/1998
• Status: Expired due to Term

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: NCR Corporation (NCR Voyix Corporation)
• Inventors: Chapra, John Mark, Grimmer, Francine G.
• Primary Examiner(s): Corrielus, Jean M.
• Assistant Examiner(s): To, Baoquoc N
• Application Number:
  US09/410,533
• Time in Patent Office: 1,054 Days
• Field of Search: 707/3, 707/4, 707/5, 707/10, 707/103, 707/100, 707/102, 707/9, 707/2, 713/201, 713/202, 709/3, 709/9, 709/10, 706/47
• US Class Current: 707/600
• CPC Class Codes: G06F 16/24573 using data annotations, e.g. user-defined metadata
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries
• CPC Class Codes: G06F 21/6245 Protecting personal data, e.g. for financial or medical purposes
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99939 Privileged access

Abstract

To address the requirements described above, the present invention discloses a method, apparatus, and article of manufacture for providing access and accepting changes to personal information stored in a data warehouse. The method comprises the steps of accepting a privacy information request from a client, retrieving privacy metadata describing the selected privacy information, translating the privacy information request to a data warehouse-compliant query using the privacy information metadata, and transmitting the query to the data warehouse. The apparatus comprises a program storage device tangibly embodying instructions for performing the method steps above. The apparatus comprises a privacy metadata subsystem, communicatively coupled to a data warehouse for retrieving privacy metadata and a consumer access subsystem communicatively coupled to the data warehouse and the privacy metadata subsystem. The consumer access subsystem accepts a request for privacy information from the client, translates the request to a data warehouse-compliant query, transmits the query to the data warehouse, and forwards data responsive to the query to the client.

Claims

1. A method of providing access to privacy information stored in at least one privacy table stored in a data warehouse and disseminable according to at least one privacy rule, comprising the steps of:

accepting a privacy information request from a client, the privacy information selected from the group comprising personal data and at least one privacy preference;

retrieving privacy metadata describing the selected privacy information;

translating the privacy information request into a data warehouse-compliant query using the privacy information metadata; and

transmitting the query to the data warehouse.

2. The method of claim 1, further comprising the steps of:

receiving personal data responsive to the query from the data warehouse; and

transmitting the personal data to the client.

3. The method of claim 1, wherein the privacy metadata includes information describing the privacy rule, the privacy table, and attributes associated with the personal data.

4. The method of claim 1, wherein the step of retrieving privacy metadata describing the selected privacy information comprises the steps of:

connecting to a privacy metadata subsystem communicatively coupled to a metadata repository storing the privacy metadata in the data warehouse; and

retrieving the privacy metadata in the privacy metadata subsystem from the metadata repository in the data warehouse; and

providing the privacy metadata to a consumer access server.

5. The method of claim 4, wherein the step of accepting a privacy information request comprises the steps of:

accepting a privacy information request in a consumer access application executing at a client; and

calling a consumer access application program interface in a consumer access server having access to the privacy metadata subsystem from the consumer access application.

20. The method of claim 1, further comprising the steps of:

receiving a message responsive to the command from the data warehouse; and

transmitting the message to the client.

6. An apparatus for providing access to privacy information stored in at least one privacy table stored in a data warehouse and disseminable according to at least one privacy rule, comprising:

means for accepting a privacy information request selected from a group comprising personal data and at least one privacy preference;

means for retrieving privacy metadata describing the selected privacy information;

means for translating the privacy information request into a data warehouse-compliant query using the privacy information metadata; and

means for transmitting the query to the data warehouse.

7. The apparatus of claim 6, further comprising:

means for receiving personal data responsive to the query from the data warehouse; and

means for transmitting the personal data to the client.

8. The apparatus of claim 6, wherein the privacy metadata includes information describing the privacy rule, the privacy table, and attributes associated with the personal data.

9. The apparatus of claim 6, wherein the step of retrieving privacy metadata describing the selected privacy information comprises the steps of:

means for connecting to a privacy metadata subsystem communicatively coupled to a metadata repository storing the privacy metadata in the data warehouse; and

means for retrieve the privacy metadata in the privacy metadata subsystem from the metadata repository in the data warehouse; and

means for providing the privacy metadata to a consumer access server.

10. The apparatus of claim 9, wherein the step of accepting a privacy information request comprises:

means for accepting a privacy information request in a consumer access application executing at a client; and

means for calling a consumer access application program interface in a consumer access server having access to the privacy metadata subsystem from the consumer access application.

11. A program storage device, readable by a computer, tangibly embodying at least one program of instructions executable by the computer to perform method steps of providing access to privacy information stored in at least one privacy table stored in a data warehouse and disseminable according to at least one privacy rule, the method comprising the steps of:

accepting a privacy information request selected from a group comprising personal data and at least one privacy preference;

retrieving privacy metadata describing the selected privacy information;

translating the privacy information request into a data warehouse-compliant query using the privacy information metadata; and

transmitting the query to the data warehouse.

12. The program storage device of claim 11, further comprising the steps of:

receiving personal data responsive to the query from the data warehouse;

transmitting the personal data to the consumer access application via the consumer access subsystem.

13. The program storage device of claim 11, wherein the privacy metadata includes information describing the privacy rule, the privacy table, and attributes associated with the personal data.

14. The program storage device of claim 11, wherein the step of retrieving privacy metadata describing the selected privacy information comprises the steps of:

connecting to a privacy metadata subsystem communicatively coupled to a metadata repository storing the privacy metadata in the data warehouse;

retrieve the privacy metadata in the privacy metadata subsystem from the metadata repository in the data warehouse; and

providing the privacy metadata to a consumer access server.

15. The program storage device of claim 14, wherein the step of accepting a privacy information request comprises the steps of:

accepting a privacy information request in a consumer access application executing at a client; and

calling a consumer access application program interface in a consumer access server having access to the privacy metadata subsystem from the consumer access application.

16. An apparatus for providing access to privacy information stored in at least one privacy table stored in a data warehouse and disseminable according to at least one privacy rule to a client, the apparatus comprising:

a privacy metadata subsystem, communicatively coupled to the data warehouse, for retrieving privacy metadata from the data warehouse;

a consumer access subsystem communicatively coupled to the data warehouse and the privacy metadata subsystem, for accepting a privacy information request from a client, the privacy information selected from a group comprising personal data and at least one privacy preference, for translating the privacy information request into a data warehouse compliant query using privacy information metadata retrieved from the privacy metadata system, and for transmitting the query to the data warehouse.

17. The apparatus of claim 16, wherein the consumer access subsystem further receives personal data responsive to the query from the data warehouse and transmits the personal data to the client.

18. The apparatus of claim 17, wherein the consumer access subsystem comprises:

a consumer access application program interface, communicatively coupleable with the client, for accepting the privacy information request from the client and for transmitting the personal data responsive to the query to the client; and

a consumer access server, communicatively coupled to the consumer access application program interface and the data warehouse, for translating the privacy information request into the data warehouse compliant query using privacy information metadata received from the privacy metadata system, and for transmitting the query to the data warehouse.

19. A method of accepting changes to privacy information stored in at least one privacy table stored in a data warehouse and disseminable according to at least one privacy rule, comprising the steps of:

accepting a privacy information change request from a client, the privacy information selected from the group comprising personal data and privacy preferences;

retrieving privacy metadata describing the selected privacy information;

translating the privacy information request into a data warehouse-compliant command using the privacy information metadata; and

transmitting the command to the data warehouse.

21. An apparatus for accepting changes to privacy information stored in at least one privacy table stored in a data warehouse and disseminable according to at least one privacy rule, comprising the steps of:

means for accepting a privacy information change request from a client, the privacy information selected from the group comprising personal data and privacy preferences;

means for retrieving privacy metadata describing the selected privacy information;

means for translating the privacy information request into a data warehouse-compliant command using the privacy information metadata; and

means for transmitting the command to the data warehouse.

22. The apparatus of claim 21, further comprising the steps of:

receiving a message responsive to the command from the data warehouse; and

transmitting the message to the client.

23. A program storage device, readable by a computer, tangibly embodying at least one program of instructions executable by the computer to perform method steps of accepting changes to privacy information stored in at least one privacy table stored in a data warehouse and disseminable according to at least one privacy rule, the method steps comprising the steps of

accepting a privacy information change request from a client, the privacy information selected from the group comprising personal data and privacy preferences;

retrieving privacy metadata describing the selected privacy information;

translating the privacy information request into a data warehouse-compliant command using the privacy information metadata; and

transmitting the command to the data warehouse.

24. The program storage device of claim 23, wherein the method further comprises the method steps of:

receiving a message responsive to the command from the data warehouse; and

transmitting the message to the client.