Fuzzy search and highlighting of existing data visualization
A user may provide input to search an existing visualization (e.g., bar chart, graph) of a dataset returned in response to database querying. A highlighted visualization may then provide additional insight into relationships within the dataset. The highlighting may comprise changes to the appearance (e.g., size, color, background) of visualization elements. The search and highlighting may be executed by a functional module in an application layer of a local client in communication with database on a remote server. A search engine of the functional module may perform searching of dimension names, dimension values, and measure names within the dataset, identifying particular elements of the data set that are relevant to a search term (e.g., “q1”). Based upon recognition of relevant dataset data, a visualization engine may highlight particular elements of the visualization (e.g., changing an appearance of vertical bars showing first quarter revenue relative to vertical bars for other quarters).
1. A computer system comprising:
one or more processors;
a software program, executable on said computer system, the software program configured to:
provide in a Random Access Memory (RAM) of a client located remote from a server, an application layer storing,
a dataset comprising a dimension name, a dimension value, and a measure name responsive to a database query issued by the client to the server, and
an existing visualization of the dataset including a first visualization element;
cause the application layer to further store executable code of a functional module of the application layer receiving a search input from a user, the search input comprising a dimension name, a dimension value, or a measure name, the functional module automatically creating a box displaying the search input;
cause a search engine of the functional module to search the dataset according to the search input and a fuzzy search index to produce a search result;
cause a visualization engine of the functional module to transform the search result and the existing visualization to create a highlighted visualization including a first changed appearance of the first visualization element and a second changed appearance of a second visualization element of the existing visualization, the second changed appearance different from the first changed appearance; and
cause the application layer to communicate the highlighted visualization to the user;
wherein the software program is further configured to:
cause the functional module to receive an extended input reflecting a filter from the user in response to the highlighted visualization;
cause the functional module to process the dataset according to the extended input to produce an extended search result smaller than the search result;
cause the functional module to generate an extended visualization from the extended search result and the highlighted visualization, the extended visualization including fewer elements than the highlighted visualization;
cause the functional module to store the extended visualization in the RAM; and
cause the application layer to communicate the extended visualization to the user.
2. A computer system as in claim 1 wherein the existing visualization comprises a chart and the visualization element changed in appearance comprises a data point, a legend text, and/or a category axis label.
3. A computer system as in claim 1 wherein the highlighted visualization comprises a horizontal bar chart, a vertical bar chart, a plot, or a pie chart.
4. A non-transitory computer readable storage medium embodying a computer program for performing a method, said method comprising:
providing in a Random Access Memory (RAM) of a client located remote from a server, an application layer storing,
a dataset comprising a dimension name, a dimension value, and a measure name responsive to a database query issued by the client to the server, and
an existing visualization of the dataset including a first visualization element;
the application layer further storing in the RAM executable code of a functional module of the application layer receiving a search input from a user, the search input comprising a dimension name, a dimension value, or a measure name, the functional module automatically creating a box displaying the search input;
the functional module searching the dataset according to the search input and a fuzzy search index to produce a search result;
the functional module transforming the search result and the existing visualization to create a highlighted visualization including a first changed appearance of the first visualization element and a second changed appearance of a second visualization element of the existing visualization, the second changed appearance different from the first changed appearance;
the application layer communicating the highlighted visualization to the user;
the functional module receiving an extended input reflecting a filter from the user in response to the highlighted visualization;
the functional module processing the dataset according to the extended input to produce an extended search result smaller than the search result;
the functional module generating an extended visualization from the extended search result and the highlighted visualization, the extended visualization including fewer elements than the highlighted visualization;
the functional module storing the extended visualization in the RAM; and
the application layer communicating the extended visualization to the user.
5. A non-transitory computer readable storage medium as in claim 4 wherein the highlighted visualization is generated by a highlighting engine of the functional module.
6. A non-transitory computer readable storage medium as in claim 4 wherein the existing visualization comprises a chart and the visualization element changed in appearance comprises a data point, a legend text, and/or a category axis label.
7. A non-transitory computer readable storage medium as in claim 4 wherein the highlighted visualization comprises a horizontal bar chart, a vertical bar chart, a plot, or a pie chart.
8. A non-transitory computer readable storage medium as in claim 4 wherein the application layer automatically displays a search box in response to the search input.
9. A method comprising:
providing in a Random Access Memory (RAM) of a client located remote from a server, an application layer storing,
a dataset responsive to a database query issued by the client to the server, and
an existing visualization of the dataset including a first visualization element;
the application layer further storing in the RAM executable code of a functional module receiving a search input from a user and automatically creating a box displaying the search input;
the functional module searching the dataset according to the search input and a fuzzy search index to produce a search result;
the functional module transforming the search result and the existing visualization to create a highlighted visualization including a first changed appearance of the first visualization element and a second changed appearance of a second visualization element of the existing visualization, the second changed appearance different from the first changed appearance;
the application layer communicating the highlighted visualization to the user;
the functional module receiving an extended input from the user in response to the highlighted visualization;
the functional module processing the dataset according to the extended search input to produce an extended search result;
the functional module generating an extended visualization from the extended search result and the highlighted visualization;
the functional module storing the extended visualization in the RAM; and
the application layer communicating the extended visualization to the user.
10. A method as in claim 9 wherein the dataset comprises a dimension and the search input reflects a dimension name or a dimension value.
11. A method as in claim 9 wherein the dataset comprises a measure and the search input reflects a measure name.
12. A method as in claim 9 wherein the existing visualization comprises a chart and the visualization element changed in appearance comprises a data point, a legend text, and/or a category axis label.
13. A method as in claim 9 wherein the extended input comprises a filter, the extended search result is smaller than the search result, and the extended visualization includes fewer elements than the highlighted visualization.
14. A method as in claim 9 wherein the highlighted visualization comprises a horizontal bar chart, a vertical bar chart, a plot, or a pie chart.