Publishing and subscribing to calendar events information via categorical mapping methodology

• US 9,053,466 B2
• Filed: 10/31/2007
• Issued: 06/09/2015
• Est. Priority Date: 10/31/2007
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Caceres, Barry M.
• Primary Examiner(s): AL HASHEMI, SANA A
• Application Number:
  US11/933,176
• Publication Number:
  US 20090112986A1
• Time in Patent Office: 2,778 Days
• Field of Search: 707/611, 707/618, 707/624, 707/631, 707/638
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/109 Time management, e.g. calendars, reminders, meetings or time accounting

Abstract

A system, method and program product for publishing and subscribing to calendar events publication are disclosed. In one aspect, method and system for providing a publication of calendar events for one or more computer-based devices having a calendaring system capable of operation therein, is disclosed. The method and system comprises defining one or more calendar publication definitions. The definitions comprise an identifier for the publication and a set of criteria for qualifying calendar events from a calendar database for inclusion in and/or exclusion from the publication. The method and system include activating a publication agent for processing each publication definition by applying the qualifying criteria to the calendar database to create a subset of qualified calendar events from the calendar database to be included in the publication. Furthermore, the method and system include aggregating the qualified calendar events into a single identifiable calendar publication making the calendar publication available.

Claims

1. A computer-implemented method for providing a calendar publication, the computer-implemented method comprising:

defining, based on input from a user, one or more calendar publication definitions including;

(i) an identifier for the calendar publication and (ii) a set of criteria for qualifying calendar events from a calendar database for inclusion in or exclusion from the calendar publication, the set of criteria including one or more query conditions;

activating a publication agent for processing each calendar publication definition by applying the respective qualifying criteria to the calendar database in order to identify a subset of qualified calendar events from the calendar database to include in the calendar publication and resulting in one or more calendar events in the calendar database being excluded from the calendar publication, wherein applying the qualifying criteria includes constructing a database query from the one or more query conditions, wherein the calendar publication is uniquely identifiable and exists independently of any subscriber count thereto;

aggregating the qualified calendar events into the calendar publication; and

making the calendar publication available for subscription, without first requiring a publisher of the calendar publication to ascertain any subsequent subscriber to the calendar publication, wherein the calendar publication is platform-independent relative to at least one of;

(i) a plurality of calendaring database platforms and (ii) a plurality of calendaring client platforms.

5. The computer-implemented method of claim 1, wherein each calendar publication definition further comprises one or more transformation rules for transforming the data contained in fields of the qualified calendar events from the calendar database, wherein processing each calendar publication definition by the publication agent further comprises applying the respective one or more transformation rules to the qualified calendar events so that field values of the qualified calendar events are transformed before inclusion in the calendar publication.

6. The computer-implemented method of claim 1, wherein the calendar publication definition further comprises an access control list identifying subscribers who are authorized to access the calendar publication, wherein the publication agent includes the access control list from the respective calendar publication definition in each generated calendar publication so that unauthorized access to restricted publications is prevented when an attempt is later made by a subscriber to access the publication.

7. The computer-implemented method of claim 1, wherein the calendar publication is provided without requiring modification to any of the calendaring databases and without requiring modification to any of the calendaring clients.

8. The computer-implemented method of claim 1,

wherein the set of criteria include a plurality of conditions including the one or more conditions, wherein the database query includes a database query predicate generated from the plurality of query conditions using a query predicate generator, wherein each query condition includes a comparison operator and a comparison value for a database attribute, wherein the comparison operator comprises at least one of a matching operator, a non-matching operator, and a range operator, wherein the plurality of query conditions include:

(i) a first query condition having a first comparison operator selected from a greater-than operator and a greater-than-or-equal-to operator, wherein the first comparison operator is associated with a first comparison value; and

(ii) a second query condition having a second comparison operator selected from a less-than operator and a less-than-or-equal-to operator, wherein the second comparison operator is associated with a second comparison value; and

wherein the first condition and the second condition are determined to belong to a first parenthesized group;

