-
Statistics
- Active Links: 15419
- Pending Links: 52
- Todays Links: 0
- Active Articles: 1148
- Pending Articles: 3
- Todays Articles: 0
- Total Categories: 18
- Sub Categories: 3515
Overce high quality SEO web link directoryArticle Details
What is Materialized View |
|
| Date Added: October 19, 2011 05:59:52 PM | |
| Author: Joseph | |
| Category: Business: Information Technology | |
In different situations, users will need to combine multiple data queries, and some great values to calculate the work of these statements. Generally, a query is routine in a database to support applications such as decision support system. Sometimes, however, the info on the OLTP database, it's bad, the smooth running of OLTP violated. Oracle to launch a new feature called materialized when the desired function is information that can save the shortcut to the applications and use them in real-time and temporary data should be summarized. All sets of results are not available to restore a single line, because the restoration of a normal table. Materialized views on the concept of aggregate data and do a couple of times to collect data from multiple users. Materialized views are schema objects such as tables, indexes; data can be stored in a database table in another database or the same. Replication of the same or different databases, a summary of the different sectors of these broad classes is also used. Materialized view is maintained only in the form of copies of replication of data between distributed databases. However, the prospects for an important reason for the physical design of application can provide access to aggregated data. However, detailed analysis is needed to determine, before creating a materialized view, database tables and columns are needed, taking into account the compression method and the combination of data users, and usually the best way to define the form ready for use. Materialized views are very similar in concept and that you should consider changing the data in database tables (this can lead to potential congestion of the base table DML). Remains on schedule, outlook, bulk panels, you can disable / remove it before loading, and re-create or re-loading. They also tend to consume space. Sign up to be significant, if the opinion is based on large tables, but it saves a lot of work in proportion. Materialized views are updated, in whole or incrementally. Materialized View log similar in concept to the current protocol is used for Oracle allows for more updates. Materialized use in table top. A table can be treated like any other table. In other words, the index can be divided, so that you can create a real life important, the CBO optimizer. Materialized views can be directly or indirectly, by the end user, who may seek the advice of its existence when used. If your application uses existing users, which are used directly with the database tables cannot be trained in some way. You can continue to base their questions on the table with the OBC and automatically write the questions on materialized views are possible uses or inappropriate. Author is technical writer in Oracle Support Services, Online Oracle Trainings and also editor in Free Web Directory, and submit site -Free Directory Listing, Oracle DBA Forums. |
|
|
|
|
-
Tag Cloud