Transformation of property-value table to facilitate search

1. A system comprising:

a memory storing processor-executable program code; and

a processing unit to execute the processor-executable program code in order to cause the system to:

identify first distinct values of a key column of a property-value table;

create a new table including a new key column, the new key column populated with only one of each of the identified first distinct values;

identify second distinct values of a property column of the property-value table;

create only one property column of the new table for each of the identified second distinct values;

populate each cell of the property columns with a value of the property-value table associated with the first distinct value of the row of the cell and the second distinct value of the property column of the cell in the property-value table; and

after population of each cell of the property columns:

receive a search query including the property-value table from a requestor computing system;

identify the new table as a search table of the property-value table;

execute the search query on the new table; and

return a result of the executed search query to the requestor computing system via one or more computing networks.

2. A system according to claim 1 , wherein population of each cell of the property columns with a value of the property-value table comprises:

determination of a property and a key associated with a value of the property-value table, and population of a cell of the new table associated with the key and the property with the value.

3. A system according to claim 1 , the processing unit to execute the processor-executable program code in order to cause the system to:

after population of each cell of the property columns, associate the new table with the property-value table in metadata.

4. A system according to claim 3 , wherein association of the new table with the property-value table in metadata comprises designation of the new table as the search table for the second distinct values of the property column of the property-value table.

5. A system according to claim 1 , wherein the property-value table is associated with a database table, and the processing unit to execute the processor-executable program code in order to cause the system to:

execute a join between the new table and the database table.

6. A system according to claim 1 , the processing unit to execute the processor-executable program code in order to cause the system to:

identify third distinct values of the key column of the property-value table;

create a second new table including a second new key column, the second new key column populated with only one of each of the identified third distinct values;

identify fourth distinct values of the property column of the property-value table;

create only one property column of the second new table for each of the identified fourth distinct values;

populate each cell of the property columns of the second new table with a value of the property-value table associated with the third distinct value of the row of the cell and the fourth distinct value of the property column of the cell in the property-value table; and

after population of each cell of the property columns of the second new table, perform a search on the second new table,

wherein the fourth distinct values are different from the second distinct values.

7. A computer-implemented method comprising:

identifying first distinct values of a key column of a property-value table;

creating a new table including a new key column, the new key column populated with only one of each of the identified first distinct values;

identifying second distinct values of a property column of the property-value table;

adding only one property column to the new table for each of the identified second distinct values;

populating each cell of the property columns with a value of the property-value table associated with the first distinct value of the row of the cell and the second distinct value of the property column of the cell in the property-value table; and

after populating each cell of the property columns:

receiving a search query including the property-value table from a requestor computing system;

identifying the new table as a search table of the property-value table;

executing the search query on the new table; and

returning a result of the executed search query to the requestor computing system over one or more computing networks.

8. A method according to claim 7 , wherein populating each cell of the property columns with a value of the property-value table comprises:

determining a property and a key associated with a value of the property-value table, and populating a cell of the new table associated with the key and the property with the value.

9. A method according to claim 7 , further comprising:

after populating each cell of the property columns, associating the new table with the property-value table in metadata.

10. A method according to claim 9 , wherein associating the new table with the property-value table in metadata comprises designating the new table as the search table for the second distinct values of the property column of the property-value table.

11. A method according to claim 7 , wherein the property-value table is associated with a database table, the method further comprising:

executing a join between the new table and the database table.

12. A method according to claim 7 , further comprising:

identifying third distinct values of the key column of the property-value table;

creating a second new table including a second new key column, the second new key column populated with only one of each of the identified third distinct values;

identifying fourth distinct values of the property column of the property-value table;

adding only one property column of the second new table for each of the identified fourth distinct values;

populating each cell of the property columns of the second new table with a value of the property-value table associated with the third distinct value of the row of the cell and the fourth distinct value of the property column of the cell in the property-value table; and

after populating each cell of the property columns of the second new table, performing a search using the second new table,

wherein the fourth distinct values are different from the second distinct values.

13. A non-transitory medium storing processor-executable program code, the program code executable by a computing system to cause the computing system to:

identify first distinct values of a key column of a property-value table;

create a new table including a new key column, the new key column populated with only one of each of the identified first distinct values;

identify second distinct values of a property column of the property-value table;

create only one property column of the new table for each of the identified second distinct values;

populate each cell of the property columns with a value of the property-value table associated with the first distinct value of the row of the cell and the second distinct value of the property column of the cell in the property-value table; and

after population of each cell of the property columns:

receive a search query including the property-value table from a requestor computing system;

identify the new table as a search table of the property-value table;

execute the search query on the new table; and

return a result of the executed search query to the requestor computing system over one or more computing networks.

14. A medium according to claim 13 , wherein population of each cell of the property columns with a value of the property-value table comprises:

determination of a property and a key associated with a value of the property-value table, and population of a cell of the new table associated with the key and the property with the value.

15. A medium according to claim 13 , the program code executable by a computing system to cause the computing system to:

after population of each cell of the property columns, associate the new table with the property-value table in metadata.

16. A medium according to claim 15 , wherein association of the new table with the property-value table in metadata comprises designation of the new table as the search table for the second distinct values of the property column of the property-value table.

17. A medium according to claim 13 , wherein the property-value table is associated with a database table, and the program code executable by a computing system to cause the computing system to:

execute a join between the new table and the database table.

18. A medium according to claim 13 , the program code executable by a computing system to cause the computing system to:

identify third distinct values of the key column of the property-value table;

create a second new table including a second new key column, the second new key column populated with only one of each of the identified third distinct values;

identify fourth distinct values of the property column of the property-value table;

create only one property column of the second new table for each of the identified fourth distinct values;

populate each cell of the property columns of the second new table with a value of the property-value table associated with the third distinct value of the row of the cell and the fourth distinct value of the property column of the cell in the property-value table; and

after population of each cell of the property columns of the second new table, perform a search on the second new table,

wherein the fourth distinct values are different from the second distinct values.