CAJ | 학술논문

针对MySQL数据库不同类型存储引擎的数据表,总结出事务实现的方法及步骤.通过分析MyISAM与InnoDB存储引擎的特点,给出两个数据表为保证数据一致性在两种存储引擎环境下的事务实现方式.设计数据库表时应考虑是否会涉及事务应用以及基于该表的主要操作类型,根据情况决定采用MyISAM或InnoDB存储引擎,再根据不同存储引擎采用不同的方法实现事务.
침대MySQL수거고불동류형존저인경적수거표,총결출사무실현적방법급보취.통과분석MyISAM여InnoDB존저인경적특점,급출량개수거표위보증수거일치성재량충존저인경배경하적사무실현방식.설계수거고표시응고필시부회섭급사무응용이급기우해표적주요조작류형,근거정황결정채용MyISAM혹InnoDB존저인경,재근거불동존저인경채용불동적방법실현사무.
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.