Invention Grant
- Patent Title: Emulation of database updateable views for migration to a different database
-
Application No.: US16542143Application Date: 2019-08-15
-
Publication No.: US11269824B1Publication Date: 2022-03-08
- Inventor: Florian Michael Waas , Dmitri Korablev , Lyublena Rosenova Antova , Mohamed Soliman , Michael Alexander Duller
- Applicant: Datometry, Inc.
- Applicant Address: US CA San Francisco
- Assignee: Datometry, Inc.
- Current Assignee: Datometry, Inc.
- Current Assignee Address: US CA San Francisco
- Agency: Adeli LLP
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/21 ; G06F16/2458 ; G06F16/23 ; G06F16/28

Abstract:
For an updateable view that is defined for a first database, some embodiments provide an automated method for processing an update to data tuples in a second database, the update specified by reference to the updateable view. The method receives a first query from a client for modifying a particular data tuple presented in the updateable view. From a metadata storage, the method retrieves a definition of the updateable view, where the definition includes 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, the method generates a second query referencing a second set of one or more objects associated with the particular data tuple in the second database. The method executes the generated second query on the second database, to modify the particular data tuple in the second database.
Information query