Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2001-05-03
2004-06-15
Homere, Jean R. (Department: 2177)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
06751626
ABSTRACT:
BACKGROUND OF THE INVENTION
1. Field of the Invention
The present invention relates to a method, system, and program for mining data in a personal information manager database.
2. Description of the Related Art
Organizations and individuals use scheduling and calendaring software programs to schedule their daily activities. At some point, a person may want to know the extent to which they have met their scheduled goals. For instance, an individual may want to know how often they were late or early for business meetings. A company may want to know how much time individuals in fact spent at scheduled activities or at designated work locations.
In the current art, to make such determinations as to whether an individual adhered to the scheduled events, the organization would have to question the individual to gather information on actual activity. Such information of actual activity may be difficult to accurately gather unless a person keeps a written diary of their activities on a daily basis. Otherwise, most people if questioned on their actual activity a few days following the activity will be unable to relate accurate information. Given these constraints in gathering actual activity information, the ability to accurately compare and analyze actual versus scheduled activity is not a capability that has been developed and offered as of date.
For these reasons, there is a need in the art for technology to allow individuals and organizations to accurately determine the extent to which actual activity of a person coincides with scheduled events.
SUMMARY OF THE PREFERRED EMBODIMENTS
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.
In further implementations, the search criteria includes specified event information, wherein the query determines all position records having event information matching the specified event information. For all the determined position records that include event information matching the user specified event information, the time period values are aggregated to determine a total time, wherein the generated information indicates the total time associated with the event identified by the specified event information.
Still further, the event information may identify a location and the search criteria may include one specified location, wherein the total time indicates a time period the user of the wireless device was at the identified location.
Additionally, the event information may identify an activity and the search criteria may include one specified activity, wherein the time value indicates the time period during which the user of the wireless device was engaged in the identified activity.
In still further implementations, the database includes scheduled event records 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. The database is queried 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. In such case, the generated information includes a comparison of the determined scheduled event records and the determined position records.
In further implementations, the database is queried to determine position records for one user that satisfy at least one search criteria including specified event information. A determination is then made of an aggregate amount of actual from the time periods included in the determined position records for the event identified by the specified event information and of 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. information is displayed 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.
The described implementations provide a technique for data mining information in a database that includes records indicating events and time periods of a user that are based on positioned coordinates generated by a wireless device. The described implementations provide a technique to gather and analyze information on the whereabouts of one or more users having records in the database. The database may further include scheduled events for the user. In such case, the described implementations provide techniques for comparing data concerning scheduled events and actual realization of the scheduled events for specified time periods.
The described implementations, thus, provide tools for analyzing and tracking user activity and presence at particular locations over periods of time.
REFERENCES:
patent: 5124912 (1992-06-01), Hotaling et al.
patent: 5416473 (1995-05-01), Dulaney, III
patent: 5428784 (1995-06-01), Cahill, Jr.
patent: 5664063 (1997-09-01), Johnson et al.
patent: 5664175 (1997-09-01), Jackson et al.
patent: 5774873 (1998-06-01), Berent et al.
patent: 5790974 (1998-08-01), Tognazzini
patent: 5832489 (1998-11-01), Kucala
patent: 5835896 (1998-11-01), Fisher et al.
patent: 5890138 (1999-03-01), Godin et al.
patent: 5918158 (1999-06-01), LaPorta et al.
patent: 6047260 (2000-04-01), Levinson
patent: 6085166 (2000-07-01), Beckhardt et al.
patent: 6101480 (2000-08-01), Conmy et al.
patent: 6154172 (2000-11-01), Piccionelli et al.
patent: 6154727 (2000-11-01), Karp et al.
patent: 6317718 (2001-11-01), Fano
patent: 6411891 (2002-06-01), Jones
patent: 6569094 (2003-05-01), Suzuki et al.
patent: 6574630 (2003-06-01), Augustine et al.
patent: 2001/0020204 (2001-09-01), Runyon et al.
patent: 2001/0052873 (2001-12-01), Rezai
patent: 2002/0083025 (2002-06-01), Robarts et al.
patent: 2002/0175211 (2002-11-01), Dominquez et al.
patent: 0495622 (1992-01-01), None
patent: 0637807 (1994-07-01), None
patent: 0834840 (1997-09-01), None
patent: 1039397 (2000-09-01), None
patent: 0029979 (2000-05-01), None
U.S. Application Ser. No. 09/848,166, filed on May 3, 2001, entitled “Method System and Program for Providing User Location Information with a Personal Information Management Program, ” by MW Brown; R Dutta and MA Paolini.
Patent Cooperation Treaty (PCT) International Search Report, for International Application No. PCT/GB 02/02051, Search completed on May 9, 2003.
U.S. application Ser. No. 09/848,173, filed on May 3, 2001, entitled “Method, System and Program for Providing User Loacation Information for a Personal Information Management System from Transmitting Devices,” by M. Paolini, et al.
Mueller, Erik T., “A Calendar with Common Sense”, © 2000 ACM, pp. 198-201.
Schwartz, Ephraim, “Cellular Phone Giants to Integrate Sirf's GPS Technology”, Aug. 10, 1998 [online], Retrieved from the Internet <URL: www.infoworld.com./cgi-bin/displayStory.pl?980810.ehe911.htm>.
“allNetDevices:—The Wireless Internet: Applications, Technology and Market Strategies”, Jan. 10, 2001, pp. 1-4 [online]. Retrieved from the Internet <URL: www.allnetdevices.com/icom_cgi/print/print.cgi?url=http://www.allnetdevices.com/wireless/opinions/2001. . . >.
“allNetDevices:—Java 2 Micro Edition and the Mobile Information Device Profile”, Feb. 16, 2001, pp. 1-7 [online]. Retrieved from the internet <URL: www.allnetdevices.com/icom_cgi/print/print.cgi?url=ht
Brown Michael Wayne
Dutta Rabindranath
Paolini Michael A.
Homere Jean R.
Konrad Raynes & Victor LLP
Pham Khanh
Victor David W.
LandOfFree
Method, system, and program for mining data in a personal... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method, system, and program for mining data in a personal..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method, system, and program for mining data in a personal... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3353164