Database Management
Database Management and Information Technology
Databases
are used to store and organize mass amounts of data, allowing administrators
and stakeholders convenient access to the data that is needed to conduct
business operations and drive business decisions. Database management refers to
the act of managing the data and data storage applications for a company,
individual, or organization (Mullins, 2023). This course covers the
fundamentals of information technology, including computer applications such as
database management systems (Vahid & Lysecky, 2019). These systems
essentially connect the dots between data and technology, facilitating the flow
of information within the technological landscape.
A Brief History
While
the first computer was developed in the early 1900s, their popularity amongst
businesses and individuals did not rise significantly until the 1980s (Vahid
& Lysecky, 2019). The first computer systems were enormous, and expensive,
and were primarily used for specialized calculations within the military.
Derived from the concept of telephone switches, computers are built from
connected switches that are represented as bits (0s and 1s). All information
stored and displayed by computers is represented using bits.
Database management relates to
several pivotal concepts within the realm of information technology such as
software development, application architecture, cybersecurity, and programming
languages. Database management intersects with software engineering principles,
as databases are integral components of most software applications.
Additionally, database security protocols play a critical role in safeguarding
sensitive information, aligning with cybersecurity best practices. Furthermore,
proficiency in programming languages is required for database administrators to
develop custom scripts and queries for optimizing database performance and
functionality.
Hardware
Database management relies on the
major hardware components of a modern computer system to store, retrieve, and
present data to its users. For example, the computer monitor displays the DBMS
application and user interface while the keyboard and mouse allow users and
administrators to navigate the database, execute queries, run reports, and
optimize the system. Industrial-use database systems are often housed pm high-end
servers or computers with significant memory configurations. Within these
devices, CPUs facilitate application functions such as data manipulation,
storage devices hold massive amounts of data for permanent storage, and random-access
memory (RAM) temporarily stores data for speedy retrieval. Efficient database
management hinges significantly on the hardware capabilities and configurations
of the overall system (Mendes et al., 2023).
Software
Database management relies on dedicated database management applications like MySQL or Oracle. These applications, stored as executable files on computers, facilitate tasks such as data development or importation. They offer users tools to navigate databases, execute queries, generate reports, and handle other management functions. Essentially, database management application software serves as the intermediary between users and the database system, enabling efficient and user-friendly interaction with the stored data.
Programming Languages
Database
management requires the use of programming languages for storing, processing,
and presenting information. SQL (Structured Query Language) is the most common database
programming language and enables data insertion, deletion, retrieval, and
modification. Program execution methods such as debugging, and triggers
automate relevant processes to facilitate efficient and consistent operations. These
languages and methods allow users to interact with and manage data effectively
within a database environment.
Fundamental Concepts
The fundamental concepts of
databases encompass various essential components and principles. Firstly, the
database environment refers to the infrastructure and settings where the
database operates, including hardware, software, and network configurations
(Geeks for Geeks, 2024). Schemas define the structure and organization of data
within the database. Data integrity ensures the accuracy, consistency, and
reliability of data stored in the database. Queries are commands or
instructions used to retrieve specific information from the database. Lastly,
data manipulation involves operations such as insertion, deletion, and
modification of data within the database. Together, these concepts form the
foundation of database management and operation.
Network
The
basic concepts of network architecture, management, and security have an
important influence on database management. Firstly, the layout of the network
architecture influences how data flows from the server to client devices,
directly affecting database management and performance. Secondly, network
management influences database management by ensuring connectivity and access
to database resources. Finally, secure network protocols allow for safe
transmission of data between servers and clients, preventing malicious
interception and data manipulation.
References
Mendes, F. C., Sarna, P., Emelyanov, P., Dunlop, C. (2023). Database internals: Hardware and operating system interactions. In: Database Performance at Scale. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-9711-7_3
Mullins, C. S. (2023, November). Database management system (DBMS). TechTarget. https://www.techtarget.com/searchdatamanagement/definition/database-management-system#:~:text=The%20first%20DBMS%20was%20developed,by%20many%20large%20organizations%20today.
Vahid, F., & Lysecky, S. (2019). Computing technology for all. zyBooks.
Comments
Post a Comment