Back to results
US 11,693,912 B2Granted
Adapting database queries for data virtualization over combined database stores
AssigneeAveva Software, LLC
InventorsJiping Zhu, Benjamin James Graham
Life of this patent
Estimating the term…
Abstract
Adapting database queries from a common interface into conditions specific to database storage formats, optimization of a data model, and virtualization of query results from combined databases.
Claims17
A system comprising:
- a first computing device,
- comprising:
- an interface
- processor, and
- a first non-transitory memory device communicatively coupled to the interface processor, the first non-transitory memory device storing processor readable instructions thereon that, when executed by the interface processor, provide:
- a query-based programmatic interface configured to receive database queries, and
- a proxy configured to validate the received database queries and produce entity query criteria from the validated received database queries;
- a communications network;
- and
- a second computing device communicatively coupled to the first computing device via the communications network, the second computing device comprising:
- a query processor, and
- a second non-transitory memory device communicatively coupled to the query processor, the second non-transitory memory device storing processor readable instructions thereon that, when executed by the query processor, provide an entity query source configured to adapt the entity query criteria into one or more conditions of a plurality of data sources such that the plurality of data sources filter and sort data stored therein to determine query results satisfying the database queries and return the query results for display via the query-based programmatic interface;
- wherein the entity query criteria comprise at least two of:
- a referenced fields parameter indicating fields required for fulfilling the database queries;
- a filter predicate parameter operating on an entity and returning whether the entity satisfies a filter condition;
- a sort definitions parameter indicating a sort order;
- a selected field parameter indicating a field to select;
- and
- a skip and take parameter indicating how many entities to skip and how many entities to take.
16 more elements
A computer-implemented method for querying data across combined data stores comprising:
- receiving a database query via a query-based programmatic interface;
- validating, by a parser, the received query;
- producing, by the parser, entity query criteria from the validated query;
- adapting, by an entity query source, the entity query criteria into conditions of a proprietary database format such that a database of the proprietary database format filters and sorts data stored therein to determine query results satisfying the database query;
- and
- displaying the query results via the query-based programmatic interface;
- wherein the entity query criteria comprise at least two of:
- a referenced fields parameter indicating fields required for fulfilling the database queries;
- a filter predicate parameter operating on an entity and returning whether the entity satisfies a filter condition;
- a sort definitions parameter indicating a sort order;
- a selected field parameter indicating a field to select;
- and
- a skip and take parameter indicating how many entities to skip and how many entities to take.
10 more elements
A non-transitory computer readable storage device having processor readable instructions stored thereon including instructions that, when executed by a processor, provide a database query platform, comprising:
- a query-based programmatic interface configured to receive database queries;
- a parser configured to validate the received database queries and produce entity query criteria from the validated received database queries;
- an executor configured to receive the entity query criteria from the parser and invoke one or more corresponding methods in an entity query source;
- and
- the entity query source, wherein the entity query source is configured to perform the one or more corresponding methods to adapt the entity query criteria into one or more conditions of a plurality of data sources such that the plurality of data sources filter and sort data stored therein to determine query results satisfying the received database queries represented by the entity query criteria and return the query results for display via the query-based programmatic interface;
- wherein the entity query criteria comprise at least two of:
- a referenced fields parameter indicating fields required for fulfilling the database queries;
- a filter predicate parameter operating on an entity and returning whether the entity satisfies a filter condition;
- a sort definitions parameter indicating a sort order;
- a selected field parameter indicating a field to select;
- and
- a skip and take parameter indicating how many entities to skip and how many entities to take.
9 more elements
Dependencies are inferred from the claim text.