公开(公告)号：US11514119B2

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

申请号：US16864816

申请日：2020-05-01

Applicant: SAP SE

Inventor： Anubhav Bhatia ,  Martin Weiss ,  Oliver Mainka ,  Ankit Shivhare ,  Rajarshi Ghosh ,  Lauren McMullen

IPC: G06F16/9535 ,  G06F16/9538 ,  G06F16/901 ,  G06F16/2453 ,  G06F16/242

Abstract: A global filter allows data filtering using attributes across multiple Analysis Tools (ATs), by broadcasting semantic filter context objects. Upon selecting object attribute values, the filter context object is created with attribute names and values. A processing engine resolves the filter context object to a data object, and then subsequently to target data. A lateral filter finds related entities in a relational database, without having to maintain and/or duplicate all of the data into a graph database. The processing engine resolves lateral filters using an entity graph path calculation conducted in conjunction with the generation of a bootstrapped graph structure. That graph structure is constructed (bootstrapped) utilizing available database schematic information—e.g., pre-calculated (key) relations and metadata read from the relational database. From that information, relationships in the bootstrapped graph structure are determined. Possible paths between entities are used to generate an optimized SQL query to reach target data.

公开(公告)号：US11461349B2

公开(公告)日：2022-10-04

申请号：US16864785

申请日：2020-05-01

Applicant: SAP SE

Inventor： Anubhav Bhatia ,  Martin Weiss ,  Oliver Mainka ,  Ankit Shivhare ,  Rajarshi Ghosh ,  Lauren McMullen

IPC: G06F16/21 ,  G06F16/248 ,  G06F16/28 ,  G06F16/901

Abstract: A global filter allows data filtering using attributes across multiple Analysis Tools (ATs), by broadcasting semantic filter context objects. Upon selecting object attribute values, the filter context object is created with attribute names and values. A processing engine resolves the filter context object to a data object, and then subsequently to target data. A lateral filter finds related entities in a relational database, without having to maintain and/or duplicate all of the data into a graph database. The processing engine resolves lateral filters using an entity graph path calculation conducted in conjunction with the generation of a bootstrapped graph structure. That graph structure is constructed (bootstrapped) utilizing available database schematic information—e.g., pre-calculated (key) relations and metadata read from the relational database. From that information, relationships in the bootstrapped graph structure are determined. Possible paths between entities are used to generate an optimized SQL query to reach target data.

公开(公告)号：US20210342409A1

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

申请号：US16864816

申请日：2020-05-01

Applicant: SAP SE

Inventor： Anubhav Bhatia ,  Martin Weiss ,  Oliver Mainka ,  Ankit Shivhare ,  Rajarshi Ghosh ,  Lauren McMullen

IPC: G06F16/9535 ,  G06F16/901 ,  G06F16/9538

Abstract: A global filter allows data filtering using attributes across multiple Analysis Tools (ATs), by broadcasting semantic filter context objects. Upon selecting object attribute values, the filter context object is created with attribute names and values. A processing engine resolves the filter context object to a data object, and then subsequently to target data. A lateral filter finds related entities in a relational database, without having to maintain and/or duplicate all of the data into a graph database. The processing engine resolves lateral filters using an entity graph path calculation conducted in conjunction with the generation of a bootstrapped graph structure. That graph structure is constructed (bootstrapped) utilizing available database schematic information—e.g., pre-calculated (key) relations and metadata read from the relational database. From that information, relationships in the bootstrapped graph structure are determined. Possible paths between entities are used to generate an optimized SQL query to reach target data.

公开(公告)号：US20210342336A1

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

申请号：US16864785

申请日：2020-05-01

Applicant: SAP SE

Inventor： Anubhav Bhatia ,  Martin Weiss ,  Oliver Mainka ,  Ankit Shivhare ,  Rajarshi Ghosh ,  Lauren McMullen

IPC: G06F16/248 ,  G06F16/21 ,  G06F16/901 ,  G06F16/28

Abstract: A global filter allows data filtering using attributes across multiple Analysis Tools (ATs), by broadcasting semantic filter context objects. Upon selecting object attribute values, the filter context object is created with attribute names and values. A processing engine resolves the filter context object to a data object, and then subsequently to target data. A lateral filter finds related entities in a relational database, without having to maintain and/or duplicate all of the data into a graph database. The processing engine resolves lateral filters using an entity graph path calculation conducted in conjunction with the generation of a bootstrapped graph structure. That graph structure is constructed (bootstrapped) utilizing available database schematic information—e.g., pre-calculated (key) relations and metadata read from the relational database. From that information, relationships in the bootstrapped graph structure are determined. Possible paths between entities are used to generate an optimized SQL query to reach target data.