Enhancing Performance of Partitioned Database in Cloud Computing Environment


(*) Corresponding author


Authors' affiliations


DOI's assignment:
the author of the article can submit here a request for assignment of a DOI number to this resource!
Cost of the service: euros 10,00 (for a DOI)

Abstract


Cloud computing is a revolutionary technology which has taken more concern than any other before, especially by large companies, huge online services and every compute-data intensive application; not only because it is new, but cloud computing has moved distributed systems from side to another. This paper describes the design and architecture of our self-stabilization cloud DBMS based on an in-depth benchmark model with focusing on read operations. On the contrast of map-Reduce, which is a powerful traditional distributed system working on a dedicated cluster and uses key-value data store with a low-level query language, our architecture benefits from great cloud characteristics, certainly automatic resource provisioning to scale virtual cluster up or down with an easy and straight way, and from a long-term evolution of RDBMS and their indexes including b-tree, hash and also full text to retrieve data; in addition, the  SQL is a standard query language. Our system uses a dedicated benchmark server which we have developed to benchmark virtual nodes used in the system to give the broker, the stabilizer in the system, a benchmark matrix containing number of queries, distributed over data object stairs and time stairs, per time cycle, besides a decision tree, so the broker can build up access pattern matrix such the benchmark matrix, but with using a decision tree to estimate query time stair; depending on the two matrices, The broker stabilizes the system by migrating and replicating data objects, while allocating or releasing nodes
Copyright © 2014 Praise Worthy Prize - All rights reserved.

Keywords


Cloud Computing; RDBMS; Distributed System; Database Benchmark; Self-Stabilization; Autonomic Computing

Full Text:

PDF


References


B.Furht and A. Escalante, Eds., Handbook of Cloud Computing (Springer, 2010).

M. Cordero, L. Correia, H. Lin, V. Thatikonda, R. Xavier and S. Vetter, IBM PowerVM Virtualization Introduction and Configuration (IBM Redbooks publication, 2013).

"Twitter HomePage," [Online]. Available: http://twitter.com/. [Accessed 5 2013].

R. Buyya, J. Broberg and A. Goscinski, Eds., Cloud Computing Principles and Paradigms (Wiley, 2011).

F. Marozzo, D. Talia and P. Trunfio, P2P-MapReduce: Parallel data processing in dynamic Cloud environments, Journal of Computer and System Sciences, Vol. 78, n. 5, pp. 1382–1402, 2012.

"More patent nonsense — Google MapReduce," 11 2 2010. [Online]. Available: http://www.dbms2.com/2010/02/11/google-mapreduce-patent/. [Accessed 8 9 2013].

Pavlo, E. Paulson, A. Rasin, D. J. Abadi, D. J. DeWitt, S. Madden and M. Stonebraker, A comparison of approaches to large-scale data analysis, Proceedings of the 35th SIGMOD international conference on Management of data (Page: 165 Year of Publication: 2009 ISBN: 978-1-60558-551-2 ).

Luo, T., Yuan, W., Deng, P., Zhang, Y., Chen, G., A hybrid system of Hadoop and DBMS for earthquake precursor application, (2013) International Review on Computers and Software (IRECOS), 8 (2), pp. 463-467.

D. Kshemkalyani and M. Singhal, Distributed Computing Principles Algorithms and Systems (New York: Cambridge University Press, 2008).

J. O Kephart and D. M Chess, The vision of autonomic computing, Computer, Vol. 36, n. 1, pp. 41-50, 2003.

"TPC-C HomePage," [Online]. Available: http://www.tpc.org/tpcc/. [Accessed 4 2013].

wikipedia, "Interquartile Range," [Online]. Available: http://en.wikipedia.org/wiki/Interquartile_range. [Accessed 2 5 2013].

"PostgreSQL 9.2.5 Documentation," The PostgreSQL Global Development Group, [Online]. Available: http://www.postgresql.org/. [Accessed 7 2013].

