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 a record into the row partitioned store; performing an optimization based upon additional information to determine that a uniqueness violation may exist with respect to the record; when it is determined that a uniqueness violation may exist, performing a search of the column partitioned store to determine whether a uniqueness violation exists with respect to the record; receiving a query on the database; performing a search on the row partitioned store of the database using the query; selectively searching the column partitioned store using the query depending on an analysis of the search performed on the row partitioned store; and returning a search result.