EP 2082317 A4 20101006 - SYSTEM AND METHOD FOR DISTRIBUTING QUERIES TO A GROUP OF DATABASES AND EXPEDITING DATA ACCESS
Title (en)
SYSTEM AND METHOD FOR DISTRIBUTING QUERIES TO A GROUP OF DATABASES AND EXPEDITING DATA ACCESS
Title (de)
SYSTEM UND VERFAHREN ZUM VERTEILEN VON ANFRAGEN AN EINE GRUPPE VON DATENBANKEN UND ZUM BESCHLEUNIGEN DES DATENZUGRIFFS
Title (fr)
SYSTÈME ET PROCÉDÉ POUR DISTRIBUER DES DEMANDES À UN GROUPE DE BASES DE DONNÉES ET ACCÉLÉRER UN ACCÈS À DES DONNÉES
Publication
Application
Priority
- US 2007083164 W 20071031
- US 86380106 P 20061031
- US 92978907 A 20071030
Abstract (en)
[origin: WO2008055202A2] 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.
IPC 8 full level
G06F 7/00 (2006.01); G06F 17/30 (2006.01)
CPC (source: EP)
G06F 16/24539 (2018.12); G06F 16/24556 (2018.12); G06F 16/2462 (2018.12); G06F 16/283 (2018.12)
Citation (search report)
- [XI] US 2004215626 A1 20041028 - COLOSSI NATHAN GEVAERD [US], et al
- [I] US 5978788 A 19991102 - CASTELLI VITTORIO [US], et al
- [E] US 2008270363 A1 20081030 - HUNT HERBERT DENNIS [US], et al
- See references of WO 2008055202A2
Designated contracting state (EPC)
AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IS IT LI LT LU LV MC MT NL PL PT RO SE SI SK TR
DOCDB simple family (publication)
WO 2008055202 A2 20080508; WO 2008055202 A3 20080814; CA 2701173 A1 20080508; EP 2082317 A2 20090729; EP 2082317 A4 20101006
DOCDB simple family (application)
US 2007083164 W 20071031; CA 2701173 A 20071031; EP 07871310 A 20071031