专利快速检索-快速检索全球专利，免费商用专利数据库-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. 发明申请

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.
摘要翻译：公开了一种用于提供数据记录的历史视图的计算机实现的系统和方法。数据记录存储在服务器计算机的主存储器中。接收到更新数据记录的指令，执行更新数据记录的指令以提供数据记录的最新版本。生成历史表，其包括在更新数据记录之后表示数据记录的最新版本的主表部分，以及在更新数据记录之前表示数据记录的一个或多个过去版本的历史表部分。历史记录表存储在服务器计算机的主存储器中。

3. 发明授权

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.
摘要翻译：将记录插入到包括主键列和第二列的表中，该主列和第二列包括横跨所述表被分割的多个数据分区的全部唯一性约束，而不检查该表中的记录的值第二列是全局唯一的，通过联系其他分区，将要添加记录的一个分区。可以至少部分地通过在一个分区上实现写入锁定而不在其他分区上实现读取锁来处理该插入。插入完成后，可以释放一个分区上的写锁定，之后可以验证插入的有效性，例如通过检查其他部分和对应于该表的增量分区。如果插入无效，插入可以撤消。

4. 发明申请

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事务。还描述了相关设备，系统，技术和物品。

5. 发明申请

US20140236912A1 Time Slider Operator For Temporal Data Aggregation 有权
标题翻译：时间滑块运算符用于时间数据聚合
公开(公告)号：US20140236912A1
公开(公告)日：2014-08-21
申请号：US14265042
申请日：2014-04-29
申请人： Martin Kaufmann , Norman May , Andreas Tonder , Donald Kossmann
发明人： Martin Kaufmann , Norman May , Andreas Tonder , Donald Kossmann
IPC分类号： G06F17/30
CPC分类号： G06F17/30309 , G06F17/30353 , G06F17/30371 , G06F17/30551
摘要： Calculation of aggregated values in a history database table can be optimized using an approach in which an ordered history table is accessed. The ordered history table can include a sequential listing of commit identifiers associated with updates, insertions, and/or deletions to values in the database table. The ordered history table can be traversed in a single pass to calculate an aggregation function using an optimized algorithm. The optimized algorithm can enable calculation of an aggregated metric of the values based on a selected method for tracking invalidated values to their corresponding commit identifiers. The calculated metric is generated for a current version of the database table; and promoted.
摘要翻译：可以使用访问有序历史表的方法来优化历史数据库表中的聚合值的计算。有序历史表可以包括与数据库表中的值的更新，插入和/或删除相关联的提交标识符的顺序列表。可以在一次通过中遍历有序历史表，使用优化算法计算聚合函数。优化的算法可以使得能够基于用于将无效值跟踪到其对应的提交标识符的所选择的方法计算值的聚合度量。为数据库表的当前版本生成计算的度量; 并提拔。

6. 发明申请

US20150242400A1 Database Table Re-Partitioning Using Trigger-Based Capture and Replay 审中-公开
标题翻译：使用基于触发的捕获和重放的数据库表重新分区
公开(公告)号：US20150242400A1
公开(公告)日：2015-08-27
申请号：US14188543
申请日：2014-02-24
申请人： Christian Bensberg , Franz Faerber , Lars Fricke , Juchang Lee , Roland Sedler , Andreas Tonder , Emanuel Ziegler
发明人： Christian Bensberg , Franz Faerber , Lars Fricke , Juchang Lee , Roland Sedler , Andreas Tonder , Emanuel Ziegler
IPC分类号： G06F17/30
CPC分类号： G06F17/30339
摘要： Partitioning of a source table of a database to a target table is initiated. Thereafter, a replay table is generated that is populated with triggers for database operations performed on the source table for subsequent replay for the target partitions. Data is later moved (e.g., asynchronously moved, etc.) from the source table to the target table. The database operations are replayed on the target table T subsequent to the moving of the data using the replay table. In addition, the source table is dropped when all of the data has been moved to the target table and there are no operations requiring replay. Related apparatus, systems, techniques and articles are also described.
摘要翻译：启动将数据库的源表分区到目标表。此后，生成重播表，其中填充有用于在源表上执行的数据库操作的触发器，用于目标分区的后续重放。数据稍后从源表移动到目标表（例如异步移动等）。在使用重放表移动数据之后，在目标表T上重播数据库操作。此外，当所有数据已被移动到目标表并且没有需要重放的操作时，源表被删除。还描述了相关设备，系统，技术和物品。

7. 发明授权

