公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：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.

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

公开(公告)号：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.

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

公开(公告)号：US07043490B2

公开(公告)日：2006-05-09

申请号：US10091919

申请日：2002-03-05

申请人： David M. Choy ,  Tawei Hu ,  Lily Liang ,  Kenneth C. Nelson ,  Randal J. Richardt

发明人： David M. Choy ,  Tawei Hu ,  Lily Liang ,  Kenneth C. Nelson ,  Randal J. Richardt

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

CPC分类号： G06F17/30017 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99945

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

公开(公告)号：US07392246B2

公开(公告)日：2008-06-24

申请号：US10367086

申请日：2003-02-14

申请人： Rupa Bhaghavan ,  Tawei Hu ,  Kenneth Carlin Nelson ,  Randal James Richardt

发明人： Rupa Bhaghavan ,  Tawei Hu ,  Kenneth Carlin Nelson ,  Randal James Richardt

IPC分类号： G06F17/30

CPC分类号： G06F17/30427 ,  G06F21/6218 ,  G06F21/6227 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99937 ,  Y10S707/99938 ,  Y10S707/99939

摘要： A method to generate an SQL sub-expression that implement access control rules stored in a library server. The SQL sub-expression is then merged with the SQL passed from an application program interface (API). The access control checking mechanism is implemented on the server side of the content management system. In this client/server environment, the query SQL statement is built in two layers: the API (client) layer and the server layer. The API sends the query string to the underlying stored procedure. The stored procedure then generates the access control logic based on the configuration parameters of the library server. This access control logic is dynamically added to the query string sent by the API. The stored procedure prepares, builds and executes this new query string as a dynamic SQL statement.

摘要翻译： 一种生成实现存储在库服务器中的访问控制规则的SQL子表达式的方法。 然后，SQL子表达式与从应用程序接口（API）传递的SQL合并。 访问控制检查机制在内容管理系统的服务器端实现。 在此客户端/服务器环境中，查询SQL语句分为两层：API（客户端）层和服务器层。 API将查询字符串发送到底层存储过程。 存储过程然后根据库服务器的配置参数生成访问控制逻辑。 该访问控制逻辑被动态添加到由API发送的查询字符串中。 存储过程准备，构建并执行此新查询字符串作为动态SQL语句。

公开(公告)号：US07478094B2

公开(公告)日：2009-01-13

申请号：US10459078

申请日：2003-06-11

申请人： Mang-Rong Ho ,  Tawei Hu

发明人： Mang-Rong Ho ,  Tawei Hu

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

CPC分类号： H04L63/102 ,  G06F21/6218 ,  H04L63/101 ,  H04L63/105 ,  H04L2463/101 ,  Y10S707/99939

摘要： A method providing a high performance access control list. The preferred embodiments operate in a computer network having a plurality of users of the network and comprising a database management system and a content management system controlling access to a plurality of entities shareable by the users of the network, the content management system using an access control list table having group privilege rules and user privilege rules for controlling access to the entities. A high performance ACL method is provided, the method comprising providing a run-time compiled ACL table, wherein the compiled ACL table provides resolved privilege rules for each of the users at run-time, and using the compiled ACL table, the content management system accessing user-selected ones of the entities based on the resolved privilege rules.

摘要翻译： 一种提供高性能访问控制列表的方法。 优选实施例在具有网络的多个用户的计算机网络中操作，并且包括数据库管理系统和控制对由网络的用户共享的多个实体的访问的内容管理系统，使用访问控制的内容管理系统 列表具有用于控制对实体的访问的组特权规则和用户权限规则。 提供了一种高性能ACL方法，该方法包括提供运行时编译的ACL表，其中编译的ACL表在运行时为每个用户提供解决的权限规则，并且使用编译的ACL表，内容管理系统 基于解决的权限规则访问用户选择的实体。

公开(公告)号：US07284265B2

公开(公告)日：2007-10-16

申请号：US10131659

申请日：2002-04-23

申请人： David Mun-Hien Choy ,  Tawei Hu ,  Jy-Jine James Lin ,  Yuping Wang ,  Alan Tsu-I Yaung

发明人： David Mun-Hien Choy ,  Tawei Hu ,  Jy-Jine James Lin ,  Yuping Wang ,  Alan Tsu-I Yaung

IPC分类号： G06F17/30 ,  H04L9/32

