Slide 16.14: Generating and modifying objects (cont.)

Desired Properties (Cont.)

Generating and Modifying Objects (Cont.)

Insert a new vehicle for which an object manufacturer already exists.
1. Insert a new vehicle made by that manufacturer.
  INSERT NEW( model, manufacturer, color ) VALUES( 'Mondeo', m, 'red' ) INTO vehicle;
  |||
  INSERT NEW( model, manufacturer, color ) VALUES( 'Mondeo', SELECT f FROM f IN company WHERE name = 'Ford', 'red' ) INTO vehicle;
An appropriate flatten-operator should be available because the query defines a set and the manufacturer of a vehicle is not set-values.
Modification operations may also have an effect on existing collections. For example, John Smith is to be employed in Ford‘.s subsidiary in Chicago. The following procedure is required:
1. Insert John Smith into the class employee.
2. Select the object from the class subsidiary of the company with the name Ford and the location “Chicago” in its address.
3. Insert the object employee with name John Smith into the set employees of this subsidiary.

Generating New Classes, Instances, and Operations
A data manipulation language of an OODBS must allow views to be defined on a given database state. In RDBMS, the VIEW command creates a logical (virtual) table. This logical table exists only in memory, and yet it may be treated as though it were a real table.