Extended computerized query language syntax for analyzing multiple tabular data arrangements in data-driven collaborative projects
Various embodiments relate generally to data science and data analysis, computer software and systems, and wired and wireless network communications to interface among repositories of disparate datasets and computing machine-based entities configured to access datasets, and, more specifically, to a computing and data storage platform configured to provide one or more computerized tools that facilitate development and management of data projects, including implementation of extended computerized query language syntax to analyze, for example, multiple tabular data arrangements in data-driven collaborative projects. For example, a method may include generating data to present a query editor in a data project interface, receiving data representing a first query command to select one or more subsets of data, identifying in the data representing a second query command a subset of datasets from which to extract the data, and applying a query based on a first query command and a second query command.
1. A method comprising:
receiving data representing one or more characters to implement a multi-table syntax based on a computerized query language syntax;
identifying a portion of multiple file identifiers including a data pattern associated with each of the datasets;
implementing one or more variable characters as variable for the portion of multiple file identifiers;
detecting one or more explicit selections to target subsets of data in the subset of datasets that otherwise is implemented in accordance with a first query command;
implementing the one or more explicit selections to target any subsets of data in association with a second query command;
applying a query based on the first query command and the second query command to a subset of datasets, at least one subset of the datasets formatted as a triple-based dataset; and
executing instructions to access data from multiple tabular data arrangements responsive to identification of the multiple tabular data arrangements in-situ in query formation.
2. The method of claim 1 further comprising:
forming a query including either the first or the second query command implementing an extended query command.
3. The method of claim 2 further comprising:
performing the query in-situ at a point in time at which the query is identified.
4. The method of claim 1 further comprising:
applying a query based on the first query command and the second query command to a subset of datasets, at least one subset of the datasets including a graph data arrangement.
5. The method of claim 1 wherein the query is performed responsive to identifying multiple tabular data arrangements in-situ at a point in time at which the query is written or formed.
6. The method of claim 1 further comprising:
forming a query via a data project interface responsive to data presented at a remote computing interface.
7. The method of claim 1 wherein the implementing the one or more variable characters comprises:
implementing a string of characters.
8. The method of claim 1 further comprising:
mapping data values between at least one ingested tabular data arrangement and a graph data arrangement to identify datasets as blocks of data.
9. The method of claim 8 further comprising:
rewriting a relational-based query to include a graph-based query,
wherein at least one of the first query command and the second query command is implemented as one of the relational-based query and the graph-based query.
10. A system comprising:
a memory configured to store executable instructions to implement computerized tools including a data project interface; and
a processor configured to execute at least a subset of the instructions, the processor configured to:
receive data representing one or more characters to implement a multi-table syntax based on a computerized query language syntax;
identify a portion of multiple file identifiers including a data pattern associated with each of the datasets;
implement one or more variable characters as variable for the portion of multiple file identifiers;
detect one or more explicit selections to target subsets of data in the subset of datasets that otherwise is implemented in accordance with a first query command;
implement the one or more explicit selections to target any subsets of data in association with a second query command;
apply a query based on the first query command and the second query command to a subset of datasets, at least one subset of the datasets formatted as a triple-based dataset; and
execute the subset of the instructions to access data from multiple tabular data arrangements responsive to identification of the multiple tabular data arrangements in-situ in query formation.
11. The system of claim 10 , wherein the processor is further configured to:
form a query including either the first or the second query command implementing an extended query command.
12. The system of claim 11 , wherein the processor is further configured to:
perform the query in-situ at a point in time at which the query is identified.
13. The system of claim 10 , wherein the processor is further configured to:
apply a query based on at least one of the first query command and the second query command to a subset of datasets, at least one subset of the datasets formatted as a triple-based dataset.
14. The system of claim 10 , wherein the processor is further configured to:
apply a query based on at least one of the first query command and the second query command to a subset of datasets, at least one subset of the datasets including a graph data arrangement.
15. The system of claim 10 wherein the query is performed responsive to identifying multiple tabular data arrangements in-situ at a point in time at which the query is written or formed.
16. The system of claim 10 , wherein the processor is further configured to:
form a query via a data project interface responsive to data presented at a remote computing interface.
17. The system of claim 10 wherein the processor configured to implement the one or more variable characters is further configured to:
implement a string of characters.
18. The system of claim 10 , wherein the processor is further configured to:
map data values between at least one ingested tabular data arrangement and a graph data arrangement to identify datasets as blocks of data.
19. The system of claim 18 , wherein the processor is further configured to:
rewrite a relational-based query to include a graph-based query,
wherein at least one of the first query command and the second query command is implemented as one of the relational-based query and the graph-based query.