CN110515972A - Database quick reference system and data query method - Google Patents
Database quick reference system and data query method Download PDFInfo
- Publication number
- CN110515972A CN110515972A CN201910798189.6A CN201910798189A CN110515972A CN 110515972 A CN110515972 A CN 110515972A CN 201910798189 A CN201910798189 A CN 201910798189A CN 110515972 A CN110515972 A CN 110515972A
- Authority
- CN
- China
- Prior art keywords
- data
- query statement
- module
- memory module
- query
- 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 45
- 230000001360 synchronised effect Effects 0.000 claims abstract description 35
- 230000001133 acceleration Effects 0.000 claims abstract description 26
- 230000009471 action Effects 0.000 claims abstract description 10
- 238000004891 communication Methods 0.000 claims description 21
- 230000005540 biological transmission Effects 0.000 claims description 12
- 230000008878 coupling Effects 0.000 description 6
- 238000010168 coupling process Methods 0.000 description 6
- 238000005859 coupling reaction Methods 0.000 description 6
- 230000008901 benefit Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 230000008859 change Effects 0.000 description 3
- 238000006243 chemical reaction Methods 0.000 description 2
- 238000004590 computer program Methods 0.000 description 2
- 235000013399 edible fruits Nutrition 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000005611 electricity Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 238000007430 reference method Methods 0.000 description 1
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24532—Query optimisation of parallel queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/24569—Query processing with adaptation to specific hardware, e.g. adapted for using GPUs or SSDs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Abstract
The invention discloses a kind of database quick reference system and data query method, database quick reference system includes: primary server and acceleration server；Primary server includes: database, CPU, accelerates drive module and data simultaneous module, acceleration server includes: GPU, video memory module and data memory module；Accelerate drive module to be used for: hooking up and parse the query statement that CPU is received, judge whether query statement is that can accelerate query statement；It is executed if so, query statement is assigned to GPU；Data simultaneous module is used for: obtaining the real time data synchronization of database in primary server to data memory module；Data memory module is used for: synchronous data are stored into the video memory module for accelerating server；GPU is used for: being executed query statement with parallel action method, is obtained from the data that video memory module stores and return to query result.
Description
Technical field
The present invention relates to database fields, and in particular to a kind of database quick reference system and data query method.
Background technique
Database for storing data, facilitates user to pass through inquiry database when in use, gets the data of needs.It is existing
There is technology when inquiring database, server where directly accessing the database often by querying command, by the CPU of server
Querying command is executed, query result is read from hard disk.For needing to touch mass data and completing the inquiries of complicated calculations,
Due to using the CPU architecture of server under the prior art to limit, query execution speed is not satisfactory.
Therefore, it is badly in need of a kind of database quick reference system, to promote data base querying speed.
Summary of the invention
In view of the above problems, it proposes on the present invention overcomes the above problem or at least be partially solved in order to provide one kind
State the database quick reference system and data query method of problem.
According to an aspect of the invention, there is provided a kind of database quick reference system, comprising: primary server and plus
Fast server；Primary server includes: database, CPU, accelerates drive module and data simultaneous module, accelerates server packet
Contain: GPU, video memory module and data memory module；
Accelerate drive module to be used for: hooking up and parse the query statement that CPU is received, judge whether query statement is that can add
Fast query statement；It is executed if so, query statement is assigned to GPU；
Data simultaneous module is used for: obtaining the real time data synchronization of database in primary server to data memory module；
Data memory module is used for: synchronous data are stored into the video memory module for accelerating server；
GPU is used for: being executed query statement with parallel action method, is obtained and return from the data that video memory module stores and look into
Ask result.
Optionally, drive module is accelerated to be further used for:
When CPU receives the query statement of user's transmission, query statement is hooked up；
Query statement is parsed, judges whether query statement is single table query statement；
If so, determining that query statement is that can accelerate query statement.
Optionally, data simultaneous module is further used for:
According to query statement, real time data synchronization in primary server in database relevant to query statement is obtained extremely
Data memory module；
Data memory module is further used for: generalization processing is carried out to the data type of synchronous data, by generalization
Treated stores into the video memory module for accelerating server.
Optionally, drive module is accelerated to be further used for:
If judging, query statement is assigned to CPU and executed by query statement for that can not accelerate query statement, and is returned by CPU
Return query result.
According to another aspect of the present invention, a kind of data query side using above-mentioned database quick reference system is provided
Method comprising:
Accelerate drive module to hook up and parse the query statement that CPU is received, judges whether query statement is that can accelerate to look into
Ask sentence；
It is executed if so, accelerating drive module that query statement is assigned to GPU；
Data simultaneous module obtains the real time data synchronization of database in primary server to data memory module；
Data memory module stores synchronous data into the video memory module for accelerating server；
GPU executes query statement with parallel action method, obtains from the data that video memory module stores and returns to inquiry knot
Fruit.
Optionally, accelerate drive module hook up and parse the query statement that CPU is received, judge query statement whether be can
Acceleration query statement further comprises:
When CPU receives the query statement of user's transmission, drive module is accelerated to hook up query statement；
Query statement is parsed, judges whether query statement is single table query statement；
If so, determining that query statement is that can accelerate query statement.
Optionally, data simultaneous module obtains the real time data synchronization of database in primary server to data memory module
Further comprise:
According to query statement, data simultaneous module obtains the number in primary server in database relevant to query statement
Data memory module is synchronized to when factually；
The video memory module that data memory module stores synchronous data to acceleration server further comprises:
Data memory module carries out generalization processing to the data types of synchronous data, by generalization treated storage
Into the video memory module for accelerating server.
Optionally, method further include:
If drive module is accelerated to judge that query statement for that can not accelerate query statement, is assigned to CPU and held by query statement
Row, and query result is returned to by CPU.
According to another aspect of the invention, provide a kind of electronic equipment, comprising: processor, memory, communication interface and
Communication bus, processor, memory and communication interface complete mutual communication by communication bus；
Memory makes processor execute above-mentioned data query method for storing an at least executable instruction, executable instruction
Corresponding operation.
In accordance with a further aspect of the present invention, a kind of computer storage medium is provided, at least one is stored in storage medium
Executable instruction, executable instruction make processor execute such as the corresponding operation of above-mentioned data query method.
The database quick reference system and data query method provided according to the present invention, wherein database quick search
System includes primary server and acceleration server；Primary server includes: database, CPU, accelerates drive module and data
Synchronization module, acceleration server includes: GPU, video memory module and data memory module；Accelerate drive module to be used for: hooking up simultaneously
The query statement that parsing CPU is received, judges whether query statement is that can accelerate query statement；If so, query statement is assigned
It is executed to GPU；Data simultaneous module is used for: real time data synchronization to the data for obtaining database in primary server store mould
Block；Data memory module is used for: synchronous data are stored into the video memory module for accelerating server；GPU is used for: to hold parallel
Line mode executes query statement, obtains from the data that video memory module stores and returns to query result.It, will be primary using the present invention
Server with accelerate server be connected, received query statement is hooked up and is parsed, using GPU execute query statement from show
Query result is obtained in storing module, can greatly improve inquiry velocity.
The above description is only an overview of the technical scheme of the present invention, in order to better understand the technical means of the present invention,
And it can be implemented in accordance with the contents of the specification, and in order to allow above and other objects of the present invention, feature and advantage can
It is clearer and more comprehensible, the followings are specific embodiments of the present invention.
Detailed description of the invention
By reading the following detailed description of the preferred embodiment, various other advantages and benefits are common for this field
Technical staff will become clear.The drawings are only for the purpose of illustrating a preferred embodiment, and is not considered as to the present invention
Limitation.And throughout the drawings, the same reference numbers will be used to refer to the same parts.In the accompanying drawings:
Fig. 1 shows the system architecture schematic diagram of database quick reference system according to an embodiment of the invention；
Fig. 2 shows the flow charts of data query method according to an embodiment of the invention；
Fig. 3 shows the structural schematic diagram of a kind of electronic equipment according to an embodiment of the invention.
Specific embodiment
Exemplary embodiments of the present disclosure are described in more detail below with reference to accompanying drawings.Although showing the disclosure in attached drawing
Exemplary embodiment, it being understood, however, that may be realized in various forms the disclosure without should be by embodiments set forth here
It is limited.On the contrary, these embodiments are provided to facilitate a more thoroughly understanding of the present invention, and can be by the scope of the present disclosure
It is fully disclosed to those skilled in the art.
Fig. 1 shows the system architecture schematic diagram of database quick reference system according to an embodiment of the invention.Such as
Shown in Fig. 1, database quick reference system includes: primary server 110 and acceleration server 120.Wherein, primary server
110 include: database 111, CPU112, accelerate drive module 113 and data simultaneous module 114.Server 120 is accelerated to wrap
Contain: GPU121, video memory module 122 and data memory module 123.
Mass data is stored in primary server 110 in database 111 for inquiry, the prior art is directly to pass through
CPU112 executes query statement, and corresponding query result is got from database 111.It in the present embodiment, is realization logarithm
According to the quick search in library, primary server 110 is connected with server 120 is accelerated, is realized to database quick search.
It, can be Hard link or by way of being flexible coupling when by primary server 110 with accelerating server 120 to be connected.
Hard link includes establishing primary server 110 such as in the way of host slot, USB connection, optical fiber connection and accelerating server
120 connection.It, can be by preset between primary server 110 and acceleration server 120 when needing to transmit data
Communication protocol is transmitted.Communication protocol can use the existing communication protocol based on hardware communications, do not do expansion herein and say
It is bright.It is flexible coupling including the connection such as established primary server 110 in the way of network etc. with accelerate server 120, primary service
Carried out data transmission between device 110 and acceleration server 120 by network.
In the present embodiment, it will be all independently performed by primary server 110 to data base querying, be led in the prior art
The connection established primary server 110 and accelerate server 120 is crossed, it is common complete with acceleration server 120 by primary server 110
The inquiry in paired data library.Specifically, further comprising acceleration in addition to comprising database 111 and CPU112 in primary server 110
Drive module 113 and data simultaneous module 114.
When CPU112 receives the query statement of user's transmission, drive module 113 is accelerated to hook up what CPU112 was received
Query statement interrupts CPU112 and directly executes the query statement.Accelerate drive module 113 to parse query statement, judges
Whether query statement is that can accelerate query statement.In the present embodiment, accelerate drive module 113 judge query statement whether be can
It when accelerating query statement, is parsed by the SQL text to query statement, as parsed the tables of data obtained in SQL text, inquiry is closed
The information such as bracing part, queried for items judge whether query statement is that can accelerate query statement according to the information that parsing obtains.If sentencing
Disconnected query statement is that can accelerate query statement, and query statement is assigned to the GPU121 in acceleration server 120 to execute.For
It can accelerate query statement, be illustrated by taking single table query statement as an example in the present embodiment, but be not limited to single table query statement.Accelerate
After drive module 113 obtains the information such as tables of data, inquiry Correlation Criteria, queried for items in SQL text in parsing query statement, sentence
Whether tables of data in disconnected SQL text is inquiry individual data table, inquiry Correlation Criteria whether be single table inquiry Correlation Criteria, look into
Whether inquiry project is queried for items in individual data table, if so, judging that query statement for that can accelerate query statement, is referred to
The GPU121 in acceleration server 120 is tasked to execute.Due to accelerating drive module 113 to be arranged in primary server 110,
In accelerating server 120, the two is adhered to separately in different server for GPU121 setting, is serviced according to primary server 110 with acceleration
The connection type of device 120, can by be suitable for hardware transport transport protocol (hard connecting mode) come transmission inquery sentence, or
By network connection (be flexible coupling mode) come transmission inquery sentence, the appointment of query statement is completed.
Accelerate the GPU121 in server 120 after receiving query statement, query statement executed with parallel action method,
To obtain query result.To be better carried out inquiry, accelerate to further comprise video memory module 122, video memory module in server 120
Synchronous data from database 111 are stored in 122, the data for facilitating GPU121 that can directly store from video memory module 122
Middle acquisition simultaneously returns to query result, compared with the prior art is from database 111 by memory read-write data, greatly improves inquiry
Speed.The synchronous data of the slave database 111 stored in video memory module 122, need data simultaneous module 114 and data to store mould
Block 123 is completed jointly.
Data simultaneous module 114 gets data from the database 111 of primary server 110, then by its real-time synchronization
To data memory module 123, data memory module 123 stores synchronous data to the video memory module 122 for accelerating server 120
In.The synchronization of data is serviced according to primary server 110 with acceleration between data simultaneous module 114 and data memory module 123
The connection type of device 120 is transmitted by being suitable for the transport protocol (hard connecting mode) of hardware transport, or passes through network connection
(be flexible coupling mode) is transmitted, and expansion explanation is not herein done.Further, data simultaneous module 114 and data memory module 123 can
To be executed before receiving query statement, the data in database 111 are synchronized in advance, avoid occupying query time；
Alternatively, can also be executed after receiving query statement, when the progress data of data simultaneous module 114 are synchronous, according to inquiry
Sentence obtains real time data synchronization to the data in primary server 110 in database 111 relevant to query statement and stores mould
Block 123.I.e. data simultaneous module 114 finds the corresponding data of tables of data in query statement from database 111 and is synchronized to data
Memory module 123.On the one hand, the real-time and accuracy of synchrodata are ensured；On the other hand, synchronous data and query statement
Correlation avoids time cost etc. caused by synchronous extraneous data, reduces the influence to inquiry velocity.
Further, data memory module 123 can also lead to the data type of synchronous data in storing data
It is handled with change, is general data type by the data type conversion of synchronous data, treated stores to acceleration by generalization
In the video memory module 122 of server 120, facilitate it is subsequent data are handled, be more common on various application the present embodiment
Upper layer application, make it be not necessarily to be concerned about the data type of database purchase.
Further, if drive module 113 is accelerated to judge query statement for query statement can not be accelerated, by query statement
It is assigned to CPU112, the query statement is executed by CPU112, query result is obtained from database 111, and returns to inquiry knot
Fruit.
The database quick reference system provided according to the present invention comprising primary server and acceleration server；It is primary
Server includes: database, CPU, accelerates drive module and data simultaneous module, acceleration server includes: GPU, video memory mould
Block and data memory module；Accelerate drive module to be used for: hooking up and parse the query statement that CPU is received, judges to inquire language
Whether sentence is that can accelerate query statement；It is executed if so, query statement is assigned to GPU；Data simultaneous module is used for: being obtained primary
The real time data synchronization of database is to data memory module in server；Data memory module is used for: synchronous data are stored
Into the video memory module for accelerating server；GPU is used for: being executed query statement with parallel action method, is stored from video memory module
It is obtained in data and returns to query result.Using the present invention, primary server is connected with server is accelerated, to received inquiry
Sentence is hooked up and is parsed, and is executed query statement using GPU and is obtained query result from video memory module, can greatly improve and look into
Ask speed.
Fig. 2 shows the flow charts of data query method according to an embodiment of the invention.As shown in Fig. 2, data are looked into
Inquiry method specifically comprises the following steps:
Step S201, accelerate drive module hook up and parse the query statement that CPU is received, judge query statement whether be
It can accelerate query statement.
When CPU receives the query statement of user's transmission, drive module is accelerated to hook up the query statement that CPU is received,
It interrupts CPU and directly executes the query statement.Accelerate drive module query statement is parsed, judge query statement whether be can
Accelerate query statement.In the present embodiment, drive module is accelerated to judge whether query statement is when can accelerate query statement, to pass through
The SQL text of query statement is parsed, such as parsing obtains tables of data, inquiry Correlation Criteria, queried for items in SQL text and believes
Breath judges whether query statement is that can accelerate query statement according to the information that parsing obtains.If judging query statement for that can accelerate
Query statement thens follow the steps S202；If judging, query statement for that can not accelerate query statement, thens follow the steps S206.
For query statement can be accelerated, it is illustrated by taking single table query statement as an example in the present embodiment, but be not limited to single table
Query statement.Drive module is accelerated to obtain the tables of data in SQL text, inquiry Correlation Criteria, queried for items in parsing query statement
Etc. after information, judge whether the tables of data in SQL text is inquiry individual data table, inquiry Correlation Criteria whether be single table inquiry
Correlation Criteria, whether queried for items is queried for items in individual data table, if so, judging query statement for that can accelerate to inquire
Otherwise sentence judges query statement for that can not accelerate query statement.
Step S202 accelerates drive module that query statement is assigned to GPU and executes.
After accelerating drive module to judge query statement for query statement can be accelerated, it is assigned to and is accelerated in server
GPU is executed.Due to accelerating drive module setting in primary server, in accelerating server, the two is adhered to separately or not GPU setting
With in server, according to the connection type of primary server and acceleration server, the transmission for being suitable for hardware transport can be passed through
Agreement (hard connecting mode) carrys out transmission inquery sentence, or is completed by network connection (be flexible coupling mode) come transmission inquery sentence
The appointment of query statement.
Step S203, real time data synchronization to the data that data simultaneous module obtains database in primary server store mould
Block.
Step S204, data memory module store synchronous data into the video memory module for accelerating server.
Data simultaneous module gets data from the database of primary server, then it is synchronized to data storage in real time
Module, data memory module store synchronous data into the video memory module for accelerating server.Data simultaneous module and data
The synchronization of data is according to primary server and the connection type for accelerating server between memory module, by being suitable for hardware transport
Transport protocol (hard connecting mode) transmit, or transmitted by network connection (be flexible coupling mode), herein do not do expansion and say
It is bright.
Further, step S203 and step S204 can be executed before step S201 receives query statement, in advance will
Data in database synchronize, and avoid occupying query time；Alternatively, step S203 and step S204 can also be in steps
S201 is executed after receiving query statement, when data simultaneous module progress data are synchronous, according to query statement, is obtained primary
Real time data synchronization in server in database relevant to query statement is to data memory module.I.e. data simultaneous module from
The corresponding data of tables of data in query statement are found in database is synchronized to data memory module.On the one hand, synchrodata is ensured
Real-time and accuracy；On the other hand, synchronous data are related to query statement, avoid the time caused by synchronous extraneous data
Spend etc., reduce the influence to inquiry velocity.
Further, data memory module can also carry out the data type of synchronous data general in storing data
Change processing, by the data type conversion of synchronous data be general data type, by generalization treated store to accelerate take
Be engaged in device video memory module in, facilitate it is subsequent data are handled, be more common to the various upper layers using on the present embodiment and answer
With the data type for making it be not necessarily to be concerned about database purchase.
Step S205, GPU execute query statement with parallel action method, obtain and return from the data that video memory module stores
Return query result.
Accelerate the GPU in server after receiving query statement, query statement is executed with parallel action method, to obtain
Query result.When obtaining query result, GPU is directly obtained from the data that the video memory module of synchronized data library data stores
And query result is returned, compared with the prior art is from database by memory read-write data, greatly improve inquiry velocity.
Query statement is assigned to CPU execution and returns to query result by CPU by step S206.
Accelerate drive module judging query statement for query statement can not be accelerated, then query statement is assigned to CPU, by
CPU executes the query statement, query result is obtained from database, and return to query result.
The data query method provided according to the present invention accelerates drive module to hook up and parse the inquiry language that CPU is received
Sentence, judges whether query statement is that can accelerate query statement；It is executed if so, accelerating drive module that query statement is assigned to GPU；
Data simultaneous module obtains the real time data synchronization of database in primary server to data memory module；Data memory module will
Synchronous data are stored into the video memory module for accelerating server；GPU executes query statement with parallel action method, from video memory mould
It is obtained in the data of block storage and returns to query result.By the way that received query statement is hooked up and parsed, held using GPU
Row query statement obtains query result from video memory module, can greatly improve inquiry velocity.
Corresponding description in the description reference method embodiment of above each module, details are not described herein.
Present invention also provides a kind of nonvolatile computer storage media, the computer storage medium is stored at least
The data query method in above-mentioned any means embodiment can be performed in one executable instruction, the computer executable instructions.
Fig. 3 shows the structural schematic diagram of a kind of electronic equipment according to an embodiment of the invention, and the present invention is specifically real
Example is applied not limit the specific implementation of electronic equipment.
As shown in figure 3, the electronic equipment may include: processor (processor) 302, communication interface
(Communications Interface) 304, memory (memory) 306 and communication bus 308.
Wherein:
Processor 302, communication interface 304 and memory 306 complete mutual communication by communication bus 308.
Communication interface 304, for being communicated with the network element of other equipment such as client or other servers etc..
Processor 302 can specifically execute the correlation in above-mentioned data query embodiment of the method for executing program 310
Step.
Specifically, program 310 may include program code, which includes computer operation instruction.
Processor 302 may be central processor CPU or specific integrated circuit ASIC (Application
Specific Integrated Circuit), or be arranged to implement the integrated electricity of one or more of the embodiment of the present invention
Road.The one or more processors that electronic equipment includes can be same type of processor, such as one or more CPU；It can also
To be different types of processor, such as one or more CPU and one or more ASIC.
Memory 306, for storing program 310.Memory 306 may include high speed RAM memory, it is also possible to further include
Nonvolatile memory (non-volatile memory), for example, at least a magnetic disk storage.
Program 310 specifically can be used for so that processor 302 executes the data query side in above-mentioned any means embodiment
Method.The specific implementation of each step may refer to right in corresponding steps and unit in above-mentioned data query embodiment in program 310
The description answered, this will not be repeated here.It is apparent to those skilled in the art that for convenience and simplicity of description, on
The equipment of description and the specific work process of module are stated, can refer to corresponding processes in the foregoing method embodiment description, herein
It repeats no more.
Algorithm and display are not inherently related to any particular computer, virtual system, or other device provided herein.
Various general-purpose systems can also be used together with teachings based herein.As described above, it constructs required by this kind of system
Structure be obvious.In addition, the present invention is also not directed to any particular programming language.It should be understood that can use various
Programming language realizes summary of the invention described herein, and the description done above to language-specific is to disclose this hair
Bright preferred forms.
In the instructions provided here, numerous specific details are set forth.It is to be appreciated, however, that implementation of the invention
Example can be practiced without these specific details.In some instances, well known method, structure is not been shown in detail
And technology, so as not to obscure the understanding of this specification.
Similarly, it should be understood that in order to simplify the disclosure and help to understand one or more of the various inventive aspects, In
Above in the description of exemplary embodiment of the present invention, each feature of the invention is grouped together into single implementation sometimes
In example, figure or descriptions thereof.However, the disclosed method should not be interpreted as reflecting the following intention: i.e. required to protect
Shield the present invention claims features more more than feature expressly recited in each claim.More precisely, such as right
As claim reflects, inventive aspect is all features less than single embodiment disclosed above.Therefore, it then follows tool
Thus claims of body embodiment are expressly incorporated in the specific embodiment, wherein each claim conduct itself
Separate embodiments of the invention.
Those skilled in the art will understand that can be carried out adaptively to the module in the equipment in embodiment
Change and they are arranged in one or more devices different from this embodiment.It can be the module or list in embodiment
Member or component are combined into a module or unit or component, and furthermore they can be divided into multiple submodule or subelement or
Sub-component.Other than such feature and/or at least some of process or unit exclude each other, it can use any
Combination is to all features disclosed in this specification (including adjoint claim, abstract and attached drawing) and so disclosed
All process or units of what method or apparatus are combined.Unless expressly stated otherwise, this specification is (including adjoint power
Benefit require, abstract and attached drawing) disclosed in each feature can carry out generation with an alternative feature that provides the same, equivalent, or similar purpose
It replaces.
In addition, it will be appreciated by those of skill in the art that although some embodiments described herein include other embodiments
In included certain features rather than other feature, but the combination of the feature of different embodiments mean it is of the invention
Within the scope of and form different embodiments.For example, in detail in the claims, embodiment claimed it is one of any
Can in any combination mode come using.
Various component embodiments of the invention can be implemented in hardware, or to run on one or more processors
Software module realize, or be implemented in a combination thereof.It will be understood by those of skill in the art that can be used in practice
Microprocessor or digital signal processor (DSP) are realized in database quick reference system according to an embodiment of the present invention
The some or all functions of some or all components.The present invention is also implemented as executing method as described herein
Some or all device or device programs (for example, computer program and computer program product).Such reality
Existing program of the invention can store on a computer-readable medium, or may be in the form of one or more signals.
Such signal can be downloaded from an internet website to obtain, and perhaps be provided on the carrier signal or in any other forms
It provides.
It should be noted that the above-mentioned embodiments illustrate rather than limit the invention, and ability
Field technique personnel can be designed alternative embodiment without departing from the scope of the appended claims.In the claims,
Any reference symbol between parentheses should not be configured to limitations on claims.Word "comprising" does not exclude the presence of not
Element or step listed in the claims.Word "a" or "an" located in front of the element does not exclude the presence of multiple such
Element.The present invention can be by means of including the hardware of several different elements and being come by means of properly programmed computer real
It is existing.In the unit claims listing several devices, several in these devices can be through the same hardware branch
To embody.The use of word first, second, and third does not indicate any sequence.These words can be explained and be run after fame
Claim.
Claims (10)
1. a kind of database quick reference system characterized by comprising primary server and acceleration server；It is described primary
Server includes: database, CPU, accelerates drive module and data simultaneous module, and the acceleration server includes: GPU, shows
Storing module and data memory module；
The acceleration drive module is used for: being hooked up and is parsed the query statement that the CPU is received, judge that the query statement is
No is that can accelerate query statement；It is executed if so, the query statement is assigned to the GPU；
The data simultaneous module is used for: real time data synchronization to the data for obtaining database described in primary server are deposited
Store up module；
The data memory module is used for: synchronous data are stored into the video memory module for accelerating server；
The GPU is used for: being executed the query statement with parallel action method, is obtained from the data that the video memory module stores
And return to query result.
2. system according to claim 1, which is characterized in that the acceleration drive module is further used for:
When the CPU receives the query statement of user's transmission, the query statement is hooked up；
The query statement is parsed, judges whether the query statement is single table query statement；
If so, determining that the query statement is that can accelerate query statement.
3. system according to claim 1, which is characterized in that the data simultaneous module is further used for:
According to the query statement, the data obtained in primary server in database relevant to the query statement are same in real time
It walks to the data memory module；
The data memory module is further used for: carrying out generalization processing to the data type of the synchronous data, will lead to
With changing, treated is stored into the video memory module for accelerating server.
4. system according to any one of claim 1-3, which is characterized in that the acceleration drive module is further used
In:
If judging, the query statement for that can not accelerate query statement, is assigned to the CPU and executed by the query statement, and
Query result is returned to by CPU.
5. a kind of data query method using such as database quick reference system of any of claims 1-4,
Include:
Accelerate drive module to hook up and parse the query statement that CPU is received, judges whether the query statement is that can accelerate to look into
Ask sentence；
It is executed if so, accelerating drive module that the query statement is assigned to GPU；
Data simultaneous module obtains the real time data synchronization of database in primary server to data memory module；
Data memory module stores synchronous data into the video memory module for accelerating server；
GPU executes the query statement with parallel action method, obtains and returns from the data that the video memory module stores and looks into
Ask result.
6. according to the method described in claim 5, it is characterized in that, the acceleration drive module hooks up and parses CPU and receives
Query statement, judge whether the query statement is that can accelerate the query statement to further comprise:
When CPU receives the query statement of user's transmission, drive module is accelerated to hook up the query statement；
The query statement is parsed, judges whether the query statement is single table query statement；
If so, determining that the query statement is that can accelerate query statement.
7. according to the method described in claim 5, it is characterized in that, the data simultaneous module obtains data in primary server
The real time data synchronization in library to data memory module further comprises:
According to the query statement, data simultaneous module is obtained in primary server in database relevant to the query statement
Real time data synchronization to the data memory module；
The video memory module that the data memory module stores synchronous data to acceleration server further comprises:
Data memory module carries out generalization processing to the data types of the synchronous data, by generalization treated storage
Into the video memory module for accelerating server.
8. the method according to any one of claim 5-7, which is characterized in that the method also includes:
If drive module is accelerated to judge that for that can not accelerate query statement, the query statement is assigned to for the query statement
CPU is executed, and returns to query result by CPU.
9. a kind of electronic equipment, comprising: processor, memory, communication interface and communication bus, the processor, the storage
Device and the communication interface complete mutual communication by the communication bus；
The memory executes the processor as right is wanted for storing an at least executable instruction, the executable instruction
Ask the corresponding operation of data query method described in any one of 5-8.
10. a kind of computer storage medium, an at least executable instruction, the executable instruction are stored in the storage medium
Processor is set to execute the corresponding operation of data query method as described in any one of claim 5-8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910798189.6A CN110515972A (en) | 2019-08-27 | 2019-08-27 | Database quick reference system and data query method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910798189.6A CN110515972A (en) | 2019-08-27 | 2019-08-27 | Database quick reference system and data query method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110515972A true CN110515972A (en) | 2019-11-29 |
Family
ID=68628144
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910798189.6A Pending CN110515972A (en) | 2019-08-27 | 2019-08-27 | Database quick reference system and data query method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110515972A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102810133A (en) * | 2012-05-15 | 2012-12-05 | 北京像素软件科技股份有限公司 | Ray query method for network game, and scene server |
| US20150116340A1 (en) * | 2013-10-29 | 2015-04-30 | International Business Machines Corporation | Selective utilization of graphics processing unit (gpu) based acceleration in database management |
| WO2016053083A1 (en) * | 2014-10-02 | 2016-04-07 | Mimos Berhad | System for processing multiple queries using gpu |
| CN107341193A (en) * | 2017-06-14 | 2017-11-10 | 中国神华能源股份有限公司 | Mobile object querying method in road network |
| CN107451916A (en) * | 2017-07-21 | 2017-12-08 | 武汉楚鼎信息技术有限公司 | The querying method of high-performance K lines based on graphics processor, form are selected stocks system |
| KR101980320B1 (en) * | 2019-01-31 | 2019-05-20 | 주식회사아이티존 | Parallel distributed processing method for big data query based on gpu |
-
2019
- 2019-08-27 CN CN201910798189.6A patent/CN110515972A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102810133A (en) * | 2012-05-15 | 2012-12-05 | 北京像素软件科技股份有限公司 | Ray query method for network game, and scene server |
| US20150116340A1 (en) * | 2013-10-29 | 2015-04-30 | International Business Machines Corporation | Selective utilization of graphics processing unit (gpu) based acceleration in database management |
| WO2016053083A1 (en) * | 2014-10-02 | 2016-04-07 | Mimos Berhad | System for processing multiple queries using gpu |
| CN107341193A (en) * | 2017-06-14 | 2017-11-10 | 中国神华能源股份有限公司 | Mobile object querying method in road network |
| CN107451916A (en) * | 2017-07-21 | 2017-12-08 | 武汉楚鼎信息技术有限公司 | The querying method of high-performance K lines based on graphics processor, form are selected stocks system |
| KR101980320B1 (en) * | 2019-01-31 | 2019-05-20 | 주식회사아이티존 | Parallel distributed processing method for big data query based on gpu |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8498975B2 (en) | Search query processing | |
| CN104881494B (en) | The methods, devices and systems synchronous with Redis server progress data | |
| CN110032575A (en) | Data query method, apparatus, equipment and storage medium | |
| CN105471968B (en) | A kind of method for interchanging data, system and data platform server | |
| CN104376127B (en) | A kind of data manipulation method and device | |
| US11422817B2 (en) | Method and apparatus for executing instructions including a blocking instruction generated in response to determining that there is data dependence between instructions | |
| CN104881808B (en) | Method, server and the system of auction data are obtained in real time | |
| CA3055071C (en) | Writing composite objects to a data store | |
| CN109474633A (en) | Method for converting protocol, calculates equipment and computer storage medium at device | |
| CN106411778B (en) | The method and device of data forwarding | |
| CN106649114B (en) | The method and apparatus that application crash is positioned | |
| CN110083533A (en) | Data processing method and device based on Mock service | |
| CN110008106A (en) | Code test method, device and computer readable storage medium | |
| CN106598747B (en) | The method for parallel processing and device of network packet | |
| CN109800078A (en) | A kind of task processing method, task distribution terminal and task execution terminal | |
| CN106599062A (en) | Data processing method and device in SparkSQL system | |
| CN108520003B (en) | A kind of storing process scheduling system and method | |
| CN110209565A (en) | A kind of metadata schema adjustment method and its device | |
| CN110515972A (en) | Database quick reference system and data query method | |
| CN105843603B (en) | The method and device of graphics process | |
| CN106844415A (en) | A kind of data processing method and device in SparkSQL systems | |
| CN113760242A (en) | Data processing method, device, server and medium | |
| CN108460002A (en) | Affiliate's automatic butt method, apparatus, equipment and storage medium | |
| CN105354052B (en) | flash game loading method and device | |
| CN105577707B (en) | A kind of remote invocation method and equipment |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20191129 |
|
| WD01 | Invention patent application deemed withdrawn after publication |