Method, system, and program for improving performance of database queries
First Claim
Patent Images
1. A method for improving performance for SQL queries, comprising:
- obtaining multidimensional metadata associated with a cube model metadata object;
automatically identifying one or more summary tables to be built based on the obtained multidimensional metadata; and
automatically identifying one or more indexes to create based on the obtained multidimensional metadata.
1 Assignment
0 Petitions
Accused Products
Abstract
Disclosed is a system, method, and program for improving the performance for SQL queries. Multidimensional metadata associated with a cube model metadata object is obtained. One or more summary tables to be built are automatically identified based on the obtained multidimensional metadata. One or more indexes to create are automatically identified based on the obtained multidimensional metadata.
-
Citations
40 Claims
-
1. A method for improving performance for SQL queries, comprising:
-
obtaining multidimensional metadata associated with a cube model metadata object;
automatically identifying one or more summary tables to be built based on the obtained multidimensional metadata; and
automatically identifying one or more indexes to create based on the obtained multidimensional metadata. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 40)
-
-
22. An article of manufacture including a program for improving performance for SQL queries, wherein the program causes operations to be performed, the operations comprising:
-
obtaining multidimensional metadata associated with a cube model metadata object;
automatically identifying one or more summary tables to be built based on the obtained multidimensional metadata; and
automatically identifying one or more indexes to create based on the obtained multidimensional metadata. - View Dependent Claims (23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35)
-
-
36. A system for improving performance for SQL queries, comprising:
-
a computer system having at least one program for;
(i) obtaining multidimensional metadata associated with a cube model metadata object;
(ii) automatically identifying one or more summary tables to be built based on the obtained multidimensional metadata; and
(iii) automatically identifying one or more indexes to create based on the obtained multidimensional metadata. - View Dependent Claims (37, 38, 39)
-
Specification