CN108052569A - Data bank access method, device, computer readable storage medium and computing device - Google Patents
Data bank access method, device, computer readable storage medium and computing device Download PDFInfo
- Publication number
- CN108052569A CN108052569A CN201711286353.2A CN201711286353A CN108052569A CN 108052569 A CN108052569 A CN 108052569A CN 201711286353 A CN201711286353 A CN 201711286353A CN 108052569 A CN108052569 A CN 108052569A
- Authority
- CN
- China
- Prior art keywords
- data
- shared drive
- base querying
- local device
- data base
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/901—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/54—Interprogram communication
- G06F9/544—Buffers; Shared memory; Pipes
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to database fields, provide a kind of data bank access method, device, computer readable storage medium and computing device, to improve the whole access efficiency of database.The described method includes：When servicing startup, by the shared drive of the Data Migration in disk database to local device；Monitoring data library inquiry is asked；It is asked according to data base querying, the data of data base querying request institute requesting query is obtained from shared drive；If getting the data of data base querying request institute requesting query from shared drive, the data got from shared drive are handled.On the one hand technical solution provided by the invention greatly reduces the time overhead of network I/O；On the other hand, by the way that the data of hit institute requesting query is gone the time overhead of magnetic disc i/o to be eliminated, without visiting again disk so as to the whole access efficiency for improving database from memory.
Description
Technical field
The invention belongs to database field more particularly to a kind of data bank access method, device, computer-readable storage mediums
Matter and computing device.
Background technology
Database is to be long-term stored at interior, organized, the sharable data acquisition system of computer.Data in database refer to
Be with certain data model tissue, description and storage together with, have redundancy as small as possible, higher Dynamic data exchange
The characteristics of property and expansibility can be simultaneously multiple users to share within the specific limits.Existing Database Systems are come from storage medium
Dividing includes disk database (Disk Resident Database, DRDB) and memory database (MainMemory
Database, MMDB), wherein, the primary copy of the data of DRDB is on disk, and data base management system to application system in order to carry
For access service, the data accessed is needed to be fitted into main memory user, i.e., be " the caching skill based on disk to the management of data
Art ", and in MMDB, the data of whole or the active transaction access of database are put in memory, in this way, access of the affairs to disk
It fully phases out.
It is well known that disk is the storage medium of extremely low speed for main memory, and disk access speed also and is intended to
The physical location of the data of access is related with current magnetic head state.In addition, either in operating system (OS) layer or database
System layer, management caching (cache) or buffering (buffer) are managed, is required for paying larger cost (time and/or space generation
Valency, especially using time cost as very).And for MMDB, in device powers down, data will lose, and data capacity is limited by main memory size
System can not realize that active and standby machine is synchronous, and can not be with relevant database cooperating in the market.
In conclusion existing disk database and memory database respectively have its inherent shortcoming.
The content of the invention
The present invention provides a kind of data bank access method, device, computer readable storage medium and computing device, to improve
The whole access efficiency of database.
First aspect present invention provides a kind of data bank access method, the described method includes：
When servicing startup, by the shared drive of the Data Migration in disk database to local device；
Monitoring data library inquiry is asked；
It is asked according to the data base querying, the data base querying request institute requesting query is obtained from the shared drive
Data；
If getting the data of data base querying request institute requesting query from the shared drive, to from described common
The data that memory is got are enjoyed to be handled.
It is described when servicing startup in the first embodiment of first aspect with reference to first aspect present invention, by magnetic
Data Migration in disk database to local device shared drive, including：
Model data in the disk database is loaded onto to the shared drive of the local device；
It is established in the shared drive of the local device corresponding with the field index of tables of data in the disk database
Index.
It is described to be looked into according to the database in second of embodiment of first aspect with reference to first aspect present invention
Request is ask, the data of the data base querying request institute requesting query are obtained from the shared drive, including：
Judge whether the data of the data base querying request institute requesting query are located at the shared drive of the local device；
If the data of the data base querying request institute requesting query are located at the shared drive of the local device, by institute
It states shared drive and maps to consumer process space, the data base querying request institute is inquired about from the shared drive of the local device
The data of requesting query.
It is described in the third embodiment of first aspect with reference to second of embodiment of first aspect present invention
Method further includes：
If the data of data base querying request institute requesting query are not in the shared drive of the local device, by institute
Data base querying request is stated to be transmitted to and the corresponding service of data base querying request.
Second aspect of the present invention provides a kind of database access device, and described device includes：
Data Migration module, for service start when, by being total to for the Data Migration in disk database to local device
Enjoy memory；
Monitoring module is asked for monitoring data library inquiry；
For being asked according to the data base querying, the database is obtained from the shared drive for data acquisition module
The data of inquiry request institute requesting query；
Data processing module, if for getting the data base querying request institute requesting query from the shared drive
Data are then handled the data got from the shared drive.
With reference to second aspect of the present invention, in the first embodiment of second aspect, the Data Migration module includes：
Loading unit, for the model data in the disk database to be loaded onto the shared interior of the local device
It deposits；
Unit is established, for being established in the shared drive of the local device and tables of data in the disk database
The corresponding index of field index.
With reference to second aspect of the present invention, in second of embodiment of second aspect, the data acquisition module includes：
Whether judging unit, the data for judging the data base querying request institute requesting query set positioned at the local
Standby shared drive；
Query unit, if the data for data base querying request institute requesting query are located at being total to for the local device
Memory is enjoyed, then the shared drive is mapped into consumer process space, the number is inquired about from the shared drive of the local device
According to the data of library inquiry request institute requesting query.
It is described in the third embodiment of second aspect with reference to second of embodiment of second aspect of the present invention
Device includes：
Forwarding module, if data not being total in the local device for data base querying request institute requesting query
Memory is enjoyed, then is transmitted to data base querying request and the corresponding service of data base querying request.
Third aspect present invention provides a kind of computing device, including memory, processor and storage in memory
And the computer program that can be run on a processor, processor realize following steps when performing computer program：
When servicing startup, by the shared drive of the Data Migration in disk database to local device；
Monitoring data library inquiry is asked；
It is asked according to the data base querying, the data base querying request institute requesting query is obtained from the shared drive
Data；
If getting the data of data base querying request institute requesting query from the shared drive, to from described common
The data that memory is got are enjoyed to be handled.
It is described when servicing startup in the first embodiment of the third aspect with reference to third aspect present invention, by magnetic
Data Migration in disk database to local device shared drive, including：
Model data in the disk database is loaded onto to the shared drive of the local device；
It is established in the shared drive of the local device corresponding with the field index of tables of data in the disk database
Index.
It is described to be looked into according to the database in second of embodiment of the third aspect with reference to third aspect present invention
Request is ask, the data of the data base querying request institute requesting query are obtained from the shared drive, including：
Judge whether the data of the data base querying request institute requesting query are located at the shared drive of the local device；
If the data of the data base querying request institute requesting query are located at the shared drive of the local device, by institute
It states shared drive and maps to consumer process space, the data base querying request institute is inquired about from the shared drive of the local device
The data of requesting query.
It is described in the third embodiment of the third aspect with reference to second of embodiment of third aspect present invention
Method further includes：
If the data of data base querying request institute requesting query are not in the shared drive of the local device, by institute
Data base querying request is stated to be transmitted to and the corresponding service of data base querying request.
The fourth aspect of the embodiment of the present invention provides a kind of computer readable storage medium, computer readable storage medium
The step of being stored with computer program, following methods realized when computer program is executed by processor：
When servicing startup, by the shared drive of the Data Migration in disk database to local device；
Monitoring data library inquiry is asked；
It is asked according to the data base querying, the data base querying request institute requesting query is obtained from the shared drive
Data；
If getting the data of data base querying request institute requesting query from the shared drive, to from described common
The data that memory is got are enjoyed to be handled.
It is described when servicing startup in the first embodiment of fourth aspect with reference to fourth aspect present invention, by magnetic
Data Migration in disk database to local device shared drive, including：
Model data in the disk database is loaded onto to the shared drive of the local device；
It is established in the shared drive of the local device corresponding with the field index of tables of data in the disk database
Index.
It is described to be looked into according to the database in second of embodiment of fourth aspect with reference to fourth aspect present invention
Request is ask, the data of the data base querying request institute requesting query are obtained from the shared drive, including：
Judge whether the data of the data base querying request institute requesting query are located at the shared drive of the local device；
If the data of the data base querying request institute requesting query are located at the shared drive of the local device, by institute
It states shared drive and maps to consumer process space, the data base querying request institute is inquired about from the shared drive of the local device
The data of requesting query.
It is described in the third embodiment of fourth aspect with reference to second of embodiment of fourth aspect present invention
Method further includes：
If the data of data base querying request institute requesting query are not in the shared drive of the local device, by institute
Data base querying request is stated to be transmitted to and the corresponding service of data base querying request.
It was found from the technical solution that the invention described above provides, by being total to for the Data Migration in disk database to local device
Memory is enjoyed, and is asked according to data base querying, the data of data base querying request institute requesting query are obtained from shared drive, because
This, on the one hand, it can be in the data that local data base inquires i.e. in local data library inquiry, without by network inquiry, greatly
Ground reduces the time overhead of network I/O；On the other hand, the access speed of memory will be significantly faster than the access speed of disk, lead to
Crossing from memory goes the data of hit institute requesting query the time overhead of magnetic disc i/o to be eliminated, without visiting again disk so as to whole
Improve the access efficiency of database.
Description of the drawings
It to describe the technical solutions in the embodiments of the present invention more clearly, below will be to embodiment or description of the prior art
Needed in attached drawing be briefly described, it should be apparent that, the accompanying drawings in the following description be only the present invention some
Embodiment, for those of ordinary skill in the art, can also be according to these attached drawings under the premise of not making the creative labor
Obtain other attached drawings.
Fig. 1 is the realization flow diagram of data bank access method provided in an embodiment of the present invention；
Fig. 2 is the structure diagram of database access device provided in an embodiment of the present invention；
Fig. 3 is the structure diagram for the database access device that another embodiment of the present invention provides；
Fig. 4 is the structure diagram for the database access device that another embodiment of the present invention provides；
Fig. 5 is the structure diagram for the database access device that another embodiment of the present invention provides；
Fig. 6 is the structure diagram of computing device provided in an embodiment of the present invention.
Specific embodiment
In being described below, in order to illustrate rather than in order to limit, it is proposed that such as tool of particular system structure, technology etc
Body details, to understand thoroughly the embodiment of the present invention.However, it will be clear to one skilled in the art that there is no these specifically
The present invention can also be realized in the other embodiments of details.In other situations, omit to well-known system, device, electricity
Road and the detailed description of method, in case unnecessary details interferes description of the invention.
In order to illustrate technical scheme, illustrated below by specific embodiment.
Attached drawing 1 is the realization flow diagram of data bank access method provided in an embodiment of the present invention, mainly including following
Step S101 to S104, it is described further below：
S101, when servicing startup, by the shared drive of the Data Migration in disk database to local device.
It should be noted that can be applied to data volume few for technical scheme, such as power industry, monitoring trade
Etc. industries Database Systems, these data, can be from disk when being migrated from disk database to the shared drive of local device
For bulk migration into shared drive, data volume is usually no more than the main memory size of equipment.Separately it should be noted that, so-called local is set
It is standby, refer to client and server-side be respectively positioned on same server, the client to server-side send data base querying request when,
The same server is exactly local device for client or server-side.
As one embodiment of the invention, when servicing startup, by the Data Migration in disk database to local device
Shared drive can S1011 to step S1012 as follows：
Model data in disk database is loaded onto the shared drive of local device by S1011.
So-called model data is the data with data model (Data Model) to describe, and data model is data spy
Sign it is abstract, data (Data) are to describe the symbol record of things, and model (Model) is the abstract of real world, data model
Static nature, dynamic behaviour and the constraints of system are described from abstraction hierarchy, be Database Systems information represent with
Operation provides an abstract frame, and the described content of data model includes data structure, data manipulation and data constraint
Deng.When the model data in disk database to be loaded onto to the shared drive of local device, directly by model data transformation into
Tables of data, so as to form memory database.
S1012 is established corresponding with the field index of tables of data in disk database in the shared drive of local device
Index.
It is well known conventional wisdom is that, for the convenience of inquiry, the field of tables of data all can there are one index, examples in disk database
As B+ trees index.In embodiments of the present invention, established in the shared drive of local device and tables of data in disk database
The corresponding index of field index, i.e. when the field S of tables of data has index I in disk database, will be in disk database
After Data Migration to the shared drive of local device, also index I is established for field S in the shared drive of local device.
S102, the request of monitoring data library inquiry.
In embodiments of the present invention, a network service can be started, such as TCP services carry out monitored data library inquiry and ask
It asks.
S103 is asked according to data base querying, and obtaining data base querying from the shared drive of local device is asked
The data of inquiry.
It as one embodiment of the invention, is asked according to data base querying, data is obtained from the shared drive of local device
The data of library inquiry request institute requesting query can be realized with S1031 as follows and step S1032：
S1031, judges whether the data of data base querying request institute requesting query are located locally the shared drive of equipment.
It should be noted that in embodiments of the present invention, data base querying request carries the name of the database to be inquired about
Therefore the information such as the title or ID of title or ID and tables of data, can ask these information carried according to data base querying, sentence
Whether the data of disconnected data base querying request institute requesting query are located locally the memory number of the i.e. local device of shared drive of equipment
According to storehouse.
S1032, will be local if the data of data base querying request institute requesting query are located at the shared drive of local device
The shared drive of equipment maps to consumer process space, is asked from the shared drive inquiry data base querying of local device
The data of inquiry.
In embodiments of the present invention, systematic difference routine interface (Application Programming can be called
Interface, API), the shared drive of local device is mapped to by user by the parameter wherein comprising shared drive title
The process space.As previously mentioned, the field index with tables of data in disk database is established in the shared drive of local device
Therefore corresponding index, after the shared drive of local device is mapped to consumer process space, can be indexed according to these, from
The data of the shared drive inquiry data base querying request institute requesting query of local device.
S104 is right if getting the data of data base querying request institute requesting query from the shared drive of local device
The data got from the shared drive of local device are handled.
In embodiments of the present invention, the data got from the shared drive of local device are carried out with processing is included to real-time
The inquiry or modification of database and inquiry or modification to business database etc., wherein, if will to real-time data base, such as
Memory database is changed, then can by the write back data of modification to disk database, when being that the memory database of host is changed,
If desired the database synchronization of host and guest machine then also needs the data of modification being synchronized in the database of guest machine.
It was found from above-mentioned 1 exemplary data bank access method of attached drawing, the Data Migration in disk database is set to local
Standby shared drive, and asked according to data base querying, the number of data base querying request institute requesting query is obtained from shared drive
According to therefore, on the one hand, can in the data that local data base inquires i.e. in local data library inquiry, without by network inquiry,
Greatly reduce the time overhead of network I/O；On the other hand, the access speed of memory will be significantly faster than the access speed of disk
Degree, by the way that the data of hit institute requesting query is gone to eliminate the time overhead of magnetic disc i/o without visiting again disk from memory, from
And the whole access efficiency for improving database.
Fig. 2 is the schematic diagram of database access device provided in an embodiment of the present invention, mainly includes Data Migration module
201st, monitoring module 202, data acquisition module 203 and data processing module 204, detailed description are as follows：
Data Migration module 201, for service start when, by the Data Migration in disk database to local device
Shared drive；
Monitoring module 202 is asked for monitoring data library inquiry；
For being asked according to data base querying, database is obtained from the shared drive of local device for data acquisition module 203
The data of inquiry request institute requesting query；
Data processing module 204, if being asked for getting data base querying from the shared drive of local device
The data of inquiry are then handled the data got from the shared drive of local device.
It should be noted that device provided in an embodiment of the present invention, due to being based on same structure with the method for the present invention embodiment
Think, the technique effect brought is identical with the method for the present invention embodiment, and particular content can be found in the method for the present invention embodiment
Narration, details are not described herein again.
2 exemplary Data Migration module 201 of attached drawing can include loading unit 301 and establish unit 302, as attached drawing 3 shows
The database access device of example, wherein：
Loading unit 301, for the model data in disk database to be loaded onto to the shared drive of local device；
Unit 302 is established, for establishing the field with tables of data in disk database in the shared drive of local device
Index corresponding index.
2 exemplary data acquisition module 203 of attached drawing can include judging unit 401 and query unit 402, as attached drawing 4 shows
The database access device of example, wherein：
Whether judging unit 401, the data for judging data base querying request institute requesting query are located locally equipment
Shared drive；
Query unit 402, if the data for data base querying request institute requesting query are located at the shared interior of local device
It deposits, then the shared drive of local device is mapped into consumer process space, looked into from the shared drive inquiry database of local device
Ask the data of request institute requesting query.
4 exemplary database access device of attached drawing can include forwarding module 501, such as 5 exemplary database access of attached drawing
Device.If forwarding module 501 for data base querying request institute requesting query data not in the shared drive of local device,
Data base querying request is transmitted to and the corresponding service of data base querying request.
Fig. 6 is the structure diagram for the computing device that one embodiment of the invention provides.As shown in fig. 6, the meter of the embodiment
Calculating equipment 6 includes：Processor 60, memory 61 and it is stored in the computer that can be run in memory 61 and on processor 60
Program 62, such as the program of data bank access method.Processor 60 realizes above-mentioned database access when performing computer program 62
Step in embodiment of the method, such as step S101 to S104 shown in FIG. 1.Alternatively, processor 60 performs computer program 62
The function of each module/unit in the above-mentioned each device embodiments of Shi Shixian, such as Data Migration module shown in Fig. 2 201, monitoring module
202nd, the function of data acquisition module 203 and data processing module 204.
Illustratively, the computer program 62 of data bank access method mainly includes：When servicing startup, by data in magnetic disk
Data Migration in storehouse to local device shared drive；Monitoring data library inquiry is asked；It is asked according to data base querying, from this
The shared drive of ground equipment obtains the data of data base querying request institute requesting query；If it is obtained from the shared drive of local device
To the data of data base querying request institute requesting query, then to from being carried out from the data that the shared drive of local device is got
Reason.Computer program 62 can be divided into one or more module/units, one or more module/unit is stored in
It in memory 61, and is performed by processor 60, to complete the present invention.One or more module/units can complete spy
Determine the series of computation machine program instruction section of function, which is used to describe the holding in computing device 6 of computer program 62
Row process.For example, computer program 62 can be divided into Data Migration module 201, monitoring module 202, data acquisition module
203 and the function (module in virtual bench) of data processing module 204, each module concrete function it is as follows：Data Migration module
201, for service start when, by the shared drive of the Data Migration in disk database to local device；Monitoring module
202, it is asked for monitoring data library inquiry；Data acquisition module 203, for being asked according to data base querying, from local device
Shared drive obtain the data of data base querying request institute requesting query；Data processing module 204, if for from local device
Shared drive get the data of data base querying request institute requesting query, then the data got from shared drive are carried out
Processing.
Computing device 6 may include but be not limited only to processor 60, memory 61.It will be understood by those skilled in the art that Fig. 6
The only example of computing device 6 does not form the restriction to computing device 6, can include than illustrating more or fewer portions
Part either combines some components or different components, such as computing device can also include input-output equipment, network connects
Enter equipment, bus etc..
Alleged processor 60 can be central processing unit (Central Processing Unit, CPU), can also be
Other general processors, digital signal processor (Digital Signal Processor, DSP), application-specific integrated circuit
(Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor can also be any conventional processor
Deng.
Memory 61 can be the internal storage unit of computing device 6, such as the hard disk or memory of computing device 6.Storage
Device 61 can also be the plug-in type hard disk being equipped on the External memory equipment of computing device 6, such as computing device 6, intelligent storage
Block (Smart Media Card, SMC), secure digital (Secure Digital, SD) card, flash card (Flash Card) etc..
Further, memory 61 can also both include the internal storage unit of computing device 6 or including External memory equipment.Memory
61 for storing computer program and other programs and data needed for computing device.Memory 61 can be also used for temporarily
Store the data that has exported or will export.
It is apparent to those skilled in the art that for convenience of description and succinctly, only with above-mentioned each work(
Can unit, module division progress for example, in practical application, can be as needed and by above-mentioned function distribution by different
Functional unit, module are completed, i.e., the internal structure of device are divided into different functional units or module, to complete above description
All or part of function.Each functional unit, module in embodiment can be integrated in a processing unit or
Unit is individually physically present, can also two or more units integrate in a unit, above-mentioned integrated unit
Both the form that hardware may be employed is realized, can also be realized in the form of SFU software functional unit.In addition, each functional unit, mould
The specific name of block is not limited to the protection domain of the application also only to facilitate mutually distinguish.It is single in above system
Member, the specific work process of module, may be referred to the corresponding process in preceding method embodiment, details are not described herein.
In the above-described embodiments, all emphasize particularly on different fields to the description of each embodiment, be not described in detail or remember in some embodiment
The part of load may refer to the associated description of other embodiments.
Those of ordinary skill in the art may realize that each exemplary lists described with reference to the embodiments described herein
Member and algorithm steps can be realized with the combination of electronic hardware or computer software and electronic hardware.These functions are actually
It is performed with hardware or software mode, specific application and design constraint depending on technical solution.Professional technician
Described function can be realized using distinct methods to each specific application, but this realization is it is not considered that exceed
The scope of the present invention.
In embodiment provided by the present invention, it should be understood that disclosed device/computing device and method, it can be with
It realizes by another way.For example, device described above/computing device embodiment is only schematical, for example, mould
The division of block or unit is only a kind of division of logic function, can there is other dividing mode in actual implementation, such as multiple
Unit or component may be combined or can be integrated into another system or some features can be ignored or does not perform.It is another
Point, shown or discussed mutual coupling or direct-coupling or communication connection can be by some interfaces, device or
The INDIRECT COUPLING of unit or communication connection can be electrical, machinery or other forms.
The unit illustrated as separating component may or may not be physically separate, be shown as unit
Component may or may not be physical location, you can be located at a place or can also be distributed to multiple networks
On unit.Some or all of unit therein can be selected to realize the purpose of this embodiment scheme according to the actual needs.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, it can also
That unit is individually physically present, can also two or more units integrate in a unit.Above-mentioned integrated list
The form that hardware had both may be employed in member is realized, can also be realized in the form of SFU software functional unit.
If integrated module/unit is realized in the form of SFU software functional unit and is independent production marketing or use
When, it can be stored in a computer read/write memory medium.Based on such understanding, the present invention realizes above-described embodiment side
All or part of flow in method can also instruct relevant hardware to complete, database access side by computer program
The computer program of method can be stored in a computer readable storage medium, which, can when being executed by processor
The step of realizing above-mentioned each embodiment of the method, i.e. when servicing startup, the Data Migration in disk database is set to local
Standby shared drive；Monitoring data library inquiry is asked；It is asked according to data base querying, number is obtained from the shared drive of local device
According to the data of library inquiry request institute requesting query；If it gets data base querying from the shared drive of local device to be asked
The data of inquiry are then handled the data got from the shared drive of local device.Wherein, computer program includes meter
Calculation machine program code, computer program code can be source code form, object identification code form, executable file or some centres
Form etc..Computer-readable medium can include：Any entity or device, record that computer program code can be carried are situated between
It is matter, USB flash disk, mobile hard disk, magnetic disc, CD, computer storage, read-only memory (ROM, Read-Only Memory), random
Access memory (RAM, Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium etc..It needs
It is noted that the content that includes of computer-readable medium can according to legislation in jurisdiction and the requirement of patent practice into
The appropriate increase and decrease of row, such as in some jurisdictions, according to legislation and patent practice, computer-readable medium does not include electricity and carries
Ripple signal and telecommunication signal.The above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations；Although with reference to before
Embodiment is stated the present invention is described in detail, it will be understood by those of ordinary skill in the art that：It still can be to preceding
The technical solution recorded in each embodiment is stated to modify or carry out equivalent substitution to which part technical characteristic；And these
Modification is replaced, and the essence of appropriate technical solution is not made to depart from the spirit and scope of various embodiments of the present invention technical solution,
It should all be included in the protection scope of the present invention.
Claims (10)
1. a kind of data bank access method, which is characterized in that the described method includes：
When servicing startup, by the shared drive of the Data Migration in disk database to local device；
Monitoring data library inquiry is asked；
It is asked according to the data base querying, the number of the data base querying request institute requesting query is obtained from the shared drive
According to；
If the data of the data base querying request institute requesting query are got from the shared drive, to out of described share
The data got are deposited to be handled.
2. data bank access method as described in claim 1, which is characterized in that it is described when servicing startup, by disk database
In Data Migration to local device shared drive, including：
Model data in the disk database is loaded onto to the shared drive of the local device；
Rope corresponding with the field index of tables of data in the disk database is established in the shared drive of the local device
Draw.
3. data bank access method as described in claim 1, which is characterized in that it is described to be asked according to the data base querying, from
The shared drive obtains the data of the data base querying request institute requesting query, including：
Judge whether the data of the data base querying request institute requesting query are located at the shared drive of the local device；
If the data of the data base querying request institute requesting query are located at the shared drive of the local device, will be described common
It enjoys memory and maps to consumer process space, inquire about the data base querying from the shared drive of the local device and asked
The data of inquiry.
4. data bank access method as claimed in claim 3, which is characterized in that the method further includes：
If the data of data base querying request institute requesting query are not in the shared drive of the local device, by the number
It is transmitted to and the corresponding service of data base querying request according to library inquiry request.
5. a kind of database access device, which is characterized in that described device includes：
Data Migration module, for service start when, by the Data Migration in disk database to local device it is shared in
It deposits；
Monitoring module is asked for monitoring data library inquiry；
For being asked according to the data base querying, the data base querying is obtained from the shared drive for data acquisition module
Ask the data of institute's requesting query；
Data processing module, if for getting the number of the data base querying request institute requesting query from the shared drive
According to then handling the data got from the shared drive.
6. database access device as claimed in claim 5, which is characterized in that the Data Migration module includes：
Loading unit, for the model data in the disk database to be loaded onto to the shared drive of the local device；
Unit is established, for establishing the field with tables of data in the disk database in the shared drive of the local device
Index corresponding index.
7. database access device as claimed in claim 5, which is characterized in that the data acquisition module includes：
Whether judging unit, the data for judging the data base querying request institute requesting query are located at the local device
Shared drive；
Query unit, if the data for data base querying request institute requesting query are located at the shared interior of the local device
It deposits, then the shared drive is mapped into consumer process space, the database is inquired about from the shared drive of the local device
The data of inquiry request institute requesting query.
8. database access device as claimed in claim 7, which is characterized in that described device further includes：
Forwarding module, if interior not in sharing for the local device for the data of data base querying request institute requesting query
It deposits, is then transmitted to data base querying request and the corresponding service of data base querying request.
9. a kind of computing device, including memory, processor and it is stored in the memory and can be on the processor
The computer program of operation, which is characterized in that the processor realizes such as Claims 1-4 when performing the computer program
The step of any one the method.
10. a kind of computer readable storage medium, the computer-readable recording medium storage has computer program, and feature exists
In realization is such as the step of Claims 1-4 any one the method when the computer program is executed by processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711286353.2A CN108052569A (en) | 2017-12-07 | 2017-12-07 | Data bank access method, device, computer readable storage medium and computing device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711286353.2A CN108052569A (en) | 2017-12-07 | 2017-12-07 | Data bank access method, device, computer readable storage medium and computing device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108052569A true CN108052569A (en) | 2018-05-18 |
Family
ID=62123192
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711286353.2A Pending CN108052569A (en) | 2017-12-07 | 2017-12-07 | Data bank access method, device, computer readable storage medium and computing device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108052569A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110287252A (en) * | 2019-06-27 | 2019-09-27 | 南方电网科学研究院有限责任公司 | A kind of data safety guard system |
| CN110457345A (en) * | 2019-07-05 | 2019-11-15 | 平安证券股份有限公司 | Database read method, device and computer readable storage medium |
| CN111143464A (en) * | 2019-12-10 | 2020-05-12 | 北京字节跳动网络技术有限公司 | Data acquisition method and device and electronic equipment |
| CN111159142A (en) * | 2018-11-07 | 2020-05-15 | 马上消费金融股份有限公司 | Data processing method and device |
| CN111669321A (en) * | 2020-06-11 | 2020-09-15 | 上海乾臻信息科技有限公司 | Method, device and system for realizing routing request |
| CN112069172A (en) * | 2020-08-21 | 2020-12-11 | 南京南瑞继保电气有限公司 | Power grid data processing method and device, electronic equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1740978A (en) * | 2004-08-23 | 2006-03-01 | 华为技术有限公司 | Method for realing sharing internal stored data base and internal stored data base system |
| CN102945251A (en) * | 2012-10-12 | 2013-02-27 | 浪潮电子信息产业股份有限公司 | Method for optimizing performance of disk database by memory database technology |
| CN103197979A (en) * | 2012-01-04 | 2013-07-10 | 阿里巴巴集团控股有限公司 | Method and device for realizing data interaction access among processes |
| CN104933045A (en) * | 2014-03-17 | 2015-09-23 | 腾讯科技（深圳）有限公司 | Network information browsing method and network information browsing device |
| US9830369B1 (en) * | 2013-05-14 | 2017-11-28 | Jsonar, Inc. | Processor for database analytics processing |
-
2017
- 2017-12-07 CN CN201711286353.2A patent/CN108052569A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1740978A (en) * | 2004-08-23 | 2006-03-01 | 华为技术有限公司 | Method for realing sharing internal stored data base and internal stored data base system |
| CN103197979A (en) * | 2012-01-04 | 2013-07-10 | 阿里巴巴集团控股有限公司 | Method and device for realizing data interaction access among processes |
| CN102945251A (en) * | 2012-10-12 | 2013-02-27 | 浪潮电子信息产业股份有限公司 | Method for optimizing performance of disk database by memory database technology |
| US9830369B1 (en) * | 2013-05-14 | 2017-11-28 | Jsonar, Inc. | Processor for database analytics processing |
| CN104933045A (en) * | 2014-03-17 | 2015-09-23 | 腾讯科技（深圳）有限公司 | Network information browsing method and network information browsing device |
Non-Patent Citations (1)
| Title |
|---|
| 解添: ""基于CIM模型的微网实时数据库系统"", 《万方数据知识服务平台》 * |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111159142A (en) * | 2018-11-07 | 2020-05-15 | 马上消费金融股份有限公司 | Data processing method and device |
| CN110287252A (en) * | 2019-06-27 | 2019-09-27 | 南方电网科学研究院有限责任公司 | A kind of data safety guard system |
| CN110457345A (en) * | 2019-07-05 | 2019-11-15 | 平安证券股份有限公司 | Database read method, device and computer readable storage medium |
| CN110457345B (en) * | 2019-07-05 | 2023-11-03 | 平安证券股份有限公司 | Database reading method, device and computer readable storage medium |
| CN111143464A (en) * | 2019-12-10 | 2020-05-12 | 北京字节跳动网络技术有限公司 | Data acquisition method and device and electronic equipment |
| CN111669321A (en) * | 2020-06-11 | 2020-09-15 | 上海乾臻信息科技有限公司 | Method, device and system for realizing routing request |
| CN111669321B (en) * | 2020-06-11 | 2022-06-24 | 上海乾臻信息科技有限公司 | Method, device and system for realizing routing request |
| CN112069172A (en) * | 2020-08-21 | 2020-12-11 | 南京南瑞继保电气有限公司 | Power grid data processing method and device, electronic equipment and storage medium |
| CN112069172B (en) * | 2020-08-21 | 2022-07-22 | 南京南瑞继保电气有限公司 | Power grid data processing method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108052569A (en) | Data bank access method, device, computer readable storage medium and computing device | |
| CN105978704B (en) | System and method for creating new cloud resource instruction set architecture | |
| CA2892889C (en) | Scaling computing clusters | |
| CN102255962B (en) | Distributive storage method, device and system | |
| CN108737325A (en) | A kind of multi-tenant data partition method, apparatus and system | |
| US9229993B2 (en) | Processing hybrid co-tenancy in a multi-database cloud | |
| CN108388675A (en) | Circulation method and terminal device are drawn in a kind of identity | |
| CN109669709A (en) | A kind of data migration method and data mover system of the upgrading of block chain | |
| CN102541990A (en) | Database redistribution method and system utilizing virtual partitions | |
| CN107179878A (en) | The method and apparatus of data storage based on optimizing application | |
| CN106686140A (en) | Network virtualization storage method, equipment and system | |
| CN106648462B (en) | Date storage method and device | |
| CN107832392A (en) | A kind of metadata management system | |
| CN106713391A (en) | Session information sharing method and sharing system | |
| CN109639598A (en) | Request processing method, server, storage medium and device based on micro services | |
| CN109144969A (en) | For the data processing method of block chain network system, device and storage medium | |
| CN110119304A (en) | A kind of interruption processing method, device and server | |
| CN106021566A (en) | Method, device and system for improving concurrent processing capacity of single database | |
| CN103593420A (en) | Method for constructing heterogeneous database clusters on same platform by sharing online logs | |
| CN108255989A (en) | Picture storage method, device, terminal device and computer storage media | |
| CN109903050A (en) | Transaction De-weight method, transaction building method, equipment and storage medium | |
| CN110490724A (en) | The storage method and device of account data | |
| CN115858488A (en) | Parallel migration method and device based on data governance and readable medium | |
| CN111651286A (en) | Data communication method, device, computing equipment and storage medium | |
| CN110502187A (en) | A kind of snapshot rollback method and device |
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: 20180518 |