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

31. 发明授权

US09176995B2 Organization of data within a database 有权
标题翻译：在数据库中组织数据
公开(公告)号：US09176995B2
公开(公告)日：2015-11-03
申请号：US12946054
申请日：2010-11-15
申请人： Tianchao Li , Peter Bendel , Oliver Draese , Namik Hrle
发明人： Tianchao Li , Peter Bendel , Oliver Draese , Namik Hrle
IPC分类号： G06F17/30
CPC分类号： G06F17/30339 , G06F17/30286 , G06F17/30289 , G06F17/30342 , G06F17/30345 , G06F17/30598
摘要： A computer implemented method is provided for processing data representing a data entity having sub entities. The method includes analyzing queries to the data entity for deriving information about sets of the sub entities frequently queried together, and grouping the sub entities to a number of banks, each bank having a maximum width, based on the information about sets of sub entities frequently queried together, in order to reduce an average number of banks to be accessed for data retrieval.
摘要翻译：提供了一种用于处理表示具有子实体的数据实体的数据的计算机实现的方法。该方法包括分析对数据实体的查询，用于导出关于一起经常查询的子实体的集合的信息，并且基于关于子实体的集合的信息频繁地将子实体分组到多个银行，每个银行具有最大宽度一起查询，以减少要进行数据检索的银行平均数量。

32. 发明授权

US08653993B2 Data value occurrence information for data compression 失效
标题翻译：用于数据压缩的数据值出现信息
公开(公告)号：US08653993B2
公开(公告)日：2014-02-18
申请号：US13515043
申请日：2010-12-07
申请人： Peter Bendel , Oliver Draese , Namik Hrle , Tianchao Li
发明人： Peter Bendel , Oliver Draese , Namik Hrle , Tianchao Li
IPC分类号： H03M7/40
CPC分类号： H03M7/30
摘要： A method for generating occurrence data of data values for enabling encoding of a data set includes determining occurrences of data values in a first data batch and determining occurrence count information for a first number of most frequent data values in the first data batch, the occurrence count information identifying the most frequent data values and their occurrence counts. The method also includes generating for rest of the data values in the first data batch at least a first histogram having a second number of buckets and merging the occurrence count information of the first data batch with occurrence count information of a second data batch. The method further includes merging the first histogram of the first data batch to a merged histogram corresponding to the second data batch and processing a next data batch as a first data batch until the data set to be encoded is processed.
摘要翻译：一种用于产生用于使数据集编码的数据值的出现数据的方法，包括：确定第一数据批中的数据值的出现以及确定第一数据批中第一数量最频繁数据值的出现次数信息，发生次数识别最频繁的数据值及其发生次数的信息。该方法还包括在第一数据批中生成具有第二数量桶的至少第一直方图的剩余数据值，并且将第一数据批次的发生计数信息与第二数据批次的发生计数信息进行合并。该方法还包括将第一数据批次的第一直方图合并到与第二数据批次相对应的合并直方图，并将下一数据批处理作为第一数据批次，直到处理要编码的数据集。

33. 发明授权

US08626717B2 Database backup and restore with integrated index reorganization 有权
标题翻译：数据库备份与恢复与综合索引重组
公开(公告)号：US08626717B2
公开(公告)日：2014-01-07
申请号：US13465381
申请日：2012-05-07
申请人： Amit Bendakovsky , Namik Hrle , Thomas Ritter
发明人： Amit Bendakovsky , Namik Hrle , Thomas Ritter
IPC分类号： G06F17/30
CPC分类号： G06F11/1469 , G06F11/1448 , G06F11/1458 , G06F11/1471 , G06F2201/80
摘要： A mechanism is provided for reorganizing a source index tree of a database table resulting in a target index tree of the database table is provided. A backup process reads source leaf pages of the source index tree in a logical order defined by a sequence of index keys. The logical order can be different from a physical order of the source leaf pages defined by a sequence of respective storage locations. The backup process constructs target leaf pages of the target index tree maintaining the logical order. A restore process constructs target non-leaf pages of the target index tree based on the distribution of the index keys among the constructed leaf pages and stores the target leaf and non-leaf pages.
摘要翻译：提供了一种用于重新组织数据库表的源索引树的机制，导致提供了数据库表的目标索引树。备份过程按照索引键序列定义的逻辑顺序读取源索引树的源页面页面。逻辑顺序可以不同于由各个存储位置的序列定义的源叶子页的物理顺序。备份过程构建维护逻辑顺序的目标索引树的目标叶页面。恢复过程基于构建的叶子页面中的索引关键字的分布来构建目标索引树的目标非叶子页面，并存储目标叶子和非叶子页面。

34. 发明授权

