Supercharge Your Innovation With Domain-Expert AI Agents!

Materialized view refreshing method and device, storage medium and processor

A materialized view and storage medium technology, applied in the field of database architecture design and optimization, can solve problems such as unproposed solutions, inaccurate business query data, large consumption, etc., and achieve the effect of reducing the amount of logs

Active Publication Date: 2021-02-09
人人行科技股份有限公司
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] 1. Backing up the database needs to consume a lot of IO to restore the data. In the production environment, the backup database IO often reaches 100%.
[0007] 2. The data cannot be guaranteed to be restored to the backup database in time, resulting in inaccurate business query data
[0008] Aiming at the problem that a large number of logs will be generated during the refresh process of the materialized view in related technologies, no effective solution has been proposed so far

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Materialized view refreshing method and device, storage medium and processor
  • Materialized view refreshing method and device, storage medium and processor
  • Materialized view refreshing method and device, storage medium and processor

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] In order to enable those skilled in the art to better understand the solutions of the present invention, the following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only It is an embodiment of a part of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts shall fall within the protection scope of the present invention.

[0027] It should be noted that the terms "first" and "second" in the description and claims of the present invention and the above drawings are used to distinguish similar objects, but not necessarily used to describe a specific sequence or sequence. It is to be understood that the data so used are interchangeable under appropriate ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a materialized view refreshing method and device, a storage medium and a processor. Wherein, the method includes: using the first task to perform a first refresh operation on the first materialized view, wherein data is stored in the second materialized view during the first refresh operation, and the first materialized view and the second materialized view are based on The same materialized view created by the target base table; after the first task performs the first refresh operation on the first materialized view, use the second task to perform the second refresh operation on the second materialized view, wherein, during the second refresh operation The data after the first refresh operation is stored in the first materialized view. The invention solves the technical problem in the related art that a large amount of logs will be generated during the refresh process of the materialized view.

Description

technical field [0001] The invention relates to the field of database architecture design and optimization, in particular to a method and device for refreshing a materialized view, a storage medium, and a processor. Background technique [0002] The materialized view (MV for short) technology provided by Oracle database is widely used in data execution and providing query performance. In the application scenario of data warehouse business with massive data, the role of materialized view is to improve The query efficiency of statistical tasks. For example, if there are three tables with more than 500 million pieces of data, it is necessary to frequently do three-table associated queries. Such queries take a long time. At this time, the result set of this query is prepared in advance through the materialized view Well, when the user queries again, the query efficiency will be greatly improved. However, because a large amount of redo logs are generated every time the materiali...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/242G06F16/2453
CPCG06F16/2425G06F16/2453
Inventor 谭怀远
Owner 人人行科技股份有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com