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

1. 发明授权

US10235368B2 System and method for updating external file referenced by database with transactional consistency using SQL 有权
公开(公告)号：US10235368B2
公开(公告)日：2019-03-19
申请号：US10135982
申请日：2002-04-30
申请人： Hui-I Hsiao , Joshua Wai-Ho Hui , Inderpal Singh Narang
发明人： Hui-I Hsiao , Joshua Wai-Ho Hui , Inderpal Singh Narang
IPC分类号： G06F17/30
摘要： A system and method for updating files in a file system that is linked to a database system which stores metadata pertaining to the files. Changes intended to be made to an original file are written to a replacement file, and when the user is ready to move the changes onto the original file, a database transaction is commenced. If the transaction commits, the replacement file is renamed to the original file and the file security attributes of the original file are applied. Otherwise, the rename operation does not take place, thereby ensuring consistency between the metadata in the dbms system and the file system data that is represented by the metadata.

2. 发明授权

US06553391B1 System and method for replicating external files and database metadata pertaining thereto 有权
标题翻译：用于复制与其相关的外部文件和数据库元数据的系统和方法
公开(公告)号：US06553391B1
公开(公告)日：2003-04-22
申请号：US09590637
申请日：2000-06-08
申请人： Robert David Goldring , Joshua Wai-Ho Hui , Inderpal Singh Narang
发明人： Robert David Goldring , Joshua Wai-Ho Hui , Inderpal Singh Narang
IPC分类号： G06F1730
CPC分类号： G06F17/30174 , Y10S707/99953 , Y10S707/99954
摘要： A system and method for replicating files in a source file system that is linked to a source DBMS which stores metadata pertaining to files in the source file system. The files and metadata are replicated to a target system having a target file system linked to a target DBMS. File references are also mapped from the source to the target. Also, only the most recent consistent version of files that have changed at the source and that have had insert or update references in the source DBMS are copied over to the target file system, thereby minimizing unnecessary replications.
摘要翻译：用于复制源文件系统中的文件的系统和方法，该文件系统链接到源数据库，其存储与源文件系统中的文件有关的元数据。将文件和元数据复制到具有链接到目标DBMS的目标文件系统的目标系统。文件引用也从源映射到目标。此外，只有在源代码中已更改并在源DBMS中具有插入或更新引用的最新的一致版本的文件被复制到目标文件系统，从而最小化不必要的复制。

3. 发明授权

US06874001B2 Method of maintaining data consistency in a loose transaction model 有权
标题翻译：在松散的事务模型中维护数据一致性的方法
公开(公告)号：US06874001B2
公开(公告)日：2005-03-29
申请号：US09971755
申请日：2001-10-05
申请人： Inderpal Singh Narang , Karen Wolfe Brannon , Suparna Bhattacharya , Hui-I Hsiao
发明人： Inderpal Singh Narang , Karen Wolfe Brannon , Suparna Bhattacharya , Hui-I Hsiao
IPC分类号： G06F12/00 , G06F17/30
CPC分类号： G06F17/30551 , G06F8/71 , G06F17/30943 , Y10S707/99938 , Y10S707/99954
摘要： A method, an apparatus, a system, a computer program product, and a computer program are disclosed for maintaining consistency of object content (252) and metadata (204) related to the object (252) in a loose transaction model, preferably using SQL Mediated Object Manipulation (SMOM), for object and meta-data updates. The related meta-data (204) and a reference to the object (252) are stored in a table of a database. The object is stored externally to the database in an object store. The reference is used to obtain a handle for directly accessing or manipulating the external object. A version number embedded in the handle is then obtained. The embedded version number is then compared with a version number of a latest committed version of the externally stored object to determine if the handle refers to a current version of the externally stored object. Next, the last modification timestamp of the file is compared with the last modification timestamp of the latest committed version, in order to detect uncommitted updates. A mismatch indicates that stale data is being referenced, and in that situation an appropriate error is returned.
摘要翻译：公开了一种方法，装置，系统，计算机程序产品和计算机程序，用于在松散的事务模型中保持与对象（252）相关的对象内容（252）和元数据（204）的一致性，优选地使用SQL 媒体对象操纵（SMOM），用于对象和元数据更新。相关的元数据（204）和对对象（252）的引用被存储在数据库的表中。对象存储在对象存储中的数据库的外部。该引用用于获取用于直接访问或操纵外部对象的句柄。然后获得嵌入在句柄中的版本号。然后将嵌入的版本号与外部存储对象的最新提交版本的版本号进行比较，以确定句柄是否指向外部存储对象的当前版本。接下来，将文件的最后修改时间戳与最新提交版本的最后修改时间戳进行比较，以便检测未提交的更新。不匹配表示正在引用陈旧的数据，在这种情况下会返回适当的错误。

