公开(公告)号：GB2459354A

公开(公告)日：2009-10-28

申请号：GB0905817

申请日：2009-04-03

Applicant: IBM

Inventor： STOLZE KNUT ,  DRAESE OLIVER ,  STAEBLER BENNO ,  STEINBACH TORSTEN

IPC: G06F17/30

Abstract: Emulating a plurality of databases (logical databases 205, 206, 207) using a single physical database 208. A database system (110, fig 1) comprising a plurality of databases (103, fig 1) on a plurality of servers, each database coupled to at least one application 201-203 (101, fig 1) of a set of applications. Consolidation of such a system to a single physical database comprises substituting all logical names from the plurality of databases with a unique physical name for all the plurality of databases. A mapping catalogue (106, fig 1; 316, fig 3) is created which comprises the logical names and their assigned unique physical names, the mapping catalogue being located in a physical layer. Each database is saved with its unique physical names into a different segment 209-211 of the single database 208, the single database being located in the physical layer. A consolidation layer 204 is provided which is coupled to each application 201-203. A separate consolidation layer (105, fig 1; 306-310, fig 3) is provided for each application and is coupled to the mapping catalogue and to the single database. The consolidation layer is adapted to receive queries from the applications, search the mapping catalog, rewrite the queries and forward the rewritten queries to the single database. The response from the single database may also be rewritten. The plurality of databases are simulated as logical databases and consolidation is transparent for the applications.