David Fong Choy

US Patent:

6757680, Jun 29, 2004

Filed:

Jul 3, 2000

Appl. No.:

09/609810

Inventors:

David Mun-Hien Choy - Los Altos CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1730

US Classification:

707 9, 707 4, 707 10, 707102, 707104

Abstract:

A system and method are provided for an information management system (IMS) having an underlying relational database system (RDBMS) that allows an item to be associated with plural containers, and one of the containers is designated as the items primary container. Inheritance of the primary containers access control rules can be activated, and when it is, the containers access control rules are automatically used to access the item. Otherwise, the items access control rules are used. The containers rules can be propagated through many levels of containers/items.

US Patent:

6947948, Sep 20, 2005

Filed:

Apr 23, 2002

Appl. No.:

10/128428

Inventors:

Andy I-Shin Wang - Palo Alto CA, US
David M. Choy - Los Altos CA, US
Lily L. Liang - San Jose CA, US
James J. Lin - Cupertino CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F017/30

US Classification:

707102

Abstract:

A relational database is disclosed which includes a number of target tables each exhibiting a different type, such as a general contact table, a personal contact table and a department contact table. The relational database includes a super-column which is divided into a number of columns corresponding to the number of types of target tables. A respective column is allocated in the super-column for each of the types of the target tables. Valuable system memory space is consequently conserved. Multiple-typed tables and multi-targeted tables are supported, and multi-version data storage capabilities are provided.

US Patent:

6976023, Dec 13, 2005

Filed:

Apr 23, 2002

Appl. No.:

10/131651

Inventors:

An Feng-I Chen - Fremont CA, US
David Mun-Hien Choy - Los Altos CA, US
Tawei Hu - San Jose CA, US
Kenneth Carlin Nelson - Hollister CA, US
Yuping Wang - San Jose CA, US
Alan Tsu-I Yaung - San Jose CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F017/30

US Classification:

707 9

Abstract:

Access to system and user defined entities (objects, data items, or the like) is managed by a content manager. A privilege grants a user an ability to access system such controlled entities. An item is an atomic user data entity stored in the CM library server. A privileges table is used to store system and user defined privileges. A privilege is represented by a row in the table. Each privilege has a unique privilege code, with codes 0 to 999 reserved to store system-defined privileges and codes beyond 999 open for user-defined privileges thus allowing application specific privileges to be added without limit.

US Patent:

6999966, Feb 14, 2006

Filed:

Apr 23, 2002

Appl. No.:

10/128332

Inventors:

Lily L. Liang - San Jose CA, US
Tawei Hu - San Jose CA, US
Kenneth C. Nelson - Hollister CA, US
David M. Choy - Los Altos CA, US
Khanh M. Le - Austin TX, US
Edward J. Perry - Cary NC, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/00

US Classification:

707100, 707101, 715514

Abstract:

A content management system is provided including a plurality of tables forming a tree-based storage hierarchy. The system includes a library server having a stored procedure which creates a hierarchical tree-based storage structure having any number of child components horizontally and any number of component types vertically thus specifying a tree topology. Advantageously, a single invocation of the stored procedure will create the specified tree-based data storage structure which is stored in the library server.

US Patent:

7043490, May 9, 2006

Filed:

Mar 5, 2002

Appl. No.:

10/091919

Inventors:

David M. Choy - Los Altos CA, US
Tawei Hu - San Jose CA, US
Lily Liang - San Jose CA, US
Kenneth C. Nelson - Hollister CA, US
Randal J. Richardt - San Jose CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/30
G06F 7/00

US Classification:

707101, 707102, 7071041, 707 10

Abstract:

Methods, systems, and program products for managing multimedia content. These are built upon a combination of a high level content model for specific multimedia content types and a low level physical for mapping to a data engine. The method, system, and program product include representing multimedia content management objects and managing the objects in a relational database. The relational database is adapted for representing data in a plurality of relational database tables, where each of the relational database tables has at least one row with a plurality of columns. Content is managed by associating the object as an item to a row in a first relational database table; and associating additional components, if any, of the object to additional relational database tables.

US Patent:

7080085, Jul 18, 2006

Filed:

Jul 12, 2000

Appl. No.:

09/614369

Inventors:

David Mun-Hien Choy - Los Altos CA, US
Sriram Raghavan - San Jose CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/00

US Classification:

707101, 707102, 707103 R, 707201

Abstract:

A system and method are provided for an information management system (IMS) to manage heterogenous references in the system, to ensure “referential integrity”, without changing the underlying relational database management system (RDBMS) of the IMS. One or more system tables are kept that are not visible to system users. In one embodiment, the RDBMS' mechanisms to ensure referential integrity for homogenous references is used in conjunction with the system table to extend referential integrity to heterogenous references. In another embodiment, the triggers of the RDBMS, in conjunction with the system table, are used to ensure referential integrity of heterogenous references.

US Patent:

7099899, Aug 29, 2006

Filed:

Apr 23, 2002

Appl. No.:

10/128861

Inventors:

David Mun-Hien Choy - Los Altos CA, US
Sudipta Deb Deb - Palo Alto CA, US
Tawei Hu - San Jose CA, US
Lily Liang - San Jose CA, US
Kenneth Carlin Nelson - Hollister CA, US
Edward Joseph Perry - Cary NC, US
Mayank Vipin Shah - San Jose CA, US
I-Shin Andy Wang - Palo Alto CA, US
Howard Hao Zhang - San Jose CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/30

US Classification:

707203, 707200, 707201

Abstract:

A content management system provides versioning capability that can either be controlled by the client application or be transparent thereto. Control of document versions depends on the root and child component attributes that are defined by the hierarchical structure of the document. When a document is updated, the present system performs any or all of the following scenarios as desired by the user: replace the existing attribute values stored in the root component instance for a specified document; replace the existing attribute values stored in a specified child component instance for the specified document; add a new child component instance into the hierarchical structure for the specified document; or delete an existing child component instance from the hierarchical structure for the specified document.

US Patent:

7216126, May 8, 2007

Filed:

Apr 4, 2003

Appl. No.:

10/407387

Inventors:

David Mun-Hien Choy - Los Altos CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/30

US Classification:

707 9, 707 10, 707103

Abstract:

A system and method are provided for an information management system (IMS) having an underlying relational database management system (RDBMS) that allows applications to access the RDBMS directly for improved performance without going through the IMS, while maintaining access control. An access control list (ACL) is generated, with tables in the RDBMS being bound using codes in the ACL. At run time or, more preferably, pre-run time, user-defined functions (UDF) evaluate access control attributes and generate an access authorization table, which is joined with the appropriate information table(s) in response to a query against a view on the table. The view is presented to the querying user. Thus, access control rules are encapsulated in the view that is presented to the user.