Skip to main content
SpringerLink
Log in

Simplifying Data Migration from Relational Database Management System to Google App Engine Datastore

  • Conference paper
  • First Online:
Advanced Technologies, Embedded and Multimedia for Human-centric Computing

Part of the book series: Lecture Notes in Electrical Engineering ((LNEE,volume 260))

Abstract

Cloud computing has been widely introduced because of its ability to increase resource utilization. Furthermore, cloud computing offers resources as services that taken part as one of the next generation computing technologies. Before delivery application to cloud computing environment, the first step is the migration of the data. Migrating data from relational database management system (RDBMS) to Google App Engine is time-consuming problem. Hence, Google App Engine (GAE) Datastore provides NoSQL data storage with configuration file that contains table schema and CSV or XML file. This study presents the method for simplifying data migration from RDBMS to GAE including blob data migration. The proposed method leverages AppCfg to provide convenience way for data migration. As a result, user has eliminated at least 75 % task effort for data migration.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 259.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 329.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 329.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Elsenpeter R, Velte AT, Velte TJ (2010) Cloud computing—a practical approach. McGraw-Hill, USA, p 23

    Google Scholar 

  2. Ingthorsson O (2012) 5 Reasons cloud computing is key to business success. http://www.datacenterknowledge.com/archives/2012/06/25/5-reasons-cloud-computing-is-key-to-businesss-success/. Retrieved 5 Nov 2012

  3. Paul F (2012) 8 Reasons why cloud computing is even better for small businesses. http://readwrite.com/2012/04/06/8-reasons-why-cloud-computing. Retrieved 5 Nov 2012

  4. Google (2012) What is Google App Engine? https://developers.google.com/appengine/docs/whatisgoogleappengine. Retrieved 29 Dec 2012

  5. Severance C (2009) Using Google App Engine. O’Reilly Media, USA, p 14

    Google Scholar 

  6. Burrows M, Chandra T, Chang F, Dean J, Fikes A, Ghemawat S, Gruber RE, Hsieh WC, Wallach DA (2008) Bigtable: a distributed storage system for structured data. J ACM Trans Comput Syst 26(2), article no. 4, June 2008

    Google Scholar 

  7. Matthes F, Schulz C, Haller K (2011) Testing & quality assurance in data migration projects. In: 2011 27th IEEE international conference on software maintenance (ICSM), pp 438–447, Sept 2011

    Google Scholar 

  8. Kang S, Reddy ALN (2008) User-centric data migration in networked storage systems. In: IEEE international symposium on parallel and distributed processing, IPDPS 2008, pp 1–12, June 2008

    Google Scholar 

  9. IBM (2007) Best practices for data migration: methodologies for planning, designing, migrating and validating data migration. https://www-935.ibm.com/services/us/gts/pdf/softek-best-practices-data-migration.pdf. Retrieved 29 Jan 2013

  10. Wikipedia (2013) Relational database. http://en.wikipedia.org/wiki/Relational_database. Retrieved 9 Jan 2012

  11. Google (2012) Google App Engine—the platform for your next great idea

    Google Scholar 

  12. Prodan R, Sperk M, Osterman S (2012) Evaluating high-performance computing on Google App Engine. Software IEEE 29(2):52–58

    Article  Google Scholar 

  13. Google (2012) Datastore overview. https://developers.google.com/appengine/docs/python/datastore/overview. Retrieved 15 Dec 2012

  14. Elamparithi M (2010) Database migration tool (DMT)—accomplishments & future directions. In: 2010 International conference on communication and computational intelligence (INCOCCI), Dec 2010, pp 481–485

    Google Scholar 

  15. Walek B, Klimes C (2012) A methodology for data migration between different database management systems. Int J Comput Inf Eng 6:85–90

    Google Scholar 

  16. Walek B, Klimes C (2012) Data migration between document-oriented and relational databases. World Acad Sci, Eng Technol (69):894–898, Sept 2012

    Google Scholar 

  17. Shirazi MN, Kuan HC, Dolatabadi H () Design patterns to enable data portability between clouds’ databases. In: 2012 12th International conference on computational science and its applications (ICCSA), June 2012, pp 117–120

    Google Scholar 

  18. Lahman S (2012) Download Lahman’s baseball database. http://www.seanlahman.com/baseball-archive/statistics/. Retrieved 30 Dec 2012

  19. Imagenet (n.d) ImageNet. http://www.image-net.org. Retrieved 1 Jan 2012

  20. Couchbase (2012) NoSQL database technology

    Google Scholar 

  21. Google (2012) Blobstore python API overview. https://developers.google.com/appengine/docs/python/blobstore/overview. Retrieved 15 Dec 2012

  22. Dancis K (2009) AppRocket 2.0.0. http://kaspa.rs/. Retrieved 16 Dec 2012

Download references

Acknowledgments

The authors would like to thank the National Science Council of the Republic of China, Taiwan for financially/partially supporting this research under Contract No. NSC101-2221-E-143-005-, NSC101-2221-E-259-003- and NSC101-2221-E-259-005-MY2.

Author information

Authors and Affiliations

  1. Department of Computer Science and Information Engineering, National Taitung Unviersity, Taitung, Taiwan, Republic of China

    Yao-Chung Chang

  2. Department of Computer Science and Information Engineering, National Dong Hwa University, Hualien, Taiwan, Republic of China

    Ruay-Shiung Chang & Yudy Chen

Authors
  1. Yao-Chung Chang
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Ruay-Shiung Chang
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Yudy Chen
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Yao-Chung Chang .

Editor information

Editors and Affiliations

  1. ES Department, National Cheng Kung University, Tainan City, Taiwan

    Yueh-Min Huang

  2. Engineering, National Ilan University Inst. Computer Science & Information, I-Lan, Taiwan

    Han-Chieh Chao

  3. Dept of Computer Sci. and Inf. Bao-Shan Campus, National Changhua University of Education, Changhua City, Taiwan

    Der-Jiunn Deng

  4. Department of Computer Science and Engineering, Seoul University of Science & and Technology (SeoulTech), Seoul, Korea, Republic of (South Korea)

    James J. (Jong Hyuk) Park

Rights and permissions

Reprints and permissions

Copyright information

© 2014 Springer Science+Business Media Dordrecht

About this paper

Cite this paper

Chang, YC., Chang, RS., Chen, Y. (2014). Simplifying Data Migration from Relational Database Management System to Google App Engine Datastore. In: Huang, YM., Chao, HC., Deng, DJ., Park, J. (eds) Advanced Technologies, Embedded and Multimedia for Human-centric Computing. Lecture Notes in Electrical Engineering, vol 260. Springer, Dordrecht. https://doi.org/10.1007/978-94-007-7262-5_101

Download citation

  • DOI: https://doi.org/10.1007/978-94-007-7262-5_101

  • Published:

  • Publisher Name: Springer, Dordrecht

  • Print ISBN: 978-94-007-7261-8

  • Online ISBN: 978-94-007-7262-5

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation