[go: up one dir, main page]
Scribd
Upload
87 views2 pages

DBMS Assignment

The document discusses 4 tools in database management: 1. Oracle RDBMS - The most popular object-relational database, supports many platforms and cloud computing. 2. MySQL - An open-source relational database used by many large companies due to its ease of use. 3. SQL Server Management Studio - Provides robust tools for accessing and managing SQL Server. 4. DevOps - Applies DevOps principles to databases by automating processes to improve productivity and reduce burnout.

Uploaded by

Adarsh The Great
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
87 views2 pages

DBMS Assignment

The document discusses 4 tools in database management: 1. Oracle RDBMS - The most popular object-relational database, supports many platforms and cloud computing. 2. MySQL - An open-source relational database used by many large companies due to its ease of use. 3. SQL Server Management Studio - Provides robust tools for accessing and managing SQL Server. 4. DevOps - Applies DevOps principles to databases by automating processes to improve productivity and reduce burnout.

Uploaded by

Adarsh The Great
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Adarsh Jha

DBMS 14/03/2022
20BCE10988

Assignment 1

Practice- activity Explorer DBMS

Question 1

Explore Different Tools in DBMS with their developing Company/


society

1) Oracle RDBMS

The Oracle database management system is the most popular object-relational database
management system. The most recent version of the utility supports numerous Windows, Linux,
and UNIX versions, as well as cloud computing. It is safe, supports huge databases, takes up less
space, and minimises the amount of time it takes for the CPU to process data.

2) MySQL

MySQL is a database management system that is quite useful. Top firms such as Google, LinkedIn,
YouTube, PayPal, and Twitter, to mention a few, use MySQL. This open-source relational database
is simple to use and comes pre-installed in a variety of popular web applications, such as
WordPress. MySQL is a fantastic choice if you just have time to learn one database because of its
popularity and ease of use.

3) SQL Server Management Studio

When it comes to database management software, SQL Server Management Studio is the best
option. It provides SQL Server access and management using a robust collection of user-friendly
graphical interfaces and a choice of script editors. It comes with an all-in-one database
performance profiling and tuning solution. Developers and database administrators of all skill levels
can utilise SSMS.

4) DevOps

DevOps is the most useful database management framework. Heavyweight processes that stifle
performance, such as manual reviews and ticketing, are well-known in the database today. In
order to boost software delivery speed and stability, DevOps ideas are applied to the database by
leveraging tools that automate these procedures. This boosts productivity while also lowering staff
burnout.
Adarsh Jha
DBMS 14/03/2022
20BCE10988

Question 2

Rank the Tools based on the Revenue and year of Birth

1. Oracle RDBMS

2. 2. MySQL

3. Server Management Studio

4. ESM Tools

Question 3

Different Between SQL & No-SQL

SQL
NoSQL

These databases have fixed or They have dynamic schema


static or predefined schema
These databases are not suited These databases are best suited
for hierarchical data storage. for hierarchical data storage.
Relational Database Non-relational or distributed
Management System (RDBMS) database system.
These databases are best suited These databases are not so good
for complex queries for complex queries

Question 4

Different Between SQL & No-SQL




MySQL is the primary database used by Facebook for storing all the social data.
Spanner is Google’s globally distributed relational database management system (RDBMS), the
successor to BigTable.

You might also like