Page 65 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

11 Data Relationships: DBMS systems support the establishment and management of relationships between
different sets of data, allowing for the creation of complex data structures and efficient retrieval of related
information.

12 Performance Optimization: DBMS systems often include query optimization techniques to improve the
performance of database operations. This involves choosing the most efficient execution plans for complex
queries.
13 Data Dictionary: A data dictionary is a part of the DBMS that stores metadata, which includes information about
the structure of the database, data types, relationships, and constraints. This helps users and applications
understand the database’s schema.
Advantages of DBMS
Manages Data Redundancy: By centralizing data within a single database file, DBMS effectively controls
redundancy in recorded information.
Facilitates Data Sharing: Authorized users within an organization can seamlessly share data among multiple
individuals through the DBMS.
Simplified Maintenance: The centralized nature of the database system makes maintenance notably simpler
and more manageable.
Time Efficiency: DBMS expedites development processes and diminishes maintenance demands, leading to
time savings.
Enables Backup: Incorporating backup and recovery subsystems, DBMS automatically backs up data in the
event of hardware or software failures and facilitates data restoration as needed.
Supports Multiple User Interfaces: DBMS offers various user interfaces, including graphical user interfaces
and application program interfaces, catering to diverse user preferences.
Disadvantages of DBMS
Expense for Hardware and Software: Running DBMS software demands robust data processing capabilities
and substantial memory capacity, incurring costs for hardware upgrades.

Space Consumption: DBMS occupies considerable disk space and memory to ensure efficient operations.
Increased Complexity: Implementing a database system introduces added complexity and prerequisites.
Heightened Vulnerability to Failure: Database failures have a substantial impact, particularly in organizations
where all data resides within a single database. Incidents like power outages or database corruption could lead
to permanent data loss.
Relational Database Management System
RDBMS stands for Relational Database Management System.

RDBMS is an abbreviation for Relational Database Management Systems.
It serves as software that enables the creation, modification, and maintenance of relational databases.
A relational database is a type of system for storing and retrieving data presented in a structured table layout
composed of rows and columns.
It’s a specific component of Database Management Systems (DBMS) conceptualized by E.F. Codd in the 1970s.
The fundamental principles of relational DBMS form the basis for prominent database systems like SQL, MySQL,
and Oracle.
How it works
• Information is portrayed in the form of rows known as tuples within RDBMS.
• The prevailing choice for databases is the relational type. It comprises numerous tables, each endowed with
its unique primary key.
• The structured assembly of tables facilitates seamless data retrieval within RDBMS.

52

CITS : IT&ITES - Computer software application - Lesson 18 - 36