Abstract: Disclosed are systems and methods of accessing content items stored at a content management system by a mobile device, when the mobile device is not communicatively coupled to the content management system. The content management system can receive an indication to mark a content item (e.g., folder and the content items associated with the folder) as available to a mobile device when the mobile device is offline. The content management system can mark the content item, and any content items associated with the content item, for offline access by the mobile device and determine a synchronization schedule for the content item(s). The content management system can then initially send to the mobile device, the marked content item(s) in accordance with the synchronization schedule. While offline, the mobile device can make changes to the marked content items. The changes can be synchronized between the mobile device and content management system when the mobile device is online.

Abstract: Disclosed are systems and methods of accessing content items stored at a content management system by a mobile device, when the mobile device is not communicatively coupled to the content management system. The content management system can receive an indication to mark a content item (e.g., folder and the content items associated with the folder) as available to a mobile device when the mobile device is offline. The content management system can mark the content item, and any content items associated with the content item, for offline access by the mobile device and determine a synchronization schedule for the content item(s). The content management system can then initially send to the mobile device, the marked content item(s) in accordance with the synchronization schedule. While offline, the mobile device can make changes to the marked content items. The changes can be synchronized between the mobile device and content management system when the mobile device is online.

Abstract: Disclosed are systems and methods of accessing content items stored at a content management system by a mobile device, when the mobile device is not communicatively coupled to the content management system. The content management system can receive an indication to mark a content item (e.g., folder and the content items associated with the folder) as available to a mobile device when the mobile device is offline. The content management system can mark the content item, and any content items associated with the content item, for offline access by the mobile device and determine a synchronization schedule for the content item(s). The content management system can then initially send to the mobile device, the marked content item(s) in accordance with the synchronization schedule. While offline, the mobile device can make changes to the marked content items. The changes can be synchronized between the mobile device and content management system when the mobile device is online.

Abstract: Aspects of the subject technology relate to ways to avoid file duplication in a cloud storage service. In some aspects, a method of the technology includes steps for retrieving, via a computer network, one or more files from a first memory location, identifying a first signature and a second signature for each of the files, and storing the first signature and the second signature into a duplication reference list. In some aspects, the method further includes steps for analyzing files in a second memory location to identify duplicate files using the duplication reference list. Systems and computer-readable media are also provided.

Abstract: Aspects of the subject technology relate to ways to avoid file duplication in a cloud storage service. In some aspects, a method of the technology includes steps for retrieving, via a computer network, one or more files from a first memory location, identifying a first signature and a second signature for each of the files, and storing the first signature and the second signature into a duplication reference list. In some aspects, the method further includes steps for analyzing files in a second memory location to identify duplicate files using the duplication reference list. Systems and computer-readable media are also provided.

Abstract: Disclosed are systems and methods of accessing content items stored at a content management system by a mobile device, when the mobile device is not communicatively coupled to the content management system. The content management system can receive an indication to mark a content item (e.g., folder and the content items associated with the folder) as available to a mobile device when the mobile device is offline. The content management system can mark the content item, and any content items associated with the content item, for offline access by the mobile device and determine a synchronization schedule for the content item(s). The content management system can then initially send to the mobile device, the marked content item(s) in accordance with the synchronization schedule. While offline, the mobile device can make changes to the marked content items. The changes can be synchronized between the mobile device and content management system when the mobile device is online.

Abstract: One or more techniques and/or systems are disclosed for efficiently storing metadata of partitioned data (e.g., directed to a specific individual/user). A first subset of data is identified from the set of partitioned data. The first subset of data comprises data that has a high frequency of access, and may be identified, at least in part, by frequency of access metadata that is associated with the data in the set. Metadata, such as discovery information, permissions, version info, etc., that is associated with the data in the first subset can be stored in low latency (e.g., fast) storage, proving more efficient access. Metadata associated with data from the set of partitioned data that is not in the first subset (e.g., that is not accessed frequently) can be stored in higher latency (e.g., slower, less expensive) storage.

Abstract: One or more techniques and/or systems are disclosed for efficiently storing metadata of partitioned data (e.g., directed to a specific individual/user). A first subset of data is identified from the set of partitioned data. The first subset of data comprises data that has a high frequency of access, and may be identified, at least in part, by frequency of access metadata that is associated with the data in the set. Metadata, such as discovery information, permissions, version info, etc., that is associated with the data in the first subset can be stored in low latency (e.g., fast) storage, proving more efficient access. Metadata associated with data from the set of partitioned data that is not in the first subset (e.g., that is not accessed frequently) can be stored in higher latency (e.g., slower, less expensive) storage.

Abstract: The present invention the is directed to systems and methods for hosting the CLR in a DBMS in order to achieve reliability, scalability, security, and robustness for enabled DBMS programming features. Integrating the CLR with a DBMS enables programming features in the database such as stored procedures, functions, triggers, types, and aggregates to be written in any of the programming languages that are compiled into IL code supported by the CLR. For the various embodiments of the present invention, the CLR is hosted inside the DBMS and, instead of making requests directly to the server operating system, the CLR instead interfaces with the DBMS via DBMS APIs for such requests, and only the DBMS directly interfaces with the server operating system to access the server.

Abstract: The SQL Algebrizer of the present invention comprises a plurality of algorithms to “algebrize” SQL Trees to QP Algebra using an approach that is more consistent and much more efficient than typical algebrizers. More specifically, the Algebrizer of the present invention processes a SQL Tree using a reduced number of recursive depth-first passes by performing multiple operations in a single pass. Furthermore, the Algebrizer of the present invention also performs the operation of constant folding in this single, multi-operation pass so that the QP, upon receiving the QP Algebra, needs not perform this operation at all.