4. 发明授权

US06564215B1 Update support in database content management 有权
标题翻译：更新数据库内容管理支持
公开(公告)号：US06564215B1
公开(公告)日：2003-05-13
申请号：US09464836
申请日：1999-12-16
申请人： Hui-I Hsiao , Inderpal Singh Narang
发明人： Hui-I Hsiao , Inderpal Singh Narang
IPC分类号： G06F1730
CPC分类号： G06F17/30362 , G06F11/1461 , G06F11/1469 , G06F2201/80 , Y10S707/99938 , Y10S707/99953
摘要： A computer system updates a data object that is maintained in data storage external to a database management system (DBMS), after receiving an update request from a DBMS client for the data object, by first scheduling the update request with the DBMS to provide access to the external data object, then initiating a subtransaction in the DBMS for the update request, updating the data object with an in-place update action at the external data storage to thereby produce an updated data object and also updating the DBMS metadata of the data object, next appending information relating to type and time of the update action in an object version table, and then executing a backup operation of the updated data object. This permits update-in-place operations on the external data object, under supervision of the DBMS. The system thereby supports update-in-place operations on external data with access control, backup and recovery, and transaction consistency in accordance with a database management system, while avoiding large copy operations that would consume network resources.
摘要翻译：在从数据对象的DBMS客户机接收到更新请求之后，计算机系统通过首先利用DBMS调度更新请求来更新在数据库管理系统（DBMS）外部的数据存储中维护的数据对象，以提供对数据对象的访问外部数据对象，然后在DBMS中启动用于更新请求的子迁移，在外部数据存储器处利用就地更新动作更新数据对象，从而产生更新的数据对象，并且还更新数据对象的DBMS元数据，下一步将关于更新动作的类型和时间的信息附加到对象版本表中，然后执行更新的数据对象的备份操作。这允许在DBMS的监督下对外部数据对象进行就地更新操作。因此，该系统根据数据库管理系统支持具有访问控制，备份和恢复以及事务一致性的外部数据的就地操作，同时避免消耗网络资源的大型复制操作。

5. 发明授权

US06496944B1 Method for database assisted file system restore 有权
标题翻译：数据库辅助文件系统恢复方法
公开(公告)号：US06496944B1
公开(公告)日：2002-12-17
申请号：US09413368
申请日：1999-10-06
申请人： Hui-I Hsiao , Kiran Mehta , Inderpal Singh Narang
发明人： Hui-I Hsiao , Kiran Mehta , Inderpal Singh Narang
IPC分类号： G06F1100
CPC分类号： G06F11/1435 , G06F11/1471
摘要： Recovery of a filesystem directory structure is performed to restore it to any point in time and also to synchronize a database restore and a filesystem restore to bring the two restores to a database consistent state. A database management system (DBMS) manages external files and hierarchical directory structures to enable recovery and reconciliation of the files and filesystems, under DBMS control, after filesystem crashes. First, a database table, which recorded previous directory creations and deletions, is used to rebuild a filesystem's directory structure to any previous database state and then external file link information is used to restore files to that same state.
摘要翻译：执行文件系统目录结构的恢复，以将其还原到任何时间点，并且还可以同步数据库还原和文件系统还原，以使两个还原到数据库一致状态。数据库管理系统（DBMS）管理外部文件和分层目录结构，以在文件系统崩溃后，在DBMS控制下启用文件和文件系统的恢复和协调。首先，记录以前的目录创建和删除的数据库表用于将文件系统的目录结构重建为任何先前的数据库状态，然后使用外部文件链接信息将文件还原到同一状态。

