+1 vote
194 views
in Database Management Systems by

1 Answer

+1 vote
by
selected by (user.guest)
 
Best answer

Data manipulation is

The retrieval of information stored in the database.

The insertion of new information into the database.

The deletion of information from the database.

The modification of information stored in the database.  

A data-manipulation language (DML) is a language that enables users to access or manipulate data as organized by the appropriate data model. There are basically two types:  

Procedural DMLs require a user to specify what data are needed and how to get those data.  

Declarative DMLs (also referred to as nonprocedural DMLs) require a user to specify what data are needed without specifying how to get those data. Declarative DMLs are usually easier to learn and use than are procedural DMLs.  

However, since a user does not have to specify how to get the data, the database system has to figure out an efficient means of accessing data. The DML component of the SQL language is nonprocedural.  

A query is a statement requesting the retrieval of information. The portion of a DML that involves information retrieval is called a query language. Although technically incorrect, it is common practice to use the terms query language and data manipulation language synonymously.  

This query in the SQL language finds the name of the customer whose customer-id is 192-83-7465:  

select customer.customer-name from customer where customer.customer-id = 192-83-7465

The query specifies that those rows from the table customer where the customer-id is 192-83-7465 must be retrieved, and the customer-name attribute of these rows must be displayed.  

Queries may involve information from more than one table. For instance, the following query finds the balance of all accounts owned by the customer with customerid 192-83- 7465.  

select account.balance from depositor, account where depositor.customer-id = 192-83-7465 and depositor.account-number = account.account-number  

There are a number of database query languages in use, either commercially or experimentally.  

The levels of abstraction apply not only to defining or structuring data, but also to manipulating data. At the physical level, we must define algorithms that allow efficient access to data. At higher levels of abstraction, we emphasize ease of use. The goal is to allow humans to interact efficiently with the system. The query processor component of the database system translates DML queries into sequences of actions at the physical level of the database system.

Related questions

+1 vote
1 answer 132 views
+1 vote
1 answer 187 views
+1 vote
0 answers 16 views
+1 vote
1 answer 153 views
+1 vote
1 answer 68 views
+1 vote
1 answer 321 views
0 votes
2 answers 275 views
+2 votes
1 answer 145 views
asked Aug 14 in Database Management Systems by (user.guest)
+2 votes
1 answer 1.4k views
+1 vote
1 answer 99 views
+1 vote
1 answer 73 views
0 votes
1 answer 26 views
+1 vote
1 answer 162 views
+2 votes
1 answer 383 views
+2 votes
1 answer 485 views
0 votes
1 answer 32 views
asked 3 days ago in Computational Tools by (user.guest)
+1 vote
1 answer 81 views
0 votes
1 answer 91 views
+1 vote
1 answer 266 views
asked Jan 26, 2020 in Computer Architecture by anonymous
+1 vote
1 answer 34 views
+1 vote
1 answer 36 views
+1 vote
1 answer 36 views
+1 vote
1 answer 48 views
0 votes
1 answer 83 views
+1 vote
1 answer 42 views
0 votes
1 answer 64 views
asked Oct 25 in Database Management Systems by (user.guest)
0 votes
1 answer 83 views
asked Sep 23 in Database Management Systems by (user.guest)
+1 vote
1 answer 71 views
+1 vote
1 answer 74 views
asked Sep 23 in Database Management Systems by anonymous
+1 vote
1 answer 393 views
+1 vote
1 answer 99 views
+1 vote
1 answer 85 views
+1 vote
1 answer 212 views
+1 vote
1 answer 52 views
+1 vote
1 answer 226 views
asked Sep 22, 2020 in Database Management Systems by (user.guest)
+1 vote
1 answer 262 views
+2 votes
1 answer 936 views
+1 vote
1 answer 1.3k views
Welcome to CPENTalk.com
Solution-oriented students of computer engineering on one platform to get you that

ONE SOLUTION

...