Dynamic access paths

1. A computer-implemented method for generating dynamic access paths, comprising:

generating a plurality of real-time statistics (RTS) estimates based on a log of a database;

generating a plurality of access paths based on a structured query language command and the RTS estimates, wherein generating the access paths comprises invoking an optimizer of the database to generate the access paths based on the RTS estimates; and

training a machine learning model to map the RTS estimates to the access paths.

2. The method of claim 1 , further comprising:

determining a current RTS for the database; and

determining an efficient access path based on the current RTS by using the machine learning model.

3. The method of claim 2 , wherein training the machine learning model comprises mapping the RTS estimates and potential system resources associated with the database to the access paths.

4. The method of claim 3 , further comprising determining current system resources, wherein determining the efficient access path comprises determining the efficient access path based on the current system resources.

5. The method of claim 2 , further comprising identifying the efficient access path to an executive component of the database.

6. The method of claim 5 , further comprising executing the efficient access path.

7. The method of claim 1 , further comprising determining periodic statistics of the database, wherein generating the access paths is further based on the periodic statistics.

8. A computer program product comprising program instructions stored on a computer readable storage medium, wherein the computer readable storage medium is not a transitory signal per se, the program instructions executable by a processor to cause the processor to perform a method comprising:

generating a plurality of real-time statistics (RTS) estimates based on a log of a database;

determining periodic statistics of the database;

generating a plurality of access paths based on a structured query language command, the RTS estimates, and the periodic statistics, wherein generating the access paths comprises invoking an optimizer of the database to generate the access paths based on the RTS estimates; and

training a machine learning model to map the RTS estimates to the access paths.

9. The computer program product of claim 8 , further comprising:

determining a current RTS for the database; and

determining an efficient access path based on the current RTS by using the machine learning model.

10. The computer program product of claim 9 , wherein training the machine learning model comprises mapping the RTS estimates and potential system resources associated with the database to the access paths.

11. The computer program product of claim 10 , further comprising determining current system resources, wherein determining the efficient access path comprises determining the efficient access path based on the current system resources.

12. The computer program product of claim 9 , further comprising identifying the efficient access path to an executive component of the database.

13. The computer program product of claim 12 , further comprising executing the efficient access path.

14. A system comprising:

a computer processing circuit; and

a computer-readable storage medium storing instructions, which, when executed by the computer processing circuit, are configured to cause the computer processing circuit to perform a method comprising:

generating a plurality of real-time statistics (RTS) estimates based on a log of a database;

generating a plurality of access paths based on a structured query language command and the RTS estimates, wherein generating the access paths comprises invoking an optimizer of the database to generate the access paths based on the RTS estimates; and

training a machine learning model to map the RTS estimates to the access paths.

15. The system of claim 14 , further comprising:

determining a current RTS for the database;

determining an efficient access path based on the current RTS by using the machine learning model, wherein training the machine learning model comprises mapping the RTS estimates and potential system resources associated with the database to the access paths; and

determining current system resources, wherein determining the efficient access path comprises determining the efficient access path based on the current system resources.

16. The system of claim 15 , the method further comprising:

identifying the efficient access path to an executive component of the database; and

executing the efficient access path.

17. The system of claim 14 , the method further comprising determining periodic statistics of the database, wherein generating the access paths is further based on the periodic statistics.