4th Dimension and Oracle

version 1.5

Using 4D for Oracle, you can create a data management system that combines the best of 4th Dimension with the best of Oracle. With 4D for Oracle, 4th Dimension and Oracle work together intelligently in a client/server architecture in which network traffic is greatly reduced and tasks are distributed.

4th Dimension offers an easytouse interface that allows the user to manage data using intuitive, graphically-oriented forms, editors, and menus.

The communication between 4th Dimension and Oracle can be made completely transparent to the user. The user creates and modifies records and processes data without knowing which Oracle tables are being accessed or which rows are being updated.

Using 4th Dimension's interface, the user performs database operations without knowing 4th Dimension's procedural language or Oracle's Structured Query Language (SQL).

Oracle can manage vast quantities of data and can quickly extract data to be sent to the user. Oracle operates on minicomputers and mainframe computers, both of which offer greater storage and disk access capabilities than can be found on today's personal computers.

The client/server architecture of 4D for Oracle reduces network traffic because only necessary information circulates on the network. The network is no longer just a file or message carrier. With 4D for Oracle, it is a communication tool.

In client/server architecture, the tasks are divided between the clients and the server. Each machine performs tasks for which it is best adapted.

The clients are connected to the server through a network and access common information. They generate requests, process local data, and ask the server to carry out operations.

The server stores common information. It answers the client queries by performing the operations necessary for getting results.

With 4D for Oracle, the end user computer is more than a simple terminal talking to a host. It manages the local processing of data and frees the Oracle server from controlling the interface for each user query. These tasks normally consume a great deal of the server's capacity.