Invention Grant
- Patent Title: Deployment of javascript and typescript stored procedures and user-defined functions into database management systems
-
Application No.: US16117367Application Date: 2018-08-30
-
Publication No.: US11360976B2Publication Date: 2022-06-14
- Inventor: Matthias Brantner , Laurent Daynes , Pit Fender , Benjamin Schlegel , Anantha Kiran Kandukuri , Hassan Chafi , Eric Sedlar , Juergen Christ , Lucas Braun , Bastian Hossbach , Alexander Ulrich , Harshad Kasture
- 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: Hickman Becker Bingham Ledesma LLP
- Agent Brian N. Miller
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/2455

Abstract:
Herein are computerized techniques for deploying JavaScript and TypeScript stored procedures and user-defined functions into a database management system (DBMS). In an embodiment, a computer generates a SQL call specification for each subroutine of one or more subroutines encoded in a scripting language. The generating is based on a signature declaration of the subroutine. Each subroutine comprises a definition of a stored procedure or a user-defined function. The computer packages the definition and the SQL call specification of each subroutine into a single bundle file. The definition and the SQL call specification of each subroutine are deployed into a DBMS from the single bundle file. Eventually, the SQL call specification of at least one subroutine is invoked to execute the definition of the subroutine in the DBMS.
Public/Granted literature
Information query