Method, system, and program for mining data in a personal information manager database

• US 6,751,626 B2
• Filed: 05/03/2001
• Issued: 06/15/2004
• Est. Priority Date: 05/03/2001
• Status: Active Grant

• Current Assignee: MediaTek, Inc.
• Original Assignee: International Business Machines Corporation
• Inventors: Dutta, Rabindranath, Paolini, Michael A., Brown, Michael Wayne
• Primary Examiner(s): Homere, Jean R.
• Assistant Examiner(s): PHAM, KHANH B
• Application Number:
  US09/848,176
• Publication Number:
  US 20020171673A1
• Time in Patent Office: 1,139 Days
• Field of Search: 707/3, 707/6, 707/100, 707/101, 707/10, 705/8, 705/9, 342/357.01, 342/357.06
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G07C 1/10 together with the recording, indicating or registering of other data, e.g. of signs of identity
• CPC Class Codes: H04M 1/72451 according to schedules, e.g. using calendar applications
• CPC Class Codes: H04M 1/72457 according to geographic location
• CPC Class Codes: H04M 15/43 Billing software details
• CPC Class Codes: H04M 15/58 based on statistics of usage or network monitoring
• CPC Class Codes: H04M 15/8033 location-dependent, e.g. business or home
• CPC Class Codes: H04M 15/8038 Roaming or handoff
• CPC Class Codes: H04M 2215/0188 Network monitoring; statistics on usage on called/calling number
• CPC Class Codes: H04M 2215/32 Involving wireless systems
• CPC Class Codes: H04M 2215/34 Roaming
• CPC Class Codes: H04M 2215/7435 Location dependent, e.g. Bussiness or home
• CPC Class Codes: H04M 2215/7442 Roaming
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99936 Pattern matching access
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation

Abstract

Provided is a method, system, and program for analyzing data within a personal information management program. Position records are provided in a database for at least one user. Each position record includes a time period value and event information indicating an event that occurred with respect to the user during the time period. The time period value and event information in each position record is based on time information and position coordinates generated by a wireless device associated with the user that indicate a location of the wireless device for time periods. The database is queried to determine position records for one user that satisfy at least one search criteria. Information is generated characterizing data in the determined position records.

Claims

1. A method for analyzing data within a personal information management program, comprising:

receiving from a wireless device measured records indicating time information and position coordinates;

processing the received measured records to determine measured records whose position coordinates are within a defined geographic boundary. wherein a database includes a plurality of the defined geographic boundaries each including a different set of position coordinates;

generating a position record in the database indicating a time period that spans the time periods indicated in the determined measured records and including event information indicating the defined geographic boundary that includes the position coordinates of the determined measured records;

determining an activity associated with a plurality of measured records having consecutive time periods that are not used to generate the position record whose event information indicates the defined geographic boundary;

generating a position record in the database indicating a time period that spans time periods in measured position records associated with the determined activity and including event information indicating the determined activity;

querying the database to determine position records for one user that satisfy at least one search criteria; and

generating information characterizing data in the determined position records.

2. The method of claim 1, further comprising:

wherein the search criteria includes specified event information, wherein the query determines all position records having event information matching the specified event information; and

for all the determined position records associated with event information matching the user specified event information, aggregating the time period values to determine a total time, wherein the generated information indicates the total time associated with the event identified by the specified event information.

3. The method of claim 2, further comprising:

displaying the total time associated with the event identified by the specified event information.

4. The method of claim 2, wherein the search criteria further specifies a time range, and wherein the determined position records have a time period value that falls within the specified time range, and wherein the generated information indicates the total time associated with the event identified in the specified event information for the specified time range.

5. The method of claim 2, wherein the search criteria includes multiple specified event information values, and wherein the generated information indicates the total time associated with each of the specified event information values.

6. The method of claim 2, wherein the search criteria includes one specified location, and wherein the total time indicates a time period the user of the wireless device was at the specified location.

7. The method of claim 6, wherein the query is performed with respect to multiple users in the database to determine position records for multiple users that satisfy the search criteria, and wherein the total time at the specified location is aggregated across the multiple users to determine the total time the multiple users were at the specified location.

