公开(公告)号：US20230376623A1

公开(公告)日：2023-11-23

申请号：US17747115

申请日：2022-05-18

Applicant: SAP SE

Inventor： Sen Zhang ,  De-Li Xu ,  Zhi-peng Dong ,  Jixiang Xv ,  Sheng Cheng ,  Ruiming Dang

IPC: G06F21/62 ,  G06F16/28 ,  G06F16/21 ,  G06F12/14

CPC classification number: G06F21/6227 ,  G06F16/284 ,  G06F16/21 ,  G06F12/1491

Abstract: Methods, systems, and computer-readable storage media for receiving a query request including authorization data and a query, the authorization data indicating a privilege level index, determining a set of row ranges based on the privilege level index and a row range table, the set of row ranges including one or more row ranges having a privilege level associated therewith in the row range table, providing an initial results set including one or more records of a data table that are determined to be responsive, determining a final results set including at least one record of the initial results set, the at least one record being included in the final results set in response to determining that the at least one record is included in a row range of the set of row ranges, and outputting the final results set as at least a portion of a query result.

公开(公告)号：US10545984B2

公开(公告)日：2020-01-28

申请号：US15602373

申请日：2017-05-23

Applicant: SAP SE

Inventor： Sen Zhang ,  Yinghua Ouyang ,  Jian Wang ,  Zhen Tian

IPC: G06F17/30 ,  G06F16/25 ,  G06F16/22 ,  G06F16/21 ,  G06F16/23

Abstract: Methods, systems, and computer-readable storage media for providing a table in a database system, the table including a column having a column data type set to an abstract data type, receiving a first data record to be added to the table, the first data record including a first data value to be included in the column, determining a first data type corresponding to a data type of the first data value, changing the column data type from the abstract data type to the first data type, receiving a second data record to be added to the table, the second data record including a second data value to be including in the column, determining a second data type corresponding to the data type of the second data value, and selectively changing the column data type to the second data type.

公开(公告)号：US12013961B2

公开(公告)日：2024-06-18

申请号：US17747115

申请日：2022-05-18

Applicant: SAP SE

Inventor： Sen Zhang ,  De-Li Xu ,  Zhi-Peng Dong ,  Jixiang Xv ,  Sheng Cheng ,  Ruiming Dang

IPC: G06F17/30 ,  G06F12/14 ,  G06F16/21 ,  G06F16/28 ,  G06F21/62

CPC classification number: G06F21/6227 ,  G06F12/1491 ,  G06F16/21 ,  G06F16/284

Abstract: Methods, systems, and computer-readable storage media for receiving a query request including authorization data and a query, the authorization data indicating a privilege level index, determining a set of row ranges based on the privilege level index and a row range table, the set of row ranges including one or more row ranges having a privilege level associated therewith in the row range table, providing an initial results set including one or more records of a data table that are determined to be responsive, determining a final results set including at least one record of the initial results set, the at least one record being included in the final results set in response to determining that the at least one record is included in a row range of the set of row ranges, and outputting the final results set as at least a portion of a query result.

公开(公告)号：US20180341689A1

公开(公告)日：2018-11-29

申请号：US15602373

申请日：2017-05-23

Applicant: SAP SE

Inventor： Sen Zhang ,  Yinghua Ouyang ,  Jian Wang ,  Zhen Tian

IPC: G06F17/30

CPC classification number: G06F16/258 ,  G06F16/214 ,  G06F16/221 ,  G06F16/235 ,  G06F16/2393

Abstract: Methods, systems, and computer-readable storage media for providing a table in a database system, the table including a column having a column data type set to an abstract data type, receiving a first data record to be added to the table, the first data record including a first data value to be included in the column, determining a first data type corresponding to a data type of the first data value, changing the column data type from the abstract data type to the first data type, receiving a second data record to be added to the table, the second data record including a second data value to be including in the column, determining a second data type corresponding to the data type of the second data value, and selectively changing the column data type to the second data type.