Real-time data display method based on HBase table

Abstract

The invention relates to a real-time data display method based on an HBase table. The method comprises the following steps: A, establishing a Kafka message queue; B, acquiring real-time data in a service server, and transmitting the real-time data to an HBase detail list through the Kafka message queue; C, performing multi-dimensional calculation on the real-time data in the HBase detail list; D,establishing a storage structure of the HBase table, and respectively storing the calculation result into each field, wherein an index primary key, an index name, a channel name, a product name, a dimension code, a dimension value and a calculation value field are respectively arranged in the storage structure of the HBase table, and the index primary key is formed by splicing the contents of other fields through separators; and E, reading the index primary key and splitting the index primary key by front-end equipment, and displaying split character strings on the front-end equipment. The front-end equipment can quickly acquire the data from a rear-end database at a millisecond or second-level speed for display, the acquisition speed of the real-time data is increased by multiple orders of magnitudes, and the requirement of real-time display of the data is completely met.

Description

technical field [0001] The invention relates to a data display method, in particular to a real-time data display method based on an HBase table. Background technique [0002] In the context of financial big data, banking institutions need clear data to let business personnel and developers understand the current business situation, so more and more financial institutions / enterprises will display data through some large data screens. In data display, there is a high requirement for real-time data, and everyone wants to see dynamically changing values, so as to quickly understand the business situation. At present, when displaying data on a large screen, the front end needs to access the database at the back end, query the required data from multiple databases, and then display it on the large screen. However, it is often very time-consuming for the front-end equipment to access the back-end database to obtain various data, and it may even take several minutes. This makes the...

AI Technical Summary

Problems solved by technology

However, it is often very time-consuming for the front-end equipment to access the back-end database to obtain various data, and it may even take several minutes. This makes the data displayed on the front-end large screen no longer the current real-time data, and there is a delay. It will have a great impact on the financial industry

Images