I am looking at Aerospike as a system and I had a few questions
-
How similar is AQL to the SQL92 standard? I noticed that the AQL documentation explicitly says that it is not SQL so what are the key differences between AQL and SQL92?
-
I couldn’t really find much information on the buffer pool manager. Would you be able to explain more about the BPM?
-
The Hybrid-Storage documentation says that storage is copy on write. How does this work exactly? What are the advantages of doing copy on write for a typical workload for Aeropsike? I also couldn’t find much information on how logging works. What type of logging does Aerospike use (logical, physical, physiological, etc)?
-
I couldn’t find much information on checkpointing. What type of checkpointing does Aerospike use/support?
-
With configurable levels of consistency, how does concurrency control work on Aerospike?
-
How does query execution actually work in Aerospike? Is it tuple at a time, is it vectorized, is it materialized? What type of query level parallelism is there? Is there inter/intra query parallelism?
Thanks