Patent ID: 8849840
Filing Date: 2014-09-30
Classification: G06F,Y10S

Abstract:
1. A method comprising: obtaining a database query statement, the database query statement specifying a join of a plurality of database tables in a database, a condition for selecting one or more data records from the database tables, and one or more data fields to retrieve from the one or more data records; determining a layout, the layout specifying that at least one of the database tables is a base table and that one or more other database tables of the plurality of database tables are related tables in a database, wherein the layout comprises an arrangement of the one or more data fields; identifying, from the one or more data fields, a searchable data field, including: receiving a search request separately from the database query statement, the search request including at least one search term; constructing a quick search query statement using the search term and the database query statement, including replacing the condition of the database query statement for selecting the one or more data records with a new condition that includes the search term and specifying the related table in the quick query statement; performing a search in the database by executing the quick search query statement; and providing a result of the search as a response to the search request, wherein the method is performed by one or more computers.