SQL code generation for heterogeneous environment
    2.
    发明申请
    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)编译生成的源代码以形成用于实现主题查询的机器可执行代码。 因此,查询直接作为机器可执行代码执行,从而避免了执行计划中的程序段的运行时解释。

    Optimized database appliance
    3.
    发明申请

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

    Network interface for distributed intelligence database system
    4.
    发明申请
    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.

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

    Disk mirror architecture for database appliance with locally balanced regeneration
    5.
    发明申请
    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.

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

    Limiting scans of loosely ordered and/or grouped relations using nearly ordered maps
    6.
    发明申请
    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.

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

    Notebook and notebook cover assembly
    8.
    发明授权
    Notebook and notebook cover assembly 失效
    笔记本和笔记本电脑盖组件

    公开(公告)号:US5503486A

    公开(公告)日:1996-04-02

    申请号:US206359

    申请日:1994-03-07

    申请人: Barry Zane

    发明人: Barry Zane

    CPC分类号: B42F3/04 B42F13/402

    摘要: The improved notebook and notebook cover assembly of the present invention includes a notebook, preferably of a loose-leaf type, and a sub-assembly which includes front and rear notebook covers, an edge binder interconnecting the two covers and foldable back upon itself, and a notebook connector releasably interconnecting the notebook only to the covers. Due to the edge binder the covers are movable between a first position wherein the front cover overlies and protects the notebook and a second position wherein the front cover is behind and flat against the rear cover, thus fully exposing the notebook and supporting it in a flat position for easy viewing and writing therein. The edge binder can have a longitudinal fold line along the length of the center line of the central portion thereof, or can be divided along that center line into two halves joined together by a hinge, such as a piano hinge or a flexible strip of plastic, cloth, paper or rubber. Openable rings or the like releasably secure the notebook to the covers, either directly thereto or to wings connected to the inner surfaces of the covers. If desired, the edge binder can be integral with the covers. Detents may be present on the covers to releasably hold them together when the front cover is in the second position.

    摘要翻译: 本发明的改进的笔记本电脑和笔记本电脑盖组件包括优选为活页式笔记本的笔记本电脑和包括前后笔记本电脑外盖的子组件,将两个盖子相互连接的边缘固定件,并可自行折叠, 笔记本连接器将笔记本电脑可拆卸地互连到盖子。 由于边缘装订器,盖可以在第一位置和第二位置之间移动,其中前盖覆盖并保护笔记本,并且第二位置,其中前盖在后盖之后并且平靠在后盖上,从而完全暴露笔记本并将其支撑在平面中 位置,方便查看和写入。 边缘粘合剂可以沿着其中心部分的中心线的长度具有纵向折叠线,或者可以沿着该中心线分成通过铰链(诸如钢琴铰链或柔性塑料条)连接在一起的两个半部 ,布,纸或橡胶。 可打开的环等可将笔记本电脑直接固定到盖子上或者连接到盖子的内表面的翼片上。 如果需要,边缘粘合剂可以与盖一体。 当前盖处于第二位置时,护套可能存在于盖上以可释放地将它们保持在一起。

    Loose leaf binder assembly and spine therefor
    10.
    发明授权
    Loose leaf binder assembly and spine therefor 失效
    松散的叶片组合件和脊柱

    公开(公告)号:US5692847A

    公开(公告)日:1997-12-02

    申请号:US620724

    申请日:1996-03-19

    IPC分类号: B42F13/26 B42F3/04

    CPC分类号: B42F13/26

    摘要: The improved loose leaf ring binder assembly includes a binder having a central vertical back portion connected to laterally extending wings or side portions which form the front and back covers of the binder. The assembly also includes a vertically extending spine connected to the front surface of the back portion. The spine is in the form of a hollow tube having closed upper and lower ends and containing a spaced pair of vertical rods. The inner ends of half rings are connected to the rods at spaced intervals along the length thereof. The half rings extend laterally outwardly from the rods through openings on opposite sides of the tube. The free ends of the half rings on one side of the tube are adapted to mate with half rings from the opposite side of the tube to form complete rings to releasably hold loose perforated sheets in place in the binder. The rod secured to the half rings on one side of the spine is vertically biased by a spring in the tube to facilitate fitting the free ends of the half rings together to form complete rings. In one embodiment, the half rings on one side of the spine are locked against rotation, as by fixedly connecting in the tube the rod to which they are connected. In another embodiment, a sleeve which can be screwed into and out of contact with the spring biased rod end can releasably lock the rings shut or open. The pair of rod and half rings can be identical, in some embodiments.

    摘要翻译: 改进的松散叶环粘合剂组件包括粘合剂,其具有连接到形成粘合剂的前盖和后盖的横向延伸的翼或侧部的中心垂直后部。 组件还包括连接到后部的前表面的垂直延伸的脊柱。 脊柱呈中空管的形式,具有封闭的上端和下端并且包含间隔开的一对垂直杆。 半环的内端沿着其长度以间隔的间隔连接到杆。 半环从杆的横向向外延伸穿过管的相对侧上的开口。 管的一侧上的半环的自由端适于与管的相对侧配合半环以形成完整的环,以将松散的多孔板可释放地保持在粘合剂中的适当位置。 固定在脊柱一侧上的半环的杆通过管中的弹簧垂直偏置,以便将半环的自由端装配在一起形成完整的环。 在一个实施例中,脊的一侧上的半环被锁定以防止旋转,如通过将其连接到的杆固定在管中。 在另一个实施例中,可以与弹簧偏压的杆端螺纹连接并脱离接触的套筒可以可释放地锁定环闭合或打开。 在一些实施例中,一对杆和半环可以是相同的。