Patent ID: 9576006
Date: 2017-02-21
CPC Classifications: G06F

Claim:
1. A method of storing data in a database in a memory, the database having a main table and an auxiliary table, the method which comprises providing: a memory and a database management system for allocating memory space in the memory, the database management system configured for storing the data in the database without using an nvarchar(MAX) data type by performing the following steps: dividing the data into a sequence of segments each having a size smaller than a predetermined threshold, the sequence of segments including a first segment and further segments; storing the first segment of the sequence in a first field of a given record of the main table of the database; storing an index indexing the data in a second field of the given record; storing the further segments of the sequence in first fields of corresponding records of the auxiliary table of the database; generating further indexes associated with the further segments and storing each further index thus generated in a second field of a record of the auxiliary table that stores the associated segment of the sequence and also in a third field of the record of the auxiliary table that stores a preceding segment in the sequence; and storing, in a third field of the given record of the main table, the index of a first segment of the further segments of the sequence that is stored in the auxiliary table, wherein the index in the third field of the given record of the main table is identical to the index in the second field of the record in the auxiliary table.