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

1. 发明授权

US5586315A Computer program product for off-loading host-based DBMS predicate evaluation to a disk controller 失效
标题翻译：用于将基于主机的DBMS谓词评估卸载到磁盘控制器的计算机程序产品
公开(公告)号：US5586315A
公开(公告)日：1996-12-17
申请号：US513696
申请日：1995-08-11
申请人： Inderpal S. Narang , Balakrishna R. Iyer , Chandrasekaran Mohan
发明人： Inderpal S. Narang , Balakrishna R. Iyer , Chandrasekaran Mohan
IPC分类号： G06F12/00 , G06F11/14 , G06F17/30
CPC分类号： G06F17/30377 , Y10S707/99938 , Y10S707/99954
摘要： A computer program product, such as a pre-recorded software program on a floppy disk, is disclosed, for use with a processing and database system for off-loading, to disk controller, the extraction of committed data. Responsive to the pre-recorded program instructions, the system first picks a Commit.sub.-- LSN value and insures all the data modified prior to the Commit.sub.-- LSN value is processed following the DBMS policy of reducing some disk I/Os or not for the modified pages cached in the system. If the policy is not to do disk I/Os for such pages, then the system places the identifiers of those pages in an ignore list. Otherwise, the system writes those pages to disk and empties the ignore list. Afterwards, the system forwards the ignore list and the Commit.sub.-- LSN along with information regarding the data to be processed to the controller. The controller performs the off-load function by reading from disk every page identified by the system except those in the ignore list, and determining, for each page, if the page's Page.sub.-- LSN value is less than the Commit.sub.-- LSN. If it is, then the controller processes the page and adds any qualifying data from that page to a defined answer set. Otherwise, the controller adds the Page.sub.-- ID for that page to a defined exception list. The controller than passes the answer set and the exception list to the system. The system processes the pages identified in the exception list and those in the ignore list. The system consolidates these answers with the answer set returned by the controller for presentation to the user.
摘要翻译：公开了一种计算机程序产品，例如软盘上的预先记录的软件程序，用于与用于卸载的处理和数据库系统一起用于磁盘控制器提取已提交的数据。响应于预先记录的程序指令，系统首先选择一个Commit-LSN值，并确保在Commit-LSN值之前修改的所有数据在遵循减少某些磁盘I / O的DBMS策略之后被处理缓存在系统中。如果策略不为这些页面执行磁盘I / O，则系统将这些页面的标识符放置在忽略列表中。否则，系统将这些页面写入磁盘并清空忽略列表。然后，系统将忽略列表和Commit-LSN以及有关要处理的数据的信息转发给控制器。控制器通过从除了忽略列表中的系统之外的系统识别的每个页面读取磁盘来执行卸载功能，并且为每个页面确定页面的页面-LSN值是否小于Commit-LSN。如果是，则控制器处理该页面并将该页面中的任何限定数据添加到定义的答案集。否则，控制器将该页面的Page-ID添加到定义的异常列表中。控制器将答案集和异常列表传递给系统。系统处理异常列表中标识的页面和忽略列表中的页面。系统将这些答案与控制器返回的回答集合合并，以呈现给用户。

2. 发明授权

