Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 33 views

    DBMS Assignment

    Uploaded by

    Adarsh The Great
    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.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    DBMS Assignment

    Uploaded by

    Adarsh The Great
    33 views2 pages
    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.

    Original Title

    DBMS-Assignment

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    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.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    33 views2 pages

    DBMS Assignment

    Uploaded by

    Adarsh The Great
    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.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 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