8. The method of claim 1, wherein the search criteria includes one specified activity, and wherein the time value indicates the time period during which the user of the wireless device was engaged in the specified activity.

9. The method of claim 1, further comprising:

providing entered scheduled event records in the database for at least one user, wherein each scheduled event record includes a time period value and event information identifying a scheduled event at the time period value; and

querying the database to determine all scheduled event records for the one user that satisfy the at least one search criteria that was used to query the position records for the user, wherein the generated information includes a comparison of the determined scheduled event records and the determined position records.

10. The method of claim 9, wherein the event information in the scheduled event records indicates a scheduled activity to perform during the associated time period value, wherein the search criteria comprises a specified activity, and wherein the generated information includes a comparison of the a scheduled time for the activity versus an actual time devoted to the activity.

11. The method of claim 10, wherein the user specified activity comprises a form of exercising.

12. The method of claim 9, wherein the event information in the scheduled event records identifies a location at which the user of the wireless device was present during the associated time period value, wherein the search criteria comprises a specified location, and wherein the generated information indicates a comparison of time scheduled to be at the location versus actual time at the specified location.

13. The method of claim 1, wherein each position record includes a position coordinate associated with the event, wherein the search criteria includes one specified user and a proximate area, wherein the position records of the specified user are queried to determine those position records having position coordinates that are within the proximate area of the position coordinates within the position records of the one user, and wherein the generated information characterizing the data indicates a time period the one user and the specified user were located within the same proximate area.

14. The method of claim 13, further comprising:

providing entered scheduled event records in the database for the one user, wherein each scheduled event record includes a time period value and event information identifying the specified user;

querying the database to determine all scheduled event records for the one user that include event information identifying the specified person; and

aggregating the time period value across all the determined scheduled event records to determine scheduled time to spend with the specified user, wherein the generated information includes a comparison of the determined scheduled time to spend with the specified user and the time period the one user and the specified user were located within the same proximate area.

15. A method for analyzing data within a personal information management program, comprising:

receiving from a wireless device measured records indicating time information and position coordinates;

processing the received measured records to determine measured records whose position coordinates are within a defined geographic boundary, wherein a database includes a plurality of the defined geographic boundaries each including a different set of position coordinates;

generating a position record in the database indicating a time period that spans the time periods indicated in the determined measured records and including location information indicating the defined geographic boundary that includes the position coordinates of the determined measured records;

determining an activity associated with a plurality of measured records having consecutive time periods that are not used to generate the position record;

generating a position record in the database indicating a time period that spans time periods in measured position records associated with the determined activity;

querying the database to determine position records for one user that satisfy at least one search criteria including specified event information;

querying the database to determine scheduled event records for one user that satisfy at least one search criteria including specified event information, wherein each scheduled event record for one user includes a time period value and event information of a scheduled event for the user;

determining an aggregate amount of actual user time from the time periods included in the determined position records for the event identified by the specified event information;

determining an aggregate amount of scheduled time from the time periods included in the determined scheduled event records for the event identified by the specified event information; and

displaying information indicating the aggregate amount of scheduled time and the aggregate amount of actual user time for the event identified by the user specified event information.

16. The method of claim 15, wherein the displayed information provides a comparison of the scheduled and actual time devoted for the event identified by the specified event information.

17. The method of claim 15, wherein each time period value in the scheduled event and the position records indicates a start and end time for the event identified by the event information;

for each determined scheduled event record, performing;

(i) determining the determined position records that have start and end times that overlap with the start and end times of the scheduled event record; and

(ii) determining the position records having the start time that differs from the start time in the scheduled event record, wherein the generated information indicates an extent to which an actual start time is different from a scheduled start time.

18. The method of claim 17, wherein for each determined scheduled event record, further performing:

determining the position records having the end time that is different than the end time in the scheduled event record, wherein the generated information indicates an extent to which an actual end time is different from a scheduled end time.

19. A system for analyzing data within a personal information management program in communication with a wireless device, comprising:

