Method, system and apparatus for efficiently determining priority of data in a database

• US 8,849,806 B2
• Filed: 03/23/2010
• Issued: 09/30/2014
• Est. Priority Date: 03/23/2010
• Status: Expired due to Fees

• Current Assignee: Blackberry Limited
• Original Assignee: Blackberry Limited
• Inventors: Walker, David Ryan, Klassen, Gerhard Dietrich, Godfrey, James Andrew, Rose, Scott Douglas, Bells, Matthew, Fyke, Steven Henry
• Primary Examiner(s): CHANNAVAJJALA, SRIRAMA T
• Application Number:
  US12/729,868
• Publication Number:
  US 20110238671A1
• Time in Patent Office: 1,652 Days
• Field of Search: 707601-602, 707/656, 707705-707, 707/723, 707748-754, 707/792, 707/609, 707/694, 707/731, 707769-770, 707/805, 709/203, 709/206, 709/737, 709751-752, 709/762, 709/963, 705/309, 705/319, 705/301, 705/7.16, 705 718- 719, 705/7.24, 706/926, 706/934, 345/650, 345/661, 345/674, 345/213, 715/710, 715/752, 715/963, 715/968, 719/318, 718/100
• US Class Current: 707/723
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 16/24578 using ranking
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 3/00 Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
• CPC Class Codes: G06Q 10/109 Time management, e.g. calendars, reminders, meetings or time accounting
• CPC Class Codes: Y10S 715/963 Calendar or scheduling
• CPC Class Codes: Y10S 715/968 interface for database querying and retrieval

Abstract

A method and apparatus for determining priority of data in a database managed by a computing device are provided. The data comprises a list of events, the computing device comprising a processing unit interconnected with a memory device and a display device. Context data is processing at the processing unit to determine a priority ranking for each of the items, wherein processing the context data to determine a priority ranking comprises at least one of processing attendance data, location, event data, and telephone record data. Respective areas of the display device are controlled to provide visual representations of each of the events, each respective area controlled according to the priority ranking.

Claims

1. A method for determining priority of data in a database managed by a computing device, the data comprising a list of events, the computing device comprising a processing unit interconnected with a memory device and a display device, the method comprising:

processing context data at the processing unit to determine an attendance history, and based on the attendance history a priority ranking for each of the events in the list;

controlling respective areas of the display device to provide visual representations of each of the events in a calendar application, each respective area controlled according to the priority ranking;

generating reminder data for at least two calendar events based on the priority ranking;

controlling the display device to provide the reminder data for the at least two calendar events based on the priority ranking as determined based on the attendance history; and

generating delete data events based on the priority ranking such that an event that meets a predetermined threshold value is deleted from the data.

2. The method of claim 1, wherein generating reminder data includes an option for at least one of declining a calendar event invitation and moving an event associated with the data.

3. The method of claim 1, further comprising controlling the display device to provide a calendar view of the data, wherein each of the events comprises a calendar event given a visual precedence in the calendar view based on the priority ranking.

4. The method of claim 1, wherein the predetermined threshold value is based on at least one of a period of time that a recurring calendar event has not been attended, a number of times that the recurring calendar event has been attended, and a threshold priority ranking.

5. The method of claim 4, further comprising generating a prompt indicative that the delete data events should be generated wherein the generating the delete data events occurs after receiving a positive response to the prompt.

6. The method of claim 1, wherein the database is stored in at least one of the memory device and a remote database.

7. The method of claim 1, wherein at least one of the events corresponds to a work associated calendar event that occurs during a vacation period, the work associated calendar event automatically hidden during the vacation period.

8. The method of claim 7, further comprising providing a show work appointments icon at the display device which, when selected, causes the work associated calendar event to be displayed, and providing a hide work appointments icon which, when selected, causes the work associated calendar events to be hidden.

9. The method of claim 1, wherein at least one of the events corresponds to a travel-related calendar event that occurs during a travel period, the travel-related calendar event given a visual precedence during the travel period.

10. The method of claim 9, wherein at least another of the events corresponds to a non-travel-related calendar event that occurs during the travel period, the non-travel-related calendar event given diminished visual precedence during the travel period.

11. The method of claim 1, wherein processing the context data to determine a priority ranking comprises at least one of:

processing the data to determine attendance data associated with each the event;

processing location data associated with each the event to determine the attendance data;

processing the attendance data associated with each the event to determine if recurring events have been attended, and assigning higher respective priority rankings to events having higher attendance;

processing the attendance data to determine which of at least two conflicting recurring events have been previously attended, and assigning higher respective priority rankings to an event having higher attendance;

processing event data to determine when each of the events have occurred, been cancelled or moved; and

processing telephone record data to determine the attendance data.

12. A computing device for determining priority of data in a database managed by the computing device, the data comprising a list of events, the computing device comprising:

a processing unit interconnected with a memory device and a display device, the processing unit enabled to;

process context data to determine an attendance history, and based on the attendance history a priority ranking for each of the events in the list;

control respective areas of the display device to provide visual representations of each of the events in a calendar application, each respective area controlled according to the priority ranking;

generate reminder data for at least two calendar events based on the priority ranking;

control the display device to provide the reminder data for the at least two calendar events based on the priority ranking as determined based on the attendance history; and

generate delete data events based on the priority ranking such that an event that meets a predetermined threshold value is deleted from the data.

13. The computing device of claim 12, wherein the reminder data includes an option for at least one of declining a calendar event invitation and moving an event associated with the data.

14. The computing device of claim 12, wherein the processing unit is further enabled to control the display device to provide a calendar view of the data, wherein each of the events comprises a calendar event given a visual precedence in the calendar view based on the priority ranking.

15. The computing device of claim 12, wherein the predetermined threshold value is based on at least one of a period of time that a recurring calendar event has not been attended, a number of times that the recurring calendar event has been attended, and a threshold priority ranking.

16. The computing device of claim 15, wherein the processing unit is further enabled to generate a prompt indicative that the delete data events should be generated wherein the delete data events occurs after receiving a positive response to the prompt.

17. The computing device of claim 12, wherein the database is stored in at least one of the memory device and a remote database.

18. The computing device of claim 12, wherein at least one of the events corresponds to a work associated calendar event that occurs during a vacation period, the work associated calendar event automatically hidden during the vacation period.

19. The computing device of claim 12, wherein the processing unit is further enabled to provide a show work appointments icon at the display device which, when selected, causes the work associated calendar event to be displayed, and provide a hide work appointments icon which, when selected, causes the work associated calendar events to be hidden.

20. The computing device of claim 12, wherein at least one of the events corresponds to a travel-related calendar event that occurs during a travel period, the travel-related calendar event given a visual precedence during the travel period.

21. The computing device of claim 20, wherein at least another of the events corresponds to a non-travel-related calendar event that occurs during the travel period, the non-travel-related calendar event given diminished visual precedence during the travel period.

22. The computing device of claim 17, wherein to process the context data to determine a priority ranking the processing unit is further enabled to at least one of:

process the data to determine attendance data associated with each the event;

process location data associated with each the event to determine the attendance data;

process the attendance data associated with each the event to determine if recurring events have been attended, and assign higher respective priority rankings to events having higher attendance;

process the attendance data to determine which of at least two conflicting recurring events have been previously attended, and assign higher respective priority rankings to an event having higher attendance;

process event data to determine when each of the events have occurred, been cancelled or moved; and

process telephone record data to determine the attendance data.