1. A computer-implemented method comprising: providing in a non-transitory computer readable storage medium, a database created in an application level language and comprising row partitioned store and column partitioned store; causing a row engine to insert records into the row partitioned store; performing an optimization based upon additional information to check for a uniqueness violation only if there are uniqueness constraints; and selectively moving data from the row partitioned store to the column partitioned store when one or more criteria according to a data movement policy are met.