Redundant version information in history table that enables efficient snapshot querying
    2.
    发明授权
    Redundant version information in history table that enables efficient snapshot querying 失效
    历史表中的冗余版本信息,可实现高效的快照查询

    公开(公告)号:US08010492B2

    公开(公告)日:2011-08-30

    申请号:US12194540

    申请日:2008-08-20

    IPC分类号: G06F7/00 G06F17/00 G06F17/30

    摘要: 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.

    摘要翻译: 用于高效快照查询的系统包括:为历史表中的每个数据提供第一版本值,其中第一版本值指示数据有效的周期的开始; 为历史表中的每个数据提供至少第二版本值,其中第二版本值指示数据有效期间的结束; 接收对数据库版本的请求; 并且以小于或等于所请求的版本的第一版本值和大于或等于所请求的版本的第二版本值来检索数据。 通过维护具有冗余版本信息的历史表,系统能够提供高效的快照查询,同时避免常规方法的开销负担。 不需要聚合,连接或子查询来检索快照。

    Incrementally sychronizing occasionally-connected mobile databases, preserving horizontal filter scope consistency by using client pre-image
    3.
    发明授权
    Incrementally sychronizing occasionally-connected mobile databases, preserving horizontal filter scope consistency by using client pre-image 失效
    增量同步偶尔连接的移动数据库,通过使用客户端预映像来保持水平过滤器范围的一致性

    公开(公告)号:US07974947B2

    公开(公告)日:2011-07-05

    申请号:US12131029

    申请日:2008-05-30

    IPC分类号: G06F17/00

    摘要: A system for synchronizing data on a first device with data at a second device, includes: determining a pre-image of the data on the first device according to a filter after a previous synchronization with the data at the second device; determining a current image of the data at the second device according to the filter; determining a delta of the current image, where the delta comprises data that exists in the current image and has changed since the previous synchronization; instructing the first device to delete data that exists in the pre-image but not in the current image; and instructing the first device to UPSERT a union of the data that exists in the delta and the data that exists in the current image but not the pre-image. This is efficient in time and bandwidth resources while also providing consistent data integrity.

    摘要翻译: 一种用于将第一设备上的数据与第二设备上的数据同步的系统包括:在与第二设备上的数据进行先前同步之后,根据过滤器确定第一设备上的数据的前置映像; 根据滤波器确定第二设备处的数据的当前图像; 确定当前图像的增量,其中所述增量包括存在于当前图像中并且自先前同步之后已经改变的数据; 指示第一设备删除存在于前图像中但不在当前图像中的数据; 并指示第一个设备对存在于增量中的数据和当前图像中存在的数据而不是预映像进行联合。 这在时间和带宽资源方面是有效的,同时也提供一致的数据完整性。

    REDUNDANT VERSION INFORMATION IN HISTORY TABLE THAT ENABLES EFFICIENT SNAPSHOT QUERYING
    4.
    发明申请
    REDUNDANT VERSION INFORMATION IN HISTORY TABLE THAT ENABLES EFFICIENT SNAPSHOT QUERYING 失效
    历史表中的冗余版本信息使用有效的快照查询

    公开(公告)号:US20080306907A1

    公开(公告)日:2008-12-11

    申请号:US12194540

    申请日:2008-08-20

    IPC分类号: G06F7/06 G06F17/30

    摘要: 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.

    摘要翻译: 用于高效快照查询的系统包括:为历史表中的每个数据提供第一版本值,其中第一版本值指示数据有效的周期的开始; 为历史表中的每个数据提供至少第二版本值,其中第二版本值指示数据有效期间的结束; 接收对数据库版本的请求; 并且以小于或等于所请求的版本的第一版本值和大于或等于所请求的版本的第二版本值来检索数据。 通过维护具有冗余版本信息的历史表,系统能够提供高效的快照查询,同时避免常规方法的开销负担。 不需要聚合,连接或子查询来检索快照。

    Incrementally sychronizing occasionally-connected mobile databases, preserving horizontal filter scope consistency by using client pre-image
    5.
    发明授权
    Incrementally sychronizing occasionally-connected mobile databases, preserving horizontal filter scope consistency by using client pre-image 失效
    增量同步偶尔连接的移动数据库,通过使用客户端预映像来保持水平过滤器范围的一致性

    公开(公告)号:US07395280B2

    公开(公告)日:2008-07-01

    申请号:US10985421

    申请日:2004-11-10

    IPC分类号: G06F17/30 G06F15/16

    摘要: A method for synchronizing data on a first device with data at a second device, includes: determining a pre-image of the data on the first device according to a filter after a previous synchronization with the data at the second device; determining a current image of the data at the second device according to the filter; determining a delta of the current image, where the delta comprises data that exists in the current image and has changed since the previous synchronization; instructing the first device to delete data that exists in the pre-image but not in the current image; and instructing the first device to UPSERT a union of the data that exists in the delta and the data that exists in the current image but not the pre-image. This is efficient in time and bandwidth resources while also providing consistent data integrity.

    摘要翻译: 一种用于将第一设备上的数据与第二设备上的数据同步的方法包括:在先前与第二设备之间的数据同步之后,根据过滤器确定第一设备上的数据的前图像; 根据滤波器确定第二设备处的数据的当前图像; 确定当前图像的增量,其中所述增量包括存在于当前图像中并且自先前同步之后已经改变的数据; 指示第一设备删除存在于前图像中但不在当前图像中的数据; 并指示第一个设备对存在于增量中的数据和当前图像中存在的数据而不是预映像进行联合。 这在时间和带宽资源方面是有效的,同时也提供一致的数据完整性。

    Redundant version information in history table that enables efficient snapshot querying
    6.
    发明授权
    Redundant version information in history table that enables efficient snapshot querying 失效
    历史表中的冗余版本信息,可实现高效的快照查询

    公开(公告)号:US07509307B2

    公开(公告)日:2009-03-24

    申请号:US11039528

    申请日:2005-01-19

    IPC分类号: G06F7/00

    摘要: 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.

    摘要翻译: 用于高效快照查询的方法和系统包括:为历史表中的每个数据提供第一版本值,其中第一版本值指示数据有效的周期的开始; 为历史表中的每个数据提供至少第二版本值,其中第二版本值指示数据有效期间的结束; 接收对数据库版本的请求; 并且以小于或等于所请求的版本的第一版本值和大于或等于所请求的版本的第二版本值来检索数据。 通过维护具有冗余版本信息的历史表,该方法和系统能够提供高效的快照查询,同时还避免常规方法的开销负担。 不需要聚合,连接或子查询来检索快照。

    INCREMENTALLY SYCHRONIZING OCCASIONALLY-CONNECTED MOBILE DATABASES, PRESERVING HORIZONTAL FILTER SCOPE CONSISTENCY BY USING CLIENT PRE-IMAGE
    7.
    发明申请
    INCREMENTALLY SYCHRONIZING OCCASIONALLY-CONNECTED MOBILE DATABASES, PRESERVING HORIZONTAL FILTER SCOPE CONSISTENCY BY USING CLIENT PRE-IMAGE 失效
    通过使用客户端预先图像来保持水平滤波器一致性,实现了全方位同步的移动移动数据库

    公开(公告)号:US20080228858A1

    公开(公告)日:2008-09-18

    申请号:US12131029

    申请日:2008-05-30

    IPC分类号: G06F15/16

    摘要: A system for synchronizing data on a first device with data at a second device, includes: determining a pre-image of the data on the first device according to a filter after a previous synchronization with the data at the second device; determining a current image of the data at the second device according to the filter; determining a delta of the current image, where the delta comprises data that exists in the current image and has changed since the previous synchronization; instructing the first device to delete data that exists in the pre-image but not in the current image; and instructing the first device to UPSERT a union of the data that exists in the delta and the data that exists in the current image but not the pre-image. This is efficient in time and bandwidth resources while also providing consistent data integrity.

    摘要翻译: 一种用于将第一设备上的数据与第二设备上的数据同步的系统包括:在与第二设备上的数据进行先前同步之后,根据过滤器确定第一设备上的数据的前置映像; 根据滤波器确定第二设备处的数据的当前图像; 确定当前图像的增量,其中所述增量包括存在于当前图像中并且自先前同步之后已经改变的数据; 指示第一设备删除存在于前图像中但不在当前图像中的数据; 并指示第一个设备对存在于增量中的数据和当前图像中存在的数据而不是预映像进行联合。 这在时间和带宽资源方面是有效的,同时也提供一致的数据完整性。