SQL server in the cloud?{1}

by Dean H

Summary: SQL server is a very powerful relational database system that can provide powerful calculations. Cloud computing is the up coming new star which many companies not only use it to maintain its competition, but also rely on it to perform the business operation. Microsoft came out with the idea of combining the two together and introduced the “Cloud SQL server”. It is “a distributed storage system for web-base applications”. It is also currently being used as the storage engine for Microsoft’s Exchange Hosted Archive and SQL Azure. There are two main approaches, one is a database without key (a co-located), or the traditional way with the keys to identify the different tables. Although the cloud SQL server is already implemented, there are some drawbacks such as the Cloud SQL performance is lower than the SQL server, unable to be self-monitoring and self- managing. A big improvement would be replacing the partitioning requirement and still maintain an acceptable performance.
Response: I competed in last year’s IT competition and our topic was on Cloud computing. Personally I think it is the an inevitable trend of the future, so I am not surprised to see Microsoft introduce a “Cloud SQL Server’. It brings performance and mobility to the table, as well as an easier way to measure the cost of IT within a company. From this article I learned some technical terms that I have heard before, but not sure the actual implementation. An example would be “two phase commit”. It means “an all-or-nothing affair”, that if a series of operation bound as a transaction cannot be completed, the rollback must restore the system to the pre-transaction state, which leads the approach of a keyless data model.
Citation Bernstein, P.A.; Cseri, I.; Dani, N.; Ellis, N.; Kalhan, A.; Kakivaya, G.; Lomet, D.B.; Manne, R.; Novik, L.; Talius, T.; , “Adapting microsoft SQL server for cloud computing,” Data Engineering (ICDE), 2011 IEEE 27th International Conference on , vol., no., pp.1255-1263, 11-16 April 2011 doi: 10.1109/ICDE.2011.5767935 URL: http://0-ieeexplore.ieee.org.opac.library.csupomona.edu/stamp/stamp.jsp?tp=&arnumber=5767935&isnumber=5767827