Invention Grant
- Patent Title: Data type based visual profiling of large-scale database tables
-
Application No.: US17541494Application Date: 2021-12-03
-
Publication No.: US11893038B2Publication Date: 2024-02-06
- Inventor: Dilyan Kovachev , Pradeep Kumar Reddy Savadi , Gurbaksh Sharma
- Applicant: Treasure Data, Inc.
- Applicant Address: US CA Mountain View
- Assignee: Treasure Data, Inc.
- Current Assignee: Treasure Data, Inc.
- Current Assignee Address: US CA Mountain View
- Agency: Baker Botts L.L.P.
- Priority: IN 2111047901 2021.10.21
- Main IPC: G06F16/26
- IPC: G06F16/26 ; G06F16/242 ; G06F16/2452 ; G06F16/2453 ; G06F16/2458

Abstract:
A computer-implemented method can comprise establishing programmatic connections to a digitally stored first database comprising over one million records, each of the records comprising columns; reading a configuration file that specifies tables in the database; for each particular table, forming and submitting a plurality of queries to the database, each of the queries specifying data aggregation operations, and in response thereto, receiving result sets of records of the database; calculating metadata metrics that characterize columns of the records in the result sets and storing the metadata metrics in tables for string column statistics, numeric column statistics, date column statistics, based upon a particular data type among different data types of the columns; generating presentation instructions which when rendered cause displaying one or more graphical visualizations in a graphical user interface.
Public/Granted literature
- US20230129763A1 DATA TYPE BASED VISUAL PROFILING OF LARGE-SCALE DATABASE TABLES Public/Granted day:2023-04-27
Information query