Facilitating mobile device interaction with an enterprise database system

• US 9,961,519 B1
• Filed: 08/01/2017
• Issued: 05/01/2018
• Est. Priority Date: 08/01/2017
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Ashe, Subrata
• Primary Examiner(s): Ajayi, Joel
• Application Number:
  US15/666,283
• Time in Patent Office: 273 Days
• Field of Search: 455466
• CPC Class Codes: G06F 16/219 Managing data history or versioning querying versioned data G06F16/2474; querying temporal data G06F16/2477
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: H04W 4/12 Messaging; Mailboxes; Announcements

Abstract

Disclosed are systems, methods, apparatus and computer program products for facilitating text-based interaction by a mobile device with an enterprise database. In some implementations, a first one or more text messages sent from a mobile device during a session is parsed to identify a command and a type of enterprise work record. It is determined that the identified command and record type were previously identified. One or more fields of the record type required by the enterprise database to be populated to carry out the identified command is determined. A request message requesting user input to populate the one or more fields can be sent to the mobile device, and instructions can be sent to the enterprise database to carry out the identified command with respect to the identified type of enterprise work record using the field data.

Claims

1. A system for facilitating interaction by a mobile device with an enterprise database storing a plurality of enterprise work records, the system comprising:

a server system comprising a hardware processor in communication with a local memory, the server system configurable to cause;

parsing a first one or more text messages sent from the mobile device during a session to identify one of a plurality of commands and one of a plurality of types of the enterprise work records;

determining, using historical data stored in the local memory and without querying the enterprise database, that the identified command and the identified type of enterprise work record were previously identified by parsing a previous one or more text messages sent from the mobile device during the session;

identifying, responsive to the determination, one or more fields of the identified type of enterprise work record required by the enterprise database to be populated to carry out the identified command;

sending a request message to the mobile device, the request message requesting user input to populate the one or more fields;

parsing a second text message sent from the mobile device during the session to identify field data for the one or more fields; and

sending instructions to the enterprise database to carry out the identified command with respect to the identified type of enterprise work record using the identified field data.

2. The system of claim 1, the server system further configurable to cause:

retrieving, from the historical data and without querying the enterprise database, a set of most-frequently used commands and a set of most-frequently accessed enterprise work records or types of enterprise work records; and

sending one or more prompt messages to the mobile device, the one or more prompt messages indicating the set of most-frequently used commands and the set of most-frequently accessed enterprise work records or types of enterprise work records, the one or more prompt messages prompting a user of the mobile device to select one of the most-frequently used commands and one of the most-frequently accessed types of enterprise work records as the identified command and the identified type of enterprise work record.

3. The system of claim 1, the server system further configurable to cause:

establishing or maintaining the session by authenticating a user of the mobile device using an identifiable uniform resource locator (URL) and a login credential sent from the mobile device, the login credential identifying the user.

4. The system of claim 1, the server system further configurable to cause:

updating, in the historical data, a list of most-frequently used commands and most-frequently used types of enterprise work records based on the identified command and the identified type of enterprise work record.

5. The system of claim 1, the server system further configurable to cause:

updating the historical data to include the identified field data in association with the identified command and the identified type of enterprise work record.

6. The system of claim 1, the server system further configurable to cause:

generating the instructions to identify one or more of a plurality of application programming interfaces (APIs) configured to enable the enterprise database to carry out the identified command with respect to the identified type of enterprise work record using the identified field data; and

storing the instructions in the local memory.

7. The system of claim 1, the server system further configurable to cause:

retrieving the instructions from the local memory.

8. The system of claim 1, wherein the required one or more fields are identified using the historical data and without querying the enterprise database, the required one or more fields having been previously communicated from the enterprise database to the server system in association with a schema update for a build at the enterprise database.

9. A computer program product comprising computer-readable program code capable of being executed by one or more processors when retrieved from a non-transitory computer-readable medium, the program code comprising instructions configurable to cause:

