专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20130159265A1 Parallel Uniqueness Checks for Partitioned Tables 有权
标题翻译：分区表的并行唯一性检查
公开(公告)号：US20130159265A1
公开(公告)日：2013-06-20
申请号：US13332215
申请日：2011-12-20
申请人： Thomas Peh , Wolfgang Stephan , Andreas Tonder , Lars Fricke , Christian Bensberg
发明人： Thomas Peh , Wolfgang Stephan , Andreas Tonder , Lars Fricke , Christian Bensberg
IPC分类号： G06F17/30
CPC分类号： G06F17/30584
摘要： An insertion of a record into a table that includes a primary key column and a second column that includes a global uniqueness constraint across all of a plurality of data partitions across which the table is split is initiated without checking that a value of the record in the second column is globally unique by contacting other partitions the one partition to which the record is to be added to. The insertion can be processed, at least in part by implementing a write lock on the one partition but without implementing a read lock on the other partitions. The write lock on the one partition can be released after the insertion is completed, after which the validity of the insertion can be verified, for example by examining the other parts and a delta partition corresponding to the table. The insertion can be undone if the insertion was not valid.
摘要翻译：将记录插入到包括主键列和第二列的表中，该主列和第二列包括横跨所述表被分割的多个数据分区的全部唯一性约束，而不检查该表中的记录的值第二列是全局唯一的，通过联系其他分区，将要添加记录的一个分区。可以至少部分地通过在一个分区上实现写入锁定而不在其他分区上实现读取锁来处理该插入。插入完成后，可以释放一个分区上的写锁定，之后可以验证插入的有效性，例如通过检查其他部分和对应于该表的增量分区。如果插入无效，插入可以撤消。

2. 发明授权

US08812564B2 Parallel uniqueness checks for partitioned tables 有权
标题翻译：分区表的并行唯一性检查
公开(公告)号：US08812564B2
公开(公告)日：2014-08-19
申请号：US13332215
申请日：2011-12-20
申请人： Thomas Peh , Wolfgang Stephan , Andreas Tonder , Lars Fricke , Christian Bensberg
发明人： Thomas Peh , Wolfgang Stephan , Andreas Tonder , Lars Fricke , Christian Bensberg
IPC分类号： G06F17/30
CPC分类号： G06F17/30584
摘要： An insertion of a record into a table that includes a primary key column and a second column that includes a global uniqueness constraint across all of a plurality of data partitions across which the table is split is initiated without checking that a value of the record in the second column is globally unique by contacting other partitions the one partition to which the record is to be added to. The insertion can be processed, at least in part by implementing a write lock on the one partition but without implementing a read lock on the other partitions. The write lock on the one partition can be released after the insertion is completed, after which the validity of the insertion can be verified, for example by examining the other parts and a delta partition corresponding to the table. The insertion can be undone if the insertion was not valid.
摘要翻译：将记录插入到包括主键列和第二列的表中，该主列和第二列包括横跨所述表被分割的多个数据分区的全部唯一性约束，而不检查该表中的记录的值第二列是全局唯一的，通过联系其他分区，将要添加记录的一个分区。可以至少部分地通过在一个分区上实现写入锁定而不在其他分区上实现读取锁来处理该插入。插入完成后，可以释放一个分区上的写锁定，之后可以验证插入的有效性，例如通过检查其他部分和对应于该表的增量分区。如果插入无效，插入可以撤消。

3. 发明授权

US10042910B2 Database table re-partitioning using two active partition specifications 有权
公开(公告)号：US10042910B2
公开(公告)日：2018-08-07
申请号：US14188541
申请日：2014-02-24
申请人： Christian Bensberg , Lars Fricke , Juchang Lee , Michael Muehle , Thomas Peh , Wolfgang Stephan
发明人： Christian Bensberg , Lars Fricke , Juchang Lee , Michael Muehle , Thomas Peh , Wolfgang Stephan
IPC分类号： G06F17/30
摘要： Partitioning of source partitions of a table of a database to target partitions is initiated. Thereafter, a transition partition specification is specified that identifies the source partitions and the target partitions. Data is then moved (e.g., asynchronously moved, etc.) from the source partitions to the target partitions. Concurrently with the moving of the data, operates are handled using the transition partition specification. Subsequently, the source partitions are dropped when all of the data has been moved to the target partitions and there are no open transactions accessing the source partitions. Related apparatus, systems, techniques and articles are also described.

4. 发明申请

