公开(公告)号：US20060026212A1

公开(公告)日：2006-02-02

申请号：US10903594

申请日：2004-07-29

申请人： Alex Tsukerman ,  Jane Chen ,  Jacco Draaijer ,  Eric Voss ,  Mineharu Takahara ,  Mark Ramacher

发明人： Alex Tsukerman ,  Jane Chen ,  Jacco Draaijer ,  Eric Voss ,  Mineharu Takahara ,  Mark Ramacher

IPC分类号： G06F17/30

CPC分类号： G06F17/30289 ,  Y10S707/99945 ,  Y10S707/99948

摘要： Various embodiments of the invention provide solutions to facilitate the management and/or automation of various database tasks, in particular system tasks. Merely by way of example, some embodiments provide methods systems and/or software products that can facilitate automation of such tasks. In accordance with certain embodiments, a maintenance window may be defined. The maintenance window can provide an opportunity for system tasks (and/or other tasks, especially those that consume significant database resources) to execute without significantly impacting the usability of the database. In particular embodiments, a maintenance window may be defined to coincide with a period of relatively low user activity. In some cases, a maintenance window may be implemented in conjunction with a job scheduler and/or a resource manager. Merely by way of example, a resource manager might allocate relatively more system and/or database resources to system tasks during the maintenance window, and/or a job scheduler may schedule system tasks to execute during the maintenance window.

摘要翻译： 本发明的各种实施例提供了便于各种数据库任务（特别是系统任务）的管理和/或自动化的解决方案。 仅仅作为示例，一些实施例提供了可以促进这些任务的自动化的方法系统和/或软件产品。 根据某些实施例，可以定义维护窗口。 维护窗口可以提供系统任务（和/或其他任务，特别是那些消耗大量数据库资源的任务）执行的机会，而不会显着影响数据库的可用性。 在特定实施例中，可以将维护窗口定义为与相对低的用户活动的周期相一致。 在某些情况下，可以结合作业调度器和/或资源管理器来实现维护窗口。 仅仅作为示例，资源管理器可以在维护窗口期间向系统任务分配相对更多的系统和/或数据库资源，和/或作业调度器可以调度在维护窗口期间执行的系统任务。

公开(公告)号：US06226649B1

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

申请号：US09390028

申请日：1999-09-03

申请人： Roger Bodamer ,  Jacco Draaijer ,  Eric Voss ,  Raghu Mani

发明人： Roger Bodamer ,  Jacco Draaijer ,  Eric Voss ,  Raghu Mani

IPC分类号： G06F1730

CPC分类号： G06F17/30427 ,  Y10S707/971 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99943 ,  Y10S707/99945

摘要： 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）向外部数据库选择性地向代理进程输出请求。 输出到外部数据库的请求是基于访问指定外部数据库可执行的操作的功能表。 因此，本地服务器进程内的异构服务管理涉及具有有限能力的外部数据库系统的客户端语句，并使用代理进程来管理与外部数据库系统的交互，包括转换数据，以保持本地服务器进程的完整性，并提供 外观给客户端应用一个均匀的分布式数据库系统。

公开(公告)号：US6041344A

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

申请号：US880325

申请日：1997-06-23

申请人： Roger Bodamer ,  Jacco Draaijer ,  Eric Voss ,  Raghu Mani

发明人： Roger Bodamer ,  Jacco Draaijer ,  Eric Voss ,  Raghu Mani

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的请求映射到 外国数据库。 本地数据库服务器选择性地为外部数据库分配预期结果的内存空间，并在从代理进程接收到预期结果后完成该语句的执行。 因此，代理进程有效地管理具有要由外部数据库系统处理的表达式的客户端语句。

公开(公告)号：US07577627B2

公开(公告)日：2009-08-18

申请号：US11247498

申请日：2005-10-10

申请人： Ravi Ramkissoon ,  Raghu Mani ,  Jacco Draaijer ,  Eric Voss