executing a query predicate generator in order to programmatically determine, based on the query conditions, at least one logical operator to include between the query conditions, wherein the first parenthesized group having the first comparison operator and the second comparison operator is modified based on the at least one logical operator, wherein determining the at least one logical operator comprises;

upon determining that the first comparison value is less than the second comparison value, chaining the first and second query conditions with a logical AND operator; and

upon determining that the first comparison value is greater than the second comparison value, chaining the first and second query conditions with a logical OR operator; and

programmatically generating at least one database query predicate to include in a database query to apply against the database for obtaining a set of query results, wherein the database query includes the received query conditions chained using the determined at least one logical operator.

15. The computer-implemented method of claim 5, where the calendar publication definition further comprises one or more transformation criteria for determining whether or not the transformation rules should be applied to a qualified calendar event from the calendar database, wherein the publication agent, for each calendar publication definition, evaluates the one or more transformation criteria for each qualified calendar event before conditionally applying the relative transformation rules to the qualified calendar events that meet the required transformation criteria.

16. The computer-implemented method of claim 7, wherein a plurality of distinct calendar publications is provided, including the calendar publication, wherein the plurality of distinct calendar publications overlap in terms of inclusion of at least one calendar event, wherein the calendar publication supports propagating a change by the publisher without requiring the publisher to first ascertain any subscribers and without causing any calendar event in the calendar publication to be duplicated, wherein the plurality of calendar publications facilitates synchronization to provide one or more latest updates to one or more subscribers and without pushing any subscriber-side calendar events to the plurality of calendar publications.

17. The computer-implemented method of claim 8, wherein constructing the database query predicate further comprises:

determining at least one parenthesized group including the first parenthesized group, wherein each of the at least one parenthesized group includes at least one query condition providing at least one comparison operator and value for the same database attribute;

wherein query conditions within each group having multiple query conditions are processed to determine at least one logical operator to chain the query conditions in the respective group; and

for parenthesized groups having multiple query conditions, generating modified parenthesized groups having the query conditions in the parenthesized group chained with the determined at least one logical operator, wherein the database query predicate comprises the modified parenthesized groups and parenthesized groups having only one query condition;

wherein determining at least one logical operator to include between the query conditions further comprises, in respective instances;

upon determining that a comparison operator of a second parenthesized group comprises a matching operator, chaining a first query condition and a second query condition in the second parenthesized group with the logical OR operator; and

upon determining that a comparison operator of a second parenthesized group comprises a non-matching operator, chaining a first query condition and a second query condition in the second parenthesized group with the logical AND operator.

19. The computer-implemented method of claim 16, wherein the publisher is permitted to define and apply qualifying criteria in order to exclude at least a first calendar entry, while the one or more subscribers are also permitted to define and apply respective qualifying criteria independent of and in addition to the qualifying criteria applied by the publisher and in order to exclude at least a second calendar entry, thereby facilitating customization of display of the calendar publication both from a publisher perspective and from a subscriber perspective;

wherein the calendar publication supports platform-independent access control in terms of limiting access to one or more calendar events and without using any access control functionality specific to any of the calendaring databases, wherein the one or more subscribers are permitted to customize display of the calendar publication using rule-based subscriber preferences that are automatically re-applied upon synchronization.

20. The computer-implemented method of claim 17, wherein constructing the database query predicate further comprises:

generating a modified parenthesized group by removing at least one query condition from one parenthesized group having range operators that specify a range of database attribute values that are a subset of the range of database attribute values of at least one other query condition in the parenthesized group;

chaining the modified parenthesized group and at least one unmodified parenthesized group with the logical AND operator, wherein the database query predicate comprises the chained parenthesized groups;

determining query conditions in a second parenthesized group having query predicates with a “

starts-with”

operator and at least one additional “

starts-with” and

/or “

equals”

(“

=”

) comparison operator and/or a “

does-not-start-with”

operator and at least one additional “

does-not-start-with” and

/or “

not-equal-to”

(“

!=”

) comparison operator; and

