Characteristics of DBMS

-
  • It uses a digital repository established on a server to store and manage the information.
  • It can provide a clear and logical view of the process that manipulates data.
  • DBMS contains automatic backup and recovery procedures.
  • It contains ACID properties which maintain data in a healthy state in case of failure.
  • It can reduce the complex relationship between data.
  • It is used to support manipulation and processing of data.
  • It is used to provide security of data.
  • It can view the database from different viewpoints according to the requirements of the user.

टिप्पणियाँ

एक टिप्पणी भेजें

इस ब्लॉग से लोकप्रिय पोस्ट

2-Tier Architecture

-
चित्र
The 2-Tier architecture is same as basic client-server. In the two-tier architecture, applications on the client end can directly communicate with the database at the server side. For this interaction, API's like:  ODBC ,  JDBC  are used. The user interfaces and application programs are run on the client-side. The server side is responsible to provide the functionalities like: query processing and transaction management. To communicate with the DBMS, client-side application establishes a connection with the server side. Fig: 2-tier Architecture
और पढ़ें

Terminology and overview

-
Formally, a "database" refers to a set of related data and the way it is organized. Access to this data is usually provided by a "database management system" (DBMS) consisting of an integrated set of computer software that allows  users  to interact with one or more databases and provides access to all of the data contained in the database (although restrictions may exist that limit access to particular data). The DBMS provides various functions that allow entry, storage and retrieval of large quantities of information and provides ways to manage how that information is organized. Because of the close relationship between them, the term "database" is often used casually to refer to both a database and the DBMS used to manipulate it. Outside the world of professional  information technology , the term  database  is often used to refer to any collection of related data (such as a  spreadsheet  or a card index) as size and usage requirements typically n
और पढ़ें

Database languages

-
Database languages are special-purpose languages, which allow one or more of the following tasks, sometimes distinguished as  sublanguages : Data control language  (DCL) – controls access to data; Data definition language  (DDL) – defines data types such as creating, altering, or dropping and the relationships among them; Data manipulation language  (DML) – performs tasks such as inserting, updating, or deleting data occurrences; Data query language  (DQL) – allows searching for information and computing derived information.
और पढ़ें