A transaction management of cloud database :proposal model

A transaction management in cloud database : proposal model Ms.Vian F. a, Dr. Ziyad Tarik Abdul Mehdi b " Foundation Department , IT Instructor of Bayan college , Muscat , Oman" " Information technology and computer science,Ass.Pro.& Hod of Mazoon college, muscat ,Oman" Abstract Cloud computing, this new technique contributed to attract many users by the services that provided to uses of the cloud. One of these services is cloud database, which means the user of the cloud can create a database through the application which cloud is provided and store it at the cloud so this database called cloud database. Now to run the data at cloud database needs to use a specific transaction management that provide data consistency because transaction management executing the ACID So to use the traditional transaction management technique in cloud case is not a proper choice because it is not simple to follow. And there is another reason is the weakness in data consistency that many web applications cannot afford it. As well the modifying of the data items that occur only in one site host (SH) , large number of aborted transaction and the longtime of execution the transaction lead to search for transaction management that solve all these issues. So the concept of the proposal model that presented through this research is to find a transaction model can be executed at base station (BS)and site host (SH), namely the proposal model can modify the data item locally and then pre-commit , when SH connects with BS these pre-committed transaction are sent to the BS and re-executed on the master data at BS as a base transaction (BT)(S ).

At SHS the transactions are pre-committed according to the availability of the data items , because each SH can obtain a specific amount of the value δi and the rest is kept at BS , this process maintain the data consistency. The modifying of the data items at SH is allowed in case ,the request transaction is within the limit of δi . If it is not SH is going to block the transaction and send it to the BS as a request transaction to executed there. The result of the implanting this proposal model is positive.