US20150242451A1 Database Table Re-Partitioning Using Two Active Partition Specifications 审中-公开
标题翻译：使用两个活动分区规范的数据库表重新分区
公开(公告)号：US20150242451A1
公开(公告)日：2015-08-27
申请号：US14188541
申请日：2014-02-24
申请人： Christian Bensberg , Lars Fricke , Juchang Lee , Michael Muehle , Thomas Peh , Wolfgang Stephan
发明人： Christian Bensberg , Lars Fricke , Juchang Lee , Michael Muehle , Thomas Peh , Wolfgang Stephan
IPC分类号： G06F17/30
CPC分类号： G06F17/30584 , G06F17/30578
摘要： Partitioning of source partitions of a table of a database to target partitions is initiated. Thereafter, a transition partition specification is specified that identifies the source partitions and the target partitions. Data is then moved (e.g., asynchronously moved, etc.) from the source partitions to the target partitions. Concurrently with the moving of the data, operates are handled using the transition partition specification. Subsequently, the source partitions are dropped when all of the data has been moved to the target partitions and there are no open transactions accessing the source partitions. Related apparatus, systems, techniques and articles are also described.
摘要翻译：启动将数据库表的源分区分区到目标分区。此后，指定了标识源分区和目标分区的转换分区规范。然后将数据从源分区移动（例如异步移动等）到目标分区。同时随着数据的移动，操作使用转换分区规范进行处理。随后，当所有数据已被移动到目标分区并且没有访问源分区的打开事务时，源分区将被丢弃。还描述了相关设备，系统，技术和物品。

5. 发明申请

US20120310934A1 Historic View on Column Tables Using a History Table 审中-公开
标题翻译：使用历史表的列表上的历史视图
公开(公告)号：US20120310934A1
公开(公告)日：2012-12-06
申请号：US13153333
申请日：2011-06-03
申请人： Thomas Peh , Wolfgang Stephan , Andreas Tonder
发明人： Thomas Peh , Wolfgang Stephan , Andreas Tonder
IPC分类号： G06F17/30
CPC分类号： G06F16/219
摘要： A computer-implemented system and method for providing an historical view of a data record are disclosed. A data record is stored in main memory of a server computer. An instruction to update the data record is received, and the instruction to update the data record is executed to provide a most recent version of the data record. A history table is generated that includes a main table part that represents the most recent version of the data record after the data record is updated, and a history table part that represents one or more past versions of the data record before the data record is updated. The history table is stored in the main memory of the server computer.
摘要翻译：公开了一种用于提供数据记录的历史视图的计算机实现的系统和方法。数据记录存储在服务器计算机的主存储器中。接收到更新数据记录的指令，执行更新数据记录的指令以提供数据记录的最新版本。生成历史表，其包括在更新数据记录之后表示数据记录的最新版本的主表部分，以及在更新数据记录之前表示数据记录的一个或多个过去版本的历史表部分。历史记录表存储在服务器计算机的主存储器中。

6. 发明申请

US20150006466A1 Multiversion concurrency control for columnar database and mixed OLTP/OLAP workload 审中-公开
标题翻译：用于柱状数据库和混合OLTP / OLAP工作负载的多版本并发控制
公开(公告)号：US20150006466A1
公开(公告)日：2015-01-01
申请号：US14017063
申请日：2013-09-03
申请人： Andreas Tonder , Wolfgang Stephan , Ivan Schreter
发明人： Andreas Tonder , Wolfgang Stephan , Ivan Schreter
IPC分类号： G06F17/30
CPC分类号： G06F16/2336
摘要： Online transactional processing (OLTP) transactions and online analytic processing (OLAP) transactions (e.g., aggregation operations, etc.) are both initiated on at least one table within a columnar oriented insert-only database in which at least a portion of the transactions are executed concurrently. Subsequently, it is checked, for each transaction, whether a corresponding record number is visible for the OLTP transaction using a create baselist bitvector and a delete baselist bitvector for the corresponding table. Thereafter, the OLTP transactions and the OLAP transactions having visible corresponding record numbers are executed. Related apparatus, systems, techniques and articles are also described.
摘要翻译：在线交易处理（OLTP）交易和在线分析处理（OLAP）交易（例如，聚合操作等）都在至少一个以行为形式的仅插入数据库中的至少一个表上启动，其中至少一部分交易是同时执行。随后，对于每个事务，检查对应的记录号是否对于OLTP事务是可见的，使用相应表的创建基址位元和删除基线位图。此后，执行具有可见对应记录号的OLTP事务和OLAP事务。还描述了相关设备，系统，技术和物品。

7. 发明申请

US20130226869A1 SELECTION OF ROWS AND VALUES FROM INDEXES WITH UPDATES 有权
公开(公告)号：US20130226869A1
公开(公告)日：2013-08-29
申请号：US13862288
申请日：2013-04-12
申请人： Frank Renkes , Thomas Peh , Andrew Ross , Holger Schwedes , Wolfgang Stephan
发明人： Frank Renkes , Thomas Peh , Andrew Ross , Holger Schwedes , Wolfgang Stephan
IPC分类号： G06F17/30
CPC分类号： G06F17/30581 , G06F17/30336 , G06F17/30492
摘要： Methods and apparatus, including computer program products, for selection of rows and values from indexes with updates. In general, rows of an index may be associated with validity flags that indicate whether a row has been updated with an update inserted in a delta index; one scheme for value identifiers may be used for an index and another scheme for one or more delta indexes where all of the indexes are, to at least some extent, compressed according to dictionary-based compression; and multiple delta indexes may be used in alternation such that one delta index may accept updates while another is being updated. The delta indexes may also have validity flags and all updates, such as modifications of values, deletion of records, and inserting of new records may be handled as updates accepted by one or more delta indexes.

