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
  Designing a SOHO network with DHCP Network requirements for the office Sales department – 4 computers Finance department – 3 computers Networking devices requirement: ·          1 router ·          2 switches (one for each department) ·          1 DHCP server Documentation I started by setting up the network topology and used the automatic connecting cable to connect all the devices together. Then I configured the server with IPv4 address and a subnet mask. to do this you have to press on the server and then go to desktop. Then I filled in all the parameters as seen below. Then I had to configure the DHCP server. To do this I clicked on the server > services > DHCP. Then I turned on the serves and configured the server as seen in this screenshot. For the next step I configured the router with the IPv4 address and subnet mask. To a...
Post a Comment
Read more

What's the difference between JIRA, MS project and Trello

  What's the difference between JIRA, MS project and Trello Jira, Microsoft Project, and Trello are all project management tools, but they have different features, functionalities, and target audiences. Here's a comparison of the key differences between them:   Target Audience and Use Cases: Jira: Primarily used by software development teams and Agile practitioners. It offers extensive features for issue tracking, bug tracking, project management, and Agile methodologies such as Scrum and Kanban. Microsoft Project: Suited for traditional project management, especially for complex projects in various industries. It provides tools for project planning, scheduling, resource management, and reporting. Trello: Designed for teams and individuals looking for a simple, visual way to manage tasks and projects. It uses boards, lists, and cards to organize and prioritize work, making it ideal for small to medium-sized teams and projects.   Features and Functionality: Jira: Offers ro...
Post a Comment
Read more