公开(公告)号：US10706046B2

公开(公告)日：2020-07-07

申请号：US16048055

申请日：2018-07-27

Applicant: Risk Management Solutions, Inc.

Inventor： Horst Werner ,  Christof Bornhoevd

IPC: G06F7/00 ,  G06F16/2452 ,  G06F16/23 ,  G06F16/242 ,  G06F16/2453 ,  G06F16/2457 ,  G06F16/21

Abstract: In an embodiment, a method comprises generating and storing metadata that maps a domain model to data stored in a data store, wherein the domain model describes the data and relationships between the data; receiving, from a client application, a request for data stored in the data store, wherein the request is in a first query language; translating the request into one or more queries based on the metadata, wherein the one or more queries are in a second query language; sending the one or more queries to the data store; receiving a first result set from the data store, based on the data store executing the one or more queries.

公开(公告)号：US20220300499A1

公开(公告)日：2022-09-22

申请号：US17833586

申请日：2022-06-06

Applicant: Risk Management Solutions, Inc.

Inventor： Horst Werner ,  Christof Bornhoevd

IPC: G06F16/2452 ,  G06F16/23 ,  G06F16/242 ,  G06F16/2453 ,  G06F16/2457 ,  G06F16/21

Abstract: A method of transforming requests into queries on a data store is disclosed. The method comprises receiving, by a processor, a request for data stored in a data store, the request being in a request query language based on a domain model, the request including a first part specifying a navigation path of one or more joins and one or more aggregations, the request including a second part specifying details of the one or more joins and aggregations; mapping, by the processor, entities specified in the request to a plurality of tables and a plurality of fields in the data store using metadata associated with the domain model; creating table aliases based on the plurality of tables or the one or more joins; creating field aliases based on the plurality of fields or the one or more aggregations; assembling the table aliases and the field aliases into one or more queries associated with the data store; sending the one or more queries to the data store.

公开(公告)号：US20190034482A1

公开(公告)日：2019-01-31

申请号：US16048055

申请日：2018-07-27

Applicant: Risk Management Solutions, Inc.

Inventor： Horst Werner ,  Christof Bornhoevd

IPC: G06F17/30

CPC classification number: G06F16/2452 ,  G06F16/211 ,  G06F16/2393 ,  G06F16/2433 ,  G06F16/24534 ,  G06F16/24573

Abstract: In an embodiment, a method comprises generating and storing metadata that maps a domain model to data stored in a data store, wherein the domain model describes the data and relationships between the data; receiving, from a client application, a request for data stored in the data store, wherein the request is in a first query language; translating the request into one or more queries based on the metadata, wherein the one or more queries are in a second query language; sending the one or more queries to the data store; receiving a first result set from the data store, based on the data store executing the one or more queries.

公开(公告)号：US20200293520A1

公开(公告)日：2020-09-17

申请号：US16891030

申请日：2020-06-02

Applicant: Risk Management Solutions, Inc.

Inventor： Horst Werner ,  Christof Bornhoevd

IPC: G06F16/2452 ,  G06F16/23 ,  G06F16/242 ,  G06F16/2453 ,  G06F16/2457 ,  G06F16/21

Abstract: In an embodiment, a method comprises storing metadata that maps a domain model to data stored in a plurality of data stores, each data store being associated with a particular query language, the domain model describing the data and relationships between the data. The method comprises receiving a request for data stored in a first data store of, the request being in a request query language based on the domain model. The method comprises generating an abstract syntax tree indicating a field selection, an entity path, and a condition based on the request; generating a structure model comprising one or more aggregation levels for one or more entities; and generating annotations comprising query language aliases for portions of the request and correlating the portions of the request with the metadata. The method comprises generating queries in a first query language associated with the first data store based on the annotations; and sending the queries to the first data store.

公开(公告)号：US11372855B2

公开(公告)日：2022-06-28

申请号：US16891030

申请日：2020-06-02

Applicant: Risk Management Solutions, Inc.

Inventor： Horst Werner ,  Christof Bornhoevd

IPC: G06F7/00 ,  G06F16/2452 ,  G06F16/23 ,  G06F16/242 ,  G06F16/2453 ,  G06F16/2457 ,  G06F16/21

Abstract: In an embodiment, a method comprises storing metadata that maps a domain model to data stored in a plurality of data stores, each data store being associated with a particular query language, the domain model describing the data and relationships between the data. The method comprises receiving a request for data stored in a first data store of, the request being in a request query language based on the domain model. The method comprises generating an abstract syntax tree indicating a field selection, an entity path, and a condition based on the request; generating a structure model comprising one or more aggregation levels for one or more entities; and generating annotations comprising query language aliases for portions of the request and correlating the portions of the request with the metadata. The method comprises generating queries in a first query language associated with the first data store based on the annotations; and sending the queries to the first data store.