Data base management system (DBMS) data ko reduce karke rakhne ke tarike hote hain.
Types of DBMS Architecture
लिंक पाएं
Facebook
X
Pinterest
ईमेल
दूसरे ऐप
-
Types of DBMS Architecture
Database architecture can be seen as a single tier or multi-tier. But logically, database architecture is of two types like: 2-tier architecture and 3-tier architecture.
In this architecture, the database is directly available to the user. It means the user can directly sit on the DBMS and uses it. Any changes done here will directly be done on the database itself. It doesn't provide a handy tool for end users. The 1-Tier architecture is used for development of the local application, where programmers can directly communicate with the database for the quick response.
Database languages are special-purpose languages, which allow one or more of the following tasks, sometimes distinguished as sublanguages : Data control language (DCL) – controls access to data; Data definition language (DDL) – defines data types such as creating, altering, or dropping and the relationships among them; Data manipulation language (DML) – performs tasks such as inserting, updating, or deleting data occurrences; Data query language (DQL) – allows searching for information and computing derived information.
टिप्पणियाँ
एक टिप्पणी भेजें