SYSTEM AND METHOD FOR MONITORING OF DATABASE DATA

• US 20160132511A1
• Filed: 11/10/2014
• Published: 05/12/2016
• Est. Priority Date: 11/10/2014
• Status: Active Grant

• Current Assignee: Business Objects Incorporated (SAP SE)
• Original Assignee: Business Objects Incorporated (SAP SE)
• Inventors: Mak, Walter, Chan, Pak Man
• Granted Patent: US 10,049,112 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/122 using management policies backup systems G06F11/1446; file migration policies for HSM systems G06F16/185
• CPC Class Codes: G06F 16/1734 Details of monitoring file system events, e.g. by the use of hooks, filter drivers, logs

Abstract

The present disclosure relates a computer-implemented method comprising obtaining, at a database application, a selection of one or more database metadata items from a user device, wherein each metadata item includes human-intelligible content and each metadata item identifying an associated database object contained in a database, identifying, based at least partially on the database objects associated with the selected one or more metadata items, one or more predefined database views of the database application, registering the identified one or more predefined database views, monitoring if the one or more predefined database views are updated after the registering operation and triggering pushing of an update notification to the user device in response to a monitored update of the one or more predefined database views.

Claims

1. A computer-implemented method, the method comprising:

obtaining, at a database application, a selection of one or more database metadata items from a user device, wherein each metadata item includes human-intelligible content and wherein each metadata item identifies an associated database object contained in a database;

identifying, based at least partially on the database objects associated with the selected one or more metadata items, one or more predefined database views of the database application;

registering the identified one or more predefined database views;

monitoring whether the one or more predefined database views are updated after the registering operation; and

triggering pushing of an update notification to the user device in response to a monitored update of the one or more predefined database views.

2. The computer-implemented method of claim 1, wherein triggering pushing of an update notification to the user device includes sending status update information to a push notification server, wherein the status update information includes information regarding an update of the predefined database view.

3. The computer-implemented method of claim 2, wherein the push notification server is a mobile device operating system push application server.

4. The computer-implemented method of claim 1, further comprising providing the identified one or more predefined database views for consumption to the user device.

5. The computer-implemented method of claim 1, wherein the one or more database objects include one or more columns of one or more database tables.

6. The computer-implemented method of claim 1, wherein one or more of the operations of obtaining the selection of one or more database metadata items, identifying one or more predefined database views, registering the identified one or more predefined database views, monitoring if the one or more predefined database views are updated, and triggering pushing of an update notification to the user device are performed by an in-memory database application.

7. The computer-implemented method of claim 1, wherein the user device is a mobile device.

8. The computer-implemented method of claim 1, wherein the one or more predefined database views include one or more of an attribute view, an analytic view, or a calculation view, wherein an attribute view references one or more data items in other tables of the database, wherein an analytic view defines on or more functions operable on data items in the database, and wherein a calculation view is operable to provide composites of other views.

9. The computer-implemented method of claim 1, wherein identifying one or more predefined database views of the database application comprises:

obtaining information identifying a popularity of the one or more database objects associated with the selected one or more database metadata items in previous user selection processes; and

identifying, based at least partially on the database objects associated with the selected one or more metadata items and the information identifying a popularity of the one or more database objects, the one or more predefined database views of the database application.

10. The computer-implemented method of claim 9, wherein the popularity of the one or more database objects is determined at least partially based on a selection frequency in previous user selection processes.

11. The computer-implemented method of claim 1, wherein identifying one or more predefined database views of the database application comprises:

obtaining user-specific information associated with the user of the user device; and

identifying, based at least partially on the database objects associated with the selected one or more metadata items and the user information, the one or more predefined database views of the database application.

12. The computer-implemented method of claim 1, wherein identifying one or more predefined database views of the database application comprises:

obtaining usage information of the database objects associated with the selected one or more metadata items; and

identifying, based at least partially on the database objects associated with the selected one or more metadata items and the usage information of the database objects, the one or more predefined database views of the database application.

13. The computer-implemented method of claim 1, wherein monitoring if the one or more predefined database views are updated comprises one or more of monitoring a status of the predefined database views, monitoring if a measure or metadata calculated from a measure of the predefined database views changes and monitoring if an alert system of the predefined database view is triggered.

14. The computer-implemented method of claim 1, wherein the method further comprises providing a list of selectable database metadata items for presentation on the user device.

15. The computer-implemented method of claim 1, wherein the database metadata items include one or more of a identifier of the associated one or more database objects, a title of the associated one or more database objects, or a description of the associated one or more database objects.

16. The computer-implemented method of claim 1, the method further comprising receiving, from the user device, a request to provide the one or more updated predefined database views to the user device.

17. A computer readable medium storing instructions thereon which when executed by a processor cause the processor to:

obtain, at a database application, a selection of one or more database metadata items from a user device, wherein each metadata item includes human-intelligible content and wherein each metadata item identifies an associated database object contained in a database;

obtain information identifying a popularity of the one or more database objects associated with the selected one or more database metadata item in previous user selection processes;

identify, based at least partially on the database objects associated with the selected one or more metadata items and the information identifying a popularity of the one or more database objects, one or more predefined database views of the database application; and

register the identified one or more predefined database views for future provision of data related to the one or more predefined database views to a user device.

18. A system comprising:

one or more processors; and

a computer-readable medium storing instructions executable by the one or more processors to perform operations comprising;

obtaining, at a database application, a selection of one or more database metadata items from a user device, wherein each metadata item includes human-intelligible content and wherein each metadata item identifies an associated database object contained in a database;

identifying, based at least partially on the database objects associated with the selected one or more metadata items, one or more predefined database views of the database application;

registering the identified one or more predefined database views;

monitoring whether the one or more predefined database views are updated after the registering operation; and

triggering pushing of an update notification to the user device in response to a monitored update of the one or more predefined database views.