Map intelligence for mapping data to multiple processing units of database systems

A non-transitory computer readable storage medium storing at least executable code that when executed:

• obtains at least one map that at least:
• (a) associates multiple distinct portions of data of the database to multiple distinct containers, and (b) also associates each one the multiple distinct containers to one or more of multiple processing units of a database system for processing the data of the database that is associated with its respective associated distinct container, wherein each one of the multiple distinct containers is associated with at least one of the multiple distinct portions of data of the database, thereby the containers effectively containing multiple distinct portions of data of the database, wherein each one of the multiple distinct portions of data of the database includes at least a part of one or more database tables of the database, and wherein the associating of multiple distinct portions of the data of the database to multiple distinct containers by the obtained map further comprises:
• mapping the entire content of at least one database table of the database to at least one of the multiple distinct containers;
• assigns, by the one or more processors of the database system, at least partially based on the obtained at least one map, one or more of the multiple distinct portions of data of the database, assigned by the at least one map, to one or more of the multiple processing units for processing of the multiple distinct portions of data of the database by the one or more of the assigned multiple processing units as assigned by the at least one obtained map, wherein the assigning by the database system uses only the at least one map to assign one or more of the multiple distinct portions data of the database to the one or more of the multiple processing units for processing by the multiple processing units in parallel, and wherein the same distinct portion of data of the database is mapped to multiple distinct containers by multiple maps at the same time, wherein the at least one map includes at least one status, and wherein the at least one status includes two states:
• an active state, and an inactive state;
• receives, by the database system, a database query of the data of database including the one or more of the multiple distinct data portions assigned by the at least one map;
• and
• thereafter, processes, by the one or more of the multiple processing units of the database system, at least partially based on the at least one obtained map, the one or more respectively assigned multiple distinct portions of data of the database, in response to the database query.

A database system, comprising:

• one or more processors that effectively provide multiple processing units each configured to process at least a portion of the data of the database, wherein the one or more processors are configured to:
• obtain at least one map that at least:
• (a) associates multiple distinct portions of data of the database to multiple distinct containers, and (b) also associates each one the multiple distinct containers to one or more of multiple processing units of a database system for processing the data of the database that is associated with its respective associated distinct container, wherein each one of the multiple distinct containers is associated with at least one of the multiple distinct portions of data of the database, thereby the containers effectively containing multiple distinct portions of data of the database, wherein each one of the multiple distinct portions of data of the database includes at least a part of one or more database tables of the database, and wherein the associating of multiple distinct portions of the data of the database to multiple distinct containers by the obtained map further comprises:
• mapping the entire content of at least one database table of the database to at least one of the multiple distinct containers;
• assign, by the one or more processors of the database system, at least partially based on the obtained at least one map, one or more of the multiple distinct portions of data of the database, assigned by the at least one map, to one or more of the multiple processing units for processing of the multiple distinct portions of data of the database by the one or more of the assigned multiple processing units as assigned by the at least one obtained map, wherein the assigning by the database system uses only the at least one map to assign one or more of the multiple distinct portions data of the database to the one or more of the multiple processing units for processing by the multiple processing units in parallel, and wherein the same distinct portion of data of the database is mapped to multiple distinct containers by multiple maps at the same time, wherein the at least one map includes at least one status, and wherein the at least one status includes two states:
• an active state, and an inactive state;
• receive, by the database system, a database query of the data of database including the one or more of the multiple distinct data portions assigned by the at least one map;
• and
• thereafter, process, by the one or more of the multiple processing units of the database system, at least partially based on the at least one obtained map, the one or more respectively assigned multiple distinct portions of data of the database, in response to the database query.