DATABASE ENVIRONMENT

Database Environment :

Introduction:

Database is used to store, manipulate and retrieve data in every type of organization like Business, Healthcare, Education, Govt and Libraries. Database technology is used by Individuals like Personal Computers, or by working groups Like Department wise, and Enterprise wise and Distributed wise.

Many organizations are today building separate database these databases are called data warehouses   . By using database we can develop relational database management, Online management System, and Employee Relationship management system. Etc.

By using database we can create or develop , retrieve and maintenance an organization data conveniently and successfully.

Data is a collection of raw facts . These facts may be in text, symbols, sounds, graphysics etc. data is the real thing of  database of an organization.

Eg. ABC group of institutions. Hyderabad.

Characteristics of DBMS:

DBMS is a mechanism to manage the designed database i.e. to create the data , insert the data, to update the data, and to delete the data in and from the database.

DBMS represents complex relationships between the data or information.

DBMS has a centralized data dictionary to store  metadata .

DBMS keeps data control and redundancy i.e. avoid duplicate data.

DBMS has automatic intelligent backup and recovery procedures for its units.

DBMS provide different user interfaces to manipulate the data in the database.

Data Independency is a process the separation of data description from metadata  i.e. in an organization data not depends on metadata. Each database should have database applications i.e. A large program  or set of programs to perform a specified action is a n application .In database by using application we can  read, write, update and delete of database information . An application which is used to perform database operations like read, write, update and delete is known as database application. When we develop our own database we should consider the legacy system or data. Legacy data means  any data which is installed before developing our own database in the system is known as Legacy data. It contained by the system which is used prior to the installation of the system. When we develop a personnel database we should follow the database constraint. Constraint means when we develop our own database we should follow certain rules and conditions these rules and conditions are known as constrains.