US08442988B2 Adaptive cell-specific dictionaries for frequency-partitioned multi-dimensional data 失效
标题翻译：用于频率分割的多维数据的自适应小区特定字典
公开(公告)号：US08442988B2
公开(公告)日：2013-05-14
申请号：US12939605
申请日：2010-11-04
申请人： Oliver Draese , Namik Hrle , Oliver Koeth , Tianchao Li , Vijayshankar Raman , Knut Stolze
发明人： Oliver Draese , Namik Hrle , Oliver Koeth , Tianchao Li , Vijayshankar Raman , Knut Stolze
IPC分类号： G06F17/30
CPC分类号： G06F17/30592
摘要： A cell-specific dictionary is applied adaptively to adequate cells, where the cell-specific dictionary subsequently optimizes the handling of frequency-partitioned multi-dimensional data. This includes improved data partitioning with super cells or adjusting resulting cells by sub-dividing very large cells and merging multiple small cells, both of which avoid the highly skewed data distribution in cells and improve the query processing. In addition, more efficient encoding is taught within a cell in case the distinct values that actually appear in that cell are much smaller than the size of the column dictionary.
摘要翻译：小区特定字典自适应地应用于适当的小区，其中小区特定字典随后优化频分区多维数据的处理。这包括使用超级单元的改进的数据分区或通过划分非常大的单元并合并多个小单元来调整所得到的单元，这两者都避免了单元格中高度偏斜的数据分布并改进查询处理。另外，如果在该单元中实际出现的不同值远小于列字典的大小，则在单元格内教授更有效的编码。

35. 发明申请

US20130033389A1 DATA VALUE OCCURRENCE INFORMATION FOR DATA COMPRESSION 失效
标题翻译：数据压缩的数据值信息
公开(公告)号：US20130033389A1
公开(公告)日：2013-02-07
申请号：US13515043
申请日：2010-12-07
申请人： Peter Bendel , Oliver Draese , Namik Hrle , Tianchao Li
发明人： Peter Bendel , Oliver Draese , Namik Hrle , Tianchao Li
IPC分类号： H03M7/30
CPC分类号： H03M7/30
摘要： A method for generating occurrence data of data values for enabling encoding of a data set includes determining occurrences of data values in a first data batch and determining occurrence count information for a first number of most frequent data values in the first data batch, the occurrence count information identifying the most frequent data values and their occurrence counts. The method also includes generating for rest of the data values in the first data batch at least a first histogram having a second number of buckets and merging the occurrence count information of the first data batch with occurrence count information of a second data batch. The method further includes merging the first histogram of the first data batch to a merged histogram corresponding to the second data batch and processing a next data batch as a first data batch until the data set to be encoded is processed.
摘要翻译：一种用于产生用于使数据集编码的数据值的出现数据的方法，包括：确定第一数据批中的数据值的出现以及确定第一数据批中第一数量最频繁数据值的出现次数信息，发生次数识别最频繁的数据值及其发生次数的信息。该方法还包括在第一数据批中生成具有第二数量桶的至少第一直方图的剩余数据值，并且将第一数据批次的发生计数信息与第二数据批次的发生计数信息进行合并。该方法还包括将第一数据批次的第一直方图合并到与第二数据批次相对应的合并直方图，并将下一数据批处理作为第一数据批次，直到处理要编码的数据集。

36. 发明授权

US08180762B2 Database tuning methods 失效
标题翻译：数据库调优方法
公开(公告)号：US08180762B2
公开(公告)日：2012-05-15
申请号：US11467065
申请日：2006-08-24
申请人： Thorsten Steinbach , Michael Reichert , Holger Karn , Namik Hrle , Norbert Heck
发明人： Thorsten Steinbach , Michael Reichert , Holger Karn , Namik Hrle , Norbert Heck
IPC分类号： G06F7/00
CPC分类号： G06F17/30306
摘要： A method for tuning a database system is disclosed. A tuning strategy is received comprising a first procedure to determine a suggested tuning action, and a second procedure to measure performance of the database system. The suggested tuning action is determined and pre-action performance measured according to the respective procedures. Undo information that indicates how to undo the database system state change of the suggested tuning action is recorded in a database system state history. After executing the suggested tuning action, post-action database system performance is measured according to the second procedure. When the post-action performance is lower than the pre-action performance, the database system state change is undone using the undo information. Embodiments enabling to create new tuning strategies, downloading existing tuning strategies, sharing own tuning strategies and changing existing tuning strategies are disclosed as well.
摘要翻译：公开了一种用于调整数据库系统的方法。接收包括确定建议的调整动作的第一过程和测量数据库系统性能的第二过程的调整策略。确定建议的调整动作，并根据各自的步骤测量动作前的性能。撤消指示如何撤消数据库系统状态更改建议的调整操作的信息记录在数据库系统状态历史记录中。执行建议的调整动作后，根据第二个步骤测量动作后数据库系统性能。当操作后的性能低于动作前的性能时，数据库系统状态更改将使用撤消信息撤销。还公开了能够创建新的调谐策略，下载现有调谐策略，共享自己的调谐策略和改变现有调谐策略的实施例。

37. 发明授权

