US 11,726,971 B2
Methods and systems for storing data in a database
Roi Avinoam, Foster City, CA (US); Alon Brody, Cresskill, NJ (US); and Ken Saggy, Atlit (IL)
Assigned to SQream, Tel Aviv (IL)
Filed by SQream, Tel Aviv (IL)
Filed on Jul. 12, 2021, as Appl. No. 17/372,971.
Prior Publication US 2023/0008700 A1, Jan. 12, 2023
Int. Cl. G06F 16/22 (2019.01)
CPC G06F 16/22 (2019.01) 20 Claims
OG exemplary drawing
 
10. A method comprising, by a processor and memory circuitry (PMC):
obtaining a plurality of data, wherein the plurality of data comprises one or more groups of data,
obtaining a data structure informative of a plurality of data types according to which data can be represented for their storage, wherein the data structure is usable to determine, for at least a first data type and a second data type among said plurality of data types, a given data type which is adapted to represent at least both data of the first data type and data of the second data type for their storage,
for at least one first group of data of the plurality of data, which comprises a plurality of subsets of data S1 to SN:
for subset S1, determining a current common data type adapted to represent data of subset S1 for its storage,
repeatedly performing, for each subset Si, with i from 2 to N:
determining a data type adapted to represent data of subset Si for its storage, wherein, when this data type is not adapted to represent data of the current common data type, using the data structure to determine a given data type which is adapted to represent both data of subset Si and data of the current common data type, and assigning this given data type as current common data type,
providing the current common data type determined for i=N, which is adapted to represent data of the at least one first group of data for their storage, thereby facilitating storing the at least one first group of data in a database according to this common data type,
or
repeatedly performing, for each subset Si, with i from 1 to N,
determining a data type adapted to represent data of subset Si for its storage, wherein when this data type is not adapted to represent data of a current common data type, using the data structure to determine a given data type which is adapted to represent both data of subset Si and data of the current common data type, and assigning this given data type as current common data type,
wherein for i=1, the current common data type corresponds to a data type of a second group of data of an existing database,
providing the current common data type determined for i=N, which is adapted to represent said second group of data and said at least one first group of data for their storage according to said current common data type, thereby facilitating storing the second group of data with the at least one first group of data of the database according to this common data type.