removing from the second parenthesized group those determined query conditions whose at least one specified attribute value is a subset of one of the query conditions having a “

starts-with”

or “

does-not-start-with”

operator;

wherein the database query is displayed in a user interface configured to permit a user to modify and view the database query;

receiving user selection in the user interface to execute the database query against the database; and

displaying results of executing the database query in the user interface, wherein the results include a set of calendar events qualified for inclusion in the calendar publication.

21. The computer-implemented method of claim 19, wherein each calendar publication definition further comprises one or more transformation rules for transforming the data contained in fields of the qualified calendar events from the calendar database, wherein processing each calendar publication definition by the publication agent further comprises applying the respective one or more transformation rules to the qualified calendar events such that field values of the qualified calendar events are transformed before inclusion in the calendar publication;

wherein the calendar publication definition further comprises one or more transformation criteria for determining whether or not the transformation rules should be applied to a qualified calendar event from the calendar database, wherein the publication agent, for each calendar publication definition, evaluates the one or more transformation criteria for each qualified calendar event before conditionally applying the relative transformation rules to the qualified calendar events that meet the required transformation criteria.

22. The computer-implemented method of claim 21, wherein the publication agent is activated upon subscriber request to obtain one or more calendar publications, wherein the publication agent is activated as a result of a PDA synchronization process and the subscribers are PDA users, wherein the publication agent is automatically activated periodically to update the content of the one or more calendar publications from the most recent data in the calendar database, wherein the publication agent makes the calendar publications available to an external system that will provide the calendar publications to one or more subscribers;

wherein the calendar publication definition further comprises an access control list identifying subscribers who are authorized to access the calendar publication, wherein the publication agent utilizes the access control list from the calendar publication definition to determine which of the one or more calendar publications the requesting subscriber is authorized to access, wherein publication agent only provides the calendar publications for which the current requesting subscriber is authorized to access.

23. The computer-implemented method of claim 22, wherein the publication agent includes the access control list from the respective calendar publication definition in each generated calendar publication and such that unauthorized access to restricted publications is prevented when an attempt is later made by a subscriber to access the publication, wherein at least a first calendaring client of the calendaring clients is configured to subscribe to the calendar publication by:

defining, based on user input, one or more calendar subscription definitions including;

an identifier for the subscription;

a locator or identifier to find and access the calendar publication, wherein the calendar publication comprises a subset of qualified calendar events from the calendar database; and

a transformation rule to map the calendar events from the calendar publication to one or more categories in a subscriber calendar;

activating a subscription agent for processing each calendar subscription definition by removing existing events in the subscriber calendar that belong to the one or more categories to which calendar events from the calendar publication may be mapped;

retrieving the calendar events from the calendar publication;

transforming the retrieved calendar events according to the defined transformation rule in order to map the category of each event to the one or more subscriber categories for the calendar publication; and

loading the transformed calendar events from the calendar publication into a calendar database, with the mapped category values, of a subscriber.

24. The computer-implemented method of claim 23, wherein in a first instance, the transformation rule for mapping the calendar events to one or more specific categories in a calendar subscription definition maps all calendar events contained in the designated publication for that calendar subscription definition to a single specified category, in which instance the subscription agent performs the removal process for such a calendar subscription definition by removing all existing events in the subscriber calendar that belong to that specified one category for that calendar subscription definition before loading the calendar events from the defined publication of that calendar subscription definition;

wherein in a second instance, the transformation rule for mapping the calendar events to one or more specific categories in a calendar subscription definition determines the mapped category for each calendar event contained in the designated publication for that calendar subscription definition by deriving the category value by pre-pending/appending a prefix and/or suffix, respectively, to a source field from calendar event, in which instance the subscription agent performs the removal process for such a calendar subscription definition by removing all existing events whose categories start with and/or end-with the designated prefix and/or suffix, respectively, for that calendar subscription definition before loading the calendar events from the defined publication of that calendar subscription definition.

