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

Window aggregation method, query method and device in relational database management system

A technology of window aggregation and management system, applied in relational database, database model, electronic digital data processing, etc., to achieve the effect of improving window query execution performance and execution efficiency

Active Publication Date: 2020-12-15
YUSUR TECH CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, the execution efficiency of the window aggregation operation of the existing relational database still needs to be further improved, so as to further improve the execution performance of the window query of the relational database

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
  • Window aggregation method, query method and device in relational database management system
  • Window aggregation method, query method and device in relational database management system
  • Window aggregation method, query method and device in relational database management system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention more clear, the embodiments of the present invention will be further described in detail below in conjunction with the accompanying drawings. Here, the exemplary embodiments and descriptions of the present invention are used to explain the present invention, but not to limit the present invention.

[0026] Existing window aggregation operations are performed serially. Improving the parallelism of the database through multi-threading, or utilizing the overlap of cached window data of adjacent tuples to reuse partial window data can improve the execution efficiency of window aggregation. However, it is limited by the number of threads and the size of the cache. The size brings limited performance improvement space. In addition, the relatively fixed sliding window calculation mode of the window aggregation function can be accelerated by dedicated hardware, but the ...

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 provides a window aggregation method, a query method and a device in a relational database management system, and the aggregation method comprises the steps: storing window data, obtained from child nodes of a window aggregation node in an original relational database, of at least one window length into an array of tuple types applied in a memory; converting all the window data in the array of tuple types into basic data types, and storing the window data of all the basic data types into the array of basic data types applied in the memory; all window data in the array of the window function type and the basic data type are output by setting a kernel function, so that an external hardware accelerator is used for aggregating the window data according to the window function type; and receiving a returned window aggregation result of the basic data type by setting a kernel function, and assigning the window aggregation result to the original relational database. Through the method, the execution efficiency of the window aggregation operation can be improved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a window aggregation method, query method and device in a relational database management system. Background technique [0002] With the rapid development of the Internet and e-commerce, more and more relational databases are used on the Internet, and they assume the core responsibility of enterprise business and information systems, so they are increasingly facing the test of ultra-large-scale data volume and high-intensity instantaneous concurrency. In response to these problems, for database enterprise-level applications, database technology with higher execution efficiency is required to ensure the interests of enterprises. [0003] Relational database window queries can be used to calculate aggregate functions for tuples within a certain range, for example, to calculate aggregate values ​​for a fixed time interval, where this time interval is called a window. Windows can o...

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/2453G06F16/28
CPCG06F16/2453G06F16/284
Inventor 鄢贵海江树浩申宇昂
Owner YUSUR TECH CO LTD