Project management system with geographic data

• US 9,020,930 B2
• Filed: 07/27/2012
• Issued: 04/28/2015
• Est. Priority Date: 07/27/2012
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Lafferty, Shawn P., Zeltov, Alex
• Primary Examiner(s): LIAO, JASON G
• Application Number:
  US13/560,296
• Publication Number:
  US 20140032530A1
• Time in Patent Office: 1,005 Days
• US Class Current: 707/722
• CPC Class Codes: G06F 16/29 Geographical information databases

Abstract

A system for retrieving project management data based upon geographic criteria defines a plurality of locations. The system assigns the plurality of locations to project management data stored within a memory, wherein the project management data comprises a plurality of projects, a plurality of activities, and a plurality of resources, and the locations are assigned to the plurality of projects, activities, and resources. The system receives a request to retrieve project management data with assigned locations that meet a geographic criteria. The system retrieves project management data that meets the geographic criteria.

Claims

1. A computer readable medium having instructions stored thereon that, when executed by a processor, causes the processor to retrieve project management data based upon geographic criteria, the retrieving comprising:

storing a plurality of geographic location tables in a database, each geographic location table including;

an identification field,

a name field,

at least one of a country field, a state field, a city field, and a street address field and

latitude/longitude data fields;

storing a plurality of project management data tables in the database, each project management data table including;

an identification field,

a starting date field,

an ending date field,

a name field,

a geographic location field identifying one of the geographic location tables, and

one or more activity fields, each activity field identifying an activity table stored in the database, each activity table including;

an identification field,

a starting date field,

an ending date field,

a name field, and

a geographic location field identifying one of the geographic location tables;

storing a plurality of resource tables in the database, each resource table including;

an identification field,

a name field, and

a geographic location field identifying one of the geographic location tables;

determining geographic search criteria based on geographic location table data stored in the database;

presenting the geographic search criteria to a user in a selectable format;

receiving, from the user, a request to retrieve a list of resources that meet a selected geographic criteria, the geographic criteria including at least one of a state, a city, a street address and latitude/longitude data;

searching the plurality of resource tables stored in the database;

retrieving one or more resources that match the selected geographic criteria; and

presenting the matching resources to the user.

2. The computer readable medium of claim 1, wherein the geographical criteria further includes distance from the state, city, street address or latitude/longitude data.

3. The computer readable medium of claim 1, wherein the retrieving project management data further comprises providing a project-level view, an activity-level view, and a resource-level view to the user, each view including geographic location data.

4. The computer readable medium of claim 1, wherein the retrieving project management data further comprises determining whether the geographic locations assigned to the projects, project activities and resources are within a geographical area of a natural disaster.

5. The computer readable medium of claim 1, wherein the plurality of resources include people, materials and equipment.

6. The computer readable medium of claim 1, wherein the retrieving project management data further comprises receiving, from the user, a selection of a resource from the list of resources for allocation to a project or a project activity.

7. The computer readable medium of claim 1, wherein presenting the matching resources to the user includes displaying the matching resources on a map.

8. A method for retrieving project management data based upon geographic criteria, the method comprising:

storing a plurality of geographic location tables in a database, each geographic location including;

an identification field,

a name field,

at least one of a country field, a state field, a city field, and a street address field, and

latitude/longitude data fields;

storing a plurality of project management data tables in the database, each project management data table including;

an identification field,

a starting date field,

an ending date field,

a name field,

a geographic location field identifying one of the geographic location tables, and

one or more activity fields, each activity field identifying an activity table stored in the database, each activity table including;

an identification field,

a starting date field,

an ending date field,

a name field, and

a geographic location field identifying one of the geographic location tables;

storing a plurality of resource tables in the database, each resource table including;

an identification field,

a name field, and

a geographic location field identifying one of the geographic location tables;

determining geographic search criteria based on geographic location table data stored in the database;

presenting the geographic search criteria to a user in a selectable format;

receiving, from the user, a request to retrieve a list of resources that meet a selected geographic criteria, the geographic criteria including at least one of a state, a city, a street address and latitude/longitude data;

searching the plurality of resource tables stored in the database;

retrieving one or more resources that match the selected geographic criteria; and

presenting the matching resources to the user.

9. The method of claim 8, wherein the geographical criteria further includes a distance from the state, city, street address or latitude/longitude data.

10. The method of claim 8, further comprising providing a project-level view, an activity-level view, and a resource-level view to the user, each view including geographic location data.

11. The method of claim 8, further comprising determining whether the geographic locations assigned to the projects, project activities and resources are within a geographical area of a natural disaster.

12. The method of claim 8, wherein the plurality of resources include people, materials and equipment.

13. The method of claim 8, further comprising receiving, from the user, a selection of a resource from the list of resources for allocation to a project or a project activity.

14. The method of claim 8, wherein presenting the matching resources to the user includes displaying the matching resources on a map.

15. A computer system comprising a memory, a display and a processor, coupled to the memory and the display, adapted to retrieve project management data based upon geographic criteria, the retrieving comprising:

storing a plurality of geographic location tables in a database, each geographic location table including;

an identification field,

a name field,

at least one of a country field, a state field, a city field, and a street address field, and

latitude/longitude data fields;

storing a plurality of project management data tables in the database, each project management data table including;

an identification field,

a starting date field,

an ending date field,

a name fields,

a geographic location field identifying one of the geographic location tables, and

one or more activity fields, each activity field identifying an activity table stored in the database, each activity table including;

an identification field,

a starting date field,

an ending date field,

a name field, and

a geographic location field identifying one of the geographic location tables,

storing a plurality of resource tables in the database;

each resource including;

an identification field,

a name field, and

a geographic location field identifying one of the geographic location tables;

determining geographic search criteria based on geographic location table data stored in the database;

presenting the geographic search criteria to a user in a selectable format;

receiving, from the user, a request to retrieve a list of resources that meet a selected geographic criteria, the geographic criteria including at least one of a state, a city, a street address and latitude/longitude data;

searching the plurality of resource tables stored in the database;

retrieving one or more resources that match the selected geographic criteria; and

displaying the matching resources to the user on a map.

16. The computer system of claim 15, wherein the geographical criteria includes a distance from the state, city, street address or latitude/longitude data.

17. The computer system of claim 15, wherein the retrieving project management data further comprises providing a project-level view, an activity-level view, and a resource-level view to the user, each view including geographic location data.

18. The computer system of claim 15, wherein the retrieving project management data further comprises determining whether the geographic locations assigned to the projects, project activities and resources are within a geographical area of a natural disaster.

19. The computer system of claim 15, wherein the plurality of resources include people, materials and equipment.

20. The computer system of claim 15, wherein the retrieving project management data further comprises receiving, from the user, a selection of a resource from the list of resources for allocation to a project or a project activity.