6. 发明授权

US06438654B1 Castout processing for duplexed cache structures 有权
标题翻译：双工缓存结构的Castout处理
公开(公告)号：US06438654B1
公开(公告)日：2002-08-20
申请号：US09255383
申请日：1999-02-22
申请人： David Arlen Elko , Steven Bruce Jones , Jeffrey W. Josten , Inderpal Singh Narang , Jeffrey M. Nick , Kelly B. Pushong , David Harold Surman , James Zu-Chia Teng
发明人： David Arlen Elko , Steven Bruce Jones , Jeffrey W. Josten , Inderpal Singh Narang , Jeffrey M. Nick , Kelly B. Pushong , David Harold Surman , James Zu-Chia Teng
IPC分类号： G06F1300
CPC分类号： G06F11/1666 , G06F11/1471 , G06F11/20 , G06F12/0804 , G06F12/0866
摘要： Castout processing for duplexed data structures. A selective data item is written from a primary instance of a data structure to at least one storage medium. A determination is made as to whether the selective data item can be deleted from a secondary instance of the data structure. If the selective data item can be deleted, it is deleted from the secondary instance.
摘要翻译：双工数据结构的铸造处理。将选择性数据项从数据结构的主实例写入到至少一个存储介质。确定是否可以从数据结构的次级实例中删除选择性数据项。如果可以删除选择性数据项，则从辅助实例中删除。

7. 发明授权

US07885953B2 Off-loading star join operations to a storage server 失效
标题翻译：卸载明星加入操作到存储服务器
公开(公告)号：US07885953B2
公开(公告)日：2011-02-08
申请号：US11866907
申请日：2007-10-03
申请人： Ying-lin Chen , You-Chin Fuh , Wei Han , Fen-Ling Lin , Inderpal Singh Narang , Lin Qiao , Vijayshankar Raman , Kouhorng Allen Yang
发明人： Ying-lin Chen , You-Chin Fuh , Wei Han , Fen-Ling Lin , Inderpal Singh Narang , Lin Qiao , Vijayshankar Raman , Kouhorng Allen Yang
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30498
摘要： A method, storage server, and computer readable medium for off-loading star-join operations from a host information processing system to a storage server. At least a first and second set of keys from a first and second dimension table, respectively are received from a host system. Each of the first and second set of keys is associated with at least one fact table. A set of locations associated with a set of foreign key indexes are received from the host system. A set of fact table indexes are traversed. At least a first set of Row Identifiers (“RIDs”) associated with the first set of keys and at least a second set of RIDs associated with the second set of keys are identified. An operation is performed on the first and second sets of RIDs to identify an intersecting set of RIDs. The intersecting set of RIDs are then stored.
摘要翻译：一种用于从主机信息处理系统到存储服务器的卸载星形连接操作的方法，存储服务器和计算机可读介质。分别从主机系统接收来自第一和第二维度表的至少第一和第二组密钥。第一组和第二组中的每一个与至少一个事实表相关联。从主机系统接收与一组外键索引相关联的一组位置。遍历一组事实表索引。识别与第一组密钥相关联的至少第一组行标识符（“RID”）和与第二组密钥相关联的至少第二组RID。对第一和第二组RID执行操作以识别RID的交叉集合。然后存储相交的RID集合。

8. 发明申请

US20080059489A1 Method for parallel query processing with non-dedicated, heterogeneous computers that is resilient to load bursts and node failures 审中-公开
标题翻译：使用非专用异构计算机进行并行查询处理的方法，该计算机对加载突发和节点故障具有弹性
公开(公告)号：US20080059489A1
公开(公告)日：2008-03-06
申请号：US11512769
申请日：2006-08-30
申请人： Wei Han , Inderpal Singh Narang , Vijayshankar Raman
发明人： Wei Han , Inderpal Singh Narang , Vijayshankar Raman
IPC分类号： G06F7/00
CPC分类号： G06F9/5066 , G06F16/245 , G06F16/2455
摘要： A method is provided for query processing in a grid computing infrastructure. The method entails storing data in a data storage system accessible to a plurality of computing nodes. Computationally-expensive query operations are identified and query fragments are allocated to individual nodes according to computing capability. The query fragments are independently executed on individual nodes. The query fragment results are combined into a final query result.
摘要翻译：提供了一种用于网格计算基础设施中的查询处理的方法。该方法需要将数据存储在多个计算节点可访问的数据存储系统中。识别计算昂贵的查询操作，并根据计算能力将查询片段分配给各个节点。查询片段在各个节点上独立执行。查询片段结果组合成最终查询结果。

9. 发明授权

US07827283B2 System for managing and controlling storage access requirements 有权
标题翻译：用于管理和控制存储访问要求的系统
公开(公告)号：US07827283B2
公开(公告)日：2010-11-02
申请号：US10367444
申请日：2003-02-19
申请人： Vijay K. Naik , Vitthal Mahadeo Gogate , Divyesh Jadav , Inderpal Singh Narang , Prashant Pandey , Upendra Sharma , Pradeep Varma , Nagraj Alur
发明人： Vijay K. Naik , Vitthal Mahadeo Gogate , Divyesh Jadav , Inderpal Singh Narang , Prashant Pandey , Upendra Sharma , Pradeep Varma , Nagraj Alur
IPC分类号： G06F15/16 , G06F12/00
CPC分类号： H04L67/1095 , H04L29/06 , H04L67/1097 , H04L67/322 , H04L69/329
摘要： A Resource Management and Reservation System (RMRS) for managing and reserving storage bandwidth, is a platform independent middleware layer that provides an interface to applications, their database management systems, or some other higher level data management systems like ADRS which does data management on behalf of the applications. RMRS is highly relevant in hosted environments where one or more applications may be run on behalf of multiple customers each with a unique service level agreement with the Service Provider. Through its interface to the aforementioned applications, RMRS allows each application or an application side management system to communicate expected future storage access requirements (e.g., periodic access for backups). The interface also allows applications to request urgent storage access (e.g., recovery actions may be requested without being planned ahead of time).
摘要翻译：用于管理和保留存储带宽的资源管理和预留系统（RMRS）是一个独立于平台的中间件层，为应用程序，数据库管理系统或其他更高级别的数据管理系统（如代表数据管理的ADRS）提供接口的应用程序。 RMRS在托管环境中高度相关，其中可以代表多个客户运行一个或多个应用程序，每个客户与服务提供商具有唯一的服务级别协议。通过其与上述应用的接口，RMRS允许每个应用程序或应用程序侧管理系统传达预期的未来存储访问要求（例如，备份的定期访问）。该接口还允许应用程序请求紧急存储访问（例如，可以在不提前计划的情况下请求恢复动作）。

10. 发明授权

US07337195B2 Method and device for establishing synchronized recovery log points 有权
标题翻译：用于建立同步恢复日志点的方法和设备
公开(公告)号：US07337195B2
公开(公告)日：2008-02-26
申请号：US10334892
申请日：2002-12-31
申请人： Namik Hrle , Inderpal Singh Narang , James Zu-Chia Teng
发明人： Namik Hrle , Inderpal Singh Narang , James Zu-Chia Teng
IPC分类号： G06F17/30 , G06F17/00
CPC分类号： G06F11/1471 , G06F2201/80 , G06F2201/82 , Y10S707/99952 , Y10S707/99953
摘要： According to the present invention a method and a system is provided for establishing synchronized recovery log points in an infrastructure comprising at least a first database management system and a second database management system, whereby recovery log files are written and log points are created separately for each database management system. Firstly, log write of all database management systems is suspended, then, the corresponding log points for each database management system forming a global log point are recorded and log writes of all database management systems are resumed.
摘要翻译：根据本发明，提供一种方法和系统，用于在包括至少第一数据库管理系统和第二数据库管理系统的基础设施中建立同步的恢复日志点，由此写入恢复日志文件，并且为每个日志点分别创建日志点数据库管理系统。首先，暂停所有数据库管理系统的日志写入，然后记录形成全局日志点的每个数据库管理系统的对应日志点，并恢复所有数据库管理系统的日志写入。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式