Memory table query method and system based on centerless architecture distributed database
A query method and memory table technology, applied in database indexing, database updating, structured data retrieval, etc., can solve the problems of insufficient improvement of query efficiency and performance degradation, and achieve the goals of improving user experience, optimizing performance, and maintaining consistency Effect
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0047] The present invention is based on the in-memory table query method of the non-central framework distributed database, comprises the following steps:
[0048] S100, define the memory table on the database client, and designate the original table of the database as a memorable state in the CREATE TABLE stage as the memory table;
[0049] S200. Create a corresponding memory table metadata manager based on the memory table. The memory table metadata manager stores memory table attribute information, and the memory table attribute information includes a memory data pulling completion identifier and lock information of the table data corresponding to the memory table;
[0050] S300. If there is table data stored in the original table of the database, pull the table data in the original table of the database into the memory of the currently operating data node, and update the memory data pulling completion flag of the memory table metadata manager;
[0051] S400. Create and ex...
Embodiment 2
[0065] The present invention is based on a memory table query system of a distributed database with a central architecture, including a memory table creation module, a memory table metadata manager creation module, a user check module, a data pull module, and a query module. The memory table creation module is used for The database client defines a memory table, and in the CREATE TABLE stage, the original table of the database is designated as a memory-capable state as a memory table; the memory table metadata manager creation module is used to create a corresponding memory table metadata manager based on the memory table, The memory table metadata manager stores the memory table attribute information. The memory table attribute information includes the memory data pulling completion mark and the lock information of the corresponding table data of the memory table; the user checking module is used to check the user authority of the memory table; the data The pulling module acts...
PUM
Login to View More Abstract
Description
Claims
Application Information
Login to View More