Which nosql database will allow me sequential access to data?

Question

Which NoSQL flavor of database technology will allow me sequential access to query data?

Here is a description of what I mean by sequential access:

Imagine there is some data being pumped into the database, and your application's requirement is to process it serially.

I intend to query some documents based on some condition. I issue a query against the instance and get a response that has a finite number of records and a sequence identifier (in case I am interested in getting the next set of similar data - pertaining to the same query).

Hence to retrieve, the next set, I issue the same query and, this time, I'd pass this sequence id along with it. This specifically tells the db engine to get newer records after that sequence. So the db engine, based on some algorithm will give me fresh set of records/data/documents.

Which opensource db engine does this?

The use case is something like my app:

1. open connection
2. queries data
3. caches data
4. closes connection
5. processes data
6. opens connection
7. queries with previously obtained sequence id
8. ...repeats...

Answer 1

You can do that with MongoDB:

1. Fetch first 100 from cursors
2. close connection
3. open connection
4. create new cursor, skip 100 and fetch the next 100

Skipping is done via https://docs.mongodb.com/manual/reference/method/cursor.skip

MongoDB is open source.

Answer 2

I would think that technically, they all do. It comes down to writing your queries correctly to access the data-set you need, and in the right order - via sorting the result, for example.