DATABASE RACE CONDITION PREVENTION

    公开(公告)号:US20230114105A1

    公开(公告)日:2023-04-13

    申请号:US17489062

    申请日:2021-09-29

    Applicant: Stripe, Inc.

    Abstract: A method comprises: setting an first entry and an second entry in a database; receiving a first online transaction; responsive to determining a lock of the database is in progress, suspending the first online transaction; updating the first entry; removing the lock; receiving a second online transaction; responsive to determining that the first field is greater than zero, decrementing the first field by an amount indicated in the second online transaction; and responsive to determining the second entry is greater than zero, decrementing the second entry.

    DATABASE LOCKNG MECHANISM
    2.
    发明申请

    公开(公告)号:US20230098748A1

    公开(公告)日:2023-03-30

    申请号:US17590206

    申请日:2022-02-01

    Applicant: Stripe, Inc.

    Abstract: A method for preventing race conditions in a database comprises: setting a first numerical entry and a second numerical entry in a database; receiving a first online transaction; responsive to determining a lock of the database is in progress due to a second received online transaction, suspending the first online transaction; removing the lock after the second received online transaction is completed; responsive to determining that the first entry is greater than zero, decrementing the first entry by an amount indicated in the first online transaction; responsive to determining the second entry is greater than zero, decrementing the second entry; processing the first transaction; and generating an online transaction record for the first transaction and storing the generated record in an online transaction database.

    Database locking mechanism
    3.
    发明授权

    公开(公告)号:US12204953B2

    公开(公告)日:2025-01-21

    申请号:US17590206

    申请日:2022-02-01

    Applicant: Stripe, Inc.

    Abstract: A method for preventing race conditions in a database comprises: setting a first numerical entry and a second numerical entry in a database; receiving a first online transaction; responsive to determining a lock of the database is in progress due to a second received online transaction, suspending the first online transaction; removing the lock after the second received online transaction is completed; responsive to determining that the first entry is greater than zero, decrementing the first entry by an amount indicated in the first online transaction; responsive to determining the second entry is greater than zero, decrementing the second entry; processing the first transaction; and generating an online transaction record for the first transaction and storing the generated record in an online transaction database.

    Database race condition prevention

    公开(公告)号:US12111822B2

    公开(公告)日:2024-10-08

    申请号:US17489062

    申请日:2021-09-29

    Applicant: Stripe, Inc.

    CPC classification number: G06F16/2379 G06F16/2343 G06Q10/087

    Abstract: A method comprises: setting an first entry and an second entry in a database; receiving a first online transaction; responsive to determining a lock of the database is in progress, suspending the first online transaction; updating the first entry; removing the lock; receiving a second online transaction; responsive to determining that the first field is greater than zero, decrementing the first field by an amount indicated in the second online transaction; and responsive to determining the second entry is greater than zero, decrementing the second entry.

Patent Agency Ranking