公开(公告)号：US09767146B2

公开(公告)日：2017-09-19

申请号：US10933917

申请日：2004-08-31

申请人： Rupa Bhaghavan ,  Wayne Frederick Miller ,  Kenneth Carlin Nelson ,  Sharon McKenna Sanders ,  Fang-Yi Wang

发明人： Rupa Bhaghavan ,  Wayne Frederick Miller ,  Kenneth Carlin Nelson ,  Sharon McKenna Sanders ,  Fang-Yi Wang

IPC分类号： G06F17/30 ,  G06Q10/06

CPC分类号： G06F17/30421 ,  G06Q10/06

摘要： Various embodiments of a method, apparatus and article of manufacture provide a decision point in a workflow system comprising a server and at least a first client work node. A decision point work node is provided at the server. A SQL expression which is associated with the decision point work node and the first client work node is generated. The server determines whether to route a work package to the first client work node based on the SQL expression.

公开(公告)号：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语句。

公开(公告)号：US07761443B2

公开(公告)日：2010-07-20

申请号：US12123723

申请日：2008-05-20

申请人： 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 system 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语句。

公开(公告)号：US20080222708A1

公开(公告)日：2008-09-11

申请号：US12123723

申请日：2008-05-20

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

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

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

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

摘要： A system 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语句。

公开(公告)号：US08479203B2

公开(公告)日：2013-07-02

申请号：US12509342

申请日：2009-07-24

申请人： Kenneth Carlin Nelson ,  Brett Edward Morris

发明人： Kenneth Carlin Nelson ,  Brett Edward Morris

IPC分类号： G06F9/46

CPC分类号： G06F17/30011 ,  G06Q10/06

摘要： Systems, methods and articles of manufacture are disclosed for processing documents for electronic discovery. A request may be received to perform a task on documents, each document having a distinct document identifier. A task record may be generated to represent the requested task. The task record may include information specific to the request task. However, the task record need not include any document identifiers. At least one batch record may be generated that includes the document identifier for each of the documents. The task record may be associated with the at least one batch record. The requested task may be performed according to the task record and the at least one batch record. An audit record may be generated for the performed task. The audit record may be associated with the at least one batch record.

摘要翻译： 公开了用于处理用于电子发现的文件的系统，方法和制品。 可以接收到对文档执行任务的请求，每个文档具有不同的文档标识符。 可以生成任务记录来表示所请求的任务。 任务记录可以包括特定于请求任务的信息。 但是，任务记录不需要包含任何文档标识符。 可以生成包括每个文档的文档标识符的至少一个批记录。 任务记录可以与至少一个批次记录相关联。 可以根据任务记录和至少一个批记录来执行所请求的任务。 可以为执行的任务生成审核记录。 审计记录可以与至少一个批记录相关联。

公开(公告)号：US08001611B2

公开(公告)日：2011-08-16

申请号：US11975579

申请日：2007-10-18

申请人： Kenneth Carlin Nelson ,  Marilene Araujo Noronha

发明人： Kenneth Carlin Nelson ,  Marilene Araujo Noronha

IPC分类号： G06F7/04 ,  G06K9/00

CPC分类号： H04L63/08 ,  G06F21/31 ,  G06F2221/2115 ,  H04L63/205 ,  Y10S707/99939

摘要： System for authenticating a user for logon to a content manager running on top of a database manager. A connect procedure connects the user to a database manager; and then a logon procedure logs on the user to the content manager selectively responsive to the user connecting to the database manager; the user being authenticated by a third party by way of a user exit or a trusted logon environment and privilege; or the user being authenticated by the content manager.

摘要翻译： 用于验证用户登录到在数据库管理器顶部运行的内容管理器的系统。 连接过程将用户连接到数据库管理器; 然后登录过程将用户选择性地响应于连接到数据库管理器的用户登录到内容管理器; 用户通过用户出口或可信登录环境和特权由第三方认证; 或用户被内容管理器认证。

公开(公告)号：US07761404B2

公开(公告)日：2010-07-20

申请号：US11182148

申请日：2005-07-15

申请人： An Feng-I Chen ,  David Mun-Hien Choy ,  Tawei Hu ,  Jy-Jine James Lin ,  Kenneth Carlin Nelson ,  Yuping Wang ,  Alan Tsu-I Yaung

发明人： An Feng-I Chen ,  David Mun-Hien Choy ,  Tawei Hu ,  Jy-Jine James Lin ,  Kenneth Carlin Nelson ,  Yuping Wang ,  Alan Tsu-I Yaung

IPC分类号： G06F17/30

CPC分类号： G06F21/6218 ,  G06F21/10 ,  Y10S707/99939 ,  Y10S707/99943

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

