Abstract
In this paper, we investigate the usage of naming conventions in SQL programming. To this end, we define a reference style, consisting of naming conventions that have been proposed in the literature. Then, we perform an empirical study that involves the database schemas of 21 open source projects. In our study, we evaluate the adherence of the names that are used in the schemas to the reference style. Moreover, we study how the adherence of the names to the reference style evolves, during the lifetime of the schemas. Our study reveals that many conventions are followed in all schemas. The adherence to these conventions is typically stable, during the lifetime of the schemas. However, there are also conventions that are partially followed, or even not followed. Over time, the adherence of the schemas to these conventions may improve, decay or remain stable.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
- 2.
- 3.
Due to the lack of space we use percentages to give an overview of the results. The complete raw results that we obtained in our study can be found in www.cs.uoi.gr/~zarras/SQLNamingConventions/SQLStatisticsSLA.rar.
- 4.
- 5.
- 6.
References
Allamanis, M., Barr, E.T., Bird, C., Sutton, C.A.: Learning natural coding conventions. In: Proceedings of the 22nd ACM SIGSOFT International Symposium on Foundations of Software Engineering (FSE), pp. 281–293 (2014)
Allamanis, M., Barr, E.T., Bird, C., Sutton, C.A.: Suggesting accurate method and class names. In: Proceedings of the Joint 23rd ACM SIGSOFT Symposium on the Foundations of Software Engineering and 15th European Software Engineering Conference (FSE/ESEC), pp. 38–49 (2015)
Arnaoudova, V., Penta, M.D., Antoniol, G.: Linguistic antipatterns: what they are and how developers perceive them. Empirical Softw. Eng. 21(1), 104–158 (2016)
Avidan, E., Feitelson, D.G.: Effects of variable names on comprehension an empirical study. In: Proceedings of the 25th International Conference on Program Comprehension (ICPC), pp. 55–65 (2017)
Beniamini, G., Gingichashvili, S., Klein-Orbach, A., Feitelson, D.G.: Meaningful identifier names: the case of single-letter variables. In: Proceedings of the 25th International Conference on Program Comprehension (ICPC), pp. 45–54 (2017)
Binkley, D., Davis, M., Lawrie, D., Maletic, J.I., Morrell, C., Sharif, B.: The impact of identifier style on effort and comprehension. Empirical Softw. Eng. 18(2), 219–276 (2013)
Butler, S.: Mining Java class identifier naming conventions. In: Proceedings of the 34th IEEE-ACM-SIGSOFT International Conference on Software Engineering (ICSE), pp. 1641–1643 (2012)
Butler, S., Wermelinger, M., Yu, Y.: A survey of the forms of Java reference names. In: Proceedings of the 23rd IEEE International Conference on Program Comprehension, (ICPC), pp. 196–206 (2015)
Celko, J.: SQL Programming Style. Morgan-Kaufmann, Burlington (2005)
Hofmeister, J.C., Siegmund, J., Holt, D.V.: Shorter identifier names take longer to comprehend. Empirical Softw. Eng. 24(1), 417–443 (2019)
Holywell, S.: SQL Style Guide. www.sqlstyle.guide
Kashiwabara, Y., Onizuka, Y., Ishio, T., Hayase, Y., Yamamoto, T., Inoue, K.: Recommending verbs for rename method using association rule mining. In: Proceedings of the 21st IEEE International Conference on Software Analysis, Evolution, and Reengineering (SANER), pp. 323–327 (2014)
Lawrie, D., Morrell, C., Feild, H., Binkley, D.: What’s in a Name? A study of identifiers. In: Proceedings of the 14th IEEE International Conference on Program Comprehension (ICPC), pp. 3–12 (2006)
Martin, R.C.: Clean Code - A Handbook of Agile Software Craftsmanship. Prentice Hall, Upper Saddle River (2009)
Skoulis, I., Vassiliadis, P., Zarras, A.V.: Growing up with stability: how open-source relational databases evolve. Inf. Syst. 53, 363–385 (2015)
Swidan, A., Serebrenik, A., Hermans, F.: How do scratch programmers name variables and procedures? In: 17th IEEE International Working Conference on Source Code Analysis and Manipulation (SCAM), pp. 51–60 (2017)
Vassiliadis, P., Kolozoff, M., Zerva, M., Zarras, A.V.: Schema evolution and foreign keys: a study on usage, heartbeat of change and relationship of foreign keys to table activity. Computing 101(10), 1431–1456 (2019)
Vassiliadis, P., Zarras, A.V., Skoulis, I.: Gravitating to rigidity: patterns of schema evolution - and its absence - in the lives of tables. Inf. Syst. 63, 24–46 (2017)
Acknowledgements
We would like to thank the anonymous reviewers for their useful suggestions and comments.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2020 Springer Nature Switzerland AG
About this paper
Cite this paper
Papamichail, A., Zarras, A.V., Vassiliadis, P. (2020). Do People Use Naming Conventions in SQL Programming?. In: Chatzigeorgiou, A., et al. SOFSEM 2020: Theory and Practice of Computer Science. SOFSEM 2020. Lecture Notes in Computer Science(), vol 12011. Springer, Cham. https://doi.org/10.1007/978-3-030-38919-2_35
Download citation
DOI: https://doi.org/10.1007/978-3-030-38919-2_35
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-38918-5
Online ISBN: 978-3-030-38919-2
eBook Packages: Computer ScienceComputer Science (R0)