公开(公告)号：US06829764B1

公开(公告)日：2004-12-07

申请号：US08880616

申请日：1997-06-23

申请人： Mitchell Adam Cohen ,  Anant Deep Jhingran ,  Ronald Mraz

发明人： Mitchell Adam Cohen ,  Anant Deep Jhingran ,  Ronald Mraz

IPC分类号： G06F900

CPC分类号： G06F9/4881 ,  G06F9/5066

摘要： A task schedule is enforced among multiple processes by setting process priorities based upon which tasks are running on which processes and based upon the task schedule. The task scheduling may be provided by a local or global scheduler which uses application information to prioritize tasks. The task schedule, or priority list, is provided at Local Activity Schedulers which schedule the activities for their local execution elements/nodes. Execution of activities locally are performed by any number of processes that reside in each execution element. These processes are assigned operating system priorities by the respective Local Activity Scheduler based on their assigned activities for execution and the task schedule.

摘要翻译： 通过根据哪些任务正在运行哪些进程并基于任务计划来设置进程优先级，从而在多个进程中实施任务计划。 任务调度可以由本地或全局调度器提供，其使用应用信息来优先处理任务。 在本地活动计划程序中提供任务计划或优先级列表，该计划程序为其本地执行元素/节点计划活动。 本地执行活动由驻留在每个执行元素中的任何数量的进程执行。 这些进程由相应的本地活动计划程序根据其分配的执行活动和任务计划分配操作系统优先级。

公开(公告)号：US5978788A

公开(公告)日：1999-11-02

申请号：US843290

申请日：1997-04-14

申请人： Vittorio Castelli ,  Anant Deep Jhingran ,  Chung-Sheng Li ,  John Timothy Robinson

发明人： Vittorio Castelli ,  Anant Deep Jhingran ,  Chung-Sheng Li ,  John Timothy Robinson

IPC分类号： G06F17/30

CPC分类号： G06F17/30592 ,  G06F17/30489 ,  G06F17/30536 ,  G06F2216/03 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99943 ,  Y10S707/99945

摘要： An apparatus and method for approximating the data stored in a databases by generating multiple projections and representations from the database such that the OLAP queries for the original database (such as aggregation and histogram operations) may be applied to the approximated version of the database, which can be much smaller than the original databases. Other aspects optimize a mapping, via a mapping (or dimension) table, of non-numeric or numeric attributes to other numeric attributes such that the error incurred on applying queries to the approximated version of the database is minimized. Still further aspects define boundaries of approximations so that the boundaries are preserved when approximated versions of the databases are generated.

摘要翻译： 一种用于通过从数据库生成多个投影和表示来近似存储在数据库中的数据的装置和方法，使得对原始数据库的OLAP查询（诸如聚合和直方图操作）可以应用于数据库的近似版本， 可以比原始数据库小得多。 其他方面通过映射（或维度）表将非数字或数字属性的映射优化为其他数字属性，从而将对数据库近似版本的查询应用所产生的错误最小化。 另外的方面定义了近似的边界，使得当生成数据库的近似版本时边界被保留。

公开(公告)号：US5907849A

公开(公告)日：1999-05-25

申请号：US865156

申请日：1997-05-29

申请人： Daniel Manuel Dias ,  Anant Deep Jhingran ,  Richard Pervin King ,  Christos Polyzois

发明人： Daniel Manuel Dias ,  Anant Deep Jhingran ,  Richard Pervin King ,  Christos Polyzois

IPC分类号： G06F11/14 ,  G06F17/00

CPC分类号： G06F11/2046 ,  G06F11/2033 ,  G06F11/2038 ,  G06F11/1662 ,  Y10S707/99952 ,  Y10S707/99953

摘要： A method and system for recovering from a failure of a processing node in a partitioned shared nothing database processing system are provided. The processing system may include a pair of processing nodes having twin-tailed-connected thereto a storage device. A first processing node of the pair of processing nodes has a first database instance running thereon which accesses a first data partition on the storage device prior to the failure. Upon detection of the failure, access to the first data partition on the storage device is provided to a third, spare processing node through the second processing node of the pair of processing nodes. The third processing node runs a replacement database instance for the first database instance which was running on the first processing node prior to the failure thereof. The replacement database instance accesses the first data partition on the storage device through the second processing node, thereby recovering from the failure of the first processing node. Access to the first data partition may include using a virtual shared disk utility having a server portion on the second processing node and a client portion on the third processing node.

摘要翻译： 提供了一种用于从分区共享数据库处理系统中的处理节点的故障中恢复的方法和系统。 处理系统可以包括一对具有双尾连接到其上的处理节点的存储装置。 该对处理节点的第一处理节点具有在其上运行的第一数据库实例，其在故障之前访问存储设备上的第一数据分区。 在检测到故障时，通过该对处理节点的第二处理节点向第三备用处理节点提供对存储设备上的第一数据分区的访问。 第三处理节点为在其失败之前在第一处理节点上运行的第一数据库实例运行替换数据库实例。 替换数据库实例通过第二处理节点访问存储设备上的第一数据分区，从而从第一处理节点的故障中恢复。 对第一数据分区的访问可以包括使用具有第二处理节点上的服务器部分的虚拟共享磁盘实用程序和第三处理节点上的客户端部分。