My requirement is to store historical data for a column for a specific date and use it for trend analysis. How can this be achieved in aerospike.
For time series data, if you want to store an entry to a record, you can create a bin ( column ) to store timestamp, other bins for data, and then create a secondary index on this bin ( column ), then you can use query to get your timestamp and data, this is the simplest way. Another solution is store multiple entries into a record as a block, this solution make you merge a batch entries into one block. In this block, you can use sorted map or sorted list, please refer to Modelling Time-Series Data for Top-Performing Stocks in Aerospike using Sorted Maps | Aerospike. You also can serialize the data into a binary, then put this binary into a sorted list. All solutions can work, it depends on your requirement and Aerospike limitation.