Read Mostly Instances
AssigneeOracle International Corporation
InventorsWilson Wai Shun Chan, Chandrajith Ramachandran Unnithan
Life of this patent
Estimating the term…
Abstract
According to one aspect of the invention, a read-write instance of a multiple-instance database system receives a database statement for execution. The multiple-instance database system comprises a database shared by a plurality read-mostly instances that request only read access to a plurality of user database objects in the database and a plurality of read-write instances that request both read access and write access to the plurality of user database objects. The read-write instance selects one or more read-mostly instances, in the plurality of read-mostly instances, to perform one or more operations that require no write access to the plurality of user data objects.
Claims20
A multi-instance database system comprising:
- a database storing a plurality of user data objects;
- a plurality of instances configured to perform database operations on one or more of the plurality of user data objects;
- wherein the plurality of instances comprises a plurality of read-write instances configured with read access and write access to the plurality of user data objects;
- wherein the plurality of instances comprises a plurality of read-mostly instances configured with only read access to the plurality of user data objects;
- and
- a read-write instance configured to select one or more read-mostly instances, in the plurality of read-mostly instances, to perform one or more operations that require no write access to the plurality of user data objects.
A method comprising:
- a read-write instance of a multiple-instance database system receiving a database statement for execution, wherein the multiple-instance database system comprises a database shared by a plurality read-mostly instances configured with only read access to a plurality of user database objects in the database and a plurality of read-write instances configured with both read access and write access to the plurality of user database objects;
- and
- the read-write instance selecting one or more read-mostly instances, in the plurality of read-mostly instances, to perform one or more operations that require no write access to the plurality of user data objects;
- wherein the method is performed by one or more computing devices.
One or more non-transitory computer-readable media storing instructions which, when executed by one or more processors, cause performance of a method for evaluating reporting window functions, the method comprising:
- a read-write instance of a multiple-instance database system receiving a database statement for execution, wherein the multiple-instance database system comprises a database shared by a plurality read-mostly instances configured with only read access to a plurality of user database objects in the database and a plurality of read-write instances configured with both read access and write access to the plurality of user database objects;
- and
- the read-write instance selecting one or more read-mostly instances, in the plurality of read-mostly instances, to perform one or more operations that require no write access to the plurality of user data objects.
Dependencies are inferred from the claim text.