发明人： Ravi Ramkissoon ,  Raghu Mani ,  Jacco Draaijer ,  Eric Voss

IPC分类号： G06F17/00 ,  G06N5/00

CPC分类号： G06N5/02 ,  G06N5/046

摘要： A system, method, computer program and article of manufacture for improved process flow of job processing is accomplished via a combination of complex dependencies, task and chain reuse, and use of one or more events as a task.

摘要翻译： 通过复杂的依赖性，任务和链路重用的组合以及将一个或多个事件用作任务来实现用于改进作业处理过程流程的系统，方法，计算机程序和制品。

公开(公告)号：US20070094186A1

公开(公告)日：2007-04-26

申请号：US11247498

申请日：2005-10-10

申请人： Ravi Ramkissoon ,  Raghu Mani ,  Jacco Draaijer ,  Eric Voss

发明人： Ravi Ramkissoon ,  Raghu Mani ,  Jacco Draaijer ,  Eric Voss

IPC分类号： G06N5/00

CPC分类号： G06N5/02 ,  G06N5/046

摘要： A system, method, computer program and article of manufacture for improved process flow of job processing is accomplished via a combination of complex dependencies, task and chain reuse, and use of one or more events as a task.

摘要翻译： 通过复杂的依赖性，任务和链路重用的组合以及将一个或多个事件用作任务来实现用于改进作业处理过程流程的系统，方法，计算机程序和制品。

公开(公告)号：US06236997B1

公开(公告)日：2001-05-22

申请号：US08880333

申请日：1997-06-23

申请人： Roger Bodamer ,  Eric Voss ,  Jacco Draaijer

发明人： Roger Bodamer ,  Eric Voss ,  Jacco Draaijer

IPC分类号： G06F1730

CPC分类号： G06F17/30569

摘要： An apparatus and method for accessing foreign processes in a heterogeneous database environment includes a local database server having a heterogeneous services module 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, or whether the statement is registered as an external routine. The heterogeneous services module selectively outputs a request to an agent process executing in an address space separate from the local server process and in communication with the foreign database. The agent process performs all necessary interaction with the foreign database, including data type translation. The agent includes a conversion module that includes data type conversion routines, and which may obtain additional conversion routines via an Application Programming Interface (API) from a foreign database driver corresponding to the foreign database. The converted request is output from the agent process to the foreign database. Hence, the heterogeneous services module manages client statements involving foreign database systems having limited capabilities, as well as client statements having expressions unrecognizable by the local database server. Use of the agent process ensures that the integrity of the local server process is protected.

摘要翻译： 用于在异构数据库环境中访问外部进程的装置和方法包括具有异构服务模块的本地数据库服务器，以根据各自的能力选择性地向外部进程发送请求。 本地服务器进程会检查向本地数据库服务器发送语句的客户端应用程序，以确定该语句是否包含对外部数据库系统的引用，还是将该语句注册为外部例程。 异构服务模块有选择地向与本地服务器进程分离的地址空间中执行的代理进程和与外部数据库通信的请求。 代理进程执行与外部数据库的所有必要的交互，包括数据类型转换。 该代理包括一个包括数据类型转换例程的转换模块，并且可以通过应用程序编程接口（API）从对应于外部数据库的外部数据库驱动程序获得额外的转换程序。 转换的请求从代理进程输出到外部数据库。 因此，异构服务模块管理涉及具有有限功能的外部数据库系统的客户端语句以及具有本地数据库服务器无法识别的表达式的客户端语句。 使用代理进程可以确保本地服务器进程的完整性受到保护。

公开(公告)号：US07950011B2

公开(公告)日：2011-05-24

申请号：US11247500

申请日：2005-10-10

申请人： Raghu Mani ,  Jacco Draaijer ,  Eric Voss ,  Ravi Ramkissoon

发明人： Raghu Mani ,  Jacco Draaijer ,  Eric Voss ,  Ravi Ramkissoon

IPC分类号： G06F9/46

CPC分类号： G06F9/542 ,  G06F2209/544

