Internet cloud-hosted natural language interactive messaging system with virtual database

A system comprising:

• one or more processors;
• and
• a non-transitory computer-readable medium containing instructions that, when executed by the one or more processors, cause the one or more processors to perform operations including:
• receive, by a server with a uniform resource identifier (URI) from a source, a hypertext transfer protocol (HTTP) post call message directed to the URI and comprising event data including a message from a user;
• store the event data in a location in a local database, wherein the system includes the local database, and wherein
• the event data is deleted from the location according to a first schedule;
• after storing the event data in the location, store the event data in a remote database according to a second schedule, wherein the remote database is separate from the system, and wherein the first schedule is less often than the second schedule;
• define a virtual database comprising a union of the local database and the remote database;
• expose, to a client application, an application programming interface to receive a query from a user for accessing the virtual database, wherein receiving the query invokes a first invocable method for querying the virtual database;
• calculate a first summary value from the event data of the source, the first summary value quantifying particular actions performed at the source by one or more users, the first summary value being used to generate a materialized view of analytics associated with the source;
• and
• incrementally update, by the server, the first summary value as new event data is received, the first summary value being updated independent from accessing the event data of the local database and the remote database;
• calculate, by the server, a second summary value based at least in part on identifying that a particular action has taken place with respect to a particular user based at least in part on identifying, from a plurality of individual events including the event data received by the server and one or more instances of event data retrieved from the virtual database, that a plurality of required actions associated with the particular action have occurred in accordance with a predefined sequence and within a predefined amount of time of one another;
• expose, to the client application, a second invocable method for accessing the first summary value and the second summary value.

A computer-program product tangibly embodied in a non-transitory machine-readable storage medium, including instructions that, when executed by one or more processors, cause the one or more processors to:

• receive, by a server associated with a uniform resource identifier (URI) from a source, a hypertext transfer protocol (HTTP) post call message directed to the URI and comprising event data including a message from a user;
• store the event data in a location in a local database, wherein the server includes the local database, and wherein
• the event data is deleted from the location according to a first schedule;
• after storing the event data in the location, store the event data in a remote database according to a second schedule, wherein the remote database is separate from the server, and wherein the first schedule is less often than the second schedule;
• define a virtual database comprising a union of the local database and the remote database;
• expose, to a client application, an application programming interface to receive a query from a user for accessing the virtual database, wherein receiving the query invokes a first invocable method for querying the virtual database;
• calculate, by the server, a summary value from the event data of the source, a first summary value quantifying particular actions performed at the source by one or more users, the first summary value being used to generate a materialized view of analytics associated with the source;
• incrementally update the first summary value as new event data is received, the first summary value being updated independent from accessing the event data of the local database and the remote database;
• calculate, by the server, a second summary value based at least in part on identifying that a particular action has taken place with respect to a particular user based at least in part on identifying, from a plurality of individual events including the event data received by the server and one or more instances of event data retrieved from the virtual database, that a plurality of required actions associated with the particular action have occurred in accordance with a predefined sequence and within a predefined amount of time of one another;
• and
• expose, to the client application, a second invocable method for accessing the first summary value and the second summary value.