System performance optimization method and system based on materialized view

A materialized view and system performance technology, applied in the database field, can solve problems such as data floating and data inaccuracy, and achieve the effects of reducing CPU consumption, reducing logic reading, and improving scanning speed

Inactive Publication Date: 2009-07-08
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF0 Cites 32 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] In order to solve the traditional problem of needing to manually refresh the materialized view, which causes data floati...

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
  • System performance optimization method and system based on materialized view
  • System performance optimization method and system based on materialized view
  • System performance optimization method and system based on materialized view

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] In order to make the above objects, features and advantages of the present invention more comprehensible, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0031] In order to illustrate the technical solution of the present invention more clearly and intuitively, the exemplary hardware and software environment used to implement an embodiment of the present invention are defined as follows:

[0032] Operating system: LinuxAS4 Kernel version: 64-bit MEM memory capacity: 2G

[0033] swap paging space: 2G cpu: Pentium(R)D CPU 2.80GHZ

[0034] oracle version: 10.2.0.2.0

[0035] It should be noted that the above operating environment is just an example of a suitable operating environment, and does not imply any limitation on the applicable scope and functions of the operating environment. Other known computer systems, environments and / or configurations applicable to the materialized vie...

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 relates to the database field, and provides a method and a system for optimizing system performance based on materialized view. The method comprises the following steps: capturing SQL (structure query language) query language; confirming a question base table formed by SQL query language which triggers system full scan; establishing a materialized view aiming to the question base table; optimizing the established materialized view; and processing corresponding SQL query utilizing optimized materialized view. The invention solves the inaccuracy problem caused by traditional manual refreshment of the materialized view in the prior art, and avoids the effect to the operation performance of the base table brought by manual synchronous refreshment. The regularly automatic refreshment technology provided by the invention works with index, so that the data is led to reach a relative good query state, and a user can quickly and accurately view the data.

Description

technical field [0001] The invention relates to the field of databases, in particular to a materialized view-based system performance optimization method and system. Background technique [0002] SQL (Structured Query Language), an advanced non-procedural programming language, allows users to work on high-level data structures. It does not require users to specify how to store data, nor does it require users to understand the specific data storage methods. Therefore, different database systems with completely different underlying structures can use the same SQL language as the interface for data input and management. [0003] For the traditional implementation of SQL query sorting, it is necessary to perform operations such as sorting, grouping, calculation, and filtering on the query result set in the table. Since the analysis of these operations requires the specific display of the result set, it is like SQL Operations such as queries and views that only need to be read w...

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
IPC IPC(8): G06F17/30
Inventor 罗琼
Owner KINGDEE SOFTWARE(CHINA) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap