Patents by Inventor David R. Vyvyan
David R. Vyvyan has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 10169438Abstract: Determining common table definitions in distributed databases includes receiving a query at a node in a distributed database. The query targets a logical table. Upon determining the logical table is locally defined, one of the local definition and a network definition is selected to use. The network definition is independently established for shared logical table names. The selected definition is used and propagated with the query through the distributed database. Upon determining the logical table is not locally defined, an initial query is issued to other nodes in network to find the network definition for the logical table, the network definition is stored in memory, and the selected definition is propagated through the distributed database with the query.Type: GrantFiled: January 13, 2016Date of Patent: January 1, 2019Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventor: David R. Vyvyan
-
Patent number: 9813331Abstract: Method and system are provided for assessing response routes in a network of connected nodes wherein a querying node propagates a query through multiple routes of intermediate nodes to a data source node and the data source node returns data to the querying node. The method at a data source node may include: receiving a query instance including metadata with route information of the route of intermediate nodes in the network that the query instance has travelled through from a querying node to the data source node; comparing the route information to a route policy; and responding to a query instance which meets the route policy by returning the query response via the route of intermediate nodes of the query instance.Type: GrantFiled: February 3, 2014Date of Patent: November 7, 2017Assignee: International Business Machines CorporationInventors: Graham A. Bent, Thomas J. C. Berman, Patrick Dantressangle, David R. Vyvyan
-
Patent number: 9716649Abstract: A query is propagated from a querying node to a destination node in a network of connected nodes, where at least one node is designated as a delay node. A query is transmitted from the querying node to one or more connected nodes in the network of connected nodes. One or more nodes, from the one or more connected nodes, are designated as delay nodes, wherein delay nodes apply delays to the query before retransmitting the query to other nodes from the one or more connected nodes. Upon receiving the query, each node, from the one or more connected nodes, retransmits the query to another one or more nodes from the one or more connected nodes. The query is repeatedly received and retransmitted by the connected nodes until the query is received at the destination node.Type: GrantFiled: November 18, 2013Date of Patent: July 25, 2017Assignee: International Business Machines CorporationInventors: Graham A. Bent, Thomas J. C. Berman, Patrick Dantressangle, David R. Vyvyan
-
Patent number: 9667530Abstract: In at least one embodiment, a method and a system include a node potentially having information responsive to an information request distributed into, for example, a federated coalition network where the node receives at least one information request packet, conducts a search of information at the node to determine if requested information is present, when the requested information is present, then the node sends an acknowledgement to a requesting node, linear network codes the requested information into m packets where m is greater than or equal to k, which is the number of packets needed to be received by the requesting node to reconstruct the requested information, selects multiple paths between the node and the requesting node such that no third party will see more than k?1 different packets, and transmits the m packets distributed over the selected paths.Type: GrantFiled: May 6, 2013Date of Patent: May 30, 2017Assignee: International Business Machines CorporationInventors: Thomas J. C. Berman, Seraphin B. Calo, Lu Su, David R. Vyvyan, Fan Ye
-
Publication number: 20160359724Abstract: A query is propagated from a querying node to a destination node in a network of connected nodes, where at least one node is designated as a delay node. A query is transmitted from the querying node to one or more connected nodes in the network of connected nodes. One or more nodes, from the one or more connected nodes, are designated as delay nodes, wherein delay nodes apply delays to the query before retransmitting the query to other nodes from the one or more connected nodes. Upon receiving the query, each node, from the one or more connected nodes, retransmits the query to another one or more nodes from the one or more connected nodes. The query is repeatedly received and retransmitted by the connected nodes until the query is received at the destination node.Type: ApplicationFiled: November 18, 2013Publication date: December 8, 2016Inventors: GRAHAM A. BENT, THOMAS J. C. BERMAN, PATRICK DANTRESSANGLE, DAVID R. VYVYAN
-
Patent number: 9471647Abstract: A database query is received that includes a logical query indicator at a distributed database node within a distributed network of databases. The logical query indicator includes at least one physical database query and at least one database node identifier that allows at least one distributed database node to identify at least one physical database to execute the physical database query against. It is determined that the at least one database node identifier matches a local node identifier. The at least one physical database query is executed against at least one local physical database table. A local query response is formed including data retrieved from the at least one local physical database table. The database query is responded to with at least the local query response.Type: GrantFiled: September 30, 2015Date of Patent: October 18, 2016Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Graham A. Bent, Patrick Dantressangle, David R. Vyvyan
-
Publication number: 20160132579Abstract: Determining common table definitions in distributed databases includes receiving a query at a node in a distributed database. The query targets a logical table. Upon determining the logical table is locally defined, one of the local definition and a network definition is selected to use. The network definition is independently established for shared logical table names. The selected definition is used and propagated with the query through the distributed database. Upon determining the logical table is not locally defined, an initial query is issued to other nodes in network to find the network definition for the logical table, the network definition is stored in memory, and the selected definition is propagated through the distributed database with the query.Type: ApplicationFiled: January 13, 2016Publication date: May 12, 2016Inventor: David R. Vyvyan
-
Publication number: 20160117369Abstract: A database query is received that includes a logical query indicator at a distributed database node within a distributed network of databases. The logical query indicator includes at least one physical database query and at least one database node identifier that allows at least one distributed database node to identify at least one physical database to execute the physical database query against. It is determined that the at least one database node identifier matches a local node identifier. The at least one physical database query is executed against at least one local physical database table. A local query response is formed including data retrieved from the at least one local physical database table. The database query is responded to with at least the local query response.Type: ApplicationFiled: September 30, 2015Publication date: April 28, 2016Inventors: Graham A. Bent, Patrick Dantressangle, David R. Vyvyan
-
Patent number: 9251293Abstract: Determining common table definitions in distributed databases includes independently establishing, for a node in a distributed database, a common network definition for shared logical table names. Establishing the common network definition includes providing local definitions for at least one logical table, and querying at least one node in a network of nodes to determine any existing network definitions for the logical table. If there is no existing network definition, the method includes adding the local definition as a new network definition. If there is an existing network definition, the method includes updating the existing network definition with any extra columns of local definition, and applying an updated network definition to other nodes in the network holding a record of the network definition.Type: GrantFiled: September 4, 2013Date of Patent: February 2, 2016Assignee: International Business Machines CorporationInventor: David R. Vyvyan
-
Patent number: 9183260Abstract: A database query is received that includes a logical query indicator at a distributed database node within a distributed network of databases. The logical query indicator includes at least one physical database query and at least one database node identifier that allows at least one distributed database node to identify at least one physical database to execute the physical database query against. It is determined that the at least one database node identifier matches a local node identifier. The at least one physical database query is executed against at least one local physical database table. A local query response is formed including data retrieved from the at least one local physical database table. The database query is responded to with at least the local query response. This abstract is not to be considered limiting, since other embodiments may deviate from the features described in this abstract.Type: GrantFiled: October 9, 2008Date of Patent: November 10, 2015Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Graham A. Bent, Patrick Dantressangle, David R. Vyvyan
-
Publication number: 20140328342Abstract: In at least one embodiment, a method and a system include a node potentially having information responsive to an information request distributed into, for example, a federated coalition network where the node receives at least one information request packet, conducts a search of information at the node to determine if requested information is present, when the requested information is present, then the node sends an acknowledgement to a requesting node, linear network codes the requested information into m packets where m is greater than or equal to k, which is the number of packets needed to be received by the requesting node to reconstruct the requested information, selects multiple paths between the node and the requesting node such that no third party will see more than k?1 different packets, and transmits the m packets distributed over the selected paths.Type: ApplicationFiled: May 6, 2013Publication date: November 6, 2014Inventors: Thomas J. C. Berman, Seraphin B. Calo, Lu Su, David R. Vyvyan, Fan Ye
-
Publication number: 20140219278Abstract: Method and system are provided for assessing response routes in a network of connected nodes wherein a querying node propagates a query through multiple routes of intermediate nodes to a data source node and the data source node returns data to the querying node. The method at a data source node may include: receiving a query instance including metadata with route information of the route of intermediate nodes in the network that the query instance has travelled through from a querying node to the data source node; comparing the route information to a route policy; and responding to a query instance which meets the route policy by returning the query response via the route of intermediate nodes of the query instance.Type: ApplicationFiled: February 3, 2014Publication date: August 7, 2014Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: GRAHAM A. BENT, THOMAS J. C. BERMAN, PATRICK DANTRESSANGLE, DAVID R. VYVYAN
-
Publication number: 20140074882Abstract: Determining common table definitions in distributed databases includes independently establishing, for a node in a distributed database, a common network definition for shared logical table names. Establishing the common network definition includes providing local definitions for at least one logical table, and querying at least one node in a network of nodes to determine any existing network definitions for the logical table. If there is no existing network definition, the method includes adding the local definition as a new network definition. If there is an existing network definition, the method includes updating the existing network definition with any extra columns of local definition, and applying an updated network definition to other nodes in the network holding a record of the network definition.Type: ApplicationFiled: September 4, 2013Publication date: March 13, 2014Applicant: International Business Machines CorporationInventor: David R. Vyvyan
-
Patent number: 8626747Abstract: A database query comprising a logical table definition and at least one route tracing indicator is forwarded to at least one distributed database node within a distributed network of databases. At least one query response is received including distributed route tracing information associated with each distributed database node that processed the database query along a path associated with the at least one query response. The received distributed route tracing information is processed to characterize query route propagation within the distributed network of databases. This abstract is not to be considered limiting, since other embodiments may deviate from the features described in this abstract.Type: GrantFiled: July 30, 2012Date of Patent: January 7, 2014Assignee: International Business Machines CorporationInventors: Graham A. Bent, Patrick Dantressangle, David R. Vyvyan
-
Patent number: 8560570Abstract: A logical table definition is received as part of a database query within a distributed database system. A determination is made as to whether the received logical table definition matches a local logical table definition. The query is processed in response to determining that the received logical table definition matches the local logical table definition. The query is forwarded to at least one other distributed database node.Type: GrantFiled: February 2, 2012Date of Patent: October 15, 2013Assignee: International Business Machines CorporationInventors: Graham A. Bent, Patrick Dantressangle, David R. Vyvyan
-
Patent number: 8458208Abstract: A database query is received including a logical table identifier, a data element, and at least one data source assurance indicator at a distributed database node within a distributed network of databases. The data element is encrypted based upon the at least one data source assurance indicator. A data portion of a local query response to the database query is formed including data retrieved from a local physical database table mapped by a local logical table that matches the received logical table identifier. A node identifier and the encrypted data element are added as an authentication portion of the local query response to authenticate the data portion of the local query response. The database query is responded to with at least the authenticated local query response. This abstract is not to be considered limiting, since other embodiments may deviate from the features described in this abstract.Type: GrantFiled: October 9, 2008Date of Patent: June 4, 2013Assignee: International Business Machines CorporationInventor: David R. Vyvyan
-
Patent number: 8458166Abstract: A database query is received including a logical table identifier at a distributed database node within a distributed network of databases. The logical table identifier includes a dynamically-updatable constant column identifier. Local logical table definitions are filtered based upon the logical table identifier and the dynamically-updatable constant column identifier to identify a local logical table associated with the logical table identifier and the dynamically-updatable constant column identifier. A local query response is formed including data retrieved from a local physical database table mapped by the local logical table in response to identifying the local logical table associated with the logical table identifier and the dynamically-updatable constant column identifier. The database query is responded to, in response to forming the local query response, with at least the local query response.Type: GrantFiled: October 9, 2008Date of Patent: June 4, 2013Assignee: International Business Machines CorporationInventors: Graham A. Bent, Patrick Dantressangle, David R. Vyvyan
-
Patent number: 8386515Abstract: Methods and systems are provided, for persistent querying in a federated database system. A federated database system has a plurality of connectable database management system nodes, each database node having at least one database. Persistent querying includes: receiving a query at a first database node and propagating the query from the first database node to other database nodes in the federated database system. A responding database node satisfying the query: obtains a query results set; defines a topic identifier for the query; and publishes subsequent messages relating to the topic identifier when data updates are available. The first database node receives query results sets from one or more responding nodes and the first database node subscribes to topic identifiers for publications of subsequent messages from the responding database nodes. Subsequent messages are published relating to the query along the connection through which the query is returned.Type: GrantFiled: November 23, 2010Date of Patent: February 26, 2013Assignee: International Business Machines CorporationInventors: Graham Bent, Patrick Dantressangle, Christopher R. Gibson, David R. Vyvyan
-
Publication number: 20120303609Abstract: A database query comprising a logical table definition and at least one route tracing indicator is forwarded to at least one distributed database node within a distributed network of databases. At least one query response is received including distributed route tracing information associated with each distributed database node that processed the database query along a path associated with the at least one query response. The received distributed route tracing information is processed to characterize query route propagation within the distributed network of databases. This abstract is not to be considered limiting, since other embodiments may deviate from the features described in this abstract.Type: ApplicationFiled: July 30, 2012Publication date: November 29, 2012Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Graham A. Bent, Patrick Dantressangle, David R. Vyvyan
-
Patent number: 8285710Abstract: A database query comprising a logical table definition and at least one route tracing indicator is forwarded to at least one distributed database node within a distributed network of databases. At least one query response is received including distributed route tracing information associated with each distributed database node that processed the database query along a path associated with the at least one query response. The received distributed route tracing information is processed to characterize query route propagation within the distributed network of databases. This abstract is not to be considered limiting, since other embodiments may deviate from the features described in this abstract.Type: GrantFiled: October 9, 2008Date of Patent: October 9, 2012Assignee: International Business Machines CorporationInventors: Graham A. Bent, Patrick Dantressangle, David R. Vyvyan