PRO/5® Data Server
Working together, BASIS clients and the PRO/5 Data Server create high-performance, cost-effective client/server systems that are faster and more efficient than common mapped-drive systems.
In a typical network, using mapped or NFS-mounted drives, a Windows client must do all file processing and exchange multiple messages with a remote data source to complete even a simple transaction. In a BASIS client/server system, the PRO/5 Data Server moves the burden of file system processing off the client and onto the remote server. Only two messages, a request from the client and an answer from the server, must be exchanged to complete a read or write to a file. The end result is less network traffic, better overall network performance and faster data access.
In addition to better performance, a BASIS client/server system using PRO/5, Visual PRO/5, and the PRO/5 Data Server can support a variety of client/server features. You can use new modes to maintain a connection between a client and a data server regardless of the BEGINs in your application’s code. When using a PRO/5 Data Server, you can utilize 4-GB and 64-bit files on operating systems that support the large file system standard. And the PRO/5 Data Server manages client licensing and connections on networks that dynamically allocate IP addresses using standards such as the dynamic host control protocol (DHCP).
BBj® Data Server
The BBj DS Server, which is included with BBj, offers server-side execution and processing of SQL statements, as the SQL engine is part of the data server rather than the ODBC driver. Because of this, processing of multithreaded SQL statements is much more efficient. The BBj DS Data Server is backward compatible with earlier PRO/5® and Visual PRO/5® versions of the SQL engine.
The BBj DS Server uses an intelligent query optimizer that implements optimization strategies, including those for statements containing one or more ORs in WHERE clauses. The Enterprise Manager, the data server’s GUI administration tool, provides a central location for managing all BBj Data Servers. From the Enterprise Manager, you can configure all database and server settings as well as maintain all database- and user-level security.
For a detailed listing of the current ports and revisions for these languages on the popular Windows, Linux/UNIX (*nix), and Mac platforms, see BASIS Platform Availability list.