Various embodiments for providing a data transfer and management system are described herein. An embodiment operates by determining that data of a column is stored in a column loadable format in which all of the data of the column is moved from the disk storage location to a memory responsive to a data request. A data vector that identifies a plurality of value IDs corresponding to at least a subset of the plurality of rows of the column, is identified. A page format that provides that a portion of the data of the column across a subset of the plurality of rows is moved from the second disk storage location into the memory responsive to the data request is determined. The entries of the data vector are requested, converted from column loadable format into the page persistent format, and stored across one or more memory pages.
Legal claims defining the scope of protection, as filed with the USPTO.
2. The method of claim 1, wherein the column is part of a table of an in-memory database.
8. The method of claim 7, wherein the plurality of value IDs of the data dictionary are in a sorted order prior to the requesting the entry and remain in the sorted order throughout the repeating the requesting the entry.
9. The method of claim 1, wherein at least a portion of the requested subset of the plurality of entries is compressed and remains compressed throughout both the converting the value IDs, the converting the corresponding entries, and the storing.
11. The system of claim 10, wherein the column is part of a table of an in-memory database.
17. The system of claim 16, wherein the plurality of value IDs of the data dictionary are in a sorted order prior to the requesting the entry and remain in the sorted order throughout the repeating the requesting the entry.
18. The system of claim 10, wherein at least a portion of the requested subset of the plurality of entries is compressed and remains compressed throughout both the converting the value IDs, the converting the corresponding entries, and the storing.
20. The device of claim 19, wherein the column is part of a table of an in-memory database.
Cooperative Patent Classification codes for this invention. Click any code to explore related patents in that topic.
May 20, 2020
August 23, 2022
Browse 5M+ US patents with plain-English claim translations and AI-generated analysis.