mysql materialized view

In our project, we encountered the problem of getting data from the databases of other systems for statistical analysis. We initially chose to use ORACLE's ODI tool for data extraction, but the database provided by the other party In our project, we encountered the problem of getting data from the databases of other systems for statistical analysis. We initially chose to use ORACLE's ODI tool for data extraction, but the database provided by the other party In the company's project, if you

Number of materialized views synchronized 1. The purpose is to synchronize some data in the production database to the Data Warehouse. Considering the cost and convenience, the method of regularly refreshing the Materialized View Number of materialized views synchronized 1. The purpose is to synchronize some data in th

The biggest advantage of Materialized view is that it can improve performance: by pre-computing the answer to store it, it can greatly reduce the load on the machine.Features:Less physical reads-scanning less dataLess write-do not sort and aggregate frequentlyReduce CPU consumption-no need to aggregate data and call FunctionsSignificantly faster response time-query results will be returned quickly when data

Transferred from: http://blog.csdn.net/zhangchu_63/article/details/5543377The following connections are the theory of materialized views: http://blog.csdn.net/tianlesoftware/article/details/4713553The company's project encountered the need to take data from the database of other systems to carry out statistical analysis of the problem, the initial choice of using Oracle's ODI tool to draw the number, but the other provided by the database user does no

Label:If we encounter the need to take data from the database of other systems for statistical analysis, the suspect chooses to use ORACLE 's ODI tool for the number of votes, but the other side of the database provided by the user does not have any objects, just have to query all the table permissions, so the data can not be reversed. So decided to use materialized view, the data in the other database to t

1. Permissions required to create materialized views: [SQL] View plaincopy GRANT CREATE materialized VIEW to user_name; 2. Establish materialized view log in source table [SQL] View

If we encounter the problem that we need to fetch data from other system databases for statistical analysis, we may choose to use ORACLE's ODI tool for data extraction, but the database users provided by the other party do not have any objects, you only have the permission to query all tables, so you cannot reverse the data. Therefore, we decided to use the materialized view to retrieve the data in the data

The company's project encountered the need to take data from other systems in the database for statistical analysis of the problem, the initial choice of using Oracle's ODI tool to extract the number, but the other side provided by the database users do not have any objects, but only have the right to query all tables, so can not do data reverse. Then decided to use the materialized view, the data in the ot

Materialized View synchronization count 1. Usage Now we need to synchronize some data in the production database to the Data Warehouse. Considering the cost and convenience, we need to regularly refresh the materialized view for data synchronization. 2. Overall Implementation ideas L create a dblink to access the remot

The 0RA-01400 error is reported when the materialized view is refreshed. Background: materialized view is one of the three major tools for data warehouse refresh. In actual work, it is used for data extraction on heterogeneous platforms. Today, after creating a materialized

When refresh fast on demand is used to incrementally refresh the materialized view, the conventional creation step is to first create the materialized view log on the source database, and then create the materialized view on the t

A view is a database that stores only the query statements that define the view (the content is generated when the query is queried), and the materialized view is a view of the content after its query statement is queried and stored (the content is generated when the

I. IntroductionMaterialized View, as its name implies, is a physical view that is actually stored on the hard disk. query performance is better than normal views. Ii. materialized view principle:1. generate dataTwo major options: build immediate build deferredBuild immediate: generate data based on the master table whi

2014-06-08 Baoxinjian1. usage A materialized view is a database object that includes a query result, which is a local copy of the remote data, or is used to generate a summary table based on the sum of the data tables.materialized views store data based on remote tables and can also be referred to as snapshots. For replication, materialized views allow you

2014-06-08 Baoxinjian1. usage A materialized view is a database object that includes a query result, which is a local copy of the remote data, or is used to generate a summary table based on the sum of the data tables.materialized views store data based on remote tables and can also be referred to as snapshots. For replication, materialized views allow you