It is not a secret that today a lot of crm solutions are based on the "Client-Server" principle, i.e. all data of the modern crm systems are saved and processed by the help of one centralized database and customers usually receive the access to them over various remote terminals. Thus, the interaction between a client and a server can be performed on the basis of Intranet/Internet. In order to receive the access to the system over the Internet, a client uses a standard web-browser. In fact, the "Server" part usually consists of two following applications:
1) a database, which is used for saving and processing data;
2) the OLAP-server system that allows to analyze these data online.
Frequently, companies use various database products of such well-known producers as Oracle, Interbase and Microsoft SQL Server. The individual solution for each crm system developer is considered to be building OLAP-applications.
As it is known, nowadays, the Microsoft SQL Server 7.0 is the most powerful server for Windows. It should be emphasized that it is the first server with an integrated OLAP-server, which supports an auto configuration. Furthermore, a lot of the present crm systems are built by the Microsoft SQL Server 7.0.
The given product has the following advantages: a symmetrical multiple-processor data processing, built-in duplication mechanisms, a close integration with the Internet and e-mail etc. In addition, the SQL Server supports auto statistics, contains a Web Assistant module, which helps to publish data (text and image formats) in the network. As to the SQL Trace utility, it allows to fix an activity of customers and show the results graphically.
The main advantage of the Microsoft SQL Server 7.0 is suggested to be its close integration with the products of Microsoft BackOffice family, which makes from the given software an ideal tool for building and administrating corporative databases. Moreover, the SQL Server takes into consideration the connection to the external data storage sources.
However, there is another powerful database server, which can be also used for developing crm systems, - Oracle8i. The given system is based on the Oracle8 server and intended for calculations and processing data over the Internet. Compared with the Microsoft SQL Server, the given system supports almost all existent operating systems (not only Windows).
Additionally, the Oracle8i supports multimedia data and OLTP. It is the only system, which includes a special set of tools for processing data over the Internet and permits to provide customers with a high degree of reliability.
Sometimes the realization of the server part for crm systems can be also performed on the basis of ASP principle. All clients of this system (including an administrator) are given the access to the application over the Internet. As usual, the firms, which present ASP services, provide customers with the certain software, hardware, network infrastructure that are necessary for applications. The given system contains a processing of results, a system integration and studying.