Data cube high availability
AssigneeMicrosoft Technology Licensing, LLC
InventorsSiddharth Rana, Govind Saoji, Bhavini Soneji
Life of this patent
Estimating the term…
Abstract
The subject disclosure is directed towards making cube data highly available and efficient to access by separating the read cube server from the processing cube server, on different physical machines. The read cube server may be mirrored, and the write cube server may be mirrored. When the primary read cube server is not operational (e.g., has failed) or is having its read cube synchronized, the read queries are handled by the mirror read cube server. When a processing cube server (or its write cube) is not operational, its mirror processing cube server takes over and performs cube processing operations via its mirror write cube.
Claims21
1-20. (canceled)
An apparatus, comprising:
- a logic circuit;
- and
- logic operative on the logic circuit to communicate a Structured Query Language (SQL) query to a SQL database to determine the state of an active read cube, and direct the SQL query to a passive read cube when the active read cube is not operational or is being synchronized with write data from an active processing cube or from a passive processing cube if the active processing cube is not available.
An apparatus, comprising:
- a primary read server coupled to a primary read cube, the primary read server configured to handle incoming read queries by returning data from the primary read cube;
- a backup read server coupled to a backup read cube for the primary read cube, the backup read server configured to handle incoming read queries by returning data from the backup read cube in response to a failover occurrence;
- a primary processing server coupled to a cube service and a primary write cube, the cube service configured to write data changes in the database to the primary write cube and to synchronize at least one of the primary read cube or the backup read cube based on the data changes;
- and
- a backup processing server coupled to a backup cube service and a backup write cube for the primary write cube, the backup cube service configured to write the data changes to the backup write cube and to synchronize at least one of the primary read cube or backup read cube in response to a failover occurrence.
A computer-implemented method performed at least in part on at least one processor, comprising:
- processing read queries directed to an active read cube at an active read server, including querying a database at a first read server to determine a state of a first read cube, and if the first read cube is active, directing the read queries to the first read server, and if not, directing the read queries to a second read server having a second read cube;
- synchronizing a first write cube or a second write cube of a first write processing server or a second write processing server, respectively, with data changes to the database based on whether the first write cube or the first write processing server is operational;
- and
- synchronizing change data corresponding to the data changes with at least one of the first read cube or the second read cube.
Dependencies are inferred from the claim text.