# US 2024/0177187 A1 · System and method for loading secure data in multiparty secure computing environment

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

- Number: US 2024/0177187 A1
- Document ID: US20240177187A1
- Status: Published application
- Kind: A1
- Application number: 18/431,411
- Filed: 2024-02-02
- Published: 2024-05-30
- Earliest claimed: 2021-03-22
- Assignees: Royal Bank of Canada
- Applicants: Royal Bank of Canada
- Inventors: Edison U. ORTIZ; David Ian MCKAY; Christoph KNOESS; Seung Bong BAEK; Ravi KHANDAVILLI; Adel Al NABULSI; Arnold BADAL-BADALIAN; Justin SIMONELIS
- Web page: https://patentgrep.com/patent/US20240177187A1

## CPC

- G06Q 30/0224: {based on user history}
- H04L 63/10: {for controlling access to devices or network resources}
- H04L 63/20: {for managing network security; network security policies in general (filtering policies H04L63/0227)}
- G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M)

## Abstract

A computational approach is proposed herein for controlling a user interface for rendering of interactive graphical control elements representing offers and coupons that are inserted into a computational payment process. In particular, the offers and coupons can interact with stored payment information resident (or tokens thereof) on a digital wallet data structure. The approach can be implemented as a computing system, a computing method operable on a computing system, or a computer program product affixed in the form of a non-transitory computer readable medium storing machine-interpretable instructions.

## Claims

### Claim 1

A computer system for privacy preserving cross-data table analysis, the computer system comprising:
a processor operating in conjunction with computer memory and storing data on a non-transitory computer readable storage medium, the processor configured to:
receive, through a network from a computing device, a query message request representing a set of logical conditions requiring cross-table connections between at least two tables of a plurality of data tables associated with at least two different data sources or entities, each logical condition of the set of logical conditions representing a user characteristic, each data table of the plurality of data tables including at least a field representing unique identifiers used as a primary key for identifying a user across the plurality of data tables, a first corresponding field representing the user characteristic for each unique identifier of the unique identifiers, and a second corresponding field representing a consent field for each unique identifier of the unique identifiers;
aggregate the at least two data tables of the plurality of data tables together for the cross-table connections, wherein the aggregated at least two data tables of the plurality of data tables is not accessible external to a trusted execution environment;
in response to receiving the query message request, generate an audience list representing one or more users within the aggregated at least two data tables satisfying the set of logical conditions;
validate or compare the query message request in accordance with or for adherence to one or more privacy policy requirements by validating or comparing the query message request against the second corresponding field representing the consent field of the one or more users in the audience list and modifying the audience list in adherence to the one or more privacy policy requirements without use of cookies on a webpage or computing device.

### Claim 2 (depends on 1)

The computer system of claim 1, wherein the set of logical conditions includes a threshold score established through a plurality of weighted logical conditions to be met, and wherein the computing device is not provided individual scores contributing to the threshold score.

### Claim 3 (depends on 1)

The computer system of claim 1, wherein the audience list data structure is maintained on the always protected database system and the computing device does not have access to the audience list data structure.

### Claim 4 (depends on 1)

The computer system of claim 1, wherein the loaded plurality of data tables is joined together in a temporal aggregate data table for processing the query message request, and the temporal aggregate data table is discarded after processing the query message request.

### Claim 5 (depends on 1)

The computer system of claim 1, wherein the query message request is communicated by the computing device along with a consent data structure representing consent tokens provided by at least one of a user or data sources corresponding to the plurality of data tables to be loaded, and wherein the validation of the query message request for adherence to one or more privacy policy requirements includes validating the consent data structure.

### Claim 6 (depends on 5)

The computer system of claim 5, wherein the consent data structure includes cryptographic keys, each corresponding to at least one of the at least one of a user or data sources corresponding to the plurality of data tables to be loaded, and each of the cryptographic keys are validated against a corresponding cryptographic key validation portion stored on or accessible by the always protected database system.

### Claim 7 (depends on 1)

The computer system of claim 1, wherein the audience list is utilized for automatic provisioning of offers or promotions and a list of users of the audience list is not otherwise accessible.

### Claim 8 (depends on 1)

The computer system of claim 1, wherein the audience list is utilized for coordinating eligibility for multiple campaigns to prevent provisioning overlapping promotions to a same user on the audience list.

### Claim 9 (depends on 1)

The computer system of claim 1, wherein the audience list is utilized for automatic eligibility for promotions based on user attributes.

