US 12,229,158 B2
Data type-based visual profiling of large-scale database tables
Dilyan Kovachev, Bridgeport, CT (US); Pradeep Kumar Reddy Savadi, Sunnyvale, CA (US); and Gurbaksh Sharma, Karnal (IN)
Assigned to Treasure Data, Inc., Mountain View, CA (US)
Filed by Treasure Data, Inc., Mountain View, CA (US)
Filed on Nov. 8, 2023, as Appl. No. 18/504,813.
Application 18/504,813 is a continuation of application No. 17/541,494, filed on Dec. 3, 2021, granted, now 11,893,038.
Claims priority of application No. 202111047901 (IN), filed on Oct. 21, 2021.
Prior Publication US 2024/0078248 A1, Mar. 7, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/26 (2019.01); G06F 16/242 (2019.01); G06F 16/2452 (2019.01); G06F 16/2453 (2019.01); G06F 16/2458 (2019.01)
CPC G06F 16/26 (2019.01) [G06F 16/2445 (2019.01); G06F 16/24522 (2019.01); G06F 16/24545 (2019.01); G06F 16/2458 (2019.01)] 16 Claims
OG exemplary drawing
 
1. A computer-implemented method, comprising:
using a first computer, reading a configuration file to iteratively access databases, tables and columns specified in the configuration file;
using the first computer programmatically calling PRESTO and HIVE functions to execute aggregation operations on the databases, the tables and the columns while concurrently calculating aggregated statistical metadata relating to the databases, the tables and the columns;
in response to executing the aggregation operations and calculating the aggregated statistical metadata, creating and storing reduced-size tables comprising a metadata table, wherein display instructions are generated to display an exploratory data analysis (EDA) dashboard corresponding to the reduced-size tables with the metadata table on a graphical user interface (GUI) of a computer display device associated with the first computer;
using the first computer, receiving input specifying a plurality of filters to remove non-matching rows of the metadata table from visualization of the EDA dashboard; and
generating one or more GUI panels, each GUI panel is associated with a particular type of filter.