公开(公告)号：US20210064614A1

公开(公告)日：2021-03-04

申请号：US16556815

申请日：2019-08-30

Applicant: Oracle International Corporation

Inventor： PIT FENDER ,  HARSHAD KASTURE ,  ALEXANDER ULRICH ,  BENJAMIN SCHLEGEL ,  MATTHIAS BRANTNER ,  HASSAN CHAFI

IPC: G06F16/242 ,  G06F16/25 ,  G06F9/455

Abstract: Herein are techniques that extend a software system to embed new guest programing languages (GPLs) that interoperate in a transparent, modular, and configurable way. In embodiments, a computer inserts an implementation of a GPL into a deployment of the system. A command registers the GPL, define subroutines for the GPL, generates a guest virtual environment, and adds a binding of a dependency to a guest module. In an embodiment, a native programing language invokes a guest programing language to cause importing intra- or inter-language dependencies. An embodiment defines a guest object that is implemented in a first GPL and accessed from a second GPL. In an embodiment, dependencies are retrieved from a virtual file system having several alternative implementation mechanisms that include: an archive file or an actual file system, and a memory buffer or a column of a database table.

公开(公告)号：US20210064619A1

公开(公告)日：2021-03-04

申请号：US16555974

申请日：2019-08-29

Applicant: Oracle International Corporation

Inventor： PIT FENDER ,  ALEXANDER ULRICH ,  LAURENT DAYNES ,  MATTHIAS BRANTNER ,  BASTIAN HOSSBACH ,  BENJAMIN SCHLEGEL ,  HASSAN CHAFI

IPC: G06F16/2453 ,  G06F16/2455 ,  G06F8/41

Abstract: The present invention relates to execution optimization of database queries. Herein are techniques for optimal execution based on query interpretation by translation to a domain specific language (DSL), with optimizations such as partial evaluation, abstract syntax tree (AST) rewriting, just in time (JIT) compilation, dynamic profiling, speculative logic, and Futamura projection. In an embodiment, a database management system (DBMS) that is hosted on a computer generates a query tree that represents a database query that contains an expression that is represented by a subtree of the query tree. The DBMS generates a sequence of DSL instructions that represents the subtree. The sequence of DSL instructions is executed to evaluate the expression during execution of the database query. In an embodiment, an AST is generated from the sequence of DSL instructions. In an embodiment, the DSL AST is optimally rewritten based on a runtime feedback loop that includes dynamic profiling information.

公开(公告)号：US20210064613A1

公开(公告)日：2021-03-04

申请号：US16556760

申请日：2019-08-30

Applicant: Oracle International Corporation

Inventor： PIT FENDER ,  HARSHAD KASTURE ,  ALEXANDER ULRICH ,  BENJAMIN SCHLEGEL ,  MATTHIAS BRANTNER ,  HASSAN CHAFI

IPC: G06F16/242 ,  G06F8/30 ,  G06F16/25

Abstract: Herein are techniques that extend a software system to embed new guest programing languages (GPLs) that interoperate in a transparent, modular, and configurable way. In embodiments, a computer inserts an implementation of a GPL into a deployment of the system. A command registers the GPL, define subroutines for the GPL, generates a guest virtual environment, and adds a binding of a dependency to a guest module. In an embodiment, a native programing language invokes a guest programing language to cause importing intra- or inter-language dependencies. An embodiment defines a guest object that is implemented in a first GPL and accessed from a second GPL. In an embodiment, dependencies are retrieved from a virtual file system having several alternative implementation mechanisms that include: an archive file or an actual file system, and a memory buffer or a column of a database table.

公开(公告)号：US20210064588A1

公开(公告)日：2021-03-04

申请号：US16556847

申请日：2019-08-30

Applicant: Oracle International Corporation

Inventor： PIT FENDER ,  HARSHAD KASTURE ,  ALEXANDER ULRICH ,  BENJAMIN SCHLEGEL ,  MATTHIAS BRANTNER ,  HASSAN CHAFI

IPC: G06F16/21

Abstract: Herein are techniques that extend a software system to embed new guest programing languages (GPLs) that interoperate in a transparent, modular, and configurable way. In embodiments, a computer inserts an implementation of a GPL into a deployment of the system. A command registers the GPL, define subroutines for the GPL, generates a guest virtual environment, and adds a binding of a dependency to a guest module. In an embodiment, a native programing language invokes a guest programing language to cause importing intra- or inter-language dependencies. An embodiment defines a guest object that is implemented in a first GPL and accessed from a second GPL. In an embodiment, dependencies are retrieved from a virtual file system having several alternative implementation mechanisms that include: an archive file or an actual file system, and a memory buffer or a column of a database table.

公开(公告)号：US20190065552A1

公开(公告)日：2019-02-28

申请号：US16117367

申请日：2018-08-30

Applicant: Oracle International Corporation

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

IPC: G06F17/30

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.