IP Library Granted Patent US 11,354,330
Granted Patent B2
US 11,354,330 · App. 16/695,474 · Granted Jun 7, 2022

System and method for partitioning data based on authorization rules

Inventor: Guy Boyangu (Tel Aviv, IL)
Assignee: Sisense Ltd.
G06F16/254G06F16/2379
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 11,354,330
App. No.
16/695,474
Granted
Jun 7, 2022
Kind
B2
Abstract

A system and method for partitioning data based on authorization rules. The method includes initiating a plurality of data nodes, each data node including a dataset generated based on a shared data model, wherein each of the plurality of data nodes corresponds to at least one authorization rule, wherein each authorization rule authorizes at least one user identifier to access a respective data node of the plurality of data nodes; and configuring an extract, transform, and load (ETL) application service to extract data from a data source and to load data from the data source to the dataset stored on a first data node of the plurality of data nodes when the at least one first authorization rule authorizes a requesting user to access the first data node.

Claims (29)

1. A method for partitioning data based on authorization rules, comprising:

initiating a plurality of data nodes, each data node including a dataset generated based on a shared data model, wherein each of the plurality of data nodes corresponds to at least one authorization rule, wherein each authorization rule authorizes at least one user identifier to access a respective data node of the plurality of data nodes; and

prior to receiving a user request for data, initially configuring an extract, transform, and load (ETL) application service to extract data from a data source and to load data from the data source to the dataset stored on a first data node of the plurality of data nodes when the at least one first authorization rule authorizes a requesting user to access the first data node.

2. The method of claim 1 , further comprising:

establishing a plurality of ETL pipelines, each ETL pipeline corresponding to one of the plurality of data nodes, wherein data filtered through each of the ETL pipelines is loaded into the dataset stored on the data node corresponding to the ETL pipeline.

3. The method of claim 2 , wherein new data to be stored on the plurality of data nodes is continuously filtered through the plurality of ETL pipelines.

4. The method of claim 2 , wherein each ETL pipeline has instructions for performing ETL operations, wherein the instructions of each ETL pipeline includes instructions for loading data into the corresponding data node.

5. The method of claim 1 , wherein the data source is a first data source of a plurality of data sources, wherein the shared data model includes a plurality of portions, wherein each of the plurality of portions is stored in a different data source of the plurality of data sources.

6. The method of claim 1 , wherein each authorization rule further authorizes the respective at least one user identifier to access at least one location of data.

7. The method of claim 6 , wherein each authorization rule defines a key, wherein the at least one location of data authorized by each authorization rule stores the key defined in the authorization rule.

8. The method of claim 1 , further comprising:

generating a plurality of user groups, wherein each of the plurality of user groups includes at least one user corresponding to the at least one user identifier of one of the at least one authorization rule.

9. A non-transitory computer readable medium having stored thereon instructions for causing a processing circuitry to execute a process, the process comprising:

initiating a plurality of data nodes, each data node including a dataset generated based on a shared data model, wherein each of the plurality of data nodes corresponds to at least one authorization rule, wherein each authorization rule authorizes at least one user identifier to access a respective data node of the plurality of data nodes; and

prior to receiving a user request for data, initially configuring an extract, transform, and load (ETL) application service to extract data from a data source and to load data from the data source to the dataset stored on a first data node of the plurality of data nodes when the at least one first authorization rule authorizes a requesting user to access the first data node.

10. A system for partitioning data based on authorization rules, comprising:

a processing circuitry; and

a memory, the memory containing instructions that, when executed by the processing circuitry, configure the system to:

initiate a plurality of data nodes, each data node including a dataset generated based on a shared data model, wherein each of the plurality of data nodes corresponds to at least one authorization rule, wherein each authorization rule authorizes at least one user identifier to access a respective data node of the plurality of data nodes; and

prior to receiving a user request for data, initially configure an extract, transform, and load (ETL) application service to extract data from a data source and to load data from the data source to the dataset stored on a first data node of the plurality of data nodes when the at least one first authorization rule authorizes a requesting user to access the first data node.

11. The system of claim 10 , wherein the system is further configured to:

establish a plurality of ETL pipelines, each ETL pipeline corresponding to one of the plurality of data nodes, wherein data filtered through each of the ETL pipelines is loaded into the dataset stored on the data node corresponding to the ETL pipeline.

12. The system of claim 11 , wherein new data to be stored on the plurality of data nodes is continuously filtered through the plurality of ETL pipelines.

13. The system of claim 11 , wherein each ETL pipeline has instructions for performing ETL operations, wherein the instructions of each ETL pipeline includes instructions for loading data into the corresponding data node.

14. The system of claim 10 , wherein the data source is a first data source of a plurality of data sources, wherein the shared data model includes a plurality of portions, wherein each of the plurality of portions is stored in a different data source of the plurality of data sources.

15. The system of claim 10 , wherein each authorization rule further authorizes the respective at least one user identifier to access at least one location of data.

16. The system of claim 15 , wherein each authorization rule defines a key, wherein the at least one location of data authorized by each authorization rule stores the key defined in the authorization rule.

17. The system of claim 10 , wherein the system is further configured to:

generate a plurality of user groups, wherein each of the plurality of user groups includes at least one user corresponding to the at least one user identifier of one of the at least one authorization rule.

Assignments (9)
RELEASE OF SECURITY INTEREST Recorded Jun 16, 2023
From: TRIPLEPOINT VENTURE GROWTH BDC CORP
To: SISENSE SF, INC.; SISENSE LTD.
Reel/Frame 063980/0047 →
SECURITY INTEREST Recorded Jun 14, 2023
From: SISENSE LTD; SISENSE SF INC.
To: HERCULES CAPITAL, INC.
Reel/Frame 063948/0662 →
RELEASE OF SECURITY INTEREST Recorded Jun 9, 2023
From: COMERICA BANK
To: SISENSE LTD.
Reel/Frame 063915/0257 →
RELEASE OF SECURITY INTEREST Recorded Sep 24, 2021
From: SILICON VALLEY BANK
To: SISENSE LTD
Reel/Frame 057594/0867 →
SECURITY INTEREST Recorded Sep 24, 2021
From: SISENSE LTD.
To: COMERICA BANK
Reel/Frame 057588/0698 →
RELEASE OF SECURITY INTEREST Recorded Sep 24, 2021
From: SILICON VALLEY BANK, AS AGENT
To: SISENSE LTD
Reel/Frame 057594/0926 →
INTELLECTUAL PROPERTY SECURITY AGREEMENT Recorded Mar 30, 2020
From: SISENSE LTD
To: SILICON VALLEY BANK, AS AGENT
Reel/Frame 052267/0325 →
INTELLECTUAL PROPERTY SECURITY AGREEMENT Recorded Mar 30, 2020
From: SISENSE LTD
To: SILICON VALLEY BANK
Reel/Frame 052267/0313 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 26, 2019
From: BOYANGU, GUY
To: SISENSE LTD.
Reel/Frame 051115/0761 →
Continuity (2)
Provisional Application 62779815 · Dec 14, 2018
Related Publication 20200192910A1 · Jun 18, 2020