Patent ID: 8732159

Claim:
A non-transitory computer-readable medium containing instructions to configure at least one processor to perform operations comprising: receiving an indication of a defined outer join to enable obtaining a first database table at a first database and a second database table at a second database, the indication containing a first instruction for obtaining the first database table and a second instruction for obtaining the second database table, wherein the first database comprises at least one of an in-memory database and a column-based database and the second database comprises a persistent relational database; sending a first request to the first database to obtain the first database table, the first request including the first instruction converted into a first format associated with the first type of the first database table; sending a second request to the second database to obtain the second database table, the second request including the second instruction converted into a second format associated with the second type of the second database table; receiving, in response to the first and second requests, each of the first and second database tables; performing an outer join on the received first and second database tables based on at least one predetermined definition associated with the outer join, the outer join forming an output database table, the output database table being formed based on a field catalog containing information about all database tables in the first database and the second database; and providing the output database table.