Operational
database-
These databases store detailed data
about the operations of an organization. They are typically organized by
subject matter, process relatively high volumes of updates using transactions.
Essentially every major organization on earth uses such databases. Examples
include customer databases that record contact, credit, and demographic
information about a business' customers, personnel databases that hold
information such as salary, benefits, skills data about employees, Enterprise
resource planning that record details about product components, parts
inventory, and financial databases that keep track of the organization's money,
accounting and financial dealings.
Data warehouse-
Data warehouses archive modern data from
operational databases and often from external sources such as market research
firms. Often operational data undergoes transformation on its way into the
warehouse, getting summarized, anonymized, reclassified, etc. The warehouse
becomes the central source of data for use by managers and other end-users who
may not have access to operational data. For example, sales data might be
aggregated to weekly totals and converted from internal product codes to use UPC
codes so that it can be compared with ACNielsen data.Some basic and essential
components of data warehousing include retrieving and analyzing data,
transforming,loading and managing data so as to make it available for further
use.
Analytical database-
Analysts may do their work directly
against, a data warehouse, or create a separate analytic database for Online
Analytical Processing. For example, a company might extract sales records
for analyzing the effectiveness of advertising and other sales promotions at an
aggregate level.
Distributed database-
These are databases of local
work-groups and departments at regional offices, branch offices, manufacturing
plants and other work sites. These databases can include segments of both
common operational and common user databases, as well as data generated and
used only at a user’s own site.
End-user database-
These databases consist of data developed
by individual end-users. Examples of these are collections of documents in
spreadsheets, word processing and downloaded files, even managing their
personal baseball card collection.
External database-
These databases contain data collected
for use across multiple organizations, either freely or via subscription. The Internet
Movie Database is one example.
Hypermedia databases-
The Worldwide web can be thought of as
a database, albeit one spread across millions of independent computing systems.
Web browsers "process" this data one page at a time, while web
crawlers and other software provide the equivalent of database indexes to
support search and other activities.
Operational
database-
Operational Database is the
database-of-record, consisting of system-specific reference data and event data
belonging to a transaction-update system. It may also contain system control
data such as indicators, flags, and counters. The operational database is the
source of data for the data warehouse. It contains detailed data used to run
the day-to-day operations of the business. The data continually changes as
updates are made, and reflect the current value of the last transaction.
========================
