Location based services bridge to external data sources
First Claim
1. A method for location enabling of user'"'"'s profile information in an external database comprising:
- storing, in a local memory, a compact definition of schema of an external database, wherein the external database comprises a user'"'"'s profile information;
storing, in the local memory, data source information that describes how to connect and communicate with the external database;
storing, in the local memory, a structured query language (SQL) statement that, upon execution, extracts properties from the external database corresponding to the compact definition;
storing, in the local memory, a foreign key that identifies a record in the external database;
storing, in the local memory, positional information, for the record in the external database, as a geocoding index; and
providing access to the user'"'"'s profile information using the stored compact definition, data source information, SQL statement, foreign key, and positional information.
7 Assignments
0 Petitions
Accused Products
Abstract
Embodiments of the invention provide access to a user'"'"'s profile information to a location based service, location enable user profile information in external databases, portals, etc., and allow the seamless/transparent provision of location services using both internal and external profile information. A compact definition of a schema of an external database (that comprises a user'"'"'s profile information) is stored. Data source information that describes how to connect and communicate with the external database and a structured query language (SQL) statement is stored, wherein the statement, upon execution, extracts properties from the external database corresponding to the compact definition. A foreign key identifies a record in the external database and positional information for the record in the external database is stored as a geocoding index. The stored information is then used to provide access to the user'"'"'s profile information.
-
Citations
40 Claims
-
1. A method for location enabling of user'"'"'s profile information in an external database comprising:
-
storing, in a local memory, a compact definition of schema of an external database, wherein the external database comprises a user'"'"'s profile information;
storing, in the local memory, data source information that describes how to connect and communicate with the external database;
storing, in the local memory, a structured query language (SQL) statement that, upon execution, extracts properties from the external database corresponding to the compact definition;
storing, in the local memory, a foreign key that identifies a record in the external database;
storing, in the local memory, positional information, for the record in the external database, as a geocoding index; and
providing access to the user'"'"'s profile information using the stored compact definition, data source information, SQL statement, foreign key, and positional information. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)
-
-
15. An apparatus for location enabling user profile information in an external database, comprising:
-
(a) a computer having a memory attached thereto, wherein the computer is configured to communicate with an external database that comprises a user'"'"'s profile information;
(b) a location based services (LBS) database stored in the memory on the computer;
(c) an LBS application executing on the computer, wherein the LBS application is configured to;
(i) store a compact definition of a schema of the external database;
(ii) store data source information, that describes how to connect and communicate with the external database;
(iii) store an SQL statement that, upon execution, extracts properties from the external database corresponding to the compact definition;
(iv) store, in the LBS database, a foreign key that identifies a record in the external database;
(v) store, in the LBS database, positional information for the record in the external database as a geocoding index; and
(vi) provide access to the user'"'"'s profile information using the compact definition, data source information, SQL statement, foreign key, and positional information. - View Dependent Claims (16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 33)
-
-
27. An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform a method for location enabling user profile information in a computer system, the method comprising:
-
storing, in local memory, a compact definition of a schema of an external database, wherein the external database comprises a user'"'"'s profile information;
storing, in local memory, data source information that describes how to connect and communicate with the external database;
storing, in local memory, a structured query language (SQL) statement that, upon execution, extracts properties from the external database corresponding to the compact definition;
storing, in local memory, a foreign key that identifies a record in the external database;
storing, in local memory, positional information for the record in the external database as a geocoding index; and
providing access to the user'"'"'s profile information using the stored compact definition, data source information, SQL statement, foreign key, and positional information. - View Dependent Claims (28, 29, 30, 31, 32, 34, 35, 36, 37, 38, 39, 40)
-
Specification