Types of Databases Management System, Operational Databases
Types of Databases Management System: 
Continuing developments in information technology and its business applications have resulted in the evolution of several major types of databases. Six major conceptual categories of databases that may be found in computer-using organizations include:
Operational Databases - These databases store detailed data needed to support the operations of the entire organization.  They are also called subject area databases (SADB), transaction databases, and production databases.  Examples are customer databases, personnel databases, inventory databases, and other databases containing data generated by business operations.

Analytical Databases - These databases store data and information extracted from selected operational and external databases.  They consist of summarized data and information most needed by the organization's managers and other end users.  Analytical databases are also called management databases or information databases.  They may also be called multidimensional databases since they frequently use a multidimensional database structure to organize data. These are the databases accessed by the online analytical processing (OLAP) systems, decision support systems, and executive information systems in order to support managerial decision making.
Data Warehouse Databases - A data warehouse stores data from current and previous years that has been extracted from the various operational and management databases of an organization.  It is a central source of data that has been screened, edited, standardized, and integrated so it can be used by managers and other end-user professionals from throughout an organization.  Data warehouses may be subdivided into data marts which hold specific subsets of data from the warehouse.  A major use of data warehouse databases is data mining.  In data mining, the data in a data warehouse are processed to identify key factors and trends in historical patterns of business activity can be used to help managers make decisions about strategic changes in business operations to gain competitive advantages in the marketplace.

Distributed Databases - Many organizations replicate and distribute copies or parts of databases to network servers at a variety of sites.  These distributed databases can reside on network servers on the World Wide Web, on corporate intranets or extranets, or on other company networks.  Distributed databases may be copies of operational or analytical databases, hypermedia or discussion databases, or any other type of database.  Replication and distribution of databases are done to improve database performance and security.
End User Databases - These databases consist of a variety of data files developed by end users at their workstations.  End users may have their own electronic copies of documents they downloaded from the WEB, generated themselves, or received by electronic mail.
External Databases - Access to external, privately owned online databases or data banks is available for a fee to end users and organizations from commercial online services, and with or without charge from many sources on the Internet, especially the WEB. 

Mukesh Rajput

Mukesh Rajput

I am a Computer Engineer, a small amount of the programming tips as it’s my hobby, I love to travel and meet people so little about travel, a fashion lover and love to eat food, I am investing a good time to keep the body fit so little about fitness also..

Post A Comment:


Mukesh Rajput