Disadvantages of DBMS

-
  • Cost of Hardware and Software: It requires a high speed of data processor and large memory size to run DBMS software.
  • Size: It occupies a large space of disks and large memory to run them efficiently.
  • Complexity: Database system creates additional complexity and requirements.
  • Higher impact of failure: Failure is highly impacted the database because in most of the organization, all the data stored in a single database and if the database is damaged due to electric failure or database corruption then the data may be lost forever.

टिप्पणियाँ

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

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

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.
और पढ़ें