Flexible tables

摘要

A system includes reception of an instruction to access a column of a database table, determination that the column is not associated with the schema of the database table, determination of whether the schema of the database table is flexible or static, returning, if it is determined that the schema of the database table is static, of an error in response to the instruction, and, if it is determined that the schema of the database table is flexible, not returning an error in response to the instruction.

主权项

1. A system comprising:
a data storage device storing a database table including a first set of columns; a computing device comprising:
a memory storing processor-executable program code; anda processor to execute the processor-executable program code in order to cause the computing device to:receive an instruction to insert a record into the database table, the record including data associated with each column of the first set of columns, and including other data associated with a second column;determine that the second column is not included in a schema of the database table, wherein the schema specifies columns of the database table;determine whether the schema of the database table specifies the database table is flexible or static;if it is determined that the schema of the database table is static, return an error in response to the instruction; andif it is determined that the schema of the database table is flexible, add a new column to the schema of the database table and insert the data of the record into respective ones of the first set of columns and the other data of the record into the new column.