A Multi-Dimensional Table Segmentation System for Order Data

Abstract

The invention relates to a multi-dimensional sub-table system for order data. The input interface inputs business data, the hot table database stores active data, and the data synchronization unit synchronizes the data satisfying the conditions in the hot table database to the multi-dimensional cold table database and sorts the data. To cold table sub-tables of different dimensions, data is allocated to cold table sub-tables of different dimensions at the same time. There are pointers between corresponding data in the cold table database, which is convenient for data out of the database at the same time. Through the query interface of data routing, fuzzy matching The unit cooperates with the self-heating table database or multi-dimensional cold table database to query data. The invention does not interfere with each other between operations, greatly reduces the amount of business data of the hot meter, reduces the pressure on the database, especially the database writing, and makes common business operations easier and less time-consuming; full historical data query can be performed for special scenarios, greatly reducing various Data export and full query are time-consuming; data is backed up in real time without excessive computation.

Description

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

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