Optimization of first set of ordered items
Systems and methods for retrieving a set of ordered items from a distributed database. A plurality of ordered items may be stored at a cache. The plurality of ordered items may have a length of N+B at a first instant in time. A first instruction to delete a first item of the plurality of ordered items may be received. A second instruction to add a second item to the plurality of ordered items may be received. The first instruction and the second instruction may be stored in a change log. A request for the first N items of the plurality of ordered items may be received. The first instruction may be executed by deleting the first item from the plurality of ordered items. The second instruction may be executed by adding the second item to the plurality of ordered items. The first N items of the plurality of ordered items may be sent in response to the request.
1. A computer-implemented method comprising:
storing a plurality of ordered items at a storage medium, wherein the plurality of ordered items has a length of at least N at a first instant in time; N being a positive integer;
receiving a first instruction to delete a first item of the plurality of ordered items;
receiving a second instruction to add a second item to the plurality of ordered items;
storing the first instruction and the second instruction;
receiving a request for a first N items of the plurality of ordered items; and
in response to receiving the request:
executing the first instruction by deleting the first item from the plurality of ordered items;
executing the second instruction by adding the second item to the plurality of ordered items; and
sending the first N items of the plurality of ordered items.
2. The computer-implemented method of claim 1 , wherein the first instruction and the second instruction are stored in a change log.
3. The computer-implemented method of claim 1 , wherein:
deleting the first item from the plurality of ordered items causes the length of the plurality of ordered items to decrease by one; and
adding the second item to the plurality of ordered items causes the length of the plurality of ordered items to increase by one.
4. The computer-implemented method of claim 1 , further comprising:
receiving a third instruction to update a third item of the plurality of ordered items;
storing the third instruction; and
executing the third instruction by updating the third item of the plurality of ordered items.
5. The computer-implemented method of claim 1 , wherein the storage medium is a cache.
6. The computer-implemented method of claim 5 , wherein the plurality of ordered items has a length of less than N at a second instant in time, and wherein the computer-implemented method further comprises:
invaliding the cache; and
rebuilding the cache such that the plurality of ordered items has a length of N+B; B being a positive integer.
7. The computer-implemented method of claim 1 , wherein sending the first N items occurs after executing the first instruction and executing the second instruction.
8. A non-transitory computer-readable storage media comprising instructions that, when executed by one or more processors, cause the one or more processors to perform operations comprising:
storing a plurality of ordered items at a storage medium, wherein the plurality of ordered items has a length of at least N at a first instant in time; N being a positive integer;
receiving a first instruction to delete a first item of the plurality of ordered items;
receiving a second instruction to add a second item to the plurality of ordered items;
storing the first instruction and the second instruction;
receiving a request for a first N items of the plurality of ordered items; and
in response to receiving the request:
executing the first instruction by deleting the first item from the plurality of ordered items;
executing the second instruction by adding the second item to the plurality of ordered items; and
sending the first N items of the plurality of ordered items.
9. The non-transitory computer-readable storage media of claim 8 , wherein the first instruction and the second instruction are stored in a change log.
10. The non-transitory computer-readable storage media of claim 8 , wherein:
deleting the first item from the plurality of ordered items causes the length of the plurality of ordered items to decrease by one; and
adding the second item to the plurality of ordered items causes the length of the plurality of ordered items to increase by one.
11. The non-transitory computer-readable storage media of claim 8 , wherein the operations further comprise:
receiving a third instruction to update a third item of the plurality of ordered items;
storing the third instruction; and
executing the third instruction by updating the third item of the plurality of ordered items.
12. The non-transitory computer-readable storage media of claim 8 , wherein the storage medium is a cache.
13. The non-transitory computer-readable storage media of claim 12 , wherein the plurality of ordered items has a length of less than N at a second instant in time, and wherein the operations further comprise:
invaliding the cache; and
rebuilding the cache such that the plurality of ordered items has a length of N+B; B being a positive integer.
14. The non-transitory computer-readable storage media of claim 8 , wherein sending the first N items occurs after executing the first instruction and executing the second instruction.
15. A system comprising:
one or more processors; and
a storage device comprising instructions that, when executed by the one or more processors, cause the one or more processors to perform operations comprising:
storing a plurality of ordered items at a storage medium, wherein the plurality of ordered items has a length of at least N at a first instant in time; N being a positive integer;
receiving a first instruction to delete a first item of the plurality of ordered items;
receiving a second instruction to add a second item to the plurality of ordered items;
storing the first instruction and the second instruction;
receiving a request for a first N items of the plurality of ordered items; and
in response to receiving the request:
executing the first instruction by deleting the first item from the plurality of ordered items;
executing the second instruction by adding the second item to the plurality of ordered items; and
sending the first N items of the plurality of ordered items.
16. The system of claim 15 , wherein the first instruction and the second instruction are stored in a change log.
17. The system of claim 15 , wherein:
deleting the first item from the plurality of ordered items causes the length of the plurality of ordered items to decrease by one; and
adding the second item to the plurality of ordered items causes the length of the plurality of ordered items to increase by one.
18. The system of claim 15 , wherein the operations further comprise:
receiving a third instruction to update a third item of the plurality of ordered items;
storing the third instruction; and
executing the third instruction by updating the third item of the plurality of ordered items.
19. The system of claim 15 , wherein the storage medium is a cache.
20. The system of claim 15 , wherein sending the first N items occurs after executing the first instruction and executing the second instruction.