Skip to main content

Chapter 1 RDBMS Introduction- Technology369kk

 CHAPTER - 1 : RDBMS INTRODUCATION

RDBMS: 

A Relational Database Management System (RDBMS) is a type of database management system that stores data in a structured format using rows and columns , It is based on the relational model introduced by E.F. Codd . The software used to store, manage, query, and retrieve data stored in a relational database is called an RDBMS. 

In this post we are discuss about details on RDBMS Introduction and  Some Feature and work.  

The most common definition of an RDBMS is a product that presents a view of data as a collection of rows and columns, even if it is not based strictly upon relational theory.

Table Of Content: 

  • A relational database refers to a database that stores data in a structure format, using rows and columns.
  • This makes it easier to locate and access specific values within the database.
  • It is “relational” because the values within each table are related to each other.
  • Tables may also be related to the other tables.
  • The relational structure makes it possible to run queries across multiple tables at once.
Note If you want to only for definitions then include this definition. 
  • RDBMS stands for Relational Database Management System. It refers to a software system that allows users to create, manage, and interact with relational databases.
  • In an RDBMS, data is organized into tables consisting of rows and columns, forming a logical and structured relationship between the data. The RDBMS provides a set of tools and functionality to store, retrieve, update, and manage data efficiently.
Take care reader, don't confuse to different- different definition, make sure which is comfortable you can you mention our note or following definition. I hope this is helpful for you. 

FEATURES OF RDBMS 


Some major feature : 
  • Every piece of introduction is stores in the forms of tables.
  • Has primary keys for unique identification of rows
  • Has foreign keys to ensure data integrity
  • Provides SQL for data access
  • Uses indexes for faster data retrieval
  • Gives access privileges to ensure data security. 
The Key Feature of RDBMS : 
  • Tabular Structure: Data is organized into tables with predefined columns and rows. Each column represents a specific attribute or field, while each row represents a record or instance of data.
  • Relationships: RDBMS supports the establishment of relationships between tables using keys, such as primary keys and foreign keys. These relationships enable data integrity, referential integrity, and the ability to join multiple tables to retrieve related data.
  • SQL Interface: RDBMS utilizes Structured Query Language (SQL) as a standardized language for interacting with the database. SQL provides a set of commands and statements for creating, querying, updating, and deleting data in the database.
  • Data Integrity: RDBMS enforces data integrity by applying constraints and rules to maintain the accuracy and consistency of data. Examples of constraints include unique constraints, primary key constraints, foreign key constraints, and check constraints.
  • ACID Properties: RDBMS ensures transactional consistency and reliability through the ACID properties. ACID stands for Atomicity, Consistency, Isolation, and Durability, which guarantees that database transactions are executed reliably and accurately.
  • Concurrency Control: RDBMS includes mechanisms for handling concurrent access to the database by multiple users or processes. It manages conflicts and ensures that changes made by one user do not interfere with the work of others.
  • Scalability and Performance: RDBMS is designed to handle large amounts of data efficiently. It provides indexing mechanisms, query optimization techniques, and caching strategies to improve performance and scalability.

OPERATIONS OF RDBMS 

  • Adding new files: It means that add value in table 
  • Inserting data
  • Retrieving data : Replace data 
  • Modifying data : Name changes 
  • Removing data : Delete data for database
  • Removing files:  remove database of table

ADVANTAGE OF DBMS 

There are several advantages of using an RDBMS:

  • Simplicity: The relational database model organizes data into tables that reduce the complexity of data analysis and study. It also allows performing certain simple operations and can efficiently perform data manipulation. 
  • Ease of use: RDBMS has a user-friendly table format that makes it easy to use.
  • Network access: A software program in the RDBMS is designed specially to catch requests sent over a network, which makes it easier to access data from multiple locations. 
  • Language support: RDBMS supports SQL (Structured Query Language), which is a standard language for managing relational databases. 
  • Data integrity: RDBMS ensures data integrity by enforcing constraints such as unique, primary key, foreign key, and check constraints. 
  • Scalability: RDBMS can handle large amounts of data and can be scaled up or down depending on the size of the data set. 

DISADVANTAGE OF RDBMS 

