DBMS (DATABASE MANAGEMENT SYSTEM)

DBMS (DATABASE MANAGEMENT SYSTEM)

1. BY JUAN SEBASTIAN RAMIREZ HERNANDEZ (CODE: 1007576037)

2. 1. DEFINITION

   • A DATABASE MANAGEMENT SYSTEM (DBMS) IS A SOFTWARE APPLICATION THAT FACILITATES THE CREATION, MAINTENANCE, AND UTILIZATION OF DATABASES. IT PROVIDES USERS WITH AN INTERFACE TO DEFINE, STORE, RETRIEVE, AND MANIPULATES DATA, WHILE ALSO ENSURING DATA INTEGRITY, SECURITY, AND EFFICIENT MANAGEMENT OF RESOURCES.

3. 2. COMPONENTS OF DBMS

   • 2.1. DATA DEFINITION LANGUAGE (DDL)
     • DDL IS A SUBSET OF SQL (STRUCTURED QUERY LANGUAGE) USED TO DEFINE THE STRUCTURE OF A DATABASE SCHEMA. IT INCLUDES COMMANDS SUCH AS CREATE, ALTER, AND DROP TO DEFINE TABLES, INDEXES, VIEWS, AND OTHER DATABASE OBJECTS. DDL STATEMENTS ARE USED TO SPECIFY THE DATA TYPES, CONSTRAINTS, AND RELATIONSHIPS AMONG DATA ELEMENTS. 2.2. DATA MANIPULATION LANGUAGE (DML)
   • 2.2. DATA MANIPULATION LANGUAGE (DML)
     • DML IS A SUBSET OF SQL USED TO MANIPULATE DATA STORED IN THE DATABASE. IT INCLUDES COMMANDS SUCH AS SELECT, INSERT, UPDATE, AND DELETE TO QUERY, ADD, MODIFY, AND REMOVE DATA FROM TABLES. DML STATEMENTS ALLOW USERS TO RETRIEVE SPECIFIC DATA, INSERT NEW RECORDS, UPDATE EXISTING RECORDS, AND DELETE UNWANTED RECORDS.
   • 2.3. DATA CONTROL LANGUAGE (DCL)
     • DCL IS A SUBSET OF SQL USED TO CONTROL ACCESS TO DATA STORED IN THE DATABASE. IT INCLUDES COMMANDS SUCH AS GRANT AND REVOKE TO GRANT OR REVOKE PERMISSIONS ON DATABASE OBJECTS. DCL STATEMENTS ALLOW DATABASE ADMINISTRATORS TO MANAGE USER PRIVILEGES AND PERMISSIONS, ENSURING DATA SECURITY AND INTEGRITY.
   • 2.4. QUERY PROCESSOR
     • THE QUERY PROCESSOR IS A COMPONENT OF THE DBMS RESPONSIBLE FOR INTERPRETING AND EXECUTING SQL QUERIES. IT INCLUDES A PARSER TO ANALYZE THE SYNTACTIC STRUCTURE OF QUERIES, AN OPTIMIZER TO GENERATE EFFICIENT EXECUTION PLANS, AND AN EXECUTOR TO EXECUTE THE PLANS AND RETRIEVE DATA FROM THE DATABASE. THE QUERY PROCESSOR PLAYS A CRUCIAL ROLE IN OPTIMIZING QUERY PERFORMANCE AND ENSURING ACCURATE AND TIMELY RETRIEVAL OF DATA.
   • 2.5. TRANSACTION MANAGER
     • THE TRANSACTION MANAGER IS RESPONSIBLE FOR ENSURING THE ACID PROPERTIES (ATOMICITY, CONSISTENCY, ISOLATION, DURABILITY) OF DATABASE TRANSACTIONS. IT COORDINATES AND MANAGES THE EXECUTION OF TRANSACTIONS, WHICH ARE UNITS OF WORK THAT CONSIST OF ONE OR MORE DATABASE OPERATIONS. THE TRANSACTION MANAGER ENSURES THAT TRANSACTIONS ARE EXECUTED RELIABLY AND CONSISTENTLY, EVEN IN THE PRESENCE OF FAILURES OR CONCURRENT ACCESS BY MULTIPLE USERS.
   • 2.6. STORAGE MANAGER
     • THE STORAGE MANAGER IS RESPONSIBLE FOR MANAGING THE STORAGE OF DATA ON DISK OR IN MEMORY. IT TRANSLATES LOGICAL DATA STRUCTURES (E.G., TABLES, INDEXES) INTO PHYSICAL STORAGE REPRESENTATIONS. THE STORAGE MANAGER HANDLES TASKS SUCH AS ALLOCATING AND DEALLOCATING STORAGE SPACE, ORGANIZING DATA FOR EFFICIENT RETRIEVAL, AND ENSURING DATA INTEGRITY AND DURABILITY.

