Distributed-type database access method and system

An access method and access system technology, applied in the field of distributed database access methods and systems, to achieve the effects of simple configuration, reduced communication cost, and reduced burden

Inactive Publication Date: 2011-04-27
BEIJING BEWINNER DIANYI INFORMATION TECH CO LTD
View PDF3 Cites 104 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In order to overcome the defects caused by the existing centralized management database, the present invention provides a distributed database access 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
  • Distributed-type database access method and system
  • Distributed-type database access method and system
  • Distributed-type database access method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040] In order to achieve the above object, the present invention provides such as figure 1 The distributed database access system shown, the data read and write separation in the system, including Web server group (Web server group), database dispatcher (Db Dispatcher), master database group (Master Db group) and slave database group (SlaveDb group); the Web server group also sends SQL query requests and receives the returned results through the database scheduler, the database scheduler writes the data into the master database group, and the master database group copies the data to the slave database group; Read the corresponding data from the database group; both the master database group and the slave database group save users and their related information. The database scheduler is the proxy server, by figure 1 It can be seen that each WEB server in the WEB server group only communicates with the data distribution proxy server (hereinafter referred to as the proxy serve...

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 relates to a distributed-type database access method and system. The distributed-type database access method comprises: 1. a Web server sends a database access request to a proxy server; 2. the proxy server analyzes the database access request according to a preset analysis rule, and sends the analyzed database access request to a corresponding target database; and 3. the proxy serve sends a result returned by the target database to the Web server. The invention avoids risk of high cost brought by the centralized management of the database and avoids the risks that the whole system fails because of the fault of the single database, the system scale has small possibility of expanding and is limited and the like. The invention effectively realizes the reasonable distribution of physical resources, lowers communication cost, has strong expansibility, can dynamically distribute data flow, and can separate reading from writing; and under the condition of limited resource, performance is maximized.

Description

technical field [0001] The invention relates to the field of databases, in particular to a distributed database access method and system. Background technique [0002] With the maturity of traditional database technology and the rapid development of Internet applications, database applications have generally appeared on computer networks. At the same time, the traditional centralized database system also shows its shortcomings: centralized management will inevitably cause performance bottlenecks, and a single improvement of hardware performance is not enough to meet the current Internet's large data volume and high concurrent query writing requirements. At the same time, a large amount of hardware maintenance and upgrade costs are generated. Moreover, centralized management of databases often results in multi-database associations. Once a database crashes, it will cause the entire system to crash. So the distributed database system will gradually replace the traditional ce...

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 BEIJING BEWINNER DIANYI INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap