Communication and message-efficient protocol for computing the intersection between different sets of data

Patent metadata

Field	Value
Publication number	US-2016173660-A1
Application number	US-201615064187-A
Country	US
Kind code	A1
Filing date	Mar 8, 2016
Priority date	Dec 16, 2013
Publication date	Jun 16, 2016
Grant date	—

Abstract

Embodiments relate to data processing. A method includes analyzing a plurality of data items in a relational database, where different portions of the data items are stored in a plurality of servers. The method also includes determining a maximum size of a subset of the data items stored in each of at least two servers among the plurality of servers, calculating a logarithm function based on the maximum size of the subset of the data items in each of the two servers, and calculating a highest number of sequences of communications between the two servers such that when the logarithmic function is iteratively applied, a value of the logarithmic function remains smaller than one. A protocol is then generated between the two servers for performing an intersection operation using the highest number of sequences calculated.

First claim

What is claimed:

1 . A method comprising:
analyzing a plurality of data items in a relational database, wherein different portions of the data items are stored in a plurality of servers; determining a maximum size of a subset of the data items stored in each of at least two servers among the plurality of servers; calculating a logarithm function based on the maximum size of the subset of the data items in each of the two servers, wherein the logarithmic function includes an upper bound and a lower bound in its functional calculation; calculating a highest number of sequences of communications between the two servers such that when the logarithmic function is iteratively applied, a value of the logarithmic function remains smaller than 1, wherein the highest number of sequences is defined as O(k) bits where k is the maximum size of the subset of the data items in each of the two servers, wherein the maximum size of the subset of the data items is defined as n and the logarithmic function is defined as O(k log n) bits of communication, wherein the value of n is alterable when at least one of a new data item is added and when an existing data item is removed from the relational database such that O(k log n) is further calculated by the logarithmic function O(log*k) for the two servers, wherein the two servers deterministically exchange their inputs using only O(k log(n/k)) bits of communication, wherein the two servers hash their data items in elements of O(log k)-bit strings, and wherein the two servers exchange the hashed values in order to determine which elements are in the intersection of their data items; and generating a protocol between the two servers for performing an intersection operation using the highest number of sequences calculated, wherein the intersection operation determines common data items stored in the two servers through the communications between the two servers such that the number of times the communications are exchanged does not exceed the highest number of sequences calculated, and wherein the intersection operation is used to compute a number of distinct elements in a union of the data items between the two servers.

Assignees

• IBM

Inventors

• Woodruff David P
• Yaroslavtsev Grigory

Classifications

• H04L67/1097

  for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS] · CPC title

• H04L69/24 Primary

  Negotiation of communication capabilities · CPC title

• H04L69/166 Primary

  IP fragmentation; TCP segmentation · CPC title

• G06F16/40

  of multimedia data, e.g. slideshows comprising image and additional audio data (retrieval of still image data G06F16/50; retrieval of audio data G06F16/60; retrieval of video data G06F16/70) · CPC title

• G06F16/27

  Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor · CPC title