公开(公告)号：US20050131853A1

公开(公告)日：2005-06-16

申请号：US10710868

申请日：2004-08-09

申请人： Srikanth Sampath ,  Fei Zhou ,  Girish Vaitheeswaran ,  Prasanta Ghosh

发明人： Srikanth Sampath ,  Fei Zhou ,  Girish Vaitheeswaran ,  Prasanta Ghosh

IPC分类号： G06F7/00

CPC分类号： G06F11/3442 ,  G06F11/1469 ,  G06F11/1471 ,  G06F11/2028 ,  G06F11/3485 ,  G06F2201/80 ,  G06F2201/87 ,  G06F2201/88 ,  G06F2201/885 ,  Y10S707/99953

摘要： A database system providing self-tuned parallel database recovery is described. In one embodiment, for example, in a database system, a method is described for performing recovery operations using an optimal number of recovery threads, the method comprises steps of: (a) spawning an initial recovery thread to perform recovery operations; (b) measuring I/O (input/output) performance with the initial recovery thread; (c) spawning a subsequent recovery thread to perform recovery operations; (d) measuring I/O performance with the subsequent recovery thread; and (e) as long as I/O performance does not degrade beyond a preselected percentage, repeating steps (c) and (d) for spawning a desired number of additional recovery threads. In another embodiment, the database system auto-tunes the cache during performance of database recovery operations to optimize the performance of recovery operations.

摘要翻译： 描述了提供自调谐并行数据库恢复的数据库系统。 在一个实施例中，例如，在数据库系统中，描述了使用最佳数量的恢复线程执行恢复操作的方法，所述方法包括以下步骤：（a）产生初始恢复线程以执行恢复操作; （b）用初始恢复线测量I / O（输入/输出）性能; （c）产生后续恢复线程执行恢复操作; （d）用随后的恢复线测量I / O性能; 和（e）只要I / O性能不会降低超过预选百​​分比，重复步骤（c）和（d）以产生所需数量的其他恢复线程。 在另一个实施例中，数据库系统在执行数据库恢复操作期间自动调整缓存以优化恢复操作的性能。

公开(公告)号：US07447710B2

公开(公告)日：2008-11-04

申请号：US10710868

申请日：2004-08-09

申请人： Srikanth Sampath ,  Fei Zhou ,  Girish Vaitheeswaran ,  Prasanta Ghosh

发明人： Srikanth Sampath ,  Fei Zhou ,  Girish Vaitheeswaran ,  Prasanta Ghosh

IPC分类号： G06F12/00 ,  G06F17/30

CPC分类号： G06F11/3442 ,  G06F11/1469 ,  G06F11/1471 ,  G06F11/2028 ,  G06F11/3485 ,  G06F2201/80 ,  G06F2201/87 ,  G06F2201/88 ,  G06F2201/885 ,  Y10S707/99953

摘要： A database system providing self-tuned parallel database recovery is described. In one embodiment, for example, in a database system, a method is described for performing recovery operations using an optimal number of recovery threads, the method comprises steps of: (a) spawning an initial recovery thread to perform recovery operations; (b) measuring I/O (input/output) performance with the initial recovery thread; (c) spawning a subsequent recovery thread to perform recovery operations; (d) measuring I/O performance with the subsequent recovery thread; and (e) as long as I/O performance does not degrade beyond a preselected percentage, repeating steps (c) and (d) for spawning a desired number of additional recovery threads. In another embodiment, the database system auto-tunes the cache during performance of database recovery operations to optimize the performance of recovery operations.

摘要翻译： 描述了提供自调谐并行数据库恢复的数据库系统。 在一个实施例中，例如，在数据库系统中，描述了使用最佳数量的恢复线程执行恢复操作的方法，所述方法包括以下步骤：（a）产生初始恢复线程以执行恢复操作; （b）用初始恢复线测量I / O（输入/输出）性能; （c）产生后续恢复线程执行恢复操作; （d）用随后的恢复线测量I / O性能; 和（e）只要I / O性能不降低超过预选百​​分比，重复步骤（c）和（d）以产生所需数量的其他恢复线程。 在另一个实施例中，数据库系统在执行数据库恢复操作期间自动调整缓存以优化恢复操作的性能。

公开(公告)号：US07421562B2

公开(公告)日：2008-09-02

申请号：US10710381

申请日：2004-07-06

申请人： Vadiraja Bhatt ,  Praveen Vegulla ,  Prasanta Ghosh ,  Girish Vaitheeswaran

发明人： Vadiraja Bhatt ,  Praveen Vegulla ,  Prasanta Ghosh ,  Girish Vaitheeswaran

IPC分类号： G06F9/28

CPC分类号： G06F12/0897 ,  G06F12/0866 ,  G06F12/12 ,  G06F2212/311 ,  G06F2212/465

摘要： A database system providing methodology for extended memory support is described. In one embodiment, for example, a method is described for extended memory support in a database system having a primary cache, the method comprises steps of: creating a secondary cache in memory available to the database system; mapping a virtual address range to at least a portion of the secondary cache; when the primary cache is full, replacing pages from the primary cache using the secondary cache; in response to a request for a particular page, searching for the particular page in the secondary cache if the particular page is not found in the primary cache; if the particular page is found in the secondary cache, determining a virtual address in the secondary cache where the particular page resides based on the mapping; and swapping the particular page found in the secondary cache with a page in the primary cache, so as to replace a page in the primary cache with the particular page from the secondary cache.