摘要： A job scheduling technique that allows jobs to be launched as a result of messages which are not targeted specifically at the job, and for jobs to be interrelated in complex ways.

摘要翻译： 一种作业调度技术，允许作业由于不是专门针对工作的消息而导致作业的结果，以及以复杂的方式相互关联的作业。

公开(公告)号：US20070083866A1

公开(公告)日：2007-04-12

申请号：US11247500

申请日：2005-10-10

申请人： Raghu Mani ,  Jacco Draaijer ,  Eric Voss ,  Ravi Ramkissoon

发明人： Raghu Mani ,  Jacco Draaijer ,  Eric Voss ,  Ravi Ramkissoon

IPC分类号： G06F9/46

CPC分类号： G06F9/542 ,  G06F2209/544

摘要： A job scheduling technique that allows jobs to be launched as a result of messages which are not targeted specifically at the job, and for jobs to be interrelated in complex ways.

摘要翻译： 一种作业调度技术，允许作业由于不是专门针对工作的消息而导致作业的结果，以及以复杂方式相互关联的作业。

公开(公告)号：US5987463A

公开(公告)日：1999-11-16

申请号：US880326

申请日：1997-06-23

申请人： Jacco Draaijer ,  Roger Bodamer ,  Eric Voss

发明人： Jacco Draaijer ,  Roger Bodamer ,  Eric Voss

IPC分类号： G06F17/30

CPC分类号： G06F17/30483

摘要： An apparatus and method for accessing foreign processes in a heterogeneous database environment includes a local database server having a heterogeneous services module 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 for a registered external routine executable by an agent process in an address space separate from the local server process. The heterogeneous services module selectively initiates a network connection with an external agent process, and the external agent process executes the external routine by accessing a dynamically linked library. If necessary, the local database server and the agent process exchange callback queries and callback results via the heterogeneous services module to complete intermediate queries within the same user instance. The local database server then completes the client statement based on the results received from the agent process. Use of a link to an external agent process executing in a separate address space enables the local server process to use enhanced external routines written in third generation languages, without risking the local server process to failures in the external routines.

摘要翻译： 用于在异构数据库环境中访问外部进程的装置和方法包括具有异构服务模块的本地数据库服务器，以根据各自的能力选择性地向外部进程发送请求。 由本地服务器进程检查向本地数据库服务器发送语句的客户端应用程序，以确定该语句是否包含与本地服务器进程分开的地址空间中的代理进程可执行的已注册外部例程的引用。 异构服务模块选择性地启动与外部代理进程的网络连接，并且外部代理进程通过访问动态链接的库来执行外部例程。 如果需要，本地数据库服务器和代理进程通过异构服务模块交换回调查询和回调结果，以完成同一用户实例中的中间查询。 然后本地数据库服务器根据从代理进程收到的结果完成客户端语句。 使用在单独地址空间中执行的外部代理进程的链接可以使本地服务器进程使用以第三代语言编写的增强外部例程，而不会导致本地服务器进程在外部例程中发生故障。

公开(公告)号：US6049800A

公开(公告)日：2000-04-11

申请号：US962537

申请日：1997-10-31

申请人： Rajagopalan Govindarajan ,  Jacco Draaijer

发明人： Rajagopalan Govindarajan ,  Jacco Draaijer

IPC分类号： G06F17/30

CPC分类号： G06F17/30483

摘要： A database server is configured to process original requests received from a client and callback requests received from an external routine. The database server saves global information before calling the external routine to distinguish whether a received request is an original or a callback request. Furthermore, both types of requests can be submitted via the same application programming interface and preferably with the same interprocess communication protocol.

摘要翻译： 数据库服务器被配置为处理从客户端接收的原始请求和从外部例程接收的回调请求。 在调用外部例程之前，数据库服务器保存全局信息，以区分接收的请求是原始还是回调请求。 此外，两种类型的请求可以通过相同的应用编程接口提交，并且优选地具有相同的进程间通信协议。