Discussion of transaction realization under PHP and MySQL platform
Zhao Xin-ping
Abstract
Zhao Xin-ping
Abstract
The methods and steps of transaction realization were summed up according to MySQL tables with different types of storage engine.By analyzing the characteristics of the MyISAM and InnoDB storage engine,the transaction realization steps based on two tables ensuring data consistency were given.Transaction application and main type of operation should be considered in database design,using different storage engine and a different approach to transaction realization according to the decision which storage engine to be used.
A significance statement is not available in the OpenAlex record.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
The methods and steps of transaction realization were summed up according to MySQL tables with different types of storage engine.By analyzing the characteristics of the MyISAM and InnoDB storage engine,the transaction realization steps based on two tables ensuring data consistency were given.Transaction application and main type of operation should be considered in database design,using different storage engine and a different approach to transaction realization according to the decision which storage engine to be used.
Key concepts: Realization (probability), Database, Database transaction, Computer science, Transaction processing system, Consistency (knowledge bases), Nested transaction, Data consistency