US08055646B2 Prevention of redundant indexes in a database management system 有权
标题翻译：预防数据库管理系统中的冗余索引
公开(公告)号：US08055646B2
公开(公告)日：2011-11-08
申请号：US12185847
申请日：2008-08-05
申请人： Oliver Augenstein , Namik Hrle , Thomas Ritter , Andreas Uhl
发明人： Oliver Augenstein , Namik Hrle , Thomas Ritter , Andreas Uhl
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30336
摘要： A method and system for preventing redundant indexes in a database management system (DBMS). A received create-index command specifies a new index to be created for retrieving data from a table created by the DBMS and a redundancy check to be performed for the new index in conjunction with an action parameter in the create-index command. If the action parameter includes a REPORT value, each redundant index is stored and/or displayed and the new index is created. If the action parameter includes a PREVENT value and an existing index is redundant in view of the new index and the new index is not redundant in view of the existing index, the existing index is deleted and the new index is created. If the action parameter includes a PREVENT value and the new index is redundant in view of an existing index, the new index is not created.
摘要翻译：一种用于防止数据库管理系统（DBMS）中的冗余索引的方法和系统。接收到的create-index命令指定要创建的新索引，用于从DBMS创建的表中检索数据，并结合create-index命令中的action参数为新索引执行冗余检查。如果操作参数包含REPORT值，则存储和/或显示每个冗余索引，并创建新的索引。如果action参数包含PREVENT值，并且现有索引在查看新索引的情况下是冗余的，并且鉴于现有索引，新索引不是冗余的，则现有索引将被删除，并创建新的索引。如果操作参数包含PREVENT值，并且新索引在现有索引的基础上是冗余的，则不会创建新的索引。

38. 发明授权

US07797347B2 Workload aware checking of database reorganization 失效
标题翻译：工作量感知检查数据库重组
公开(公告)号：US07797347B2
公开(公告)日：2010-09-14
申请号：US11944865
申请日：2007-11-26
申请人： Oliver Draese , Namik Hrle , Torsten Steinbach , Michael Jeffrey Winer
发明人： Oliver Draese , Namik Hrle , Torsten Steinbach , Michael Jeffrey Winer
IPC分类号： G06F17/30
CPC分类号： G06F17/30339 , G06F17/30312
摘要： The present solution addresses the need to carry out reorganization of a database storage. A statistics-based reorganization check procedure is performed on at least first database tables and indexes, resulting in a preliminary reorganization recommendation. Information on workload on tables and indexes of said database storage is received. Based on the information on workload and the preliminary reorganization recommendation, it is decided whether to carry out reorganization of the database storage in accordance with the preliminary reorganization recommendation.
摘要翻译：本解决方案解决了对数据库存储进行重组的需要。对至少第一个数据库表和索引执行基于统计的重组检查过程，从而进行初步重组建议。接收有关所述数据库存储的表和索引的工作负载的信息。根据工作量信息和初步重组建议，决定是否按照初步重组建议重组数据库。

39. 发明授权

US07698253B2 Method and system for reducing host variable impact on access path selection 有权
标题翻译：减少主机变量影响访问路径选择的方法和系统
公开(公告)号：US07698253B2
公开(公告)日：2010-04-13
申请号：US11777049
申请日：2007-07-12
申请人： Namik Hrle
发明人： Namik Hrle
IPC分类号： G06F17/30
CPC分类号： G06F17/30474 , G06F17/3041 , G06F17/30433 , G06F17/30463 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935
摘要： The present invention proposes enhancing the access path selection process by storing the relevant frequency distribution and the host variables values used for selecting the access path together with the corresponding access path executable. This way, the host variables impact to the access path can be inexpensively assessed and the re-optimization triggered only if necessary.
摘要翻译：本发明提出通过存储用于选择访问路径的相关频率分布和主机变量值以及相应的访问路径可执行来增强访问路径选择过程。这样，主机变量对访问路径的影响可以被低成本地评估，并且仅在必要时触发重新优化。

40. 发明授权

US08954407B2 System and method for partially deferred index maintenance 有权
标题翻译：部分延期索引维护的系统和方法
公开(公告)号：US08954407B2
公开(公告)日：2015-02-10
申请号：US13085281
申请日：2011-04-12
申请人： Namik Hrle , Johannes Schuetzner , Knut Stolze
发明人： Namik Hrle , Johannes Schuetzner , Knut Stolze
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30327
摘要： Methods and Apparatus, including computer program products, for maintaining indexes in a database management system. The database management system includes a table having table entries and an index data structure having index data structure entries, the index data structure relating to the table. The index data structure is updated synchronously with an insertion of table entries. The index data structure is maintained unchanged when the table entries are deleted. It is verified by an index-scan on the index data structure that a valid criterion is fulfilled for index data structure entries, and those index data structure entries that pass the valid criterion from the index-scan are returned.
摘要翻译：方法和设备，包括计算机程序产品，用于维护数据库管理系统中的索引。数据库管理系统包括具有表条目的表和具有索引数据结构条目的索引数据结构，与该表相关的索引数据结构。索引数据结构与表条目的插入同步更新。当表项删除时，索引数据结构保持不变。通过对索引数据结构的索引扫描验证索引数据结构条目满足有效标准，并返回从索引扫描传递有效标准的索引数据结构条目。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式