Computer data system current row position query language construct and array processing query language constructs
Described are methods, systems and computer readable media for providing a current row position query language construct and array processing query language constructs and associated processing.
1. A system comprising:
one or more hardware processors;
an electronic computer readable data storage device coupled to the one or more hardware processors, the electronic computer readable data storage device having stored thereon software instructions that, when executed by the one or more hardware processors, cause the one or more hardware processors to perform operations for improving the functionality of computer data system query language code execution via compilation of query language constructs, the operations including:
accessing, at the one or more hardware processors, computer data system query language code stored in the electronic computer readable data storage device, the computer data system query language code including a current row value and a current data storage location value associated with a data object, wherein the current row value and the current data storage location value are constructs of a computer data system query language;
parsing, at the one or more hardware processors, the computer data system query language code into a parsed query language structure;
generating, at the one or more hardware processors, computer programming language code based on the parsed query language structure, the computer programming language code including computer programming language functions that are mapped to usages of the current row value and the current data storage location value, wherein the generated computer programming language code and the computer programming language functions are compiled;
executing, at the one or more hardware processors, the compiled computer programming language code;
determining, at the one or more hardware processors, based on execution of the compiled computer programming language code, a return data storage location value from the computer programming language functions corresponding to the current data storage location value, the return data storage location value representing a current data storage location of the data object corresponding to a query language construct at a time of execution of the compiled computer programming language code;
when one or more data sources that the data object depends on are updated, subsequently executing, at the one or more hardware processors, the compiled computer programming language code, including a portion of computer programming language code corresponding to the current data storage location, wherein the updating includes one or more of adding, modifying, deleting, or re-indexing the one or more data sources that the data object depends on; and
determining, at the one or more hardware processors, based on the subsequent execution of the compiled computer programming language code, a new return data storage location value from the computer programming language functions corresponding to the current data storage location value, the new return data storage location value representing an updated current data storage location of the data object corresponding to another query language construct at a subsequent time of execution of the compiled computer programming language code.
2. The system of claim 1 , wherein the computer data system query language code includes a vector access query language construct configured to permit access to a vector representing an entire column of data values.
3. The system of claim 2 , wherein the access includes one or more of absolute indexing and relative indexing.
4. The system of claim 2 , wherein the vector access query language construct includes one or more of passing by reference, passing by value, slicing, length retrieval or element retrieval.
5. The system of claim 1 , wherein the current row value of the data object is updated once the data sources providing data for the data object have been updated.
6. The system of claim 1 , wherein the executing and determining are performed as part of a real time data system query.
7. The system of claim 1 , wherein the operations further include mapping the current row value to the current data storage location value within a data source providing data for the data object.
8. The system of claim 1 , wherein the computer data system query language code includes code retrieving data from one or more data object positions other than the current row value in order to compute a time series operation.
9. A system comprising:
one or more hardware processors;
an electronic computer readable data storage device coupled to the one or more hardware processors, the electronic computer readable data storage device having stored thereon software instructions that, when executed by the one or more hardware processors, cause the one or more hardware processors to perform operations for improving the functionality of computer data system query language code, the operations including:
accessing, at the one or more hardware processors, computer data system query language code stored in the electronic computer readable data storage device, the computer data system query language code including an array processing query language construct including at least a portion of data within a data object as a parameter;
parsing, at the one or more hardware processors, the computer data system query language code into a parsed query language structure;
generating, at the one or more hardware processors, computer programming language code based on the parsed query language structure, the computer programming language code including a portion of computer programming language code corresponding to the array processing query language construct associated with the data object;
executing, at the one or more hardware processors, the computer programming language code, including the portion of computer programming language code corresponding to the array processing query language construct associated with the data object;
determining, at the one or more hardware processors, based on execution of the computer programming language code, a return value from the portion of computer programming language code corresponding to the array processing query language construct associated with the data object, the return value including transformed data from the data object;
when one or more data sources that the data object depends on are updated, subsequently executing, at the one or more hardware processors, the computer programming language code, including the portion of computer programming language code corresponding to the array processing query language construct associated with the data object; and
determining, at the one or more hardware processors, based on the subsequent execution of the computer programming language code, a new return value from the portion of computer programming language code corresponding to the array processing query construct associated with the data object, the new return value including updated transformed data from the data object at a subsequent time of execution of the computer programming language code.
10. The system of claim 9 , wherein the array processing query language construct includes a column-to-array query language construct and the transformed data includes array data transformed from column data.
11. The system of claim 9 , wherein the array processing query language construct includes an array-to-column query language construct and the transformed data includes column data transformed from array data.
12. The system of claim 10 , wherein the operations further include performing a vector operation on the array data.
13. The system of claim 10 , wherein the computer data system query language code includes a vector access query language construct configured to permit access to a vector formed by a column-to-array operation based on the column-to-array query language construct.
14. The system of claim 13 , wherein the access includes one or more of absolute indexing and relative indexing.
15. The system of claim 9 , wherein the executing and determining are performed as part of a real time data system query.
16. The system of claim 13 , wherein the vector access query language construct includes one or more of passing by reference, passing by value, slicing, length retrieval or element retrieval.
17. A nontransitory computer readable medium having stored thereon software instructions that, when executed by one or more hardware processors, cause the one or more hardware processors to perform operations, the operations including:
accessing, at the one or more hardware processors,
computer data system query language code stored in the electronic computer readable data storage device, the computer data system query language code including a current row value and a current data storage location value associated with a data object, wherein the current row value and the current data storage location value are constructs of a computer data system query language;
parsing, at the one or more hardware processors, the computer data system query language code into a parsed query language structure;
generating, at the one or more hardware processors, computer programming language code based on the parsed query language structure, the computer programming language code including computer programming language functions that are mapped to usages of the current row value and the current data storage location value, wherein the generated computer programming language code and the computer programming language functions are processed, thereby improving the functionality of computer data system query language code execution;
executing, at the one or more hardware processors, the processed computer programming language code;
determining, at the one or more hardware processors, based on execution of the processed computer programming language code, a return index value from the computer programming language functions corresponding to the current row value, the return index value representing a current data storage location of the data object corresponding to a query language construct at a time of execution of the processed computer programming language code;
when one or more data sources that the data object depends on are updated, subsequently executing, at the one or more hardware processors, the processed computer programming language code, including a portion of computer programming language code corresponding to the current row value, wherein the updating includes one or more of adding, modifying, deleting, or re-indexing the one or more data sources that the data object depends on; and
determining, at the one or more hardware processors, based on the subsequent execution of the processed computer programming language code, a new return index value from the computer programming language functions corresponding to the current row value, the new return index value representing an updated current data storage location of the data object corresponding to another query language construct at a subsequent time of execution of the processed computer programming language code.
18. The nontransitory computer readable medium of claim 17 , wherein the computer data system query language code includes a vector access query language construct configured to permit access to a vector representing an entire column of data values.
19. The nontransitory computer readable medium of claim 17 , wherein the current row value of the data object is updated once the data sources providing data for the data object have been updated.
20. The nontransitory computer readable medium of claim 17 , wherein the computer data system query language code includes code retrieving data from one or more data object positions other than the current row value in order to compute a time series operation.