8. 发明申请

US20140289285A1 Equi-Joins Between Split Tables 有权
标题翻译：分离表之间的连接
公开(公告)号：US20140289285A1
公开(公告)日：2014-09-25
申请号：US14297223
申请日：2014-06-05
申请人： Thomas Peh , Holger Schwedes , Wolfgang Stephan
发明人： Thomas Peh , Holger Schwedes , Wolfgang Stephan
IPC分类号： G06F17/30
CPC分类号： G06F17/30289 , G06F17/30466 , G06F17/30498 , G06F17/30545 , G06F17/30584
摘要： A join operation between split data tables includes providing reduction data from first partitions to each partition among second partitions. The reduction data serves to identify actual values in one of the second partitions that also occur in one of the first partitions. Global IDs are assigned. Translation lists including the global IDs are sent to the first partitions. Each first partition and each second partition create globalized lists which can then be combined to generate respective first and second compiled lists. The join operation can then be conducted on the first and second compiled lists.
摘要翻译：分割数据表之间的连接操作包括从第一分区向第二分区中的每个分区提供缩减数据。还原数据用于识别也在第一分区中的一个中发生的第二分区之一中的实际值。全局ID被分配。包括全局ID的翻译列表将发送到第一个分区。每个第一分区和每个第二分区创建全局化列表，然后可以将其组合以生成相应的第一和第二编译列表。然后可以在第一和第二编译列表上进行加入操作。

9. 发明授权

US08527518B2 Inverted indexes with multiple language support 有权
标题翻译：具有多语言支持的反向索引
公开(公告)号：US08527518B2
公开(公告)日：2013-09-03
申请号：US12970766
申请日：2010-12-16
申请人： Frederik Transier , Holger Schwedes , Wolfgang Stephan , Thomas Peh
发明人： Frederik Transier , Holger Schwedes , Wolfgang Stephan , Thomas Peh
IPC分类号： G06F17/30
CPC分类号： G06F17/30622
摘要： A search query for a collection of electronic documents is parsed to identify one or more terms and such identified terms are associated with one or more languages (i.e., spoken languages such as English, German, Spanish, etc.). A terms inverted index and a language inverted index are accessed to identify documents responsive to the query. Related apparatus, systems, techniques and articles are also described.
摘要翻译：解析用于电子文档集合的搜索查询以识别一个或多个术语，并且这些识别的术语与一种或多种语言（即，口语，例如英语，德语，西班牙语等）相关联。访问术语反向索引和语言反转索引以识别响应于查询的文档。还描述了相关设备，系统，技术和物品。

10. 发明授权

US08161024B2 Selection of rows and values from indexes with updates 有权
标题翻译：从具有更新的索引中选择行和值
公开(公告)号：US08161024B2
公开(公告)日：2012-04-17
申请号：US12901268
申请日：2010-10-08
申请人： Frank Renkes , Thomas Peh , Andrew Ross , Holger Schwedes , Wolfgang Stephan
发明人： Frank Renkes , Thomas Peh , Andrew Ross , Holger Schwedes , Wolfgang Stephan
IPC分类号： G06F17/30
CPC分类号： G06F17/30581 , G06F17/30336 , G06F17/30492
摘要： Methods and apparatus, including computer program products, for selection of rows and values from indexes with updates. In general, rows of an index may be associated with validity flags that indicate whether a row has been updated with an update inserted in a delta index; one scheme for value identifiers may be used for an index and another scheme for one or more delta indexes where all of the indexes are, to at least some extent, compressed according to dictionary-based compression; and multiple delta indexes may be used in alternation such that one delta index may accept updates while another is being updated. The delta indexes may also have validity flags and all updates, such as modifications of values, deletion of records, and inserting of new records may be handled as updates accepted by one or more delta indexes.
摘要翻译：方法和设备，包括计算机程序产品，用于从具有更新的索引中选择行和值。通常，索引的行可以与指示是否已经用插入在delta索引中的更新来更新行的有效性标志相关联; 价值标识符的一个方案可以用于索引，另一个方案用于一个或多个增量索引，其中所有索引至少在一定程度上根据基于字典的压缩被压缩; 并且可以交替地使用多个增量索引，使得一个增量索引可以接受更新，而另一个增量索引正在被更新。增量索引还可以具有有效性标志，并且可以将所有更新（例如值的修改，记录的删除和插入新记录）处理为由一个或多个增量索引接受的更新。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式