Sunday, 22 April 2012

What is data modeling? | Oracle DBA

A data model consists of the following two components:
1. Structure — Refers to the way the system structures the data (or at least how the user thinks it is structured)
2. Operations — Refers to the facilities given to the users of the DBMS to manipulate the data within the database
Following are the operations that can be performed on the database:
i. Create tables and queries using Data Definition Language
ii.Add, sort, and calculate the data using Data Manipulation Language
iii. Retrieve the data using Data Query Language
iv. Control the access of data using Data Control Language.

No comments: