Difference between Database System
and Data Warehouse
Database System: Database System is used in traditional way of storing and
retrieving data. The major task of database system is to perform query processing.
These systems are generally referred as online transaction processing system. These
systems are used day to day operations of any organization. Data Warehouse: Data
Warehouse is the place where huge amount of data is stored. It is meant for users or
knowledge workers in the role of data analysis and decision making. These systems
are supposed to organize and present data in different format and different forms in
order to serve the need of the specific user for specific purpose. These systems are
referred as online analytical processing. Difference between Database System and
Data Warehouse:
Database System Data Warehouse
It supports analysis and performance
It supports operational processes. reporting.
Capture and maintain the data. Explore the data.
Current data. Multiple years of history.
Data is balanced within the scope of Data must be integrated and balanced from
this one system. multiple system.
Data is updated when transaction
occurs. Data is updated on scheduled processes.
Data verification occurs when entry is
done. Data verification occurs after the fact.
100 MB to GB. 100 GB to TB.
ER based. Star/Snowflake.
Application oriented. Subject oriented.
Primitive and highly detailed. Summarized and consolidated.
Flat relational. Multidimensional.
What is multidimensional data model (MDM)?
Multidimensional Data Model can be defined as a method for arranging the data in
the database, with better structuring and organization of the contents in the
database. Unlike a system with one dimension such as a list, the Multidimensional
Data Model can have two or three dimensions of items from the database system
What are the disadvantages of multi-dimensional data model?
Followings are the key disadvantages of Multidimensional Data Model - These types
of databases are usually dynamic in design since the Multi-Dimensional Data Model
manages complicated structures. Being a dynamic structure means the content of
the database is often immense in quantity.
What is logical multidimensional data?
2.1The Logical Multidimensional Data Model The multidimensional data model is an
integral part of On-Line Analytical Processing, or OLAP. Because OLAP is on-line, it
must provide answers quickly; analysts pose iterative queries during interactive
sessions, not in batch jobs that run overnigh
What is an example of a dimensional data model?
For example, a dimensional table for an item may contain the attributes item_name,
brand, and type. A multidimensional data model is organized around a central theme,
for example, sales. This theme is represented by a fact table. Facts are numerical
measures
What is Multi-Dimensional Data Model?
A multidimensional model views data in the form of a data-cube. A data cube
enables data to be modeled and viewed in multiple dimensions. It is defined by
dimensions and facts.
The dimensions are the perspectives or entities concerning which an organization
keeps records. For example, a shop may create a sales data warehouse to keep
records of the store's sales for the dimension time, item, and location. These
dimensions allow the save to keep track of things, for example, monthly sales of
items and the locations at which the items were sold. Each dimension has a table
related to it, called a dimensional table, which describes the dimension further. For
example, a dimensional table for an item may contain the attributes item_name,
brand, and type.
A multidimensional data model is organized around a central theme, for example,
sales. This theme is represented by a fact table. Facts are numerical measures. The
fact table contains the names of the facts or measures of the related dimensional
tables.
Consider the data of a shop for items sold per quarter in the city of Delhi. The data is
shown in the table. In this 2D representation, the sales for Delhi are shown for the
time dimension (organized in quarters) and the item dimension (classified according
to the types of an item sold). The fact or measure displayed in rupee_sold (in
thousands).
lay Videox
Now, if we want to view the sales data with a third dimension, For example, suppose
the data according to time and item, as well as the location is considered for the
cities Chennai, Kolkata, Mumbai, and Delhi. These 3D data are shown in the table.
The 3D data of the table are represented as a series of 2D tables.
Conceptually, it may also be represented by the same data in the form of a 3D data
cube, as shown in fig:
