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

1. 发明授权

US08972346B2 Method and system for minimizing synchronization efforts of parallel database systems 有权
标题翻译：用于最小化并行数据库系统同步工作的方法和系统
公开(公告)号：US08972346B2
公开(公告)日：2015-03-03
申请号：US12957530
申请日：2010-12-01
申请人： James W Pickel , Wolfgang Reichert , Johannes Schuetzner
发明人： James W Pickel , Wolfgang Reichert , Johannes Schuetzner
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30575
摘要： Operating a parallel database server system, where the database server system comprises at least two database servers and one data source. A client identifier is received from a client requesting services from one of said database servers. Information associated with said client is retrieved. The client is allocated to one of said database servers based on the retrieved information.
摘要翻译：操作并行数据库服务器系统，其中数据库服务器系统包括至少两个数据库服务器和一个数据源。从客户端接收请求来自所述数据库服务器之一的服务的客户端标识符。检索与所述客户端相关联的信息。基于检索到的信息，将客户端分配给所述数据库服务器之一。

2. 发明授权

US10452629B2 Automatic maintenance of a set of indexes with different currency characteristics in a database management system 有权
公开(公告)号：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.

3. 发明授权

US08161017B2 Enhanced identification of relevant database indices 有权
标题翻译：加强相关数据库指标的识别
公开(公告)号：US08161017B2
公开(公告)日：2012-04-17
申请号：US12418146
申请日：2009-04-03
申请人： Namik Hrle , Johannes Schuetzner , James Teng
发明人： Namik Hrle , Johannes Schuetzner , James Teng
IPC分类号： G06F7/00
CPC分类号： G06F17/30442 , G06F17/30336
摘要： According to one embodiment of the present invention, a method for identifying relevant database indexes is provided. According to one embodiment of the present invention, a method includes determining the importance of a particular database transaction and storing an index name related to the transaction along with an indicator of the importance. A database transaction is initiated and the importance indicator is received in an index advisor. The index advisor then makes an index recommendation based on the index importance.
摘要翻译：根据本发明的一个实施例，提供了一种用于识别相关数据库索引的方法。根据本发明的一个实施例，一种方法包括确定特定数据库事务的重要性并存储与事务相关的索引名称以及重要性的指示符。启动数据库事务，并在索引顾问中接收重要性指标。然后，指数顾问根据指标的重要性提出指数推荐。

4. 发明申请

US20110295800A1 Method and System for Minimizing Synchronization Efforts of Parallel Database Systems 有权
标题翻译：并行数据库系统同步化方法和系统的最小化
公开(公告)号：US20110295800A1
公开(公告)日：2011-12-01
申请号：US12957530
申请日：2010-12-01
申请人： James W. Pickel , Wolfgang Reichert , Johannes Schuetzner
发明人： James W. Pickel , Wolfgang Reichert , Johannes Schuetzner
IPC分类号： G06F17/30
CPC分类号： G06F17/30575
摘要： Operating a parallel database server system, where the database server system comprises at least two database servers and one data source. A client identifier is received from a client requesting services from one of said database servers. Information associated with said client is retrieved. The client is allocated to one of said database servers based on the retrieved information.
摘要翻译：操作并行数据库服务器系统，其中数据库服务器系统包括至少两个数据库服务器和一个数据源。从客户端接收请求来自所述数据库服务器之一的服务的客户端标识符。检索与所述客户端相关联的信息。基于检索到的信息，将客户端分配给所述数据库服务器之一。

5. 发明授权

US07552110B2 Method for performing a query in a computer system to retrieve data from a database 失效
标题翻译：在计算机系统中执行查询以从数据库检索数据的方法
公开(公告)号：US07552110B2
公开(公告)日：2009-06-23
申请号：US10947611
申请日：2004-09-22
申请人： Namik Hrle , Johannes Schuetzner
发明人： Namik Hrle , Johannes Schuetzner
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30693 , G06F17/30687 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： Presented is a method to perform a query to retrieve data from a database that is part of a computer system comprising a Data-Base Management System (DBMS) with an optimizer. A Query Execution Plan (QEP) is generated for the query. The QEP is assessed by considering statistical values about previous executions of the query according to the QEP to decide whether to choose the QEP or to generate a new QEP. Furthermore, the statistical values on previous executions of the query are exploited during query optimization. The query is executed according to the chosen QEP. For optimizing the execution of future queries, statistical values about the execution of the query are collected during execution.
摘要翻译：呈现的是执行查询以从作为包括具有优化器的数据库管理系统（DBMS）的计算机系统的一部分的数据库检索数据的方法。为查询生成查询执行计划（QEP）。通过根据QEP考虑关于先前执行查询的统计值来评估QEP，以决定是选择QEP还是生成新的QEP。此外，在查询优化期间利用查询的先前执行的统计值。该查询根据选定的QEP执行。为了优化未来查询的执行，在执行期间收集关于查询执行的统计值。

6. 发明申请

