Protecting confidential data with math

Dec 16, 2011

Statistical databases (SDBs) are collections of data that are used to gather and analyze information from a variety of sources. The data may be derived from sales transactions, customer files, voter registrations, medical records, employee rosters, product inventories, or other compilations of facts and figures.

Because database security requires multiple processes and controls, it presents huge security challenges to organizations. With the computerization of databases in healthcare, forensics, telecommunications, and other fields, ensuring this kind of security has become increasingly important.

In a paper published Thursday in the SIAM Journal on Discrete Mathematics, authors Rudolf Ahlswede and Harout Aydinian analyze a security-control model for statistical databases.

"Providing privacy and confidentiality in SDBs is not a new issue," Aydinian points out. "Privacy interests have evolved from the very first census in the United States. Recorded protests until the mid-20th century reflect constitutional issues resulting from the requirement for U.S. residents to provide sensitive personal information. Questions on census forms about diseases, mortgage values, and other items have raised many concerns."

While such databases are very helpful in aggregating data, there is a risk that confidential information about an individual's record may be deliberately compromised. "Since such data sets also contain sensitive information, such as the disease of an individual, or the salary of an employee, it is necessary to provide security against the disclosure of confidential information," says Aydinian. "Even in cases where a user has no direct access to sensitive information, sometimes about an individual can be inferred by correlating enough statistics."

Typically, statistical databases are designed to only accept queries that involve specific statistical functions (such as sum, average, count, min, max, etc.). However, the use of these queries may render databases susceptible to compromise. For instance, it may be possible to infer information about specific individuals by putting together data from a sequence of statistical queries, using prior knowledge of an individual, or through collusion among users.

An SDB is considered secure if no protected data can be inferred from available queries. "In the literature, many scenarios of compromise and inference control methods have been proposed to protect SDBs," Aydinian says. "However, to date no one security control method is capable of completely preventing compromise."

Query restriction is one of several general approaches used for security control. A "query request" retrieves a subset of data from a database that meets a set of conditions. In query restriction, the kind and amount of data that can be retrieved by such queries is limited, for example, the size of the data, or the amount of overlap between data that is returned.

In one type of query restriction method, only certain sums of individual records (called "SUM queries") that meet a minimum specified size or number, and satisfy a specified set of conditions, are available to users.

Aydinian explains with an example. "Consider a company with a large number of employees. Suppose that for each member of the company, the sex, age, rank, length of employment, salary etc. is recorded. The salaries of individual employees are confidential. Suppose that only SUM queries are allowed, i.e. the sum of the salaries of the specified people is returned. Then one might pose the query: What is the sum of salaries for males, above 50, and during the last 10 years?"

The task addressed in the paper is to provide an optimal collection of SUM queries that prevents compromise of confidential information—such as individual salaries, for instance. A natural solution is to maximize the number of available SUM queries. The authors obtain tight bounds for the maximum number of such queries that return subsets of data without compromising groups of entries.

"Future work in the query-restriction approach includes evaluation of new security-control mechanisms, which are easy to implement and guarantee absolute security," says Aydinian. "At the same time, it is desirable that these methods satisfy other criteria like richness of available queries, consistency, cost etc. It also seems promising to develop methods combining different security control mechanisms."

Explore further: Math journal puts Rauzy fractcal image on the cover

More information: On Security of Statistical Databases. Rudolf Ahlswede and Harout Aydinian, SIAM Journal on Discrete Mathematics, 25, pp 1778-1791 (Online publish date: December 15, 2011)

Related Stories

Google queries and stock market volumes related

Nov 15, 2010

Financial markets and the 'swarm intelligence' of the internet are linked. This is the result of a joint study in which search engine query data are analyzed by Tobias Preis and Daniel Reith of Johannes Gutenberg University ...

Classic grammar model can be used for computerised parsing

May 31, 2010

A classic Nordic grammar model can be used for computerised grammatical analyses and technical applications of modern Swedish text, shows a new thesis in the field of language technology from the University of Gothenburg, ...

Recommended for you

History books spark latest Texas classroom battle

21 minutes ago

As Texas mulls new history textbooks for its 5-plus million public school students, some academics are decrying lessons they say exaggerate the influence of Christian values on America's Founding Fathers.

Flatow, 'Science Friday' settle claims over grant

36 minutes ago

Federal prosecutors say radio host Ira Flatow and his "Science Friday" show that airs on many National Public Radio stations have settled civil claims that they misused money from a nearly $1 million federal ...

'Hidden Treasure of Rome' project unveiled

1 hour ago

For more than a century, hundreds of thousands of historical artifacts dating back to before the founding of Rome have been stored in crates in the Capitoline Museums of Rome, where they have remained mostly untouched. Now, ...

Poverty rate drops for the first time since 2006

2 hours ago

The poverty rate in the United States has dropped for the first time since 2006, bringing a bit of encouraging news about the nation's economy as President Barack Obama and Congress gear up for the November elections.

User comments : 0