LARGE FOLDER OPERATIONS IN A COLLABORATIVE CLOUD-BASED ENVIRONMENT

• US 20170286229A1
• Filed: 03/31/2016
• Published: 10/05/2017
• Est. Priority Date: 03/31/2016
• Status: Active Grant

• Current Assignee: Box Incorporated
• Original Assignee: Box Incorporated
• Inventors: Cheung, Michael
• Granted Patent: US 10,157,104 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 11/14 Error detection or correction of the data by redundancy in operation G06F11/16 takes precedence
• CPC Class Codes: G06F 11/1451 by selection of backup contents
• CPC Class Codes: G06F 11/1474 in transactions G06F16/20 takes precedence
• CPC Class Codes: G06F 16/16 File or folder operations, e.g. details of user interfaces specifically adapted to file systems
• CPC Class Codes: G06F 16/1774 Locking methods, e.g. locking methods for file systems allowing shared and concurrent access to files
• CPC Class Codes: G06F 21/6218 to a system of files or objects, e.g. local or distributed file system or database
• CPC Class Codes: G06F 2221/2147 Locking files

Abstract

Systems for managing operating on folders that comprise a large number of objects in a cloud-based collaboration platform. A cloud-based environment includes storage devices that store content objects accessible by collaborating users. The content objects are identified by one or more hierarchical path identifiers comprising a folder identifier corresponding to a logical grouping. The hierarchical path identifiers are stored in a relational database. Methods receive an operation command from a user to operate on the content objects associated with the logical grouping, after which a relational database search query is generated. Processing of the query returns a plurality of result sets corresponding to respective portions of the content objects associated with the logical grouping. The operation command is applied iteratively over the plurality of result sets, and the command is finalized after the last iteration. Collaborators can perform certain operations on content objects even while the iterations are in progress.

Claims

1. A method comprising:

identifying a server in a cloud-based environment that is interfaced with one or more storage devices that store one or more content objects accessible by one or more users, wherein the content objects are identified by one or more hierarchical path identifiers comprising at least one folder identifier corresponding to a logical folder, and wherein the hierarchical path identifiers are stored in a relational database in the storage devices;

receiving at least one operation command from at least one of the users to operate on the content objects associated with the logical folder;

generating a search query for the relational database to return a plurality of result sets corresponding to respective portions of the content objects associated with the logical folder; and

invoking the operation command over the plurality of the result sets.

2. The method of claim 1, further comprising updating status metadata to indicate an operation status for the respective portion of the content objects associated with the logical folder.

3. The method of claim 2, further comprising repeatedly invoking the operation command on at least a portion of the result sets based at least in part on the operation status.

4. The method of claim 2, further comprising generating a revert query for the relational database based at least in part on the operation status.

5. The method of claim 2, wherein the operation status characterizes at least one of, a successfully completed status, or a pending completion status, or a queued status, or a failed status.

6. The method of claim 1, further comprising updating permissibility metadata to indicate an operation permissibility for the respective portion of the content objects associated with the logical folder.

7. The method of claim 6, wherein the operation permissibility is based at least in part on the operation command.

8. The method of claim 6, wherein the operation permissibility characterizes an association between the operation command and one or more concurrent operations on the content objects.

9. The method of claim 6, wherein the permissibility metadata further indicates a logical locking of at least one of, the logical folder, a parent folder of the logical folder, or at least one of the content objects associated with the logical folder.

10. The method of claim 1, wherein the search query comprises a returned item bound to determine at least one of the result sets.

11. The method of claim 10, wherein the returned item bound is a chunk size.

12. A computer readable medium, embodied in a non-transitory computer readable medium, the non-transitory computer readable medium having stored thereon a sequence of instructions which, when stored in memory and executed by a processor causes the processor to perform a set of acts, the acts comprising:

identifying a server in a cloud-based environment that is interfaced with one or more storage devices that store one or more content objects accessible by one or more users, wherein the content objects are identified by one or more hierarchical path identifiers comprising at least one folder identifier corresponding to a logical folder, and wherein the hierarchical path identifiers are stored in a relational database in the storage devices;

receiving at least one operation command from at least one of the users to operate on the content objects associated with the logical folder;

generating a search query for the relational database to return a plurality of result sets corresponding to respective portions of the content objects associated with the logical folder; and

invoking the operation command over the plurality of the result sets.

13. The computer readable medium of claim 12, further comprising instructions which, when stored in memory and executed by the processor causes the processor to perform acts of updating status metadata to indicate an operation status for the respective portion of the content objects associated with the logical folder.

14. The computer readable medium of claim 13, further comprising instructions which, when stored in memory and executed by the processor causes the processor to perform acts of repeatedly invoking the operation command on at least a portion of the result sets based at least in part on the operation status.

15. The computer readable medium of claim 13, further comprising instructions which, when stored in memory and executed by the processor causes the processor to perform acts of generating a revert query for the relational database based at least in part on the operation status.

16. The computer readable medium of claim 13, wherein the operation status characterizes at least one of, a successfully completed status, or a pending completion status, or a queued status, or a failed status.

17. The computer readable medium of claim 12, further comprising instructions which, when stored in memory and executed by the processor causes the processor to perform acts of updating permissibility metadata to indicate an operation permissibility for the respective portion of the content objects associated with the logical folder.

18. The computer readable medium of claim 17, wherein the operation permissibility is based at least in part on the operation command.

19. A system comprising:

a storage medium having stored thereon a sequence of instructions; and

a processor or processors that execute the instructions to cause the processor or processors to perform a set of acts, the acts comprising,

identifying a server in a cloud-based environment that is interfaced with one or more storage devices that store one or more content objects accessible by one or more users, wherein the content objects are identified by one or more hierarchical path identifiers comprising at least one folder identifier corresponding to a logical folder, and wherein the hierarchical path identifiers are stored in a relational database in the storage devices;

receiving at least one operation command from at least one of the users to operate on the content objects associated with the logical folder;

generating a search query for the relational database to return a plurality of result sets corresponding to respective portions of the content objects associated with the logical folder; and

invoking the operation command over the plurality of the result sets.

20. The system of claim 19, wherein an operation status characterizes at least one of, a successfully completed status, or a pending completion status, or a queued status, or a failed status.