Apparatus to query a relational database using text-based queries
A control circuit has access to both a relational database comprised of structured data and a text-based index of reciprocal queries for the relational database. The control circuit, upon receiving a text-based query via a user input, applies the text-based query to the text-based index of reciprocal queries to thereby obtain one or more reciprocal queries that the control circuit uses to query the relational database for structured data content responsive to the text-based query. By one approach the text-based index of reciprocal queries comprises a text-based index of SQL reciprocal queries. By one approach the text-based index of reciprocal queries comprises at least one virtual document.
1. An apparatus comprising:
a first memory having at least one relational database comprised of structured data stored therein;
a second memory having a text-based index of reciprocal queries for the at least one relational database;
a user interface;
a control circuit operably coupled to the first memory, the second memory, and the user interface, the control circuit configured to:
obtain a set of rules that identify a reciprocal query from the second memory as a function of a text-based query by searching the text-based index to identify text-based entries in the text-based index that correlate to the text-based query and then retrieving a reciprocal query that correlates to the identified text-based entry in the text-based index;
receive a text-based query via the user interface;
identify a reciprocal query from the second memory by evaluating the received text-based query against the set of rules;
use the identified reciprocal query to query the relational database for structured data content responsive to the text-based query.
2. The apparatus of claim 1 wherein the text-based index of reciprocal queries comprises a text-based index of Structured Query Language (SQL) reciprocal queries.
3. The apparatus of claim 1 wherein the text-based index of reciprocal queries comprises at least one virtual document.
4. The apparatus of claim 1 wherein the text-based query includes at least one Boolean operator.
5. The apparatus of claim 1 wherein the control circuit is configured to apply the text-based query to the text-based index of reciprocal queries to thereby query the relational database without presenting to a user via a user interface any of the reciprocal queries.
6. The apparatus of claim 1 wherein the control circuit comprises a part of a server-side configuration.
7. The apparatus of claim 1 wherein the control circuit comprises a part of a client-side configuration.
8. The apparatus of claim 1 wherein the control circuit is configured to apply the text-based query to the text-based index of reciprocal queries to thereby query a plurality of relational databases for structured data content responsive to the text-based query.
9. The apparatus of claim 8 wherein the control circuit is further configured to provide the structured data content that is responsive to the text-based query via the user interface without indicating which of the plurality of relational databases sourced the provided structured data content.
10. An apparatus comprising:
at least one physical shopping facility having a plurality of items available for sale;
a first memory having at least one relational database comprised of structured data stored therein regarding the plurality of items;
a second memory having a text-based index of reciprocal queries for the at least one relational database;
a user interface;
a control circuit operably coupled to the first memory, the second memory, and the user interface, the control circuit configured to:
obtain a set of rules that identify a reciprocal query from the second memory as a function of a text-based query by searching the text-based index to identify text-based entries in the text-based index that correlate to the text-based query and then retrieving a reciprocal query that correlates to the identified text-based entry in the text-based index;
receive a text-based query regarding at least one of the plurality of items via the user interface;
identify a reciprocal query from the second memory by evaluating the received text-based query against the set of rules;
use the identified reciprocal query to thereby search the relational database for structured data content responsive to the text-based query.
11. The apparatus of claim 10 wherein the text-based index of reciprocal queries comprises text-based index of Structured Query Language (SQL) reciprocal queries.
12. The apparatus of claim 10 wherein the text-based index of reciprocal queries comprises at least one virtual document.
13. The apparatus of claim 10 wherein the text-based query includes at least one Boolean operator.
14. The apparatus of claim 10 wherein the control circuit is configured to apply the text-based query to the text-based index of reciprocal queries to thereby query the relational database without presenting to a user via a user interface any of the reciprocal queries.
15. The apparatus of claim 10 wherein the control circuit comprises a part of at least one of a server-side configuration and a client-side configuration.
16. The apparatus of claim 10 wherein at least some entries in the text-based index of reciprocal queries were automatically generated.
17. The apparatus of claim 10 wherein the control circuit is configured to apply the text-based query to the text-based index of reciprocal queries to thereby query a plurality of relational databases for structured data content responsive to the text-based query.
18. The apparatus of claim 17 wherein the control circuit is further configured to provide the structured data content that is responsive to the text-based query via the user interface without indicating which of the plurality of relational databases sourced the provided structured data content.