Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and apparatus for maintaining data for on-line analytical processing in a database system

An online analytical processing and analytical processing technology, applied in the field of data processing, can solve problems affecting the performance of online data processing, etc.

Active Publication Date: 2019-06-28
HUAWEI TECH CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, the periodic creation of child processes will affect the performance of online data processing

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
  • Method and apparatus for maintaining data for on-line analytical processing in a database system
  • Method and apparatus for maintaining data for on-line analytical processing in a database system
  • Method and apparatus for maintaining data for on-line analytical processing in a database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0049] The technical solutions in the embodiments of the present invention are explained below with reference to the drawings. Obviously, the embodiments described below are only for exemplary purposes and cannot cover all embodiments of the present invention. Those skilled in the art can derive other embodiments from the embodiments given herein without any creative work, and all these embodiments are within the protection scope of the present invention.

[0050] The present invention uses multiple processes to manage OLTP load and OLAP load, and uses collaborative process synchronization to realize real-time OLAP database.

[0051] Such as figure 1 As shown, there is a multi-threaded process called the main process 110 in the database system 100, which is responsible for OLTP. The main process 110 is the only process in the database system 100 that can perform write operations. In addition, the database system 100 includes at least one read-only multi-threaded process 120, whic...

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

A method and an apparatus of maintaining data for online analytical processing in a database system. The method includes: tracking a changed page in a main process; and synchronizing the changed page to a child process for online analytical processing. In the method and apparatus of maintaining data for online analytical processing, the changed pages are tracked and then the child process is synchronized with the changed pages. Therefore, periodic forking is avoided, fork overhead due to periodic forking in the prior art is removed, the synchronization is faster since only the changed pages are synchronized, and the performance of online data processing is enhanced.

Description

Technical field [0001] The present invention relates to the field of data processing technology, and in particular to a method and device for maintaining data for online analysis and processing. Background technique [0002] Online transaction processing (OLTP) and online analytical processing (OLAP) are two types of database systems. The OLTP system is used to manage and process transactions. Typical examples of such transaction processing systems are sales order entry or bank transaction processing. The OLAP system is used to analyze data and generate reports for business analysts. Typical reports include aggregate sales statistics broken down by geographic area, product category, or customer classification. [0003] Because OLAP query processing has generated resource competition and severely damaged critical transaction processing, initially, it did not consider trying to execute OLAP queries on the running OLTP database. Therefore, a data hierarchical architecture is desig...

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/27G06F16/958G06F16/28G06F16/178
CPCG06F16/254G06F16/178G06F16/27G06F16/28G06F16/283G06F16/958H04L67/02
Inventor 威诺斯·韦拉拉格哈文普拉森纳·文卡特斯·拉玛穆尔蒂陈志标
Owner HUAWEI TECH CO LTD