Methods and systems for ordering query results based on annotations
View Patent ↗A system, method and article of manufacture for managing query results and, more particularly, for sorting data records contained in a query result obtained in response to execution of a query against a database. In one embodiment, the data records in the query result are sorted on the basis of related information which is retrieved from a corresponding data source. In another embodiment, the sorting is performed on the basis of a value variance which is determined for each of the data records in the query result. In still another embodiment, the sorting is performed on the basis of a requested value range coverage. In yet another embodiment, the sorting is performed on the basis of suitability scores which are determined with respect to analysis routines which are configured for processing the query result.
1. A computer-implemented method, comprising:
in response to a query issued by a requesting entity against a data abstraction model abstractly describing data in a database, wherein the query specifies to order query results responsive to the query, based on a relative proximity between: (i) data retrieved for a logical field of the data abstraction model, and (ii) a predefined value, wherein the query specifies the predefined value:
a) receiving a list of data records ordered according to an initial order, the list of data records defining a result set for the query;
b) before outputting the result set, determining a value variance for each data record in the list, the value variance of a given data record indicating a relative proximity between the predefined value and a corresponding value of the given data record;
c) sorting the received list of data records on the basis of the determined value variances; and
d) outputting the sorted list of data records.
2. The method of claim 1 , wherein sorting the received list of data records on the basis of the predefined value variance comprises:
ranking the data records according to the determined relative proximities.
3. The method of claim 1 , wherein the query comprises:
(i) data selection criteria configured to select the data records of the list of data records from the database; and
(ii) sorting criteria configured to specify the predefined value.
4. The method of claim 3 , further comprising:
identifying the data selection criteria from the issued query;
identifying the sorting criteria from the issued query; and
generating a query on the basis of the identified data selection criteria.
5. The method of claim 4 , wherein at least one of the issued query and the generated query is one of an SQL and an XML query.
6. The method of claim 4 , further comprising:
executing the generated query against the database to identify the data records of the list of data records.
7. The method of claim 6 , wherein the issued query and the generated query are abstract queries, each having one or more logical fields of the data abstraction model; and wherein the data abstraction model is adapted for transforming the one or more logical fields of the abstract queries into a form consistent with a physical representation of the data in the database.
8. The method of claim 6 , wherein the database is a server-side data source and the sorting is done by a client-side application.
9. The method of claim 6 , wherein the database is a server-side data source and the sorting is done by a server-side application.
10. A computer-readable storage medium containing a program which, when executed by a processor, performs operations comprising:
in response to a query issued by a requesting entity against a data abstraction model abstractly describing data in a database, wherein the query specifies to order query results responsive to the query, based on a relative proximity between: (i) data retrieved for a logical field of the data abstraction model, and (ii) a predefined value, wherein the query specifies the predefined value:
a) receiving a list of data records ordered according to an initial order, the list of data records defining a result set for the query;
b) before outputting the result set, determining a value variance for each data record in the list, the value variance of a given data record indicating a relative proximity between a predefined value and a corresponding value of the given data record;
c) sorting the received list of data records on the basis of the determined value variances; and
d) outputting the sorted list of data records.
11. The computer-readable storage medium of claim 10 , wherein sorting the received list of data records on the basis of the predefined value variance comprises:
ranking the data records according to the determined relative proximities.
12. The computer-readable storage medium of claim 10 , wherein the query comprises:
(i) data selection criteria configured to select the data records of the list of data records from the database; and
(ii) sorting criteria configured to specify the predefined value.
13. The computer-readable storage medium of claim 12 , wherein the operations further comprise:
identifying the data selection criteria from the issued query;
identifying the sorting criteria from the issued query; and
generating a query on the basis of the identified data selection criteria.
14. The computer-readable storage medium of claim 13 , wherein at least one of the issued query and the generated query is one of an SQL and an XML query.
15. The computer-readable storage medium of claim 13 , wherein the operations further comprise:
executing the generated query against the database to identify the data records of the list of data records.
16. The computer-readable storage medium of claim 15 , wherein the issued query and the generated query are abstract queries, each having one or more logical fields of the data abstraction model; and wherein the data abstraction model is adapted for transforming the one or more logical fields of the abstract queries into a form consistent with a physical representation of the data in the database.
17. The computer-readable storage medium of claim 15 , wherein the database is a server-side data source and the sorting is done by a client-side application.
18. The computer-readable storage medium of claim 15 , wherein the database is a server-side data source and the sorting is done by a server-side application.
19. A computer system, comprising:
one or more computer processors;
a memory containing a program which, when executed by the one or more computer processors, is configured to perform an operation in response to a query issued by a requesting entity against a data abstraction model abstractly describing data in a database, wherein the query specifies to order query results responsive to the query, based on a relative proximity between: (i) data retrieved for a logical field of the data abstraction model, and (ii) a predefined value, wherein the query specifies the predefined value, wherein the operation comprises:
a) receive a list of data records ordered according to an initial order, the list of data records defining a result set for the query;
b) before outputting the result set, determine a value variance for each data record in the list, the value variance of a given data record indicating a relative proximity between a predefined value and a corresponding value of the given data record;
c) sort the received list of data records on the basis of the determined value variances; and
d) output the sorted list of data records.