Large Object Containers with Size Criteria for Storing Mid-Sized Large Objects

1. A method, comprising: determining, by an in memory database system, a first size of a first object, a second size of a second object, and a third size of a third object, the first object, the second object, and the third object each having data that is operable upon by one or more query operators; determining that the first size of the first object is greater than a first threshold size criteria, that the first size of the first object is less than a second threshold size criteria, and that a first access frequency of the first object is less than a threshold access frequency criteria; in response to determining that the first size of the first object is greater than the first threshold size criteria, that the first size of the first object is less than the second threshold size criteria, and that the first access frequency of the first object is less than the threshold access frequency criteria, storing, by the in memory database system, the first object to an object container in a disk storage coupled to the in memory database system; determining that the second size of the second object is greater than the first threshold size criteria, that the second size of the second object is less than the second threshold size criteria, and that a second access frequency of the second object is greater than the threshold access frequency criteria; in response to determining that the second size of the second object is greater than the first threshold size criteria, that the second size of the second object is less than the second threshold size criteria, and that the second access frequency of the second object is greater than the threshold access frequency criteria, storing, by the in memory database system, the second object to an in memory storage of the in memory database system; in response to the storing of the first object to the object container in the disk storage coupled to the in memory database system, generating, by the in memory database system, a first object identifier to identify the first object, wherein the first object identifier is mapped to a container identifier that identifies the object container at the disk storage and is further mapped to a first offset that indicates where in the object container the first object begins; storing, to the in memory storage of the in memory database system, the first object identifier mapped to the container identifier and the first offset; in response to the storing of the second object to the in memory storage of the in memory database system, generating, by the in memory database system, a second object identifier to identify the second object, wherein the second object identifier is mapped to the in memory storage of the in memory database system where the second object is stored; storing, to the in memory storage of the in memory database system, the second object identifier mapped to the in memory storage of the in memory database system where the second object is stored; determining that the third size of the third object is less than the first threshold size criteria; in response to determining that the third size of the third object is less than the first threshold size criteria, storing the third object to the in memory storage of the in memory database system; in response to storing the third object to the in memory storage of the in memory database system, generating, by the in memory database system, a third object identifier to identify the third object, wherein the third object identifier is mapped to the in memory storage of the in memory database system where the third object is stored; storing, to the in memory storage of the in memory database system, the third object identifier mapped to the in memory storage of the in memory database system where the third object is stored; and accessing, by the in memory database system, the first object based on the stored first object identifier, the second object based on the stored second object identifier, or the third object based on the stored third object identifier.

2. The method of claim 1 , wherein the object container further includes metadata, the metadata comprising a sum of sizes of objects stored in the object container and a count of objects stored in the object container, and wherein the method further comprises: determining that a fourth size of a fourth object is greater than the second threshold size criteria; and in response to determining that the fourth size of the fourth object is greater than the second threshold size criteria, storing, by the in memory database system, the fourth object to the object container in the disk storage coupled to the in memory database system.

3. A system, comprising: a processor; and a memory storing machine-readable instructions, which when executed by the processor, cause the processor to perform one or more operations, the operations comprising: determining, by an in memory database system, a first size of a first object, a second size of a second object, and a third size of a third object, the first object, the second object, and the third object each having data that is operable upon by one or more query operators; determining that the first size of the first object is greater than a first threshold size criteria, that the first size of the first object is less than a second threshold size criteria, and that a first access frequency of the first object is less than a threshold access frequency criteria; in response to determining that the first size of the first object is greater than the first threshold size criteria, that the first size of the first object is less than the second threshold size criteria, and that the first access frequency of the first object is less than the threshold access frequency criteria, storing, by the in memory database system, the first object to an object container in a disk storage coupled to the in memory database system; determining that the second size of the second object is greater than the first threshold size criteria, that the second size of the second object is less than the second threshold size criteria, and that a second access frequency of the second object is greater than the threshold access frequency criteria; in response to determining that the second size of the second object is greater than the first threshold size criteria, that the second size of the second object is less than the second threshold size criteria, and that the second access frequency of the second object is greater than the threshold access frequency criteria, storing, by the in memory database system, the second object to an in memory storage of the in memory database system; in response to the storing of the first object to the object container in the disk storage coupled to the in memory database system, generating, by the in memory database system, a first object identifier to identify the first object, wherein the first object identifier is mapped to a container identifier that identifies the object container at the disk storage and is further mapped to a first offset that indicates where in the object container the first object begins; storing, to the in memory storage of the in memory database system, the first object identifier mapped to the container identifier and the first offset; in response to the storing of the second object to the in memory storage of the in memory database system, generating, by the in memory database system, a second object identifier to identify the second object, wherein the second object identifier is mapped to the in memory storage of the in memory database system where the second object is stored; storing, to the in memory storage of the in memory database system, the second object identifier mapped to the in memory storage of the in memory database system where the second object is stored; determining that the third size of the third object is less than the first threshold size criteria; in response to determining that the third size of the third object is less than the first threshold size criteria, storing the third object to the in memory storage of the in memory database system; in response to storing the third object to the in memory storage of the in memory database system, generating, by the in memory database system, a third object identifier to identify the third object, wherein the third object identifier is mapped to the in memory storage of the in memory database system where the third object is stored; storing, to the in memory storage of the in memory database system, the third object identifier mapped to the in memory storage of the in memory database system where the third object is stored; and accessing, by the in memory database system, the first object based on the stored first object identifier, the second object based on the stored second object identifier, or the third object based on the stored third object identifier.

