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

Data access method and device as well as distributed database system

A data access and database technology, which is applied in the database field, can solve problems such as poor data recoverability and poor scalability of distributed memory database server systems, and achieve the effects of timely data recovery, flexible and convenient system expansion, and improved scalability

Active Publication Date: 2013-03-06
SHENZHEN GLOBEBILL TECH CO LTD
View PDF4 Cites 32 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The present invention provides a data access method, a data access device and a distributed database system to solve the problem of poor data recoverability and poor scalability of the distributed memory database server system in the existing distributed memory database server system The 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
  • Data access method and device as well as distributed database system
  • Data access method and device as well as distributed database system
  • Data access method and device as well as distributed database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0023] refer to figure 1 , shows a flow chart of steps of a data access method according to Embodiment 1 of the present invention.

[0024] The data access method of the present embodiment includes the following steps:

[0025] Step S102: When the scheduling server receives the request to add a database server or delete a database server, it performs data migration on the database server to be added or the database server to be deleted.

[0026] When the system needs to be expanded, a new database server will be added, and the newly added database server may be a memory database server or a disk database server. The newly added database server will send a request for adding a database server to the scheduling server, but it is not limited thereto, and the scheduling server may find that a new database server has been added through monitoring, and generate a request for adding a database server. When the database server fails or needs to be deleted, the scheduling server will...

Embodiment 2

[0037] refer to figure 2 , shows a flow chart of steps of a data access method according to Embodiment 2 of the present invention.

[0038] In this embodiment, a scheduling server, an in-memory database server cluster including at least one in-memory database server, and a disk database server cluster including at least one disk database server are set, and the number of servers in the in-memory database server cluster can be equal to that of the disk database server cluster. The number of servers in is the same or different. Among them, the scheduling server implements the scheduling, access, synchronization and management functions of the memory database server cluster and the disk database server cluster, the memory database server cluster implements data reading, the disk database server cluster implements data writing, and the memory database server cluster implements data synchronization Achieve data consistency with the disk database server cluster. Preferably, some ...

Embodiment 3

[0082] In this embodiment, a distributed memory database system is taken as an example to describe the data access method of the present invention.

[0083] The structure of the distributed memory database system of this embodiment is as follows image 3 As shown, including writing layer scheduling server, data synchronization server, reading layer scheduling server, WDC (Writing-layer Database Cluster, writing layer database cluster), and RDC (Reading-layer Database Cluster, reading layer database cluster) . Among them, WDC is a disk database server cluster, and RDC is a memory database server cluster. The writing layer scheduling server, the data synchronization server and the reading layer scheduling server belong to the same machine physically, but they are logically divided into three logical nodes. Of course, it can also be the actual three physical machines.

[0084] Among them, the main function of the writing layer scheduling server is to control the WDC, update th...

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 data access method and a device as well as a distributed database system. The data access method comprises the following steps of: when receiving a request of adding a databank server or deleting a databank server, carrying out data migration on the databank server to be added or the databank server to be deleted; generating a second corresponding relationship according to the data migration, storing the second corresponding relationship and a first corresponding relationship before the data migration, wherein the first corresponding relationship is used for indicating the corresponding relationship between the data and the server before the data migration, and the second corresponding relationship is used for indicating the corresponding relationship between new data which is generated according to the data migration and the server; receiving a data access request in the data migration process; and according to the data access request and the stored first corresponding relationship and second corresponding relationship, determining the server where the data to be accessed are located, and accessing the data to be accessed on the determined server. By utilizing the data access method, the capacity expandability of a system is improved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a data access method, a data access device and a distributed database system. Background technique [0002] In the technical application of the Internet, the database service occupies a very important position. With the development of technology, the background service of the Internet requires the database to have a faster response speed. Under this demand, the emergence of the memory database has been born. An in-memory database is different from a traditional database in that the data in an in-memory database is stored in memory. Since the data of the network service may be very large, the memory database server cannot load all the data on a single memory database server, which requires distributed management of the memory database server. [0003] A realization scheme of distributed memory server system management is as follows, including: the memory database obtains the i...

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 SHENZHEN GLOBEBILL 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