Simplified search interface for querying a relational database
First Claim
1. A method for searching a relational database, the method comprising:
- providing a search object model on a computer to perform keyword-based and structured query language (SQL)-based searches of the relational database;
providing an abstract query class of the search object model defining an execute method for causing a query to be performed on the relational database and one or more query properties that specify a query string and the manner in which the query is performed;
providing a keyword query class derived from the abstract query class, the keyword query class defining a query request using keyword syntax and comprising an execute method which when called causes a keyword query to be performed on the relational database and one or more keyword query properties that specify how the keyword query is to be performed and how results from the keyword query are to be returned; and
setting the query string to specify one or more keywords to pass directly to a search service for performing a keyword-based search of the relational database.
5 Assignments
0 Petitions
Accused Products
Abstract
Methods and computer-readable media are provided for performing a search on a relational database. According to one method, a query class is provided that includes properties that specify how a query is to be performed and how results from the query are to be returned, and an execute method that is called to perform the actual query. A keyword query class derived from the query class is also provided that includes keyword query properties and an execute method for performing the keyword query. In order to perform a keyword query of an SQL database, an instance of the keyword query class is created, the properties set on the instance, and the execute method called. When the execute method is called, the specified properties are translated into an equivalent SQL statement and the search is performed on the identified relational database by a search service.
-
Citations
20 Claims
-
1. A method for searching a relational database, the method comprising:
-
providing a search object model on a computer to perform keyword-based and structured query language (SQL)-based searches of the relational database; providing an abstract query class of the search object model defining an execute method for causing a query to be performed on the relational database and one or more query properties that specify a query string and the manner in which the query is performed; providing a keyword query class derived from the abstract query class, the keyword query class defining a query request using keyword syntax and comprising an execute method which when called causes a keyword query to be performed on the relational database and one or more keyword query properties that specify how the keyword query is to be performed and how results from the keyword query are to be returned; and setting the query string to specify one or more keywords to pass directly to a search service for performing a keyword-based search of the relational database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. A method for searching a relational database, the method comprising:
-
providing a search object model on a computer to perform keyword-based and structured query language (SOL)-based searches of the relational database; providing an abstract query class of the search object model defining an execute method for causing a query to be performed on the relational database and one or more query properties that specify the manner in which the query is performed; providing a keyword query class derived from the abstract query class, the keyword query class defining a query request using keyword syntax and comprising an execute method which when called causes a keyword query to be performed on the relational database and one or more keyword query properties that specify how the keyword query is to be performed and how results from the keyword query are to be returned; and exposing functionality provided by the keyword query class through a remote function call operative to receive a request packet as input, the request packet comprising query text specifying one or more keywords to pass directly to a search service for performing a keyword-based search of the relational database and one or more data elements corresponding to the properties of the keyword query class. - View Dependent Claims (13, 14, 15, 16, 17, 18, 19)
-
-
20. A computer-readable storage medium having computer-executable instructions stored thereon which, when executed by a computer, cause the computer to:
-
create an instance of a keyword query class, the keyword query class defining a query request using keyword syntax and comprising an execute method which when called causes a keyword query to be performed on a relational database and one or more keyword query properties that specify how the keyword query is to be performed and how results from the keyword query are to be returned; set a property on the instance for specifying query text comprising one or more keywords to be used in the keyword query; and call the execute method on the instance to perform the keyword query on the relational database.
-
Specification