# US 2019/0171738 A1 · Managing Database Object Schema Virtual Changes

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2019/0171738 A1
- Document ID: US20190171738A1
- Status: Published application
- Kind: A1
- Application number: 15/829,862
- Filed: 2017-12-01
- Published: 2019-06-06
- Earliest claimed: 2017-12-01
- Assignees: International Business Machines Corporation
- Applicants: International Business Machines Corporation
- Inventors: Ke Ke Cai; Zhong Su; Bing Jiang Sun; Shuang YS Yu; Shi Wan Zhao
- Web page: https://patentgrep.com/patent/US20190171738A1

## CPC

- G06F 16/2365: {Ensuring data consistency and integrity}
- G06F 16/211: {Schema design and management}
- G06F 16/213: {with details for schema evolution support}
- G06F 16/2455: Query execution
- G06F 16/248: Presentation of query results
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A virtual change database system that supports iterative and parallel database application development is disclosed. The system stores a common set of base physical data and a plurality of sets of virtual changes. Each set of virtual changes is associated with a database object. A database application may access a database object in the database by using the virtual version of the object to extract the object's data content from the common base physical data. The database system present a first query response to (i) a first application based on the set of base physical data and (ii) a first set of virtual changes for a particular database object, while also presenting a second query response to a second application based on the set of base physical data and a second, different set of virtual changes for the particular database object.

## Claims

### Claim 1

A computer-implemented method for managing a database comprising a set of database objects, the method comprising:
storing a set of base physical data for the database;
storing a plurality of sets of virtual changes for the database objects, each set of virtual changes associated with a database object;
presenting a first query response to a first application based on the set of base physical data and a first set of virtual changes associated with a particular database object; and
presenting a second query response to a second application based on the set of base physical data and a second, different set of virtual changes associated with the particular database object.

### Claim 2 (depends on 1)

The computer-implemented method of claim 1, further comprising:
(i) receiving a change request to the database system from the first application that affects the particular object;
(ii) creating a third set of virtual changes for the particular object based on the received change request; and
(iii) presenting a third query response based on the set of base physical data and the third set of virtual changes for the particular object.

### Claim 3 (depends on 2)

The computer-implemented method of claim 2, further comprising:
determining a validity of the change request from the first application; and
issuing an error notification to the first application when the change request is not valid.

### Claim 4 (depends on 2)

The computer-implemented method of claim 2, wherein creating the third set of virtual changes for the particular object comprises:
generating a delta metadata based on the received change request; and
merging the generated delta metadata with a metadata of the particular object.

### Claim 5 (depends on 1)

The computer-implemented method of claim 1, wherein a set of virtual changes for a database object comprises changes to schema of the database stored as a virtual version of the database object.

### Claim 6 (depends on 5)

The computer-implemented method of claim 5, wherein a virtual version of a database object comprises:
(i) references to a set of objects in the database, and
(ii) metadata of the referenced objects.

### Claim 7 (depends on 5)

The computer-implemented method of claim 5, wherein the set of virtual changes for a database object further comprises changes to a data content of the database stored as a set of temporary physical data.

### Claim 8 (depends on 5)

The computer-implemented method of claim 5, wherein virtual versions of database objects are registered as a catalog of virtual versions.

### Claim 9 (depends on 1)

The computer-implemented method of claim 1, wherein:
the data object is a table, and
the set of virtual changes comprises adding a column to or deleting a column from the table.

### Claim 10 (depends on 1)

The computer-implemented method of claim 1, wherein at least one set of virtual changes from the plurality of sets of virtual changes comprises adding to the database a database object that does not have corresponding data content in the base physical data.

### Claim 11

A computing device for managing a database comprising a set of database objects, the computing device comprising:
a set of processing units;
a first storage device storing (i) a set of base physical data for the database and (ii) a plurality of sets of virtual changes for the database objects, each set of virtual changes being associated with a database object; and
a second storage device storing a set of instructions, wherein an execution of the set of instructions by the set of processing units configures the computing device to perform acts, comprising:
presenting a first query response to (i) a first application based on the set of base physical data and (ii) a first set of virtual changes for a particular database object from the set of database objects; and
presenting a second query response to (i) a second application based on the set of base physical data and (ii) a second, different set of virtual changes for the particular database object.

### Claim 12 (depends on 11)

The computing device of claim 11 is further configured to perform acts comprising:
(i) receiving a change request to the database system from the first application that affects the particular database object;
(ii) creating a third set of virtual changes for the particular database object based on the received change request; and
(iii) presenting a third query response based on the set of base physical data and the third set of virtual changes for the particular database object.

### Claim 13 (depends on 12)

The computing device of claim 12 is further configured to perform acts comprising:
determining a validity of the change request from the first application; and
issuing an error notification to the first application when the change request is not valid.

### Claim 14 (depends on 12)

The computing device of claim 12, wherein creating the third set of virtual changes for the particular database object comprises:
generating a delta metadata based on the received change request; and
merging the generated delta metadata with a metadata of the particular database object.

### Claim 15

A computer program product for managing a database comprising a set of database objects, the computing program product comprising:
one or more non-transitory computer-readable storage device and program instructions stored on at least one of the one or more non-transitory storage devices, the program instructions executable by a processor, the program instructions comprising sets of instructions for:
accessing a set of base physical data for the database;
accessing a plurality of sets of virtual changes for the set of database objects, each set of virtual changes associated with a database object of the set of database objects;
presenting a first query response to (i) a first application based on the set of base physical data and (ii) a first set of virtual changes for a particular database object of the set of database objects; and
presenting a second query response to (i) a second application based on the set of base physical data and (ii) a second, different set of virtual changes, for the particular database object.

### Claim 16 (depends on 15)

The computer program product of claim 15, wherein a set of virtual changes for a database object comprises changes to schema of the database stored as a virtual version of the database object.

### Claim 17 (depends on 16)

The computer program product of claim 16, wherein a virtual version of a database object of the set of database objects comprises:
(i) references to a set of objects in the database; and
(ii) metadata of the referenced objects.

### Claim 18 (depends on 16)

The computer program product of claim 16, wherein the set of virtual changes for a database object further comprises changes to a data content of the database stored as a set of temporary physical data.

### Claim 19 (depends on 15)

The computer program product of claim 15, wherein:
the data object is a table, and
the set of virtual changes comprises adding a column to or deleting a column from the table.

### Claim 20 (depends on 15)

The computer program product of claim 15, wherein at least one set of virtual changes of the plurality of sets of virtual changes comprises adding to the database a database object that does not have corresponding data content in the base physical data.