US5495601A Method to off-load host-based DBMS predicate evaluation to a disk controller 失效
标题翻译：用于将基于主机的DBMS谓词评估卸载到磁盘控制器的计算机程序产品
公开(公告)号：US5495601A
公开(公告)日：1996-02-27
申请号：US989447
申请日：1992-12-11
申请人： Inderpal S. Narang , Balakrishna R. Iyer , Chandrasekaran Mohan
发明人： Inderpal S. Narang , Balakrishna R. Iyer , Chandrasekaran Mohan
IPC分类号： G06F12/00 , G06F11/14 , G06F17/30
CPC分类号： G06F17/30377 , Y10S707/99938 , Y10S707/99954
摘要： A method is disclosed for a database system for [off-loading] off-loading, to disk [controller] controller, the extraction of committed [data involving the] data. The system first [picking] picks a Commit.sub.-- LSN value and [insuring] insures all the data modified prior to the Commit.sub.-- LSN value is processed following the DBMS policy of reducing some disk I/Os or not for the modified pages cached in the system. If the policy is not to do disk I/Os for such [pages] pages, then the system places the identifiers of those pages in an ignore list. Otherwise, the system writes those pages to disk and empties the ignore list. [After which] Afterwards, the system forwards the ignore list and the Commit.sub.--LSN along with information regarding the data to be processed to the controller. The controller performs the off-load function by reading from disk every page identified by the system except those in the ignore [list] list, and [determining] determining, for each [page] page, if the page's Page.sub.-- LSN value is less than the Commit.sub.-- LSN. If it [is] is, then the controller processes the page and adds any qualifying data from that page to a defined answer set. Otherwise, the controller adds the Page.sub.-- ID for that page to a defined exception list. The controller than passes the answer set and the exception list to the system. The system processes the pages identified in the exception list and those in the ignore list. The system consolidates these answers with the answer set returned by the controller for presentation to the user.
摘要翻译：公开了一种用于[卸载]卸载的数据库系统的方法，到磁盘[控制器]控制器，提取已提交的涉及数据的数据。系统首先[pick]选择一个Commit-LSN值，并且[确保]确保在Commit-LSN值之前修改的所有数据被处理，遵循减少某些磁盘I / O的DBMS策略，而不是缓存在系统。如果策略不为这些[页]页面执行磁盘I / O，则系统将这些页面的标识符放置在忽略列表中。否则，系统将这些页面写入磁盘并清空忽略列表。 [之后]之后，系统将忽略列表和Commit-LSN以及要处理的数据的信息与控制器进行转发。控制器通过从除了[list]列表中的系统之外的系统识别的每个页面读取磁盘来执行卸载功能，以及[确定]对于每个[page]页面，如果页面的Page-LSN值较小比Commit-LSN。如果是，则控制器处理页面，并将该页面中的任何限定数据添加到定义的答案集。否则，控制器将该页面的Page-ID添加到定义的异常列表中。控制器将答案集和异常列表传递给系统。系统处理异常列表中标识的页面和忽略列表中的页面。系统将这些答案与控制器返回的回答集合合并，以呈现给用户。

3. 发明授权

US5455942A Partial page write detection for a shared cache using a bit pattern written at the beginning and end of each page 失效
标题翻译：使用在每个页面的开头和结尾写入的位模式，对共享高速缓存进行局部页写入检测
公开(公告)号：US5455942A
公开(公告)日：1995-10-03
申请号：US955076
申请日：1992-10-01
申请人： Chandrasekaran Mohan , Inderpal S. Narang , James Zu-chia Teng
发明人： Chandrasekaran Mohan , Inderpal S. Narang , James Zu-chia Teng
IPC分类号： G06F12/00 , G06F11/10 , G06F12/08 , G06F12/16 , G06F15/167 , G06F11/08
CPC分类号： G06F11/1076 , G06F11/1008 , G06F12/0866 , Y10S707/99953
摘要： Disk check bits refer to bit patterns stored in particular bytes of a page which are used to detect errors in writing the page to storage. Every time a page is obtained from storage, changed from the version retained in storage, and written back to storage, the check bit pattern on the changed page is altered to be different from the bit pattern on the storage page. This is because the changed page overwrites the stored page. The invention provides a method for managing the check bits in a multi-DBMS system employing a high-speed shared electronic store as a store-in cache for all pages obtained from disk storage. When a page is first obtained from disk storage by a DBMS and changed, check bit information for the page is maintained in a directory of the storing cache which indicates what the patterns are for the version of the page in the disk storage. All pages which are modified are stored in the store-in cache and are only returned to disk storage from the cache. Therefore, when a page is to be written to disk storage, the DBMS writing the page to storage processes the check bits on the page itself, changing them as required based on the check bit information stored in the directory for the page.
摘要翻译：磁盘检查位是指存储在页面的特定字节中的位模式，用于检测将页面写入存储器时的错误。每次从存储中获取页面时，从存储中保留的版本中更改页面，并将其写回存储器，更改页面上的校验位模式将更改为与存储页面上的位模式不同。这是因为更改的页面将覆盖存储的页面。本发明提供一种用于管理采用高速共享电子商店的多DBMS系统中的校验位的方法，作为从磁盘存储器获得的所有页面的存储高速缓存。当页首首先由DBMS从磁盘存储器中获取并更改时，检查页面的位信息是否保存在存储缓存的目录中，该目录指示磁盘存储器中页面版本的模式。被修改的所有页面都存储在存储缓存中，只能从高速缓存返回到磁盘存储。因此，当将页面写入磁盘存储器时，将页面写入存储器的DBMS处理页面本身的校验位，根据存储在页面目录中的校验位信息根据需要进行改变。

