会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 1. 发明申请
    • Accelerated Join Process in Relational Database Management System
    • 关系数据库管理系统中加速加入流程
    • US20120310917A1
    • 2012-12-06
    • US13149180
    • 2011-05-31
    • Vadim SheininHangu Yeo
    • Vadim SheininHangu Yeo
    • G06F17/30
    • G06F16/24561G06F16/2456
    • Techniques are provided for an accelerated join process in a relational database management system. The disclosed join method partitions a plurality of input records using a hash-based technique to form a plurality of partitioned blocks. The partitioned blocks are sorted to form sorted partitioned blocks. The sorted partitioned blocks are then compressed to form a plurality of compressed blocks of records. The compressed blocks of records are stored for each partition in a storage system. The compressed blocks of records associated with a pair of partitions can then be loaded into a main memory. The loaded compressed blocks of records are then decompressed and the decompressed blocks of records are merged into associated merged partitions. Finally, two of the merged partitions are joined by comparing records from each merged partition. In a multi-threaded implementation, multiple pairs of merged partitions can be joined in parallel.
    • 提供了在关系数据库管理系统中加速加入流程的技术。 所公开的连接方法使用基于散列的技术分割多个输入记录以形成多个分区块。 分区块被排序以形成分类分区块。 然后将分类的分区块压缩以形成多个压缩的记录块。 为存储系统中的每个分区存储压缩的记录块。 然后可以将与一对分区相关联的记录的压缩块加载到主存储器中。 然后将加载的压缩的记录块解压缩,并将解压缩的记录块合并到关联的合并分区中。 最后,通过比较每个合并分区的记录来连接两个合并的分区。 在多线程实现中,可以并行连接多对合并分区。