Patent ID: 8782075
Filing Date: 2014-07-15
Classification: G06F

Abstract:
1. A database access method comprising: (1) receiving a database query relating to data which is stored in each of a first database and a second database, wherein the first database and the second database are two separate and discrete databases, wherein the first database is managed by a first database management system that includes a first query processor configured to execute queries directed to the first database, wherein the second database is managed by a second database management system that is distinct from the first database management system, the second database management system including a second query processor configured to execute queries directed to the second database, wherein at least one attribute of the data stored in the first database is stored in columnar form, and wherein none of the attributes of the data stored in the second database are stored in columnar form; (2) determining, externally from each of the first database management system and the second database management system, if the database query is to be executed on the first database or the second database based on the processing required by the database query and the form in which data is stored by the first and second database management systems, the determining comprising, checking if the database query involves computation of an aggregation and determining that the database query is to be executed on the first database responsive to the database query involving computation of an aggregation; and (3) providing the database query to the first query processor or the second query processor based on the determination made in operation (2).