Heterogenous database communication system in which communicating
systems identify themselves and convert any requests/responses into
their own data format
    21.
    发明授权
    Heterogenous database communication system in which communicating systems identify themselves and convert any requests/responses into their own data format 失效
    异构数据库通信系统,其中通信系统识别自身并将任何请求/响应转换成他们自己的数据格式

    公开(公告)号:US5416917A

    公开(公告)日:1995-05-16

    申请号:US66323

    申请日:1993-05-21

    摘要: The invention establishes the context in which data exchanged between dissimilar relational database management systems can be mutually understood and preserved, and data conversions can be minimized. The invention accomplishes this by establishing layers of descriptive information which isolate machine characteristics, levels of support software, and user data descriptions. Optimized processing is achieved by processing the different descriptor levels at different times during the development and execution of the database management systems. Minimal descriptive information is exchanged between the cooperating database management systems. Any data conversions that may be necessary are done only by the receiver of the data, and only at the point where it is necessary to have the data represented in the receiver's native format for processing. For sending and receiving systems which match, data conversion is completely avoided, even when the data may have been forwarded through intermediate DBMS systems which do not match. For sending and receiving systems which do not match, data conversion is minimized. The data conversion routines and tables in each system are also minimized by requiring conversion only INTO a system's native format, never FROM its native format into some other format.

    摘要翻译: 本发明建立了可以相互理解和保存不同关系数据库管理系统之间交换的数据的上下文,并且可以最小化数据转换。 本发明通过建立隔离机器特性,支持软件级别和用户数据描述的描述信息层来实现这一点。 通过在开发和执行数据库管理系统的不同时间处理不同的描述符级别来实现优化处理。 在协作的数据库管理系统之间交换最小的描述信息。 可能需要的任何数据转换只能由数据的接收者进行,并且只有在需要以接收方的本机格式表示的数据进行处理的时候才能进行。 对于匹配的发送和接收系统,完全避免数据转换,即使数据可能已经通过不匹配的中间DBMS系统转发。 对于不匹配的发送和接收系统,数据转换最小化。 每个系统中的数据转换例程和表也通过仅将INTO转换为系统的本机格式,从而将其本机格式从其他格式转换为最小化。

    Method and system for describing and exchanging data between
