A computer-implemented method according to one embodiment includes identifying data to be stored in one or more tables on a bucket, where the bucket is an allocation of a partitioned storage in a node of one or more nodes of a swarm database, the bucket having at least one replica, and where no two identical bucket replicas reside on a single node, assigning an identifier and a data storage hierarchical level to the data, mapping the data to an index and storing the data in accordance with the index and the data storage hierarchical level, the storing including writing the data to a row in one of the one or more tables on the bucket and recording a write operation into a transaction log of the node, receiving a plurality of write operations, and combining a plurality of write tasks of the bucket for a predetermined time period.