Using view layer in database system for zero downtime upgrade

    公开(公告)号:US12124840B2

    公开(公告)日:2024-10-22

    申请号:US17411141

    申请日:2021-08-25

    Applicant: SAP SE

    CPC classification number: G06F8/656 G06F16/213 G06F16/217

    Abstract: Methods, systems, and computer-readable storage media for providing a first access schema in a view layer of the database system, the first access schema including first database objects and projection views, each projection view corresponding to a second database object of second database objects in a data persistency, transitioning access of sessions of an application from the data persistency to the first access schema, executing at least a portion of the maintenance procedure in the database system, the at least a portion of the maintenance procedure changing one or more second database objects within the data persistency, creating a second access schema, and transitioning access of the sessions of the application from the first access schema to the second access schema, transitioning access of the sessions of the application from the second access schema to the data persistency, and removing the second access schema from the database system.

    COPY AVOIDANCE VIA STATIC ANALYSIS FOR DBMS QUERYING

    公开(公告)号:US20240273091A1

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

    申请号:US18589052

    申请日:2024-02-27

    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.

    Copy avoidance via static analysis for DBMS querying

    公开(公告)号:US11947531B1

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

    申请号:US18109781

    申请日:2023-02-14

    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.

    TUNING EXTERNAL INVOCATIONS UTILIZING WEIGHT-BASED PARAMETER RESAMPLING

    公开(公告)号:US20240078219A1

    公开(公告)日:2024-03-07

    申请号:US18510236

    申请日:2023-11-15

    Inventor: Debajyoti Roy

    CPC classification number: G06F16/215 G06F16/217 G06F16/2386 G06N20/00

    Abstract: Techniques are disclosed for tuning external invocations utilizing weight-based parameter resampling. In one example, a computer system determines a plurality of samples, each sample being associated with a parameter value of a plurality of potential parameter values of a particular parameter. The computer system assigns weights to each of the parameter values, and then selects a first sample for processing via a first external invocation based on a weight of the parameter value of the first sample. The computer system then determines feedback data associated with a level of performance of the first external invocation. The computer system adjusts the weights of the parameter values of the particular parameter based on the feedback data. The computer system then selects a second sample of the plurality of samples to be processed via execution of a second external invocation based on the adjustment of weights of the parameter values.

Patent Agency Ranking