TECHNIQUES FOR USING DATABASE METRIC RESULTS
First Claim
Patent Images
1. A method implemented in a computer-readable storage medium and processed by a processor to perform the method, comprising:
- receiving Structured Query Language (SQL) statements;
identifying a first metric calculation and a second metric calculation in the SQL statements, wherein the first metric calculation and the second metric calculation are a source for a target rule within the SQL statements; and
processing the first metric calculation and the second metric calculation against a database and using results as the source that is fed to the target rule within the SQL statements, and wherein the target rule is processed with the results.
1 Assignment
0 Petitions
Accused Products
Abstract
Techniques for using database metric results are provided. Structure Query Language (SQL) statements are parsed for multiple metric calculations. Each metric calculation is dynamically processed against a database to obtain combined results. The combined results are fed to remaining portions of the SQL statements as a source for or a driver to the remaining portions of the SQL statements.
-
Citations
20 Claims
-
1. A method implemented in a computer-readable storage medium and processed by a processor to perform the method, comprising:
-
receiving Structured Query Language (SQL) statements; identifying a first metric calculation and a second metric calculation in the SQL statements, wherein the first metric calculation and the second metric calculation are a source for a target rule within the SQL statements; and processing the first metric calculation and the second metric calculation against a database and using results as the source that is fed to the target rule within the SQL statements, and wherein the target rule is processed with the results. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A method implemented in a computer-readable storage medium and processed by a processor to perform the method, comprising:
-
dynamically parsing Structured Query Language (SQL) statements to obtain a first metric calculation and a second metric calculation; processing the first metric calculation and the second metric calculation against a database and summing first results from the first metric calculation with second results from the second metric calculation to produce combined results; and using the combined results as input to other portions of the SQL statements when processing the other portions against the database. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. A computer-implemented system that executes on one or more processors, the system comprising:
-
a Structured Query Language (SQL) preprocessor implemented in a computer-readable storage medium and executed by a processor of a network; and a data store implemented in a computer-readable storage medium and accessible to the SQL preprocessor; wherein the SQL preprocessor iterates SQL statements to automatically and dynamically identify and process multiple metric calculations against the database to produce combined results that feed other portions of the SQL statements when those other portions of the SQL statements are processed. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification