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

A database access method and system thereof

An access method and database technology, applied in database management systems, electronic digital data processing, structured data retrieval, etc., can solve problems such as lack of methods and systems, avoid low data access rates and network congestion, improve efficiency, and ensure The effect of visits

Active Publication Date: 2019-01-25
SHANGHAI AILONG INFORMATION TECH
View PDF6 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present application provides a database access method and its system to solve the technical problem in the prior art that lacks a method and system for implementing database access based on client routing

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
  • A database access method and system thereof
  • A database access method and system thereof
  • A database access method and system thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0053] see figure 1 As shown, the embodiment of the present application provides a database access method, which specifically includes the following steps:

[0054] Step S102, obtaining a service request;

[0055] The service request is sent by the client, and the service request is used to request access to the database.

[0056] Step S104, judging the type of the service request; wherein, the type of the service request includes: services related to public data and services related to personal data;

[0057] In this embodiment of the application, the business is classified according to the data requested by the obtained business request. If the purpose of the obtained business request is to request access to public data or upload public data and other operations related to public data, the business request The type is business related to public data; and when the data requested by the business request is personal data, if the purpose of the business request is to view or c...

Embodiment 2

[0066] see figure 2 As shown, the embodiment of the present application provides a database access method, which mainly includes the following steps:

[0067] Step S200, in a specific area, build the same number of main database master nodes and the same number of sub-database master nodes.

[0068] In this embodiment of the application, provinces and municipalities can be used as units to build the same number of main database master nodes and the same number of sub-database master nodes in each province and municipality.

[0069] For example, build a main database master node and ten sub-database master nodes in each province or municipality, or build a main database master node and 20 sub-database master nodes in each province or municipality.

[0070] It is pointed out here that the specific numbers listed above for the master nodes of the main database and the master nodes of the sub-database are only for the convenience of explanation, and are not specific limitations ...

Embodiment 3

[0113] Corresponding to the database access method disclosed above, the embodiment of this application discloses a database access system, see image 3 As shown, it mainly includes:

[0114] A service acquisition module 32, configured to acquire a service request;

[0115] A judging module 34, configured to judge the type of the business request; wherein, the type includes business related to public data and business related to personal data;

[0116] Forwarding module 36, if the type of the business request is a business related to public data, then forward the business to the corresponding master database master node; if the type of the business request is a business related to personal data, then forward the business to The service is forwarded to the corresponding master node of the sub-library.

[0117] The database access system described in the embodiment of the present application can be set in a client, and before sending a service request, the client can first requ...

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 embodiment of the application discloses a database access method and system, wherein, the method comprises the following steps: obtaining a service request; judging the type of the service request; Wherein the types include services related to public data and services related to personal data; If the type of the service request is a service related to the public data, the service request is forwarded to the corresponding master database master node; If the type of the service request is a service related to personal data, the service request is forwarded to the corresponding branch masternode. By adopting the technical scheme, the balance of accessing quantity of each database can be ensured, the access efficiency of users is improved, and the technical problems of low data access rate and network congestion caused by the sudden increase of accessing volume of a certain database under the condition of high concurrency are effectively avoided.

Description

technical field [0001] The present application relates to the technical field of data storage and database access, in particular to a database access method and system thereof. Background technique [0002] With the continuous development of Internet technology, more and more e-commerce platforms are integrated into people's lives. With more and more users accessing the e-commerce platform, storing the user's personal data and commodity data information in one server can no longer meet the needs of the e-commerce platform under high concurrency conditions. Therefore, more database servers are needed to store user's personal data and commodity data in a distributed manner, and then access the corresponding database based on the requested data, so as to meet the increasing number of visits. [0003] In the current e-commerce platform, there are many implementation methods for database access. However, there is no implementation method for database access based on client-side ...

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
IPC IPC(8): G06F16/25G06F16/2453
Inventor 张甫李志伟董浩
Owner SHANGHAI AILONG INFORMATION TECH
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