For an updateable view that is defined for a first database, a non-transitory machine readable medium storing a program which when executed by at least one processing unit, processes an update to data tuples in a second database, the update specified by reference to the updateable view, the program comprising sets of instructions for:
- from a client, receiving a first query for modifying a particular data tuple presented in the updateable view;
- from a metadata storage, retrieving a definition of the updateable view, said definition comprising a reference to a first set of one or more objects associated with the particular data tuple in the first database;
- based on the retrieved definition, generating a second query referencing a second set of one or more objects associated with the particular data tuple in the second database;
- and
- executing the generated second query on the second database to modify the particular data tuple in the second database.