Systems and methods for client-side data analysis
Systems and methods are provided for analyzing data in one or more datasets, where the one or more datasets are embodied as local, embedded databases in a client-side application, such as a web browser or web browser tab. A client-side data analysis application or artifact may be used to interact, i.e., query, the local, embedded databases, and retrieve results to analyze data. Because the one or more datasets are localized, there is no need to access a remote database/datastore in order to analyze the data. Moreover, the client-side data analysis application or artifact can be executed as individual instances in the client-side application. The state of a local, embedded database may be stored as another file that can be used as a local, embedded database for another instance of the client-side data analysis application or artifact.
1. A system comprising:
one or more processors; and
a memory storing instructions that, when executed by the one or more processors, cause the system to:
translate data files into a local embedded database stored at a client-side application;
execute an instance of a client-side data analysis artifact within the client-side application to analyze the local embedded database without an active network connection to a remote database or a remote server, wherein the instance of the client-side data analysis artifact comprises a browser tab operating in a sandboxed environment;
receive a data analysis query, through the instance of the client-side data analysis artifact, to analyze the dataset;
process the data analysis query using the local embedded database;
store a result of the data analysis query in the local embedded database;
capture a state of the local embedded database including the result of the data analysis query; and
export the captured state of the local embedded database to the remote database or the remote server upon restoration of the active network connection.
2. The system of claim 1 , wherein the client-side data analysis artifact comprises a first client-side data analysis artifact; and the instructions, when executed, further cause to the system to:
execute a second client-side data analysis artifact, the second client-side data analysis artifact being executed in a second client-side application, the second client-side data analysis artifact comprising a second local embedded database compiled as an SQLite database.
3. The system of claim 2 , wherein the instructions, when executed, further cause the system to:
import, from the remote database or the remote server, the captured state of the local embedded database to the second client-side analysis artifact in response to receiving a user interaction through the second client-side analysis artifact; and
providing the captured state of the local embedded database as the second local embedded database.
4. The system of claim 3 , wherein the data analysis query comprises a first data analysis query; and the instructions, when executed, further cause the system to:
receive a second data analysis query;
process the second data analysis query using the second client-side data analysis artifact and the second local embedded database; and
store a result of the second data analysis query in the second local embedded database, wherein a state of the second local embedded database is updated based on the result of the second data analysis query.
5. The system of claim 2 , wherein the second client-side data analysis artifact comprises a second instance of the client-side data analysis artifact.
6. The system of claim 5 , wherein the second instance of the client-side data analysis artifact is executed in a second web browser tab.
7. The system of claim 1 , wherein the instructions, when executed, cause the system to:
export the captured state of the local embedded database to a file on the system.
8. The system of claim 1 , wherein the client-side data analysis artifact comprises a data visualization tool adapted to render the result of the data analysis query in at least one of a graphical manner or a tabular manner.
9. The system of claim 7 , wherein the instructions, when executed, further cause the system to:
convert the file comprising data to which the data analysis query is applied into the captured state of the local embedded database.
10. A method being implemented by a computing system including one or more physical processors and a storage media storing machine-readable instructions, the method comprising:
translating data files into a local embedded database stored at a client-side application;
executing an instance of a client-side data analysis artifact within the client-side application to analyze the local embedded database without an active network connection to a remote database or a remote server, wherein the instance of the client-side data analysis artifact comprises a browser tab operating in a sandboxed environment;
receiving a data analysis query via a user interface of the instance of the client-side application, to analyze the dataset;
processing the data analysis query using the local embedded database; and
generating one or more representations of a result of the data analysis query for presentation through the client-side application.
11. The method of claim 10 , wherein the generating the one or more representations of the result of the data analysis query comprises at least one of a textual representation or graphical representation of the result of the data analysis query.
12. The method of claim 10 , further comprising:
exporting a current state of the local embedded database to at least one of a local file, the remote server or the remote database, subsequent to processing the data analysis query.
13. The system of claim 1 , wherein the instance of the client-side data analysis artifact is executed without accessing a remote database or server.
14. The system of claim 1 , wherein the executing an instance further comprises:
in response to processing the data analysis query:
representing the results as a table comprising fields; and
determining a type of graph and a number of divisions of the graph based on a format of one of the fields.
15. A non-transitory memory of a computing system including instructions that, when executed by one or more processors, cause the computing system to:
translate data files into a local embedded database stored at a client-side application;
execute an instance of a client-side data analysis artifact within the client-side application to analyze the local embedded database without an active network connection to a remote database or a remote server, wherein the instance of the client-side data analysis artifact comprises a browser tab operating in a sandboxed environment;
receive a data analysis query, through the instance of the client-side data analysis artifact, to analyze the dataset;
process the data analysis query using the local embedded database;
store a result of the data analysis query in the local embedded database;
capture a state of the local embedded database including the result of the data analysis query; and
export the captured state of the local embedded database to the remote database or the remote server upon restoration of the active network connection.
16. The non-transitory memory of claim 15 , wherein the client-side data analysis artifact comprises a first client-side data analysis artifact; and the instructions, when executed, further cause to the computing system to:
execute a second client-side data analysis artifact, the second client-side data analysis artifact being executed in a second client-side application, the second client-side data analysis artifact comprising a second local embedded database compiled as an SQLite database.
17. The non-transitory memory of claim 16 , wherein the instructions, when executed, further cause to the computing system to:
import, from the remote database or the remote server, the captured state of the local embedded database to the second client-side analysis artifact in response to receiving a user interaction through the second client-side analysis artifact; and
providing the captured state of the local embedded database as the second local embedded database.
18. The system of claim 1 , wherein the local embedded database is compiled as an SQLite database.