Database value exploration system
AssigneeSap SE
InventorJens Schyma
Life of this patent
Estimating the term…
Abstract
A computer-implemented method may comprise receiving a first search value and generating a first set of search results based on a first search of database tables for the first search value. The first set of search results may identify each row of each database table that has a corresponding cell that includes the first search value. Each row of one of the database tables that is identified in the first set of search results may be displayed along with a corresponding cell value that is stored in each one of the cells of the row. A second search value defined by a user selection of one of the displayed cell values may be received, and, in response to receiving the second search value, a second set of search results may be generated based on a second search search of the database tables for the second search value.
Claims20
A computer-implemented method comprising:
- receiving a first search value from a computing device;
- generating a first set of search results based on a first search of a plurality of database tables for the first search value, each database table in the plurality of database tables comprising a plurality of rows, each row in the plurality of rows comprising a plurality of cells, the first set of search results identifying each row of each database table in the plurality of database tables that has a corresponding cell that includes the first search value, each database table stored in a relational database;
- for one of the plurality of database tables, causing each row, of the one of the plurality of database tables, that is identified in the first set of search results, including cell values that do not contain the first search value, to be displayed on the computing device and causing each cell value that contains the first search value to be displayed with a first visual indication corresponding to the first search value;
- subsequent to the causing, receiving, from the computing device, a second search value defined by a user selection of one of the displayed cell values, the second search value being different from the first search value;
- in response to receiving the second search value, generating a second set of search results based on a second search of the plurality of database tables for the second search value, the second set of search results identifying each row of each database table in the plurality of database tables that has a corresponding cell that includes the second search value;
- and
- for the one of the plurality of database tables, causing each row, of the one of the plurality of database tables, that is identified in the second set of search results, including cell values that do not contain the second search value, to be displayed on the computing device and causing each cell value that contains the second search value to be displayed with a second visual indication corresponding to the second search value, the first visual indication and the second visual indication being displayed concurrently on the computing device.
A system of comprising:
- at least one hardware processor;
- and
- a non-transitory computer-readable medium storing executable instructions that, when executed, cause the at least one hardware processor to perform computer operations comprising:
- receiving a first search value from a computing device;
- generating a first set of search results based on a first search of a plurality of database tables for the first search value, each database table in the plurality of database tables comprising a plurality of rows, each row in the plurality of rows comprising a plurality of cells, the first set of search results identifying each row of each database table in the plurality of database tables that has a corresponding cell that includes the first search value, each database table stored in a relational database;
- for one of the plurality of database tables, causing each row, of the one of the plurality of database tables, that is identified in the first set of search results, including cell values that do not contain the first search value, to be displayed on the computing device and causing each cell value that contains the first search value to be displayed with a first visual indication corresponding to the first search value;
- subsequent to the causing, receiving, from the computing device, a second search value defined by a user selection of one of the displayed cell values, the second search value being different from the first search value;
- in response to receiving the second search value, generating a second set of search results based on a second search of the plurality of database tables for the second search value, the second set of search results identifying each row of each database table in the plurality of database tables that has a corresponding cell that includes the second search value;
- and
- for the one of the plurality of database tables, causing each row, of the one of the plurality of database tables, that is identified in the second set of search results, including cell values that do not contain the second search value, to be displayed on the computing device and causing each cell value that contains the second search value to be displayed with a second visual indication corresponding to the second search value, the first visual indication and the second visual indication being displayed concurrently on the computing device.
A non-transitory machine-readable storage medium tangibly embodying a set of instructions that, when executed by at least one hardware processor, causes the at least one processor to perform computer operations comprising:
- receiving a first search value from a computing device;
- generating a first set of search results based on a first search of a plurality of database tables for the first search value, each database table in the plurality of database tables comprising a plurality of rows, each row in the plurality of rows comprising a plurality of cells, the first set of search results identifying each row of each database table in the plurality of database tables that has a corresponding cell that includes the first search value, each database table stored in a relational database;
- receiving a first search value from a computing device;
- generating a first set of search results based on a first search of a plurality of database tables for the first search value, each database table in the plurality of database tables comprising a plurality of rows, each row in the plurality of rows comprising a plurality of cells, the first set of search results identifying each row of each database table in the plurality of database tables that has a corresponding cell that includes the first search value, each database table stored in a relational database;
- for one of the plurality of database tables, causing each row, of the one of the plurality of database tables, that is identified in the first set of search results, including cell values that do not contain the first search value, to be displayed on the computing device and causing each cell value that contains the first search value to be displayed with a first visual indication corresponding to the first search value;
- subsequent to the causing, receiving, from the computing device, a second search value defined by a user selection of one of the displayed cell values, the second search value being different from the first search value;
- in response to receiving the second search value, generating a second set of search results based on a second search of the plurality of database tables for the second search value, the second set of search results identifying each row of each database table in the plurality of database tables that has a corresponding cell that includes the second search value;
- and
- for the one of the plurality of database tables, causing each row, of the one of the plurality of database tables, that is identified in the second set of search results, including cell values that do not contain the second search value, to be displayed on the computing device and causing each cell value that contains the second search value to be displayed with a second visual indication corresponding to the second search value, the first visual indication and the second visual indication being displayed concurrently on the computing device.
Dependencies are inferred from the claim text.