Columnwise storage of point data
A database query of point data among two or more axes of a database is received. The database stores point data in distinct integer vectors with a shared dictionary. Thereafter, the dictionary is scanned to determine boundaries for each axis specified by the query. In response, results characterizing data responsive to the query within the determined boundaries for each axis are returned. Related apparatus, systems, techniques and articles are also described.
1. A computer-implemented method comprising:
receiving a database query of point data among two or more axes of a database, the database storing point data in distinct integer vectors with a shared dictionary, wherein coordinates for the point data are stored individually in an order in which they have been inserted into the database;
scanning the dictionary to determine boundaries for each axis specified by the query, wherein at least a portion fo the scanning for each axis is performed in parallel; and
returning results characterizing data responsive to the query within the determined boundaries for each axis.
2. A method as in claim 1 , wherein the database is a column oriented database storing data in a columnwise manner.
3. A method as in claim 2 , wherein the database is an in-memory database.
4. A method as in claim 1 , further comprising:
generating, for each axis, a bit vector identifying all points within the corresponding boundaries; and
merging all of the bit vectors to generate a query window, the query window being used to identify results responsive to the query.
5. A method as in claim 1 , wherein the point data characterizes geometric attributes of data.
6. A method as in claim 5 , wherein the geometric attributes comprise one or more of location when data was acquired or shape of acquired data.
7. A method as in claim 1 , wherein the point data characterizes topology attributes of data.
8. A method as in claim 7 , wherein the topology attributes characterize spatial adjacency in relation to other data points.
9. A method as in claim 1 , wherein the receiving, scanning, and returning are performed by at least one data processor forming part of at least one computing system.
10. A non-transitory computer program product storing instructions, which when executed by at least one data processor of at least one computing system, result in operations comprising:
receiving a database query of point data among two or more axes of a database, the database storing point data in distinct integer vectors with a shared dictionary, the dictionary provide dictionary-based compression, wherein coordinates for the point data are stored individually in an order in which they have been inserted into the database;
scanning the dictionary to determine boundaries for each axis specified by the query, wherein at least a portion fo the scanning for each axis is performed in parallel; and
returning results characterizing data responsive to the query within the determined boundaries for each axis.
11. A computer program product as in claim 10 , wherein the database is a column oriented database storing data in a columnwise manner.
12. A computer program product as in claim 11 , wherein the database is an in-memory database.
13. A computer program product as in claim 10 , wherein the operations further comprise:
generating, for each axis, a bit vector identifying all points within the corresponding boundaries; and
merging all of the bit vectors to generate a query window, the query window being used to identify results responsive to the query.
14. A computer program product as in claim 10 , wherein the point data characterizes geometric attributes of data.
15. A computer program product as in claim 14 , wherein the geometric attributes comprise one or more of location when data was acquired or shape of acquired data.
16. A computer program product as in claim 10 , wherein the point data characterizes topology attributes of data.
17. A computer program product as in claim 16 , wherein the topology attributes characterize spatial adjacency in relation to other data points.
18. A system comprising:
a column-oriented in-memory database storing data columnwise, the stored data comprising coordinates that are stored in an order corresponding to when they were inserted into the in-memory database;
one or more data processors;
memory storing instructions, which when executed, cause at least one data processor to perform operations comprising:
receiving a database query of point data among two or more axes, the database storing point data in distinct integer vectors with a shared dictionary;
scanning the dictionary to determine boundaries for each axis specified by the query; and
returning results characterizing data responsive to the query within the determined boundaries for each axis.
19. A system as in claim 18 , wherein the operations further comprise:
generating, for each axis, a bit vector identifying all points within the corresponding boundaries; and
merging all of the bit vectors to generate a query window, the query window being used to identify results responsive to the query.
20. A system as in claim 18 , wherein the point data characterizes geometric attributes of data that comprise one or more of location when data was acquired or shape of acquired data.