Storage of small tables as pseudo tables

A computer program product comprising:

• one or more computer-readable storage media;
• and
• program instructions stored on the one or more computer-readable storage media to perform operations comprising:
• determining that a populated table, comprising a record having an attribute value, is smaller than a predefined number of records;
• responsive to determining that the populated table is smaller than the predefined number of records:
• creating a populated pseudo table representing the populated table, the creating the populated pseudo table comprising:
• defining an empty version of the populated table in a software program;
• inserting the record in the populated pseudo table by encoding the attribute value of the record of the populated table as inline data in the software program;
• removing the populated table and thereby reducing overhead and resource consumption;
• and
• responsive to receiving a request for the record:
• returning the record from the populated pseudo table;
• inserting additional records into the populated pseudo table;
• determining that the populated pseudo table satisfies a materialization criterion based on a combination of the record and the additional records exceeding the predefined number of records;
• and
• responsive to determining that the populated pseudo table satisfies the materialization criterion:
• materializing the populated pseudo table by creating the populated table with the record and the additional records encoded in the software program;
• removing the software program;
• and
• responsive to receiving a subsequent request for the record:
• returning the record from the created populated table.

A computer system comprising:

• a processor set;
• one or more computer-readable storage media;
• and
• program instructions stored on the one or more computer-readable storage media to cause the processor set to perform operations comprising:
• determining that a populated table, comprising a record having an attribute value, is smaller than a predefined number of records;
• responsive to determining that the populated table is smaller than the predefined number of records:
• creating a populated pseudo table representing the populated table, the creating the populated pseudo table comprising:
• defining an empty version of the populated table in a software program;
• inserting the record in the populated pseudo table by encoding the attribute value of the record of the populated table as inline data in the software program;
• and
• removing the populated table and thereby reducing overhead and resource consumption;
• inserting additional records into the populated pseudo table;
• determining that the populated pseudo table satisfies a materialization criterion based on a combination of the record and the additional records exceeding the predefined number of records;
• and
• responsive to determining that the populated pseudo table satisfies the materialization criterion:
• materializing the populated pseudo table by creating the populated table with the record and the additional records encoded in the software program;
• removing the software program;
• and
• responsive to receiving a subsequent request for the record:
• returning the record from the created populated table.