Systems and methods for attribute analysis of one or more databases
Systems and techniques for indexing and/or querying a database are described herein. Multiple, large disparate data sources may be processed to cleanse and/or combine item data and/or item metadata. Further, attributes may be extracted from the item data sources. The interactive user interfaces allow a user to select one or more attributes and/or other parameters to present visualizations based on the processed data.
1. A computer-implemented method comprising:
determining, from item data, a plurality of items;
determining, from the item data, a plurality of attributes, wherein determining the plurality of attributes further comprises:
identifying, from the item data, a first valid word that matches a first word in a dictionary;
adding the first valid word as a first attribute to the plurality of attributes;
identifying, from the item data, a second valid word that matches a second word in a custom dictionary different from the dictionary; and
adding the second valid word as a second attribute to the plurality of attributes;
receiving first user input comprising a set of user specified conjunction attributes, the set of user specified conjunction attributes comprising the first attribute;
receive second user input comprising a set of user specified synonymous attributes, the set of user specified synonymous attributes comprising the second attribute and a third attribute;
determining, from the plurality of items, a subset of items corresponding to the set of user specified conjunction attributes and the set of user specified synonymous attributes, wherein determining the subset of items further comprises:
determining, from the plurality of items, a first set of items corresponding to the first attribute and the second attribute, wherein each item of the first set of items is associated with the first attribute and the second attribute;
determining, from the plurality of items, a second set of items corresponding to the first attribute and the third attribute, wherein each item of the second set of items is associated with the first attribute and the third attribute; and
adding the first set of items and the second set of items to the subset of items;
determining, from item metadata, a plurality of summary indicators, wherein each summary indicator of the plurality of summary indicators is representative of each item from the subset of items; and
presenting, in a user interface, a plurality of visualizations associated with a respective indicator from the plurality of summary indicators, wherein the plurality of visualizations indicate data associated with the set of user specified conjunction attributes and at least one attribute of the set of user specified synonymous attributes as if the second attribute and the third attribute were the same.
2. The computer-implemented method of claim 1 , wherein determining the plurality of summary indicators further comprises:
determining a set of summary indicators from the item metadata, wherein each summary indicator of the set of summary indicators corresponds to an item from the subset of items;
generating a ranking of the set of summary indicators; and
selecting, from the set of summary indicators, the plurality of summary indicators based at least in part on the ranking.
3. The computer-implemented method of claim 2 , wherein selecting the plurality of summary indicators based at least in part on the ranking further comprises:
identifying, from the ranking, a first summary indicator that is higher than a second summary indicator; and
adding the first summary indicator to the plurality of summary indicators instead of the second summary indicator.
4. The computer-implemented method of claim 2 , wherein selecting the plurality of summary indicators based at least in part on the ranking further comprises:
identifying, from the ranking, the plurality of summary indicators as a top number of results from the set of summary indicators.
5. The computer-implemented method of claim 1 , wherein the first attribute comprises a tag for at least one item.
6. The computer-implemented method of claim 5 , wherein the at least one item comprises a food item.
7. The computer-implemented method of claim 1 , wherein a visualization of the plurality of visualizations comprises a time series visualization.
8. A system comprising:
at least one computer hardware processor; and
data storage comprising instructions executable by the at least one computer hardware processor to cause the system to:
determine, from item data, a plurality of items;
determine, from the item data, a plurality of attributes, wherein to determine the plurality of attributes further comprises:
identify, from the item data, a first valid word that matches a first word in a custom dictionary;
add the first valid word as a first attribute to the plurality of attributes;
identify, from the item data, a second valid word that matches a second word in a dictionary different from the custom dictionary; and
add the second valid word as a second attribute to the plurality of attributes;
receive first user input comprising a set of user specified conjunction attributes, the set of user specified conjunction attributes comprising the first attribute;
receive second user input comprising a set of user specified synonymous attributes, the set of user specified synonymous attributes comprising the second attribute and a third attribute;
determine, from the plurality of items, a subset of items corresponding to the set of user specified conjunction attributes and the set of user specified synonymous attributes, wherein to determine the subset of items further comprises:
determine, from the plurality of items, a first set of items corresponding to the first attribute and the second attribute, wherein each item of the first set of items is associated with the first attribute and the second attribute;
determine, from the plurality of items, a second set of items corresponding to the first attribute and the third attribute, wherein each item of the second set of items is associated with the first attribute and the third attribute; and
add the first set of items and the second set of items to the subset of items;
determine, from item metadata, a plurality of summary indicators, wherein each summary indicator of the plurality of summary indicators is representative of each item from the subset of items; and
present, in a user interface, the plurality of summary indicators.
9. The system of claim 8 , wherein to determine the plurality of summary indicators further comprises:
determine a set of summary indicators from the item metadata, wherein each summary indicator of the set of summary indicators corresponds to an item from the subset of items;
generate a ranking of the set of summary indicators; and
select, from the set of summary indicators, the plurality of summary indicators based at least in part on the ranking.
10. The system of claim 9 , wherein to determine the ranking further comprises:
determine an order of the set of summary indicators as ascending or descending, wherein the ranking is according to the order.
11. The system of claim 10 , wherein the at least one computer hardware processor further causes the system to:
receive third user input comprising filtering criteria that specifies ascending or descending, wherein the order is determined as ascending or descending according to the filtering criteria that specifies ascending or descending.
12. The system of claim 10 , wherein to select the plurality of summary indicators based at least in part on the ranking further comprises:
identify, from the ranking, the plurality of summary indicators as a top number of results from the set of summary indicators that are below a threshold number of results.
13. The system of claim 8 , further comprising:
a processed data storage comprising the plurality of attributes, wherein the plurality of attributes further comprise the third attribute, and wherein each attribute of the plurality of attributes comprises a tag for at least one item.
14. The system of claim 8 , wherein the item data is in a columnar data format.
15. The system of claim 8 , wherein to generate the plurality of attributes further comprises:
determine that two or more words from the item data are synonyms;
select, from the two or more words, a first word as a representative attribute; and
add the first word as the representative attribute to the plurality of attributes.