Systems and methods for transforming datasets
First Claim
1. A method comprising, by a computer system:
- receiving a data-transformation request in relation to a visualization of a first dataset, wherein the visualization represents columns of data, wherein the data-transformation request expresses at least one transformation of the first dataset without using Structured Query Language (SQL) syntax, wherein the visualization is characterized by a first SQL statement maintained by the computer system, wherein the columns of the visualization are mapped to constituent parts of the first SQL statement in which the columns are referenced;
automatically determining a second SQL statement configured to return a second dataset, wherein the second dataset implements the at least one transformation of the first dataset, the automatically determining comprising;
looking up an identifier of the at least one transformation in a repository;
responsive to a determination that there exists, in the repository for the identifier, an applicable SQL generation rule other than a default rule, automatically building the second SQL statement based, at least in part, on the mapping of the visualization to the constituent parts of the first SQL statement, using SQL syntax specified by the applicable SQL generation rule; and
responsive to a determination that there does not exist, in the repository for the identifier, an applicable SQL generation rule other than the default rule, automatically building the second SQL statement based, at least in part, on the mapping of the visualization to the constituent parts of the first SQL statement, using SQL syntax specified by the default rule, the building comprising including the first SQL statement as a subquery in a clause of the second SQL statement;
causing the second SQL statement to be executed on one or more databases;
receiving the second dataset in response to the causing; and
updating the visualization to reflect the second dataset.
22 Assignments
0 Petitions
Accused Products
Abstract
In one embodiment, a method includes receiving a data-transformation request in relation to a visualization of a first dataset, wherein the data-transformation request expresses at least one transformation of the first dataset without using Structured Query Language (SQL) syntax, wherein the visualization is characterized by a first SQL statement. In addition, the method includes automatically determining based, at least in part, on a mapping of the visualization to the first SQL statement, a second SQL statement operable to return a second dataset. Further, the method includes causing the second SQL statement to be executed on one or more databases. Moreover, the method includes receiving, in response to the causing, the second dataset. The method also includes updating the visualization to reflect the second dataset.
-
Citations
17 Claims
-
1. A method comprising, by a computer system:
-
receiving a data-transformation request in relation to a visualization of a first dataset, wherein the visualization represents columns of data, wherein the data-transformation request expresses at least one transformation of the first dataset without using Structured Query Language (SQL) syntax, wherein the visualization is characterized by a first SQL statement maintained by the computer system, wherein the columns of the visualization are mapped to constituent parts of the first SQL statement in which the columns are referenced; automatically determining a second SQL statement configured to return a second dataset, wherein the second dataset implements the at least one transformation of the first dataset, the automatically determining comprising; looking up an identifier of the at least one transformation in a repository; responsive to a determination that there exists, in the repository for the identifier, an applicable SQL generation rule other than a default rule, automatically building the second SQL statement based, at least in part, on the mapping of the visualization to the constituent parts of the first SQL statement, using SQL syntax specified by the applicable SQL generation rule; and responsive to a determination that there does not exist, in the repository for the identifier, an applicable SQL generation rule other than the default rule, automatically building the second SQL statement based, at least in part, on the mapping of the visualization to the constituent parts of the first SQL statement, using SQL syntax specified by the default rule, the building comprising including the first SQL statement as a subquery in a clause of the second SQL statement; causing the second SQL statement to be executed on one or more databases; receiving the second dataset in response to the causing; and updating the visualization to reflect the second dataset. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. An information handling system comprising at least one processor, wherein the at least one processor is configured to implement a method comprising:
-
receiving a data-transformation request in relation to a visualization of a first dataset, wherein the visualization represents columns of data, wherein the data-transformation request expresses at least one transformation of the first dataset without using Structured Query Language (SQL) syntax, wherein the visualization is characterized by a first SQL statement maintained by the information handling system, wherein the columns of the visualization are mapped to constituent parts of the first SQL statement in which the columns are referenced; automatically determining a second SQL statement configured to return a second dataset, wherein the second dataset implements the at least one transformation of the first dataset, the automatically determining comprising; looking up an identifier of the at least one transformation in a repository; responsive to a determination that there exists, in the repository for the identifier, an applicable SQL generation rule other than a default rule, automatically building the second SQL statement based, at least in part, on the mapping of the visualization to the constituent parts of the first SQL statement, using SQL syntax specified by the applicable SQL generation rule; and responsive to a determination that there does not exist, in the repository for the identifier, an applicable SQL generation rule other than the default rule, automatically building the second SQL statement based, at least in part, on the mapping of the visualization to the constituent parts of the first SQL statement, using SQL syntax specified by the default rule, the building comprising including the first SQL statement as a subquery in a clause of the second SQL statement; causing the second SQL statement to be executed on one or more databases; receiving the second dataset in response to the causing; and updating the visualization to reflect the second dataset. - View Dependent Claims (11, 12, 13, 14, 15, 16)
-
-
17. A computer-program product comprising a non-transitory computer-usable medium having computer-readable program code embodied therein, the computer-readable program code adapted to be executed to implement a method comprising:
-
receiving a data-transformation request in relation to a visualization of a first dataset, wherein the visualization represents columns of data, wherein the data-transformation request expresses at least one transformation of the first dataset without using Structured Query Language (SQL) syntax, wherein the visualization is characterized by a first SQL statement maintained by a computer system, wherein the columns of the visualization are mapped to constituent parts of the first SQL statement in which the columns are referenced; automatically determining a second SQL statement configured to return a second dataset, wherein the second dataset implements the at least one transformation of the first dataset, the automatically determining comprising; looking up an identifier of the at least one transformation in a repository; responsive to a determination that there exists, in the repository for the identifier, an applicable SQL generation rule other than a default rule, automatically building the second SQL statement based, at least in part, on the mapping of the visualization to the constituent parts of the first SQL statement, using SQL syntax specified by the applicable SQL generation rule; and responsive to a determination that there does not exist, in the repository for the identifier, an applicable SQL generation rule other than the default rule, automatically building the second SQL statement based, at least in part, on the mapping of the visualization to the constituent parts of the first SQL statement, using SQL syntax specified by the default rule, the building comprising including the first SQL statement as a subquery in a clause of the second SQL statement; causing the second SQL statement to be executed on one or more databases; receiving the second dataset in response to the causing; and updating the visualization to reflect the second dataset.
-
Specification