a database;

means for receiving from the wireless device measured records indicating time information and position coordinates;

means for processing the received measured records to determine measured records whose position coordinates are within a defined geographic boundary, wherein the database includes a plurality of defined geographic boundaries each including a different sets of position coordinates;

means for generating a position record in the database indicating a time period that spans the time periods indicated in the determined measured records and including event information indicating the defined geographic boundary that includes the position coordinates of the determined measured records;

means for determining an activity associated with a plurality of measured records having consecutive time periods that are not used to generate the position record whose event information indicates the defined geographic boundary;

means for generating a position record in the database indicating a time period that spans time periods in measured position records associated with the determined activity and including event information indicating the determined activity;

means for querying the database to determine position records for one user that satisfy at least one search criteria; and

means for generating information characterizing data in the determined position records.

20. The system of claim 19, wherein the search criteria includes specified event information, wherein the means for querying the database determines all position records having event information matching the specified event information, further comprising:

means for aggregating the time period values to determine a total time for all the determined position records that include event information matching the user specified event information, wherein the generated information indicates the total time associated with the event identified by the specified event information.

21. The system of claim 20, further comprising:

means for displaying the total time associated with the event identified by the specified event information.

22. The system of claim 20, wherein the search criteria further specifies a time range, and wherein the determined position records have a time period value that falls within the specified time range, and wherein the means for generating information indicates the total time associated with the event identified in the specified event information for the specified time range.

23. The system of claim 20, wherein the search criteria includes multiple specified event information values, and wherein the means for generating information indicates the total time associated with each of the specified event information values.

24. The system of claim 20, wherein the search criteria includes one specified location, and wherein the total time indicates a time period the user of the wireless device was at the specified location.

25. The system of claim 24, wherein the query is performed with respect to multiple users in the database to determine position records for multiple users that satisfy the search criteria, and wherein the total time at the specified location is aggregated across the multiple users to determine the total time the multiple users were at the specified location.

26. The system of claim 19, wherein the search criteria includes one specified activity, and wherein the time value indicates the time period during which the user of the wireless device was engaged in the specified activity.

27. The system of claim 19, further comprising:

means for providing entered scheduled event records in the database for at least one user, wherein each scheduled event record includes a time period value and event information identifying a scheduled event at the time period value; and

means for querying the database to determine all scheduled event records for the one user that satisfy the at least one search criteria that was used to query the position records for the user, wherein the generated information includes a comparison of the determined scheduled event records and the determined position records.

28. The system of claim 27, wherein the event information in the scheduled event records indicates a scheduled activity to perform during the associated time period value, wherein the search criteria comprises a specified activity, and wherein the generated information includes a comparison of the a scheduled time for the activity versus an actual time devoted to the activity.

29. The system of claim 28, wherein the user specified activity comprises a form of exercising.

30. The system of claim 27, wherein the event information in the scheduled event records identifies a location at which the user of the wireless device was present during the associated time period value, wherein the search criteria comprises a specified location, and wherein the generated information indicates a comparison of time scheduled to be at the location versus actual time at the location.

31. The system of claim 19, wherein each position record includes a position coordinate associated with the event, wherein the search criteria includes one specified user and a proximate area, wherein the position records of the specified user are queried to determine those position records having position coordinates that are within the proximate area of the position coordinates within the position records of the one user, and wherein the generated information characterizing the data indicates a time period the one user and the specified user were located within the same proximate area.

32. The system of claim 31, further comprising:

means for providing entered scheduled event records in the database for the one user, wherein each scheduled event record includes a time period value and event information identifying the specified user;

means for querying the database to determine all scheduled event records for the one user that include event information identifying the specified person; and

means for aggregating the time period value across all the determined scheduled event records to determine scheduled time to spend with the specified user, wherein the generated information includes a comparison of the determined scheduled time to spend with the specified user and the time period the one user and the specified user were located within the same proximate area.

33. A system for analyzing data within a personal information management program receiving information from a wireless device, comprising:

a database;

means for receiving from the wireless device measured records indicating time information and position coordinates;

