A Result Cache Method of Distributed Database Based on Hierarchical Mapping

Abstract

The invention provides a layered mapping-based distributed database result caching method, belongs to the field of distributed database performance optimization research and application, and particularly relates to cache management, grouping, sorting and extraction of query operation result set data of a distributed database. According to the method, a distributed mapping cache framework is established based on a distributed framework; a bottom-layer local cache realizes local storage and grouping of the result set data; cache information is gathered in an upper-layer virtual cache; data extraction is realized through mapping of the virtual cache and the local cache; and the processing of grouping, sorting and the like of a result set is realized. Through the cache technology provided by the invention, while the result set of the distributed database is correctly extracted, the internal network and memory load of a system is reduced, and the reliability and data throughput performance of the distributed data system are improved. The technology has a positive application value in the fields of big data-based e-commerce, internet of things, wisdom cities and the like.

Description

technical field [0001] The invention provides a distributed database result set cache technology. The invention belongs to the field of distributed database performance optimization research and application, and in particular relates to a cache management, grouping, sorting and extraction method of query operation result set data of a distributed database. Background technique [0002] Data is the core resource of information system. How to correctly and reliably extract data satisfying constraints is one of the key issues of information systems. With the rapid development of technologies and applications such as the Internet of Things and social networks, the speed and scale of data generation have shown explosive growth. And whoever can hold these data and make good use of them can occupy a dominant position in the industry. As a core asset of an enterprise, business data has very high requirements for data storage, use, and management. In order to meet these requireme...

AI Technical Summary

Problems solved by technology

[0011] The above problems greatly affect the performance of distributed databases

There are already some solutions to push data to the second master node other than the master node for calculation (such as ocean base, etc.), so that although the master node’s master control ability can be guaranteed when the data is congested, it is still not solved in essence. Problems caused when large amounts of data and computation converge to a single point

Images