中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

13 records (took 0.03 seconds)

    REMOTE DATASOURCE-BASED OPTIMIZATION OF PROCEDURE-BASED MULTI-DATASOURCE QUERIES
    1.
    发明申请
    REMOTE DATASOURCE-BASED OPTIMIZATION OF PROCEDURE-BASED MULTI-DATASOURCE QUERIES 有权

    公开(公告)号：US20230100587A1

    公开(公告)日：2023-03-30

    申请号：US17483976

    申请日：2021-09-24

    Applicant: International Business Machines Corporation

    Inventor： Hai Jun Shen ,  Chang Sheng Liu ,  Lei Cui ,  Ya Qiong Liu

    IPC: G06F16/2453

    Abstract: An approach is provided for optimizing multi-datasource queries in a networked computing environment. A procedure that contains a set of queries designed to access a specific set of data from a plurality of datasources in a virtualized hybrid storage environment (e.g., a virtualized hybrid cloud) is obtained. A set of mapped store procedures is created for the set of datasources referenced in the procedure. Each mapped store procedure includes a subset of queries that are applicable to a corresponding datasource from the set of queries in the procedure. These mapped store procedures are forwarded to the corresponding datasource for storage on the corresponding datasource. In response to a running of the procedure, execution of the mapped store procedure is commenced on each of the corresponding datasources on which they are stored.

    Reducing character set conversion
    3.
    发明授权
    Reducing character set conversion 有权

    公开(公告)号：US11797561B2

    公开(公告)日：2023-10-24

    申请号：US17173342

    申请日：2021-02-11

    Applicant: International Business Machines Corporation

    Inventor： Hai Jun Shen ,  Chang Sheng Liu ,  Ya Qiong Liu ,  Jun Hui Liu

    IPC: G06F16/25 ,  G06F40/126

    CPC classification number: G06F16/258 ,  G06F16/252 ,  G06F16/256 ,  G06F40/126

    Abstract: A computer-implemented method reduces the number of character set conversions in a distributed data virtualization system. The method includes receiving, from a first application, a first request for a set of data, including a requested codepage, stored in a first data source of a plurality of data sources. The method includes obtaining, by a connector, from the first data source, a first codepage associated with the first data source, which identifies a character set associated with the set of data. The method also includes adding a virtual coded character set identifier (VCCSID) in a first catalog entry of a catalog, wherein the first VCCSID is added to a nickname column of the catalog. The method includes obtaining and sending the set of data to the data application while allowing maximum of one codepage conversion.

    REDUCING CHARACTER SET CONVERSION
    4.
    发明申请
    REDUCING CHARACTER SET CONVERSION 有权

    公开(公告)号：US20220253455A1

    公开(公告)日：2022-08-11

    申请号：US17173342

    申请日：2021-02-11

    Applicant: International Business Machines Corporation

    Inventor： Hai Jun Shen ,  Chang Sheng Liu ,  Ya Qiong Liu ,  Jun Hui Liu

    IPC: G06F16/25 ,  G06F40/126

    Abstract: A computer-implemented method reduces the number of character set conversions in a distributed data virtualization system. The method includes receiving, from a first application, a first request for a set of data, including a requested codepage, stored in a first data source of a plurality of data sources. The method includes obtaining, by a connector, from the first data source, a first codepage associated with the first data source, which identifies a character set associated with the set of data. The method also includes adding a virtual coded character set identifier (VCCSID) in a first catalog entry of a catalog, wherein the first VCCSID is added to a nickname column of the catalog. The method includes obtaining and sending the set of data to the data application while allowing maximum of one codepage conversion.

    Remote datasource-based optimization of procedure-based multi-datasource queries
    6.
    发明授权
    Remote datasource-based optimization of procedure-based multi-datasource queries 有权

    公开(公告)号：US12222942B2

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

    申请号：US17483976

    申请日：2021-09-24

    Applicant: International Business Machines Corporation

    Inventor： Hai Jun Shen ,  Chang Sheng Liu ,  Lei Cui ,  Ya Qiong Liu

    IPC: G06F16/2453

    Abstract: An approach is provided for optimizing multi-datasource queries in a networked computing environment. A procedure that contains a set of queries designed to access a specific set of data from a plurality of datasources in a virtualized hybrid storage environment (e.g., a virtualized hybrid cloud) is obtained. A set of mapped store procedures is created for the set of datasources referenced in the procedure. Each mapped store procedure includes a subset of queries that are applicable to a corresponding datasource from the set of queries in the procedure. These mapped store procedures are forwarded to the corresponding datasource for storage on the corresponding datasource. In response to a running of the procedure, execution of the mapped store procedure is commenced on each of the corresponding datasources on which they are stored.

    JOINING REMOTE TABLES BY A FEDERATED SERVER
    8.
    发明申请
    JOINING REMOTE TABLES BY A FEDERATED SERVER 有权

    公开(公告)号：US20220253440A1

    公开(公告)日：2022-08-11

    申请号：US17172704

    申请日：2021-02-10

    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

    Inventor： Chang Sheng Liu ,  Ya Qiong Liu ,  Lei Cui

    IPC: G06F16/2455 ,  G06F16/2453 ,  G06F16/242 ,  G06F16/25 ,  G06F16/248 ,  G06F11/34

    Abstract: A system and method of joining remote tables by a federated server is provided. A method includes receiving a data join request from a client device; sending a first block fetch request to a first data source based on the data join request; receiving a first set of block data from the first data source; sending a second block fetch request to a second data source based on the data join request and a bind array containing the data of join column in the first data source; receiving a second set of block data from the second data source; and sending an output to the client device in response to the data join request in the form of rows from an outer table and an inner table.

    Complex query optimization
    9.
    发明授权
    Complex query optimization 有权

    公开(公告)号：US11243961B2

    公开(公告)日：2022-02-08

    申请号：US16693681

    申请日：2019-11-25

    Applicant: International Business Machines Corporation

    Inventor： Ya Qiong Liu ,  Xue Huang ,  Ping Liu ,  Lei Cui ,  Ying Qi Pan

    IPC: G06F16/24 ,  G06F16/2458 ,  G06F9/54 ,  G06F9/30 ,  G06F16/248

    Abstract: Disclosed is a computer implemented method and related system to improve the efficiency of querying remote databases. The method includes receiving, from a host, a query, wherein the query is configured to retrieve a set of data from a remote database. The method also includes, generating an access plan, the access plan comprising a plurality of nodes wherein each node of the plurality of nodes includes a command. The method further includes determining capabilities of the remote database. The method includes executing the query and returning the set of data to the host.

Patent Agency Ranking