The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Aug. 03, 2010
Filed:
May. 11, 2007
Thuvan Hoang, Santa Clara, CA (US);
Anthony Giardullo, San Mateo, CA (US);
Amit Ganesh, San Jose, CA (US);
Nimar S. Arora, Union City, CA (US);
Dheeraj Pandey, Santa Clara, CA (US);
Lik Wong, Union City, CA (US);
Thuvan Hoang, Santa Clara, CA (US);
Anthony Giardullo, San Mateo, CA (US);
Amit Ganesh, San Jose, CA (US);
Nimar S. Arora, Union City, CA (US);
Dheeraj Pandey, Santa Clara, CA (US);
Lik Wong, Union City, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
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.