SYSTEM AND METHOD FOR DISTRIBUTING QUERIES TO A GROUP OF DATABASES AND EXPEDITING DATA ACCESS

摘要

Disclosed are systems, methods, and computer readable media for distributing queries to a group of databases and expediting data access. The method embodiment comprises receiving a query for information from one or more databases, and returning a result to the query for information requested in the query from a hybrid database, the hybrid database being constructed by the steps comprising: (1) identifying one or more source member databases where query acceleration is required, (2) identifying one or more common dimensions or grouping patterns in a plurality of databases, (3) creating one or more sets of commonly occurring common dimensions, (4) building one or more multi¬ dimensional databases using the one or more sets of commonly occurring common dimensions, (5) building one or more fractional databases, (6) compacting the one or more fractional databases into a master fractional database, (7) building a hybrid database metadata repository combining metadata from the master fractional database and the one or more multi-dimensional databases and source databases together referred to as derived member databases, and (8) building a query governor to interface between the query, the hybrid database metadata repository, the plurality of databases, the master fractional database, and the one or more multi-dimensional databases.