Order type data multi-dimensional sub-table system

Abstract

The invention relates to an order type data multi-dimensional sub-table system. The input interface inputs business data; the hot table database stores active data; and the data synchronization unit synchronizes the data meeting the conditions in the hot table database to the multi-dimensional cold table database and lists the data to cold table sub-tables of different dimensions. The data is distributed to cold table sub-tables of different dimensions at the same moment; pointers are arranged between the corresponding data in the cold table database, so that the data can be delivered out of the database at the same time; and through a query interface of the data route, a fuzzy matching unit is matched with the self-heating table database or the multi-dimensional cold table database to query data. According to the invention, the operation is not interfered, the business data volume of the heat table is greatly reduced, the pressure of the database, especially the write library, is relieved, and the common business operation is easier and short in time consumption; full-amount historical data query can be carried out for special scenes, so that the time consumption of exporting and full-amount query of various data is greatly reduced; and the data is backed up instantly and excessive calculation amount is not generated.

Description

technical field [0001] The present invention relates to data processing systems or methods specially suitable for administrative, commercial, financial, management, supervisory or forecasting purposes; processing systems or methods specially suitable for administrative, commercial, financial, management, supervisory or forecasting purposes not included in other categories The technical field of the method, in particular to a multi-dimensional table sorting system for order data. Background technique [0002] MySQL is a relational database management system. A relational database stores data in different tables instead of putting all data in a large warehouse. It has fast reading and writing speed and high flexibility. [0003] The SQL language used by MySQL is the most commonly used standardized language for accessing databases. Because of its small size, fast speed, low overall cost of ownership, and especially its open source characteristics, it is generally chosen as the ...

AI Technical Summary

Problems solved by technology

[0006] For sub-database and sub-table, it just simply physically splits MySQL data, and splits the data into N tables according to specific fields and table sub-logic; this leads to when the data has multi-dimensional queries, Some query condition fields cannot match the sub-table logical fields, so that the actual query still needs to span multiple sub-tables, and the performance is even worse than before;

[0007] For the use of nosql, such as ElasticSearch, its performance has indeed improved, but the cost of development and operation and maintenance has also greatly increased. At the same time, the data in nosql is not easy to use client tools for real-time query and cannot be compared with other MySQL business table data. Joint query, which makes it quite inconvenient to troubleshoot the problem

Images