Page 65 - CITS - Computer Software Application -TT
P. 65

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
   60   61   62   63   64   65   66   67   68   69   70