CPC分类号： G06F21/6218

摘要： System and method for authorizing access to an entity by a user, by binding an access control list to each entity; specifying for the user a set of user privileges; intersecting the access control list and set of user privileges in a compiled ACL table; incrementally refreshing the compiled ACL table responsive to run time modification of relevant tables containing the access control list and set of user privileges; and referencing the compiled access control list to authorize a user request to access an entity.

摘要翻译： 通过将访问控制列表绑定到每个实体来授权用户访问实体的系统和方法; 为用户指定一组用户权限; 与访问控制列表和编译的ACL表中的用户权限集相交; 响应于包含访问控制列表和一组用户权限的相关表的运行时间修改，逐渐刷新编译的ACL表; 并引用编译的访问控制列表来授权访问实体的用户请求。

公开(公告)号：US07099899B2

公开(公告)日：2006-08-29

申请号：US10128861

申请日：2002-04-23

申请人： David Mun-Hien Choy ,  Sudipta Deb Deb ,  Tawei Hu ,  Lily Liang ,  Kenneth Carlin Nelson ,  Edward Joseph Perry ,  Mayank Vipin Shah ,  I-Shin Andy Wang ,  Howard Hao Zhang

发明人： David Mun-Hien Choy ,  Sudipta Deb Deb ,  Tawei Hu ,  Lily Liang ,  Kenneth Carlin Nelson ,  Edward Joseph Perry ,  Mayank Vipin Shah ,  I-Shin Andy Wang ,  Howard Hao Zhang

IPC分类号： G06F17/30

CPC分类号： G06F17/30309 ,  Y10S707/99952 ,  Y10S707/99954

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

摘要翻译： 内容管理系统提供可由客户端应用程序控制或对其透明的版本控制能力。 文档版本的控制取决于由文档的层次结构定义的根和子组件属性。 当文档被更新时，本系统根据用户的需要来执行以下任何或全部场景：替换存储在指定文档的根组件实例中的现有属性值; 替换指定文档的指定子组件实例中存储的现有属性值; 将新的子组件实例添加到指定文档的层次结构中; 或从指定文档的层次结构中删除现有的子组件实例。

公开(公告)号：US5896506A

公开(公告)日：1999-04-20

申请号：US656441

申请日：1996-05-31

申请人： Seifu Ali ,  Thomas G. Burket ,  Tawei Hu ,  Gerald Edward Kozina ,  Thomas S. Lee

发明人： Seifu Ali ,  Thomas G. Burket ,  Tawei Hu ,  Gerald Edward Kozina ,  Thomas S. Lee

IPC分类号： G06F17/30 ,  G06F13/38 ,  G06F15/17

CPC分类号： G06F17/30067

摘要： The present invention is directed to a method and system for storing and managing objects, such as binary large objects (blobs) in a digital library system which includes a plurality of clients, an object server for storing an object, a cache server for storing a copy of the object, and a centralized server for storing information identifying the object as being stored in the object server and associating one or more of the clients with the cache server, in which one of the clients, as a requesting client, requests retrieval of an object, a copy of the requested object is sent from the cache server to the requesting client if the object is stored in said cache server, and a copy of said object is sent from the object server to said requesting client if the object is not stored in the cache server; and a copy of the requested object is sent from the object server to the cache server after the object server sends the object to the client, in which the object sent to the client is made available to the client regardless of whether sending of the copy of the object to the cache server is completed.

摘要翻译： 本发明涉及用于在数字图书馆系统中存储和管理诸如二进制大对象（blob）的对象的方法和系统，所述数字图书馆系统包括多个客户端，用于存储对象的对象服务器，用于存储对象的高速缓存服务器 对象的副本以及用于存储标识被存储在对象服务器中的对象的信息并将一个或多个客户端与高速缓存服务器相关联的集中式服务器，其中作为请求客户端的客户端之一请求检索 如果对象存储在所述缓存服务器中，则所请求对象的副本从缓存服务器发送到请求客户端，并且如果对象不是，则将对象服务器的副本从对象服务器发送到所述请求客户端 存储在缓存服务器中; 并且在对象服务器将对象发送到客户端之后，将所请求的对象的副本从对象服务器发送到缓存服务器，其中发送给客户端的对象可用于客户端，而不管是否发送副本 缓存服务器的对象完成。