Invention Grant
- Patent Title: Implementing a multi-column/multi-row constraint in a relational database table
- Patent Title (中): 在关系数据库表中实现多列/多行约束
-
Application No.: US13782964Application Date: 2013-03-01
-
Publication No.: US09384228B2Publication Date: 2016-07-05
- Inventor: Zhihai Zhang , Qingyun Xie , Siva Ravada
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Vista IP Law Group, LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00 ; G06F17/30

Abstract:
A method, system, and computer program product for implementing a multi-column/multi-row constraint. Lock techniques prevent access collisions even when two or more concurrently running software applications are attempting to insert rows into the same relational database table (subject to the same multi-column/multi-row constraints). The method commences by receiving (e.g., from a first process) a first row to be inserted into a relational database table where the row comprises at least two constrained columns corresponding to the multi-column/multi-row constraint, then receiving (e.g., from a second process) a second row to be inserted into the same table. Using column locks, the method recognizes the potential for conflicting row insertions, and manages locks to prevent conflicting access grants to the two constrained columns of the existing database table. The evaluation of the multi-column/multi-row constraint is performed over the first row to be inserted and a row or rows of the relational database table.
Public/Granted literature
- US20140250060A1 IMPLEMENTING A MULTI-COLUMN/MULTI-ROW CONSTRAINT IN A RELATIONAL DATABASE TABLE Public/Granted day:2014-09-04
Information query