means for processing the received measured records to determine measured records whose position coordinates are within a defined geographic boundary, wherein the database includes a plurality of defined geographic boundaries each including a different set of position coordinates;

means for generating a position record in the database indicating a time period that spans the time periods indicated in the determined measured records and including event information indicating the defined geographic boundary that includes the position coordinates of the determined measured records;

means for determining an activity associated with a plurality of measured records having consecutive time periods that are not used to generate the position record whose event information indicates the defined geographic boundary;

means for generating a position record in the database indicating a time period that spans time periods in measured position records associated with the determined activity and including event information indicating the determined activity;

means for querying the database to determine position records for one user that satisfy at least one search criteria including specified event information;

means for determining an aggregate amount of actual user time from the time periods included in the determined position records for the event identified by the specified event information;

querying the database to determine scheduled event records for one user that satisfy at least one search criteria including specified event information, wherein each scheduled event record for one user includes a time period value and event information of a scheduled event for the user;

means for determining an aggregate amount of scheduled time from the time periods included in the determined scheduled event records for the event identified by the specified event information; and

means for displaying information indicating the aggregate amount of scheduled time and the aggregate amount of actual user time for the event identified by the user specified event information.

34. The system of claim 33, wherein the displayed information provides a comparison of the scheduled and actual time devoted for the event identified by the specified event information.

35. The system of claim 33, wherein each time period value in the scheduled event and the position records indicates a start and end time for the event identified by the event information, further comprising:

means for performing, for each determined scheduled event record;

(i) determining the determined position records that have start and end times that overlap with the start and end times of the scheduled event record; and

(ii) determining the position records having the start time that differs from the start time in the scheduled event record, wherein the generated information indicates an extent to which an actual start time is different from a scheduled start time.

36. The system of claim 35, wherein for each determined scheduled event record, further comprising:

means for determining the position records having the end time that is different than the end time in the scheduled event record, wherein the generated information indicates an extent to which an actual end time is different from a scheduled end time.

37. An article of manufacture including code for analyzing data within a personal information management program in communication with a wireless device and a database, by:

receiving from the wireless device measured records indicating time information and position coordinates;

processing the received measured records to determine measured records whose position coordinates are within a defined geographic boundary, wherein the database includes a plurality of defined geographic boundaries each including a different set of position coordinates;

generating a position record in the database indicating a time period that spans the time periods indicated in the determined measured records and including event information indicating the defined geographic boundary that includes the position coordinates of the determined measured records;

determining an activity associated with a plurality of measured records having consecutive time periods that are not used to generate the position record;

generating a position record in the database indicating a time period that spans time periods in measured position records associated with the determined activity and including event information indicating the determined activity;

querying the database to determine position records for one user that satisfy at least one search criteria; and

generating information characterizing data in the determined position records.

38. The article of manufacture of claim 37, further comprising:

wherein the search criteria includes specified event information, wherein the query determines all position records having event information matching the specified event information; and

for all the determined position records that include event information matching the user specified event information, aggregating the time period values to determine a total time, wherein the generated information indicates the total time associated with the event identified by the specified event information.

39. The article of manufacture of claim 38, further comprising:

displaying the total time associated with the event identified by the specified event information.

40. The article of manufacture of claim 38, wherein the search criteria further specifies a time range, and wherein the determined position records have a time period value that falls within the specified time range, and wherein the generated information indicates the total time associated with the event identified in the specified event information for the specified time range.

41. The article of manufacture of claim 38, wherein the search criteria includes multiple specified event information values, and wherein the generated information indicates the total time associated with each of the specified event information values.

42. The article of manufacture of claim 38, wherein the search criteria includes one specified location, and wherein the total time indicates a time period the user of the wireless device was at the specified location.

43. The article of manufacture of claim 42, wherein the query is performed with respect to multiple users in the database to determine position records for multiple users that satisfy the search criteria, and wherein the total time at the specified location is aggregated across the multiple users to determine the total time the multiple users were at the specified location.

