Apparatus and method for passing statements to foreign databases by
using a virtual package
    5.
    发明授权
    Apparatus and method for passing statements to foreign databases by using a virtual package 失效
    通过使用虚拟包将语句传递到外部数据库的装置和方法

    公开(公告)号:US6041344A

    公开(公告)日:2000-03-21

    申请号:US880325

    申请日:1997-06-23

    IPC分类号: G06F17/30 G06F15/16

    CPC分类号: G06F17/30566

    摘要: An apparatus and method for accessing foreign processes in a heterogeneous database environment includes a local database server having heterogeneous services to selectively send foreign operations to the appropriate foreign processes in a controllable manner. A client application sending a statement to the local database server is checked by the local server to determine if the statement includes a reference to a foreign database system. The heterogeneous services selectively outputs a the foreign request to an agent process in communication with the foreign database system via an Application Programming Interface (API), where a foreign database driver corresponding to the foreign database maps the request from the API to the format of the foreign database. The local database server selectively allocates memory space for expected results from the foreign database, and completes execution of the statement upon receiving the expected results from the agent process. Hence, the agent process efficiently manages client statements having expressions to be processed by a foreign database system.

    摘要翻译: 用于在异构数据库环境中访问外部进程的装置和方法包括具有异构服务的本地数据库服务器,以选择性地以可控方式将外部操作发送到适当的外部进程。 向本地数据库服务器发送语句的客户端应用程序由本地服务器检查,以确定该语句是否包含对外部数据库系统的引用。 异构服务通过应用程序编程接口(API)选择性地将外部请求输出到与外部数据库系统通信的代理进程,其中对应于外部数据库的外部数据库驱动器将来自API的请求映射到 外国数据库。 本地数据库服务器选择性地为外部数据库分配预期结果的内存空间,并在从代理进程接收到预期结果后完成该语句的执行。 因此,代理进程有效地管理具有要由外部数据库系统处理的表达式的客户端语句。

    Apparatus and method for transparent access of foreign databases in a heterogeneous database system
    6.
    发明授权
    Apparatus and method for transparent access of foreign databases in a heterogeneous database system 有权
    国外数据库在异构数据库系统中透明访问的装置和方法

    公开(公告)号:US06226649B1

    公开(公告)日:2001-05-01

    申请号:US09390028

    申请日:1999-09-03

    IPC分类号: G06F1730

    摘要: An apparatus and method for accessing foreign processes in a heterogeneous database environment includes a local database server having heterogeneous services to selectively send requests to the foreign processes based on their respective capabilities. A client application sending a statement to the local database server is checked by the local server process to determine if the statement includes a reference to a foreign database system. The local server process selectively outputs a request to an agent process in communication with a foreign database via a generic Application Programming Interface (API). The request output to the foreign database is based on accessing a capabilities table specifying the operations that can be executed by the foreign database. Hence, the heterogeneous services within the local server process manages client statements involving foreign database systems having limited capabilities, and uses the agent process to manage interactions with the foreign database systems, including converting data, to preserve the integrity of the local server process and provide the appearance to the client application of a homogeneous distributed database system.

    摘要翻译: 用于访问异构数据库环境中的外部进程的装置和方法包括具有异构服务的本地数据库服务器,以根据各自的能力选择性地向外部进程发送请求。 本地服务器进程检查向本地数据库服务器发送语句的客户端应用程序,以确定该语句是否包含对外部数据库系统的引用。 本地服务器进程通过通用应用程序编程接口(API)向外部数据库选择性地向代理进程输出请求。 输出到外部数据库的请求是基于访问指定外部数据库可执行的操作的功能表。 因此,本地服务器进程内的异构服务管理涉及具有有限能力的外部数据库系统的客户端语句,并使用代理进程来管理与外部数据库系统的交互,包括转换数据,以保持本地服务器进程的完整性,并提供 外观给客户端应用一个均匀的分布式数据库系统。