Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Horizontal database sharding method and system, and server

A technology of sub-database, sub-table and database, applied in the field of database, to achieve the effect of low cost, low cost of expansion, and reduction of the number of records

Inactive Publication Date: 2017-10-03
SHANGHAI QIANLONG INFORMATION TECH CO LTD
View PDF6 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the existing database vertical sub-database sub-table method cannot solve this problem

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
  • Horizontal database sharding method and system, and server
  • Horizontal database sharding method and system, and server
  • Horizontal database sharding method and system, and server

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] Embodiments of the present invention are described below through specific examples, and those skilled in the art can easily understand other advantages and effects of the present invention from the content disclosed in this specification. The present invention can also be implemented or applied through other different specific implementation modes, and various modifications or changes can be made to the details in this specification based on different viewpoints and applications without departing from the spirit of the present invention.

[0047]It should be noted that the diagrams provided in this embodiment are only schematically illustrating the basic idea of ​​the present invention, and only the components related to the present invention are shown in the diagrams rather than the number, shape and shape of the components in actual implementation. Dimensional drawing, the type, quantity and proportion of each component can be changed arbitrarily during actual implemen...

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

The invention provides a horizontal database sharding method, a horizontal database sharding system and a server. The method comprises the following steps of setting the number of clusters, the number of databases included in one cluster, and the number of tables included in one database; distributing data records to each database included in each cluster based on a preset database splitting routing rule; and distributing the data records in each database to each table included in the database based on a preset table splitting routing rule. According to the horizontal database sharding method, the horizontal database sharding system and the server, the databases are horizontally split into a plurality of sub-databases based on the number of rows of a single table, each sub-database is split into a plurality of sub-tables, thus the number of records of the single table is reduced, the response time required by inquiry is improved and the expandability is facilitated.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method, system and server for horizontal database and table division of databases. Background technique [0002] A database is a warehouse built on a computer storage device that organizes, stores and manages data according to the data structure. Generally, a database is a unit or a general data processing system in an application field, which stores a collection of related data belonging to enterprises and business departments, groups and individuals. The data in the database is established from a global point of view, organized, described and stored according to a certain data model; its structure is based on the natural connection between data, which can provide all necessary access paths, and the data is no longer specific to a certain It is not an application, but it is organization-wide and has overall structural characteristics. [0003] With the continuous developme...

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
CPCG06F16/213G06F16/27
Inventor 张应亮周强梁晓靖
Owner SHANGHAI QIANLONG INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com