Structured Query Language (SQL): Working, architecture of Database management system (DBMS)

Structured Query Language is abbreviated as SQL (Pronounced Sequel). It is a database sub language used mainly to manage, organize and retrieve data from a relational database. It doesn’t have statements like if, for, etc. SQL is not exactly a structured language like C or Java and consists mostly of English statements. SQL statements can be embedded to C language and other languages for providing database capabilities. SQL statements can be explicitly sent to a DBMS for processing by using call level interface from languages like Java, C, or C++. SQL statements can also be sent as messages over a computer network.

Working of SQL: Database is used to store data. This database is managed by a program known as database management system. When data has to be retrieved from a database, a SQL query as a request is sent to the DBMS (Database management system) by the user. Then, DBMS is used to process this request. After that data is retrieved from the database and sent to the user.

Working of SQL (Structured Query Language)

Architecture of DBMS: Database engine is a part of DBMS used to store, structure and retrieve data. Database engine can accept request from user application programs, interactive query systems, report writers, forms tool, and database front end. Then, it processes the requests and sends it to users and other application programs as per the requirements. Below given is the architecture of the DBMS:

Architecture of DBMS (Database management system)

Leave a Reply