# US 2024/0176773 A1 · Push channel and filtered subscription for near real time updates

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2024/0176773 A1
- Document ID: US20240176773A1
- Status: Published application
- Kind: A1
- Application number: 18/059,276
- Filed: 2022-11-28
- Published: 2024-05-30
- Earliest claimed: 2022-11-28
- Assignees: Salesforce, Inc.
- Applicants: Salesforce, Inc.
- Inventors: Ihor MOCHURAD; Dai Duong Doan; Manisha CHAURASIA
- Web page: https://patentgrep.com/patent/US20240176773A1

## CPC

- G06F 16/2379: {Updates performed during online database operations; commit processing}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Disclosed are some implementations of systems, apparatus, methods and computer program products for implementing a push strategy in a database system. A filtered subscription associated with a topic channel is received from a client subscriber, where the topic channel is associated with one or more topics, and where the filtered subscription can include a query that indicates values of one or more database fields for which database record data is requested. Database records associated with the topic channel are identified from a transaction log. The database records are further filtered according to the filtered subscription such that a set of filtered database records are obtained. The filtered database records are transmitted via a publisher to the subscriber without receiving a request from the subscriber.

## Claims

### Claim 1

A method, comprising:
receiving, by one or more servers from a subscriber, a filtered subscription associated with a topic channel, the topic channel being associated with one or more topics;
identifying, by the one or more servers from a transaction log, one or more database transactions relating to the topic channel;
filtering, by the one or more servers, the one or more database transactions according to the filtered subscription such that one or more filtered database transactions are obtained, the one or more filtered database transactions including at least a portion of the one or more database transactions; and
transmitting, by the one or more servers via a publisher, the one or more filtered database transactions to the subscriber.

### Claim 2 (depends on 1)

The method of claim 1, the subscriber being associated with a dispatcher console.

### Claim 3 (depends on 1)

The method of claim 1, the filtered transactions pertaining to a set of service appointment requests.

### Claim 4 (depends on 1)

The method of claim 1, the topic channel having a lifetime associated therewith.

### Claim 5 (depends on 1)

The method of claim 1, the filtered subscription including a query defined by a value for one or more database fields.

### Claim 6 (depends on 1)

The method of claim 1, the topic channel being defined by a topic and a query.

### Claim 7 (depends on 1)

The method of claim 1, wherein transmitting is performed automatically without receiving a message from the subscriber.

### Claim 8

A system comprising:
a database system implemented using a server system, the database system configurable to cause:
receiving, from a subscriber, a filtered subscription associated with a topic channel, the topic channel being associated with one or more topics, the filtered subscription indicating values of one or more database fields;
identifying, from a transaction log, one or more database transactions relating to the topic channel;
filtering the one or more database transactions according to the filtered subscription such that one or more filtered database transactions are obtained, the one or more filtered database transactions including at least a portion of the one or more database transactions; and
transmitting, via a publisher, the one or more filtered database transactions to the subscriber.

### Claim 9 (depends on 8)

The system of claim 8, the subscriber being associated with a dispatcher console.

### Claim 10 (depends on 8)

The system of claim 8, the filtered transactions pertaining to a set of service appointment requests.

### Claim 11 (depends on 8)

The system of claim 8, the topic channel having a lifetime associated therewith.

### Claim 12 (depends on 8)

The system of claim 8, the filtered subscription including a query defined by a value for one or more database fields.

### Claim 13 (depends on 8)

The system of claim 8, the topic channel being defined by a topic and a query.

### Claim 14 (depends on 8)

The system of claim 8, wherein transmitting is performed automatically without receiving a message from the subscriber.

### Claim 15

A computer program product comprising computer-readable program code capable of being executed by one or more processors when retrieved from a non-transitory computer-readable medium, the program code comprising computer-readable instructions configurable to cause:
receiving, from a subscriber, a filtered subscription associated with a topic channel, the topic channel being associated with one or more topics, the filtered subscription indicating values of one or more database fields;
identifying, from a transaction log, one or more database transactions relating to the topic channel;
filtering, the one or more database transactions according to the filtered subscription such that one or more filtered database transactions are obtained, the one or more filtered database transactions including at least a portion of the one or more database transactions; and
transmitting, via a publisher, the one or more filtered database transactions to the subscriber.

### Claim 16 (depends on 15)

The computer program product of claim 15, the subscriber being associated with a dispatcher console.

### Claim 17 (depends on 15)

The computer program product of claim 15, the filtered transactions pertaining to a set of service appointment requests.

### Claim 18 (depends on 15)

The computer program product of claim 15, the topic channel having a lifetime associated therewith.

### Claim 19 (depends on 15)

The computer program product of claim 15, the filtered subscription including a query defined by a value for one or more database fields.

### Claim 20 (depends on 15)

The computer program product of claim 15, the topic channel being defined by a topic and a query.
