Database selection of "large ticketing system" and "physical e-commerce system"

Discussion please move to: http://www.zhiliaotech.com/ideajam/idea/detail/423

Related articles:

Have you got the tickets today? --On the "Mass Transaction fast Processing" system of the e-commerce site from the Ministry of Railways 12306.cn site

Cannot simply apply "physical e-commerce system" to "large ticketing system" to do demand analysis

"Large ticketing system" and "physical e-commerce system" have great differences in the impact on consumers when they are unable to provide goods (services)

Differences and linkages between system boundaries of "large ticketing system" and "physical e-commerce system"

"Large ticketing system" and "physical e-commerce system" analyze various business forms according to the system boundary

Differences and linkages between "large ticketing system" and "physical e-commerce system" in payment

Difference and connection between "large ticketing system" and "physical e-commerce system" in malicious orders

Security problems of username and password in large ticketing system

Security problems introduced by the characteristics of large ticketing system

Big difference between "large ticketing system" and "physical e-commerce system" in "inventory" calculation

Differences in access management between "large ticketing system" and "physical e-commerce system"

Relationship and misunderstanding between "large ticketing system" and "physical e-commerce system" in relation to other departments of enterprises

The impact of "large ticketing system" and "physical e-commerce system" and other departments ' Dependencies on project management

The handling of machine malicious access in the "large ticketing system"--Verification code

The handling of malicious access in the "Large Ticketing system" section

Database selection (or persistent storage selection of structured data) is a problem that almost all information systems need to consider. An information system in the development process from small to large. The databases required at different stages of development are also different.

When the information system is in the smaller 0 basic stage, the database is usually chosen according to the characteristics of care.

The assumption is that CMS, Web 1.0, Web 2.0 and other applications with low quality of database services, can choose to Mariasql (MySQL was acquired, by the community development of the new version number) represented by the open source free database. The assumption is that the OA system for the database service quality requirements of the application, you need to consider the adoption of enterprise-class commercial database. Not only the database program itself can provide a richer function, can guarantee a higher quality of service. At the same time, there will be good coordination with the hardware (for example, disaster tolerance, fault tolerance).

However, enterprise-grade commercial database with the growth of the system scale, will gradually expose the shortcomings, this is not to say that enterprise-grade commercial database has any congenital defects, but with the growth of the scale, those dependent on the enterprise-class commercial database itself features, will gradually not meet the requirements, at this time need to develop their own system of corresponding functions. As more and more functions are replaced. Enterprise-grade commercial databases are only being left with purely structured data storage.

The price/performance ratio of enterprise-grade commercial database is too low at this time. When the system developed to this stage. will have to replace enterprise-grade commercial databases. Of course, this will also pay the corresponding price.

In a more detailed sense. The so-called "go to the IoE".

So for large systems, when considering what database to use, you should first consider which features are self-developed, which feature depends on the database, and then select the database according to the combination of attributes that depend on the database.

(The concept of going to the IOE is a matter of opinion, this article is only used to illustrate the issues discussed in this article, do not expand)

Contact QQ 443089607:huzhenghui
Product Manager Please add QQ Group 189763636 Group 07 period axure7pm Interaction

Database selection of "large ticketing system" and "physical e-commerce system"