Provides you with an in-depth understanding of the DB2 data warehouse.

DB2 data warehouse is a must for us to learn about DB2 databases. The following describes the knowledge of DB2 databases in detail and hopes to help you.

A system that includes operational data to run daily business transactions) contains information that business analysts can use to better understand how the business operates. For example, they can see which products are sold in which regions during the year. This helps identify exceptions or plan future sales.

However, if the analyst directly accesses operational data, several problems may occur:

They may not have the expertise to query operational databases. For example, an application that uses a special data operation language is required to query an IMS database. Generally, programmers who have specialized techniques for querying and operating databases maintain the database and its Applications full-time.

Performance is critical for many operational databases, such as banks. The system cannot process the "special" query performed by users on operational data storage. Imagine you are processing your banking business on the Internet and paying your bills. When you press the OK button, it usually takes several seconds to process the payment. Now, consider that bank analysts are trying to figure out how to earn more money from their existing customer base. The analyst runs a query, which is so complex that it takes about 30 seconds to complete your transaction. Obviously, this performance time is unacceptable and the new fees that analysts imagine are impossible ). For this reason, the operational data storage and report data storage, including OLAP databases, are generally separated.

However, in recent years, the report data storage has gradually become a pseudo-operation pseudo-operational) data storage and is very popular. Such storage is called operation data store (ODS ). For example, consider the telecommunications industry. ODS is popular among these companies because they try to identify fraudulent fees as quickly as possible. DB2 is one of the few databases that are ideal for operating and reporting workloads.

Operational data is generally not the best format used by business analysts. For example, for analysts, sales data collected based on products, regions, and seasons is much more useful than raw data.

DB2 Data Warehouse solves these problems. In the DB2 data warehouse, you create informationized data informational data) this data is extracted from operational data, and then converted and cleaned for End User decision-making) storage. For example, the DB2 data warehouse tool may replicate all the sales data in the operational database, execute calculations to summarize the data, and write the summarized data to the database separate from the operational data. End users can query this separate database data warehouse without affecting the operating database.
 

Introduction to DB2 recursive query

Implementation of DB2 Paging

DB2 cursor and usage

How to manage DB2 tablespaces

DB2 database Permissions