US6438544B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for dynamic discovery of data model allowing customization of consumer applications accessing privacy data
Assignee: Teradata US Inc
•
Filing: 1999-10-01
•
Granted: 2002-08-20
•
Expires: 2019-10-01
Abstract
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.
Inventors
- 👤 Francine G. Grimmer
- 👤 John Mark Chapra
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-07 10:21
CPC Classifications
G; G06; G06F; G06F21/00; G06F21/60; G06F21/62; G06F21/6218; G06F21/6245; G06F16/00; G06F16/20; G06F16/24; G06F16/245; G06F16/2457; G06F16/24573; G06F21/6227; G06Q; G06Q30/00; G06Q30/02; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99933; Y10S707/99935; Y10S707/99939
Claims Analysis
Total Claims: 31
Claim 1
Independent Claim
88 words
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.
Claim 2
Independent Claim
88 words
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.
Claim 3
Dependent Claim
30 words
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.
Claim 4
Dependent Claim
26 words
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.
Claim 5
Dependent Claim
70 words
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.
Claim 6
Dependent Claim
58 words
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.
Claim 7
Independent Claim
87 words
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.
Claim 8
Independent Claim
87 words
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.
Claim 9
Dependent Claim
31 words
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.
Claim 10
Dependent Claim
26 words
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.
Claim 11
Dependent Claim
76 words
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.
Claim 12
Dependent Claim
59 words
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.
Claim 13
Dependent Claim
106 words
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.
Claim 14
Dependent Claim
106 words
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.
Claim 15
Dependent Claim
38 words
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.
Claim 16
Dependent Claim
28 words
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.
Claim 17
Dependent Claim
71 words
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.
Claim 18
Dependent Claim
60 words
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.
Claim 19
Independent Claim
124 words
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.
Claim 20
Independent Claim
124 words
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.
Claim 21
Dependent Claim
31 words
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.
Claim 22
Dependent Claim
94 words
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.
Claim 23
Independent Claim
86 words
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.
Claim 24
Independent Claim
86 words
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.
Claim 25
Dependent Claim
29 words
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.
Claim 26
Independent Claim
94 words
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.
Claim 27
Independent Claim
94 words
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.
Claim 28
Dependent Claim
29 words
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.
Claim 29
Dependent Claim
111 words
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.
Claim 30
Dependent Claim
111 words
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.
Claim 31
Dependent Claim
35 words
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.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2005-08-19 | 2006-02-18 | 2006-08-20 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2009-08-19 | 2010-02-18 | 2010-08-20 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2013-08-19 | 2014-02-18 | 2014-08-20 | $7700.00 | Window Closed / Lapsed |