Cloud Database Management System

Cloud Database Management System

IS508E group NO.6 project

Group NO.6 members:

PENG Yu

KALAI Kumaraguru

KUTTIKKAT VENUGOPAL Sreehari

Contents

General business case ............................................................................................................... 1 Introduction and problems ....................................................................................................... 1 The existing technology ............................................................................................................ 2 Challenges of Implementation: ................................................................................................. 9 Reference: ............................................................................................................................... 10

1

General business case

Thanks to the successful management, the business of the company expands very fast. However, the database management system cannot withstand the quickly and greatly increased work load, the break-down frequency increases, which make the decision-making efficiency and customer experience drop. The company tries to turn around this bad trend and poses two solutions: one is to update the present DBMS including hardware, software and human resource; the other one is to make use of SQL Azure from Microsoft to set up cloud environment and transfer the DBMS there. After cost analysis, we find that to reach the same efficiency standard, the cost of first solution is 9 times of the second solution, and the second solution has merits such as capability, flexibility and elasticity, so we suggest implementing the second solution: Cloud DBMS, SQL Azure.

Introduction and problems

We are an express company in North America. We transport the parcels for customers. We have good performance and with the blooming online shopping, our business expands very fast. Recently, a large online retailer just outsources its express service to us. Our daily express order increases by 2 times more than before. Our IT department, where there are three employees. They are in charge of maintaining the database management system (DBMS) and the website providing order reacceptance and parcel tracing service. Because of the expansion of business and the outsourcing contract, the requests for placing orders and tracing parcels on the website soar 4 times than before. The present web server cannot support such huge data stream, sometimes it crashes, and this influences the clients experience and the business terribly. In front of these greatly increased clients, parcels and tracking information needs, our present database management system is not responsive and powerful enough to meet the searching, ordering, processing and indexing requirement.

Now there are two solutions to these problems. One solution is to buy software, update the hardware and recruit more employers to strengthen the present DBMS; however, this is another problem brought by this solution. The online shopping is seasonal fluctuating, which means that in official holidays, such as the national day, thanks giving day, charismas day, New Year day and so on, the online shopping activities are much more intensive than usual. Correspondently, the express orders and requests for parcel tracing also rise greatly. Here is the problem, how should we equip the present database management system, to meet the peak amount of requests or to meet the usual amount of requests. If we choose to meet the peak amount of requests, the investment will sure much bigger than that of meeting the normal amount of requests, and when the holiday passes, the capacity of system will

2

be left unused, this is a waste of resources and investment; if we choose to meet the usual amount of requests, the limited capacity of system during the holidays will cause bad customer experience, which will bring the loss of orders and clients, moreover, the profit of the orders in holidays takes big proportion of the annual profit, and this makes the result worse.

The other solution is to make use of the cloud computing technology, which means to set up DBMS on the cloud computing platform, and move all the present data to cloud DBMS. The cloud DBMS service is scalable and flexible, it can adjust the capability according to our needs, and then we do not have to face the dilemma system configuration problems.

After talking with