System and method for managing permissions of users for a single data type column-oriented data structure

Patent metadata

Field	Value
Publication number	US-11436359-B2
Application number	US-201916502679-A
Country	US
Kind code	B2
Filing date	Jul 3, 2019
Priority date	Jul 4, 2018
Publication date	Sep 6, 2022
Grant date	Sep 6, 2022

Abstract

A system and method for managing permissions of users for a column-oriented data structure, including: generating a column oriented data structure in response to receiving a request to generate the data structure from a first user device associated with a first user account, wherein the data structure comprises a plurality of columns, wherein each column is of single data type and is assigned metadata associated with the single data type; associating the first user account with a first set of permissions associated with the generated data structure; and, associating a second user account with a second set of permissions, wherein the first set of permissions comprises at least one additional permission with respect to the second set of permissions.

First claim

What is claimed is:

1. A method for managing permissions of users for a column-oriented data structure, comprising:
generating a column-oriented data structure in response to receiving a request to generate the column-oriented data structure from a first user device associated with a first user account, wherein the column-oriented data structure includes a plurality of columns, wherein each column is configured to maintain a respective single data type and is assigned metadata associated with the respective single data type;
associating the first user account with a first set of permissions associated with the generated column-oriented data structure; and
associating a second user account with a second set of permissions associated with the generated column-oriented data structure, wherein:
the first set of permissions includes at least one additional permission with respect to the second set of permissions;
the first set of permissions and the second set of permissions are based on a predetermined association with a type of user account;
both the first user account and the second user account are enabled to access the column-oriented data structure at the same time, each according to their associated permissions; and
at least one of the first set of permissions and the second set of permissions is modified based on a data structure type of the generated column-oriented data structure.

2. The method of claim 1 , wherein the second user account is associated with a second user device.

3. The method of claim 1 , wherein the first set of permissions comprises at least one of: a read command, a write command, a permission to generate a new data structure within a schema, a permission to regenerate the schema, or a permission to edit the schema.

4. The method of claim 1 , further comprising:
receiving a request from either a first user account or a second user account to make at least one change in the column-oriented data structure;
determining if the either a first user account or a second user account has a required permission to make the requested change; and
performing the requested change when the either a first user account or a second user is determined to have the required permission.

5. The method of claim 4 , wherein determining if the first user account or the second user account has permission to make the requested change is achieved by searching a data repository in which a set of permissions associated with the column-oriented data structure and with various user accounts are stored.

6. A non-transitory computer readable medium having stored thereon instructions for causing a processing circuitry to perform a process, the process comprising:
generating a column-oriented data structure in response to receiving a request to generate the column-oriented data structure from a first user device associated with a first user account, wherein the column-oriented data structure comprises a plurality of columns, wherein each column is configured to maintain a respective single data type and is assigned metadata associated with the respective single data type;
associating the first user account with a first set of permissions associated with the generated column-oriented data structure; and
associating a second user account with a second set of permissions associated with the generated column-oriented data structure, wherein:
the first set of permissions includes at least one additional permission with respect to the second set of permissions;
the first set of permissions and the second set of permissions are based on a predetermined association with a type of user account; and
at least one of the first set of permissions and the second set of permissions is modified based on a data structure type of the generated column-oriented data structure.

7. A system for managing permissions of users for a column-oriented data structure, comprising:
a processing circuitry; and
a memory, the memory containing instructions that, when executed by the processing circuitry, configure the system to:
generate a column-oriented data structure in response to receiving a request to generate the column-oriented data structure from a first user device associated with a first user account, wherein the column-oriented data structure comprises a plurality of columns, wherein each column is configured to maintain a respective single data type and is assigned metadata associated with the respective single data type;
associate the first user account with a first set of permissions associated with the generated column-oriented data structure; and
associate a second user account with a second set of permissions associated with the generated column-oriented data structure, wherein:
the first set of permissions includes at least one additional permission with respect to the second set of permissions;
the first set of permissions and the second set of permissions are based on a predetermined association with a type of user account; and
at least one of the first set of permissions and the second set of permissions is modified based on a data structure type of the generated column-oriented data structure.

8. The system of claim 7 , wherein the second user account is associated with a second user device.

9. The system of claim 7 , wherein the first set of permissions comprises at least one of: a read command, a write command, a permission to generate a new data structure within a schema, a permission to regenerate the schema, or a permission to edit the schema.

10. The system of claim 1 , where the predetermined association is based on a user account email address.

11. The system of claim 7 , wherein the system is further configured to:
receive a request from a user account to make at least one change in the column-oriented data structure;
determine if the user account has a required permission to make the requested change; and
perform the requested change when the user account is determined to have the required permission.

12. The system of claim 11 , wherein determining if the first user account or the second user account has permission to make the requested change is achieved by searching a data repository in which a set of permissions associated with the column-oriented data structure and with various user accounts are stored.

13. The method of claim 1 , wherein the plurality of columns comprise at least a first column of a first single data type and a second column of a second single data type, the first single data type differing from the second single data type.

14. The method of claim 1 , wherein the at least one additional permission comprises at least one of: a permission to delete one or more cells, a permission to add a single data type column, a permission to change a column position, a permission to change a cell position, or a permission to add a cell.

15. The method of claim 1 , wherein at least one of the plurality of columns is configured to accept only alphanumeric values in a fixed format.

16. The system of claim 7 , wherein the plurality of columns comprises at least a first column of a first single data type and a second column of a second single data type, the first single data type differing from the second single data type.

17. The system of claim 7 , wherein the at least one additional permission comprises at least one of: a permission to delete one or more cells, a permission to add a single data type column, a permission to change a column position, a permission to change a cell position, or a permission to add a cell.

18. The system

Assignees

• Monday Com Ltd

Inventors

• Lereya Daniel
• Mann Roy
• Zinman Eran
• Waisman Rotem

Classifications

• G06F21/6227 Primary

  where protection concerns the structure of data, e.g. records, types, queries · CPC title

• G06F21/31

  User authentication · CPC title

• G06F2221/2141

  Access rights, e.g. capability lists, access control lists, access tables, access matrices · CPC title

• G06F16/221

  Column-oriented storage; Management thereof · CPC title

• G06F16/907

  Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually · CPC title