If it sounds as if we??™re big fans of Oracle??™s locking scheme, well??”we are.
Workspaces
Oracle9i introduced a new feature that relates to concurrency, Workspace Manager.
A workspace is a way to isolate data from changes in the general database environment.
Workspace Manager accomplishes this by creating workspace-specific
versions of data. When youcreate a workspace, youessentially create a snapshot of
the data in the workspace at a specific point in time. Further changes to that data
from outside the workspace do not affect the view of the data in the workspace, and
changes made to data within the workspace are not seen by users outside the workspace.
And changes to data within a workspace are visible only to other workspace
users.
Workspaces allow youto essentially create separate data environments for specialized
usage. You can capture data at a certain point in time for historical analysis and
can also perform various types of ???what-if??? analysis, testing to see how changes
would affect the overall composition of the data without disturbing the main production
database.
Pages:
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443