dblearned

DBMS Architecture

DBMS architecture is the way in which the data in a database is viewed or represented by users. It helps you represent your data in an understandable way to the users, by hiding the complex bits that deal with the working of the system. Remember, DBMS architecture is not about how the DBMS software operates or how it processes data.

Figure 1 : DBMS-Architecture

In this…

This article is describe DBMS Architecture. Concepts of Schema and Mappings.

Source: DBMS Architecture

DBMS Architecture

DBMS architecture is the way in which the data in a database is viewed or represented by users. It helps you represent your data in an understandable way to the users, by hiding the complex bits that deal with the working of the system. Remember, DBMS architecture is not about how the DBMS software operates or how it processes data.

Figure 1 : DBMS-Architecture

In this…

DBMS Data Models

DBMS Data Models define how the logical structure of a database is modeled. Data Models are fundamental entities to introduce abstraction in a DBMS. Data models define how data is connected to each other and how they are processed and stored inside the system. A data model is a collection of concepts and rules for the description of the structure of the database which means the…

COMPONENT OF DBMS

Database management system is tools that manage organizational data. We can construct a database with logical structure and constraints. We can also manipulate the data and information, or create a simple database application or reporting tool.  Through a user interface users can perform certain kinds of task with the tool such as creating a database, converting an existing data…

DBMS USERS

DBMS users can access or retrieve data on demand using the applications and interfaces. Each type of user needs different capabilities. Depending on their expertise or mode of their interactions DBMS user are classified in the following Groups.

Application programmers:

Application programmers (Known as Specialized Users) who are responsible for developing application programs or user…

Components of Database System

Components of Database System

A database system consists of several components. Each component plays very important role in the database system environment. The major components of Database system are as follows:

Software:

The Software acts as a bridge between the user and the database. Software is a set of programs which can handle the database and controlling the database system. It interacts…

Characteristics of Database Management System

Characteristics of Database Management System

Usually, data was organized in file formats. Database management system was a new concept which overcomes the deficiencies in habitual style of data management. This article explains the basic characteristics of database management system are as follows:

Consistency− Consistency is a state where every relation in a database remains consistent. There…