Oracle AI 数据库 26ai 中的下一代事务 [LRN2904].pdf

1、Next-Gen TransactionsAjit Mylavarapu,VP,Transactions&AppDev TechnologiesSamrat Roy,Sr.Manager,Database Engineering Tirthankar Lahiri,SVP,Misson Critical Data and AI TechnologiesThe following is intended to outline our general product direction.It is intended for information purposes only,and may not

2、 be incorporated into any contract.It is not a commitment to deliver any material,code,or functionality,and should not be relied upon in making purchasing decisions.The development,release,timing,and pricing of any features or functionality described for Oracles products may change and remains at th

3、e sole discretion of Oracle Corporation.Safe Harbor Statement23Oracle is a leader in OLTP Transactions Use Caseshttps:/ CloudWorld Copyright 2024,Oracle and/or its affiliates4ScalabilityConcurrencyChange Tracking5Oracle CloudWorld Copyright 2024,Oracle and/or its affiliates.built into the Oracle Con

4、verged DatabaseOracle CloudWorld Copyright 2024,Oracle and/or its affiliates6ScalabilityConcurrencyChange TrackingLock-Free Reservations Eliminate hotspots on frequently updated data23Lock-Free Reservations:Background Hot spots are created due toMany concurrent sessions modifying small number of row

5、s Long running transactions holding locksTransactions requiring user interactionExample:Inventory for popular items in an online store8Oracle CloudWorld Copyright 2024,Oracle and/or its affiliatesApproaches to address hot spotsOptimistic approach Check for availability of QOH(Quantity on Hand)with a

6、 SELECT Check QOH and perform the actual update to QOH at transaction commit SELECT 1 FROM InventoryWHERE item_name=“Kitchen Towels”AND QOH=:required_amount;UPDATE InventorySET QOH=QOH-:required_amountWHERE item_name=“Kitchen Towels”AND QOH=:required_amount;9Oracle CloudWorld Copyright 2024,Oracle a