US08751525B2 Time slider operator for temporal data aggregation 有权
标题翻译：时间滑块运算符用于时间数据聚合
公开(公告)号：US08751525B2
公开(公告)日：2014-06-10
申请号：US13336951
申请日：2011-12-23
申请人： Martin Kaufmann , Norman May , Andreas Tonder , Donald Kossmann
发明人： Martin Kaufmann , Norman May , Andreas Tonder , Donald Kossmann
IPC分类号： G06F17/30
CPC分类号： G06F17/30309 , G06F17/30353 , G06F17/30371 , G06F17/30551
摘要： Calculation of aggregated values in a history database table can be optimized using an approach in which an ordered history table is accessed. The ordered history table can include a sequential listing of commit identifiers associated with updates, insertions, and/or deletions to values in the database table. The ordered history table can be traversed in a single pass to calculate an aggregation function using an optimized algorithm. The optimized algorithm can enable calculation of an aggregated metric of the values based on a selected method for tracking invalidated values to their corresponding commit identifiers. The calculated metric is generated for a current version of the database table; and promoted.
摘要翻译：可以使用访问有序历史表的方法来优化历史数据库表中的聚合值的计算。有序历史表可以包括与数据库表中的值的更新，插入和/或删除相关联的提交标识符的顺序列表。可以在一次通过中遍历有序历史表，使用优化算法计算聚合函数。优化的算法可以使得能够基于用于将无效值跟踪到其对应的提交标识符的所选择的方法计算值的聚合度量。为数据库表的当前版本生成计算的度量; 并提拔。

8. 发明申请

US20130166522A1 TIME SLIDER OPERATOR FOR TEMPORAL DATA AGGREGATION 有权
标题翻译：用于时间数据聚合的时间滑移操作器
公开(公告)号：US20130166522A1
公开(公告)日：2013-06-27
申请号：US13336951
申请日：2011-12-23
申请人： Martin Kaufmann , Norman May , Andreas Tonder , Donald Kossmann
发明人： Martin Kaufmann , Norman May , Andreas Tonder , Donald Kossmann
IPC分类号： G06F17/30
CPC分类号： G06F17/30309 , G06F17/30353 , G06F17/30371 , G06F17/30551
摘要： Calculation of aggregated values in a history database table can be optimized using an approach in which an ordered history table is accessed. The ordered history table can include a sequential listing of commit identifiers associated with updates, insertions, and/or deletions to values in the database table. The ordered history table can be traversed in a single pass to calculate an aggregation function using an optimized algorithm. The optimized algorithm can enable calculation of an aggregated metric of the values based on a selected method for tracking invalidated values to their corresponding commit identifiers. The calculated metric is generated for a current version of the database table; and promoted.
摘要翻译：可以使用访问有序历史表的方法来优化历史数据库表中的聚合值的计算。有序历史表可以包括与数据库表中的值的更新，插入和/或删除相关联的提交标识符的顺序列表。可以在一次通过中遍历有序历史表，使用优化算法计算聚合函数。优化的算法可以使得能够基于用于将无效值跟踪到其对应的提交标识符的所选择的方法计算值的聚合度量。为数据库表的当前版本生成计算的度量; 并提拔。

9. 发明授权

US10552402B2 Database lockless index for accessing multi-version concurrency control data 有权
公开(公告)号：US10552402B2
公开(公告)日：2020-02-04
申请号：US14553723
申请日：2014-11-25
申请人： Amarnadh Sai Eluri , Ivan Schreter , Andreas Tonder
发明人： Amarnadh Sai Eluri , Ivan Schreter , Andreas Tonder
IPC分类号： G06F16/23 , G06F16/22
摘要： An operation on a row of a table of a database is initiated. Thereafter, a multi-version concurrency control (MVCC) object is accessed to identify blocks associated with the row position of the row using bitwise operations. Subsequently, a row state block computed based on the row position of the row is accessed to determine a row state for the row. At least one other block is accessed, based in part on the row state, to obtain at least one timestamp from the computed offset based on the row. Next, the at least one timestamp is stored or retrieved. Related apparatus, systems, techniques and articles are also described.

10. 发明授权

US10055440B2 Database table re-partitioning using trigger-based capture and replay 有权
公开(公告)号：US10055440B2
公开(公告)日：2018-08-21
申请号：US14188543
申请日：2014-02-24
申请人： Christian Bensberg , Franz Faerber , Lars Fricke , Juchang Lee , Roland Sedler , Andreas Tonder , Emanuel Ziegler
发明人： Christian Bensberg , Franz Faerber , Lars Fricke , Juchang Lee , Roland Sedler , Andreas Tonder , Emanuel Ziegler
IPC分类号： G06F17/30
CPC分类号： G06F16/2282
摘要： Partitioning of a source table of a database to a target table is initiated. Thereafter, a replay table is generated that is populated with triggers for database operations performed on the source table for subsequent replay for the target partitions. Data is later moved (e.g., asynchronously moved, etc.) from the source table to the target table. The database operations are replayed on the target table T subsequent to the moving of the data using the replay table. In addition, the source table is dropped when all of the data has been moved to the target table and there are no operations requiring replay. Related apparatus, systems, techniques and articles are also described.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式