Data can be defined as a representation of fact, concept or instruction. It is suitable for communication, interpretation or process by human or electronic devices.
DATA can be divided into 2 types
Qualitative Data is provide descriptive information eg:- Name and Description
Quantitative Data is like numeric information eg:- Number
For saving the data we are using
This is the most important question that comes to our mind, the answer is below
Data indexing: – Due to data indexing mechanism data can be retrieved very fast from the database, whereas flat file this mechanism is not given.
It is a collection of programs (Software) written to manage the database. eg:- Oracle, SQL Server, My SQL, Teradata
When we are installing DBMS software then automatically someplace is created in hard disk is called database. And also a user interface automatically created to interact directly or indirectly through the application program.
Every Database having 2 types of structure
Physical Structured:- A structured which is visible on OS is called Physical Structured. This is handled by only DBA.
Logical Structured:- This is not visible in the OS. Logical Structured handled by Database Developer.
Logical Structured contain database object as tables, views, synonyms, sequence.
ANSI has established 3 levels of architecture for DBMS, this architecture is also known as ANSI/SPARC (standard planning and requirement committee).
3 level of architecture provides Data Independence.
The upper level is unaffected by changing the lower level is called data independence.
Changes in the internal level don’t require changes to the conceptual level is called Physical Data Independence.
Change in the conceptual level doesn’t require changes to the external level is called logical data independence.
It provides the logical structure of the database. The conceptual level doesn’t define how data is storing in the database. It defines what type of data is storing in the database by specifying the data type and also defines what type of data can’t be stored in the database by specifying constraints.
The external level provides a security mechanism for the database because at the external level some type of user allowed accessing portion of the data from the conceptual level.
Generally DBA creates views from the table and those views are given to the number of users to allow access portion of the data at a conceptual level.
The internal level defines how data is physically stored within the database. This level is handle by DBA only.
How the data is represented at the conceptual level defined by means of data model
There are 3 types of data models used.
In this data model data organize tree-like structure also data is represented in the format of records. Hierarchical data model parent and child record relationship define based on one to many relationships, on this relationship, many child records having one parent record. That’s why that data model produces more duplicate data because here child records are repeated.
If you want to retrieve data from Hierarchical data model product database server will very slowly retrieve data from the database.
In 1960 IBM introduce IMS (Information Management System)product based on the Hierarchical data model.
In 1970 COADASYL (Conference on data system language) committee introduces network data model. In this data model data is represented in the form of records. This model is implemented based on many to many relationships in between parent and child. Network data model reduces number of records because here child record is not repeated. In 1970 IBM introduce IDMS (Information Data Management System) product based on Network data model.
In 1970 E.F CODD introduce the Relational data model. Which are consists of a collection of 2D table.
A relational database uses this table for storing data or information. Relational Data Model mainly consists of 3 components these are.