DISTRIBUTED EVENT SYSTEM FOR RELATIONAL MODELS

• US 20110302200A1
• Filed: 03/11/2011
• Published: 12/08/2011
• Est. Priority Date: 03/15/2010
• Status: Active Grant

• Current Assignee: Vmware LLC (Broadcom, Inc.)
• Original Assignee: VMware, Inc. (Broadcom, Inc.)
• Inventors: Muller, Leslie, Wasser, Michael Morris, Maestro, Alberto Arias
• Granted Patent: US 9,195,707 B2
• Time in Patent Office: Days
• US Class Current: 707/769
• CPC Class Codes: G06F 16/212 with details for data modelling support
• CPC Class Codes: G06F 16/24549 Run-time optimisation
• CPC Class Codes: G06F 16/24565 Triggers; Constraints
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/9535 Search customisation based on user profiles and personalisation
• CPC Class Codes: G06F 21/10 Protecting distributed programs or content, e.g. vending or licensing of copyrighted material protection in video systems or pay television H04N7/16 ; Digital rights management [DRM]
• CPC Class Codes: G06F 21/6218 to a system of files or objects, e.g. local or distributed file system or database
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries

Abstract

A distributed event system for a relational database is disclosed. An event data model operatively describes a target database. For a subject entity in the target database, the event data model declares and defines triggering events and respective corresponding operations. An event engine monitors database queries and events involving the subject entity and determines from the event data model corresponding operations. Execution of the determined corresponding operations is distributed to network-based agents. Agents may be filtered based on skills and/or credentials injected at runtime. Code binaries of the operations are downloaded to the agents for execution.

Claims

1. A database method comprising:

providing an event data model of a target database, the target database being one of a plurality of databases;

per a subject entity in the target database, using the event data model to declare and define triggering events and respective corresponding operations for each triggering event;

detecting occurrence of an event involving the subject entity in the target database;

based on the detected event, determining from the event data model corresponding operations; and

distributing execution of the determined corresponding operations.

2. A method as claimed in claim 1 wherein the step of distributing employs one or more agents to execute respective operations;

and

respective code binaries of the operations are downloaded to the one or more agents.

3. A method as claimed in claim 2 wherein each agent has a common set of skills;

and

the method further comprises annotating the event data model with skills in a manner enabling respective filtering of agents for executing different operations.

4. A method as claimed in claim 2 wherein different agents have respective different credentials;

and

the step of distributing execution further comprises injecting credentials per operation.

5. A method as claimed in claim 2 wherein said distributing operations to agents is on a first come first served basis.

6. A method as claimed in claim 1 wherein the target database is a relational database.

7. A method as claimed in claim 1 wherein the step of detecting includes:

(a) intercepting a query of the target database;

(b) identifying the subject entity as part of the query; and

(c) cross referencing event and corresponding operations in the event data model for the subject entity as identified in the query.

8. A method as claimed in claim 1 wherein the target database is one or more databases.

9. A computer database system comprising:

an event data model of a target database, for a subject entity in the target database, the event data model declaring and defining triggering events and corresponding operations for each triggering event, wherein the target database is one of a plurality of databases;

an event engine executed by a processor, the event engine (i) detecting occurrence of an event involving the subject entity in the target database, (ii) based on the detected event, determining from the event data model corresponding operations, and (iii) distributing execution of the determined corresponding operations; and

one or more agents responsive to the event engine and executing the determined corresponding operations.

10. A computer database system as claimed in claim 9 wherein each agent has a common set of skills;

and

the event data model is annotated with skills in a manner enabling respective filtering of agents for executing different operations.

11. A computer database system as claimed in claim 9 wherein different agents have different credentials;

and

the event engine enables credentials to be injected per determined corresponding operation at runtime.

12. A computer database system as claimed in claim 9 wherein each agent obtains determined corresponding operations to execute on a first come, first served basis.

13. A computer database system as claimed in claim 9 wherein the target database is one or more relational databases.

14. A computer database system as claimed in claim 9 wherein the event engine detecting occurrence of an event involving the subject entity includes a security runtime subsystem, the security runtime subsystem:

intercepting a query of the target database;

identifying the subject entity as part of the query; and

cross referencing event and corresponding operations in the event data model for the subject entity as identified in the query.

15. A computer database system as claimed in claim 9 wherein to execute the determined corresponding operations, the one or more agents download code binaries of the determined corresponding operations.

16. A computer program product comprising:

a computer readable storage medium having computer program code embodied therewith; and

the computer program code including code configured to;

(i) provide an event data model of a target database in a plurality of databases, per a subject entity in the target database, the event data model declares and defines triggering events and corresponding operations for each triggering event;

(ii) detect occurrence of an event involving the subject entity in the target database by monitoring queries of the target database;

(iii) based on the detected event, determine from the event data model corresponding operations; and

(iv) distribute execution of the determined corresponding operations.

17. A computer program product as claimed in claim 16 wherein the program code for distributing execution employs one or more agents to execute operations, the agents downloading code binaries to execute the operations.

18. A computer program product as claimed in claim 16 wherein the target database is one or more relational databases.

19. A computer program product as claimed in claim 16 wherein the databases in the plurality are unrelated to each other and are non-centrally managed.