Materialized view generation

1. A method comprising:

determining whether a selection of database query identifiers is to be made in a fixed manner or a dynamic manner;

generating a collection comprising the selection from a list comprising database query identifiers related to a database, the list to associate the database query identifiers with view names and expressions of executable database query logic, wherein the selection of the database query identifiers comprises a number of database query identifiers selected from the list irrespective of view name and database query logic when the selection is to be made in the fixed manner, and wherein the selection of the database query identifiers comprises a set of database query identifiers selected from the list based on a view naming convention when the selection is to be made in the dynamic manner;

generating materialized views of the database query identifiers in the collection; and

storing an identifier of a materialized view in association with a given database query identifier.

2. The method of claim 1 , wherein the selection is to select database query identifiers corresponding to the most frequently executed queries.

3. The method of claim 1 further comprising, prior to the generating, converting the database query identifiers into corresponding database query logic.

4. The method of claim 1 , further comprising, prior to the generating, determining whether the given database query identifier comprises database query logic by searching the given database query identifier for a string used by a database query logic syntax.

5. The method of claim 1 , wherein the identifier is generated by applying a predetermined transformation to the given database query identifier.

6. The method of claim 1 , wherein the storing the identifier in association with the given database query identifier comprises adding a row to a correlation table, the row containing the identifier and the given database query identifier.

7. A database system comprising:

a memory being computer-readable, the memory to store a database;

a processor in communication with the memory, the processor to:

generate a collection comprising a selection of database query identifiers from a list comprising database query identifiers related to the database, the list to associate the database query identifiers with view names and expressions of executable database query logic, wherein the selection of the database query identifiers comprises a number of database query identifiers selected from the list irrespective of view name and database query logic when an identifier selection indicator is set to fixed, and wherein the selection of the database query identifiers comprises a set of database query identifiers selected from the list based on a view naming convention when the identifier selection indicator is set to dynamic; and

for a given database query identifier in the collection:

generate a materialized view corresponding to the given database query identifier;

assign a given identifier to the materialized view; and

store the given identifier in association with the given database query identifier.

8. The database system of claim 7 , wherein the selection is to select database query identifiers corresponding to the most frequently executed queries.

9. The database system of claim 7 , wherein, before the materialized view is generated, the processor is further to search the given database query identifier for a string used by a database query logic syntax.

10. The database system of claim 9 , wherein the database query logic syntax comprises Structured Query Language (SQL) query syntax and the string comprises “SELECT”.

11. The database system of claim 7 , wherein a predetermined transformation is applied to the given database query identifier to generate the given identifier.

12. The database system of claim 7 , wherein a row is added to a correlation table to store the given identifier in association with the given database query identifier, the row containing the given identifier and the given database query identifier associated with the given identifier.

13. A non-transitory computer-readable storage medium comprising instructions executable by a processor, the instructions to cause the processor to:

determine whether an identifier selection indicator is set to fixed or dynamic;

generate a collection comprising a selection of database query identifiers from a list comprising database query identifiers related to a database, the list to associate the database query identifiers with view names and expressions of executable database query logic, wherein the selection of the database query identifiers comprises a number of database query identifiers selected from the list irrespective of view name and database query logic when the identifier selection indicator is set to fixed, and wherein the selection of the database query identifiers comprises a set of database query identifiers selected from the list based on a view name following a predetermined naming convention when the identifier selection indicator is set to dynamic; and

for a given database query identifier in the collection:

generate a materialized view corresponding to the given database query identifier;

assign a given identifier to the materialized view; and

store the given identifier in association with the given database query identifier.

14. The non-transitory computer readable storage medium of claim 13 , wherein the selection is to select database query identifiers corresponding to the most frequently executed queries.

15. The non-transitory computer readable storage medium of claim 13 , the instructions comprise further instructions to cause the processor to, before the materialized view is generated, search the given database query identifier for a string used by a database query logic syntax.

16. The non-transitory computer readable storage medium of claim 15 , wherein the database query logic syntax comprises SQL query syntax and the string comprises “SELECT”.

17. The non-transitory computer readable storage medium of claim 13 , wherein a predetermined transformation is applied to the given database query identifier to generate the given identifier.

18. The non-transitory computer readable storage medium of claim 13 , wherein the instructions to store the given identifier in association with the given database query identifier comprise instructions to add a row to a correlation table, the row containing the given identifier and the given database query identifier associated with the given identifier.