Data Change Tracking and Event Notification

• US 20130006664A1
• Filed: 08/09/2011
• Published: 01/03/2013
• Est. Priority Date: 06/30/2011
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Mohiuddin, Imran, Dove, Bryan, Shah, Mehul Y., Madan, Umesh, Emami, Ali, May, Robert A., Chaliparambil, Kishore R., Chan, Chi Kit, Gunnerson, Eric
• Application Number:
  US13/206,365
• Publication Number:
  US 20130006664A1
• Time in Patent Office: Days
• US Class Current: 705/3
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G16H 10/60 for patient-specific data, e.g. for electronic patient records

Abstract

The described implementations relate to updating views in a database system. One implementation can identify an active view that retrieves records from a database and determine one or more physical tables in the database that are referenced by the active view. The implementation can track one or more columns in the physical tables that are used by the active view and identify a change to the physical tables in a transaction log of the database. If the change does not affect the one or more columns, the change can be treated as an ignorable change for the active view.

Claims

1-21. -21. (canceled)

22. A method comprising:

registering a subscription for an entity to receive a notification relating to a personal health care record stored in a health care database;

associating the subscription with a health care concept; and

in an instance when a transaction log of the health care database is updated to include a value that relates to the health care concept, sending the notification to the entity.

23. The method according to claim 22, wherein the associating comprises storing, in association with the subscription, one or more identifiers of data for which the entity will receive notifications.

24. The method according to claim 23, further comprising expanding an individual identifier to a plurality of different values.

25. The method according to claim 24, wherein the individual identifier comprises a keyword and the plurality of different values comprise terms that are related to the keyword.

26. The method according to claim 22, wherein the subscription is associated with a defined range of values, and the value is within the defined range of values.

27. The method according to claim 22, wherein the health care concept comprises a predefined code for a drug and the value comprises a brand name for the drug.

28. The method according to claim 22, wherein the health care concept comprises a brand name for a drug and the value comprises a predefined code for the drug.

29. One or more computer-readable storage media comprising computer-readable instructions which, when executed by one or more computing devices, cause the one or more computing devices to perform:

registering a first subscription for a first entity to receive a first notification relating to a personal health care record stored in a health care database, the first entity having a first role;

registering a second subscription for a second entity to receive a second notification relating to the personal health care record, the second entity having a second role;

associating the first subscription and the second subscription with a health care concept; and

responsive to determining that the health care database is being updated to include a value that relates to the health care concept, sending the first notification to the first entity and the second notification to the second entity.

30. The one or more computer-readable storage media according to claim 29, the first role reflecting that the first entity is a physician.

31. The one or more computer-readable storage media according to claim 30, the second role reflecting that the second entity is a nurse.

32. The one or more computer-readable storage media according to claim 31, wherein the first notification includes at least some data from the personal health care record that is provided to the physician but that is not provided in the second notification to the nurse.

33. The one or more computer-readable storage media according to claim 29, wherein the health care concept reflects patients of a physician and the value identifies an individual one of the patients.

34. The one or more computer-readable storage media according to claim 31, wherein at least one of the first notification or the second notification is sent before the value is persisted in the health care database.

35. A system comprising:

a subscription module configured to;

register a subscription for an entity to receive a notification relating to a personal health care record stored in a health care database;

associate the subscription with a health care concept;

detect an updated data value for the personal health care record, the updated data value being associated with the health care concept;

responsive to the updated data value being detected, trigger the notification to be sent to the entity; and

provide the notification to the entity by sending the notification to the entity via a delivery channel; and

one or more processors configured to execute the subscription module.

36. The system according to claim 35, wherein the subscription module is configured to exclude particular data from the notification in instances when the delivery channel is relatively less secure, and include the particular data in other instances when the delivery channel is relatively more secure.

37. The system according to claim 36, wherein:

the instances when the delivery channel is relatively less secure comprise instances when the delivery channel is unencrypted, and

the other instances when the delivery channel is relatively more secure comprise instances when the delivery channel is encrypted.

38. The system according to claim 37, wherein, in the instances when the delivery channel is unencrypted, the subscription module is configured to exclude patient drug information from the notification.

39. The system according to claim 38, wherein, in the other instances when the delivery channel is encrypted, the subscription module is configured to include the patient drug information in the notification.

40. The system according to claim 36, wherein the particular data excluded from the notification comprises symptoms of the patient.

41. The system according to claim 35, wherein the subscription module is configured to send the notification to a general practitioner via a mobile device when a patient of the general practitioner is admitted to a health care facility, and require the general practitioner to enter a password before providing the general practitioner with symptoms of the patient.