Method and apparatus to generate a simplified query when searching for catalog items
AssigneeSap SE
InventorsHarish Kumar Sampangi Rama, Anand Jain
Life of this patent
Estimating the term…
Abstract
Systems and methods are provided for generating a simplified catalog search query from a set of catalog access rules applicable to catalog user groups associated with a catalog user. For example, accessible sources are identified from the access rules. The accessible sources do not include sources that would lead to contradictory and/or useless search query phrases. Based on the accessible sources and the set of catalog access rules, a simplified search query is generated and run against a database of catalog items.
Claims20
A computer-implemented method comprising:
- receiving a catalog search comprising search criteria and a catalog user identifier for which the catalog search is to be performed, wherein the catalog user identifier is associated with one or more catalog user group identifiers;
- identifying, based on a plurality of access rules and the catalog search, a set of accessible source identifiers, wherein the plurality of access rules comprises positive and negative rule conditions and wherein aggregation of the positive and negative rule conditions represents a full access query;
- building, based on the positive rule conditions and the set of accessible source identifiers, a simplified access query, the simplified access query comprising a list of query phrases for a subset of the positive rule conditions;
- running the simplified access query against a plurality of catalog items, wherein the running returns a subset of the plurality of catalog items;
- and
- returning, based on running the simplified access query, a catalog search result based on the subset of the plurality of catalog items.
A computing system comprising:
- one or more processors;
- memory configured to cause the one or more processors to perform operations comprising:
- identifying, based on a plurality of search group identifiers and a plurality of rules controlling access to a plurality of catalog items, a first set of source identifiers based on rules with positive conditions and a second set of source identifiers based on rules with negative conditions;
- responsive to determining that the first set of source identifiers is an empty set and the second set of source identifiers is not an empty set:
- iteratively populating a list of query phrases from the plurality of rules;
- responsive to determining that the first and second sets of source identifiers are not empty sets:
- identifying a third set of source identifiers based on an intersection between the first and second sets of source identifiers;
- responsive to determining that the third set of source identifiers is an empty set, identifying a fourth set of source identifiers based on a difference between the first and second sets of source identifiers;
- and
- iteratively populating the list of query phrases from the rules with positive conditions and the fourth set of source identifiers;
- generating an access query based on the populated list of access query phrases;
- and
- running the access query on the plurality of catalog items.
One or more non-transitory computer-readable media comprising computer-executable instructions that, when executed, cause a computing system to perform a method comprising:
- receiving, by a server from a first computing device, a plurality of access query rules for controlling access to a plurality of catalog items, the access query rules comprising positive and/or negative conditions based on one or more source identifier constraints, catalog identifier constraints, and/or catalog kit identifier constraints, wherein aggregation of the positive and negative conditions represents a full access query;
- receiving, by the server from a second computing device, a catalog search comprising one or more catalog user group identifiers;
- determining, by the server based on the access query rules and the one or more catalog user group identifiers, a set of accessible source identifiers;
- generating, by the server based on the rules with positive conditions and the set of accessible source identifiers, a simplified access query, wherein the generating comprises:
- for rules based on source identifier constraints, populating access query phrases for the source identifier constraints present in the set of accessible source identifiers;
- for rules based on catalog kit identifier constraints, populating access query phrases for the catalog kit identifier constraints associated with source identifiers present in the set of accessible source identifiers;
- for rules based on a first set of catalog identifier constraints associated with source identifiers all present in the set of accessible source identifiers, populating access query phrases for the first set of catalog identifier constraints;
- and
- for rules based on a second set of catalog identifier constraints associated with source identifiers not all present in the set of accessible source identifiers, populating access query phrases for the second set of catalog identifier constraints with associated source identifiers present in the set of accessible source identifiers;
- and
- combining the populated access query phrases into the simplified access query, wherein the simplified access query permits access to a subset of the plurality of items;
- and
- running, by the server, the simplified access query on the plurality of items.
Dependencies are inferred from the claim text.