-
1.发明授权公开(公告)号：US07124139B2
公开(公告)日：2006-10-17
申请号：US10649665
申请日：2003-08-28
CPC分类号： G06F11/0775 , G06F3/0617 , G06F3/0635 , G06F3/067 , G06F11/0709 , G06F11/0727 , G06F11/0748 , G06F11/2294 , H04L67/1097 , Y10S707/99942 , Y10S707/99943
摘要： A computer system identifies jobs affected by a fault which occurs in any device or mechanism in a storage system to control the execution of such jobs. The computer system includes a DBMS server device, a virtualization switch device, and storage device. Each of these devices holds part of data mapping information on a data mapping path from a particular DB table accessed by a job, through a logical volume for storing the table, to physical disk units for distributively storing data on the volume. The management server device acquires the part of data mapping information from each device, and integrates the data mapping information on a job-by-job basis. When any device or mechanism fails on the data mapping path, the management server device identifies jobs affected by the fault with reference to the data mapping information. The management server device also controls the execution of these jobs.
-
2.发明申请公开(公告)号：US20060036899A1
公开(公告)日：2006-02-16
申请号：US11247160
申请日：2005-10-12
IPC分类号： G06F11/00
CPC分类号： G06F11/0775 , G06F3/0617 , G06F3/0635 , G06F3/067 , G06F11/0709 , G06F11/0727 , G06F11/0748 , G06F11/2294 , H04L67/1097 , Y10S707/99942 , Y10S707/99943
摘要： A computer system identifies jobs affected by a fault which occurs in any device or mechanism in a storage system to control the execution of such jobs. The computer system includes a DBMS server device, a virtualization switch device, and storage device. Each of these devices holds part of data mapping information on a data mapping path from a particular DB table accessed by a job, through a logical volume for storing the table, to physical disk units for distributively storing data on the volume. The management server device acquires the part of data mapping information from each device, and integrates the data mapping information on a job-by-job basis. When any device or mechanism fails on the data mapping path, the management server device identifies jobs affected by the fault with reference to the data mapping information. The management server device also controls the execution of these jobs.
-
3.发明申请公开(公告)号：US20060031270A1
公开(公告)日：2006-02-09
申请号：US11247210
申请日：2005-10-12
IPC分类号： G06F17/30
CPC分类号： G06F11/0775 , G06F3/0617 , G06F3/0635 , G06F3/067 , G06F11/0709 , G06F11/0727 , G06F11/0748 , G06F11/2294 , H04L67/1097 , Y10S707/99942 , Y10S707/99943
摘要： A computer system identifies jobs affected by a fault which occurs in any device or mechanism in a storage system to control the execution of such jobs. The computer system includes a DBMS server device, a virtualization switch device, and storage device. Each of these devices holds part of data mapping information on a data mapping path from a particular DB table accessed by a job, through a logical volume for storing the table, to physical disk units for distributively storing data on the volume. The management server device acquires the part of data mapping information from each device, and integrates the data mapping information on a job-by-job basis. When any device or mechanism fails on the data mapping path, the management server device identifies jobs affected by the fault with reference to the data mapping information. The management server device also controls the execution of these jobs.
-
4.发明授权公开(公告)号：US07552138B2
公开(公告)日：2009-06-23
申请号：US11247210
申请日：2005-10-12
IPC分类号： G06F17/00
CPC分类号： G06F11/0775 , G06F3/0617 , G06F3/0635 , G06F3/067 , G06F11/0709 , G06F11/0727 , G06F11/0748 , G06F11/2294 , H04L67/1097 , Y10S707/99942 , Y10S707/99943
摘要： A computer system identifies jobs affected by a fault which occurs in any device or mechanism in a storage system to control the execution of such jobs. The computer system includes a DBMS server device, a virtualization switch device, and storage device. Each of these devices holds part of data mapping information on a data mapping path from a particular DB table accessed by a job, through a logical volume for storing the table, to physical disk units for distributively storing data on the volume. The management server device acquires the part of data mapping information from each device, and integrates the data mapping information on a job-by-job basis. When any device or mechanism fails on the data mapping path, the management server device identifies jobs affected by the fault with reference to the data mapping information. The management server device also controls the execution of these jobs.
-
5.发明授权Method and apparatus for managing faults in storage system having job management function 失效用于管理具有作业管理功能的存储系统中的故障的方法和装置公开(公告)号：US07509331B2
公开(公告)日：2009-03-24
申请号：US11247160
申请日：2005-10-12
IPC分类号： G06F17/00
CPC分类号： G06F11/0775 , G06F3/0617 , G06F3/0635 , G06F3/067 , G06F11/0709 , G06F11/0727 , G06F11/0748 , G06F11/2294 , H04L67/1097 , Y10S707/99942 , Y10S707/99943
摘要： A computer system identifies jobs affected by a fault which occurs in any device or mechanism in a storage system to control the execution of such jobs. The computer system includes a DBMS server device, a virtualization switch device, and storage device. Each of these devices holds part of data mapping information on a data mapping path from a particular DB table accessed by a job, through a logical volume for storing the table, to physical disk units for distributively storing data on the volume. The management server device acquires the part of data mapping information from each device, and integrates the data mapping information on a job-by-job basis. When any device or mechanism fails on the data mapping path, the management server device identifies jobs affected by the fault with reference to the data mapping information. The management server device also controls the execution of these jobs.
摘要翻译： 计算机系统识别受存储系统中的任何设备或机制中发生的故障影响的作业，以控制这些作业的执行。 计算机系统包括DBMS服务器设备，虚拟交换设备和存储设备。 这些设备中的每一个将数据映射路径上的数据映射信息的一部分保存在通过用于存储表的逻辑卷的作业所访问的特定DB表的数据映射路径到用于在卷上分布式地存储数据的物理磁盘单元。 管理服务器设备从每个设备获取部分数据映射信息，并且逐个工作地整合数据映射信息。 当任何设备或机制在数据映射路径上发生故障时，管理服务器设备将参考数据映射信息来识别受故障影响的作业。 管理服务器设备还控制这些作业的执行。
-
6.发明申请Method of controlling a database management system by changing allocation of cache memory 有权通过改变高速缓冲存储器的分配来控制数据库管理系统的方法公开(公告)号：US20070016716A1
公开(公告)日：2007-01-18
申请号：US11259894
申请日：2005-10-26
IPC分类号： G06F12/06
CPC分类号： G06F12/0871 , G06F17/30289 , G06F17/30557 , G06F2212/465 , G06F2212/601 , Y10S707/99932 , Y10S707/99943
摘要： Provided is a computer system, including: at least one of database computers, in which a database management system operates; a storage system for storing a database operated by the database management system; and a management computer for managing the database computer and the storage system, the storage system having a cache memory for storing data temporarily and a physical disk drive for storing the database, in which the management computer changes capacity of the cache memory which is allocated to the database computer where the database management system operates, and instructs the database management system to change an access plan according to the change in capacity of the cache memory allocated to the database computer.
摘要翻译： 提供一种计算机系统，包括：数据库计算机中的至少一个，其中数据库管理系统操作; 用于存储由数据库管理系统操作的数据库的存储系统; 以及用于管理数据库计算机和存储系统的管理计算机，所述存储系统具有临时存储数据的高速缓存存储器和用于存储数据库的物理磁盘驱动器，其中管理计算机改变被分配给 数据库管理系统操作的数据库计算机，并且指示数据库管理系统根据分配给数据库计算机的高速缓冲存储器容量的变化来改变访问计划。
-
公开(公告)号：US07441082B2
公开(公告)日：2008-10-21
申请号：US11028218
申请日：2005-01-04
CPC分类号： H04L67/1097
摘要： Data writing into a storage device. Data is written into a cache memory in order to implement speeding-up, and also the data is written into a physical disc asynchronously therewith. Since allocation of the cache memory is performed on each writing-request basis, a cut-out processing is required which is executed when none of available areas exists. This results in a problem of necessitating a writing processing time. A DBMS server in advance notifies the storage device that a writing will take place. A manager included in the storage device performs acquisition of the cache memory prior to the writing processing. This allows the data to be stored into the acquired cache memory at the time of the writing processing.
摘要翻译： 数据写入存储设备。 将数据写入高速缓冲存储器以实现加速，并且将数据与其异步地写入物理盘。 由于在每个写入请求的基础上执行高速缓冲存储器的分配，所以当没有可用区域存在时，需要执行切出处理。 这导致需要写入处理时间的问题。 DBMS服务器预先通知存储设备将进行写入。 包含在存储装置中的管理器在写入处理之前执行高速缓冲存储器的采集。 这允许在写入处理时将数据存储到获取的高速缓冲存储器中。
-
8.发明授权Method of controlling a database management system by changing allocation of cache memory 有权通过改变高速缓冲存储器的分配来控制数据库管理系统的方法公开(公告)号：US07395371B2
公开(公告)日：2008-07-01
申请号：US11259894
申请日：2005-10-26
IPC分类号： G06F12/00
CPC分类号： G06F12/0871 , G06F17/30289 , G06F17/30557 , G06F2212/465 , G06F2212/601 , Y10S707/99932 , Y10S707/99943
摘要： Provided is a computer system, including: at least one of database computers, in which a database management system operates; a storage system for storing a database operated by the database management system; and a management computer for managing the database computer and the storage system, the storage system having a cache memory for storing data temporarily and a physical disk drive for storing the database, in which the management computer changes capacity of the cache memory which is allocated to the database computer where the database management system operates, and instructs the database management system to change an access plan according to the change in capacity of the cache memory allocated to the database computer.
摘要翻译： 提供一种计算机系统，包括：数据库计算机中的至少一个，其中数据库管理系统操作; 用于存储由数据库管理系统操作的数据库的存储系统; 以及用于管理数据库计算机和存储系统的管理计算机，所述存储系统具有临时存储数据的高速缓存存储器和用于存储数据库的物理磁盘驱动器，其中管理计算机改变被分配给 数据库管理系统操作的数据库计算机，并且指示数据库管理系统根据分配给数据库计算机的高速缓冲存储器容量的变化来改变访问计划。
-
公开(公告)号：US20060106759A1
公开(公告)日：2006-05-18
申请号：US11048290
申请日：2005-01-31
CPC分类号： G06F17/30595 , G06F17/30457 , G06F17/3048
摘要： There is a program for transmitting a prefetch command to a database management system (DBMS) so that access data of the DBMS can be prefetched to a storage. The DBMS is able to generate an access plan conscious of prefetch and to access database (DB). The DBMS is, however, unable to recognize that a prefetch command program is halted and it cannot generate an access plan at a proper I/O cost. Database management system servers 1, 2, . . . monitor a prefetch program of a management server 5, understands that the prefetch program is halted and it can optimize an execution plan to access storage apparatus 3, 4, . . . by using an I/O cost changed when the prefetch program is halted.
摘要翻译： 存在用于将预取命令发送到数据库管理系统（DBMS）的程序，使得DBMS的访问数据可以被预取到存储器。 DBMS能够生成访问计划，意识到预取和访问数据库（DB）。 然而，DBMS无法识别预取命令程序被停止，并且无法以正确的I / O代价生成访问计划。 数据库管理系统服务器1，2，。 。 。 监视管理服务器5的预取程序，理解预取程序被停止，并且可以优化执行计划以访问存储设备3,4。 。 。 通过使用在预取程序停止时改变的I / O成本。
-
公开(公告)号：US20060085598A1
公开(公告)日：2006-04-20
申请号：US11028218
申请日：2005-01-04
IPC分类号： G06F12/00
CPC分类号： H04L67/1097
摘要： Data writing into a storage device. Data is written into a cache memory in order to implement speeding-up, and also the data is written into a physical disc asynchronously therewith. Since allocation of the cache memory is performed on each writing-request basis, a cut-out processing is required which is executed when none of available areas exists. This results in a problem of necessitating a writing processing time. A DBMS server in advance notifies the storage device that a writing will take place. A manager included in the storage device performs acquisition of the cache memory prior to the writing processing. This allows the data to be stored into the acquired cache memory at the time of the writing processing.
摘要翻译： 数据写入存储设备。 将数据写入高速缓冲存储器以实现加速，并且将数据与其异步地写入物理盘。 由于在每个写入请求的基础上执行高速缓冲存储器的分配，所以当没有可用区域存在时，需要执行切出处理。 这导致需要写入处理时间的问题。 DBMS服务器预先通知存储设备将进行写入。 包含在存储装置中的管理器在写入处理之前执行高速缓冲存储器的采集。 这允许在写入处理时将数据存储到获取的高速缓冲存储器中。
-
-
-
-
-
-
-
-
-
搜索结果
86 条记录 (耗时 0.027 秒)
