Database Languages

Thursday, August 14, 2008 by Ankit Goyal

Database Languages

A DBMS is a software package that carries out many different tasks including the provision of facilities to enable the user to access and modify information in the database. The database is an intermediate link between the physical database, computer and the operating system and the users. To provide the various facilities to different types of users, a DBMS normally provides one or more spe­cialized programming languages called database languages.

Database languages come in different forms. They are: -

1. Data Description Language (DDL)

2. Data Manipulation Language (DML)

Data Description Language (DDL)

As the name suggests, this language is used to define the various types of data in the database and their relationship with each other.

The basic functions performed by DDL are: -

• Create tables, files, databases and data dictionaries.

• Specify the storage structure of each table on disk.

• Integrity constraints on various tables.

• Security and authorization information of each table.

• Specify the structure of each table.

• Overall design of the Database.

Data Manipulation Language (DML)

A language that enables users to access or manipulate data (retrieve, insert, update, delete) as organized by a certain Data Model is called the Data Manipulation Language (DML). It can be of two types: -

1. Procedural DML - It describes what data is needed and how to get it. For example: - Rela­tional Algebra.

2. Non Procedural DML - It describes what data is needed without specifying how to get it. For example: - Relational calculus.

Filed under , having  

9 comments:

Pradeep said...

Best material for short study.

siree said...

please add dbms disadvantages also

Janice Rafael said...

Great tremendous things here. I am very glad to see your post. Thanks so much and i am looking ahead to touch you. Will you please drop me a mail?
Oracle Security

Clara Snyder said...
This comment has been removed by the author.
Le Mystique said...

Hi,
I am an SEO and internet marketing consultant.
My client's previous SEO consultant left a spammy comment with the alias Ratha Lanza at your blog which links to my client's site. This is causing us serious trouble with respect to SEO and the comment does not look good on your blog either.
We apologize for the inconvenience and we request you to remove that comment as well as this current one that I am making within 48 hours. If you don't do so, I will have to use Google's disavow tool to get the spammy comment along with the website link removed and, sorry to say this, but Google may not look too nicely upon you either for not having removed the comment. Thanks in advance for your cooperation.

Le Mystique said...

thanks for removing the comment I had requested you to remove. Can you please also remove the comment by Janice Rafael? As you may notice it is also linking to my client's site. I did not see it the first time I was contacting you. This is the last time I will bother you. Thank you so much.

Qadir Shaikh said...

Nice informative information blog is this......

Thanks and Regards :
Qadir Shaikh.
Visit at http://www.oratc.com

Qadir Shaikh said...

Really Amazing Sir. It is useful information for us thanks for the sharing..........

Thanks and Regards :
Mr. Qadir Shaikh.
Visit at http://www.oratc.com

Qadir Shaikh said...

Really Amazing Sir. It is useful information for us thanks for the sharing..........

Thanks and Regards :
Mr. Qadir Shaikh.
Visit at http://www.oratc.com