公开(公告)号：US06938050B2

公开(公告)日：2005-08-30

申请号：US10128450

申请日：2002-04-23

申请人： Khanh M. Le ,  Tawei Hu ,  Edward J. Perry ,  Howard Zhang ,  Lily L. Liang

发明人： Khanh M. Le ,  Tawei Hu ,  Edward J. Perry ,  Howard Zhang ,  Lily L. Liang

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30595 ,  G06F17/3041 ,  G06F17/30607 ,  Y10S707/956 ,  Y10S707/99944

摘要： A content management system is provided including a plurality of tables forming a tree-based hierarchy for storing information such as item information. An information retrieval interface is provided to facilitate retrieval of information from the tree-based table hierarchy. The number of cursors employed for retrieving information is dynamically variable with the number of tables in the hierarchy. Advantageously, the content management system permits tables to be added or appended to the initial tree-based table hierarchy after the database is created. The number of cursors is dynamically varied to accommodate the additional cursors needed to query the additional table or tables.

摘要翻译： 提供了一种内容管理系统，其包括形成用于存储诸如项目信息之类的信息的基于树的层级的多个表。 提供信息检索界面以便于从基于树的表层次结构检索信息。 用于检索信息的游标数量随层次结构中的表数量而动态变化。 有利地，内容管理系统允许在数据库创建之后将表添加或附加到初始基于树的表层次结构。 光标的数量是动态变化的，以适应查询附加表或表所需的附加光标。

公开(公告)号：US06999966B2

公开(公告)日：2006-02-14

申请号：US10128332

申请日：2002-04-23

申请人： Lily L. Liang ,  Tawei Hu ,  Kenneth C. Nelson ,  David M. Choy ,  Khanh M. Le ,  Edward J. Perry

发明人： Lily L. Liang ,  Tawei Hu ,  Kenneth C. Nelson ,  David M. Choy ,  Khanh M. Le ,  Edward J. Perry

IPC分类号： G06F17/00

CPC分类号： G06F17/30607 ,  Y10S707/99942

摘要： 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.

公开(公告)号：US06947948B2

公开(公告)日：2005-09-20

申请号：US10128428

申请日：2002-04-23

申请人： Andy I-Shin Wang ,  David M. Choy ,  Lily L. Liang ,  James J. Lin

发明人： Andy I-Shin Wang ,  David M. Choy ,  Lily L. Liang ,  James J. Lin

IPC分类号： G06F17/00 ,  G06F17/30

CPC分类号： G06F17/30595 ,  Y10S707/99943

摘要： 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.

摘要翻译： 公开了一种关系数据库，其包括各自呈现不同类型的目标表，例如通用联系表，个人联系表和部门联系表。 关系数据库包括一个超列，该列被分成与目标表的类型数相对应的列数。 在每个类型的目标表的超级列中分配相应的列。 有价值的系统内存空间因此得到保存。 支持多类型表和多目标表，并提供多版本数据存储功能。

公开(公告)号：US07082455B2

公开(公告)日：2006-07-25

申请号：US10128260

申请日：2002-04-23

申请人： Tawei Hu ,  James J. Lin ,  Kenneth C. Nelson ,  Alan T. Yaung ,  Randy Richardt ,  Lily L. Liang ,  Ed Gallagher ,  Dwayne L. Richardson

发明人： Tawei Hu ,  James J. Lin ,  Kenneth C. Nelson ,  Alan T. Yaung ,  Randy Richardt ,  Lily L. Liang ,  Ed Gallagher ,  Dwayne L. Richardson

IPC分类号： G06F15/16 ,  G06F13/00

CPC分类号： H04L29/06 ,  H04L69/06

摘要： A content management system is provided including a server computer and a client computer. The server includes a data repository and a stored procedure. The disclosed methodology provides a way of handling parameter passing of structured data for stored procedures in the system. The system is capable of both encoding data into a structured data format and decoding data from the structured data format. The structured data format employs a binary large object (BLOB) and character large object (CLOB) to achieve handling of fixed length binary data and variable length character data. Advantageously, the stored procedure interface need not be rewritten and customized for each stored procedure in the server.

公开(公告)号：US06944627B2

公开(公告)日：2005-09-13

申请号：US10128478

申请日：2002-04-23

申请人： Howard Zhang ,  Li Ming Wang ,  Lily L. Liang ,  Tawei Hu ,  Edward J. Perry ,  Khanh M. Le

发明人： Howard Zhang ,  Li Ming Wang ,  Lily L. Liang ,  Tawei Hu ,  Edward J. Perry ,  Khanh M. Le

IPC分类号： G06F17/30

CPC分类号： G06F17/30961 ,  Y10S707/99944

摘要： A content management system is provided including a plurality of tables forming a tree-based storage hierarchy. The system includes a stored procedure which enables information to be retrieved from different arbitrary locations throughout the storage hierarchy. Advantageously, the system retrieves information from both simple and complex tree-based storage hierarchies.

摘要翻译： 提供了包括形成基于树的存储层级的多个表的内容管理系统。 该系统包括存储过程，其使得可以在整个存储层级中从不同的任意位置检索信息。 有利地，系统从简单和复杂的基于树的存储层次结构中检索信息。