Unlock instant, AI-driven research and patent intelligence for your innovation.

Database multi-index method, apparatus and system

A database and multi-index technology, applied in the database field, can solve the problems of large data scale and workload, and achieve the effect of reducing data scale and workload

Active Publication Date: 2016-04-13
ADVANCED NEW TECH CO LTD
View PDF4 Cites 19 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] In order to overcome the problem of large data size and workload caused by adding indexkey after sub-database sub-table in the related technology, this application provides a database multi-index method and system

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database multi-index method, apparatus and system
  • Database multi-index method, apparatus and system
  • Database multi-index method, apparatus and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0052] Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numerals in different drawings refer to the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with this application. Rather, they are merely examples of apparatuses and methods consistent with aspects of the present application as recited in the appended claims.

[0053] In the following detailed description, numerous specific details are set forth in order to provide a comprehensive understanding of the application, but those skilled in the art will understand that the application may be practiced without these specific details. In other embodiments, well-known methods, procedures, components and circuits have not been described in detail so as n...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

Embodiments of the invention disclose a database multi-index method, apparatus and system. The method comprises: establishing an associative index table and storing a corresponding relationship between a new index keyword and a main index keyword by using the associative index table; when the new index keyword is used as the main index keyword to perform a query, finding the corresponding main index keyword in the associative index table according to the new index keyword; and routing to a sub-table of a sub-library according to the corresponding main index keyword, thereby completing the query of data. The library division and the table division are carried out by using the associative index table instead of the new index keyword, so that one or more data are prevented from being re-recorded, and the data scale and the workload are greatly reduced.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a database multi-index method, device and system. Background technique [0002] With the widespread popularity of Internet applications, the scale of data continues to expand, there are more and more tables in the database, and the amount of data in the tables is also increasing. Correspondingly, the overhead of data operations (such as adding, deleting, modifying, and checking) It is also getting bigger and bigger, and the resources (CPU, disk, memory, etc.) of a server are limited, and eventually the amount of data that the database can carry and the data processing capacity will encounter bottlenecks. In order to solve the above problems, a sub-database and sub-table mechanism is introduced to split the data and store the data in different databases or different data tables, reducing the load and processing pressure of the single-point server and improving the efficiency of ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 于君泽
Owner ADVANCED NEW TECH CO LTD