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

1. 发明申请

US20090300075A1 Method and System for Data Definition Language (DDL) Replication 有权
标题翻译：数据定义语言（DDL）复制的方法和系统
公开(公告)号：US20090300075A1
公开(公告)日：2009-12-03
申请号：US12131679
申请日：2008-06-02
申请人： Ruifeng GUAN , Qi Yang
发明人： Ruifeng GUAN , Qi Yang
IPC分类号： G06F17/30
CPC分类号： G06F17/30575 , G06F17/30557
摘要： Systems, methods and computer program products for DDL replication are described herein. An embodiment includes a replication agent to instantiate one or more DDL triggers in a primary database and a replication server to provide DDL command text to a replicate database based on said DDL triggers. The replication agent uses the DDL trigger(s) to capture one or more DDL events and retrieve a transaction log associated with the DDL events. The replication agent processes the transaction log to obtain DDL command text. The DDL command text is then sent to a replicate database by the replication server where it is executed in an appropriate user context. In this way, DDL commands in may be replicated using DDL trigger(s) and session context switching.
摘要翻译：本文描述了用于DDL复制的系统，方法和计算机程序产品。一个实施例包括用于在主数据库和复制服务器中实例化一个或多个DDL触发的复制代理，以根据所述DDL触发向复制数据库提供DDL命令文本。复制代理使用DDL触发器捕获一个或多个DDL事件并检索与DDL事件关联的事务日志。复制代理处理事务日志以获取DDL命令文本。然后，DDL命令文本由复制服务器发送到复制数据库，它在适当的用户上下文中执行。以这种方式，可以使用DDL触发和会话上下文切换来复制DDL命令。

2. 发明授权

US09582558B2 Method and system for data definition language (DDL) replication 有权
标题翻译：数据定义语言（DDL）复制的方法和系统
公开(公告)号：US09582558B2
公开(公告)日：2017-02-28
申请号：US12131679
申请日：2008-06-02
申请人： Ruifeng Guan , Qi Yang
发明人： Ruifeng Guan , Qi Yang
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30575 , G06F17/30557
摘要： Systems, methods and computer program products for DDL replication are described herein. An embodiment includes a replication agent to instantiate one or more DDL triggers in a primary database and a replication server to provide DDL command text to a replicate database based on said DDL triggers. The replication agent uses the DDL trigger(s) to capture one or more DDL events and retrieve a transaction log associated with the DDL events. The replication agent processes the transaction log to obtain DDL command text. The DDL command text is then sent to a replicate database by the replication server where it is executed in an appropriate user context. In this way, DDL commands in may be replicated using DDL trigger(s) and session context switching.
摘要翻译：本文描述了用于DDL复制的系统，方法和计算机程序产品。一个实施例包括用于在主数据库和复制服务器中实例化一个或多个DDL触发的复制代理，以根据所述DDL触发向复制数据库提供DDL命令文本。复制代理使用DDL触发器捕获一个或多个DDL事件并检索与DDL事件关联的事务日志。复制代理处理事务日志以获取DDL命令文本。然后，DDL命令文本由复制服务器发送到复制数据库，它在适当的用户上下文中执行。以这种方式，可以使用DDL触发和会话上下文切换来复制DDL命令。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式