heterogeneous database systems with data converted by the receiving
database system
    22.
    发明授权
    Method and system for describing and exchanging data between heterogeneous database systems with data converted by the receiving database system 失效
    用异构数据库系统与接收数据库系统转换数据之间的数据进行描述和交换的方法和系统

    公开(公告)号:US5278978A

    公开(公告)日:1994-01-11

    申请号:US499114

    申请日:1990-03-26

    IPC分类号: G06F12/00 G06F17/30 G06F12/06

    摘要: The invention establishes the context in which data exchanged between dissimilar relational database management systems can be mutually understood and preserved. The invention accomplishes this by establishing layers of descriptive information which isolate machine characteristics, levels of support software, and user data descriptions. Optimized processing is achieved by processing the different descriptor levels at different times during the development and execution of the database management systems. Minimal descriptive information is exchanged between the cooperating database management systems. For systems which match, data conversion is completely avoided. For systems which do not match, data conversion is minimized.

    摘要翻译: 本发明建立了可以相互理解和保存不同关系数据库管理系统之间交换数据的上下文。 本发明通过建立隔离机器特性,支持软件级别和用户数据描述的描述信息层来实现这一点。 通过在开发和执行数据库管理系统的不同时间处理不同的描述符级别来实现优化处理。 在协作的数据库管理系统之间交换最小的描述信息。 对于匹配的系统,完全避免数据转换。 对于不匹配的系统,数据转换最小化。

    Method, system, and program product for sequential coordination of external database application events with asynchronous internal database events
    24.
    发明授权
    Method, system, and program product for sequential coordination of external database application events with asynchronous internal database events 有权
    用于使用异步内部数据库事件顺序协调外部数据库应用程序事件的方法,系统和程序产品

    公开(公告)号:US07979546B2

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

    申请号:US12103548

    申请日:2008-04-15

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30578

    摘要: Database management systems, methods, and program products that exploit time dependent sequential database management system processes to ensure presentation of the same data or view to one or a plurality of users through sequencing asynchronous database management operations such as recovery and replication. Sequencing is accomplished through the use of entries in sequential logs, including transaction logs, recovery logs, and other data recovery tools and applications. Uses include managing data migration and data replication.

    摘要翻译: 数据库管理系统,方法和程序产品利用时间依赖的顺序数据库管理系统流程,通过排序异步数据库管理操作(如恢复和复制)来确保向一个或多个用户呈现相同的数据或视图。 顺序通过使用顺序日志中的条目来实现,包括事务日志,恢复日志和其他数据恢复工具和应用程序。 用途包括管理数据迁移和数据复制。

    Failure transparency for update applications under single-master configuration
    25.
    发明授权
    Failure transparency for update applications under single-master configuration 有权
    在单主机配置下的更新应用程序的故障透明度

    公开(公告)号:US07600149B2

    公开(公告)日:2009-10-06

    申请号:US11231204

    申请日:2005-09-20

    IPC分类号: G06F11/00

    CPC分类号: G06F11/1482

    摘要: A method masking data failures, when a master copy of data is unavailable comprises storing a single master copy of data and a replica copy of the data; writing to the master using a middleware component; and reading from either the master or the replica using the middleware component, when the master copy is unavailable. When the master is unavailable, the writes are stored in a table located in the middleware component as stored write requests, in which the stored write requests comprise UDI's to be made to the master. The reads are also performed from the table and the replica when the master is unavailable. When the master becomes available, the stored write requests are propagated to the master. Thus, the middleware allows the writes to run during times when the master is unavailable.

    摘要翻译: 当数据的主副本不可用时,屏蔽数据故障的方法包括存储数据的单个主副本和数据的副本副本; 使用中间件组件向主人写信; 并且当主副本不可用时,使用中间件组件从主控或副本读取。 当主机不可用时,写入存储在位于中间件组件中的表中作为存储的写入请求,其中所存储的写入请求包括将要写入主机的UDI。 当主机不可用时,也从表和副本执行读取。 当主机可用时,存储的写入请求被传播到主机。 因此,中间件允许写入在主机不可用的时间内运行。

    System and method for asynchronous data replication without persistence for distributed computing
    26.
    发明授权
    System and method for asynchronous data replication without persistence for distributed computing 有权
    异步数据复制的系统和方法,无需持续分布式计算

    公开(公告)号:US07287043B2

    公开(公告)日:2007-10-23

    申请号:US10645221

    申请日:2003-08-21

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30578

    摘要: A system and method of lightweight asynchronous data replication that avoids the need for any persistent store at the replication source or communication channel, and is independent of the underlying data formats, wherein the method of data replication comprises replicating deltas from a source, embedding replication tracking information in the replicated deltas, wherein the tracking information comprises a timestamp and a sequence number, and applying deltas at a target. The tracking information is used to ensure that each delta is applied exactly once. In the event of a crash in the system, the target analyzes the tracking information to determine which deltas have been applied, and requests retransmission of replicated data from the source starting from the earliest unapplied delta. The source and target are treated as only delta producers and consumers, and as such the invention is applicable to replication between arbitrary data source formats.

    摘要翻译: 轻量级异步数据复制的系统和方法,避免了复制源或通信通道上任何持久存储的需要,并且独立于底层数据格式,其中数据复制的方法包括从源复制三角形,嵌入复制跟踪 复制三角形中的信息,其中所述跟踪信息包括时间戳和序列号,以及在目标上应用三角形。 跟踪信息用于确保每个增量都应用一次。 在系统崩溃的情况下,目标分析跟踪信息以确定已应用哪些增量,并且从最早未应用的增量开始从源发送重传数据。 源和目标仅被视为增量生成器和消费者,因此本发明适用于任意数据源格式之间的复制。

    Method for refreshing multicolumn tables in a relational data base using
