What is Data Warehousing?

Data storage is the process of building and using a data repository. A database a type of dbms that is created by combining data from a variety of sources that support analytical reporting, structured and / or interim questions, and decision-making. Data storage includes data cleaning, data integration, and data integration.

Source

Using Data Warehouse Information

There are decision support technologies that help to use the data available in the database. This technology enables managers to use the repository quickly and efficiently. They can collect data, analyze it, and make decisions based on the information available in the repository. Information collected in the repository may be used on any of the following domains -

Tuning Production Strategies :

Product strategies can be carefully evaluated by re-branding and managing a product portfolio by comparing quarterly or annual sales.

Customer Analysis :

Customer analysis is done by analyzing customer preferences, purchase time, budget cycles, etc.

Functional Analysis :

Data storage also helps to control customer relationships, and make environmental adjustments. Information also allows us to solve business operations.

Integrating the Preservation of Various Information To sum up many details, we have two options

The way the question is run

The process driven by the update

How the Question Is conducted

This is a common way to combine various databases. This method was used to build wrappers and joints over a wide variety of information. These producers are also known as mediators.

Query-Driven Approach Process

When a query is receiving on the client side, the metadata dictionary correctly translates the query into the various individual sites involved.

These questions are now mapped and sent to a local query reviewer.

Results from various sites are grouped into a global response set.

Disadvantage:

The interview process requires complex integration and filtering processes.

This method does not work well.

Very expensive for common questions.

This method is also very expensive for questions that need to be combined.

Ongoing Renewal Method

This is another traditional method. Modern data storage systems follow the process of revision rather than the usual one mentioned earlier. In the process of updating, information from many different sources is collected in advance and stored in a repository. This information is available for direct inquiry and analysis

Benefits

This method has the following advantages -
This method provides high performance.
Data is process of copied, processed, compiled, described, summarized and rearranged in a semantic data store in advance.
Query processing does not require a virtual connector to process data from local sources.

Data Shop Tools and Utilities Tools

The functions and tools of warehouse data are as follow-

Source

1_Data Extraction

Includes data collection from many different sources.

2_Data Cleaning

Includes finding and correcting data errors.

3_Data Conversion

Involves converting data from asset format to archive format.

4_Data Uploading

Includes filtering, summarizing, merging, integrity checking, and build and segmentation indicators.

5_Updates

Includes updates from data sources to the repository.