1 Answer - Sort by: Date | Rating
The databases may be of different types but there are two generic database architectures. These are:
(i) Centralized Databases (ii) Distributed Databases
Centralized Databases
A database who's all data is located at a single computer (or site) and multiple users can access that database is known as centralized database. A centralized database provides an efficient way to access and update data. These databases are usually used in computer network environments. The examples of centralized databases are:
(i) Personal computer databases
(ii) Client/Server databases,
(iii) Central computer databases
Distributed Databases.Many organizations/departments have sub-offices in different cities and countries. In such cases, the distributed databases are used instead of centralized databases. A distributed database is a single logical database, which is spread physically across computers in multiple locations (such as cities or countries). For example, some of the database tables may be maintained at one location with a DBMS, while another group of database tables may be maintained at another computer with a DBMS. Suppose multi-campus university database.
Any user at any campus can access data of his campus as well as of other campuses because of mutual communication between database servers at both campuses.
The distributed databases are further divided into two categories.
(i) Homogeneous databases.
(ii) Heterogeneous databases.
(i) Centralized Databases (ii) Distributed Databases
Centralized Databases
A database who's all data is located at a single computer (or site) and multiple users can access that database is known as centralized database. A centralized database provides an efficient way to access and update data. These databases are usually used in computer network environments. The examples of centralized databases are:
(i) Personal computer databases
(ii) Client/Server databases,
(iii) Central computer databases
Distributed Databases.Many organizations/departments have sub-offices in different cities and countries. In such cases, the distributed databases are used instead of centralized databases. A distributed database is a single logical database, which is spread physically across computers in multiple locations (such as cities or countries). For example, some of the database tables may be maintained at one location with a DBMS, while another group of database tables may be maintained at another computer with a DBMS. Suppose multi-campus university database.
Any user at any campus can access data of his campus as well as of other campuses because of mutual communication between database servers at both campuses.
The distributed databases are further divided into two categories.
(i) Homogeneous databases.
(ii) Heterogeneous databases.
0
0
- What Is The Difference Between Two Tier And Three Tier Client/server Architecture?
- Describe The Problem With Two- Tier Server Dbms Architecture?
- What Is The Difference Between Two-tier And Three Tier Client Server Architecture?
- How Can I Create A Online Banking Database?
- 1.7. What Is A Database System?
- How Can I Describe A Erd?
- What Is The Difference Between Procedural And Non Procedural DML?
- What Is A Good Database Design?
- What Are The Advantages Of Normalisation?
- What The Functions Of My Sql?
- What Is The Glycaemic Index?
- Describe The Function That Should Be Provided By Modern Full Scalemulti User Dbms?
- Discuss The Responsibilities Of Database Administrators?
- What Are The Approaches For Managing The Design Of A Database System That Has Multiple User View?
- What Is The Main Advantage Of Telex System Over The Telephone?
- How Do You Plan Database?
- What Is How Many Types User In Dbms?
- What Is The Difference Between Drop,delete, Truncate In Database?
- Discus Various Objective Data Base Approach Which Objectives Do You Consider Most Important And Why?
- Who Many Dbms And Name Dbms?
- How Properties Are Conserved When Database Is Distributed?
- Why Is The Relational Database Approach Better Than Earlier Methods?
- Can Anyone Give Me An Example Of A Paper Based Database?
- Explain Various Types Of Set Operations In SQL?
- Is Data Report System Worthwhile?
- What Types Of Anomalies Are Found In Relational Databases?
- How Can I Write Down Five Types Of Computer?
- Could You Write Types Of Skeleton ?
- Write Down The Major Types Of Softwares?
- What 3 Types Of Play Did Shakespeare Write?
- What Types Of Literature Did Shakespeare Write?
- What 2 Types Of Writing Did Shakespeare Write In?
- What Three Types Of Plays Did Shakespeare Write?
- What Types Of Plays Did William Shakespeare Write?
- What Types Of Literature Did William Shakespeare Not Write?

New Comment - Comments are editable for 5 min.