SYSTEM AND METHOD FOR IMPROVING A QUERY RESPONSE RATE BY MANAGING A COLUMN-BASED STORE IN A ROW-BASED DATABASE
First Claim
Patent Images
1. A system comprising:
- a shared disk database cluster comprising;
one or more database nodes; and
at least two storage nodes including a first storage node or nodes with data organized in a row-based format, and a second storage node or nodes with data organized in a column-based formant, whereineach of the storage nodes comprise a memory; and
each of the one or more database nodes comprise a processor configured to;
when a data write operation is received, write a copy of the data to each of the first storage node(s) and the second storage node(s); and
when a data search request is received;
(i) determine whether the first storage node(s) or the second storage node(s) would be more efficient in producing a result for the received data search request;
(ii) transmit the data search request to the first storage node(s) when the first storage node(s) is determined to be more efficient for the request, and to the second storage node(s) when the second storage node(s) is determined to be more efficient for the request; and
(iii) receive the results of the query from the storage node(s) that is determined to be more efficient.
4 Assignments
0 Petitions
Accused Products
Abstract
A system including a shared disk database cluster including one or more database nodes, and at least two storage nodes including a first storage node or nodes with data organized in a row-based format, and a second storage node or nodes with data organized in a column-based format. A method for efficiently searching utilizing a shared disk database cluster including one or more database nodes, and at least two storage nodes including a first storage node or nodes with data organized in a row-based format, and a second storage node or nodes with data organized in a column-based format.
20 Citations
10 Claims
-
1. A system comprising:
a shared disk database cluster comprising; one or more database nodes; and at least two storage nodes including a first storage node or nodes with data organized in a row-based format, and a second storage node or nodes with data organized in a column-based formant, wherein each of the storage nodes comprise a memory; and each of the one or more database nodes comprise a processor configured to; when a data write operation is received, write a copy of the data to each of the first storage node(s) and the second storage node(s); and when a data search request is received; (i) determine whether the first storage node(s) or the second storage node(s) would be more efficient in producing a result for the received data search request; (ii) transmit the data search request to the first storage node(s) when the first storage node(s) is determined to be more efficient for the request, and to the second storage node(s) when the second storage node(s) is determined to be more efficient for the request; and (iii) receive the results of the query from the storage node(s) that is determined to be more efficient. - View Dependent Claims (3, 4, 8, 10)
-
2. A method for a shared disk database cluster comprising one or more database nodes and at least two storage nodes including a first storage node or nodes with data organized in a row-based format, and a second storage node or nodes with data organized in a column-based formant, the method comprising:
-
when a data write operation is received by a processor of one of the database nodes, writing a copy of the data to each of the first storage node(s) and the second storage node(s), when a data search request is received by the processor;
(i) determining whether the first storage node(s) or the second storage node(s) would be more efficient in producing a result for the received data search request; and
(ii) transmitting the data search request to the first storage node(s) when the first storage node(s) is determined to be more efficient for the request, and to the second storage node(s) when the second storage node(s) is determined to be more efficient for the request; andreceiving the results of the query from the storage node(s) that is determined to be more efficient. - View Dependent Claims (5, 6, 7)
-
-
9. A system comprising:
a shared disk database cluster comprising; one or more database nodes; and at least two storage nodes including a first storage node or nodes with data organized in a row-based format, and a second storage node or nodes with data organized in a column-based formant, wherein each of the storage nodes comprise a memory; and each of the one or more database nodes comprise a processor configured to; when a data write operation is received, write a copy of the data to each of the first storage node(s) and the second storage node(s); and when a data search request is received; (i) determine whether the first storage node(s) or the second storage node(s) is more appropriate for producing a result for the received data search request based on a query response rate; (ii) transmit the data search request to the first storage node(s) when the first storage node(s) is determined to be more appropriate for the request, and to the second storage node(s) when the second storage node(s) is determined to be more appropriate for the request; and (iii) receive the results of the query from the storage node(s) that is determined to be more efficient.
Specification