In a federated system, a logical table object that is used to cache data from a data source table. A cache table comprises a nickname that identifies the data source table, one or more materialised query tables, and a schedule for replicating the data in each materialised query table.