公开(公告)号：US20240289306A1

公开(公告)日：2024-08-29

申请号：US18113707

申请日：2023-02-24

Applicant: Oracle International Corporation

Inventor： Altin Alickaj ,  Alexander Ulrich ,  Eric Sedlar

IPC: G06F16/21 ,  G06F16/22 ,  G06F16/23 ,  G06F16/245 ,  G06F16/28

CPC classification number: G06F16/212 ,  G06F16/2282 ,  G06F16/2379 ,  G06F16/245 ,  G06F16/284

Abstract: Herein, a guest language is a programing language that is not the native data access language (e.g. structured query language, SQL) of a database server. When instantiated in the database server, a guest language runtime environment provides any mechanisms needed to execute the guest language. In an embodiment contained entirely within the database server, multiple guest language runtime environments for same or different guest languages use respective database sessions to share a key-value store in RAM that stores rows from a persistent relational table. Consumption of computer resources such as time and memory space is decreased because the persistent relational table's operation by the key-value store does not generate a database statement, does not parse a database statement, does not query plan, and does not execute a database statement.

公开(公告)号：US12216649B2

公开(公告)日：2025-02-04

申请号：US18589052

申请日：2024-02-27

Applicant: Oracle International Corporation

Inventor： Altin Alickaj ,  Alexander Ulrich ,  Lukas Stadler

IPC: G06F16/22 ,  G06F16/21 ,  G06F16/242

Abstract: In a computer embodiment, in a polyglot database management system (DBMS) that contains a guest language runtime environment, a database buffer is configured that the guest language runtime environment does not manage. In the polyglot DBMS, logic that is defined in a guest language is invoked to retrieve, into the database buffer, a value stored in a database in the polyglot DBMS. Compiling the logic causes semantic analyzing the logic to detect that usage of the retrieved value cannot occur after the retrieved value is overwritten in the database buffer. When detecting that such usage of the retrieved value cannot occur, the logic is executed without, after the retrieved value is overwritten in the database buffer, retaining a copy of the retrieved value in a memory region that the guest language runtime environment manages.

公开(公告)号：US20250147741A1

公开(公告)日：2025-05-08

申请号：US18630432

申请日：2024-04-09

Applicant: Oracle International Corporation

Inventor： Aaron Tacke ,  Altin Alickaj ,  Giacomo Fabris ,  Alexander Ulrich

IPC: G06F8/41 ,  G06F40/14

Abstract: The present disclosure relates to improving the performance of evaluating path expressions on hierarchical data objects represented by binary encoded documents. An abstract syntax tree (AST) representing a path expression may be generated, wherein the AST comprises one or more syntax nodes implementing one or more respective execution steps of an evaluation of the path expression, and the path expression is included in a query to a database management system (DBMS). The AST may be modified based at least in part on profiling information and compiled into machine code. Using the machine code, the path expression may be executed on a binary-encoded hierarchical document.

公开(公告)号：US20240273091A1

公开(公告)日：2024-08-15

申请号：US18589052

申请日：2024-02-27

Applicant: Oracle International Corporation

Inventor： Altin Alickaj ,  Alexander Ulrich ,  Lukas Stadler

IPC: G06F16/242 ,  G06F16/21 ,  G06F16/22

CPC classification number: G06F16/2443 ,  G06F16/217 ,  G06F16/2219

Abstract: In a computer embodiment, in a polyglot database management system (DBMS) that contains a guest language runtime environment, a database buffer is configured that the guest language runtime environment does not manage. In the polyglot DBMS, logic that is defined in a guest language is invoked to retrieve, into the database buffer, a value stored in a database in the polyglot DBMS. Compiling the logic causes semantic analyzing the logic to detect that usage of the retrieved value cannot occur after the retrieved value is overwritten in the database buffer. When detecting that such usage of the retrieved value cannot occur, the logic is executed without, after the retrieved value is overwritten in the database buffer, retaining a copy of the retrieved value in a memory region that the guest language runtime environment manages.

公开(公告)号：US11947531B1

公开(公告)日：2024-04-02

申请号：US18109781

申请日：2023-02-14

Applicant: Oracle International Corporation

Inventor： Altin Alickaj ,  Alexander Ulrich ,  Lukas Stadler

IPC: G06F16/22 ,  G06F16/21 ,  G06F16/242

CPC classification number: G06F16/2443 ,  G06F16/217 ,  G06F16/2219

Abstract: In a computer embodiment, in a polyglot database management system (DBMS) that contains a guest language runtime environment, a database buffer is configured that the guest language runtime environment does not manage. In the polyglot DBMS, logic that is defined in a guest language is invoked to retrieve, into the database buffer, a value stored in a database in the polyglot DBMS. Compiling the logic causes semantic analyzing the logic to detect that usage of the retrieved value cannot occur after the retrieved value is overwritten in the database buffer. When detecting that such usage of the retrieved value cannot occur, the logic is executed without, after the retrieved value is overwritten in the database buffer, retaining a copy of the retrieved value in a memory region that the guest language runtime environment manages.