We are also known that every topic is advantages and disadvantages , so here are some disadvantages of using an RDBMS:

  • Cost: Setting up and maintaining a database can be expensive, and the specific software needed to create and configure a relational database can be costly. 
  • Lack of speed: Compared to other types of databases, RDBMS extracts results relatively slowly, and therefore, performance is slower. 
  • Memory limitations: Relational databases have structured limits that can make it difficult to manage huge volumes of data. 
  • Complexity: RDBMSs can be complex to implement and require skilled human resources.
  • Lack of universal data model: There is no comprehensive data model for an RDBMS, which can be a drawback.

EXAMPLES OF RDBMS 

Some popular examples of RDBMS include:
  • Oracle: Oracle is one of the most popular RDBMS is used by businesses worldwide. 
  • MySQL: MySQL is an open-source RDBMS that is widely used for web applications.
  • Microsoft SQL Server: Microsoft SQL Server is a relational database management system developed by Microsoft.
  • PostgreSQL: PostgreSQL is an open-source RDBMS that is known for its scalability and reliability, this is not popular but it can be used for out big bussiness.
  • SQLite: SQLite is a lightweight RDBMS that is often used in mobile applications.
  • MariaDB: MariaDB is an open-source RDBMS that was created as a fork of MySQL. 

RDBMS VS TRADISTIONAL APPROACH

Ans: 
  • The Key difference is that RDBMS(Relational Database Management System) applications store data in a tabular form, where in traditional approach, applications store data as files.
  • There can be use , but there will be no “relational” relational the tables, like in a RDBMS in traditional approach, data is generally stored in either a hierarchical form/navigational form. This means that a single data until will have 0, 1 or more children’s nodes and 1 parent node. 

So Boddy, Today I'm Discuss about details on RDBMS Topic, I hope this is helpful for you. Let me ask if you have quiry related to this post. Thanks for come. 


NEXT CHAPTER>>>>>>>>>>  Chapter 2    ER- Diagram







Comments

Post a Comment

Popular posts from this blog

Assignment of ITA/ Information Technology and Application BCA- Technology369kk

Q1. What is  computer Explain basic computer architecture and Difference components.  2. Discuss the use of memory in computer system, Explain memory hierarchy  in details. 3. What is software? Explain difference types of software with explain. 4. Write short notes on the given:- (I) Internet. (II) LAN (Local area network ) (III) Search engine (IV) Web browser  Q 1.What is computer Explain basic computer architecture, Difference components of computer.   Computer :- Computer is defined as an electronic device that takes input data and instructions from the user and after processing them, it generates useful and desired output quickly.   A computer is designed to execute applications and provides a variety of solutions through integrated hardware and software components.                            It is fast and automatic device. It works with the help of programs and represents the d...
2 comments
Read more

C++ and Java Practical All Questions Answers - BCA -Technology369kk

C++ and Java  In this post see most important questions for practical questions given by college all questions with answers . Guys I want to say that this is only for suggested post for your practical please request to you change same alphabets, words or anything  methods name and variables name because if you write all words same then this is copy paste for another peoples.  Used Topics:  Keywords, Variables, Condition Statements, Function , Array, Structure, Pointer.                           In OOPs, Class and Objects, Constructor, Poly morph, Encapsulation, Access Specifiers,                               Inheritance etc.  So, Without Time Lose Come to the Points, let's go start Now:        *************************************************************************  C++ 12 ...
Post a Comment
Read more

Assignment of PMO (Principal of Management and Organization) - Technology369kk

 ** Assignment Of PMO ** Agenda: -  4 Questions discuss in this post. Question 1. Write a d etails note on selection why it Called. negative process.  Question 2. Write a details note on 'span of control. Question 3. Planning is an essential process, do you agree ? Discuss  Question 4. Write a note on management function. Q 1. Write a d etails note on selection why it called negative process.  Ans :-  Selection is the process of choosing the most suitable candidates out of the several candidates available.          Selection is a negative process because there may be more rejected then those selected in most of the candidates that is called selection is a negative process. → Selection process has the following steps:-  [ A .] Screening of applicants - Based on the screening of applicants only those candidates. It Called further process of selection. Who are found eligible for the job Standards of the the organization. [ B .] S...
3 comments
Read more