What is data management language?

Data control language is a subset of structured inquiry language (SQL), which is usually used to extract and control information stored in the database. While the SQL basic language is engaged in data manipulation in the database, the Control Data language deals with the granting specific permissions of end users to perform certain types of commands in the database. The data control language gives the database manipulation to manipulate and adapt the end -user privileges to promote security and maintain a check of control over information in the database.

As a SQL, the data control language is a natural language. This means that orders used in the language are trying to be as much as possible without jargon and ambiguity, and provide a more friendly environment that allow individuals who are not very technologically witty to use the database properties. In contrast to other languages ​​such as C ++, Java and Visual Basic, which use commands that are not intuitismable lay, SQL and data control language are formulled to make their command strings relatively elementary. For example, in SQL, "Select all of the employees where Plat> = 50,000" returns a list of all individuals in the "employee" database, whose salary equals or exceeds $ 50,000 in the US (USD).

Data control language is slightly different, because its goal is to manipulate permissions rather than information in the database. The two most important commands in the data control language are grant and cancellation of elements. Through these names, as their names indicate, the database administrator can provide or reject specific permissions for the end user of the database. Common permissions include the ability to connect to the database via Connect; Select rows and columns from the database via Select; Insert new information into the database of the insert tips; Update existing information in the database through the commandUpdate; Delete existing information from the database using the Delete command; or make specific commands or code in the database via Execute.

IN OTHER LANGUAGES

Was this article helpful? Thanks for the feedback Thanks for the feedback

How can we help? How can we help?