Index contention under high concurrency in a database system
Assigneesalesforce.com, inc.
InventorRohitashva MATHUR
Life of this patent
Estimating the term…
Abstract
A database query message may be received at a database system via a network. The database query message may include one or more parameters for retrieving data from a database based on a designated database record insertion timestamp. A database query may be executed against the database system to retrieve one or more database records based on a database record insertion timestamp range determined based on the designated database record insertion timestamp and including a plurality of database record insertion timestamp values.
Claims20
A method comprising:
- receiving a database query message at a database system via a network, the database query message including one or more parameters for retrieving data from a database based on a designated database record insertion timestamp;
- executing a database query against the database system to retrieve one or more database records based on a database record insertion timestamp range, the database record insertion timestamp range determined based on the designated database record insertion timestamp, the database record insertion timestamp range including a plurality of database record insertion timestamp values, wherein a designated database record inserted into the database at a time corresponding to the designated database record insertion timestamp is associated with one of the plurality of database record insertion timestamp values;
- and
- transmitting a response message via the network, the response message identifying the one or more database records.
A database system implemented using a server system, the database system configurable to perform a method comprising:
- receiving a database query message via a network, the database query message including one or more parameters for retrieving data from a database based on a designated database record insertion timestamp;
- executing a database query against the database system to retrieve one or more database records based on a database record insertion timestamp range, the database record insertion timestamp range determined based on the designated database record insertion timestamp, the database record insertion timestamp range including a plurality of database record insertion timestamp values, wherein a database record inserted into the database at a time corresponding to the designated database record insertion timestamp is associated with one of the plurality of database record insertion timestamp values;
- and
- transmitting a response message via the network, the response message identifying the one or more database records.
One or more non-transitory computer-readable media having stored thereon computer instructions capable of causing a computer to perform a method, the method comprising:
- receiving a database query message at a database system via a network, the database query message including one or more parameters for retrieving data from a database based on a designated database record insertion timestamp;
- executing a database query against the database system to retrieve one or more database records based on a database record insertion timestamp range, the database record insertion timestamp range determined based on the designated database record insertion timestamp, the database record insertion timestamp range including a plurality of database record insertion timestamp values, wherein a database record inserted into the database at a time corresponding to the designated database record insertion timestamp is associated with one of the plurality of database record insertion timestamp values;
- and
- transmitting a response message via the network, the response message identifying the retrieved database records.
Dependencies are inferred from the claim text.