Скачать или смотреть Database Management Systems (DBMS) | 4/25 | UPV

Título: Database Management Systems (DBMS)


Descripción automática: In this video, the speaker explains the role and functions of a Database Management System (DBMS). The DBMS serves as an interface between users, databases, and applications, facilitating data retrieval and management by users and administrators. It supports database creation and modeling by defining structure and enabling manipulation such as adding, deleting, or altering records and fields. The DBMS is also responsible for storage management, ensuring security, privacy, and data integrity to prevent unauthorized access and data loss or inconsistency.

The system enables data analysis through queries, sorting, filtering, and report generation. In the realm of distributed databases, the DBMS efficiently manages data across multiple machines and locations, addressing redundancy to safeguard against data loss. It handles multi-user environments, ensuring appropriate data normalization, access locks, and permissions to maintain orderly and secure data operations.

Furthermore, the DBMS caters to various types of databases, including the prevalent relational databases in the business world, object-oriented databases suited for multimedia, and hybrid databases. The video acknowledges the rise of non-relational databases, particularly for internet server logs and social media applications, where traditional tabular structures are not optimal. Nonetheless, it concludes that relational databases remain the most commonly encountered in practice.

Autor/a: Despujol Zabala Ignacio

Curso: Este vídeo es el 4/25 del curso MOOC Introduction to SQL and relational databases.    • MOOC Introduction to SQL and relational da...  
Inscríbete en: https://upvx.es/courses/course-v1:edx...


Universitat Politècnica de València UPV: https://www.upv.es
Más vídeos en:    / valenciaupv  
Accede a nuestros MOOC: https://upvx.es

#Database #management #dbms