Flexible tables
View Patent ↗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; and
a 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; and
if 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.
2. A system according to claim 1 , wherein the processor is to further execute the processor-executable program code in order to cause the computing device to:
receive a second instruction to query a third column of the database table;
determine that the third column is not included in the schema of the database table; and
if it is determined that the schema of the database table is flexible, return a NULL value associated with the third column in response to the second instruction.
3. A system according to claim 1 , wherein the data storage device stores the database table in columnar format.
4. A non-transitory computer-readable medium storing program code, the program code executable by a processor of a computing system to cause the computing system to:
receive an instruction to insert a record into a database table including a first set of columns, 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; and
if 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.
5. A medium according to claim 4 , wherein the processor is to further execute the processor-executable program code in order to cause the computing device to:
receive a second instruction to query a third column;
determine that the third column is not included in the schema of the database table; and
if it is determined that the schema of the database table is flexible, return a NULL value associated with the third column in response to the second instruction.
6. A medium according to claim 4 , wherein the database table is stored in columnar format.
7. A computer-implemented method for a computing device comprising a memory storing processor-executable program code and a processor to execute the processor-executable program code to cause the computing device to perform the method, the method comprising:
receiving an instruction to insert a record into a database table including a first set of columns, the record including data associated with each column of the first set of columns, and
including other data associated with a second column;
determining that the second column is not included in a schema of the database table, wherein the schema specifies columns of the database table;
determining 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, returning an error in response to the instruction; and
if 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.
8. A method according to claim 7 , the method further comprising:
receiving a second instruction to query a third column of the database table;
determine that the third column is not included in the schema of the database table; and
if it is determined that the schema of the database table is flexible, returning a NULL value associated with the third column in response to the second instruction.
9. A method according to claim 7 , wherein the database table is stored in columnar format.