会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 6. 发明申请
    • ONE-PHASE COMMIT IN A SHARED-NOTHING DATABASE SYSTEM
    • 一个共享数据库系统中的一个阶段的委托
    • WO2005013155A1
    • 2005-02-10
    • PCT/US2004/024451
    • 2004-07-28
    • ORACLE INTERNATIONAL CORPORATIONBAMFORD, RogerCHANDRASEKARAN, SashikanthPRUSCINO, Angelo
    • BAMFORD, RogerCHANDRASEKARAN, SashikanthPRUSCINO, Angelo
    • G06F17/30
    • G06F17/30575G06F9/5083Y10S707/972Y10S707/99944
    • Techniques are provided for handling distributed transaction in shared-nothing database system where one or more of the nodes have access to a shared persistent storage. Rather than coordinate the distributed transaction using a two-phase commit protocol, the coordinator of the distributed transaction uses a one-phase commit protocol with those participants that have access to the transaction status information maintained by the coordinator. The transaction status information may reside, for example, in the redo log of the coordinator. In case that the coordinator fails, those participants can determine the state of the distributed transaction based on information stored on the shared disk. In addition, the coordinator is able to determine whether it is possible to commit the distributed transaction based on information that is stored on the shared disk by the participants, without those participants entering a formal "prepared " state.
    • 提供了用于在无共享数据库系统中处理分布式事务的技术,其中一个或多个节点可以访问共享持久存储。 分布式事务的协调器不是使用两阶段提交协议来协调分布式事务,而是与那些能够访问协调器维护的事务状态信息的参与者使用一阶段提交协议。 事务状态信息可以驻留在例如协调器的重做日志中。 在协调器失败的情况下,这些参与者可以基于存储在共享磁盘上的信息来确定分布式事务的状态。 此外,协调器能够根据参与者在共享磁盘上存储的信息来确定是否可以提交分布式事务,而不需要参与者进入正式的“准备”状态。
    • 7. 发明申请
    • SYSTEM AND METHOD FOR PERFORMING JOINS AND SELF-JOINS IN A DATABASE SYSTEM
    • 在数据库系统中执行联接和自我接合的系统和方法
    • WO98050867A1
    • 1998-11-12
    • PCT/US1998/008339
    • 1998-04-24
    • G06F17/30
    • G06F17/30501G06F17/30498Y10S707/972Y10S707/99932
    • A technique for efficiently joining multiple large tables in a database system which utilizes a join index (221, 223, 225). The technique uses a join index and minimizes the number of input/output operations while maximizing the use of the small main memory through a buffer allocation process based on the join index entries. The technique uses multi-dimentional partitioning and assigns partition identifier (241, 243, 245) to each buffer which are used to coordinate the resultant output files when the technique is complete. The output is vertically fragmented with one fragment for each input table which further allows the individual processing of each input table. The technique performs self-joins in a very efficient manner by requiring the records of the input table to be read only once.
    • 一种用于在利用连接索引(221,223,225)的数据库系统中有效地连接多个大表的技术。 该技术使用连接索引并且最小化输入/输出操作的数量,同时通过基于连接索引条目的缓冲器分配过程最大化使用小主存储器。 该技术使用多维划分,并为每个缓冲区分配分区标识符(241,243,245),用于在技术完成时协调结果输出文件。 输出垂直分段,每个输入表有一个片段,进一步允许每个输入表的单独处理。 该技术通过要求输入表的记录只读一次,以非常有效的方式执行自联接。