Unlock instant, AI-driven research and patent intelligence for your innovation.

Data accessing method and device

A data access and data technology, applied in the database field, can solve problems such as increasing database burden

Inactive Publication Date: 2017-12-15
UNION MOBILE PAY
View PDF4 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Considering that a large amount of data is stored in a data table, it is necessary to operate the entire data table when accessing the data, which increases the burden on the database

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 accessing method and device
  • Data accessing method and device
  • Data accessing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] In order to make the purpose, technical solutions and advantages of the present invention clearer, the following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the drawings in the embodiments of the present invention.

[0028] The data to be accessed can be divided into multiple shards according to certain rules, that is, sharding rules. For example, for a one-year order data table, the order data table can be divided according to time rules, such as in units of months , can be divided into 12 sub-order data tables, these 12 sub-order data tables can be regarded as 12 shards, and the sub-order data tables can be called shard databases. Multiple shard databases can be stored on one server or on multiple servers. The process of accessing the first data is the process of accessing data in multiple fragmented databases on one or more servers.

[0029] See figure 1 , first, an application scenario ...

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 accessing method and device. Even under the situation that a fragmentation rule is changed, a routing rule corresponding to the fragmentation rule is not needed to be programmed to a fragmentation route, and data accessing can be achieved as well. The method comprises the steps that a data accessing request sent by a terminal is received; the data accessing request is used for requesting accessing of first data, the first data is divided into multiple zones which are stored in multiple databases dispersedly; request accessing parameters carried by the data accessing request are input into a set third-party program, and a routing result which is fed back by the third-party program is received; the routing result is used for instructing and storing one or more databases of the zones contained in the first data; according to the routing result, part or all of the databases in one or more databases are accessed, and the first data is obtained.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a data access method and device. Background technique [0002] With the increasingly wide application of computers and networks and the increasingly rich types of business in different fields, the amount of data in network application systems is increasing, and the types of data are also increasing, and the access to data in network application systems is also increasing. frequently. [0003] Considering that a large amount of data is stored in a data table, it is necessary to operate the entire data table when accessing the data, which increases the burden on the database. In order to reduce the burden on the database, the database table of massive data is fragmented according to certain fragmentation rules, divided into multiple data tables, and the multiple data tables are scattered and stored in multiple databases. When accessing data, the data table where the data to be ...

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/25
Inventor 殷舒刘胜吴锋海陈正祝晓潭徐加明
Owner UNION MOBILE PAY