25. The computer-implemented method of claim 24, wherein in a third instance, the calendar subscription definition further comprises one or more additional transformation rules for transforming the data contained in the fields of the calendar events from the publication, in which instance processing each calendar subscription definition by the subscription agent further comprises applying the one or more additional transformation rules to the calendar events so that the field values of the qualified calendar events are transformed before loading them into the calendar database;

wherein in the third instance, the calendar subscription definition further comprises one or more transformation criteria for determining whether or not the transformation rules should be applied to a calendar event from the publication, in which instance processing each calendar subscription definition by the subscription agent further comprises evaluating the one or more transformation criteria for each calendar event before conditionally applying the relative transformation rules to the calendar events that meet the required transformation criteria;

wherein in a fourth instance, the calendar subscription definition further comprises a set of criteria for qualifying calendar events from the publication for inclusion in and/or exclusion from the set of calendar events from the publication that is loaded into a calendar of the subscriber, in which instance processing each calendar subscription definition by the subscription agent further comprises applying the qualifying criteria to identify the subset of calendar events from the publication that will be loaded into the subscriber calendar, wherein the subscription agent does not load those calendar events excluded from that subset into the subscriber calendar.

2. A computer-implemented method for subscribing to a calendar publication, the computer-implemented method comprising:

providing the calendar publication, which includes a subset of calendar events from a source calendar database and qualified based on a set of criteria including one or more query conditions;

defining, based on user input, one or more calendar subscription definitions including;

(i) an identifier for the subscription;

(ii) a locator or identifier to find and access the calendar publication, from a source calendar database, the subset excluding at least one calendar event in the source calendar database, wherein the calendar publication is uniquely identifiable and exists independently of any subscriber count thereto; and

(iii) a transformation rule to map the calendar events from the calendar publication to one or more categories in a subscriber calendar;

wherein the calendar publication is made available for subscription, without first requiring a publisher of the calendar publication to ascertain any subsequent subscriber to the calendar publication, wherein the calendar publication is platform-independent relative to at least one of;

(i) a plurality of calendaring database platforms and (ii) a plurality of calendaring client platforms;

activating a subscription agent for processing each calendar subscription definition by removing existing events in the subscriber calendar that belong to the one or more categories to which calendar events from the calendar publication may be mapped;

transforming the calendar events according to the defined transformation rule in order to map the category of each event to the one or more subscriber categories for the calendar publication; and

loading the transformed calendar events from the calendar publication into a calendar database, with the mapped category values, of a subscriber.

9. The computer-implemented method of claim 2, where the transformation rule for mapping the calendar events to one or more specific categories in a calendar subscription definition maps all calendar events contained in the designated publication for that calendar subscription definition to a single specified category wherein the subscription agent performs the removal process for such a calendar subscription definition by removing all existing events in the subscriber calendar that belong to that specified one category for that calendar subscription definition before loading the calendar events from the defined publication of that calendar subscription definition.

10. The computer-implemented method of claim 2, where the transformation rule for mapping the calendar events to one or more specific categories in a calendar subscription definition determines the mapped category for each calendar event contained in the designated publication for that calendar subscription definition by deriving the category value by pre-pending/appending a prefix and/or suffix, respectively, to a source field from calendar event, wherein the subscription agent performs the removal process for such a calendar subscription definition by removing all existing events whose categories start with and/or end-with the designated prefix and/or suffix, respectively, for that calendar subscription definition before loading the calendar events from the defined publication of that calendar subscription definition.

11. The computer-implemented method of claim 2, where the calendar subscription definition further comprises one or more additional transformation rules for transforming the data contained in fields of the calendar events from the publication, wherein processing each calendar subscription definition by the subscription agent further comprises applying the one or more additional transformation rules to the calendar events so that the field values of the qualified calendar events are transformed before loading them into the calendar database.

3. A computer readable medium containing computer program instructions for providing a calendar publication, the program instructions for:

defining, based on user input, one or more calendar publication definitions including;

(i) an identifier for the calendar publication and (ii) a set of criteria for qualifying calendar events from a calendar database for inclusion in or exclusion from the calendar publication, the set of criteria including one or more query conditions;

