FUNDAMENTALS OF DATABASE SYSTEMS: CONCEPTS, ARCHITECTURE, AND USER ROLES
Abstract
Database systems constitute a fundamental component of modern information technology infrastructure. Their development has significantly contributed to the expansion of computer applications across diverse domains, including business, healthcare, education, engineering, and digital commerce. This paper examines the essential concepts underlying database systems, beginning with a definition of a database as a structured and meaningful collection of related data representing a specific segment of reality, commonly referred to as the miniworld or universe of discourse. The study further explores the functions of Database Management Systems (DBMS), emphasizing their role in defining, constructing, manipulating, securing, and maintaining databases over time. Special attention is given to the classification of database users and the distribution of responsibilities within a database environment, including database administrators, database designers, and various categories of end users. By analyzing the interaction between system architecture and user roles, the paper highlights the organizational, technical, and operational dimensions that ensure the efficiency, reliability, and sustainability of database systems in contemporary digital environments.
Keywords
Database systems; Database Management System (DBMS); data modeling; miniworld; database administrator (DBA); database design; end users; data security; information management; system architecture.
References
- Grosky, W. (1994). “Multimedia Information Systems.” IEEE Multimedia, 1(1), Spring 1994.
- Grosky, W. (1997). “Managing Multimedia Information in Database Systems.” Communications of the ACM (CACM), 40(12), December 1997.
- Grosky, W., Jain, R., & Mehrotra, R. (Eds.). (1997). The Handbook of Multimedia Information Management. Prentice-Hall PTR.
- Gruber, T. (1995). “Toward Principles for the Design of Ontologies Used for Knowledge Sharing.” International Journal of Human-Computer Studies, 43(5–6), November/December 1995, 907–928.
- Guttman, A. (1984). “R-Trees: A Dynamic Index Structure for Spatial Searching.” In Proceedings of SIGMOD 1984.
- Gwayer, M. (1996). Oracle Designer/2000 Web Server Generator Technical Overview (Version 1.3.2). Technical Report, Oracle Corporation, September 1996.
- Gyssens, M., Paredaens, J., & Van Gucht, D. (1990). “A Graph-Oriented Object Model for Database End-User Interfaces.” In Proceedings of SIGMOD 1990.
- Haas, P., & Swami, A. (1995). “Sampling-Based Selectivity Estimation for Joins Using Augmented Frequent Value Statistics.” In Proceedings of ICDE 1995.
- Falcone, S., & Paton, N. (1997). “Deductive Object-Oriented Database Systems: A Survey.” In Proceedings of the 3rd International Workshop on Rules in Database Systems (RIDS ’97), Skövde, Sweden, June 1997.