minimal information
    28.
    发明授权
    Method for refreshing multicolumn tables in a relational data base using minimal information 失效
    使用最少信息在关系数据库中刷新多列表的方法

    公开(公告)号:US4631673A

    公开(公告)日:1986-12-23

    申请号:US693500

    申请日:1985-01-22

    摘要: A method for refreshing a relational data base snapshot manifest in the form of remote read-only copies of selected portions of a base table. The method takes advantage of the fact that each tuple of the base table has a unique identifier TID associated therewith from the time the record is inserted until it is deleted. The TID references the physical location of the tuple within its relation. Two system-maintained fields are added to the base table. These are PREVTID and update ID. One system-maintained column is required in the snapshot table, i.e. BASE TID. Lastly, a column in the catalog of the snapshot is also maintained, i.e. SNAPHIGH.When the refresh of the snapshot table is required, a single scan of the base relation, in ascending TID sequence, is performed on the base table. The scan produces a series of messages which contain the incremental changes required to update the snapshot table to the current state of the base relation. Upon receipt of the messages at the snapshot table site, a single skip sequential pass across the snapshot in BASE TID sequence is performed to apply the incremental changes. This refreshes the snapshot table to the required state.

    摘要翻译: 用于以基表的所选部分的远程只读副本的形式刷新关系数据库快照清单的方法。 该方法利用了从插入记录直到被删除的时间之后,基表的每个元组具有与其相关联的唯一标识符TID的事实。 TID在其关系中引用元组的物理位置。 两个系统维护的字段被添加到基表中。 这些是PREVTID和更新ID。 快照表中需要一个系统维护的列,即BASE TID。 最后,还保留快照目录中的列,即SNAPHIGH。 当需要刷新快照表时,在基表上执行以升序TID序列的基本关系的单次扫描。 扫描产生一系列消息,其中包含将快照表更新为基本关系的当前状态所需的增量更改。 在快照表站点接收到消息后,将执行BASE TID序列中快照的单次跳过顺序,以应用增量更改。 将快照表刷新到所需状态。

    METHOD, SYSTEM, AND PROGRAM PRODUCT FOR SEQUENTIAL COORDINATION OF EXTERNAL DATABASE APPLICATION EVENTS WITH ASYNCHRONOUS INTERNAL DATABASE EVENTS
    29.
    发明申请
    METHOD, SYSTEM, AND PROGRAM PRODUCT FOR SEQUENTIAL COORDINATION OF EXTERNAL DATABASE APPLICATION EVENTS WITH ASYNCHRONOUS INTERNAL DATABASE EVENTS 有权
    使用异步内部数据库事件进行外部数据库应用程序的顺序协调的方法,系统和程序产品

    公开(公告)号:US20080195673A1

    公开(公告)日:2008-08-14

    申请号:US12103548

    申请日:2008-04-15

    IPC分类号: G06F12/00

    CPC分类号: G06F17/30578

    摘要: Database management systems, methods, and program products that exploit time dependent sequential database management system processes to ensure presentation of the same data or view to one or a plurality of users through sequencing asynchronous database management operations such as recovery and replication. Sequencing is accomplished through the use of entries in sequential logs, including transaction logs, recovery logs, and other data recovery tools and applications. Uses include managing data migration and data replication.

    摘要翻译: 数据库管理系统,方法和程序产品利用时间依赖的顺序数据库管理系统流程,通过排序异步数据库管理操作(如恢复和复制)来确保向一个或多个用户呈现相同的数据或视图。 顺序通过使用顺序日志中的条目来实现,包括事务日志,恢复日志和其他数据恢复工具和应用程序。 用途包括管理数据迁移和数据复制。