IP Library Granted Patent US 6,954,764
Granted Patent B2
US 6,954,764 · App. 09/870,301 · Granted Oct 11, 2005

Region modeling of mobile services

Assignee: Oracle International Corp.
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 6,954,764
App. No.
09/870,301
Granted
Oct 11, 2005
Kind
B2
Abstract

A shareable application program interface infrastructure which is used in combination with a relational database to provide data storage and processing functions for location-dependent objects, and includes a mechanism for easily associating an object, such a service, with a geographic region, such as an area served by the service. The service designer is provided with a tool to choose a geographic region or a point location (specified by an address), and to associate that selected geographic region with a service. Each service is associated with a geographic region chosen from a hierarchy of predetermined system-defined regions that are preferably organized into a hierarchy composed of levels organized in order of decreasing size so that the boundaries of each child region lie within the boundaries of its parent region. The services designer is also provided with the option of creating “user defined regions” that are composed of existing system defined regions or a region centered around a selected location. The user-defined region could represent business objects that relate to a particular entity; for example, a set of sales regions served by different regional sales offices.

Claims (29)

1. Apparatus for performing location-dependent data processing operations comprising, in combination,

a relational database management system for creating and updating data structures comprising a first set of one or more relational tables describing objects, said data structures including means for storing data specifying the geographic location of at least selected ones of said objects;

means for storing reference data in a second set of one or more relational tables describing a plurality of system defined regions, said reference data including the specification of the geographic location of each given one of said system defined regions and a human interpretable description of each given one of said regions;

a user-manipulated control, comprising:

means for visually displaying to a user said human interpretable description for said system defined regions,

means for accepting from said user an identification of a plurality of system defined regions,

means for generating the specification of a new user defined region consisting of the combination of said plurality of system defined regions,

means for storing reference data describing said new user defined region in said second set of tables,

means for identifying a selected one of said regions described in said second set of tables, and

means for transferring data specifying the geographic location of said selected one of said regions to said first set of tables to specify the geographic location of a specified one of said objects; and

means responsive to said control for transferring selected items of said reference data to said means for storing geographic location data associated with one of said objects.

2. Apparatus as set forth in claim 1 wherein said means for storing reference data includes means for storing said reference data in a hierarchy of regions.

3. Apparatus as set forth in claim 2 wherein said hierarchy of regions consists of a parent-child hierarchy of levels holding regions of decreasing size characterized by each child region having a geographical extent the lies within the geographical extent of its parent region.

4. Apparatus as set forth in claim 2 wherein said reference data defines the boundaries of each of said regions and wherein any first region having defined boundaries within the boundaries of a region is nested within said second region within said hierarchy.

5. A method for performing location-dependent data processing operations comprising, in combination, the steps of:

creating and updating data structures describing objects in a first set of tables in a relational database management system, said data structures including data specifying the geographic location of at least selected ones of said objects;

storing reference data describing a plurality of system defined regions in a second set of tables in said relational database system, said reference data including the specification of the geographic location of each given one of said system defined regions and a human interpretable description of each given one of said system defined regions;

employing a user-manipulated control for performing the substeps of:

visually displaying to a user said human interpretable description for said system defined regions,

accepting from said user an identification of a plurality of system defined regions,

generating the specification of a new user defined region consisting of the combination of said plurality of system defined regions,

storing reference data describing said new user defined region in said second set of tables,

identifying a selected one of said regions described in said second set of tables, and

transferring data specifying the geographic location of said selected one of said regions to said first set of tables to specify the geographic location of a specified one of said objects; and

transferring said reference data describing said new user defined region to said data structures to associate said new user defined region with one of said objects.

6. The method set forth in claim 5 wherein said data structures describing objects are relational tables describing one or more services each having a geographic location serving one of said system defined regions or one of said user defined regions.

7. The method set forth in claim 5 wherein said step of storing reference data includes the step of storing said reference data in a hierarchy of regions.

8. The method set forth in claim 7 wherein said hierarchy of regions consists of a parent-child hierarchy of levels holding regions of decreasing size characterized by each child region having a geographical extent the lies within the geographical extent of its parent region.

9. The method set forth in claim 7 wherein said reference data defines the boundaries of each of said regions and wherein any first region having defined boundaries within the boundaries of a region is nested within said second region within said hierarchy.

Assignments (3)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 16, 2005
From: ORACLE CORPORATION
To: ORACLE INTERNATIONAL CORPORATION
Reel/Frame 016797/0172 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 16, 2005
From: ORACLE CORPORATION
To: ORACLE INTERNATIONAL CORPORATION
Reel/Frame 017366/0283 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded May 30, 2001
From: BISWAS, PRABUDDHA; CHATTERJEE, RAJA; HAN, SONG
To: ORACLE CORPORATION
Reel/Frame 011854/0989 →
Continuity (2)
Continuation In Part 0966950300 · Sep 25, 2000
Related Publication 20020057283A1 · May 16, 2002