Advances in Engineering Innovation
Vol. 2, 07 October 2023
Open
Access | Article
Database security
* Author to whom correspondence should be addressed.
Abstract
In the modern technological tapestry, the security of database systems has burgeoned into a prominent concern for institutional frameworks. This urgency is invigorated by a dual confluence: the shifting industry paradigm which underscores the primacy of expansive data collections, coupled with the proliferation of legislative frameworks that zealously guard the sanctity of individual consumer data. The core aim of this discourse is to furnish a panoramic understanding of indispensable measures to bolster database security, with an amplified emphasis on countering SQL injection threats. The introductory segment delineates essential fortification strategies and succinctly touches upon optimal practices for shaping a database environment’s network topography and error mitigation methodologies. Subsequent to this panoramic insight, the discourse pivots to spotlight a diverse array of methodologies to discern and neutralize SQL injection forays.
Keywords
database security, SQL injection, general practices
References
1. Agrawal, R., Kiernan, J., Srikant, R., & Xu, Y. (2002). Order preserving encryption for numeric data. Proceedings of the 2002 ACM SIGMOD International Conference on Management of Data (pp. 563-574).
2. Bertino, E., Sandhu, R., & Ferrari, E. (2001). Day-to-day access control for DBMS: An ADITI experience. Computer Security Foundations Workshop, 2001. Proceedings. 14th IEEE (pp. 49-64). IEEE.
3. Codd, E. F. (1970). A relational model of data for large shared data banks. Communications of the ACM, 13(6), 377-387.
4. Date, C. J. (2004). An introduction to database systems (8th ed.). Boston, MA: Addison-Wesley.
5. Elmasri, R., & Navathe, S. B. (2011). Fundamentals of database systems (6th ed.). Boston, MA: Addison-Wesley.
6. Garcia-Molina, H., Ullman, J. D., & Widom, J. (2009). Database systems: The complete book (2nd ed.). Upper Saddle River, NJ: Prentice Hall Press.
7. Halfond, W. G., Viegas, J., & Orso, A. (2006). A classification of SQL-injection attacks and countermeasures. Proceedings of the IEEE International Symposium on Secure Software Engineering, 1, 13-15.
8. Kamra, A., Terzi, E., & Bertino, E. (2008). Detecting anomalous access patterns in relational databases. The VLDB Journal, 17(5), 1063-1077.
9. Oracle. (2013). Oracle database security guide. Redwood Shores, CA: Oracle Corporation.
10. Ramakrishnan, R., & Gehrke, J. (2003). Database management systems (3rd ed.). Boston, MA: McGraw-Hill.
11. Silberschatz, A., Korth, H. F., & Sudarshan, S. (2010). Database system concepts (6th ed.). New York, NY: McGraw-Hill.
12. Stonebraker, M., & Hellerstein, J. M. (1998). Readings in database systems (3rd ed.). Cambridge, MA: The MIT Press.
13. Valacich, J. S., Schneider, C., & Jessup, L. M. (2014). Information systems today: Managing in the digital world (7th ed.). Upper Saddle River, NJ: Pearson.
14. Widom, J., & Ceri, S. (Eds.). (1996). Active database systems: Triggers and rules for advanced database processing. San Francisco, CA: Morgan Kaufmann Publishers Inc.
15. Zaniolo, C., Ceri, S., Faloutsos, C., Ma, R. T. W., Snodgrass, R. T., & Subrahmanian, V. S. (2000). Advanced database systems. San Francisco, CA: Morgan Kaufmann Publishers Inc.
Data Availability
The datasets used and/or analyzed during the current study will be available from the authors upon reasonable request.
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Authors who publish this journal agree to the following terms:
1. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See Open Access Instruction).
- Volume Title
- ISBN (Print)
- ISBN (Online)
- Published Date
- 07 October 2023
- Series
- Advances in Engineering Innovation
- ISSN (Print)
- 2977-3903
- ISSN (Online)
- 2977-3911
- DOI
- 10.54254/2977-3903/2/2023013
- Copyright
- 07 October 2023
- Open Access
- This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution (CC BY) license, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited