Techniques for constructing and editing a search query using an overload cell

    公开(公告)号:US10817508B2

    公开(公告)日:2020-10-27

    申请号:US12966382

    申请日:2010-12-13

    Abstract: A technique utilizes a search query having a set of clauses. The technique involves displaying, by a processor, the set of clauses of the search query onto an electronic display. Each clause includes a selection cell describing a selectable operation. The technique further involves receiving, by the processor, a mouse click input from a mouse apparatus. The mouse click input includes coordinates identifying a location that resides within the selection cell of a particular clause. The technique further involves change, by the processor, the selectable operation described by the selection cell of the particular clause between an editing operation and a Boolean operation in response to the mouse click input. Such a technique minimizes user typing and navigation demands, and offers a compact format and considerable power and flexibility when constructing and/or editing a search query.

    MAPPING EXPRESSION GENERATOR
    4.
    发明申请

    公开(公告)号:US20220147568A1

    公开(公告)日:2022-05-12

    申请号:US17094346

    申请日:2020-11-10

    Applicant: SAP SE

    Inventor: Deepak MP

    Abstract: Methods and systems may be associated with a cloud platform computing environment. A mapping expression data store may contain mapping expressions previously created by customer tenants of the cloud platform. Each mapping expression may be associated with at least one source mapping element and at least one target mapping element. A mapping expression generator may receive, from a user of a first customer tenant, a mapping expression search request that includes at least one requested source mapping element and at least one requested target mapping element. The mapping expression generator may then search the mapping expression data store based on the at least one requested source mapping element and at the least one requested target mapping element and output a result of the search to the user. The result of the search may include at least one mapping expression created by a customer tenant other than the first customer tenant.

    Building queries directed to objects hosted on clouds

    公开(公告)号:US10372760B2

    公开(公告)日:2019-08-06

    申请号:US14687956

    申请日:2015-04-16

    Abstract: According to an aspect of the present disclosure, a query builder sends to a node in a cloud, a request for meta-data related to objects, and in response receives from the node, the meta-data specifying information related to objects exposed by the node. Upon receiving from a user a partial query and a current edit location during building of a corresponding complete query, the query builder determines, based on the received meta-data, the current edit location, and the partial query, a list of identifiers which are potential candidates for insertion at the current edit location. The query builder then displays the list of identifiers to the user, and receives a selection of an identifier from the displayed list. The query builder incorporates the selected identifier in the partial query at the current edit location to form a further developed query.

    Manipulating a table with an XML column in a database

    公开(公告)号:US11860939B2

    公开(公告)日:2024-01-02

    申请号:US16407220

    申请日:2019-05-09

    Abstract: Embodiments of the disclosure provide methods, systems, computer program products for manipulating a table with an XML column in database. According to the method, a SQL statement for a table is received first, wherein the table comprises an XML column which is a representation of a plurality of logical columns of the table, there is at least one XML element in at least one row and in the XML column of the table, and each of the at least one XML element corresponds to a non-null value in a specific row and in a logical column of the plurality of logical columns of the table. Then the SQL statement is parsed. And then the SQL statement is transformed into a hybrid statement being able to process the XML column in response to the parsing result indicating that the SQL statement relates to at least one logical column of the plurality of logical columns. At last the hybrid statement is executed.

    Data transformation tool
    7.
    发明授权

    公开(公告)号:US10956408B2

    公开(公告)日:2021-03-23

    申请号:US15636987

    申请日:2017-06-29

    Abstract: A data transformation tool includes a receiver, an extraction engine, a transformation engine, and a delivery engine. The receiver receives from a user a request indicating an identifier for reference data, a format, and a delivery type. The reference data includes a data field, a list of permissible values for the data field, and a textual description of the data field. The extraction engine generates, based on the request, a database query requesting reference data identified by the identifier from a database and communicates the query to the database. The transformation engine receives, from the database, the reference data in response to communicating the query to the database and transforms the received reference data into a flat file based on the format indicated by the request. The delivery engine delivers the flat file to the user according to the user using the deliver type indicated by the request.

    Mapping expression generator
    9.
    发明授权

    公开(公告)号:US12174887B2

    公开(公告)日:2024-12-24

    申请号:US17094346

    申请日:2020-11-10

    Applicant: SAP SE

    Inventor: Deepak MP

    Abstract: Methods and systems may be associated with a cloud platform computing environment. A mapping expression data store may contain mapping expressions previously created by customer tenants of the cloud platform. Each mapping expression may be associated with at least one source mapping element and at least one target mapping element. A mapping expression generator may receive, from a user of a first customer tenant, a mapping expression search request that includes at least one requested source mapping element and at least one requested target mapping element. The mapping expression generator may then search the mapping expression data store based on the at least one requested source mapping element and at the least one requested target mapping element and output a result of the search to the user. The result of the search may include at least one mapping expression created by a customer tenant other than the first customer tenant.

    Automated Query Analysis and Remediation Tool

    公开(公告)号:US20230267148A1

    公开(公告)日:2023-08-24

    申请号:US17677145

    申请日:2022-02-22

    CPC classification number: G06F16/8365 G06F16/832

    Abstract: Aspects of the disclosure relate to an automated query analysis and remediation tool. A computing platform may receive a query for analysis. The computing platform may load an extensible markup language (XML) query execution plan for the received query. In addition, the query execution plan may include a sequence of operations used to access data in a relational database. The computing platform may shred XML data from the query execution plan into relational database tables. The computing platform may identify tuning parameters based on the shredded XML data. Based on the identified tuning parameters and using a machine learning engine, the computing platform may generate an optimized query. The computing platform may cause the optimized query to be displayed on one or more user interfaces.

Patent Agency Ranking