摘要翻译： 访问系统和用户定义的实体（对象，数据项等）由内容管理器管理。 特权授予用户访问系统这种受控实体的能力。 一个项目是存储在CM库服务器中的原子用户数据实体。 特权表用于存储系统和用户定义的权限。 权限由表中的一行表示。 每个权限都有一个唯一的权限代码，代码0到999被保留用于存储系统定义的权限，并且代码超出了999，用于用户定义的权限，从而允许无限制地添加特定应用的权限。

公开(公告)号：US08195607B2

公开(公告)日：2012-06-05

申请号：US11848834

申请日：2007-08-31

申请人： Lynda A. Hansen ,  Mang-rong Ho ,  Gerald E. Kozina ,  Kenneth Carlin Nelson

发明人： Lynda A. Hansen ,  Mang-rong Ho ,  Gerald E. Kozina ,  Kenneth Carlin Nelson

IPC分类号： G06F17/00

CPC分类号： G06F17/30011 ,  G06F11/1492

摘要： In a content management system having a plurality of resource managers storing objects, a replica resource manager stores a replica of an object stored in one of the plurality of resource managers. A library server contains a resource manager table that defines the plurality of resource managers and includes availability information for each of those resource managers. When a client requests an object, the library server identifies a primary resource manager storing the object. The library server also determines a replica resource manager storing a replica of the object and returns information identifying that replica resource manager if the resource manager table indicates that the primary resource manager is unavailable and indicates that the replica resource manager is online and available. The client then retrieves the replica object without incurring a timeout delay waiting for the primary resource manager to respond to an access request.

摘要翻译： 在具有多个资源管理器存储对象的内容管理系统中，副本资源管理器存储存储在多个资源管理器之一中的对象的副本。 库服务器包含定义多个资源管理器的资源管理器表，并且包括每个资源管理器的可用性信息。 当客户端请求对象时，库服务器识别存储对象的主资源管理器。 库服务器还确定存储对象的副本的副本资源管理器，并且如果资源管理器表指示主资源管理器不可用并且指示副本资源管理器在线并且可用，则返回标识该副本资源管理器的信息。 客户端然后检索副本对象，而不会导致等待主资源管理器响应访问请求的超时延迟。

公开(公告)号：US07809694B2

公开(公告)日：2010-10-05

申请号：US11080171

申请日：2005-03-15

申请人： Kenneth Carlin Nelson

发明人： Kenneth Carlin Nelson

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

CPC分类号： G06F17/30442

摘要： Analyzing performance data from a relational database to discover poorly performing SQL statements includes creating event records of performance data for query statements executed by a relational database management system, and condensing the performance data in the event records. A performance summary can be generated for each condensed event record. The performance summaries can then be analyzed based on performance characteristics to identify poorly performing SQL statements.

摘要翻译： 从关系数据库分析性能数据以发现性能不佳的SQL语句包括为关系数据库管理系统执行的查询语句创建性能数据的事件记录，并将事件记录中的性能数据进行聚合。 可以为每个精简事件记录生成性能摘要。 然后可以基于性能特征来分析性能摘要，以识别性能差的SQL语句。

公开(公告)号：US07213029B2

公开(公告)日：2007-05-01

申请号：US10449272

申请日：2003-05-29

申请人： Kenneth Carlin Nelson ,  Dwayne Lorenzo Richardson

发明人： Kenneth Carlin Nelson ,  Dwayne Lorenzo Richardson

IPC分类号： G06F17/30

CPC分类号： G06F9/466 ,  Y10S707/99944 ,  Y10S707/99945 ,  Y10S707/99953

摘要： Disclosed is a system and method for coordinating the backup of multiple databases and file systems in a Content Manager system. This is accomplished by “pausing” the library server to enable the desired coordinated backup of all servers, that is, the Library Servers and the Resource Servers. The coordinated backup is accomplished by both “pausing” and coordinated backup, and without interrupting a transaction which is in progress. This is accomplished by a consideration of the full CM transaction rather then just the individual elemental library server and resource manager transactions. The effect is to allow existing operations to complete, and involves “pausing” the library server to enable coordinated backup of all servers without interrupting a content management transaction which is in progress, if they complete within an interval specified by the administrator.

摘要翻译： 公开了一种用于在Content Manager系统中协调多个数据库和文件系统的备份的系统和方法。 这通过“暂停”库服务器来实现所有服务器（即库服务器和资源服务器）的所需协调备份来实现。 协调备份通过“暂停”和协调备份完成，而不会中断正在进行的事务。 这是通过考虑完整的CM事务而不是单独的元素库服务器和资源管理器事务来实现的。 影响是允许现有操作完成，并且涉及“暂停”库服务器以启用所有服务器的协调备份，而不会中断正在进行的内容管理事务，如果它们在管理员指定的时间间隔内完成。