activating a publication agent for processing each calendar publication definition by applying the qualifying criteria to the calendar database in order to identify a subset of qualified calendar events from the calendar database to include in the calendar publication and resulting in one or more calendar events in the calendar database being excluded from the calendar publication, wherein applying the qualifying criteria includes constructing a database query from the one or more query conditions, wherein the calendar publication is uniquely identifiable and exists independently of any subscriber count thereto;

aggregating the qualified calendar events into the calendar publication; and

making the calendar publication available for subscription, without first requiring a publisher of the calendar publication to ascertain any subsequent subscriber to the calendar publication, wherein the calendar publication is platform-independent relative to at least one of;

(i) a plurality of calendaring database platforms and (ii) a plurality of calendaring client platforms.

12. The computer readable medium of claim 3, wherein each calendar publication definition further comprises one or more transformation rules for transforming the data contained in fields of the qualified calendar events from the calendar database, wherein processing each calendar publication definition by the publication agent further comprises applying the respective one or more transformation rules to the qualified calendar events so that field values of the qualified calendar events are transformed before inclusion in the calendar publication.

18. The computer readable medium of claim 12, where the calendar publication definition further comprises one or more transformation criteria for determining whether or not the transformation rules should be applied to a qualified calendar event from the calendar database, wherein the publication agent, for each calendar publication definition, evaluates the one or more transformation criteria for each qualified calendar event before conditionally applying the relative transformation rules to be qualified calendar events that meet the required transformation criteria.

4. A computer readable medium containing computer program instructions for subscribing to a calendar publication, the program instructions for:

providing the calendar publication, which includes a subset of calendar events from a source calendar database and qualified based on a set of criteria including one or more query conditions;

defining, based on user input, one or more calendar subscription definitions including;

(i) an identifier for the subscription;

(ii) a locator or identifier to find and access the calendar publication, from a source calendar database, the subset excluding at least one calendar event in the source calendar database, wherein the calendar publication is uniquely identifiable and exists independently of any subscriber count thereto; and

(iii) a transformation rule to map the calendar events from the calendar publication to one or more categories in a subscriber calendar;

wherein the calendar publication is made available for subscription, without first requiring a publisher of the calendar publication to ascertain any subsequent subscriber to the calendar publication, wherein the calendar publication is platform-independent relative to at least one of;

(i) a plurality of calendaring database platforms and (ii) a plurality of calendaring client platforms;

activating a subscription agent for processing each calendar subscription definition by removing existing events in the subscriber calendar that belong to the one or more categories to which calendar events from the calendar publication may be mapped;

transforming the calendar events according to the defined transformation rule in order to map the category of each event to the one or more subscriber categories for the calendar publication; and

loading the transformed calendar events from the calendar publication into a calendar database, with the mapped category values, of a subscriber.

13. The computer readable medium of claim 4, where the transformation rule for mapping the calendar events to one or more specific categories in a calendar subscription definition maps all calendar events contained in the designated publication for that calendar subscription definition to a single specified category, wherein the subscription agent performs the removal process for such a calendar subscription definition by removing all existing events in the subscriber calendar that belong to that specified one category for that calendar subscription definition before loading the calendar events from the defined publication of that calendar subscription definition.

14. The computer readable medium of claim 4, where the transformation rule for mapping the calendar events to one or more specific categories in a calendar subscription definition determines the mapped category for each calendar event contained in the designated publication for that calendar subscription definition by deriving the category value by pre-pending/appending a prefix or suffix, respectively, to a source field from calendar event, wherein the subscription agent performs the removal process for such a calendar subscription definition by removing all existing events whose categories start with or end-with the designated prefix or suffix, respectively, for that calendar subscription definition before loading the calendar events from the defined publication of that calendar subscription definition;

wherein the calendar subscription definition further comprises one or more additional transformation rules for transforming the data contained in fields of the calendar events from the publication, wherein processing each calendar subscription definition by the subscription agent further comprises applying the one or more additional transformation rules to the calendar events so that the field values of the qualified calendar events are transformed before loading them into the calendar database.