Microsoft Technology Licensing, LLC

Snowflake Inc.

Hitesh Madan

Jayaraman Kalyana Sundaram

Venkata Raja Gopal Ravipati

Cesar Martin Ruiz-Meraz

Clemens Friedrich Vasters

David Leon Stucki

Hillary Caituiro Monge

PadmaPriya Aradhyula Bhavani

Subramanian Muralidhar

Di Wu

Nithin Mahesh

Sahaj Saini

Ashraf Hamad

Bahram Banisadr

Padma Priya Aradhyula Bhavani

Loc Duc Bui

Padmapriya Aradhyula Bhavani

The subject technology determines a set of share objects in a replication group. The subject technology, for each object from the set of share objects, determines a set of permissions for a set of objects of databases that has been granted to each share object from the replication group. The subject technology, for each permission from the set of permissions, determines a set of dependencies, the set of dependencies comprising a second set of objects. The subject technology generates a graph structure based at least in part on the set of share objects, the set of permissions, and the set of dependencies. The subject technology traverses at least a portion of the graph structure to determine a final set of dependencies for replication. The subject technology performs a replication process based at least in part on the final set of dependencies.

Share-based replication

Systems and methods for providing targeted event notifications to subscribers are disclosed. In an example embodiment, events may be received from a publisher. The events may be categorized into a plurality of topics. The events may be distributed among brokers to process a topic selected from the plurality of topics based on the events. Further, it may be determined whether the topic exists in a list of topics handled by the brokers. Authentication credentials of the publisher may be validated, based on the determination. Based on the validation, queues of the events may be formed based on an order of receipt of the events. The events present in the queues may be filtered based on subscriptions of the events. For the fileted events, targeted even notifications may be forwarded to the subscribers.

Subscription based event notifications

Systems and methods for filtering and routing event notifications to subscribers are disclosed. In an example embodiment, events from a publisher may be received. Each of the events may be associated with a topic, and the topic may be compared with topics present in broker metadata cache, based on one of prefixes and a fast lookup technique using a hash-table. Further, it may be determined whether the topic associated the events is present in the broker metadata cache based on comparison. Based upon determining, matching nodes for the events may be retrieved. Further, the events may be routed based on routing tables and availability of the matching nodes. Based on the routing, the events may be forwarded to the subscribers.

Routing and filtering event notifications

Systems and methods for dispatching targeted event notifications to subscribers are disclosed. In an embodiment, the system includes a receiver to receive events from a publisher. The system further comprises a router in communication with the receiver to route the events. The system further comprises a director to forward the targeted event notifications to the subscribers based on the routing. The director receives a delivery status of the targeted event notification from the subscribers. The delivery status includes one of success in receiving the targeted event notification and failure in receiving the targeted event notification. The director receives an event notification with the delivery status as failure in receiving the targeted event notification. The director places the targeted event notification in a delayed queue indicative of events to be delivered after a predefined time. The director re-transmits the targeted event notification to the subscribers based on the delayed queue.

Event delivery

Systems and methods for dispatching targeted event notifications to subscribers are disclosed. In an example embodiment, a notification indicating creation of an even subscription by a subscriber may be received. An event source may be invoked to enable publishing of events corresponding to an event topic associated with the event subscription. A response from the event source for publishing of the events may be received and targeted event notifications may be forwarded to the subscribers on receiving the response.

Managing subscriptions for event notifications

Publishing events. A method includes a publisher sending a message comprising one or more events to a domain. The domain is a container comprising a group of domain topics. Each domain topic in the domain is relevant by subject matter to the one or more events by virtue of belonging to the container. The method further includes, at the domain determining the appropriate domain topics from the group of domain topics for each event in the one or more events. The method further includes identifying subscribers to the appropriate domain topics. The method further includes sending notifications to the subscribers of the domain topics of the one or more events.

Event domains

Growing community of inventors

Seattle, WA, United States of America

Hitesh Madan