Types of Database - What are the Main Types of Database fully discussed the types of database - what are the types of database...
Types of Database
There are different types of database:
1. Operational Database:
These databases store detailed data needed to support the operation of an entire organization. They are also called subject-area database (SADB), transaction database, and production database. Examples are customer & personal database, and also inventory database, etc.
2. Analytical Database:
These database store data information extracted from a selected operational and external databases. Analytical databases consist of summarized data and info most needed by an organization's management and other end-user. This type of database is also called a management database or information database. Examples are the decision support system and the executive information system.
3. Data Warehouse:
A data warehouse stores data from current and previous years--data extracted from the various operational database of an organization. This type of database becomes the central source of data that which can be screened, edited, standardized and integrated so that it can be used by the managers and other end-user professionals throughout an organization.
4. Distributed Database:
This database is dispersed through an organization. This is a database of local workgroup and department at region office, branch office and other worksite. In this database data is stored physically across computers or a site at different locations is known as a distributed database system. The computer in distributed database system is connected together by a data communication network.
5. End-User Database:
Your own personal database. These databases consist of a variety of data files developed by end-user at their workstations. Examples of end-user are collections of the documents in spreadsheets, in word processing and even downloaded files.
6. External Database:
The database provides an online service/information. Access to external privately owned online database is available for a fee to end-user and organization from commercial information service.
7. Text Database:
Database of the document using a computer to create and store electronically. This online database stores the bibliography information such as publication enlarge text. For example a newspaper, magazines, etc.
8. Image and Multimedia Database:
This database stores data in a text, image, sound, video. For example, an electronic encyclopedia is available on CD ROM disk that stores 1000 animated video along with 1000 pages of text.