US6253203B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Privacy-enhanced database
Assignee: NCR Voyix Corp
•
Filing: 1998-10-02
•
Granted: 2001-06-26
•
Expires: 2018-10-02
Abstract
Abstract A method, apparatus, article of manufacture, and a memory structure for storing and retrieving data in a database implementing privacy control is disclosed. The apparatus comprises a data storage device, storing a database table comprising a plurality of data columns an at least one data control column for storing data control information reflecting consumer privacy parameters, wherein the database table comprises an identity segment for storing identity information and a personal information segment for storing personal information, and a processor, operatively coupled to the data storage device, the processor implementing a dataview suite for presenting data retrieved from the database table in accordance with the data control information. The method comprises the steps of extending a database table comprising a plurality of data columns to include at least one data control column for storing data control information reflecting at least one consumer privacy parameter, string identity information about the consumer in an identity segment of the database table and personal information about the consumer in a personal information segment of the database table, receiving a data request from a requesting entity having data privileges, and providing the data to the requesting entity via a dataview selected in accordance with the requesting entity's data privileges, the dataview masking the data in accordance with the consumer privacy parameter. The program storage device comprises a medium for storing instructions performing the method steps outlined above.
Inventors
- 👤 Kenneth W. O'Flaherty
- 👤 Richard G. Stellwagen, Jr.
- 👤 Todd A. Walter
- 👤 Reid M. Watts
- 👤 David A. Ramsey
- 👤 Adriaan W. Veldhuisen
- 👤 Renda K. Ozden
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-27 19:14
CPC Classifications
G; G06; G06Q; G06Q30/00; G06Q30/02; G06F; G06F21/00; G06F21/60; G06F21/62; G06F21/6218; G06F21/6245; G06F2221/00; G06F2221/21; G06F2221/2101; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99933; Y10S707/99939; Y10S707/99941; Y10S707/99943
Claims Analysis
Total Claims: 24
Claim 1
Independent Claim
106 words
A data warehousing, management, and privacy control system, comprising: a data storage device, storing a database table comprising a plurality of data columns and at least one data control column, the data control column for storing data control information reflecting consumer privacy parameters; wherein the database table comprises an identity segment for storing identity information and a personal information segment for storing personal information; and a processor, operatively coupled to the data storage device, the processor implementing a dataview suite for presenting data retrieved from the database table in accordance with the data control information, wherein the dataview suite comprises an anonymizing dataview masking identity information.
Claim 2
Dependent Claim
106 words
A data warehousing, management, and privacy control system, comprising: a data storage device, storing a database table comprising a plurality of data columns and at least one data control column, the data control column for storing data control information reflecting consumer privacy parameters; wherein the database table comprises an identity segment for storing identity information and a personal information segment for storing personal information; and a processor, operatively coupled to the data storage device, the processor implementing a dataview suite for presenting data retrieved from the database table in accordance with the data control information, wherein the dataview suite comprises an anonymizing dataview masking identity information.
Claim 3
Dependent Claim
25 words
The apparatus of claim 1 , wherein the dataview suite further comprises a privileged view permitting access to all data in the data base table.
Claim 4
Dependent Claim
20 words
The apparatus of claim 2 , wherein the privileged view further permits alteration of data in the data control columns.
Claim 5
Dependent Claim
16 words
The apparatus of claim 1 , wherein the dataview suite comprises a view masking personal information.
Claim 6
Dependent Claim
31 words
The apparatus of claim 1 , further comprising a customer interface module providing access to the database table via the privileged view and to permit specification of the consumer privacy parameters.
Claim 7
Dependent Claim
24 words
The apparatus of claim 5 , wherein the communications between the customer and the client interface module are implemented through a privacy data card.
Claim 8
Dependent Claim
20 words
The apparatus of claim 1 , further comprising an audit interface module for logging all accesses to the database table.
Claim 9
Dependent Claim
20 words
The apparatus of claim 1 , wherein the audit interface module logs all access to dataviews in the dataview suite.
Claim 10
Dependent Claim
32 words
The apparatus of claim 1 , wherein the database table comprises a plurality of data columns for storing personal data and a data control column for each data column storing personal data.
Claim 11
Independent Claim
117 words
A method of retrieving data in a database implementing privacy control, comprising the steps of: extending a database table comprising a plurality of data columns to include at least one data control column for storing data control information reflecting at least one consumer privacy parameter; storing identity information about the consumer in an identity segment of the database table and personal information about the consumer in a personal information segment of the database table; receiving a data request from a requesting entity having data privileges; and providing the data to the requesting entity via a dataview selected in accordance with the requesting entity's data privileges, the dataview masking the data in accordance with the consumer privacy parameter.
Claim 12
Independent Claim
117 words
A method of retrieving data in a database implementing privacy control, comprising the steps of: extending a database table comprising a plurality of data columns to include at least one data control column for storing data control information reflecting at least one consumer privacy parameter; storing identity information about the consumer in an identity segment of the database table and personal information about the consumer in a personal information segment of the database table; receiving a data request from a requesting entity having data privileges; and providing the data to the requesting entity via a dataview selected in accordance with the requesting entity's data privileges, the dataview masking the data in accordance with the consumer privacy parameter.
Claim 13
Dependent Claim
84 words
The method of claim 10 , wherein the step of providing the data to the requesting entity via a dataview comprises the steps of: providing a dataview to the requesting entity in accordance with the requesting entity's data privileges; retrieving the data according to the dataview provided to the requesting entity by translating the data request into an database query that selectively pulls columns and rows directly from a base table into a result table; and providing the result table to the requesting entity.
Claim 14
Dependent Claim
16 words
The method of claim 10 , wherein the dataview is an anonymizing view masking identity information.
Claim 15
Dependent Claim
15 words
The method of claim 10 , wherein the dataview is a view masking personal information.
Claim 16
Dependent Claim
22 words
The method of claim 10 , wherein the dataview is a privileged view permitting access to all data in the database table.
Claim 17
Dependent Claim
16 words
The method of claim 10 , wherein the dataview is established using unextended database table names.
Claim 18
Dependent Claim
139 words
A program storage device, readable by a computer, embodying one or more instructions executable by the computer to perform method steps for retrieving data in a database implementing privacy control, the method steps comprising the steps of: extending a database table comprising a plurality of data columns to include at least one data control column for storing data control information reflecting at least one consumer privacy parameter; storing identity information about the consumer in an identity segment of the database table and personal information about the consumer in a personal information segment of the database table; receiving a data request from a requesting entity having data privileges; and providing the data to the requesting entity via a dataview selected in accordance with the requesting entity's data privileges, the dataview masking the data in accordance with the consumer privacy parameter.
Claim 19
Dependent Claim
139 words
A program storage device, readable by a computer, embodying one or more instructions executable by the computer to perform method steps for retrieving data in a database implementing privacy control, the method steps comprising the steps of: extending a database table comprising a plurality of data columns to include at least one data control column for storing data control information reflecting at least one consumer privacy parameter; storing identity information about the consumer in an identity segment of the database table and personal information about the consumer in a personal information segment of the database table; receiving a data request from a requesting entity having data privileges; and providing the data to the requesting entity via a dataview selected in accordance with the requesting entity's data privileges, the dataview masking the data in accordance with the consumer privacy parameter.
Claim 20
Dependent Claim
88 words
The program storage device of claim 16 , wherein the method step of providing the data to the requesting entity via a dataview comprises the method steps of: providing a dataview to the requesting entity in accordance with the requesting entity's data privileges; retrieving the data according to the dataview provided to the requesting entity by translating the data request into an database query that selectively pulls columns and rows directly from a base table into a result table; and providing the result table to the requesting entity.
Claim 21
Dependent Claim
18 words
The program storage device of claim 16 , wherein the dataview is an anonymizing view masking identity information.
Claim 22
Dependent Claim
17 words
The program storage device of claim 16 , wherein the dataview is a view masking personal information.
Claim 23
Dependent Claim
24 words
The program storage device of claim 16 , wherein the dataview is a privileged view permitting access to all data in the database table.
Claim 24
Dependent Claim
18 words
The program storage device of claim 10 , wherein the dataview is established using unextended database table names.
References Cited (Backward Citations)
US5319777A
Cited
US5809483A
Cited
US5855008A
Cited
US6195657B1
Cited
US6141658A
Cited
US6085191A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2004-06-25 | 2004-12-25 | 2005-06-26 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2008-06-25 | 2008-12-25 | 2009-06-26 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2012-06-25 | 2012-12-25 | 2013-06-26 | $7700.00 | Window Closed / Lapsed |