i am using Microsoft SQL Server Management Studio. I though it was a database management system, until today I realized that the database management system is actually Microsoft SQL Server. So i would like to know what relation and differences are between Microsoft SQL Server Management Studio and Microsoft SQL Server.
I learned that Microsoft SQL Server Management Studio is a database administration tool, from https://en.wikipedia.org/wiki/SQL_Server_Management_Studio. So what are the differences and relations between database administration tool and database management system?
Does a database management system include user interface? (I know that a database administration tool does, based on my experience with Microsoft SQL Server Management Studio.)
Can I draw an analogy in programming languages?
Does a database management system act like the compiler of a programming language (here SQL language)?
Does a database administration tool act like the IDE for developing programs in a programming language?
I still can't figure that out after reading the following links.
From the second link:
A database management system (DBMS) is a computer program (or more typically, a suite of them) designed to manage a database, a large set of structured data, and run operations on the data requested by numerous users. Typical examples of DBMS use include accounting, human resources and customer support systems.
From https://en.wikipedia.org/wiki/Database_administration_and_automation#Database_administration_tools
Database administration tools
Often, the DBMS software comes with certain tools to help DBAs manage the DBMS. Such tools are called native tools. For example, Microsoft SQL Server comes with SQL Server Management Studio and Oracle has tools such as SQL*Plus and Oracle Enterprise Manager/Grid Control.
In addition, 3rd parties such as BMC, Quest Software, Embarcadero Technologies, EMS Database Management Solutions and SQL Maestro Group offer GUI tools to monitor the DBMS and help DBAs carry out certain functions inside the database more easily.
Thanks.