4. 发明授权

US5455946A Method and means for archiving modifiable pages in a log based transaction management system 失效
标题翻译：在基于日志的事务管理系统中归档可修改页面的方法和手段
公开(公告)号：US5455946A
公开(公告)日：1995-10-03
申请号：US66360
申请日：1993-05-21
申请人： Chandrasekaran Mohan , Inderpal S. Narang
发明人： Chandrasekaran Mohan , Inderpal S. Narang
IPC分类号： G06F12/00 , G06F11/14 , G06F11/22 , G06F15/00
CPC分类号： G06F11/1451 , G06F2201/87 , Y10S707/99953
摘要： A method and means for achieving files of modifiable pages in a log based phased commit transaction management system (TMS) in which those pages which have been modified since the last full or incremental backup donot require during the copy operation any modifications to the page itself but merely to a common status page. This is accomplished by management of a pair of global log sequence numbers. Comparison between a first number (ICBU.sub.-- LSN) and each data page LSN as the page is modified permits the common status page to be updated to correctly reflect the changed status. Subsequent modifications to the same page donot require amendment of the status page. The status page indicia are reset as part of the backup procedure and for ascertaining the page copy set for incremental copying. The ICBU LSN assumes one of two values as a function of the copy operation and another value for processing page modifications after the copy operation. A second number (ICRF.sub.-- LSN) is used in the restoration of a file after the file has been partially restored by a page merge in page number order from full and incremental copies. In this case, the ICRF.sub.-- LSN defines the point in the log for redo since the most recent copy was made.
摘要翻译：一种用于在基于日志的分阶段提交事务管理系统（TMS）中实现可修改页面的文件的方法和手段，其中自上次完全备份或增量备份之后修改的页面在复制操作期间需要修改页面本身但是只是一个共同的状态页面。这是通过管理一对全局日志序列号来实现的。第一个数字（ICBU-LSN）和页面修改的每个数据页面LSN之间的比较允许更新公共状态页面以正确反映已更改的状态。对同一页面的后续修改不需要修改状态页面。状态页标记被重置为备份过程的一部分，并用于确定用于增量复制的页面副本集。 ICBU LSN假定作为复制操作的函数的两个值之一，以及在复制操作之后处理页面修改的另一个值。第二个数字（ICRF-LSN）用于在从完整版本和增量副本以页码顺序的页面合并部分恢复文件之后恢复文件。在这种情况下，ICRF-LSN定义了从最近的拷贝进行的日志中的重做点。

5. 发明授权

US5408653A Efficient data base access using a shared electronic store in a multi-system environment with shared disks 失效
标题翻译：在具有共享磁盘的多系统环境中使用共享电子商店进行有效的数据库访问
公开(公告)号：US5408653A
公开(公告)日：1995-04-18
申请号：US869267
申请日：1992-04-15
申请人： Jeffrey W. Josten , Tina L. Masatani , Chandrasekaran Mohan , Inderpal S. Narang , James Z. Teng
发明人： Jeffrey W. Josten , Tina L. Masatani , Chandrasekaran Mohan , Inderpal S. Narang , James Z. Teng
IPC分类号： G06F12/00 , G06F11/14 , G06F17/30 , G06F15/40
CPC分类号： G06F17/30362 , G06F11/1471 , Y10S707/99938 , Y10S707/99952 , Y10S707/99953
摘要： A computer-implemented method for minimizing the amount of time to access current data in a database which may be stored wholly in a DASD-oriented external storage subsystem or partly in DASD and partly in a stored high-speed electronic store while maintaining coherency of the data with respect to multiple user systems.
摘要翻译：一种计算机实现的方法，用于最小化访问数据库中当前数据的时间量，其可以完全存储在面向DASD的外部存储子系统中，或者部分地存储在DASD中，部分存储在存储的高速电子存储中，同时保持相对于多个用户系统的数据。