### Claim 10 (depends on 1)

The computer system of claim 1, wherein the computer system is a computing server appliance residing within a data center, the computing server appliance connected through a message bus to receive the query message request across a network from the campaign management process coupled through an interface.

### Claim 11

A computer method for privacy preserving cross-data table analysis, the computer method comprising:
receiving, through a network from a computing device, a query message request representing a set of logical conditions requiring cross-table connections between at least two tables of a plurality of data tables associated with at least two different data sources or entities, each logical condition of the set of logical conditions representing a user characteristic, each data table of the plurality of data tables including at least a field representing unique identifiers used as a primary key for identifying a user across the plurality of data tables, a first corresponding field representing the user characteristic for each unique identifier of the unique identifiers, and a second corresponding field representing a consent field for each unique identifier of the unique identifiers;
aggregate the at least two data tables of the plurality of data tables together for the cross-table connections, wherein the aggregated at least two data tables of the plurality of data tables is not accessible external to a trusted execution environment;
in response to receiving the query message request, generate an audience list representing one or more users within the aggregated at least two data tables satisfying the set of logical conditions;
validating or comparing the query message request in accordance with or for adherence to one or more privacy policy requirements by validating or comparing the query message request against the second corresponding field representing the consent field of the one or more users in the audience list and modifying the audience list in adherence to the one or more privacy policy requirements without use of cookies on a webpage or computing device.

### Claim 12 (depends on 11)

The computer method of claim 11, wherein the set of logical conditions includes a threshold score established through a plurality of weighted logical conditions to be met, and wherein the computing device is not provided individual scores contributing to the threshold score.

### Claim 13 (depends on 11)

The computer method of claim 11, wherein the audience list data structure is maintained on the always protected database system and the computing device does not have access to the audience list data structure.

### Claim 14 (depends on 11)

The computer method of claim 11, wherein the loaded plurality of data tables is joined together in a temporal aggregate data table for processing the query message request, and the temporal aggregate data table is discarded after processing the query message request.

### Claim 15 (depends on 11)

The computer method of claim 11, wherein the query message request is communicated by the computing device along with a consent data structure representing consent tokens provided by at least one of a user or data sources corresponding to the plurality of data tables to be loaded, and wherein the validation of the query message request for adherence to one or more privacy policy requirements includes validating the consent data structure.

### Claim 16 (depends on 15)

The computer method of claim 15, wherein the consent data structure includes cryptographic keys, each corresponding to at least one of the at least one of a user or data sources corresponding to the plurality of data tables to be loaded, and each of the cryptographic keys are validated against a corresponding cryptographic key validation portion stored on or accessible by the always protected database system.

### Claim 17 (depends on 11)

The computer method of claim 11, wherein the audience list is utilized for automatic provisioning of offers or promotions and a list of users of the audience list is not otherwise accessible.

### Claim 18 (depends on 11)

The computer method of claim 11, wherein the audience list is utilized for coordinating eligibility for multiple campaigns to prevent provisioning overlapping promotions to a same user on the audience list.

### Claim 19 (depends on 17)

The computer method of claim 17, wherein the audience list is utilized for automatic eligibility for promotions based on user attributes.

### Claim 20

A non-transitory computer readable medium storing machine interpretable instruction sets, which when executed by a processor, cause the processor to perform a method for privacy preserving cross-data table analysis, the method comprising:
receiving, through a network from a computing device, a query message request representing a set of logical conditions requiring cross-table connections between at least two tables of a plurality of data tables associated with at least two different data sources or entities, each logical condition of the set of logical conditions representing a user characteristic, each data table of the plurality of data tables including at least a field representing unique identifiers used as a primary key for identifying a user across the plurality of data tables, a first corresponding field representing the user characteristic for each unique identifier of the unique identifiers, and a second corresponding field representing a consent field for each unique identifier of the unique identifiers;
aggregate the at least two data tables of the plurality of data tables together for the cross-table connections, wherein the aggregated at least two data tables of the plurality of data tables is not accessible external to a trusted execution environment;
in response to receiving the query message request, generate an audience list representing one or more users within the aggregated at least two data tables satisfying the set of logical conditions; and
validating or comparing the query message request in accordance with or for adherence to one or more privacy policy requirements by validating or comparing the query message request against the second corresponding field representing the consent field of the one or more users in the audience list and modifying the audience list in adherence to the one or more privacy policy requirements without use of cookies on a webpage or computing device.
