CN109460409A - Data access method and device - Google Patents
Data access method and device Download PDFInfo
- Publication number
- CN109460409A CN109460409A CN201811293284.2A CN201811293284A CN109460409A CN 109460409 A CN109460409 A CN 109460409A CN 201811293284 A CN201811293284 A CN 201811293284A CN 109460409 A CN109460409 A CN 109460409A
- Authority
- CN
- China
- Prior art keywords
- data
- major key
- library
- business major
- business
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 61
- 238000003780 insertion Methods 0.000 claims abstract description 10
- 230000037431 insertion Effects 0.000 claims abstract description 10
- 238000004422 calculation algorithm Methods 0.000 claims description 10
- 238000004590 computer program Methods 0.000 claims description 9
- 238000012545 processing Methods 0.000 claims description 9
- 238000013508 migration Methods 0.000 claims description 7
- 230000005012 migration Effects 0.000 claims description 7
- 238000010586 diagram Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 6
- 230000008569 process Effects 0.000 description 6
- 238000005516 engineering process Methods 0.000 description 4
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000013507 mapping Methods 0.000 description 3
- 238000012544 monitoring process Methods 0.000 description 3
- 241000406668 Loxodonta cyclotis Species 0.000 description 2
- 230000008878 coupling Effects 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 238000005192 partition Methods 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 230000009897 systematic effect Effects 0.000 description 1
- 230000007704 transition Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of data access method and device.This method comprises: receiving the data access request for carrying business major key, the business major key includes: any one in the inquiry request to the service data object, insertion request, removal request or update request for identifying the data access request service data object to be accessed, the data access request；According to the business major key, the corresponding data point library of the service data object is determined；The corresponding operational order of the data access request is executed on the data point library.Disperse database operating pressure, improves database performance.
Description
Technical field
The present invention relates to database application technical field more particularly to a kind of data access methods and device.
Background technique
With the continuous development of Internet technology, various abundant in content, interactive websites strong, operation is more personalized and
Application program is come into being.And the database that these websites and application program are required to rear end provides corresponding content support.
Current database technology is based on centralized database, that is, in whole system, only one database exists, institute
Some data are all stored in this database.All users pass through unique database and complete data access process.
However, above-mentioned database operating pressure is larger, it will lead to operating lag or even delay machine and stop servicing.
Summary of the invention
The present invention provides a kind of data access method and device, presses in the prior art because centralized database is run to solve
The problem that power is big and causes performance not high.
In a first aspect, the present invention provides a kind of data access method, comprising:
The data access request for carrying business major key is received, the business major key is for identifying the data access request
The service data object to be accessed, the data access request include: to the inquiry request of the service data object, insertion
Request, removal request or update request in any one；
According to the business major key, the corresponding data point library of the service data object is determined；
The corresponding operational order of the data access request is executed on the data point library.
Optionally, described according to the business major key, determine the corresponding data point library of the service data object, comprising:
It whether there is the business major key in inquiry business major key routing table, the business major key routing table is used to indicate:
The business major key of each service data object and the data of each service data object of storage divide the corresponding relationship between library；
If there are the business major key in the business major key routing table, by the business major key routing table with it is described
Library is divided as the data in the corresponding data point library of business major key.
Optionally, the data access method, further includes:
If the business major key is not present in the business major key routing table, the business is determined using preset algorithm
The corresponding data of major key divide library, and the corresponding relationship of the business major key and the data point library is added to the business major key
In routing table.
It is optionally, described that the corresponding data point library of the business major key is determined using preset algorithm, comprising:
The data for searching business major key minimum number from all data point libraries divide library；
Divide library for the data point library of the business major key minimum number as the corresponding data of the business major key.
Optionally, after the step of determining the service data object corresponding data point library, the data access side
Method further include:
The counting of business major key corresponding to the data point library is updated, the business major key counting is used to indicate the data
Divide the quantity of business major key corresponding to library.
Optionally, after the step of executing the corresponding operational order of the data access request on the data point library,
The data access method further include:
The performance count in the data point library is updated, the performance count is used to indicate accessed time in the data point library
Number.
Optionally, the data access method further include:
Obtain the performance count in each data point library；
Do Data Migration processing in the data point library for being more than preset threshold to performance count.
Second aspect, the present invention provide a kind of data access device, comprising: receiving module carries business for receiving
The data access request of major key, the business major key is for identifying the data access request business datum pair to be accessed
As, the data access request includes: the inquiry request to the service data object, insertion request, removal request or more
Newly any one in request；
Determining module, for determining the corresponding data point library of the service data object according to the business major key；
Processing module, for executing the corresponding operational order of the data access request on the data point library.
Optionally, the determining module, comprising:
Enquiry module, for whether there is the business major key, business major key road in inquiry business major key routing table
It is used to indicate by table: between the business major key of each service data object and the data point library of each service data object of storage
Corresponding relationship；
First determination unit, if for there are the business major keys in the business major key routing table, by the business
Library is divided as the data in data point library corresponding with the business major key in major key routing table.
Optionally, the determining module, further includes:
Second determination unit, if for the business major key to be not present in the business major key routing table, using default
Algorithm determine the corresponding data point library of the business major key, and the business major key and the data are divided to the corresponding relationship in library
It is added in the business major key routing table.
Optionally, second determination unit, specifically for dividing lookup business major key minimum number in library from all data
Data divide library；
Divide library for the data point library of the business major key minimum number as the corresponding data of the business major key.
Optionally, described device, further includes:
First update module counts, the business major key meter for updating business major key corresponding to the data point library
Number is used to indicate the quantity of business major key corresponding to the data point library.
Optionally, described device, further includes:
Second update module, for updating the performance count in the data point library, the performance count is used to indicate described
The number that data divide library accessed.
Optionally, described device, further includes:
Module is obtained, for obtaining the performance count in each data point library；
Data Migration processing is done in transferring module, the data point library for being more than preset threshold to performance count.
The third aspect, the present invention provide a kind of computer readable storage medium, are stored thereon with computer program, the meter
Calculation machine program realizes above-mentioned data access method when being executed by processor.
Fourth aspect, the present invention provide a kind of electronic equipment, comprising:
Processor；And
Memory, for storing the executable instruction of the processor；
Wherein, the processor is configured to realize above-mentioned data access method via the executable instruction is executed.
Data access method and device provided in this embodiment, after receiving data access request, from the data access
The business major key for the service data object to be accessed is obtained in request, and then is determined according to the business major key and stored corresponding business
The data of data object divide library, and then connect the database, divide on library in the data and execute the corresponding operation of data access request
Instruction, has dispersed database operating pressure, has improved database performance.
Detailed description of the invention
Fig. 1 is the flow chart of the embodiment one of data access method provided by the invention；
Fig. 2 is the flow chart of the embodiment two of data access method provided by the invention；
Fig. 3 is another flow chart of the embodiment two of data access method provided by the invention；
Fig. 4 is the flow chart of the embodiment three of data access method provided by the invention；
Fig. 5 is another flow chart of the embodiment three of data access method provided by the invention；
Fig. 6 is the structural schematic diagram of the embodiment one of data access device provided by the invention；
Fig. 7 is the structural schematic diagram of the embodiment two of data access device provided by the invention；
Fig. 8 is the system schematic of data access method provided by the invention；
Fig. 9 is the hardware structural diagram of server provided by the invention.
Specific embodiment
In order to make the object, technical scheme and advantages of the embodiment of the invention clearer, below in conjunction with the embodiment of the present invention
In attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is
A part of the embodiment of the present invention, instead of all the embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art
Every other embodiment obtained without creative efforts, shall fall within the protection scope of the present invention.
Current database technology is based on centralized database, that is, in whole system, only one database exists, institute
Some data are all stored in this database.User passes through this to the access process of all business objects stored in system
Single database is completed.It is clear that the pressure of database can be very big under this mode, operating lag is easily caused, even
Delay machine and stop servicing.
The present invention provides a kind of data access method and device, and database is divided into multiple data point libraries, pre-establishes this
Data divide the routing relation in library and business major key, when receiving the data access request of carrying business major key of user's input,
It determines that data corresponding with the business major key divide library according to the business major key and above-mentioned routing relation, and then divides on library in the data
Execute the corresponding operational order of data access.Compared to the prior art, the operating pressure for having dispersed centralized database reduces hair
A possibility that raw operating lag and delay machine.
How to be solved with technical solution of the specifically embodiment to technical solution of the present invention and the application below above-mentioned
Technical problem is described in detail.These specific embodiments can be combined with each other below, for the same or similar concept
Or process may repeat no more in certain embodiments.Below in conjunction with attached drawing, the embodiment of the present invention is described.
Fig. 1 is the flow chart of the embodiment one of data access method provided by the invention.As shown in Figure 1, the present embodiment mentions
The data access method of confession, comprising:
S101, reception carry the data access request of business major key, and the business major key is visited for identifying the data
Ask the request service data object to be accessed, the data access request includes: to ask to the inquiry of the service data object
Any one asked, be inserted into request, removal request or update request；
Wherein, the business major key of service data object has uniqueness, i.e., different service data objects has different industry
Business major key.It optionally, can be using the number of client or order number as business major key.
Wherein, data access request can be the inquiry request to service data object, can be for service data object
Insertion request, can be can also to be requested for the update to service data object to the removal request of service data object.
S102, according to the business major key, determine the corresponding data point library of the service data object；
Optionally, the mapping relations that can pre-establish business major key and data point library obtain current data access in S101
After the business major key carried in request, data corresponding with the business major key can be obtained according to above-mentioned mapping relations and divide library, and will
The data point library is determined as storing the data point library for the service data object that the business major key is identified.
S103, the corresponding operational order of the data access request is executed on the data point library.
Wherein, when data access request is the inquiry request to service data object, S103 specifically: in the data
Divide on library and inquiry operation is executed to the service data object；When data access request is the insertion request to service data object
When, S103 specifically: divide on library in the data and insertion operation is executed to the service data object；When data access request is
When to the removal request of service data object, S103 specifically: divide on library in the data and the service data object is executed
Delete operation；When data access request is the update request to service data object, S103 specifically: divide library in the data
On to the service data object execute update operation.
As an example it is assumed that data access request is the inquiry request to service data object A, the process of S101-S103
For example: the inquiry request to service data object A for receiving user's input extracts business datum pair from the inquiry request
As the business major key of A, it is assumed that be 201810001, according to the business major key and the mapping relations pre-established, determine with
201810001 corresponding data divide library, that is, store the data point library of service data object A, it is assumed that divide library 1 for data, finally
Divide on library 1 inquiry operation executed to data object A in the data.
Since all business datums are respectively stored in different data point according to specific classifying rules by the present embodiment
In library, when user needs to access to specific service data object, directly according to the corresponding industry of the service data object
The data that business major key inquiry stores the service data object divide library, and then divide on library in the data and execute corresponding operation instruction,
The pressure for having dispersed centralized database in the prior art reduces and generates operating lag and a possibility that the problems such as delay machine.
In addition, in an embodiment of the present invention, after receiving data access request, judging in the data access request
Whether business major key is empty.If the business major key in the data access request is not sky, above method step S101- is executed
S103；If the business major key in the data access request is sky, the data access request is distributed to all data point
Library divides library to execute associated data operation instruction, and after all data manipulations completion, merges all data by all data
Divide the result set in library.
Data access method provided in this embodiment, after receiving data access request, from the data access request
The business major key for the service data object to be accessed is obtained, and then is determined according to the business major key and stores corresponding business datum pair
The data of elephant divide library, and then connect the database, divide on library in the data and execute the corresponding operational order of data access request, point
Database operating pressure has been dissipated, database performance is improved.
Fig. 2 is the flow chart of the embodiment two of data access method provided by the invention.As shown in Fig. 2, the present embodiment is
Further to the description of the achievable mode of S102 in above-described embodiment, as shown in Fig. 2, data access side provided in this embodiment
Method, comprising:
S201, reception carry the data access request of business major key, and the business major key is visited for identifying the data
Ask the request service data object to be accessed, the data access request includes: to ask to the inquiry of the service data object
Any one asked, be inserted into request, removal request or update request.
Wherein, the implementation of S201 is referring to S101 in above-described embodiment, and details are not described herein by the present invention.
It whether there is the business major key in S202, inquiry business major key routing table.
Wherein, the business major key routing table is used to indicate: the business major key of each service data object and storage are each
The data of service data object divide the corresponding relationship between library.
If there are the business major keys in S203, the business major key routing table, will be in the business major key routing table
Library is divided as the data in data point library corresponding with the business major key.
For example, through inquiring, the corresponding data point library in above-mentioned routing table of business major key 201810001 is data point
Library 1 then shows that the corresponding service data object of business major key 201810001 is stored in data point library 1, subsequent in the data point
Corresponding operation is carried out to the service data object in library 1.
S204, the corresponding operational order of the data access request is executed on the data point library.
Wherein, the implementation of S204 can be found in S103 in above-described embodiment, and details are not described herein by the present invention.
It is shown in Figure 3, in order to record the accessed number in each data point library, method provided by the embodiment, further includes:
S205, the performance count that the data divide library is updated, it is interviewed that the performance count is used to indicate the data point library
The number asked.
Optionally, performance count area can be configured in the example information table that each data divide library, for characterizing corresponding number
The number being accessed according to library.When some data point library is accessed by another, the performance count in the data point library can be added one, with
Make that the performance count in the data point library always show is newest access total degree.
S206, the performance count that each data divide library is obtained；
Data Migration processing is done in S207, the data point library for being more than preset threshold to performance count.
Optionally, the accessed number in each data point library can be monitored in real time, when time that some data divides library accessed
When number is more than preset threshold, the data stored in the data point library can be adjourned on reserved high-performance point library.
Data access method provided in this embodiment describes a kind of achievable mode in determining data point library, i.e., logical
Pre-stored business major key routing table is crossed to inquire the corresponding data point library of the business major key.It is held on data point library to be subsequent
The step of row respective operations instruct provides foundation.
Fig. 4 is the flow chart of the embodiment three of data access method provided by the invention.The present embodiment is further to upper
The description of mode can be achieved in the another kind for stating S102 in embodiment, as shown in figure 4, data access method provided in this embodiment,
Include:
S401, reception carry the data access request of business major key, and the business major key is visited for identifying the data
Ask the request service data object to be accessed, the data access request includes: to ask to the inquiry of the service data object
Any one asked, be inserted into request, removal request or update request.
It whether there is the business major key in S402, inquiry business major key routing table.
Wherein, the implementation of S401-S402 is similar with S201-S202 in above-described embodiment, and the present invention is no longer superfluous herein
It states.
If the business major key is not present in S403, the business major key routing table, institute is determined using preset algorithm
The corresponding data point library of business major key is stated, and the corresponding relationship of the business major key and the data point library is added to the industry
In major key routing table of being engaged in.
In general, in the case where the data access request of user's input is insertion request, in business major key routing table
It is that can not find the corresponding business major key of the service data object being inserted.At this moment, the insertion that can be inputted according to user is requested
The business major key for the service data object of middle carrying being inserted, is calculated using preset algorithm and is inserted into for storing this
The data of service data object divide library.
Optionally, the achievable mode in the corresponding data point library of the business major key is determined using preset algorithm are as follows: from
The data for searching business major key minimum number in all data point libraries divide library；Divide the data of the business major key minimum number to library
Divide library as the corresponding data of the business major key.
S404, the corresponding operational order of the data access request is executed on the data point library.
Wherein, the implementation of S404 can be found in S103 in above-described embodiment, and details are not described herein by the present invention.
It is shown in Figure 5, in order to get the currently stored service data object total quantity in each data point library,
Data access method provided in this embodiment, after S403, further includes:
S403 ', the update data divide business major key corresponding to library to count, and the business major key counting is used to indicate institute
State the quantity of business major key corresponding to data point library.
Optionally, can in the example information table that each data divide library configuration service major key count area, for characterize pair
The quantity for the business major key for answering database to be stored.It, can when some data point library is inserted into a new service data object
Divide the business major key in library to count plus one the data so that the business major key in the data point library count always show be update after
Quantity.
Data access method provided in this embodiment describes the achievable mode of another kind in determining data point library, i.e.,
When inquired in business major key routing table less than business major key entrained in current data access request, according to the business major key
Corresponding data point library is determined using preset algorithm, and the corresponding service data object of business major key is stored in the database
In, while the corresponding relationship of the business major key and data point library being added in business major key routing table, so that access next time should
When service data object, library can be divided to corresponding data by business major key routing table lookup.On the other hand, by updating institute
It states the business object that data point library stored to count, the business object in data point library can be made to count, and always show is business datum
The quantity of object be updated after quantity.
Fig. 6 is the structural schematic diagram of the embodiment one of data access device provided by the invention.As shown in fig. 6, this implementation
The data access device that example provides, comprising:
Receiving module 601, for receiving the data access request for carrying business major key, the business major key is for identifying
The data access request service data object to be accessed, the data access request include: to the business datum pair
The inquiry request of elephant, any one being inserted into request, removal request or update request；
Determining module 602, for determining the corresponding data point library of the service data object according to the business major key；
Processing module 603, for executing the corresponding operational order of the data access request on the data point library.
Data access device provided in this embodiment can be used for executing the method in embodiment illustrated in fig. 1, realization principle
Similar with technical effect, details are not described herein.
Fig. 7 is the structural schematic diagram of the embodiment two of data access device provided by the invention.As shown in fig. 7, this implementation
The data access device that example provides, the determining module 602, comprising:
Enquiry module 701, for whether there is the business major key, the business major key in inquiry business major key routing table
Routing table is used to indicate: between the business major key of each service data object and the data point library of each service data object of storage
Corresponding relationship；
First determination unit 702, if for there are the business major keys in the business major key routing table, by the industry
Library is divided as the data in data point library corresponding with the business major key in business major key routing table.
Optionally, the determining module 602, further includes:
Second determination unit 703, if for the business major key to be not present in the business major key routing table, using pre-
If algorithm determine the corresponding data point library of the business major key, and divide the corresponding of library to close the business major key and the data
System is added in the business major key routing table.
Optionally, second determination unit 703, which is specifically used for dividing in library from all data, searches business major key quantity most
Few data divide library；
Divide library for the data point library of the business major key minimum number as the corresponding data of the business major key.
The data access device that embodiment provides, further includes:
First update module 704 counts, the business major key for updating business major key corresponding to the data point library
Count the quantity for being used to indicate business major key corresponding to the data point library.
Optionally, data access device provided in this embodiment, further includes:
Second update module 705, for updating the performance count in the data point library, the performance count is used to indicate institute
State the accessed number in data point library.
Optionally, data access device provided in this embodiment, further includes:
Module 706 is obtained, for obtaining the performance count in each data point library；
Data Migration processing is done in transferring module 707, the data point library for being more than preset threshold to performance count.
Data access device provided in this embodiment can be used for executing the method in Fig. 2-embodiment illustrated in fig. 5, realize
Principle is similar with technical effect, and details are not described herein.
Fig. 8 is the system schematic of data access method provided by the invention.System shown in Figure 8 includes multiple composition portions
Point, be respectively as follows: data access service module, primary database, management console, capacity and performance monitoring process, DDL go on patrol into
Journey, several points of libraries (Fig. 8 with point library 1, point library 2 ..., divide library N to illustrate).
Wherein, data access service module can be used for executing the method in any embodiment shown in Fig. 1-Fig. 5.Correspondingly,
Data access device shown in Fig. 6 and Fig. 7 is the corresponding device of data access service module.
Wherein, as shown in figure 8, data access service module is connect with the application program to be serviced, which can
To be that any required backstage provides the application program of data support, such as insurance business systematic difference program；The application program
It can be carried in the equipment such as desktop computer, notebook, smart phone or tablet computer.User passes through the application triggers number
According to access request, data access service module can find corresponding data point library according to the business major key carried in the request, into
And corresponding operational order is completed on the data point library, disperse centralized database operating pressure, improves database performance.
Specific implementation process can be described in detail in the following embodiments.
As shown in figure 8, primary database is connected with data access service module, it is required when for saving present invention operation
Configuration information.Such as: divide library definition, the routing of business major key and DDL old version record etc..It is defined about a point library, can use and divide
The formal definition of library example information table divides library, in point library example information table each point library record all have recorded one it is deployed
Data divide library, each point library record may include following necessary field:
1, ID: one, data point library data divide the unique identification in library.
2, access driver title: database access driver is the data base abstraction that can be instantiated a driving journey
The subclass of sequence class, development language that database access driver title uses when implementing according to the present invention and have different performances
Form.Such as: in .NET platform, database access driver name is configured as " SYSTEM.DATA.SQLCLIENT ".
3, connection string: matching according to database access driver, is connected to the connection in the data point library
Character string.
4, state: including in online, offline and migration.
5, version number: the version number of data structure in the data point library is recorded.
6, business datum major key counts: the data volume of the service data object saved in data point library.
7, performance count: the number for dividing library accessed for characterize data.
8, capacity: data divide the data capacity in library.
9, remaining space: data divide the database remaining space in library.
It is routed about business major key, routing relation, the routing of business major key can be saved with the form of business major key routing table
Table is the corresponding table of business major key with data point library ID.May include following field:
1, business major key: the primary identity of a service data object.
2, the ID in data point library: being used to indicate different business data object and be specifically stored in which data point library, association
In the ID divided in the example information table of library.
3, Obj State: in normal and migration.
4, last access time.
5, number of operations counts.
It is recorded about DDL old version, which records for recording in this system and data structure definition
Related operational order history.It is executed by the sequence of these operational orders, the data structure in data point library can be synchronized to most
New state.DDL old version record sheet may include following field:
1, DDL version number: the integer of sequence can all be registered as a new version when executing DDL sentence every time.
2, DDL command context: big content of text records the order of the secondary DDL.
Management console in Fig. 8 is for completing the definition of data point library, the status inquiry of data point library and DDL order publication
Function.The DDL order that one will execute total data point library can be enrolled into DDL history version by the issuing function of DDL order
In this record sheet, used for DDL patrol program.
DDL patrol program in Fig. 8 is the program that a timing executes.Its function is to check that each data point library records
In, whether version number is less than current registered maximum DDL version.As some data divides the version number in library maximum less than current
Version number, then executing the DDL order having not carried out, sequentially on the data point library the data are divided the database knot in library
Structure is updated to last state.
Capacity and performance monitoring process in Fig. 8 are the programs being periodically executed.Its function is that tours of inspection is all
Data divide the performance and easy parameter in library, and update dividing in the example information table of library into primary database.In some business major keys
Divide in the strategy of library, these performance capability data will be used to balance the performance pressures of each database.As a function of the invention
Can extension, monitoring process can be when Dynamic Discovery database access amount be excessive or the access temperature mistake of certain business major key
Gao Shi, the transition process of automatic starting overheat data object, for example data are adjourned on reserved high-performance point library etc..
Fig. 9 is the hardware structural diagram of electronic equipment provided by the invention.As shown in figure 9, the electronics of the present embodiment is set
It is standby to may include:
Memory 901, for storing program instruction.
The processor 902, for being performed the data for realizing any of the above-described embodiment description in described program instruction
Access method, specific implementation principle can be found in above-described embodiment, and details are not described herein again for the present embodiment.
The present invention provides a kind of computer readable storage medium, is stored thereon with computer program, the computer program
Data access method described in any of the above-described embodiment is realized when being executed by processor.
The present invention also provides a kind of program product, described program product includes computer program, and the computer program is deposited
In readable storage medium storing program for executing, at least one processor can read the computer program, institute from the readable storage medium storing program for executing for storage
State at least one processor execute the computer program make electronic equipment implement data described in any of the above-described embodiment visit
Ask method.
In several embodiments provided by the present invention, it should be understood that disclosed device and method can pass through it
Its mode is realized.For example, the apparatus embodiments described above are merely exemplary, for example, the division of the unit, only
Only a kind of logical function partition, there may be another division manner in actual implementation, such as multiple units or components can be tied
Another system is closed or is desirably integrated into, or some features can be ignored or not executed.Another point, it is shown or discussed
Mutual coupling, direct-coupling or communication connection can be through some interfaces, the INDIRECT COUPLING or logical of device or unit
Letter connection can be electrical property, mechanical or other forms.
The unit as illustrated by the separation member may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
In network unit.It can select some or all of unit therein according to the actual needs to realize the mesh of this embodiment scheme
's.
It, can also be in addition, the functional units in various embodiments of the present invention may be integrated into one processing unit
It is that each unit physically exists alone, can also be integrated in one unit with two or more units.Above-mentioned integrated list
Member both can take the form of hardware realization, can also realize in the form of hardware adds SFU software functional unit.
Finally, it should be noted that the above embodiments are only used to illustrate the technical solution of the present invention., rather than its limitations；To the greatest extent
Pipe present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that: its according to
So be possible to modify the technical solutions described in the foregoing embodiments, or to some or all of the technical features into
Row equivalent replacement；And these are modified or replaceed, various embodiments of the present invention technology that it does not separate the essence of the corresponding technical solution
The range of scheme.
Claims (10)
1. a kind of data access method characterized by comprising
The data access request for carrying business major key is received, the business major key is wanted for identifying the data access request
The service data object of access, the data access request include: to ask to the inquiry request of the service data object, insertion
Ask, removal request or update request in any one；
According to the business major key, the corresponding data point library of the service data object is determined；
The corresponding operational order of the data access request is executed on the data point library.
2. determining the business number the method according to claim 1, wherein described according to the business major key
Divide library according to the corresponding data of object, comprising:
It whether there is the business major key in inquiry business major key routing table, the business major key routing table is used to indicate: each
The business major key of service data object and the data of each service data object of storage divide the corresponding relationship between library；
If there are the business major key in the business major key routing table, by the business major key routing table with the business
Library is divided as the data in the corresponding data point library of major key.
3. according to the method described in claim 2, it is characterized in that, the method also includes:
If the business major key is not present in the business major key routing table, the business major key is determined using preset algorithm
Corresponding data divide library, and the corresponding relationship of the business major key and the data point library is added to the business major key and is routed
In table.
4. according to the method described in claim 3, it is characterized in that, described determine the business major key pair using preset algorithm
The data point library answered, comprising:
The data for searching business major key minimum number from all data point libraries divide library；
Divide library for the data point library of the business major key minimum number as the corresponding data of the business major key.
5. the method according to claim 3 or 4, which is characterized in that determining the corresponding data of the service data object
After the step of dividing library, the data access method further include:
The counting of business major key corresponding to the data point library is updated, the business major key counting is used to indicate the data point library
The quantity of corresponding business major key.
6. the method according to one of claim requirement 2-4, which is characterized in that execute institute on the data point library
After the step of stating data access request corresponding operational order, the data access method further include:
The performance count in the data point library is updated, the performance count is used to indicate the accessed number in the data point library.
7. according to the method described in claim 6, it is characterized in that, the method also includes:
Obtain the performance count in each data point library；
Do Data Migration processing in the data point library for being more than preset threshold to performance count.
8. a kind of data access device characterized by comprising
Receiving module, for receiving the data access request for carrying business major key, the business major key is for identifying the number
The service data object to be accessed according to access request, the data access request include: to look into the service data object
Ask any one in request, insertion request, removal request or update request；
Determining module, for determining the corresponding data point library of the service data object according to the business major key；
Processing module, for executing the corresponding operational order of the data access request on the data point library.
9. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program quilt
Claim 1-7 described in any item methods are realized when processor executes.
10. a kind of electronic equipment characterized by comprising
Processor；And
Memory, for storing the executable instruction of the processor；
Wherein, the processor is configured to realize that claim 1-7 is described in any item via the executable instruction is executed
Method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811293284.2A CN109460409A (en) | 2018-11-01 | 2018-11-01 | Data access method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811293284.2A CN109460409A (en) | 2018-11-01 | 2018-11-01 | Data access method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109460409A true CN109460409A (en) | 2019-03-12 |
Family
ID=65609107
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811293284.2A Pending CN109460409A (en) | 2018-11-01 | 2018-11-01 | Data access method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109460409A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109981767A (en) * | 2019-03-20 | 2019-07-05 | 浪潮商用机器有限公司 | HANA data bank access method, device, system, equipment and storage medium |
| CN110362553A (en) * | 2019-06-17 | 2019-10-22 | 平安普惠企业管理有限公司 | High-volume collage-credit data processing method, electronic device and computer equipment |
| CN112598327A (en) * | 2020-12-31 | 2021-04-02 | 平安银行股份有限公司 | Service processing system, method, device and storage medium |
| CN113778997A (en) * | 2021-09-26 | 2021-12-10 | 杭州安恒信息技术股份有限公司 | Database version management method, system and equipment |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104333512A (en) * | 2014-10-30 | 2015-02-04 | 北京思特奇信息技术股份有限公司 | Distributed memory database access system and method |
| CN106055587A (en) * | 2016-05-21 | 2016-10-26 | 乐视控股（北京）有限公司 | Partitioning database system and routing method thereof |
| CN106802932A (en) * | 2016-12-28 | 2017-06-06 | 华为技术有限公司 | A kind of method for routing of database, device and Database Systems |
| US20170161327A1 (en) * | 2015-12-04 | 2017-06-08 | Dell Software, Inc. | Distributed database driver middleware |
| CN106815218A (en) * | 2015-11-27 | 2017-06-09 | 华为技术有限公司 | Data bank access method, device and Database Systems |
| CN106933891A (en) * | 2015-12-31 | 2017-07-07 | 华为技术有限公司 | Access the method for distributed data base and the device of Distributed database service |
-
2018
- 2018-11-01 CN CN201811293284.2A patent/CN109460409A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104333512A (en) * | 2014-10-30 | 2015-02-04 | 北京思特奇信息技术股份有限公司 | Distributed memory database access system and method |
| CN106815218A (en) * | 2015-11-27 | 2017-06-09 | 华为技术有限公司 | Data bank access method, device and Database Systems |
| US20170161327A1 (en) * | 2015-12-04 | 2017-06-08 | Dell Software, Inc. | Distributed database driver middleware |
| CN106933891A (en) * | 2015-12-31 | 2017-07-07 | 华为技术有限公司 | Access the method for distributed data base and the device of Distributed database service |
| CN106055587A (en) * | 2016-05-21 | 2016-10-26 | 乐视控股（北京）有限公司 | Partitioning database system and routing method thereof |
| CN106802932A (en) * | 2016-12-28 | 2017-06-06 | 华为技术有限公司 | A kind of method for routing of database, device and Database Systems |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109981767A (en) * | 2019-03-20 | 2019-07-05 | 浪潮商用机器有限公司 | HANA data bank access method, device, system, equipment and storage medium |
| CN110362553A (en) * | 2019-06-17 | 2019-10-22 | 平安普惠企业管理有限公司 | High-volume collage-credit data processing method, electronic device and computer equipment |
| CN110362553B (en) * | 2019-06-17 | 2023-09-15 | 爱云保(上海)科技有限公司 | Method for processing large-batch credit investigation data, electronic device and computer equipment |
| CN112598327A (en) * | 2020-12-31 | 2021-04-02 | 平安银行股份有限公司 | Service processing system, method, device and storage medium |
| CN113778997A (en) * | 2021-09-26 | 2021-12-10 | 杭州安恒信息技术股份有限公司 | Database version management method, system and equipment |
| CN113778997B (en) * | 2021-09-26 | 2024-02-02 | 杭州安恒信息技术股份有限公司 | Database version management method, system and equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109460409A (en) | Data access method and device | |
| US6832299B2 (en) | System and method for assigning storage in a storage network in accordance with stored management information | |
| CN1517885B (en) | Method and system for updating central cache by atomicity | |
| US9280370B2 (en) | System structure management device, system structure management method, and program | |
| CN102609488B (en) | Client, data query method of client, server and data query system | |
| CN106970958B (en) | A kind of inquiry of stream file and storage method and device | |
| CN104067216A (en) | System and method for implementing a scalable data storage service | |
| CN105631035B (en) | Date storage method and device | |
| CN104424287B (en) | Data query method and apparatus | |
| CN101131697A (en) | System and method for moving records between partitions | |
| CN109684282A (en) | A kind of method and device constructing metadata cache | |
| CN105701112A (en) | Data processing method, apparatus and system | |
| CN110134681B (en) | Data storage and query method and device, computer equipment and storage medium | |
| EP2965492B1 (en) | Selection of data storage settings for an application | |
| CN109388351A (en) | A kind of method and relevant apparatus of Distributed Storage | |
| CN108319608A (en) | The method, apparatus and system of access log storage inquiry | |
| CN103455335A (en) | Multilevel classification Web implementation method | |
| EP1909170B1 (en) | Method and system for automatically generating a communication interface | |
| US8005844B2 (en) | On-line organization of data sets | |
| JP5332488B2 (en) | Map-based communication of multiple functional entities | |
| US8386953B1 (en) | Accordion user interface | |
| KR100658299B1 (en) | Method for monitoring telecommunication network performance based on web corresponding to change database structure | |
| CN111680069A (en) | Database access method and device | |
| CN109582697A (en) | Multilist dynamically associates querying method, device, server and storage medium | |
| CN110119427A (en) | Data managing method and Related product |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190312 |