Types of DBMS Architecture

-

Types of DBMS Architecture


DBMS Architecture 
Database architecture can be seen as a single tier or multi-tier. But logically, database architecture is of two types like: 2-tier architecture and 3-tier architecture.

टिप्पणियाँ

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

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

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