4. The system of claim 3 , wherein the object container further includes metadata, the metadata comprising a sum of sizes of objects stored in the object container and a count of objects stored in the object container, and wherein the operations further comprise: determining that a fourth size of a fourth object is greater than the second threshold size criteria; and in response to determining that the fourth size of the fourth object is greater than the second threshold size criteria, storing, by the in memory database system, the fourth object to the object container in the disk storage coupled to the in memory database system.

5. A non-transitory computer-readable medium storing instructions, which when executed by at least one data processor, result in operations comprising: determining, by an in memory database system, a first size of a first object, a second size of a second object, and a third size of a third object, the first object, the second object, and the third object each having data that is operable upon by one or more query operators; determining that the first size of the first object is greater than a first threshold size criteria, that the first size of the first object is less than a second threshold size criteria, and that a first access frequency of the first object is less than a threshold access frequency criteria; in response to determining that the first size of the first object is greater than the first threshold size criteria, that the first size of the first object is less than the second threshold size criteria, and that the first access frequency of the first object is less than the threshold access frequency criteria, storing, by the in memory database system, the first object to an object container in a disk storage coupled to the in memory database system; determining that the second size of the second object is greater than the first threshold size criteria, that the second size of the second object is less than the second threshold size criteria, and that a second access frequency of the second object is greater than the threshold access frequency criteria; in response to determining that the second size of the second object is greater than the first threshold size criteria, that the second size of the second object is less than the second threshold size criteria, and that the second access frequency of the second object is greater than the threshold access frequency criteria, storing, by the in memory database system, the second object to an in memory storage of the in memory database system; in response to the storing of the first object to the object container in the disk storage coupled to the in memory database system, generating, by the in memory database system, a first object identifier to identify the first object, wherein the first object identifier is mapped to a container identifier that identifies the object container at the disk storage and is further mapped to a first offset that indicates where in the object container the first object begins; storing, to the in memory storage of the in memory database system, the first object identifier mapped to the container identifier and the first offset; in response to the storing of the second object to the in memory storage of the in memory database system, generating, by the in memory database system, a second object identifier to identify the second object, wherein the second object identifier is mapped to the in memory storage of the in memory database system where the second object is stored; storing, to the in memory storage of the in memory database system, the second object identifier mapped to the in memory storage of the in memory database system where the second object is stored; determining that the third size of the third object is less than the first threshold size criteria; in response to determining that the third size of the third object is less than the first threshold size criteria, storing the third object to the in memory storage of the in memory database system; in response to storing the third object to the in memory storage of the in memory database system, generating, by the in memory database system, a third object identifier to identify the third object, wherein the third object identifier is mapped to the in memory storage of the in memory database system where the third object is stored; storing, to the in memory storage of the in memory database system, the third object identifier mapped to the in memory storage of the in memory database system where the third object is stored; and accessing, by the in memory database system, the first object based on the stored first object identifier, the second object based on the stored second object identifier, or the third object based on the stored third object identifier.

6. The method of claim 1 , wherein the first threshold size criteria is determined based at least on a first time required to load an object into a main memory of the in memory database system relative to a second time required to access the object in the disk storage.