公开(公告)号：US10452629B2

公开(公告)日：2019-10-22

申请号：US13082174

申请日：2011-04-07

申请人： Namik Hrle ,  Johannes Schuetzner ,  James Z. Teng

发明人： Namik Hrle ,  Johannes Schuetzner ,  James Z. Teng

IPC分类号： G06F16/22

摘要： Methods and apparatus, including computer program products, for maintaining a set of indexes in a database management system (DBMS) having at least one table. A current, stale or deferred status is defined for at least a part of the indexes, resulting in at least a part of a set of current, stale, or deferred indexes in the DBMS. Current indexes are maintained by refreshing a current index synchronously with a table change relating to the current index. Stale indexes are maintained by refreshing a stale index continuously and asynchronously to table modifications of tables relating to the stale index based on log information relating to the modifications. Deferred indexes are maintained by building a deferred index in response to a query to a table relating to the deferred index, thereby bringing the deferred index in accordance with the current query time status to the table relating to the deferred index.

公开(公告)号：US06775676B1

公开(公告)日：2004-08-10

申请号：US09659252

申请日：2000-09-11

申请人： Guenter Briam ,  Namik Hrle ,  James Z. Teng

发明人： Guenter Briam ,  Namik Hrle ,  James Z. Teng

IPC分类号： G06F1730

CPC分类号： G06F17/30595 ,  Y10S707/99942 ,  Y10S707/99943

摘要： A defer dataset creation system creates database objects at a computer connected to a data storage device. Initially, a command to create a database object is received. A database object definition for that database object is recorded. When the database object is accessed, a dataset for the database object is created from its database object definition.

摘要翻译： 延迟数据集创建系统在连接到数据存储设备的计算机上创建数据库对象。 最初，接收到创建数据库对象的命令。 记录该数据库对象的数据库对象定义。 访问数据库对象时，将从其数据库对象定义创建数据库对象的数据集。

公开(公告)号：US20120016881A1

公开(公告)日：2012-01-19

申请号：US13082174

申请日：2011-04-07

申请人： Namik Hrle ,  Johannes Schuetzner ,  James Z. Teng

发明人： Namik Hrle ,  Johannes Schuetzner ,  James Z. Teng

IPC分类号： G06F17/30

CPC分类号： G06F16/22

摘要： Methods and apparatus, including computer program products, for maintaining a set of indexes in a database management system (DBMS) having at least one table. A current, stale or deferred status is defined for at least a part of the indexes, resulting in at least a part of a set of current, stale, or deferred indexes in the DBMS. Current indexes are maintained by refreshing a current index synchronously with a table change relating to the current index. Stale indexes are maintained by refreshing a stale index continuously and asynchronously to table modifications of tables relating to the stale index based on log information relating to the modifications. Deferred indexes are maintained by building a deferred index in response to a query to a table relating to the deferred index, thereby bringing the deferred index in accordance with the current query time status to the table relating to the deferred index.

摘要翻译： 用于在具有至少一个表的数据库管理系统（DBMS）中维护一组索引的方法和装置，包括计算机程序产品。 为至少一部分索引定义当前，过期或延迟状态，导致DBMS中至少一部分当前，过时或延迟索引的一部分。 通过与当前索引相关的表更改同步刷新当前索引来维护当前索引。 通过基于与修改相关的日志信息，连续地和不同步地刷新与陈旧索引相关的表的表修改来维持陈旧索引来维持陈旧的索引。 通过建立延迟索引以响应于与延迟索引相关的表的查询来维护延迟索引，从而将根据当前查询时间状态的延迟索引带到与延迟索引相关的表。

公开(公告)号：US07107292B1

公开(公告)日：2006-09-12

申请号：US09687450

申请日：2000-10-13

申请人： Namik Hrle ,  James Z. Teng

发明人： Namik Hrle ,  James Z. Teng

IPC分类号： G06F17/30

CPC分类号： G06F11/1469 ,  G06F11/1471 ,  G06F2201/80 ,  Y10S707/99945 ,  Y10S707/99953

摘要： When recovering data in a database, initially, a database log, which records activities related to a database, is scanned. One or more individual objects that are to be recovered to a target time with reference to a backup time are identified.

摘要翻译： 在数据库中恢复数据时，最初扫描记录与数据库相关的活动的数据库日志。 识别要参考备份时间恢复到目标时间的一个或多个单独对象。

公开(公告)号：US20120221523A1

公开(公告)日：2012-08-30

申请号：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

摘要： According to an embodiment of the present invention, a method 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.

摘要翻译： 根据本发明的实施例，提供了一种用于重组数据库表的源索引树的方法，其导致数据库表的目标索引树。 备份过程按照索引键序列定义的逻辑顺序读取源索引树的源页面页面。 逻辑顺序可以不同于由各个存储位置的序列定义的源叶子页的物理顺序。 备份过程构建维护逻辑顺序的目标索引树的目标叶页面。 恢复过程基于构建的叶子页面中的索引关键字的分布来构建目标索引树的目标非叶子页面，并存储目标叶子和非叶子页面。

