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

1. 发明授权

US08341120B2 Apparatus and methods for transferring database objects into and out of database systems 有权
标题翻译：将数据库对象传入和传出数据库系统的设备和方法
公开(公告)号：US08341120B2
公开(公告)日：2012-12-25
申请号：US10656525
申请日：2003-09-05
申请人： Lee B. Barton , George H. Claborn , William Fisher , James Stenoish
发明人： Lee B. Barton , George H. Claborn , William Fisher , James Stenoish
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30345
摘要： Techniques for transferring objects between database systems. A transfer is controlled by a master table in the RDBMS that is performing the transfer operation. The master table specifies the kind of transfer operation to be performed, a set of objects to be transferred, operations to be performed on the objects as they are being transferred, and filters for selecting a subset of the objects. During execution of the transfer, the transfer mechanism maintains and updates state in the master table and thereby makes it possible for the entity that is doing the transfer to determine the current status of the transfer and to restart the transfer after it has been stopped. The entity that is performing the transfer may also detach from the transfer without stopping the transfer and later again attach to the transfer.
摘要翻译：在数据库系统之间传输对象的技术。传输由正在执行传输操作的RDBMS中的主表进行控制。主表指定要执行的传送操作的种类，要传送的一组对象，要传送对象时要执行的操作，以及用于选择对象子集的过滤器。在传送执行期间，传送机制维护和更新主表中的状态，从而使正在进行传送的实体可以确定传送的当前状态，并且在停止之后重新启动传输。正在执行转移的实体可以在不停止转移的情况下从转移中分离出来，并且再次附加到转移。

2. 发明授权

US07747580B2 Direct loading of opaque types 有权
标题翻译：直接加载不透明类型
公开(公告)号：US07747580B2
公开(公告)日：2010-06-29
申请号：US10648577
申请日：2003-08-25
申请人： Namit Jain , Ellen Batbouta , Nipun Agarwal , Ravi Murthy , Paul Reilly , James Stenoish
发明人： Namit Jain , Ellen Batbouta , Nipun Agarwal , Ravi Murthy , Paul Reilly , James Stenoish
IPC分类号： G06F17/30
CPC分类号： G06F17/30286
摘要： Techniques and systems are disclosed for storing instances of an opaque type in a database according to a direct path loading approach. According to one aspect, an opaque type implementor registers, with a loader application, routines that the opaque type implementor implements. In response, the loader application associates the opaque type with the routines. The loader application reads data that comprises instances of the opaque type. The loader application determines which routines are associated with the opaque type. The loader application invokes the routines, which create an array for storing instances of the opaque type and populate the array with values specified in the data. The loader application converts the array into a data stream that conforms to the format of the database's data blocks. The loader application then streams the data to a database server, which writes the data directly into data blocks in the database.
摘要翻译：公开了根据直接路径加载方法在数据库中存储不透明类型的实例的技术和系统。根据一个方面，不透明类型的实现者使用加载器应用程序来注册不透明类型实现者实现的例程。作为响应，加载程序应用程序将不透明类型与例程相关联。加载程序应用程序读取包含不透明类型实例的数据。加载程序应用程序确定哪些程序与不透明类型相关联。加载程序应用程序调用例程，它创建一个数组来存储不透明类型的实例，并使用数据中指定的值填充数组。加载程序应用程序将阵列转换为符合数据库数据块格式的数据流。然后，加载器应用程序将数据流传输到数据库服务器，数据库服务器将数据直接写入数据库中的数据块。

3. 发明申请

US20050055351A1 Apparatus and methods for transferring database objects into and out of database systems 有权
标题翻译：将数据库对象传入和传出数据库系统的设备和方法
公开(公告)号：US20050055351A1
公开(公告)日：2005-03-10
申请号：US10656525
申请日：2003-09-05
申请人： Lee Barton , George Claborn , William Fisher , James Stenoish
发明人： Lee Barton , George Claborn , William Fisher , James Stenoish
IPC分类号： G06F17/30
CPC分类号： G06F17/30345
摘要： Techniques for transferring objects between database systems. As implemented in a relational database management system, the techniques employ a data transfer mechanism that operates under control of a master table in the RDBMS that is performing the transfer operation. The master table specifies the kind of transfer operation to be performed, a set of objects to be transferred, operations to be performed on the objects as they are being transferred, and filters for selecting a subset of the objects. During execution of the transfer, the transfer mechanism maintains and updates state in the master table such that queries may be made on the master table to determine the current status of the operation and such that the transfer mechanism may restart the operation after it has been stopped either at the request of a client that is performing the operation or because of an error in the transfer. The master table's persistence and the status information it contains permit the client that is performing the operation to detach from the operation without stopping the operation and later again attach to the operation to determine the operation's status or to perform operations such as creating new files for the operation or changing the degree of parallelism with which the transfer operation is being performed. Another feature of the transfer mechanism is using an object's metadata to determine the most efficient way of transferring the object.
摘要翻译：在数据库系统之间传输对象的技术。如在关系数据库管理系统中实现的，该技术采用数据传输机制，其在正在执行传送操作的RDBMS中的主表的控制下操作。主表指定要执行的传送操作的种类，要传送的一组对象，要传送对象时要执行的操作，以及用于选择对象子集的过滤器。在执行传送过程中，传送机制维护和更新主表中的状态，以便可以在主表上进行查询以确定操作的当前状态，并且传送机制可以在停止之后重新启动操作无论是在正在执行操作的客户端请求或由于传输中的错误。主表的持久性和其所包含的状态信息允许正在执行操作的客户端从操作中分离而不停止操作，然后再次附加到操作以确定操作的状态或执行操作，例如创建新文件操作或改变正在执行传送操作的并行度。传输机制的另一个特征是使用对象的元数据来确定传输对象的最有效方式。

4. 发明申请

US20050050058A1 Direct loading of opaque types 有权
标题翻译：直接加载不透明类型
公开(公告)号：US20050050058A1
公开(公告)日：2005-03-03
申请号：US10648577
申请日：2003-08-25
申请人： Namit Jain , Ellen Batbouta , Nipun Agarwal , Ravi Murthy , Paul Reilly , James Stenoish
发明人： Namit Jain , Ellen Batbouta , Nipun Agarwal , Ravi Murthy , Paul Reilly , James Stenoish
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30286
摘要： Techniques and systems are disclosed for storing instances of an opaque type in a database according to a direct path loading approach. According to one aspect, an opaque type implementor registers, with a loader application, routines that the opaque type implementor implements. In response, the loader application associates the opaque type with the routines. The loader application reads data that comprises instances of the opaque type. The loader application determines which routines are associated with the opaque type. The loader application invokes the routines, which create an array for storing instances of the opaque type and populate the array with values specified in the data. The loader application converts the array into a data stream that conforms to the format of the database's data blocks. The loader application then streams the data to a database server, which writes the data directly into data blocks in the database.
摘要翻译：公开了根据直接路径加载方法在数据库中存储不透明类型的实例的技术和系统。根据一个方面，不透明类型的实现者使用加载器应用程序来注册不透明类型实现者实现的例程。作为响应，加载程序应用程序将不透明类型与例程相关联。加载程序应用程序读取包含不透明类型实例的数据。加载程序应用程序确定哪些程序与不透明类型相关联。加载程序应用程序调用例程，它创建一个数组来存储不透明类型的实例，并使用数据中指定的值填充数组。加载程序应用程序将阵列转换为符合数据库数据块格式的数据流。然后，加载器应用程序将数据流传输到数据库服务器，数据库服务器将数据直接写入数据库中的数据块。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式