Social Icons

Monday, January 23, 2023

DBMS database

What is DBMS ?

A DBMS (Database Management System) is a software system that is used to manage and organize data stored in a database. It provides an interface for users and applications to interact with the data in a structured and organized way. The main function of a DBMS is to provide a way to store and retrieve data in an efficient and secure manner. A DBMS is typically made up of several components, including a data dictionary, which stores metadata about the data; a query optimizer, which determines the most efficient way to execute a query; and a storage manager, which manages the physical storage of the data on disk. Additionally, DBMSs often provide security features such as user authentication and access control to ensure that only authorized users can access the data. DBMS can be further classified into different types, such as relational, hierarchical, and object-oriented, based on their data model and the way they store and organize data. Relational DBMS, the most widely used type, stores data in tables that are related to one another through a common key. Hierarchical DBMS, on the other hand, stores data in a tree-like structure, with each record having one parent and multiple children. Object-oriented DBMSs store data in objects, which are instances of a class. DBMS are widely used in various industries, such as finance, healthcare, retail, and government, for managing and storing large amounts of structured and unstructured data. Examples of popular DBMS include MySQL, Oracle, Microsoft SQL Server, and PostgreSQL.

List of most common used DBMS

Here is a list of some of the most commonly used DBMS:
  1. MySQL: an open-source relational DBMS that is widely used for web-based applications and data warehousing.
  2. Oracle: a popular enterprise-level relational DBMS that is known for its scalability and high performance.
  3. Microsoft SQL Server: a relational DBMS developed by Microsoft that is widely used in business and enterprise environments.
  4. PostgreSQL: an open-source relational DBMS that is known for its reliability and robustness.
  5. MongoDB: a document-oriented NoSQL DBMS that is widely used for storing unstructured data and for web and mobile applications.
  6. SQLite: an embedded, file-based relational DBMS that is commonly used for small to medium-sized applications.
  7. Cassandra: a wide-column NoSQL DBMS that is known for its scalability and high availability.
  8. Redis: an in-memory key-value store that is commonly used for caching and real-time data processing.
It is worth noting that this list is not exhaustive and that there are many other DBMSs available, each with its own unique set of features and capabilities. The choice of DBMS depends on the specific requirements of the application and the type of data that needs to be stored and managed.  

Younes Derfoufi CRMEF OUJDA

Younes Derfoufi

No comments:

Post a Comment

Learn Python For Beginners

Category Of Mobile Courses

Actualités (644) Adsense (1) Affiliation (1) Algebraic Topology (2) Algorithmic (1) all-news (30) Android (5) Android App (8) Android app without code (4) Android Apps (256) Android Development (4) Android download (2) Android OS (3) AngularJS (1) Automata theory and formal language (5) Bootstrap CSS (1) C programming (5) Category and Functor (8) CMS (3) Computer Glossary (29) Create Mobile App With Ionic Framework (2) CSS (2) CSS-Cascading-Style-Sheets (4) Developpement Java (13) Differential Geometry (1) Django-Python-Framework (15) dropshiping (26) Earn Money by Internet (4) Emplois (23) Framework php (2) Fraud (2) Github (2) HTML (9) IT News (3) Java For Beginners (10) Javascript (12) Kotlin Programming Language (8) Kotlin For Mobile Android (1) Linux Download (2) Marketing (5) Mobile (3) Mobile Courses (4) Mobile Marketing (4) MoneyGram (1) News (721) Node.js (5) Open Source (1) Photoshop (1) Protect Computer (1) Python (37) Python BeautifulSoup (1) Python For Data Science (2) Python PyQt (14) Python Reference (1) Python Source Code (19) Python-Books (6) Python-DVD-Training (1) Python-Exercises (313) Python-Framework (1) Python-IDE (1) Python-Kivy-Framework (2) Python-Modules (1) Python-pdf (2) Python-pyQt (1) python-temp (3) Référencement (2) Script PHP (2) Security (6) SEO (1) Snipping Tool: Faq (1) Social Networks (1) Source Code (4) Statistics With SPSS (2) Surveillance Software (1) Travail à domicile (6) Tutoriels php en vidéos (2) Tutoriels-MySql (6) tutoriels-php (19) Utilitaires (1) VPS (1) Web Hosting (1) Webcam (1) Webmarketing (11) Western Union (1) Windows 10 (1) Windows 7 (4) Windows 7 Faq (2) Windows 8 (1) Windows Accessories (1) Windows Download (8) Windows Drivers (1) Windows Fonts (1) Windows Power Shell (2) Windows Registry (2) Windows Security (18) Windows Software (2) Windows Spyware (2) Windows utilities (3) Windows Virus (2) Windows Vista (3) Windows Wireless (1) Windows xp (1) Wordpress (1)

Sample text

Sample Text

Blogger Templates