C. Gupta, A. Mehta and U. Dayal, PQR: Predicting Query Execution Times for Autonomous Workload Management, ICAC '08 Proceedings of the 2008 International Conference on Autonomic Computing (Page: 13 Year of Publication: 2008 ISBN: 978-0-7695-3175-5).

M. Tamer Özsu and P. Valduriez, Principles of Distributed Database Systems, 3rd ed. (London: Springer, 2011).

A. Silberschatz, H. F. Korth and S. Sudarshan, Database System Concepts, 6th ed. (New York: McGraw-Hill, 2011).

G. Coulouris, J. Dollimore, T. Kindberg and G. Blair, Distributed Systems Concepts and Design, 5th ed. (Addison-Wesley, 2012).

D. GOTTFRID, "Self-Service, Prorated Supercomputing Fun!," 1 11 2007. [Online]. Available: http://open.blogs.nytimes.com/2007/11/01/self-service-prorated-super-computing-fun/. [Accessed 7 2013].

"Rapid Provisioning of Virtual Machines Using SAN Copy Overview," [Online]. Available: http://technet.microsoft.com/en-us/library/gg610594.aspx. [Accessed 8 2013].

"IBM SmartCloud Provisioning," [Online]. Available: www.ibm.com/software/tivoli/products/smartcloud-provisioning [Accessed 8 2013].

"Rapid Provisioning," [Online]. Available: http://cloudpatterns.org/design_patterns/rapid_provisioning.

S. Madden, E. Wu, S. Madden, Y. Zhang, E. Jones and C. Curino, "Relational Cloud: The Case for a Database Service," 2010.

M. Brantner, Building a database on S3, ACM SIGMOD international conference on Management of data (Page: 251 Year of Publication: 2008 ISBN: 978-1-60558-102-6).

T.White, Hadoop: The Definitive Guide, 3rd ed. (O'Reilly Media Yahoo Press, 2012).

Amazon, "Amazon SimpleDB," [Online]. Available: http://aws.amazon.com/simpledb/. [Accessed 7 2013].

F. Chang, J. Dean, S. Ghemawat, W. C. Hsieh, D. A. Wallach, M. Burrows, T. Chandra, A. Fikes and R. E. Gruber, Bigtable: A Distributed Storage System for Structured Data, ACM Transactions on Computer Systems, Vol. 26, n. 2, pp. 1382–1402, 2008.

D. E. M. Arnaut, R. Schroeder and C. S. Hara, Phoenix: A Relational Storage Component for the Cloud, Cloud Computing (CLOUD), 2011 IEEE International Conference (Page: 684 Year of Publication: 2011 ISBN: 978-0-7695-4460-1).

"Amazon cloud database," [Online]. Available: http://aws.amazon.com/rds/. [Accessed 7 2013].

"Amazon Cloud Watch," [Online]. Available: http://aws.amazon.com/cloudwatch/. [Accessed 5 2013].

P. Xiong, Y. Chi, S. Zhu, H. Jin Moon, C. Pu and H. Hacigümüs, Intelligent management of virtualized resources for database systems in cloud environment, Data Engineering (ICDE), 2011 IEEE 27th International Conference (Page: 87 Year of Publication: 2011 ISBN: 978-1-4244-8958-9).

Jena, R.K., Mahanti, P.K., Computing in the cloud: Concept and trends, (2011) International Review on Computers and Software (IRECOS), 6 (1), pp. 1-10.

Jena, R.K., Green cloud computing: Need of the hour, (2012) International Review on Computers and Software (IRECOS), 7 (1), pp. 45-52.

Xiao, P., Yan, G., Liu, D., Qu, X., A reliable-enhanced cloud storage framework for mobile computing environments, (2012) International Review on Computers and Software (IRECOS), 7 (2), pp. 586-592.


Refbacks

  • There are currently no refbacks.


Please send any question about this web site to info@praiseworthyprize.com
Copyright © 2005-2024 Praise Worthy Prize