Abstract
Renovating a database application is the act of significantly reprogramming the application to meet new needs, extend functionality, or re-design to foster maintainability. It can be costly to manually renovate a database application so techniques for automating the renovation are needed. Previous research in renovation has focused on methods to improve performance, such as autonomic database research to automatically tune a DBMS or manage indexes. But there has been little previous research on how to improve functionality. There are several ways in which the functionality can be improved such as interfaces to other tools (e.g., data mining with Weka), content management system integration (e.g., Wordpress plugins), an enhanced set of forms and scripts to query and manage the data, and database mediation and migration scripts. We focus on the final category in this paper: management of the data. We propose an approach, which we call DBAutoAwesome, that adopts Google’s Auto Awesome philosophy: automatically improve an existing artifact and let the user (developer) decide whether to keep and use the improved artifact. The DBAutoAwesome approach ingests a database application to produce an enhanced application. In this paper we describe how DBAutoAwesome enhances data modification and query forms.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsNotes
- 1.
Google re-branded the app as “Photo Creations” in 2015.
References
PHPMetrics MS Windows NT kernel description. http://www.phpmetrics.org/. Accessed 30 Mar 2016
SQL Server Migration Assistant. https://msdn.microsoft.com/en-us/library/mt613434.aspx
An, Y., Khare, R., Song, I.-Y., Hu, X.: Automatically mapping and integrating multiple data entry forms into a database. In: Jeusfeld, M., Delcambre, L., Ling, T.-W. (eds.) ER 2011. LNCS, vol. 6998, pp. 261–274. Springer, Heidelberg (2011). https://doi.org/10.1007/978-3-642-24606-7_20
Cedrim, D.: Context-sensitive identification of refactoring opportunities. In: Proceedings of the International Conference on Software Engineering, ICSE, pp. 827–830 (2016)
Frakes, W.B., Terry, C.: Software reuse: metrics and models. ACM Comput. Surv. 28(2), 415–435 (1996)
Goeminne, M., Decan, A., Mens, T.: Co-evolving code-related and database-related changes in a data-intensive software system. In: 2014 Software Evolution Week - IEEE Conference on Software Maintenance, Reengineering, and Reverse Engineering, CSMR-WCRE 2014, Antwerp, Belgium, 3–6 February 2014, pp. 353–357 (2014)
Gries, C., Gilbert, E., Franz, N.: Symbiota - a virtual platform for creating voucher-based biodiversity information communities. Biodivers. Data J. 2, e1114 (2014)
Ilyas, I.F., Markl, V., Haas, P.J., Brown, P.G., Aboulnaga, A.: Automatic relationship discovery in self-managing database systems. In: 1st International Conference on Autonomic Computing (ICAC 2004), New York, NY, USA, 17–19 May 2004, pp. 340–341 (2004)
Jagadish, H.V., Chapman, A., Elkiss, A., Jayapandian, M., Li, Y., Nandi, A., Yu, C.: Making database systems usable. In: Proceedings of the ACM SIGMOD International Conference on Management of Data, Beijing, China, 12–14 June 2007, pp. 13–24 (2007)
Jayapandian, M., Jagadish, H.V.: Automated creation of a forms-based database query interface. PVLDB 1(1), 695–709 (2008)
Nandi, A., Jagadish, H.V.: Assisted querying using instant-response interfaces. In: Proceedings of the ACM SIGMOD International Conference on Management of Data, Beijing, China, 12–14 June 2007, pp. 1156–1158 (2007)
Oh, J.S., Lee, S.H.: Resource selection for autonomic database tuning. In: Proceedings of the 21st International Conference on Data Engineering Workshops, ICDE 2005, 5–8 April 2005, Tokyo, Japan, p. 1218 (2005)
Sharma, T.: Identifying extract-method refactoring candidates automatically. In: Fifth Workshop on Refactoring Tools 2012, WRT 2012, Rapperswil, Switzerland, 1 June 2012, pp. 50–53 (2012)
Vial, G.: Database refactoring: lessons from the trenches. IEEE Softw. 32(6), 71–79 (2015)
Voigt, H., Kissinger, T., Lehner, W.: SMIX: self-managing indexes for dynamic workloads. In: Conference on Scientific and Statistical Database Management, SSDBM 2013, Baltimore, MD, USA, 29–31 July 2013, pp. 24:1–24:12 (2013)
Wang, G., Jia, Z., Xue, M.: Data migration model and algorithm between heterogeneous databases based on web service. JNW 9(11), 3127–3134 (2014)
Wolf, G., Kalavagattu, A., Khatri, H., Balakrishnan, R., Chokshi, B., Fan, J., Chen, Y., Kambhampati, S.: Query processing over incomplete autonomous databases: query rewriting using learned data dependencies. VLDB J. 18(5), 1167–1190 (2009)
Xin, R., Dantressangle, P., Lightstone, S., McLaren, W., Schormann, S., Schwenger, M.: MEET DB2: automated database migration evaluation. PVLDB 3(2), 1426–1434 (2010)
Zisman, A., Kramer, J.: Information discovery for interoperable autonomous database systems. Ph.D. thesis, Imperial College London, UK (1998)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer International Publishing AG, part of Springer Nature
About this paper
Cite this paper
Adams, J., Dyreson, C.E. (2018). Renovating Database Applications with DBAutoAwesome. In: Wang, J., Cong, G., Chen, J., Qi, J. (eds) Databases Theory and Applications. ADC 2018. Lecture Notes in Computer Science(), vol 10837. Springer, Cham. https://doi.org/10.1007/978-3-319-92013-9_8
Download citation
DOI: https://doi.org/10.1007/978-3-319-92013-9_8
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-92012-2
Online ISBN: 978-3-319-92013-9
eBook Packages: Computer ScienceComputer Science (R0)