-
1.发明授权Redundant version information in history table that enables efficient snapshot querying 失效历史表中的冗余版本信息，可实现高效的快照查询公开(公告)号：US08010492B2
公开(公告)日：2011-08-30
申请号：US12194540
申请日：2008-08-20
申请人： Dilip Kumar Biswal , Isaac Kam-Chak Cheng , Cecilia O. Chu , Donald Lee Clare , Louis S. W. Mau
发明人： Dilip Kumar Biswal , Isaac Kam-Chak Cheng , Cecilia O. Chu , Donald Lee Clare , Louis S. W. Mau
CPC分类号： G06F17/30309 , G06F17/30353 , G06F17/30356 , Y10S707/99932 , Y10S707/99933 , Y10S707/99953
摘要： A system for efficient snapshot querying include: providing a first version value for each data in a history table, where the first version value indicates a beginning of a period in which the data is valid; providing at least a second version value for each data in the history table, where the second version value indicates an end of the period in which the data is valid; receiving a request for a version of a database; and retrieving the data with the first version value less than or equal to the requested version and the second version value greater than or equal to the requested version. By maintaining a history table with redundant version information, the system is able to provide efficient snapshot querying while also avoiding the overhead burden of conventional approaches. No aggregates, joins, or sub-queries are required to retrieve a snapshot.
摘要翻译： 用于高效快照查询的系统包括：为历史表中的每个数据提供第一版本值，其中第一版本值指示数据有效的周期的开始; 为历史表中的每个数据提供至少第二版本值，其中第二版本值指示数据有效期间的结束; 接收对数据库版本的请求; 并且以小于或等于所请求的版本的第一版本值和大于或等于所请求的版本的第二版本值来检索数据。 通过维护具有冗余版本信息的历史表，系统能够提供高效的快照查询，同时避免常规方法的开销负担。 不需要聚合，连接或子查询来检索快照。
-
2.发明申请REDUNDANT VERSION INFORMATION IN HISTORY TABLE THAT ENABLES EFFICIENT SNAPSHOT QUERYING 失效历史表中的冗余版本信息使用有效的快照查询公开(公告)号：US20080306907A1
公开(公告)日：2008-12-11
申请号：US12194540
申请日：2008-08-20
CPC分类号： G06F17/30309 , G06F17/30353 , G06F17/30356 , Y10S707/99932 , Y10S707/99933 , Y10S707/99953
摘要： A system for efficient snapshot querying include: providing a first version value for each data in a history table, where the first version value indicates a beginning of a period in which the data is valid; providing at least a second version value for each data in the history table, where the second version value indicates an end of the period in which the data is valid; receiving a request for a version of a database; and retrieving the data with the first version value less than or equal to the requested version and the second version value greater than or equal to the requested version. By maintaining a history table with redundant version information, the system is able to provide efficient snapshot querying while also avoiding the overhead burden of conventional approaches. No aggregates, joins, or sub-queries are required to retrieve a snapshot.
摘要翻译： 用于高效快照查询的系统包括：为历史表中的每个数据提供第一版本值，其中第一版本值指示数据有效的周期的开始; 为历史表中的每个数据提供至少第二版本值，其中第二版本值指示数据有效期间的结束; 接收对数据库版本的请求; 并且以小于或等于所请求的版本的第一版本值和大于或等于所请求的版本的第二版本值来检索数据。 通过维护具有冗余版本信息的历史表，系统能够提供高效的快照查询，同时避免常规方法的开销负担。 不需要聚合，连接或子查询来检索快照。
-
3.发明授权Synchronization-replication concurrency using non-shared snapshot query on a history table at read-uncommitted isolation level 有权使用非共享快照查询在read-uncommitted隔离级别对历史表进行同步复制并发公开(公告)号：US07403958B2
公开(公告)日：2008-07-22
申请号：US11039472
申请日：2005-01-19
申请人： Dilip Kumar Biswal , Isaac Kam-Chak Cheng , Cecilia O. Chu , Donald Lee Clare , Louis S. W. Mau
发明人： Dilip Kumar Biswal , Isaac Kam-Chak Cheng , Cecilia O. Chu , Donald Lee Clare , Louis S. W. Mau
IPC分类号： G06F17/30
CPC分类号： G06F17/30356 , G06F17/30575 , H04L67/1095 , Y10S707/99953 , Y10S707/99955
摘要： A method and system for synchronization-replication concurrency maintain a history table for a data table in a mirror, where the history table can include redundant version values that indicate a period in which data values corresponding to the version values are valid. Replication can thus be performed between a source and a mirror for a current version of the data table, while synchronization is simultaneously performed between the mirror and a client for an earlier version of the data table using the history table.
摘要翻译： 用于同步复制并发的方法和系统维护镜像中的数据表的历史表，其中历史表可以包括指示对应于版本值的数据值有效的周期的冗余版本值。 因此，可以在数据表的当前版本的源和镜像之间执行复制，同时使用历史表在镜像和客户端之间同时执行数据表的早期版本的同步。
-
4.发明授权Redundant version information in history table that enables efficient snapshot querying 失效历史表中的冗余版本信息，可实现高效的快照查询公开(公告)号：US07509307B2
公开(公告)日：2009-03-24
申请号：US11039528
申请日：2005-01-19
申请人： Dilip Kumar Biswal , Isaac Kam-Chak Cheng , Cecilia O. Chu , Donald Lee Clare , Louis S. W. Mau
发明人： Dilip Kumar Biswal , Isaac Kam-Chak Cheng , Cecilia O. Chu , Donald Lee Clare , Louis S. W. Mau
IPC分类号： G06F7/00
CPC分类号： G06F17/30309 , G06F17/30353 , G06F17/30356 , Y10S707/99932 , Y10S707/99933 , Y10S707/99953
摘要： A method and system for efficient snapshot querying include: providing a first version value for each data in a history table, where the first version value indicates a beginning of a period in which the data is valid; providing at least a second version value for each data in the history table, where the second version value indicates an end of the period in which the data is valid; receiving a request for a version of a database; and retrieving the data with the first version value less than or equal to the requested version and the second version value greater than or equal to the requested version. By maintaining a history table with redundant version information, the method and system are able to provide efficient snapshot querying while also avoiding the overhead burden of conventional approaches. No aggregates, joins, or sub-queries are required to retrieve a snapshot.
摘要翻译： 用于高效快照查询的方法和系统包括：为历史表中的每个数据提供第一版本值，其中第一版本值指示数据有效的周期的开始; 为历史表中的每个数据提供至少第二版本值，其中第二版本值指示数据有效期间的结束; 接收对数据库版本的请求; 并且以小于或等于所请求的版本的第一版本值和大于或等于所请求的版本的第二版本值来检索数据。 通过维护具有冗余版本信息的历史表，该方法和系统能够提供高效的快照查询，同时还避免常规方法的开销负担。 不需要聚合，连接或子查询来检索快照。
-
-
-
搜索结果
4 条记录 (耗时 0.01 秒)