File Server and Client/Server Architecture

Networks require configuration that manages shared data stored in a central location. Users need a way of accessing information from the central file(s), and the organization needs a way of protecting data integrity and controlling traffic to maintain the availability of shared resources. These needs are met using file server and client/server architecture.

Client/Server Architecture

GoldMine Premium Edition utilizes a client/server architecture:

■ The client/server uses network resources more efficiently to reduce network traffic and respond to requests for data while maintaining data security.

■ The client/server architecture effectively divides the functions of the DBMS between the client and the server.

■ The server acts as the database engine maintaining and administering access to the data.

■ When the server receives a request from a client, the server scans the database for data on the server and returns only the requested piece rather than a whole block.

■ Processing occurs at the server, so the server sends back the data in final form as the response to the query.

■ Structured Query Language (SQL) is the tool enabling the application user interface to communicate with the server database engine.

NOTE: To encrypt database traffic between GoldMine and SQL Server, turn on Force Protocol Encryption option in the properties of the Native Client Configuration for SQL server. Note that file attachments are transferred using Microsoft networking file system and might not be encrypted.