Skip to main content

RDBMS

RDBMS

This stands for relational database management systems. It is a program used to maintain a relational database and is the basis for all modern database systems such as MySQL, oracle, and Microsoft access. RDBMS uses SQL queries to access the data in the database. 


Relational databases are used to track inventories, process ecommerce transactions, manage substantial amounts of mission-critical costumer information, and more. These databases can be considered for any information need where data points relate to each other and must be managed in a secure, rules-based, consistent way. 


RDBMS vs DBMS 

Normally databases store sets of data that can be queried for use in other applications. A database Management system supports the development, administration, and use of database platforms. 

an RDBMS is a type of database management system (DBMS) that stores data in a row-based table structure which connects related data elements. An RDBMS includes functions that maintain the security, accuracy, integrity, and consistency of the data. This is different than the file storage used in a DBMS. Some other differences are 

  • Number of allowed users – DBMS can only accept one user at a time, whereas a RDBMS can operate with multiple users 

  • Support of database normalization – a DBMS cannot be normalised, but a RDBMS can be 

  • Distributed databases – RDBMS offers full support for distributed databases where a DBMS will not  

  • Hardware and software requirements – a DBMS needs less hardware and software than a RDBMS 

  • Amount of data – DBMS can only manage lesser amounts of data, but a RDBMS can handle any amount of data 

  • Database structure – in DBMS data is kept in a hierarchical form, where a RDBMS utilises a table where the headers are used as column's names, and the rows contain the corresponding values 

Comments

Post a Comment

Popular posts from this blog

Types of network adapters in virtual box

  Types of network adapters in VirtualBox In VirtualBox there’s multiple types of network adapters that can be used to configure virtual machines for different networking needs. Down below will give you a brief overview of each type. NAT (network address translation) The VM is placed behind a VirtualBox-managed router. This allows the VM to access the external network via the networks host’s IP, but the VM itself remains invisible to the outside. Its most suitable for simple internet access with minimal configuration NAT network This is like NAT, but it allows multiple VM’s to communicate with each other in the same NAT network all while sharing the host’s internet connection. Its commonly used when you want to simulate a small, isolated network of VM’s that can also access the internet. Bridged adapter This VM is connected directly to the physical network as if it is a separate device, it also receives its own IP address from the same network as the host. This is ide...
Post a Comment
Read more

Algorithms

  Algorithms Objective: Write a python script to automate the daily sending of email messages. The script should generate a daily message and send it via email. import smtplib from email.mime.multipart import MIMEMultipart from email.mime.text import MIMEText import schedule import time # Function to send email def send_email ( subject , body , to_email ):     # email credentials     sender_email = "#for security reasons this will be hidden"     sender_password = " #for security reasons this will be hidden "       # Create message     message = MIMEMultipart()     message[ "From" ] = sender_email     message[ "To" ] = to_email     message[ "Subject" ] = subject     message.attach(MIMEText(body, "plain" ))     # Connect to the SMTP server (Gmail in this case)     with smtplib.SMTP( "smtp.gmail.com" , 587 ) as server:         server....
Post a Comment
Read more

Project management methodologies

  Project management methodologies Agile This uses an iterative approach to delivering a project throughout its entire life cycle. This means that this is a very adaptable methodology and it has multiple frame works that can be used and the one that is selected depends on Size of organisation Structure of team Resource availability Stakeholder requirements Each of these frame works have their own pros and cons, which means that although it may work for one team it may not work for another team as effectively.                  Types of frame works Scrum - Scrum is an Agile framework used to manage complex projects. It involves: Roles: Product Owner: Manages the product backlog and ensures value delivery. Scrum Master: Facilitates the process and removes obstacles. Development Team: Delivers the product increment in a self-organizing manner. Artifacts: Product ...
Post a Comment
Read more