Efficient storage and retrieval of two-dimensional data in the JVM database
source link: https://www.codesd.com/item/efficient-storage-and-retrieval-of-two-dimensional-data-in-the-jvm-database.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Efficient storage and retrieval of two-dimensional data in the JVM database
I need to store 2 dimensional data, that is points (x,y) in a database. What I mean by database is that the data needs to have some persistence to disk, its ok if it flushes now and then.
Most of my queries are going to be to find the points within a rectangle. So this would be a query to find all Point's where ( Xa < Point < Xb AND Ya < Point < Yb).
It would be best if the database is within the JVM rather than having to call out to a server database.
Also it would be good if it does efficient caching.
Need to store data on disk at some point, the data needs to persist after my software has exited.
Need to query LARGE data, terabytes of points.
I think you are looking for some in-memory database like HSQLDB, Java DB.
Related Articles
How to optimally record snapshots of the two-dimensional array in the sql database
PHP: Filtering and exporting large amounts of data from the MySQL database
What is the most efficient way to copy primitive two-dimensional arrays in Java?
Get the two consecutive dates with the greatest period between them
Run MongoDB and Redis on two different containers in the same host machine
Search for a two-dimensional array using the Length property
How do I declare a two-dimensional array with the & lt; array & gt; on your mind?
How to sort a two-dimensional array by the length of the internal arrays in PHP?
Swift3: How to load data from the external database using PHP and Swift 3
Insert the UTC / GMT date into the Oracle database with Java and Spring
C # Fastest way to insert data into the SQL database
Saving statistical data in the MySQL database for a line graph
How can I get data from the Firebase database without triggering an event?
Best approach for transferring data from the remote database to the local database
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK