The invention provides a design method and
system for efficiently querying a
bank data warehouse based on an MPP architecture, and the method comprises the steps: S1, collecting and cleaning data from a plurality of
bank business systems, and loading the data to a Greenplum distributed
data warehouse; s2, performing
hierarchical modeling in the warehouse, constructing a customer center wide table, and storing data in each node in a balanced manner by adopting partition and hash distribution strategies; s3, designing a
batch processing task scheduling process, and improving the
batch processing efficiency by utilizing parallel execution; s4, optimizing configuration indexes and materialized views according to the queries, and accelerating query response by utilizing
parallel computing of the MPP architecture; and S5, monitoring a
system load and dynamically and elastically scaling cluster resources to deal with service peak and valley demands. By means of the steps, high-performance
batch processing and real-time query support of EB-level
bank data are achieved on the GreenplumMPP cluster, the
data processing efficiency and the query response speed are remarkably improved, and good expansibility is achieved so as to meet the
service development requirement.