6. 发明授权

US5327556A Fast intersystem page transfer in a data sharing environment with record locking 失效
标题翻译：在具有记录锁定的数据共享环境中快速进行系统间页面传输
公开(公告)号：US5327556A
公开(公告)日：1994-07-05
申请号：US59734
申请日：1993-05-11
申请人： Chandrasekaran Mohan , Inderpal S. Narang
发明人： Chandrasekaran Mohan , Inderpal S. Narang
IPC分类号： G06F9/46 , G06F12/00 , G06F12/08 , G06F17/30 , G06F15/40
CPC分类号： G06F17/30171 , G06F12/0815 , Y10S707/922 , Y10S707/99938 , Y10S707/99939 , Y10S707/99953
摘要： A fast technique for transferring units of data between transaction systems in a shared disk environment. The owning system, having updated the page, generates a version number for the page which is stored with a lock possessed by the owning system. When a requesting system seeks a record on the page, its request for a lock illicit an indication that a more recent version of the page is required in the local memory. The buffer management component of a DBMS, with assistance from the lock management, triggers a memory to memory transfer of the page from the owning DBMS to the requesting DBMS using a low overhead communication protocol. The transfer of page is without disk I/O or the log I/O for the updates made to the page.
摘要翻译：一种用于在共享磁盘环境中的事务系统之间传输数据单元的快速技术。拥有该系统的页面更新后，会生成一个版本号，用于存储拥有系统所拥有的锁的页面。当请求系统寻求页面上的记录时，其对锁的请求非法地指示在本地存储器中需要更新版本的页面。 DBMS的缓冲区管理组件在锁定管理的帮助下触发内存，使用低开销通信协议将页面从拥有的DBMS内存传输到请求DBMS。页面的传输没有磁盘I / O或用于对页面进行更新的日志I / O。

7. 发明授权

US5280611A Method for managing database recovery from failure of a shared store in a system including a plurality of transaction-based systems of the write-ahead logging type 失效
标题翻译：用于从系统中的共享存储器的故障中管理数据库恢复的方法，包括多个基于事务的预写记录类型的系统
公开(公告)号：US5280611A
公开(公告)日：1994-01-18
申请号：US790241
申请日：1991-11-08
申请人： Chandrasekaran Mohan , Inderpal S. Narang , James Z. Teng
发明人： Chandrasekaran Mohan , Inderpal S. Narang , James Z. Teng
IPC分类号： G06F12/00 , G06F11/14 , G06F11/30 , G06F12/16 , G06F15/40
CPC分类号： G06F11/1471 , G06F2201/825 , G06F2201/87 , Y10S707/99938 , Y10S707/99953
摘要： In a multi-system data sharing complex, a database system can write updated pages to a shared electronic store for a fast write. Other database systems can obtain pages written to the shared store for further modification without the pages first being written to stable storage. However, pages are eventually written to the stable storage in a castout process. Recovery of a database from failure of the shared store is bounded by determination of a recovery boundary which, when applied to the union of database system transaction logs, establishes a point in front of which are found log records of modifications to pages which were in the shared store when it failed. These log records are applied to page versions obtained from stable storage to recover from failure of the shared store.
摘要翻译：在多系统数据共享复合体中，数据库系统可以将更新的页面写入共享电子商店以进行快速写入。其他数据库系统可以获得写入共享存储区的页面，以便进一步修改，而无需首先将页面写入稳定存储。但是，页面最终会在castout进程中写入稳定存储。通过确定恢复边界来限制数据库的恢复，该恢复边界在应用于数据库系统事务日志的并集时建立一个前面的点，找到对位于共享存储失败时。这些日志记录应用于从稳定存储获得的页面版本，以从共享存储的故障中恢复。

8. 发明授权

