Privacy-enhanced database
DCFirst Claim
1. 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.
10 Assignments
Litigations
0 Petitions
Accused Products
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.
-
Citations
21 Claims
-
1. 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. 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. - View Dependent Claims (11, 12, 13, 14, 15, 21)
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.
-
-
12. The method of claim 10, wherein the dataview is an anonymizing view masking identity information.
-
13. The method of claim 10, wherein the dataview is a view masking personal information.
-
14. The method of claim 10, wherein the dataview is a privileged view permitting access to all data in the database table.
-
15. The method of claim 10, wherein the dataview is established using unextended database table names.
-
21. The program storage device of claim 10, wherein the dataview is established using unextended database table names.
-
16. 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. - View Dependent Claims (17, 18, 19, 20)
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.
-
-
18. The program storage device of claim 16, wherein the dataview is an anonymizing view masking identity information.
-
19. The program storage device of claim 16, wherein the dataview is a view masking personal information.
-
20. The program storage device of claim 16, wherein the dataview is a privileged view permitting access to all data in the database table.
Specification