4. 3. FUNCTIONS OF DBMS

   • 3.1. DATA DEFINITION
     • DATA DEFINITION INVOLVES DEFINING THE STRUCTURE AND ORGANIZATION OF DATA WITHIN THE DATABASE. IT INCLUDES SPECIFYING THE SCHEMA, WHICH DEFINES THE TABLES, COLUMNS, DATA TYPES, CONSTRAINTS, AND RELATIONSHIPS IN THE DATABASE. DATA DEFINITION ENSURES THAT THE DATABASE ACCURATELY REPRESENTS THE REAL-WORLD ENTITIES AND RELATIONSHIPS IT MODELS.
   • 3.2. DATA MANIPULATION
     • DATA MANIPULATION INVOLVES QUERYING, ADDING, MODIFYING, AND DELETING DATA STORED IN THE DATABASE. IT INCLUDES OPERATIONS SUCH AS SELECTING SPECIFIC DATA USING QUERIES, INSERTING NEW RECORDS INTO TABLES, UPDATING EXISTING RECORDS, AND DELETING UNWANTED RECORDS. DATA MANIPULATION ALLOWS USERS TO INTERACT WITH AND MODIFY THE DATA STORED IN THE DATABASE TO MEET THEIR INFORMATION NEEDS
   • 3.3. DATA SECURITY
     • DATA SECURITY INVOLVES PROTECTING THE CONFIDENTIALITY, INTEGRITY, AND AVAILABILITY OF DATA STORED IN THE DATABASE. IT INCLUDES MECHANISMS SUCH AS AUTHENTICATION, AUTHORIZATION, ENCRYPTION, AND ACCESS CONTROL TO PREVENT UNAUTHORIZED ACCESS, MODIFICATION, OR DISCLOSURE OF SENSITIVE DATA. DATA SECURITY MEASURES ENSURE THAT ONLY AUTHORIZED USERS CAN ACCESS AND MANIPULATE DATA, AND THAT DATA REMAINS ACCURATE AND RELIABLE
   • 3.4. CONCURRENCY CONTROL
     • CONCURRENCY CONTROL INVOLVES MANAGING MULTIPLE USERS ACCESSING AND MODIFYING DATA SIMULTANEOUSLY IN A MULTI-USER DATABASE ENVIRONMENT. IT PREVENTS CONCURRENCY-RELATED PROBLEMS SUCH AS LOST UPDATES, UNCOMMITTED DATA, AND INCONSISTENT READS BY COORDINATING THE EXECUTION OF TRANSACTIONS. CONCURRENCY CONTROL MECHANISMS, SUCH AS LOCKING AND TRANSACTION ISOLATION LEVELS, ENSURE THAT TRANSACTIONS EXECUTE SAFELY AND CONSISTENTLY IN PARALLEL
   • 3.5. BACKUP AND RECOVERY
     • BACKUP AND RECOVERY INVOLVE CREATING BACKUPS OF THE DATABASE TO PROTECT AGAINST DATA LOSS AND RESTORING THE DATABASE TO A CONSISTENT STATE IN CASE OF FAILURES. IT INCLUDES REGULAR BACKUPS OF DATABASE FILES, TRANSACTION LOGS, AND SYSTEM CONFIGURATIONS TO SECONDARY STORAGE DEVICES. BACKUP AND RECOVERY PROCEDURES ENSURE THAT DATA CAN BE RECOVERED IN THE EVENT OF HARDWARE FAILURES, SOFTWARE ERRORS, OR OTHER CATASTROPHIC EVENTS
   • 3.6. PERFORMANCE TUNING
     • PERFORMANCE TUNING INVOLVES OPTIMIZING THE PERFORMANCE OF THE DATABASE SYSTEM TO IMPROVE RESPONSIVENESS, THROUGHPUT, AND SCALABILITY. IT INCLUDES TECHNIQUES SUCH AS QUERY OPTIMIZATION, INDEXING, PARTITIONING, AND CACHING TO REDUCE QUERY EXECUTION TIMES AND RESOURCE UTILIZATION. PERFORMANCE TUNING AIMS TO MAXIMIZE THE EFFICIENCY AND EFFECTIVENESS OF THE DATABASE SYSTEM, ENHANCING USER SATISFACTION AND REDUCING OPERATIONAL COSTS.

