Query processing method and device for data warehouse

A technology of data warehouse and processing method, applied in the field of query processing method and device of data warehouse, can solve the problems of consuming large resources, increasing database query pressure, affecting ETL speed, etc., and achieving the effect of reducing resource pressure

Inactive Publication Date: 2011-12-07
MINSHENG BANKING CORP
View PDF2 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The characteristics of data warehouse construction and use determine that its daily data extraction, transformation and loading (Extraction Transformation Loading, referred to as: ETL) process needs to consume a lot of resources. If other queries are performed on the data warehouse during the data warehouse ETL process, It will increase the query pressure of the database and affect the speed of ETL

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
  • Query processing method and device for data warehouse
  • Query processing method and device for data warehouse
  • Query processing method and device for data warehouse

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0015] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments 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 creative efforts fall within the protection scope of the present invention.

[0016] Such as figure 1 The schematic diagram of the structure of the data warehouse provided by the embodiment of the present invention is shown, wherein the ETL server extracts, converts, loads, etc. the data sent by the peripheral source system, and sends the processed data to the data warehouse server for processing. The application server ca...

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 query processing method and device for a data warehouse. The method includes: detecting the preset query processing conditions of the data warehouse; when it is detected that the preset query processing conditions of the data warehouse have been met, processing the non-immediate demand queries. The device includes: a detection module and a processing module. The solution provided by the embodiment of the present invention effectively solves the problem in the prior art that the data warehouse cannot quickly execute other queries during the ETL process, and realizes dynamic optimization of query processing.

Description

technical field [0001] Embodiments of the present invention relate to the technical field of data processing, and in particular, to a query processing method and device for a data warehouse. Background technique [0002] A data warehouse (Data Warehouse, referred to as: DW) is a structured data environment of a decision support system (Decision Support System, referred to as: DSS) and an online analysis application data source. Data warehousing studies and solves the problems of obtaining information from databases. The characteristics of data warehouse are subject-oriented, integrated, stable and time-varying. In the existing technology, TERADATA is the world's largest enterprise-level data warehouse manufacturer, and its data warehouse products have been extremely influential in various industries. [0003] The characteristics of data warehouse construction and use determine that its daily data extraction, transformation and loading (Extraction Transformation Loading, re...

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 MINSHENG BANKING CORP
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