44. The article of manufacture of claim 37, wherein the search criteria includes one specified activity, and wherein the time value indicates the time period during which the user of the wireless device was engaged in the identified activity.

45. The article of manufacture of claim 37, further comprising:

providing entered scheduled event records in the database for at least one user, wherein each scheduled event record includes a time period value and event information identifying a scheduled event at the time period value; and

querying the database to determine all scheduled event records for the one user that satisfy the at least one search criteria that was used to query the position records for the user, wherein the generated information includes a comparison of the determined scheduled event records and the determined position records.

46. The article of manufacture of claim 45, wherein the event information in the scheduled event records indicates a scheduled activity to perform during the associated time period value, wherein the search criteria comprises a specified activity, and wherein the generated information includes a comparison of the a scheduled time for the activity versus an actual time devoted to the activity.

47. The article of manufacture of claim 46, wherein the user specified activity comprises a form of exercising.

48. The article of manufacture of claim 45, wherein the event information in the scheduled event records identifies a location at which the user of the wireless device was present during the associated time period value, wherein the search criteria comprises a specified location, and wherein the generated information indicates a comparison of time scheduled to be at the location versus actual time at the location.

49. The article of manufacture of claim 37, wherein each position record includes a position coordinate associated with the event, wherein the search criteria includes one specified user and a proximate area, wherein the position records of the specified user are queried to determine those position records having position coordinates that are within the proximate area of the position coordinates within the position records of the one user, and wherein the generated information characterizing the data indicates a time period the one user and the specified user were located within the same proximate area.

50. The article of manufacture of claim 49, further comprising:

providing entered scheduled event records in the database for the one user, wherein each scheduled event record includes a time period value and event information identifying the specified user;

querying the database to determine all scheduled event records for the one user that include event information identifying the specified person; and

aggregating the time period value across all the determined scheduled event records to determine scheduled time to spend with the specified user, wherein the generated information includes a comparison of the determined scheduled time to spend with the specified user and the time period the one user and the specified user were located within the same proximate area.

51. An article of manufacture including code for analyzing data within a personal information management program in communication with a wireless device and a database, by:

receiving from the wireless device measured records indicating time information and position coordinates;

processing the received measured records to determine measured records whose position coordinates are within a defined geographic boundary, wherein the database a includes a plurality of defined geographic boundaries each including a different set of position coordinates;

generating a position record in the database indicating a time period that spans the time periods indicated in the determined measured records and including event information indicating the defined geographic boundary that includes the position coordinates of the determined measured records;

determining an activity associated with a plurality of measured records having consecutive time periods that are not used to generate the position record;

generating a position record in the database indicating a time period that spans time periods in measured position records associated with the determined activity and including event information indicating the determined activity;

querying the database to determine position records for one user that satisfy at least one search criteria including specified event information;

determining an aggregate amount of actual user time from the time periods included in the determined position records for the event identified by the specified event information;

querying the database to determine scheduled event records for one user that satisfy at least one search criteria including specified event information, wherein each scheduled event record for one user includes a time period value and event information of a scheduled event for the user;

determining an aggregate amount of scheduled time from the time periods included in the determined scheduled event records for the event identified by the specified event information; and

displaying information indicating the aggregate amount of scheduled time and the aggregate amount of actual user time for the event identified by the user specified event information.

52. The article of manufacture of claim 51, wherein the displayed information provides a comparison of the scheduled and actual time devoted for the event identified by the specified event information.

53. The article of manufacture of claim 51, wherein each time period value in the scheduled event and the position records indicates a start and end time for the event identified by the event information;

for each determined scheduled event record, performing;

(i) determining the determined position records that have start and end times that overlap with the start and end times of the scheduled event record; and

(ii) determining the position records having the start time that differs from the start time in the scheduled event record, wherein the generated information indicates an extent to which an actual start time is different from a scheduled start time.

54. The article of manufacture of claim 53, wherein for each determined scheduled event record, further performing:

determining the position records having the end time that is different than the end time in the scheduled event record, wherein the generated information indicates an extent to which an actual end time is different from a scheduled end time.