US5761660A Computer program product and program storage device for database access using a shared electronic store in a multi-system environment having shared disks 失效
标题翻译：用于在具有共享磁盘的多系统环境中使用共享电子商店进行数据库访问的计算机程序产品和程序存储设备
公开(公告)号：US5761660A
公开(公告)日：1998-06-02
申请号：US691273
申请日：1996-08-01
申请人： Jeffrey William Josten , Tina Louise Masatani , Chandrasekaran Mohan , Inderpal S. Narang , James Zu-Chia Teng
发明人： Jeffrey William Josten , Tina Louise Masatani , Chandrasekaran Mohan , Inderpal S. Narang , James Zu-Chia Teng
IPC分类号： G06F12/00 , G06F11/14 , G06F17/30
CPC分类号： G06F17/30362 , G06F11/1471 , Y10S707/99938 , Y10S707/99952 , Y10S707/99953
摘要： A computer-implemented method for minimizing the amount of time to access current data in a database which may be stored wholly in a DASD-oriented external storage subsystem or partly in DASD and partly in a stored high-speed electronic store while maintaining coherency of the data with respect to multiple user systems.
摘要翻译：一种计算机实现的方法，用于最小化访问数据库中当前数据的时间量，其可以完全存储在面向DASD的外部存储子系统中，或者部分地存储在DASD中，部分存储在存储的高速电子存储中，同时保持相对于多个用户系统的数据。

9. 发明授权

US5493668A Multiple processor system having software for selecting shared cache entries of an associated castout class for transfer to a DASD with one I/O operation 失效
标题翻译：多处理器系统具有用于选择用于通过一个I / O操作传送到DASD的关联的流出类的共享高速缓存条目的软件
公开(公告)号：US5493668A
公开(公告)日：1996-02-20
申请号：US860806
申请日：1992-03-30
申请人： David A. Elko , Jeffrey A. Frey , Chandrasekaran Mohan , Inderpal S. Narang , Jeffrey M. Nick , Jimmy P. Strickland , Michael D. Swanson
发明人： David A. Elko , Jeffrey A. Frey , Chandrasekaran Mohan , Inderpal S. Narang , Jeffrey M. Nick , Jimmy P. Strickland , Michael D. Swanson
IPC分类号： G06F12/08 , G06F12/12 , G06F12/02 , G06F13/00
CPC分类号： G06F12/084 , G06F12/0868 , G06F12/0804 , G06F12/128
摘要： A high-speed cache is shared by a plurality of independently-operating data systems in a multi-system data sharing complex. Each data system has access both to the high-speed cache and the lower-speed, secondary storage for obtaining and storing data. Management logic and the high-speed cache assures that a block of data obtained form the cache for entry into the secondary storage will be consistent with the version of the block of data in the shared cache with non-blocking serialization allowing access to a changed version in the cache while castout is being performed. Castout classes are provided to facilitate efficient movement from the shared cache to DASD.
摘要翻译：高速缓存由多系统数据共享复合体中的多个独立操作的数据系统共享。每个数据系统都可以访问高速缓存和低速二级存储，以获取和存储数据。管理逻辑和高速缓存确保从高速缓存获得的数据块进入辅助存储将与共享高速缓存中的数据块版本一致，具有允许访问更改版本的非阻塞序列化在执行castout时的缓存中。提供了Castout类，以便有效地从共享缓存移动到DASD。

10. 发明授权

US5287473A Non-blocking serialization for removing data from a shared cache 失效
标题翻译：用于从共享缓存中删除数据的非阻塞序列化
公开(公告)号：US5287473A
公开(公告)日：1994-02-15
申请号：US627315
申请日：1990-12-14
申请人： Chandrasekaran Mohan , Inderpal S. Narang
发明人： Chandrasekaran Mohan , Inderpal S. Narang
IPC分类号： G06F12/08 , G06F12/12 , G06F13/14
CPC分类号： G06F12/128 , G06F12/084 , G06F12/0866
摘要： A high-speed cache is shared by a plurality of independently-operating data systems in a multi-system data sharing complex. Each data system has access both to the high-speed cache and the lower-speed, secondary storage for obtaining and storing data. Management logic and the high-speed cache assures that a block of data obtained form the cache for entry into the secondary storage will be consistent with the version of the block of data in the shared cache.
摘要翻译：高速缓存由多系统数据共享复合体中的多个独立操作的数据系统共享。每个数据系统都可以访问高速缓存和低速二级存储，以获取和存储数据。管理逻辑和高速缓存确保从高速缓存获得的用于进入辅助存储器的数据块将与共享缓存中的数据块的版本一致。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式