公开(公告)号：US20110208754A1

公开(公告)日：2011-08-25

申请号：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.

摘要翻译： 提供了一种用于处理表示具有子实体的数据实体的数据的计算机实现的方法。 该方法包括分析对数据实体的查询，用于导出关于一起经常查询的子实体的集合的信息，并且基于关于子实体的集合的信息频繁地将子实体分组到多个银行，每个银行具有最大宽度 一起查询，以减少要进行数据检索的银行平均数量。

公开(公告)号：US20100036864A1

公开(公告)日：2010-02-11

申请号：US12185847

申请日：2008-08-05

申请人： Oliver Augenstein ,  Namik Hrle ,  Thomas Ritter ,  Andreas Uhl

发明人： Oliver Augenstein ,  Namik Hrle ,  Thomas Ritter ,  Andreas Uhl

IPC分类号： 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值，并且新索引在现有索引的基础上是冗余的，则不会创建新的索引。

公开(公告)号：US20070136383A1

公开(公告)日：2007-06-14

申请号：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分类号： G06F17/30

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.

摘要翻译： 公开了一种用于调整数据库系统的方法。 接收包括确定建议的调整动作的第一过程和测量数据库系统性能的第二过程的调整策略。 确定建议的调整动作，并根据各自的步骤测量动作前的性能。 撤消指示如何撤消数据库系统状态更改建议的调整操作的信息记录在数据库系统状态历史记录中。 执行建议的调整动作后，根据第二个步骤测量动作后数据库系统性能。 当操作后的性能低于动作前的性能时，数据库系统状态更改将使用撤消信息撤销。 还公开了能够创建新的调谐策略，下载现有调谐策略，共享自己的调谐策略和改变现有调谐策略的实施例。

公开(公告)号：US20060230013A1

公开(公告)日：2006-10-12

申请号：US11303714

申请日：2005-12-16

申请人： Namik Hrle ,  James Teng

发明人： Namik Hrle ,  James Teng

IPC分类号： G06F17/30

CPC分类号： G06F17/30442 ,  G06F17/3048 ,  G06F17/30492

摘要： A system for retrieving stored data and/or index pages, receives a database request, generates an access plan for the database request for accessing data rows and/or index entries according to the statement, and generates a priming process by selecting a set of data and/or index pages. The set of data and/or index pages is a super-set or the exact set of the pages needed for accessing data rows and/or index entries according to the access plan. The present system retrieves the data and/or index pages of the set before executing the database request according to the access plan. The execution of the database request is performed by scanning the index and data pages preloaded into the cache. This reduces the number of necessary disk reads during execution.

摘要翻译： 一种用于检索存储的数据和/或索引页面的系统，接收数据库请求，根据该语句生成访问数据行和/或索引条目的数据库请求的访问计划，并通过选择一组数据来生成启动过程 和/或索引页。 一组数据和/或索引页是根据访问计划访问数据行和/或索引条目所需的超集或精确的页面集合。 根据访问计划，本系统在执行数据库请求之前检索该集合的数据和/或索引页。 通过扫描预先加载到缓存中的索引和数据页执行数据库请求。 这样可以减少执行期间所需的磁盘读取次数。

公开(公告)号：US07080074B2

公开(公告)日：2006-07-18

申请号：US10010371

申请日：2001-11-05

申请人： Namik Hrle ,  Andreas R. Maier ,  James Zu-Chia Teng ,  Julie A. Watts

发明人： Namik Hrle ,  Andreas R. Maier ,  James Zu-Chia Teng ,  Julie A. Watts

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  G06F17/30362 ,  Y10S707/99938

摘要： According to the method, apparatus, and computer readable medium of the present invention, a scan is performed by accessing all rows of a table in a relational database, evaluating each row to determine whether the row satifies a set of predicates of a database query, and returning the row if it satisfies the set of predicates. According to a preferred embodiment of the present invention, all rows are evaluated regardless of current locks. The scan is continued if the row does not satisfy the set of predicates regardless of the current lock on the row. The locking semantics according to the invention has the advantage that it completely removes the problem of lock contention on the rows that do not satisfy statement predicates.

摘要翻译： 根据本发明的方法，装置和计算机可读介质，通过访问关系数据库中的表的所有行来执行扫描，评估每行以确定该行是否满足数据库查询的一组谓词， 并返回该行，如果它满足一组谓词。 根据本发明的优选实施例，无论当前的锁如何，都对所有行进行评估。 如果该行不满足该组谓词，而不考虑行上的当前锁定，则继续进行扫描。 根据本发明的锁定语义的优点在于它完全消除了对不满足语句谓词的行的锁争用的问题。