SYSTEM AND METHOD FOR SEARCHING A DATABASE

• US 20110137880A1
• Filed: 11/17/2010
• Published: 06/09/2011
• Est. Priority Date: 11/17/2009
• Status: Abandoned Application

• Current Assignee: Daniel Blais
• Original Assignee: Daniel Blais
• Inventors: BLAIS, Daniel
• Application Number:
  US12/948,219
• Publication Number:
  US 20110137880A1
• Time in Patent Office: Days
• US Class Current: 707/706
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 16/9537 Spatial or temporal dependent retrieval, e.g. spatiotemporal queries

Abstract

A GUI (Graphical User Interface) is used to display items at a user terminal. Each item is user selectable and representative of a search category. A user selects one of the items to generate a query with no other user input required to generate the query. The query includes an identifier of the selected search category and a location identifier. A search for elements associated with the selected category are is performed. A geographical area is defined using the location identifier and a determination is made as to which elements are within the geographical area. The elements that are within the geographical area are then sent to the user terminal. The elements may contain information on establishments such addresses and contact information together with a distance from a central position. In some implementations, the elements are displayed in ascending order of distance of respective establishments from the central position.

Claims

1. A method of searching a database, the method comprising, at a server system:

transmitting information to a terminal of a user for displaying a GUI (Graphical User Interface), the GUI displaying a plurality items each representing a respective search category and having associated with it an identifier of the respective search category, the information comprising instructions for generating a query in response to a user selection of a selected item of the plurality of items without any other user input, the query including the identifier of the respective search category of the selected item and a location identifier;

responsive to receiving the query from the terminal, searching a database to identify elements in the database associated with the identifier of the respective search category of the selected item, each element comprising information relating to the respective search category of the selected item;

defining a geographical area using the location identifier;

for each identified element, determining whether the identified element is within the geographical area; and

,

transmitting the identified elements which are within the geographical area to the terminal.

2. A method according to claim 1 wherein the geographical area comprises a central position and for each identified element, the determining whether the identified element is within the geographical area comprising determining the distance between the central position and a position associated with the element, the distance being transmitted to the terminal as part of the identified element for display.

3. A method according to claim 2 wherein the identified elements which are within the geographical area are each transmitted in at least one packet of data for display as a visual group in order of ascending distance from the central position.

4. A method according to claim 1 wherein the location identifier comprises an IP (Internet Protocol) address.

5. A method according to claim 4 wherein the defining a geographical area using the location identifier comprises:

at the server system, using the IP address to look up a previously used location identifier and using the previously used location identifier to the define geographical area.

6. A method according to claim 4 wherein the defining a geographical area using the location identifier comprises determining location information using the IP address and defining the geographical area using the location information.

7. A method according to claim 1 wherein the geographic area is defined as a circular area of a predetermined radius about a central geographic position defined by the location identifier and wherein for each element in the database the information relating to the respective search category of the selected item comprises a geographic position of a respective establishment, and

wherein for each identified element, the determining whether the identified element is within the geographical area comprises determining the distance between the central geographic position defined by the location identifier and the geographic position of the respective establishment.

8. A method according to claim 7 comprising:

for each identified element that is within the geographical area, transmitting to the terminal the distance between the central geographic position defined by the location identifier and the geographic position of the respective establishment.

9. A method according to claim 8 comprising transmitting instructions for displaying the identified elements which are within the geographical area to the terminal in ascending order of distance from the central geographic position.

10. A method according to claim 1 wherein the search categories comprise at least one of a name of an establishment, business category, and business sub-category.

11. A method according to claim 1 wherein the location identifier comprises one of a postal code, city, town, a metropolitan center, a subdivision, and a suburb.

12. A server system for searching a database, the server system comprising:

a communications interface for receiving and transmitting data across a network;

an interface unit coupled to communications interface for transmitting information to a terminal of a user for displaying a GUI (Graphical User Interface), the GUI displaying a plurality of items each representing a respective search category and having associated with it an identifier of the respective search category, the information comprising instructions for generating a query upon a user selection of a selected item of the plurality of items without any other user input, the query including the identifier of the respective search category of the selected item and a location identifier;

a database comprising elements each associated with a search category;

a search engine for searching the database in response to receiving the query from the terminal to identify elements in the database which are associated with the identifier of the respective search category of the selected item, the search engine comprising;

a geographical search unit coupled to the communications interface for;

defining a geographical area using the location identifier;

for each identified element, determining whether the identified element is within the geographical area; and

,

transmitting the identified elements which are within the geographical area to the terminal.

13. A method according to claim 12 wherein the geographical area comprises a central position and for each identified element, the geographical search unit determining the distance between the central position and a position associated with the element and transmitting said distance to the terminal as part of the identified element for display.

14. A method according to claim 13 wherein the identified elements which are within the geographical area are each transmitted in at least one packet of data for display as a visual group in order of ascending distance from the central position.

15. A method according to claim 12 wherein the location identifier comprises an IP (Internet Protocol) address.

16. A method according to claim 12 wherein the search categories comprises at least one of a name of an establishment, business category, and business sub-category.

17. A method according to claim 12 wherein the location identifier comprises one of a postal code, city, town, a metropolitan center, a subdivision, and a suburb.

18. A method of searching a database, the method comprising:

at a user terminal, displaying a GUI (Graphical User Interface) having a plurality items each representing a respective search category and having associated with it an identifier of the respective search category;

responsive to a user selection of an item of the plurality of items, generating a query without any additional user input, the query including the identifier of the respective search category of the selected item and a location identifier;

searching a database to identify elements in the database associated with the identifier of the respective search category of the selected item, each element comprising information relating to the respective search category of the selected item;

defining a geographical area using the location identifier;

for each identified element, determining whether the identified element is within the geographical area; and

,

transmitting the identified elements which are within the geographical area to the terminal.

19. A method according to claim 18 comprising retrieving the location identifier from memory at the user terminal.

20. A method according to claim 18 wherein the location identifier comprises an IP (Internet Protocol) address, the defining a geographical area using the location identifier comprising retrieving an other location identifier from memory and using the other location identifier to define the geographic area.

21. A method according to claim 18 wherein the geographical area comprises a central position and for each identified element, the determining whether the identified element is within the geographical area comprising determining the distance between the central position and a position associated with the element, the distance being transmitted terminal as part of the identified element for display.

22. A method according to claim 21 wherein the identified elements which are within the geographical area are each transmitted in at least one packet of data for display as a visual group in order of ascending distance from the central position.