Object scriptability

Patent metadata

Field	Value
Publication number	US-12099501-B2
Application number	US-202218062134-A
Country	US
Kind code	B2
Filing date	Dec 6, 2022
Priority date	Jul 29, 2019
Publication date	Sep 24, 2024
Grant date	Sep 24, 2024

Abstract

Object scriptability includes receiving a high-level language script describing at least one data-analysis object, including a node representing the data-analysis object in a graph-based data structure including a plurality of nodes, where each node from the plurality of nodes represents a respective data-analysis object in a data analysis system, where each node from the plurality of nodes is connected to at least one other node from the plurality of nodes by an edge, and where the edge represents a relationship between the respective objects in the data analysis system.

First claim

What is claimed is:

1. A method comprising:
receiving a high-level language script describing a first analytical-object;
including, in a graph-based ontological data structure in a low-latency database analysis system, a first node, wherein:
the graph-based ontological data structure includes nodes connected with edges;
the nodes represent respective objects in the low-latency database analysis system;
the edges represent respective relationships between objects in the low-latency database analysis system corresponding to the nodes connected by the respective edges;
the first node represents the first analytical-object; and
including the first node includes including an edge between the first node and a second node;

receiving a request for data from the low-latency database analysis system;
obtaining results data responsive to the request for data, wherein obtaining the results data includes:
traversing the graph-based ontological data structure to identify the first node; and
in response to identifying the first node, obtaining the results data in accordance with the first analytical-object; and

outputting a response including the results data.

2. The method of claim 1 , further comprising:
in response to receiving the high-level language script, changing multiple analytical-objects in accordance with the high-level language script.

3. The method of claim 1 , wherein the high-level language script includes non-redundant terminology to describe the first analytical-object.

4. The method of claim 1 , wherein the high-level language script includes an alias, wherein the alias is included in a tuple representing parameters of the first analytical-object.

5. The method of claim 1 , wherein obtaining the results data in accordance with the first analytical-object includes:
generating the results data by executing a data query automatically generated in accordance with the first analytical-object.

6. The method of claim 5 , wherein obtaining the results data in accordance with the first analytical-object includes:
automatically generating the data query in accordance with the first analytical-object.

7. The method of claim 1 , wherein obtaining the results data in accordance with the first analytical-object includes:
obtaining one or more data values from a column of a table stored in a database accessed by the low-latency database analysis system, wherein the second node represents the column in the low-latency database analysis system.

8. A low-latency database analysis system comprising:
a graph-based ontological data structure in a low-latency database analysis system, wherein the graph-based ontological data structure includes nodes connected with edges, wherein the nodes represent respective objects in the low-latency database analysis system, and wherein the edges represent respective relationships between objects in the low-latency database analysis system corresponding to the nodes connected by the respective edges; and
a processor that executes instructions to:
receive a high-level language script describing a first analytical-object;
include, in the graph-based ontological data structure, a first node, wherein the first node represents the first analytical-object, and wherein including the first node includes including an edge between the first node and a second node;
receive a request for data from the low-latency database analysis system;
obtain results data responsive to the request for data by:
traversing the graph-based ontological data structure to identify the first node; and
in response to identifying the first node, obtaining the results data in accordance with the first analytical-object; and

output a response including the results data.

9. The system of claim 8 , wherein, in response to receiving the high-level language script, the processor executes the instructions to:
change multiple analytical-objects in accordance with the high-level language script.

10. The system of claim 8 , wherein the high-level language script includes non-redundant terminology to describe the first analytical-object.

11. The system of claim 8 , wherein the high-level language script includes an alias, wherein the alias is a tuple representing parameters of the first analytical-object.

12. The system of claim 8 , wherein to obtain the results data the processor executes the instructions to:
generate the results data by executing a data query automatically generated in accordance with the first analytical-object.

13. A method comprising:
in response to receiving, in a first low-latency database analysis system, first data expressing a usage intent, wherein the first data includes a request to output a first high-level language script representing a first analytical-object of the first low-latency database analysis system:
obtaining object data for the first analytical-object from a first graph-based ontological data structure of the first low-latency database analysis system;
generating the first high-level language script describing the first analytical-object based on the object data; and
outputting the first high-level language script;

generating, based on the first high-level language script, a second graph-based ontological data structure in a second low-latency database analysis system, wherein the second graph-based ontological data structure includes nodes connected with edges, wherein the nodes represent respective objects in the second low-latency database analysis system, wherein the edges represent respective relationships between objects in the second low-latency database analysis system corresponding to the nodes connected by the respective edges, and wherein generating the second graph-based ontological data structure includes:
receiving a second high-level language script describing a second analytical-object; and
generating a first node representing the second analytical-object in the second graph-based ontological data structure, wherein generating the first node includes generating an edge between the first node and a second node in the second graph-based ontological data structure.

14. The method of claim 13 , further comprising:
receiving second data expressing a usage intent, wherein the second data includes a request for data from the second low-latency database analysis system;
obtaining results data responsive to the second data, wherein obtaining the results data includes:
traversing the second graph-based ontological data structure to identify the first node; and
in response to identifying the first node, obtaining the results data in accordance with the second analytical-object; and

outputting a response including the results data.

15. The method of claim 14 , wherein obtaining the results data in accordance with the second analytical-object includes obtaining one or more data values from a column of a table stored in a database accessed by the second low-latency database analysis system, wherein the second node represents the column in the second low-latency database analysis system.

16. The method of claim 14 , wherein obtaining the results data in accordance with the second analytical-object includes:
generating the results data by executing a data query automatically generated in accordance with the second analytical-object.

17. The method of claim 16 , wherein obtaining the results data in accordance with the second analytical-object includes:
automatically generating the data query in accordance with the second analytical-object.

18. The method of claim 13 , whe

Assignees

• Thoughtspot Inc

Inventors

• Bansal Archit
• Kothari Rakesh
• Agarwal Vaibhav
• Gadia Romil
• Agrawal Akshay
• Lee Brian

Classifications

• G06F16/2272

  Management thereof · CPC title

• G06F16/254

  Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses · CPC title

• G06F16/2264

  Multidimensional index structures · CPC title

• G06F16/25

  Integrating or interfacing systems involving database management systems · CPC title

• G06F16/242

  Query formulation · CPC title