Computing systems and processes for improved database junction relationships

• US 10,282,352 B2
• Filed: 05/03/2016
• Issued: 05/07/2019
• Est. Priority Date: 05/03/2016
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Gray, William Victor
• Primary Examiner(s): Vital, Pierre M
• Assistant Examiner(s): Antoine, Alicia M
• Application Number:
  US15/145,436
• Publication Number:
  US 20170322965A1
• Time in Patent Office: 1,099 Days
• Field of Search: 707609
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06Q 10/109 Time management, e.g. calendars, reminders, meetings or time accounting
• CPC Class Codes: H04L 51/48 Message addressing, e.g. address format or anonymous messages, aliases
• CPC Class Codes: H04L 67/01 Protocols
• CPC Class Codes: H04L 67/1091 Interfacing with client-server systems or between P2P systems

Abstract

Database clients submit junction data (such as invitees to a meeting or other event) at the same time that a new database entity is created. Junction data may be represented within a string array or other data structure that can be delivered using a SOAP, REST or similar protocol for delivering data to the computing server platform. By submitting junction data within the same structure that is used to create the new entity, the likelihood of phantom data or other corruption in the database is greatly reduced.

Claims

1. A process executed by a computer system that interacts with a database, the computer system having a processor and a memory, the process comprising:

storing, by the computer system, a contact list as a first data structure in the database;

storing, by the computer system, an event list as a second data structure separate from the first data structure in the database;

receiving, by the computer system, a request to add a new event to the event list, wherein the request is received via a data network from a remote client device, wherein the request comprises a list of contacts corresponding to contacts maintained in the first data structure that are associated with the new event;

in response to the request received from the client device, the computer system initially sending a first message to the database to obtain a key for the new event and, in response to the computer system receiving the key for the new event from the database, automatically initiating a second message to the database that includes both the key obtained in response to the first message and the list of contacts received in the request from the client device to thereby associate the list of contacts with the new event in the database; and

in response to a subsequent response from the database confirming that the list of contacts has been added to the event, the computer system transmitting a response to the client device via the data network.

2. The process of claim 1, further comprising the computer system updating the list of contacts for one of the events in the list of events to thereby add an additional contact from the contact list in response to a subsequent request received via the data network from the remote client device.

3. The process of claim 1 wherein the updating comprises replacing a prior version of the list of contacts with a new version of the list of contacts that includes the additional contact from the contact list.

4. The process of claim 1 wherein the first and second data structures are database tables.

5. The process of claim 1 wherein the list of contacts is received from the remote client device as a serialized list.

6. The process of claim 5 wherein the serialized list is an array of text strings.

7. The process of claim 6 wherein each of the text strings represents an identifier of one of the contacts in the contacts list.

8. The process of claim 7 wherein the text strings are associated with the second data structure.

9. The process of claim 8 wherein the computer system identifies contacts associated with the new event from the identifiers represented in the text strings of the array.

10. The process of claim 8 wherein each of the identifiers represented in the text string of the array received from the remote client device identifies an invitee to the new event.

11. The process of claim 1 wherein the first and second messages are both sent from the computer system to the database without further intervening communication with the client device so that the newly-created entity is created in the database in response to a single communication from the client device via the data network.

12. A non-transitory computer-implemented process executable by a computer system that manages a database, the process comprising:

receiving, by the computer system from a client device, an electronic request to create a new entry to be listed in a first table in the database, wherein the electronic request received from the client device comprises digital identifiers for at least one entry in a second table in the database that is separate from the first table; and

in response to receiving the request from the client device, the computer system automatically initiating a first message to the database to create the new entry in the first database table and to receive a digital key identifying the new entry in the first database table;

in response to the computer system receiving the digital key identifying the new entry in the first database table, the computer system automatically initiating a second message to the database that comprises both the digital identifiers received from the client device and the digital key received in response to the first message to thereby instruct the database to associate the newly-created entry in the first database table with the digital identifiers for the at least one entry in the second database table; and

transmitting, by the computer system, a single confirmation to the client device after receiving confirmation from the database that the first and second messages were successful.

13. The non-transitory computer-implemented process of claim 12 wherein the first table is a table of events and the second table is a table of contacts.

14. The non-transitory computer-implemented process of claim 13 wherein the electronic request received from the client device is a request for a new event that comprises a list of contacts corresponding to event invitees.

15. The non-transitory computer-implemented process of claim 14 wherein the list is a string array.

16. The non-transitory computer-implemented process of claim 15 wherein the first and second messages are both sent from the computer system to the database without further communication with the client device so that the newly-created entry is created in response to a single electronic request from the client device.

17. The non-transitory computer-implemented process of claim 15 wherein the client request is received by the computer system via a serialized application program interface that receives the digital identifiers in a predetermined format within a first HTTP message, and wherein the single confirmation is transmitted from the computer system to the client device via the serialized application program interface within a second HTTP message.

18. The non-transitory computer-implemented process of claim 17 wherein the serialized application program interface is one of a Simple Object Access Protocol (SOAP) and Representational State Transfer (REST) interface.

19. A computer system that manages a database, the computer system comprising:

an interface to a network; and

a processor configured to;

receive an electronic request to create a new entry to be listed in a first table in the database, wherein the electronic request received from the client device comprises digital identifiers for at least one entry in a second table in the database that is separate from the first table; and

in response to receiving the request from the client device, to initiate both a first message to the database to create the new entry in the first database table and to receive a digital key identifying the new entry in the first database table; and

in response to the computer system receiving the digital key identifying the new entry in the first database table, the computer system automatically initiating a second message to the database that comprises both the digital identifiers received from the client device and the digital key received in response to the first message to thereby instruct the database to associate the newly-created entry in the first database table with the digital identifiers for the at least one entry in the second database table; and

transmit a single confirmation to the client device after receiving confirmation from the database that the first and second messages were successful.

20. The computer system of claim 19 wherein the first table is a table of events and the second table is a table of contacts, and wherein the electronic request received from the client device is a request for a new event that comprises a list of contacts corresponding to event invitees, and wherein the list is represented by a string array.