US20070168640A1 METHOD FOR SEARCHING A DATA PAGE FOR INSERTING A DATA RECORD 失效
标题翻译：搜索用于插入数据记录的数据页的方法
公开(公告)号：US20070168640A1
公开(公告)日：2007-07-19
申请号：US11620187
申请日：2007-01-05
申请人： Namik Hrle , Johannes Schuetzner , James Teng
发明人： Namik Hrle , Johannes Schuetzner , James Teng
IPC分类号： G06F12/00
CPC分类号： G06F17/30598 , G06F17/30492
摘要： A method of searching a data page in a table space of a database for inserting a data record to a first table, wherein the table space comprises space map pages and sets of data pages, wherein each space map page comprises information about the available storage space of one set of data pages, wherein each space map page and the corresponding set of data pages is further assigned to a table range for each table to which at least one data page in the set of data pages belongs to, wherein the database further comprises a clustering index for the first table in the database management system, wherein the database management system comprises a space usage information database, and wherein the space usage information database holds space usage information for each table range.
摘要翻译：一种在数据库的表空间中搜索用于将数据记录插入到第一表的数据页的方法，其中所述表空间包括空间图页和数据页组，其中每个空间图页包括关于可用存储空间的信息一组数据页面，其中每个空间地图页面和对应的数据页面集合进一步分配给数据页组中的至少一个数据页面所属的每个表的表范围，其中数据库还包括数据库管理系统中的第一表的聚类索引，其中所述数据库管理系统包括空间使用信息数据库，并且其中所述空间使用信息数据库保存每个表范围的空间使用信息。

7. 发明授权

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.
摘要翻译：方法和设备，包括计算机程序产品，用于维护数据库管理系统中的索引。数据库管理系统包括具有表条目的表和具有索引数据结构条目的索引数据结构，与该表相关的索引数据结构。索引数据结构与表条目的插入同步更新。当表项删除时，索引数据结构保持不变。通过对索引数据结构的索引扫描验证索引数据结构条目满足有效标准，并返回从索引扫描传递有效标准的索引数据结构条目。

8. 发明申请

US20120016881A1 Automatic Maintenance of a Set of Indexes with Different Currency Characteristics in a Database Management System 审中-公开
标题翻译：在数据库管理系统中自动维护一组具有不同货币特征的索引
公开(公告)号：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中至少一部分当前，过时或延迟索引的一部分。通过与当前索引相关的表更改同步刷新当前索引来维护当前索引。通过基于与修改相关的日志信息，连续地和不同步地刷新与陈旧索引相关的表的表修改来维持陈旧索引来维持陈旧的索引。通过建立延迟索引以响应于与延迟索引相关的表的查询来维护延迟索引，从而将根据当前查询时间状态的延迟索引带到与延迟索引相关的表。

9. 发明申请

US20120016851A1 System and Method for Partially Deferred Index Maintenance 有权
标题翻译：部分延期索引维护的系统和方法
公开(公告)号：US20120016851A1
公开(公告)日：2012-01-19
申请号：US13085281
申请日：2011-04-12
申请人： Namik Hrle , Johannes Schuetzner , Knut Stolze
发明人： Namik Hrle , Johannes Schuetzner , Knut Stolze
IPC分类号： G06F7/00
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.
摘要翻译：方法和设备，包括计算机程序产品，用于维护数据库管理系统中的索引。数据库管理系统包括具有表条目的表和具有索引数据结构条目的索引数据结构，与该表相关的索引数据结构。索引数据结构与表条目的插入同步更新。当表项删除时，索引数据结构保持不变。通过对索引数据结构的索引扫描验证索引数据结构条目满足有效标准，并且返回从索引扫描传递有效标准的索引数据结构条目。

10. 发明申请

US20100257152A1 ENHANCED IDENTIFICATION OF RELEVANT DATABASE INDICES 有权
标题翻译：增强相关数据库指标的识别
公开(公告)号：US20100257152A1
公开(公告)日：2010-10-07
申请号：US12418146
申请日：2009-04-03
申请人： Namik Hrle , Johannes Schuetzner , James Teng
发明人： Namik Hrle , Johannes Schuetzner , James Teng
IPC分类号： G06F7/00
CPC分类号： G06F17/30442 , G06F17/30336
摘要： According to one embodiment of the present invention, a method for identifying relevant database indexes is provided. According to one embodiment of the present invention, a method includes determining the importance of a particular database transaction and storing an index name related to the transaction along with an indicator of the importance. A database transaction is initiated and the importance indicator is received in an index advisor. The index advisor then makes an index recommendation based on the index importance.
摘要翻译：根据本发明的一个实施例，提供了一种用于识别相关数据库索引的方法。根据本发明的一个实施例，一种方法包括确定特定数据库事务的重要性并存储与事务相关的索引名称以及重要性的指标。启动数据库事务，并在索引顾问中接收重要性指标。然后，指数顾问根据指标的重要性提出指数推荐。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式