IP Library Granted Patent US 10,909,258
Granted Patent B2
US 10,909,258 · App. 15/966,450 · Granted Feb 2, 2021

Secure data management for a network of nodes

Inventors: Paul Woodward (Burton upon Trent, GB); Simon Alexander Tucker (Burton-on-Trent, GB); Stephen Michael Ginns (Narborough, GB)
Assignee: Oracle International Corporation
G06F21/6227G06F16/242G06F16/252G06F16/26G06F16/288G06Q10/087H04L63/102H04L63/105H04L67/1097
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 10,909,258
App. No.
15/966,450
Granted
Feb 2, 2021
Kind
B2
Abstract

Embodiments include systems and methods for providing secure data management for a network of nodes. A network with a plurality of connected nodes can be stored, the nodes representing entities of the network. A request can be received from a first node of the network to retrieve data about a second node of the network. A query can be generated to retrieve the requested data. The query can be filtered based on permissions for the first node stored at a trusted store. The fields from the results of the filtered query can be redacted based on the permissions for the first node. And the redacted results can be provided to the first node.

Claims (36)

1. A method for providing secure data management for a network of nodes, the method comprising:

storing a network with a plurality of connected nodes, the nodes representing entities of the network, wherein the network is mapped onto one or more relational data tables of a database;

receiving, from a first node of the network, a request to retrieve data about a second node of the network;

generating a query to retrieve the requested data from the database;

filtering the query based on permissions for the first node stored at a trusted store by augmenting the query with security parameters that provide record level access to the database, wherein the security parameters used to augment the query comprise one or more keys such that secured records within the relational data tables requested by the query are retrieved when the one or more keys include a key that corresponds to the secured records;

redacting fields from the results of the filtered query based on the permissions for the first node; and

providing the redacted results to the first node.

2. The method of claim 1 , wherein the one or more keys used to augment the query are based on permissions for the first node relative to the second node.

3. The method of claim 2 , wherein the request is received from an authenticated user of the first node.

4. The method of claim 3 , wherein the authenticated user has permission to view at least some data for nodes that are connected to the first node, the first node being connected to the second node.

5. The method of claim 3 , wherein the authenticated user has permission to view at least some data for nodes that comprise a path with the first node, the first node being on a path with the second node.

6. The method of claim 3 , wherein a permissions file is stored that defines access permissions to one or more of the relational data tables, the access permissions being defined per record in the relational data tables based on an owner node that owns a record and a relationship between the owner node and a node requesting access.

7. The method of claim 6 , wherein the trusted store immutably stores a plurality of keys for nodes of the network.

8. The method of claim 7 , wherein the one or more keys comprise a list of keys retrieved from the trusted store by accessing the permissions file and the list of keys is for a subset of nodes that are permitted for access by the first node according to the relationship between the first node and the subset of nodes.

9. The method of claim 3 , wherein the entities comprise suppliers and customers, and paths between the nodes represent supply chain networks for one or more products.

10. The method of claim 7 , wherein the authenticated user has permission to access supply chain networks that include the first node, include suppliers to the first node, or include customers of the first node.

11. A non-transitory computer readable medium having instructions stored thereon that, when executed by a processor, cause the processor to provide secure data management for a network of nodes, the providing comprising:

storing a network with a plurality of connected nodes, the nodes representing entities of the network, wherein the network is mapped onto one or more relational data tables of a database;

receiving, from a first node of the network, a request to retrieve data about a second node of the network;

generating a query to retrieve the requested data from the database;

filtering the query based on permissions for the first node stored at a trusted store by augmenting the query with security parameters that provide record level access to the database, wherein the security parameters used to augment the query comprise one or more keys such that secured records within the relational data tables requested by the query are retrieved when the one or more keys include a key that corresponds to the secured records;

redacting fields from the results of the filtered query based on the permissions for the first node; and

providing the redacted results to the first node.

12. The computer readable medium of claim 11 , wherein the request is received from an authenticated user of the first node.

13. The computer readable medium of claim 12 , wherein a permissions file is stored that defines access permissions to one or more of the relational data tables, the access permissions being defined per record in the relational data tables based on an owner node that owns a record and a relationship between the owner node and a node requesting access.

14. The computer readable medium of claim 13 , wherein the trusted store immutably stores a plurality of keys for nodes of the network.

15. The computer readable medium of claim 14 , wherein the one or more keys comprise a list of keys retrieved from the trusted store by accessing the permissions file, and the list of keys is for a subset of nodes that are permitted for access by the first node according to the relationship between the first node and the subset of nodes.

16. The computer readable medium of claim 12 , wherein the entities comprise suppliers and customers, and paths between the nodes represent supply chain networks for one or more products, and wherein the authenticated user has permission to access supply chain networks that include the first node, include suppliers to the first node, or include customers of the first node.

17. A system comprising:

a processing device in communication with a memory device, the processing device configured to provide secure data management for a network of nodes, the providing comprising:

storing a network with a plurality of connected nodes, the nodes representing entities of the network, wherein the network is mapped onto one or more relational data tables of a database;

receiving, from a first node of the network, a request to retrieve data about a second node of the network;

generating a query to retrieve the requested data from the database;

filtering the query based on permissions for the first node stored at a trusted store by augmenting the query with security parameters that provide record level access to the database, wherein the security parameters used to augment the query comprise one or more keys such that secured records within the relational data tables requested by the query are retrieved when the one or more keys include a key that corresponds to the secured records;

redacting fields from the results of the filtered query based on the permissions for the first node; and

providing the redacted results to the first node.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded May 1, 2018
From: WOODWARD, PAUL; TUCKER, SIMON ALEXANDER; GINNS, STEPHEN MICHAEL
To: ORACLE INTERNATIONAL CORPORATION
Reel/Frame 045679/0900 →
Continuity (1)
Related Publication 20190332795A1 · Oct 31, 2019