Data access method and equipment

A data access and device technology, applied in the electronic field, can solve the problem of high maintenance cost of shard routing rules

Inactive Publication Date: 2017-12-22
UNION MOBILE PAY
View PDF5 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The embodiment of the present invention provides a data access method and device, which are ...

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 equipment
  • Data access method and equipment
  • Data access method and equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0043] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are the embodiment of the present invention Some embodiments of the technical solution, but not all embodiments. Based on the embodiments recorded in the present invention documents, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the technical solutions of the present invention.

[0044] In the embodiment of the present invention, such as figure 1 As shown, the data access process is as follows:

[0045] Step S101: Obtain a database access request, which includes sqlid, fragmentation fields, and data request parameters;

[0046] Step S102: According to the ...

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 discloses a data access method and equipment. The method comprises following steps: obtaining a database access request, wherein the database access request comprises sqlid, fragmented fields and data request parameters; determining virtual library table identification according to the fragmented fields and the sqlid, wherein the virtual library table identification is a logic identification of an entity library table in a system; obtaining an entity library table A required accessing according to the mapping relationship between the virtual library table identification and the entity library table; after combining statement parameters in the data request parameters with the sql statement corresponding to the sqlid, accessing the entity library table A to obtain an access result. Therefore, the method and equipment effectively solve the technical problem of high maintenance cost of fragment routing rules in the prior art, and have the beneficial effects of reducing the modification of fragment routing rules and the operation cost of fragment routing rules.

Description

technical field [0001] The invention relates to the field of electronic technology, in particular to a data access method and device. Background technique [0002] With the development of Internet business, the business volume of trading system has increased exponentially. At the same time, Internet businesses often carry out promotional activities, which will lead to a surge in transaction volume and a transaction peak within a certain period of time. At present, transaction systems generally rely on databases as a tool for data persistence. Once a transaction peak occurs, database operations will become a bottleneck. [0003] Therefore, the distributed database solution is widely used by Internet companies to horizontally split the database table into multiple tables in multiple libraries to reduce the processing load of each fragmented table and improve the access efficiency of the database as a whole. It is necessary to formulate shard routing rules to realize data acc...

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): G06F17/30
CPCG06F16/245G06F16/2433G06F16/288
Inventor 殷舒刘胜陈正祝晓潭汤成山任慧玲
Owner UNION MOBILE PAY
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