1. A method of organizing a data in a database system comprising: at a swarm database system having one or more nodes comprising one or more processors and memory, the memory of the one or more nodes storing one or more programs to be executed by the one or more processors; identifying data to store in one or more tables on a bucket, wherein the bucket is a allocation of a partitioned storage in a node of the one or more nodes; and assigning to each of the identified data an identifier and a data storage hierarchical level of a plurality of hierarchical levels; and mapping to an index and storing each of the data in accordance with the index and assigned hierarchical level.