5. 4. TYPES OF DBMS

   • 4.1. RELATIONAL DBMS (RDBMS)
     • RDBMS IS A TYPE OF DATABASE MANAGEMENT SYSTEM THAT STORES DATA IN TABLES WITH ROWS AND COLUMNS. IT ENFORCES RELATIONSHIPS BETWEEN TABLES USING PRIMARY AND FOREIGN KEYS, ENSURING DATA INTEGRITY AND CONSISTENCY. RDBMS SYSTEMS FOLLOW THE RELATIONAL MODEL AND SUPPORT SQL (STRUCTURED QUERY LANGUAGE) FOR QUERYING AND MANIPULATING DATA.
   • 4.2. NOSQL DBMS
     • NOSQL (NOT ONLY SQL) DBMS IS A TYPE OF DATABASE MANAGEMENT SYSTEM THAT SUPPORTS NON-RELATIONAL DATA MODELS. IT IS DESIGNED FOR LARGE-SCALE, DISTRIBUTED DATA STORAGE AND PROCESSING, OFFERING FLEXIBILITY, SCALABILITY, AND HIGH AVAILABILITY. NOSQL DATABASES ARE SUITABLE FOR HANDLING UNSTRUCTURED, SEMI-STRUCTURED, AND RAPIDLY CHANGING DATA TYPES, SUCH AS DOCUMENT, KEY-VALUE, GRAPH, AND COLUMN-FAMILY STORES.
   • 4.3. OBJECT-ORIENTED DBMS (OODBMS)
     • OODBMS IS A TYPE OF DATABASE MANAGEMENT SYSTEM THAT STORES DATA AS OBJECTS, ALONG WITH THEIR ATTRIBUTES AND BEHAVIORS. IT EXTENDS THE CONCEPTS OF OBJECT-ORIENTED PROGRAMMING TO DATABASE MANAGEMENT, ALLOWING FOR COMPLEX DATA STRUCTURES AND RELATIONSHIPS. OODBMS SYSTEMS PROVIDE SUPPORT FOR ENCAPSULATION, INHERITANCE, AND POLYMORPHISM, ENABLING DEVELOPERS TO MODEL REAL-WORLD ENTITIES MORE NATURALLY.
   • 4.4. NEWSQL DBMS
     • NEWSQL DBMS IS A CATEGORY OF DATABASE MANAGEMENT SYSTEMS THAT COMBINES THE SCALABILITY OF NOSQL WITH THE ACID PROPERTIES (ATOMICITY, CONSISTENCY, ISOLATION, DURABILITY) OF TRADITIONAL RDBMS. IT AIMS TO ADDRESS THE LIMITATIONS OF TRADITIONAL RDBMS SYSTEMS IN TERMS OF SCALABILITY AND PERFORMANCE WHILE MAINTAINING STRONG CONSISTENCY AND TRANSACTIONAL SUPPORT. NEWSQL DATABASES PROVIDE HORIZONTAL SCALABILITY, DISTRIBUTED ARCHITECTURE, AND SUPPORT FOR COMPLEX TRANSACTION PROCESSING, MAKING THEM SUITABLE FOR MODERN, HIGH-PERFORMANCE APPLICATIONS