1. A computer-implemented method for dynamically partitioning and storing data in a database, the method comprising: defining a plurality of subsets corresponding to an attribute; creating a first table in a database, the first table corresponding to data values that are members of a first subset of the plurality of subsets; receiving a first insert statement, the first insert statement including a first data value that is a member of the first subset; transforming the first insert statement into a transformed first insert statement; executing the transformed first insert statement to insert the first data value into the first table; receiving a second insert statement, the second insert statement including a second data value that is a member of the first subset; detecting a trigger event corresponding to the first table; based on the detecting, creating a second table in the database, the second table corresponding to data values that are members of the first subset; transforming the second insert statement into a transformed second insert statement; and executing the transformed second insert statement to insert the second data value into the second table.