Database with dimensional balances updating

Patent metadata

Field	Value
Publication number	US-11880844-B2
Application number	US-202217850324-A
Country	US
Kind code	B2
Filing date	Jun 27, 2022
Priority date	Jun 25, 2020
Publication date	Jan 23, 2024
Grant date	Jan 23, 2024

Abstract

In an example embodiment, a method for updating a database with dimensional balancing comprises receiving a transaction request to transfer a portion of a first balance from the first balance to a second balance; determining a subset of the first balance less than or equal to the portion in the first balance compliant with dimensional rules based on one or more attributes of the subset and an identifier of an account holding the second balance; moving the determined subset from the first balance to the second balance; and updating attributes of the moved subset in the second balance.

First claim

What is claimed is:

1. A method of updating a database with dimensional balancing, comprising:
receiving, by a payment processor from a client device, a request to transfer a portion of a first balance to a second balance in the database, the first and second balances each comprising subsets having at least one respective attribute:
determining, by the payment processor, a subset of the first balance less than or equal to the portion in the first balance compliant with dimensional rules based on the one or more attributes of the subset and an identifier of an account holding the second balance to transfer to the second balance based on the request, the dimensional rules including a matching attribute between subsets in the first and second balances; wherein the attributes include jurisdiction and pending status; wherein the determining includes determining if the subset has a pending status of available and a matching jurisdiction between the first and second balances;
optimizing, by the payment processor, the transfer based on the dimensional rules, the determined subset from the first balance to the second balance in the database; and
automatically sweeping, by the payment processor, the attributes of the determined subset from the first balance to the second balance for the determined subset.

2. The method of claim 1 , wherein the receiving the transfer request from a user is via a user interface of a publication system of the payment processor.

3. The method of claim 2 , further comprising causing display, with the user interface on a display, the first and second balances with the updated attributes after the optimized transfer.

4. The method of claim 1 , wherein the dimensional rules includes tiered attributes for priority transfer, wherein the determining is repeated before the transfer to identify a plurality of subsets compliant with the dimensional rules, and wherein the transfer transfers a determined subset from the plurality of subsets based on the tiered attributes.

5. The method of claim 1 , wherein one of the at least one respective attributes is time-dependent and the method further comprises updating, before the determining, the one of the at least one respective attributes based on a current time.

6. The method of claim 1 , wherein the attributes are orthogonal to each other.

7. The method of claim 1 , wherein the dimensional rules including priority to subset with attributes of same jurisdiction of the subset of the first balance and the second balance over compliant subset with different jurisdiction, priority to subset with attributes of same currency of the subset of the first balance and the second balance over compliant subset over different currencies; and minimization of cost for transferring between jurisdiction of the subset of the first balance to the second balance if subset are compliant.

8. A non-transitory computer-readable medium having stored thereon instructions to cause a payment processor to execute a method, the method comprising:
receiving a request to transfer a portion of a first balance to a second balance in the database, the first and second balances each comprising subsets having at least one respective attribute;
determining a subset of the first balance less than or equal to the portion in the first balance compliant with dimensional rules based on the one or more attributes of the subset and an identifier of an account holding the second balance to transfer to the second balance based on the request, the dimensional rules including a matching attribute between subsets in the first and second balances; wherein the attributes include jurisdiction and pending status; wherein the determining includes determining if the subset has a pending status of available and a matching jurisdiction between the first and second balances;
optimizing the transfer based on the dimensional rules, the determined subset from the first balance to the second balance in the database; and
automatically sweeping the attributes of the determined subset from the first balance to the second balance for the determined subset.

9. A system, comprising:
a payment processor, and
a non-transitory memory having stored thereon instructions to cause the payment processor to execute a method, the method comprising:
receiving a request to transfer a portion of a first balance to a second balance in the database, the first and second balances each comprising subsets having at least one respective attribute;
determining a subset of the first balance less than or equal to the portion in the first balance compliant with dimensional rules based on the one or more attributes of the subset and an identifier of an account holding the second balance to transfer to the second balance based on the request, the dimensional rules including a matching attribute between subsets in the first and second balances; wherein the attributes include jurisdiction and pending status; wherein the determining includes determining if the subset has a pending status of available and a matching jurisdiction between the first and second balances;
optimizing the transfer based on the dimensional rules, the determined subset from the first balance to the second balance in the database; and
automatically sweeping the attributes of the determined subset from the first balance to the second balance for the determined subset.

10. The system of claim 9 , wherein the receiving the transfer request from a user is via a user interface of a publication system of the payment processor.

11. The system of claim 10 , further comprising causing display, with the user interface on a display, the first and second balances with the updated attributes after the optimized transfer.

12. The system of claim 9 , wherein the dimensional rules include tiered attributes for priority transfer, wherein the determining is repeated before the transfer to identify a plurality of subsets compliant with the dimensional rules, and wherein the transfer transfers a determined subset from the plurality of subsets based on the tiered attributes.

13. The system of claim 9 , wherein one of the at least one respective attributes is time-dependent and the system further comprises updating, before the determining, the one of the at least one respective attributes based on a current time.

14. The system of claim 9 , wherein the attributes are orthogonal to each other.

15. The system of claim 9 , wherein the dimensional rules including priority to subset with attributes of same jurisdiction of the subset of the first balance and the second balance over compliant subset with different jurisdiction, priority to subset with attributes of same currency of the subset of the first balance and the second balance over compliant subset over different currencies; and minimization of cost for transferring between jurisdiction of the subset of the first balance to the second balance if subset are compliant.

16. The system of claim 9 , further comprising creating a new subset with attribute when the transferred subset in the second balance attribute does not have a same attribute of subset of the first balance.

Assignees

• Stripe Inc

Inventors

• Jackson Carl
• Ying Robert
• Masood Usman

Classifications

• G06Q20/405 Primary

  Establishing or using transaction specific rules · CPC title

• G06F16/2379

  Updates performed during online database operations; commit processing · CPC title

• G06F16/283

  Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP · CPC title

• G06K7/10366

  the interrogation device being adapted for miscellaneous applications · CPC title

• G06K7/1413

  1D bar codes · CPC title