Disk mirror architecture for database appliance with locally balanced regeneration
    1.
    发明申请
    Disk mirror architecture for database appliance with locally balanced regeneration 失效
    具有局部平衡再生的数据库设备的磁盘镜像架构

    公开(公告)号:US20050022051A1

    公开(公告)日:2005-01-27

    申请号:US10885519

    申请日:2004-07-06

    IPC分类号: G06F11/20 G06F11/00

    摘要: A disk is segmented into a first data segment and a secondary data segment. The secondary data segment stores a logical mirror of the first data segment of another disk. Upon detecting a failure, the logical mirror of data stored in the first data segment of the failed disk is accessible from the secondary data segment of a non-failed disk. The first data segment can be rebuilt quickly on another disk from the logical mirror stored in the secondary data segment. During regenerating, accesses to the first data segment on the disk containing the logical mirror are handled by its own logical mirror, which is not involved in the regenerating process.

    摘要翻译: 磁盘被分割成第一数据段和辅助数据段。 辅助数据段存储另一个磁盘的第一个数据段的逻辑镜像。 在检测到故障时,存储在故障磁盘的第一数据段中的数据的逻辑镜像可从非故障磁盘的辅助数据段访问。 可以从存储在辅助数据段中的逻辑镜像在另一个磁盘上快速重建第一个数据段。 在重新生成期间,对包含逻辑镜像的磁盘上的第一个数据段的访问由其自己的逻辑镜像来处理,该逻辑镜不在再生过程中。

    Optimized database appliance
    2.
    发明申请

    公开(公告)号:US20060129542A1

    公开(公告)日:2006-06-15

    申请号:US11332704

    申请日:2006-01-13

    IPC分类号: G06F17/30

    摘要: A system from processing database queries allows for cost and locale based distribution for execution of database queries. The database queries are executed on execution engines that provide flexible configuration and overlapping functionality. The system reduces various costs, including elapsed time, required to perform database queries. The system provides processing of a database query using a database catalog comprising database table locality information, record locality information and execution engine information. A query optimizer receives the query and accesses the database catalog to create a query execution plan comprising locality-based database operations. A central database operation processor providing a first execution engine executes the query execution plan by performing at least a portion of the locality-based database operations and distributing at least a portion of the locality-based database operations as a subplan. A second database operation processor providing a second execution engine executes the subplan received from the central database operation processor. At least one of the database operations can be executed on either the first execution engine or the second execution engine. A storage unit stores at least a portion of database tables and records. A data communications network connects the central database processor to the second database processor.

    Limiting scans of loosely ordered and/or grouped relations using nearly ordered maps
    3.
    发明申请
    Limiting scans of loosely ordered and/or grouped relations using nearly ordered maps 有权
    使用几乎有序的地图来限制使用松散排序和/或分组关系的扫描

    公开(公告)号:US20050010564A1

    公开(公告)日:2005-01-13

    申请号:US10847895

    申请日:2004-05-18

    摘要: A large information space is divided into many smaller information extents. These extents are annotated with statistics about the information they contain. When a search for information includes a restriction based on value, the desired value ranges can be compared to the value ranges of each extent. If the desired value range lies outside the range of the extent, then the extent cannot hold the desired value and does not need to be included in the search.

    摘要翻译: 大的信息空间被分为许多较小的信息范围。 这些扩展名通过统计信息来注释它们包含的信息。 当搜索信息包括基于值的限制时,可以将期望的值范围与每个范围的值范围进行比较。 如果期望的值范围在范围的范围之外,则该范围不能保持所需的值,并且不需要包括在搜索中。

    SQL code generation for heterogeneous environment
    4.
    发明申请
    SQL code generation for heterogeneous environment 有权
    用于异构环境的SQL代码生成

    公开(公告)号:US20050028134A1

    公开(公告)日:2005-02-03

    申请号:US10887247

    申请日:2004-07-07

    IPC分类号: G06F9/44 G06F17/30

    摘要: This invention relates generally to a system for processing database queries, and more particularly to a method for generating high level language or machine code to implement query execution plans. In one preferred embodiment, the method begins by receiving a subject query, and then forming an execution plan corresponding to the subject query. The execution plan will typically have a sequence of component snippets or pieces and corresponding processes for implementing the pieces. For at least one piece in the plan, the process then (a) generates source code using different code generation techniques as a function of expected runtime processing machine types; and then (b) compiles the generated source code to form machine executable code for implementing the subject query. As a result, the query executed directly as machine executable code thereby avoiding runtime interpretation of the pieces in the execution plan.

    摘要翻译: 本发明一般涉及用于处理数据库查询的系统,更具体地说,涉及一种用于生成高级语言或机器代码来实现查询执行计划的方法。 在一个优选实施例中,该方法开始于接收主题查询,然后形成对应于对象查询的执行计划。 执行计划通常将具有一系列组件片段或片段以及用于实现片段的相应过程。 对于计划中的至少一个,过程然后(a)使用不同的代码生成技术生成源代码作为预期的运行时处理机器类型的函数; 然后(b)编译生成的源代码以形成用于实现主题查询的机器可执行代码。 因此,查询直接作为机器可执行代码执行,从而避免了执行计划中的程序段的运行时解释。

    Network interface for distributed intelligence database system
    6.
    发明申请
    Network interface for distributed intelligence database system 有权
    分布式智能数据库系统的网络接口

    公开(公告)号:US20080046438A1

    公开(公告)日:2008-02-21

    申请号:US11900222

    申请日:2007-09-11

    IPC分类号: G06F17/30

    摘要: A database appliance in which two or more internetworked data storage units are used to coordinate the storage and retrieval of database records. One or more central database processing units are also associated with the data storage units. A network infrastructure provides the ability for the central database processors and storage processors to communicate as network nodes, with the network infrastructure using a communication protocol. A software application for executing database operations executes in a distributed fashion with portions of the database application executing on at least one central database processor and other portions executing on the data storage processors. At least a portion of the database application is implemented within and/or coordinated by a communication process that is executing the communication protocol. This coordination takes place such that data blocks are passed between the communication process and at least one portion of the database application process by passing data block reference information. In accordance with other aspects of the present invention, the communication process may have at least portions of the database application process executing within it. These database application operations executing within the same context as the communication process may include database operations such as join, sort, aggregate, restrict, reject, expression evaluation, statistical analysis or other operations.

    摘要翻译: 数据库设备,其中使用两个或多个互联数据存储单元来协调数据库记录的存储和检索。 一个或多个中央数据库处理单元也与数据存储单元相关联。 网络基础设施提供中央数据库处理器和存储处理器作为网络节点通信的能力,网络基础设施使用通信协议。 用于执行数据库操作的软件应用程序以分布式方式执行,数据库应用的部分在至少一个中央数据库处理器上执行并且在数据存储处理器上执行的其他部分执行。 数据库应用的至少一部分在正在执行通信协议的通信过程中实现和/或协调。 发生这种协调,使得数据块通过传递数据块参考信息在通信进程和数据库应用进程的至少一部分之间传递。 根据本发明的其他方面,通信过程可以具有在其内执行的数据库应用进程的至少一部分。 在与通信过程相同的上下文中执行的这些数据库应用操作可以包括数据库操作,例如连接,排序,聚合,限制,拒绝,表达式评估,统计分析或其他操作。

    Backlit faceplate for data appliances and related methods
    7.
    发明申请
    Backlit faceplate for data appliances and related methods 审中-公开
    背光面板,用于数据设备及相关方法

    公开(公告)号:US20080276505A1

    公开(公告)日:2008-11-13

    申请号:US11801573

    申请日:2007-05-09

    IPC分类号: G09F13/00

    CPC分类号: G09F13/04

    摘要: A display for a data-appliance cabinet comprises a panel having front and rear surfaces and dimensions matching a front-side portion of a data-appliance cabinet allocated to an absent accessory device, a translucent window through the panel, a light source for illuminating the translucent window via the rear surface of the panel, and means facilitating installation of the backlit display.

    摘要翻译: 用于数据设备机柜的显示器包括具有前表面和后表面以及与分配给不存在的附件设备的数据设备柜的前侧部分相匹配的尺寸的面板,通过面板的半透明窗口,用于照亮 通过面板的后表面的半透明窗口,以及便于安装背光显示器的装置。

    STORAGE AND RETRIEVAL SYSTEM
    8.
    发明申请
    STORAGE AND RETRIEVAL SYSTEM 有权
    存储和检索系统

    公开(公告)号:US20100316468A1

    公开(公告)日:2010-12-16

    申请号:US12757220

    申请日:2010-04-09

    IPC分类号: B65G1/137 B65G1/06

    摘要: A storage and retrieval system including a vertical array of storage levels, each storage level having, picking aisles, storage locations, disposed within the picking aisles, and at least one transfer deck providing access to the picking aisles, a multilevel vertical conveyor system configured to transport the uncontained case units to and from the vertical array of storage levels, each storage level being configured to receive uncontained case units from the multilevel vertical conveyor system, at least one autonomous transport located on each storage level for transporting the uncontained case units between respective storage locations and the multilevel vertical conveyor system, and a controller configured to create a primary access path through the transfer decks and picking aisles to a predetermined one of the storage locations and at least one secondary access path to the predetermined one of the storage locations when the primary path is impassible.

    摘要翻译: 一种存储和检索系统,包括垂直阵列的存储级别,每个存储级别具有设置在采摘通道内的选择通道,存储位置,以及提供对采摘过道的访问的至少一个转移甲板;多层垂直输送系统,被配置为 将未包含的壳体单元运送到垂直阵列的存储级别,每个存储级别被配置为从多层垂直传送器系统接收未容纳的壳体单元,位于每个存储层上的至少一个自主传送装置,用于在相应的位置之间传送未包含的壳体单元 存储位置和多层垂直输送机系统,以及控制器,其被配置为创建通过所述转移甲板的主要进入路径并且将通道挑选到所述存储位置中的预定的一个以及至所述预定的一个所述存储位置的至少一个次要进入路径, 主要途径是不可能的。