MSG Team's other articles

10567 Understanding the Paradigm Shift in the Global Economy

For a long time in the 20th century, the global economy was divided into the developed West and the Third World or the developing economies of Asia and Africa. Any discussion about the economy would invariably be around how many poor people are there in Asia and Africa compared to the affluence that the West […]

12578 Business Process Improvement – Training Requirements

Business Process Improvement Projects have become a common tool for Organizations to help review their business operational processes from time to time and to bring about necessary improvements. Organizations as well as their processes as well as their markets, customers and products keep changing. In current times, technology is playing vital role in the way […]

8906 Designing a Decision Support System User Interface

The effectiveness of a computerized system or a software platform depends on its user interface design. Be it a routine software program or a high-end decision support system, user’s interaction with the system should be as simple, effective and hassle-free as possible. It’s not a mystery that great decision support systems have brilliant user interface […]

8845 How Not to Put All Eggs in One Basket – De-Risking Strategies for Outsourcers

What is De-Risking ? Outsourcing is a process that involves selection of vendors who would then do the necessary work for their clients regarding handling such work that the clients deem can be done by Third Party Vendors. What this means is that the clients first narrow down the list of outsourcers that can be […]

9028 What is Due Diligence, Why it is Important, and How it Works and, What it Does ?

What is Due Diligence? Many of us would have heard the term Due Diligence in various contexts and situations where one party to a transaction often tells the other to do their due diligence or states that it is considering the same. Indeed, as anyone who has negotiated an employment contract or a legal drafting […]

Search with tags

  • No tags available.

Introduction

One of the critical components in the information technology age is the data. Data is the source of all the information and information is valuable for decision making process.

Decision support systems are developed to support executive management and relevant decision makers. In the modern era, there is large volume of information is available. Data warehouse is required to store huge volume of data.

Since the data warehouse is supporting decision support system, therefore, it should be subject oriented, integrated, collected over a period of time and static.

Data Warehouse

Data warehouse has subject oriented data. This subject oriented data could be information such as sales, customer name, etc. Data warehouse excludes information, which is not useful for decision-making process.

Data warehouse is developed as an integration of multiple heterogeneous data sources. As the data source have their own data protocol, data processing is required while data warehousing.

Data warehouse provides information with time as function. This gives historical perspective to the information.

Once data is captured into the data warehouse, it cannot be changed.

Data within the data warehouse is maintained in form of star schema, snowflake schema and galaxy schema.

Data Mart

The data mart is that portion of the access layer of the data warehouse which is utilized by the end user. Therefore, data mart is a subset of the data warehouse. Data mart is usually assigned to a specific business unit within the enterprise. Data mart is used to slice data warehouse into a different business unit. Typically, ownership of the data mart is given to that particular business unit or department.

The primary utility of data mart is business intelligence. A data mart requires very less investment compared to data warehouse and therefore it is apt for smaller business. Set up time for data mart is very less again making it practical for smaller business.

The main advantages of data mart are as follows:

  • It provides easy access to daily used data.
  • It improves decision making process for end user.
  • It is easy to create and maintain.

Online Analytical Processing (OLAP)

OLAP or Online Analytical Processing is a concept in which data is analyzed through multiple dimensions with help of structure called cube. OLAP helps in converting data into information.

The main objective of OLAP is to summarize information for decision making process from large data base. The report generated through OLAP can be presented in a format as per the requirement of end user.

The advantages of OLAP are as follows:

  • It ensures that response to query is quicker consistently.
  • It provides facility to work with data which are difficult to query through SQL.
  • It lets user create view with the help of spreadsheet.

There are three types of OLAP multi-dimensional OLAP, relational OLAP and Hybrid OLAP. In multi-dimensional OLAP data is usually stored in proprietary structure suitable for multi-dimensional analysis. In relational OLAP data base is structure through standard database in star or snowflake schema. A combination of multi-dimensional OLAP and relational OLAP is the hybrid OLAP.

Article Written by

MSG Team

An insightful writer passionate about sharing expertise, trends, and tips, dedicated to inspiring and informing readers through engaging and thoughtful content.

Leave a reply

Your email address will not be published. Required fields are marked *

Related Articles

Components of Commercial Value Chain

MSG Team

The Changing Face of Business Environment

MSG Team