Invention Grant
US07769789B2 High performant row-level data manipulation using a data layer interface
有权
使用数据层接口执行高性能行级数据操作
- Patent Title: High performant row-level data manipulation using a data layer interface
- Patent Title (中): 使用数据层接口执行高性能行级数据操作
-
Application No.: US11801930Application Date: 2007-05-11
-
Publication No.: US07769789B2Publication Date: 2010-08-03
- Inventor: Thuvan Hoang , Anthony Giardullo , Amit Ganesh , Nimar S. Arora , Dheeraj Pandey , Lik Wong
- Applicant: Thuvan Hoang , Anthony Giardullo , Amit Ganesh , Nimar S. Arora , Dheeraj Pandey , Lik Wong
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Truong & Becker LLP
- Agent Deborah L. Caswell
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
Performing an operation directly on data stored in a database table provides for avoiding generation and processing of SQL statements. A Data Layer interface, comprising a set of APIs, allows internal database server components to call directly to the Data Layer for making fast row changes to a table. According to an embodiment, before making any row change to a table through this Data Layer interface, a shared state data structure is created to hold the metadata about the table. A single shared state can be used for all DML changes to a particular table regardless of what columns are updated or inserted during each DML operation. When a process needs to change a row, the process uses a mutable state based on the shared state of the table.
Public/Granted literature
- US20080281846A1 High performant row-level data manipulation using a data layer interface Public/Granted day:2008-11-13
Information query