1. A computer-implemented method comprising: accessing in a non-transitory computer readable storage medium, a database created in an application level language and comprising a row store table and a column store table having a column dictionary; retrieving one or more records from the row store table; generating a value array from data in the records retrieved from the row store table; using the value array, accessing a plurality of value ids from the column dictionary of the column store table that correspond to values in the value array; using the value ids and the row store table, generating a vid-rid table comprising a column that contains the value ids from the column store table and a column that contains row ids of rows in the row store table that contain the values corresponding to the values ids; using the value ids, generating a doc id array of doc ids of records in the column store table that contain the value ids; and performing at least an inner join operation using the doc id array and row ids in the vid-rid table to produce a plurality of row id and doc id pairs.