The research of optimizing database system has been an
ongoing process where Database Management Systems
(DBMS) have been evolving rapidly. Today, algorithms and
data are being unified by integrating programming languages
with database systems [3]. The motivation for us to optimize
database systems for the business process is indeed important
in a world where database technology is constantly improving.
Also, as lifestyles are becoming fast paced, a slow and
inefficient database applications are be deemed unacceptable.
One of key challenges and motivations is to integrate
programming languages together with databases. In addition,
researches and studies on optimization of database with large
record sets and workload are certainly a study of interest. Such
applications include monitoring of health monitoring services
[1]. Therefore, it is important that a database system is
designed to be properly planned
Therefore, transactional tables offer such feature of ensuring
transactions is “safe” and completed. However, transactional
tables come at the cost of the efficiency. An example of
transactional tables is InnoDB.