parsing a first one or more text messages sent from the mobile device during a session to identify one of a plurality of commands and one of a plurality of types of the enterprise work records;

determining, using historical data stored in a local memory and without querying the enterprise database, that the identified command and the identified type of enterprise work record were previously identified by parsing a previous one or more text messages sent from the mobile device during the session;

identifying, responsive to the determination, one or more fields of the identified type of enterprise work record required by the enterprise database to be populated to carry out the identified command;

sending a request message to the mobile device, the request message requesting user input to populate the one or more fields;

parsing a second text message sent from the mobile device during the session to identify field data for the one or more fields; and

sending instructions to the enterprise database to carry out the identified command with respect to the identified type of enterprise work record using the identified field data.

10. The computer program product of claim 9, the instructions further configurable to cause:

retrieving, from the historical data and without querying the enterprise database, a set of most-frequently used commands and a set of most-frequently accessed enterprise work records or types of enterprise work records; and

sending one or more prompt messages to the mobile device, the one or more prompt messages indicating the set of most-frequently used commands and the set of most-frequently accessed enterprise work records or types of enterprise work records, the one or more prompt messages prompting a user of the mobile device to select one of the most-frequently used commands and one of the most-frequently accessed types of enterprise work records as the identified command and the identified type of enterprise work record.

11. The computer program product of claim 9, the instructions further configurable to cause:

establishing or maintaining the session by authenticating a user of the mobile device using an identifiable uniform resource locator (URL) and a login credential sent from the mobile device, the login credential identifying the user.

12. The computer program product of claim 9, the instructions further configurable to cause:

updating, in the historical data, a list of most-frequently used commands and most-frequently used types of enterprise work records based on the identified command and the identified type of enterprise work record.

13. The computer program product of claim 9, the instructions further configurable to cause:

updating the historical data to include the identified field data in association with the identified command and the identified type of enterprise work record.

14. The computer program product of claim 9, the instructions further configurable to cause:

generating the instructions to identify one or more of a plurality of application programming interfaces (APIs) configured to enable the enterprise database to carry out the identified command with respect to the identified type of enterprise work record using the identified field data; and

storing the instructions in the local memory.

15. The computer program product of claim 9, the instructions further configurable to cause:

retrieving the instructions from the local memory.

16. A method comprising:

parsing a first one or more text messages sent from the mobile device during a session to identify one of a plurality of commands and one of a plurality of types of the enterprise work records;

determining, using historical data stored in a local memory and without querying the enterprise database, that the identified command and the identified type of enterprise work record were previously identified by parsing a previous one or more text messages sent from the mobile device during the session;

identifying, responsive to the determination, one or more fields of the identified type of enterprise work record required by the enterprise database to be populated to carry out the identified command;

sending a request message to the mobile device, the request message requesting user input to populate the one or more fields;

parsing a second text message sent from the mobile device during the session to identify field data for the one or more fields; and

sending instructions to the enterprise database to carry out the identified command with respect to the identified type of enterprise work record using the identified field data.

17. The method of claim 16, further comprising:

retrieving, from the historical data and without querying the enterprise database, a set of most-frequently used commands and a set of most-frequently accessed enterprise work records or types of enterprise work records; and

sending one or more prompt messages to the mobile device, the one or more prompt messages indicating the set of most-frequently used commands and the set of most-frequently accessed enterprise work records or types of enterprise work records, the one or more prompt messages prompting a user of the mobile device to select one of the most-frequently used commands and one of the most-frequently accessed types of enterprise work records as the identified command and the identified type of enterprise work record.

18. The method of claim 16, further comprising:

establishing or maintaining the session by authenticating a user of the mobile device using an identifiable uniform resource locator (URL) and a login credential sent from the mobile device, the login credential identifying the user.

19. The method of claim 16, further comprising:

updating, in the historical data, a list of most-frequently used commands and most-frequently used types of enterprise work records based on the identified command and the identified type of enterprise work record.

20. The method of claim 16, further comprising:

updating the historical data to include the identified field data in association with the identified command and the identified type of enterprise work record.