Chapter 1 Understanding AI for Stored Procedures

Why Use AI for Stored Procedures?

To understand how AI for Stored Procedures can provide solutions for business problems, consider the following scenario.

Problem

A company needs to attract new prospects and keep them as customers, and at the same time, lower the cost of sales.

The company would like to allow customers to self-service their accounts through a new application over the Internet. By deploying the application over the Internet, the customer would be able to easily renew an account, and the company would expand its target market without increasing its direct sales force.

However, the company faces the following constraints:

Existing operational systems were not designed for direct exposure to customers over the Internet.
The company cannot afford to rewrite all the applications or consolidate all the data on a common platform. The business logic and security infrastructure is spread across LAN database stored procedures.
The new application must be developed using HTML and Java (for broad Internet accessibility), but none of the existing systems are "Web-enabled" today.

Solution

For its solution, the company uses Sybase Enterprise Application Server (EAServer) as a platform to integrate their internal applications and make them accessible through the Internet. Using AI for Stored Procedures, they can access the business logic in their database stored procedures quickly and easily from the Jaguar middle tier for new application development.