Invention Grant
- Patent Title: PL/SQL language parsing at a virtual machine
-
Application No.: US15883803Application Date: 2018-01-30
-
Publication No.: US10353723B2Publication Date: 2019-07-16
- Inventor: Raghavendran Hanumantharau , Yoram Tal
- Applicant: salesforce.com, inc.
- Applicant Address: US CA San Francisco
- Assignee: salesforce.com, inc.
- Current Assignee: salesforce.com, inc.
- Current Assignee Address: US CA San Francisco
- Agency: Holland & Hart LLP
- Main IPC: G06F9/455
- IPC: G06F9/455 ; G06F16/242

Abstract:
In some database systems, a user device may query for data records using a procedural language extension to structured query language (PL/SQL) call. However, some databases may not be configured to process PL/SQL code. In these cases, a virtual machine may intercept the PL/SQL call, and may transform the call to a format usable by the database. For example, the virtual machine may deconstruct the PL/SQL call to determine the procedural and query functions that comprise the PL/SQL call. The virtual machine may then search a database for non-PL/SQL code snippets that correspond to these determined functions, and may generate non-PL/SQL code (e.g., Java code) that may perform the same functions as the PL/SQL call. The virtual machine, the database, or a combination of the two may execute the non-PL/SQL code to retrieve the data records from the database, and may return the records to the user device.
Public/Granted literature
- US20190042288A1 PL/SQL LANGUAGE PARSING AT A VIRTUAL MACHINE Public/Granted day:2019-02-07
Information query