Chapter 1 Understanding AI for Stored Procedures

Jaguar and AI for Stored Procedures Functionality

The following sections are intended to familiarize you with how Jaguar functions and how it relates to AI for Stored Procedures:

How Jaguar Works

Jaguar implements a "multi-tier" distributed computing architecture. Figure 1-3 shows the typical Jaguar environment, in which three distinct elements, or tiers, work together to give users access to data:

The client application code, which manages the presentation and interaction with the end user.
Middle-tier components, which run in Jaguar and are typically coded by the middle-tier developer. They contain the executable business logic that handles much of the application processing.
The back-end database, which is the transaction target accessed by the Jaguar component. It stores, manages, and processes data.

Figure 1-3: Typical Jaguar environment

In most cases, interaction between the client application and Jaguar occurs as follows:

When a client application needs to use a component, it issues a request to the Jaguar server.
The request from the client prompts Jaguar to instantiate the component.
The client invokes a method on a component.
The method invokes the target stored procedure and returns any results to the client.

For detailed information about how Jaguar works, see the Jaguar documentation.

When Jaguar Uses AI for Stored Procedures Components

In AI for Stored Procedures, the components in the middle-tier contain methods that represent target stored procedures. Figure 1-4 shows the following elements, or tiers, of the AI for Stored Procedures environment:

The client, which contains the application code that manages the presentation and interaction with the end user.
Middle-tier AI for Stored Procedures components, which contain methods that provide direct access to a target stored procedure. No middle-tier coding is required.
The target stored procedure, which contains business logic for an application.

Figure 1-4 shows the Jaguar client accessing a stored procedure through the AI for Stored Procedures component in the middle tier.

Figure 1-4: AI for Stored Procedures environment