摘要翻译： 描述了提供扩展内存支持方法的数据库系统。 在一个实施例中，例如，描述了用于具有主缓存的数据库系统中的扩展存储器支持的方法，所述方法包括以下步骤：在可用于数据库系统的存储器中创建二级高速缓存; 将虚拟地址范围映射到所述辅助高速缓存的至少一部分; 当主缓存已满时，使用二级缓存从一级缓存替换页面; 响应于对特定页面的请求，如果在主高速缓存中没有找到特定页面，则搜索二级高速缓存中的特定页面; 如果在次级高速缓存中找到特定页面，则基于映射确定特定页面驻留的辅助高速缓存中的虚拟地址; 并且使用主缓存中的页面将辅助高速缓存中找到的特定页面进行交换，以便用来自二级高速缓存的特定页面替换主缓存中的页面。

公开(公告)号：US06721765B2

公开(公告)日：2004-04-13

申请号：US10190401

申请日：2002-07-02

申请人： Prasanta Ghosh ,  Vadiraja Bhatt ,  Girish Vaitheeswaran

发明人： Prasanta Ghosh ,  Vadiraja Bhatt ,  Girish Vaitheeswaran

IPC分类号： G06F1730

CPC分类号： G06F17/30368 ,  Y10S707/99943 ,  Y10S707/99953

摘要： A database system providing improved methods for asynchronous logging of transactions is described. Log records are created describing changes to a database made by a transaction. When a command committing changes to the database for the transaction is received, a logging request is placed in a queue. An asynchronous logging service removes requests from the queue and transfers log records from the transaction to a shared cache. The shared cache stores log records before they are written to the transaction log. The logging service writes log pages containing log records for the transaction from the cache to the transaction log. After all log pages in the cache for the transaction have been written to the transaction log, changes to the database made by the transaction can be committed to the database.

摘要翻译： 描述了提供用于异步记录事务的改进方法的数据库系统。 创建日志记录，描述事务所做的数据库更改。 当接收到提交对事务数据库的更改的命令时，记录请求将被放置在队列中。 异步日志服务从队列中删除请求，并将日志记录从事务传输到共享缓存。 共享缓存将日志记录存储在事务日志中之前。 日志记录服务将包含事务的日志记录的日志页从缓存写入事务日志。 在事务的缓存中的所有日志页面都已写入事务日志之后，事务所做的数据库的更改可以提交到数据库。

公开(公告)号：US06687702B2

公开(公告)日：2004-02-03

申请号：US09965231

申请日：2001-09-25

申请人： Girish Vaitheeswaran ,  Prasanta Ghosh ,  Taghi Fatemi

发明人： Girish Vaitheeswaran ,  Prasanta Ghosh ,  Taghi Fatemi

IPC分类号： G06F1730

CPC分类号： G06F9/544 ,  Y10S707/99945

摘要： A multi-tier database system is modified such that a middle-tier application server (EJB server) and a database server run on the same host computer and communicate via shared-memory interprocess communication. The system includes a database (e.g., JDBC) driver thread that attaches to the database server, specifically by attaching to the database server's shared memory segment. Operation of the JDBC driver is modified to provide direct access between the middle tier (i.e., EJB server) and the database server, when the two are operating on the same host computer.

摘要翻译： 修改多层数据库系统，使得中间层应用服务器（EJB服务器）和数据库服务器在同一主机上运行并通过共享内存进程间通信进行通信。 系统包括附加到数据库服务器的数据库（例如，JDBC）驱动程序线程，具体地通过附加到数据库服务器的共享存储器段。 修改JDBC驱动程序的操作，以便当两者在同一主机上运行时，提供中间层（即EJB服务器）与数据库服务器之间的直接访问。

公开(公告)号：US20050193160A1

公开(公告)日：2005-09-01

申请号：US10710381

申请日：2004-07-06

申请人： Vadiraja Bhatt ,  Praveen Vegulla ,  Prasanta Ghosh ,  Girish Vaitheeswaran

发明人： Vadiraja Bhatt ,  Praveen Vegulla ,  Prasanta Ghosh ,  Girish Vaitheeswaran

IPC分类号： G06F12/08 ,  G06F12/12 ,  G11C5/00

CPC分类号： G06F12/0897 ,  G06F12/0866 ,  G06F12/12 ,  G06F2212/311 ,  G06F2212/465

摘要： A database system providing methodology for extended memory support is described. In one embodiment, for example, a method is described for extended memory support in a database system having a primary cache, the method comprises steps of: creating a secondary cache in memory available to the database system; mapping a virtual address range to at least a portion of the secondary cache; when the primary cache is full, replacing pages from the primary cache using the secondary cache; in response to a request for a particular page, searching for the particular page in the secondary cache if the particular page is not found in the primary cache; if the particular page is found in the secondary cache, determining a virtual address in the secondary cache where the particular page resides based on the mapping; and swapping the particular page found in the secondary cache with a page in the primary cache, so as to replace a page in the primary cache with the particular page from the secondary cache.

摘要翻译： 描述了提供扩展内存支持方法的数据库系统。 在一个实施例中，例如，描述了用于具有主缓存的数据库系统中的扩展存储器支持的方法，所述方法包括以下步骤：在可用于数据库系统的存储器中创建二级高速缓存; 将虚拟地址范围映射到所述辅助高速缓存的至少一部分; 当主缓存已满时，使用二级缓存从一级缓存替换页面; 响应于对特定页面的请求，如果在主高速缓存中没有找到特定页面，则搜索二级高速缓存中的特定页面; 如果在次级高速缓存中找到特定页面，则基于映射确定特定页面驻留的辅助高速缓存中的虚拟地址; 并且使用主缓存中的页面将辅助高速缓存中找到的特定页面进行交换，以便用来自二级高速缓存的特定页面替换主缓存中的页面。