With MySQL, you have full control of customer resource management [figure] _ MySQL-mysql tutorial

With MySQL, customer resource management is well-known [figure] MySQL is very suitable for supporting customer resource management (CRM) systems on the website. It is already an integral part of many Web sites, and its price level is also unmatched. In addition, a considerable amount of CRM data may already exist in dynamic websites.

As an SAP implementation team administrator at a telephone company, I gradually became proficient in its superior CRM toolkit. I have learned that about 90% of the jobs in CRM are system configuration implementation and maintenance to meet the changing requirements of users. A crm developer must be proficient in the process and structure design. Now let's discuss the process you need to go through when using MySQL to create an upgradeable high-performance CRM system.

Design a CRM solution for MySQL

The CRM database is very complex: Your user table is linked to your contact method table, and the latter is linked to your address and organization table, these two tables are linked to your transaction table, and this transaction table is linked to your directory table, and so on. For some relationships, you need to create complex composite indexes. For other relationships, you may only need simple indexes, or you do not need them at all. Updates and deletions in your implementation may or may not be stacked.

This means that you need to be extremely familiar with the adjustment methods available in MySQL. But before you can make adjustments, you need to design a CRM process that relies on it to take advantage of these adjustments.

Logic and data stream

As you can see in Figure A, you can use the MyISAM table as the source of the report type data. This is very useful, because when you simply query the database, the ISAM table will be a lightning fast data source. The disadvantage of ISAM is that the table file itself may crash, and updating its data can easily lead to such problems.

Figure

Data flow designed for CRM

To solve the ISAM instability, you can use the InnoDB table to add, update, and delete records in the data table. The InnoDB engine is transactional, so if the update fails, the data will be returned to the status before the change. InnoDB is more complete in reference, so that data updates do not violate any relational rules between tables.

What is not shown in the above chart is that you should back up your data at any time. In this case, the ISAM table stores valuable data. These tables are what you should back up. You can obtain the same data in the InnoDB table, but the ISAM table is more suitable for querying the backup process.

The recovery operations on InnoDB tables are also for the same reason-they are more suitable for updates (such as reference integrity, speed, stability, and so on ), and they will be automatically synchronized with any operations to be added/updated. If the InnoDB table crashes, you can use ISAM data to recreate the table, which is the best reason for splitting the process like this. After all, redundancy is equivalent to security.

Note that the line connecting table A and Table B in Figure A shows A unidirectional synchronization process. It involves locking the Report table (Table A and ISAM) and then pushing the Update table (Table B and InnoDB) back to table. This process takes place very quickly because there is no or very little data validation at this point. MyISAM is not supported in design.

Shrink the packaged CRM

Of course, not all CRM systems are designed to work with MySQL. They usually support MySQL, but they do not take advantage of its unique performance and design features. For example, SAP, PeopleSoft, and Microsoft CRM do not provide any optimized features for MySQL. This is why they are created based on the RDBMS design examples of Oracle and Microsoft.

There are still many CRM toolkits designed around the basis of LAMP (Linux/Apache/MySQL/PHP. These are usually open-source projects, and the related benefits and costs are conceivable. Since CRM almost always involves many software customization and business process analysis, it is quite happy to participate in open source code development. The design update interval provided by open source code is exactly what the system needs to synchronize with the actual operations of the enterprise, at least as much as possible.

Several CRM toolkit for MySQL
The following CRM toolkit has been optimized for use with MySQL:

Flamingo Internet Navigators OnmiStarLive Anteil
Unique design examples

If you are using MySQL to create a CRM solution, you need to effectively combine technologies with business skills. Matching the interfaces in the system with those in the real world requires an in-depth understanding of the available performance enhancement features in the unique MySQL design example. Understanding MySQL and non-transactional table types is the key to understanding this example, but key composition also plays a role in indexing and key-word synthesis.

MySQL can be used as a back-end database for commonly used large CRM toolkit, but these toolkit often cannot take advantage of MySQL's optimization features and design examples. However, many open-source tool kits do take advantage of the unique features of MySQL, or they can be adjusted at the source code level to take advantage of these features. This makes MySQL an ideal choice for your CRM project.