Integrated visual relational data explorer

1 . A computer-implemented method of providing visual data exploration of a plurality of electronic databases, the method comprising:

causing a schema explorer graphical user interface to be displayed in a display device of a computing device of a user,

wherein the schema explorer graphical user interface includes a visual graph of a first database in the plurality of electronic databases including at least one table node, representing at least one table, the at least one table node having at least one edge directly connecting the at least one table node to a different table node and depicting a field name, a field type, and a field description,

wherein the at least one table node includes a legacy table code name and a respective mapped descriptive table name,

wherein the at least one table includes a first relational key corresponding to the at least one edge,

wherein the at least one table includes at least one of a second relational key or a field description identifier corresponding to the field description, and

wherein the schema explorer includes one or more persistent filter inputs;

receiving, via the computing device of the user, an indication of the user including at least one query parameter corresponding to a respective one of the one or more persistent filter inputs;

receiving a user's selection of a second database;

generating, in response to the user's selection of the second database, an updated visual graph corresponding to the second database using the at least one query parameter; and

causing the updated visual graph to be displayed in the schema explorer graphical user interface of the computing device of the user.

2 . The computer-implemented method of claim 1 , wherein causing the schema explorer graphical user interface to be displayed in the display device of the computing device of a user includes displaying a list of tables, each including the respective mapped descriptive table name.

3 . The computer-implemented method of claim 1 , wherein receiving the indication of the user including the at least one query parameter includes receiving an aggregation parameter.

4 . The computer-implemented method of claim 3 , wherein the aggregation parameter includes a group by parameter.

5 . The computer-implemented method of claim 3 , wherein the aggregation parameter includes an order by parameter.

6 . The computer-implemented method of claim 1 , further comprising:

displaying a data filter graphical user interface;

receiving an aggregation clause selection from the user;

displaying an aggregation clause corresponding to the aggregation clause selection in the data filter graphical user interface;

receiving a user application selection;

generating a second updated visual graph by filtering the updated visual graph using the aggregation clause selection; and

causing the second updated visual graph to be displayed in the schema explorer graphical user interface of the computing device of the user.

7 . The computer-implemented method of claim 1 , further comprising:

receiving, via the computing device of the user, a selection of a second table node; and

causing the schema explorer graphical user interface to be displayed in the display device of the computing device of the user, wherein the schema explorer graphical user interface includes the visual graph of the first database including at least the second table node, wherein the visual graph of the first database is filtered according to the indication of the user including the at least one query parameter.

8 . The computer-implemented method of claim 1 , wherein the first electronic database is a structured query language database.

9 . A server comprising:

one or more processors; and

a memory storing instructions that, when executed by the one or more processors, cause the server to:

cause a schema explorer graphical user interface to be displayed in a display device of a computing device of a user,

wherein the schema explorer graphical user interface includes a visual graph of a first database in a plurality of electronic databases including at least one table node, representing at least one table, the at least one table node having at least one edge directly connecting the at least one table node to a different table node and depicting a field name and a field type, and a field description,

wherein the at least one table node includes a legacy table code name and a respective mapped descriptive table name,

wherein the at least one table includes a first relational key corresponding to the at least one edge,

wherein the at least one table includes at least one of a second relational key or a field description identifier corresponding to the field description, and

wherein the schema explorer includes one or more persistent filter inputs;

receive, via the computing device of the user, an indication of the user including at least one query parameter corresponding to a respective one of the one or more persistent filter inputs;

generate, in response to the user's selection of a second database, an updated visual graph corresponding to the second database using the at least one query parameter; and

cause the updated visual graph to be displayed in the schema explorer graphical user interface of the computing device of the user.

10 . The server of claim 9 , wherein the instructions further cause the server to:

cause the schema explorer graphical user interface to be displayed in the display device of the computing device of a user includes displaying a list of tables, each including the respective mapped descriptive table name.

11 . The server of claim 9 , wherein the instructions further cause the server to:

receive an aggregation parameter.

12 . The server of claim 11 , wherein the aggregation parameter includes a group by parameter.

13 . The server of claim 11 , wherein the aggregation parameter includes an order by parameter.

14 . The server of claim 9 , wherein the instructions further cause the server to:

display a data filter graphical user interface;

receive an aggregation clause selection from the user;

display an aggregation clause corresponding to the aggregation clause selection in the data filter graphical user interface;

receive a user application selection;

generate a second updated visual graph by filtering the updated visual graph using the aggregation clause selection; and

cause the second updated visual graph to be displayed in the schema explorer graphical user interface of the computing device of the user.

15 . The server of claim 9 , wherein the instructions further cause the server to:

receive, via the computing device of the user, a selection of a second table node; and

cause the schema explorer graphical user interface to be displayed in the display device of the computing device of the user, wherein the schema explorer graphical user interface includes the visual graph of the first database including at least the second table node, wherein the visual graph of the first database is filtered according to the indication of the user including the at least one query parameter.

16 . The server of claim 9 , wherein the first electronic database is a structured query language database.

17 . A non-transitory computer readable medium containing program instructions that when executed, cause a computer to:

cause a schema explorer graphical user interface to be displayed in a display device of a computing device of a user,

wherein the schema explorer graphical user interface includes a visual graph of a first database in a plurality of electronic databases including at least one table node, representing at least one table, the at least one table node having at least one edge directly connecting the at least one table node to a different table node and depicting a field name and a field type, and a field description,

wherein the at least one table node includes a legacy table code name and a respective mapped descriptive table name,

wherein the at least one table includes a first relational key corresponding to the at least one edge,

wherein the at least one table includes at least one of a second relational key or field description identifier corresponding to the field description, and

wherein the schema explorer includes one or more persistent filter inputs;

receive, via the computing device of the user, an indication of the user including at least one query parameter corresponding to a respective one of the one or more persistent filter inputs;

generate, in response to the user's selection of a second database, an updated visual graph corresponding to the second database using the at least one query parameter; and

cause the updated visual graph to be displayed in the schema explorer graphical user interface of the computing device of the user.

18 . The non-transitory computer readable medium of claim 17 containing further program instructions that when executed, cause a computer to:

receive an aggregation parameter.

19 . The non-transitory computer readable medium of claim 17 containing further program instructions that when executed, cause a computer to:

display a data filter graphical user interface;

receive an aggregation clause selection from the user;

display an aggregation clause corresponding to the aggregation clause selection in the data filter graphical user interface;

receive a user application selection;

generate a second updated visual graph by filtering the updated visual graph using the aggregation clause selection; and

cause the second updated visual graph to be displayed in the schema explorer graphical user interface of the computing device of the user.

20 . The non-transitory computer readable medium of claim 17 containing further program instructions that when executed, cause a computer to:

receive, via the computing device of the user, a selection of a second table node; and cause the schema explorer graphical user interface to be displayed in the display device of the computing device of the user, wherein the schema explorer graphical user interface includes the visual graph of the first database including at least the second table node, wherein the visual graph of the first database is filtered according to the indication of the user including the at least one query parameter.