Understanding Database Languages
What do you know about database languages? Database language is also named as database language which in general this language will be embedded or in embbeded to other programming languages. This language is the language used by users or user when interacting or communicating with DBMS or which stands for Database Management System. There are many database applications that exist and have been circulating on the internet, both free and paid.
Some of these database applications include: My SQL, MariaDB, Microsoft SQL Server, and so forth. All database applications use a programming language called the database language. What languages are used? Some database languages are used such as SQL, QUEL, dBase, etc.
Even though they have several different database languages, all of them have the same function, which is used to interact with programs so that the program can provide or perform in accordance with what we command. As we have explained that this language will be embedded in C ++, Java, Basic, Pascal, Fortran, etc. which are usually also named as host languages or host language.
Database Language Components
Database language itself has several components that need to be known, especially for those of you who have just jumped into the world of database programming. In general, there are 3 components of database language when viewed from its function, namely:
- DDL or Data Definition Language which later plays a role in specifying data schemes.
- DML or Data Manipulation Language in charge of manipulating data.
- DCl or Data Control Language which has the task as a data controller.
1. Data Definition Language or DDL
DDL is a database language component that is used to describe or represent the overall database design that will later be specified again. With the DDL, we are able to make the program run commands in the form of creating new tables, changing tables, indexing tables, as well as determining the structure and storage of tables.
The result that will be obtained by DDL is a collection of tables that will later be saved into special file which file is named as data dictionary or data dictionary. The data dictionary itself includes both metadata and superdata which serves to describe the actual data. For example, when you type the Foxpro command, there are create courses, modify structure, modify report etc.
2. Data Manipulation Language or DML
Then what is DML? This one database language is the language used to manipulate and retrieve data contained in in databases . Manipulation of these data can be in the form below:
- Insertion or addition of data contained in files or tables contained in a database.
- Deletion of files contained in data or files in a database.  Changing data contained in a table or database file.
- Searching for data contained in a table or file in a database.
The function of this DML is to facilitate the user in accessing data as represented by the data model . There are at least two types including DML, namely procedural and non-procedural.
3. Data Control Language or DCL
As the name suggests, DCl is a database language used to control or control databases. So this section has an important role to match the needs of users with data that will be received.
Examples of Database Languages
Earlier we mentioned that there were 3 important components existing in the database language, namely DML, DCL, and also DDL. After this we also have information that is no less important about some examples of each component of the databse language.
Some examples that are included in DDL include the following:
- Create: is used to form databases, indexes, and also tables.
- Drop: command which is used to change the structure in the table.
- Alter: is used to destroy the database or database.
Some examples belonging to the Data Manipulation Language are:
- Select: the part used to retrieve data.
- Delete: is used to delete data. 19659009] Insert: is used to enter data.
- Update: is used to update or change data.
As additional information that is in the database itself there are several users or users, among others:
A program module in which provides a display or interface in the form of data storage low level that is in the database with application programs or query used by the system. The duties of the existence of this database manager are for integrity, backup and also recovery security, and also used for the needs of interaction with file managers.
Someone who has power or authority and has a role as a controller of the database. All existing systems, both programs and data will be controlled by the database administrator. Then what is its function? One of its functions is to define the storage structure and also the access mode. In addition, database administrators can also be used to modify patterns and physical organizations.
There are at least 4 types of database users that have different requirements. The first is advanced users, application programmers, end users or general users, and also special users.
Thus our explanation relates to the understanding of database languages and components, and also examples of database languages. Hope it is useful.