| US 7,505,993 B2 | ||
| Database schema for content managed data | ||
| Victor Chan, Thornhill (Canada); Darl Andrew Crick, Keswick (Canada); Miu-To Brenda Lam, North York (Canada); Wan Ngai Wayne Lee, North York (Canada); Jacob Vandergoot, Bradford (Canada); and Tony Chung Keung Woo, Newmarket (Canada) | ||
| Assigned to International Business Machines Corporation, Armonk, N.Y. (US) | ||
| Filed on Dec. 14, 2005, as Appl. No. 11/304,015. | ||
| Prior Publication US 2007/0136325 A1, Jun. 14, 2007 | ||
| Int. Cl. G06F 7/00 (2006.01); G06F 17/00 (2006.01) | ||
| U.S. Cl. 707—102 [707/103 R] | 8 Claims |
| 1. A data structure embodied on a computer-readable medium in conformance with a database schema for accessing and managing
content managed data in a database, the database schema comprising:
a base schema representing a content data table and an operational data table;
a write schema representing a content managed data table and a content managed operational data table, wherein the content
managed data table includes one or more business object fields that correspond to business object fields in the content data
table and at least one content management field, and wherein one content management field indicates an operation performed
on a business object;
a read schema representing the content managed operational data table and having a view representing the content managed data
table and the content data table, wherein the view is configured to:
select business objects from the content managed data table and the content data table giving precedence to a business object
in the content managed data table over a corresponding business object in the content data table,
select a business object from the content managed data table having a content management field indicating a create operation,
select a business object from the content managed data table, having a content management field indicating a modify operation,
over a corresponding business object in the content data table, and
exclude a business object in the content managed data table having a content management field indicating a delete operation
and exclude a corresponding business object in the content data table; and
the database schema used by a business logic application to access and manipulate the content managed data in the database.
|