Both of these options would normally require you to create a duplicate
database, so workspaces can save you time and resources.
Workspaces | 199
Workspace Implementation
The key to workspaces is the support of multiple versions of the same data. To use
workspaces to version data in a table, youmu st first enable the table for versioning.
Workspace Manager can version-enable one or more user tables in the database. The
unit of versioning is a row. When a table is version-enabled, all rows in the table can
support multiple versions of the data. Versioned rows are stored in the same table as
the original rows. The versioning infrastructure is not visible to the users of the database,
and application SQL statements to select, insert, modify, and delete data
continue to work in the usual way with version-enabled tables. Workspace Manager
version-enables a table by renaming the table, adding a few columns to the table to
store versioning metadata, creating a view on the version-enabled table using the
original table name, and defining INSTEAD OF triggers on the view for SQL DML
operations.
Pages:
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444