Computing systems and processes for improved database junction relationships
Assigneesalesforce.com, inc.
InventorWilliam Victor Gray
Life of this patent
Estimating the term…
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.
Claims20
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;
- and
- in response to the request, the computer system sending both a first message to the database to obtain a key for the new event and a second message that includes the key obtained in response to the first message and the list of contacts received in the request to thereby associate the list of contacts with the new event.
11i. The process of claim 1 wherein the first and second messages are both sent from the computer system to the database without further input from the client device.
A 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 for 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 both a first message to the database to create the new entry in the first database table and a second message 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.
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 for a first table in the database from a client device via the network, 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 a second message 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.
Dependencies are inferred from the claim text.