A Distributed Database is a database which is distributed at various geographical locations. This type of database system works under the control of one central database management system and the storage devices of the distributed database are not all connected to a common CPU. A distributed database can reside on intranets, internet, network servers or extranets. The advantage of distributing the database is significant improvement in performance of data rates.
Data Warehouse is a database containing collection of information extracted from various other databases. Data Warehouse can be used by end users or management personnel, primarily for reporting purposes. There are many benefits of using a Data Warehouse, such as retrieval of information from a Data Warehouse doesn’t affect the performance of the operational system, automatic identification and resolving of inconsistent data, etc.
An analytical database is used to store extracted information from external or operational databases, for analysis purposes. The data in the analytical database is filtered, edited and used by the analysts of the organization. Organizations worldwide use Analytical databases for the analysis of employees’ or organization’s performance.
The Hypermedia database is used for the purpose of storing multimedia web pages. In a Hypermedia database, data is stored online and it can be accessed by multiple users, simultaneously.
In addition to the above database types, there can be other types of databases as well. For example, businesses in specific industries will have customized database solutions, targeted at the particular requirements and needs of the business.