Ephemeral store-based auto-save for applications with a persistence layer

A method comprising:

• storing user inputs in an auto-save cache, the user inputs being in a particular application and associated with data in a database management system, wherein storing includes:
• performing, at a determined time, an auto-save of data for a particular user and an application instance of the particular application, including:
• storing the user inputs in one or more ephemeral tables, wherein the storing uses an auto-save cache index to determine specific ones of the one or more ephemeral tables that are to be updated, wherein the one or more ephemeral tables survive database sessions, transaction boundaries, and database management system restarts, and wherein surviving includes being retained and not being deleted or lost;
• and
• performing a revert operation including:
• receiving an indication to revert the user inputs to a previous version, including identifying the particular user and the particular application associated with the user inputs;
• receiving a version of interest associated with the user inputs;
• retrieving the user inputs from the auto-save cache, including entries in the one or more ephemeral tables associated with the version, the particular user, and the particular application;
• and
• providing the user inputs.

A system comprising:

• memory storing:
• a data store of metadata associated with auto-saving information associated with user connections;
• and
• an application for:
• receiving, from an application, user inputs associated with a database management system, the user inputs being associated with a particular user and a particular application;
• identifying, from an auto-save cache index, one or more ephemeral tables that are associated with the user inputs, the ephemeral tables mapped to one or more tables in the database management system;
• and
• updating, using the user inputs and the auto-save cache index, the one or more ephemeral tables, wherein the one or more ephemeral tables are separate from, but include schema binding to, the one or more tables in the database management system, wherein the ephemeral tables include row and columns corresponding to the user inputs and include values corresponding to the user inputs that not yet applied to the one or more tables in the database management system, and wherein updating the one or more ephemeral tables includes:
• automatically storing, on a temporal basis, information associated with the user inputs;
• and
• surviving database sessions, transaction boundaries, and database management system restarts, wherein surviving includes being retained and not being deleted or lost.

A non-transitory computer-readable media encoded with a computer program, the program comprising instructions that when executed by one or more computers cause the one or more computers to perform operations comprising:

• receiving, from an application, user inputs associated with a database management system, the user inputs being associated with a particular user and a particular application;
• identifying, from an auto-save cache index, one or more ephemeral tables that are associated with the user inputs, the ephemeral tables mapped to one or more tables in the database management system;
• updating, using the user inputs and the auto-save cache index, the one or more ephemeral tables:
• automatically storing, on a temporal basis, information associated with the user inputs;
• and
• surviving database sessions, transaction boundaries, and database management system restarts, wherein surviving includes being retained and not being deleted or lost;
• and
• performing a revert operation including:
• receiving an indication to revert the user inputs to a previous version, including identifying the particular user and the particular application associated with the user inputs;
• receiving a version of interest associated with the user inputs;
• retrieving the user inputs from the auto-save cache, including entries in the one or more ephemeral tables associated with the version, the particular user, and the particular application;
• and
• providing the user inputs.