Method and mechanism of handling reporting transactions in database systems
AssigneeOracle International Corporation
InventorsSashikanth Chandrasekaran, Angelo Pruscino
Life of this patent
Estimating the term…
Abstract
Disclosed are improved methods, systems, and mediums for handling reporting transactions in database systems. In some embodiments, database snapshots are used to carry out reporting transactions on a failover node concurrently with execution of non-reporting transactions on a primary node.
Claims23
A method of handling reporting transactions in database systems, the method comprising:
- taking a snapshot of a database, wherein the database is linked to a primary node and a failover node;
- executing one or more non-reporting transactions on the primary node;
- and
- utilizing the snapshot to carry out a reporting transaction on the failover node concurrently with the execution of the one or more non-reporting transactions on the primary node.
A computer program product that includes a computer readable medium, the computer readable medium comprising instructions which, when executed by a processor, causes the processor to execute a process for handling reporting transactions in database systems, the process comprising:
- taking a snapshot of a database, wherein the database is linked to a primary node and a failover node;
- executing one or more non-reporting transactions on the primary node;
- and
- utilizing the snapshot to carry out a reporting transaction on the failover node concurrently with the execution of the one or more non-reporting transactions on the primary node.
A system for handling reporting transactions in database systems, the system comprising:
- means for taking a snapshot of a database, wherein the database is linked to a primary node and a failover node;
- means for executing one or more non-reporting transactions on the primary node;
- and
- means for utilizing the snapshot to carry out a reporting transaction on the failover node concurrently with the execution of the one or more non-reporting transactions on the primary node.
Dependencies are inferred from the claim text.