SQL in the cloud
Egger, Daniel · Repository for Publications and Research Data (ETH Zurich) · 2009
Today's web applications have the choice between two different and competing data storage options.On the one side there are the traditional relational database management systems, whereas on the other side there is a whole new market of different cloud storage systems emerging.The new cloud storage systems promise to provide very high availability and to be very scalable -characteristics that cannot be fulfilled by traditional RDBMS.The goal of this thesis is to combine those two areas by using a cloud storage system as the storage layer for the MySQL database.We aim at providing SQL in the cloud.By leveraging the scalability of the cloud storage system, we intend to create a highly scalable database.In order to achieve this, an efficient mapping of the internal SQL structures and indexes to the data model of the cloud storage system had to be established.The results of the benchmarks have shown that, with some exceptions, these goals have been achieved.