CN103729471B - Data base query method and device - Google Patents
Data base query method and device Download PDFInfo
- Publication number
- CN103729471B CN103729471B CN201410027522.0A CN201410027522A CN103729471B CN 103729471 B CN103729471 B CN 103729471B CN 201410027522 A CN201410027522 A CN 201410027522A CN 103729471 B CN103729471 B CN 103729471B
- Authority
- CN
- China
- Prior art keywords
- inquiry
- data
- query
- database server
- plan
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 39
- 230000004913 activation Effects 0.000 claims description 5
- 230000005540 biological transmission Effects 0.000 claims description 5
- 230000003111 delayed effect Effects 0.000 claims 2
- 230000003139 buffering effect Effects 0.000 claims 1
- 235000015170 shellfish Nutrition 0.000 claims 1
- 238000005516 engineering process Methods 0.000 description 7
- 230000008520 organization Effects 0.000 description 4
- 241000208340 Araliaceae Species 0.000 description 3
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 description 3
- 235000003140 Panax quinquefolius Nutrition 0.000 description 3
- 235000008434 ginseng Nutrition 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 239000012467 final product Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 230000033772 system development Effects 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the present invention provides a kind of data base query method and device.A kind of data base query method, including：The inquiry request that receiving data storehouse client sends, comprises inquiry mark ID and query argument in described inquiry request；Determine the inquiry plan prestoring according to described inquiry ID；According to the inquiry plan of described query argument and determination, the data caching in advance executes data query；Send Query Result to described database client.The technical scheme search efficiency of the embodiment of the present invention higher it is adaptable to high concentration degree and high performance inquiry.
Description
Technical field
The present embodiments relate to communication technology, more particularly, to a kind of data base query method and device.
Background technology
Needing, using in the business procession of data base querying, often to carry out high concentration degree to some particular datas
With high performance inquiry, data to be checked may need multilist association inquiry.Wherein, the inquiry of high concentration degree refers to inquire about
Rule change is fewer, is all several class inquiry, high performance inquiry refers to this kind of search request quick response, and need per second
Number of times to be executed is very many, such as 100,000 times or more.For example, unite to the client of particular customer in events marketing field
The inquiry of one view, its querying condition is exactly customer ID, and what Query Result returned is then specifically in some Client view
Attribute（Record containing sublist）.Streaming collects for another example, to each event, will first associate the target record collecting, need also exist for doing
High Performance Data Query.
In existing database inquiry mode, such inquiry is often based upon SQL (Structured
Query Language, hereinafter referred to as：SQL) sentence, is realized by associating multiple tables.When inquiring about every time, operation system can be by
SQL statement and query argument are delivered to database server, for example can be by calling the data being deployed in this operation system
Storehouse client is sending this SQL statement and query argument.Database server parses SQL statement, or reuses original inquiry
Plan, loading data from hard disk, or using the data in caching, the sequence of operations such as execution tables of data association, Ran Houxiang
Operation system returns Query Result, and returns the metadata information of Query Result simultaneously.
But, when processing this high concentration degree and high performance inquiry, disposal ability has existing database inquiry mode
Limit is it is impossible to meet the demand of user.
Content of the invention
The embodiment of the present invention provides a kind of data base query method and device.
In a first aspect, providing a kind of data base query method, including：
The inquiry request that receiving data storehouse client sends, comprises inquiry mark ID and inquiry ginseng in described inquiry request
Number；
Determine the inquiry plan prestoring according to described inquiry ID；
According to the inquiry plan of described query argument and determination, the data caching in advance executes data query；
Send Query Result to described database client.
Second aspect, provides another kind of data base query method, including：
Send inquiry request to database server, in described inquiry request, comprise inquiry mark ID and query argument, with
Described database server is made to determine, according to described inquiry ID, the inquiry plan that prestores, and according to described query argument and really
Fixed inquiry plan, executes data query in the data caching in advance；
Receive the Query Result that described database server sends.
The third aspect, provides a kind of database server, including：
Receiver module, the inquiry request sending for receiving data storehouse client, comprise inquiry mark in described inquiry request
Know ID and query argument；
Determining module, for determining the inquiry plan prestoring according to described inquiry ID；
Enquiry module, for the inquiry plan according to described query argument and determination, executes in the data caching in advance
Data query；
Sending module, for sending Query Result to described database client.
Fourth aspect, provides a kind of database client, including：
Sending module, for sending inquiry request to database server, comprises inquiry mark ID in described inquiry request
And query argument, so that described database server determines, according to described inquiry ID, the inquiry plan prestoring, and according to institute
State query argument and the inquiry plan determining, the data caching in advance executes data query；
Receiver module, for receiving the Query Result that described database server sends.
In the embodiment of the present invention, operation system can be noted in advance by calling database client in database server
Volume inquires about ID and inquiry plan corresponding with this inquiry ID, and this inquiry ID corresponding inquiry data can also be buffered in advance
In internal memory.When carrying out data query, database client only needs to transmission inquiry ID and query argument to database server；
For database server, then can determine that, using this inquiry ID, the inquiry plan prestoring, and according to query argument and really
Fixed inquiry plan, executes data query in the data caching in advance, and then to database client feedback query result.Should
Data base querying process need not be required to transmit SQL statement in each inquiry compared with technology, carries out without to SQL statement
Parsing, more need not go to carry out the operation such as data query data structure organization, therefore, the present embodiment in hard disk after parsing again
Technical scheme search efficiency higher it is adaptable to high concentration degree and high performance inquiry.
Brief description
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
Have technology description in required use accompanying drawing be briefly described it should be apparent that, drawings in the following description are these
Some bright embodiments, for those of ordinary skill in the art, without having to pay creative labor, acceptable
Other accompanying drawings are obtained according to these accompanying drawings.
Fig. 1 is the flow chart of data base query method embodiment one of the present invention；
Fig. 2 is the flow chart of data base query method embodiment two of the present invention；
Fig. 3 is the flow chart of data base query method embodiment three of the present invention；
Fig. 4 is the structural representation of database server embodiment one of the present invention；
Fig. 5 is the structural representation of database server embodiment two of the present invention；
Fig. 6 is the structural representation of database client embodiment of the present invention.
Specific embodiment
Purpose, technical scheme and advantage for making the embodiment of the present invention are clearer, below in conjunction with the embodiment of the present invention
In accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described it is clear that described embodiment is
The a part of embodiment of the present invention, rather than whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art
The every other embodiment being obtained under the premise of not making creative work, broadly falls into the scope of protection of the invention.
Fig. 1 is the flow chart of data base query method embodiment one of the present invention, as shown in figure 1, the method for the present embodiment can
To include：
The inquiry request that S101, receiving data storehouse client send, comprises inquiry mark ID and looks in described inquiry request
Ask parameter；
S102, the inquiry plan being prestored according to described inquiry ID determination；
S103, the inquiry plan according to described query argument and determination, execute data query in the data caching in advance；
S104, to described database client send Query Result.
In the present embodiment, inquiry ID passes through database client for operation system and registers in database server in advance
, this database client can be deployed in operation system.When operation system starts, or during business rule change, business
System needs to initiate the pre-registration of inquiry, and operation system informs database client inquiry ID and corresponding query logic, number
Then inquiry ID and corresponding query logic are informed database server according to storehouse client.Then, database server gets final product base
In corresponding query logic, data to be inquired about is loaded previously in caching, and data to be checked is organized according to query logic
Structure.Optionally, database server can carry out complex optimum in conjunction with multiple different inquiry ID to the structure of data.Example
As merged similar inquiry, merge identical incidence relation etc., allow multiple queries share index structure and data cached.Then,
Database server can generate the corresponding inquiry plan of this inquiry ID.Preferably, database server can be by the number of caching
Feed back to database client according to corresponding metadata structure, so in subsequent query, feedback metadata need not be wanted every time
Structure, and only need to return actual data.
For example, operation system will do three different inquiries：First inquiry attribute to be inquired about is dispersed in three
In table, comprise a master meter and two 1:N sublist；Second inquiry attribute to be inquired about is all in a master meter；3rd
Inquiry attribute to be inquired about is all at 11:In N sublist.Operation system to these three inquiry be respectively allocated inquiry ID be 101,
102nd, 103, then construct these three query logics（It is also likely to be to determine that the system development phase, or system performance rules become
Calculated based on system convention more afterwards）.If wherein first query logic is represented with SQL, need three SQL statement,
Two next is a SQL statement respectively, and each query logic comprises to inquire about the attribute description of the data of the corresponding inquiry of ID
Information.Inquiry ID and corresponding query logic can be passed to database client by operation system, and then by data base visitor
Family end passes to database server.Database server can according to this query logic group organization data, for example be directed to 101 this
Inquiry ID, needs a master meter and two 1:N sublist is associated, and then in advance data is entered row cache, and generates and look into
Ask and identify corresponding inquiry plan, the query argument that this inquiry plan describes based on database client is transmitted to is carried out
Concrete inquiry mode during data query.
In data query, the inquiry request that database server can be sent with receiving data storehouse client, this inquiry please
Can comprise in asking to inquire about ID and query argument.Wherein, the inquiry that query argument is as registered in advance in database server
ID, query argument can be for example the suction parameters such as customer ID.Then, database server can be determined based on inquiry ID
The inquiry plan corresponding with this inquiry ID prestoring, may thereby determine that based on this query argument, specifically how to inquire about number
According to that is, database server can execute data according to query argument and the inquiry plan determining in the data caching in advance
Inquiry, such that it is able to obtain query structure.Finally, database server can be to database client feedback query result.
In the present embodiment, operation system can be looked into by calling database client to register in database server in advance
Ask ID and inquiry plan corresponding with this inquiry ID, and this inquiry ID corresponding inquiry data can also be buffered in internal memory in advance
In.When carrying out data query, database client only needs to transmission inquiry ID and query argument to database server；For
Database server, then can determine that, using this inquiry ID, the inquiry plan prestoring, and according to query argument and determination
Inquiry plan, executes data query in the data caching in advance, and then to database client feedback query result.This data
Library inquiry process need not be required to transmit SQL statement in each inquiry compared with technology, solves without to SQL statement
Analysis, more need not go to carry out the operation such as data query data structure organization, therefore, the skill of the present embodiment in hard disk after parsing again
Art proposal inquiry efficiency is higher, is more suitable for high concentration degree and high performance inquiry.
Adopt a specific embodiment below, embodiment of the method one shown in Fig. 1 is described in detail.
Fig. 2 is the flow chart of data base query method embodiment two of the present invention, as shown in Fig. 2 the method for the present embodiment can
To include：
Inquiry ID and query logic that S201, receiving data storehouse client send, comprise in this query logic to inquire about ID institute
The attribute description information of corresponding inquiry data.
For example, to inquire about unified view of customers 50 attributes, this 50 property distribution in 5 tables, every
10 attributes of table, wherein 2 tables are 1:N associates, and in addition three tables are 1:1 association.Query argument is customer ID.For being based on
The system of rule, operation system directly can inform database server 50 genus to be inquired about by calling database client
The title of property.For the system based on SQL, this inquiry can split into three SQL, and one is three 1:The association of 1 table, separately
It is outward two 1:The individual query of N table, operation system can provide an inquiry ID above inquiry, and such as 101, and by number
Tell database server according to storehouse client inquiry ID and corresponding query logic.
S202, to attribute description information, corresponding data enters row cache.
Corresponding data can be entered row cache according to attribute description information by database server in advance.
For the scene of multilist association, S202 specifically can enter at least two tables of data according to attribute description information
Row association, and the tables of data of association is entered row cache.
Continue precedent, database server can be first three 1:Incidence relation carried out by the table of 1 association, and corresponding row are added
It is downloaded to internal memory, constitute a memory table having 30 attributes.Meanwhile, two 1:The table of N association is also loaded into internal memory, at this
Add two in memory table and be directed to 1:The index column of N table, points to two 1:The internal memory starting point of the corresponding row of the table of the association of N
Location.
The corresponding inquiry plan of data of S203, generation and caching and search index, and described inquiry ID is looked into described
Inquiry plan is associated.
For example, database server can be to having the 1 of 50 attributes:1 memory table and two 1:N memory table
Query key creates search index, such as Hash（Hash）Index.Database server provides inquiry ID（101）Corresponding inquiry meter
Draw, for example, indexed using Hash based on query argument, find corresponding row address, 30 attributes then copying this row are to output
Relief area, then respectively the twoth 1:Multirow record copies associated by the corresponding address of attribute in N memory table are to output
Relief area.
S204, to described database client send metadata structure corresponding with the data of described caching.
This metadata structure, for example, 30 1:1 attribute, 2 collection zygote attributes, each contains 10 attributes.
Above-mentioned S201～S204 completes pre-registration procedure.
The inquiry request that S205, receiving data storehouse client send, comprises inquiry mark ID and looks in described inquiry request
Ask parameter.
When database client initiates an inquiry, server client can send inquiry ID to database server
" 101 " and query argument " 31059865321 " arrive database server.
S206, the inquiry plan being prestored according to described inquiry ID determination.
Database server can be inquired about ID " 101 " and can determine the aforementioned inquiry plan having prestored.
S207, according to described query argument, determine search index；
According to query argument " 31059865321 ", database server can determine that Hash indexes.
S208, according to described search index, determine inquiry address, and the data copy preserving at described inquiry address arrived
Output buffer.
Database server indexes according to this Hash, you can determines and inquires about address, such as the row address in tables of data, thus
Can be by the data copy preserving at inquiry address to output buffer.
For scene for multilist association, database server is according to search index it may be necessary to determine at least two
Inquiry address, wherein, each inquiry address corresponds to the storage address in a tables of data；According to each inquiry address, from corresponding
Searching data in tables of data, and by the data copy finding from each tables of data to output buffer.
S209, by the data is activation in output buffer give described database client.
Database server finally can be by the data is activation in output buffer to database client, so that total
Obtain the data inquired about according to storehouse client, and the metadata structure being previously obtained based on S204 can know the data of inquiry
Data structure.
The present embodiment, during registered in advance, operation system can counted in advance by calling database client
According to trade mark enquiries ID in the server of storehouse and inquiry plan corresponding with this inquiry ID, this inquiry ID corresponding inquiry data is acceptable
It is buffered in internal memory in advance, and, metadata structure can also be fed back to database client by database server in advance.When
When carrying out data query, database client only needs to transmission inquiry ID and query argument to database server, and data base takes
Business device can determine that the inquiry plan prestoring, and the inquiry plan according to query argument and determination using this inquiry ID,
Data query is executed in the data caching in advance, and then to database client feedback query result, so that data base is objective
Family end group can know the data structure of the data of inquiry in the metadata structure being previously obtained.This data base querying process need not
It is required to transmit SQL statement in each inquiry compared with technology, parse without to SQL statement, more need not be in parsing
Go again afterwards in hard disk, to carry out the operation such as data query data structure organization, and, database server need not often be inquired about once
Metadata structure is just fed back once by data, and therefore, the technical scheme search efficiency of the present embodiment is higher, is more suitable for high concentration
Degree and high performance inquiry.
Fig. 3 is the flow chart of data base query method embodiment three of the present invention, as shown in figure 3, the method for the present embodiment can
To include：
S301, to database server send inquiry request, comprise in described inquiry request inquiry mark ID and inquiry ginseng
Number, so that described database server determines, according to described inquiry ID, the inquiry plan prestoring, and according to described inquiry ginseng
Number and the inquiry plan determining, execute data query in the data caching in advance；
The Query Result that S302, the described database server of reception send.
Further, before S301 sends inquiry request to database server, can also include：
Send inquiry ID and query logic to described database server, in described query logic, comprise described inquiry ID institute
The attribute description information of corresponding inquiry data, so that described database server is to described attribute description information, and corresponding data is entered
Row cache, generates the corresponding inquiry plan of data with caching and search index, and by described inquiry ID and described inquiry plan
It is associated；
Receive the corresponding metadata structure of the data with described caching that described database server sends.
The method of the present embodiment is database client corresponding with the method performed by database server in Fig. 1 and Fig. 2
The performed method in end, it is realized, and principle is similar with technique effect, and here is omitted.
Fig. 4 is the structural representation of database server embodiment one of the present invention, as shown in figure 4, the data of the present embodiment
Storehouse server, including：Receiver module 401, determining module 402, enquiry module 403, sending module 404, wherein：
Receiver module 401, the inquiry request sending for receiving data storehouse client, comprise in described inquiry request to inquire about
Mark ID and query argument；
Determining module 402, for determining the inquiry plan prestoring according to described inquiry ID；
Enquiry module 403, for the inquiry plan according to described query argument and determination, holds in the data caching in advance
Row data query；
Sending module 404, for sending Query Result to described database client.
The database server of the present embodiment is used for executing the technical scheme of embodiment of the method shown in Fig. 1, and it realizes principle
Similar with technique effect, here is omitted.
Fig. 5 is the structural representation of database server embodiment two of the present invention, as shown in figure 5, the data of the present embodiment
Storehouse server on the basis of structure shown in Fig. 4, further, enquiry module 403, including：
Determining unit 403a, for according to described query argument, determining search index；
Copy cell 403b, for according to described search index, determining inquiry address, and will preserve at described inquiry address
Data copy to output buffer；
Sending module 404, specifically for：
Data is activation in described output buffer is given described database client.
Further, copy cell 403b, specifically for：
According to described search index, determine at least two inquiry addresses, wherein, each inquiry address corresponds to a tables of data
In storage address；
According to each inquiry address, searching data from corresponding tables of data, and the data that will find from each tables of data
Copy output buffer to.
Further, receiver module 401, were additionally operable to before the inquiry request that receiving data storehouse client sends：Receive
Inquiry ID and query logic that database client sends, comprise described inquiry ID corresponding inquiry data in described query logic
Attribute description information；
The database server of the present embodiment, can also include：
Cache module 405, enters row cache for data corresponding to described attribute description information, generates the data with caching
Corresponding inquiry plan and search index, and described inquiry ID is associated with described inquiry plan；
Accordingly, sending module 404, are additionally operable to corresponding with the data of described caching to the transmission of described database client
Metadata structure.
Further, cache module 405, specifically for：
According to described attribute description information, at least two tables of data are associated；
The tables of data of association is entered row cache.
The database server of the present embodiment is used for executing the technical scheme of embodiment of the method shown in Fig. 2, and it realizes principle
Similar with technique effect, here is omitted.
Fig. 6 is the structural representation of database client embodiment of the present invention, as shown in fig. 6, the data base of the present embodiment
Client can include：Sending module 601, receiver module 602, wherein：
Sending module 601, for sending inquiry request to database server, comprises inquiry mark in described inquiry request
ID and query argument, so that described database server determines, according to described inquiry ID, the inquiry plan prestoring, and according to
Described query argument and the inquiry plan determining, execute data query in the data caching in advance；
Receiver module 602, for receiving the Query Result that described database server sends.
Further, sending module 601, were additionally operable to before sending inquiry request to database server：To described number
Send inquiry ID and query logic according to storehouse server, in described query logic, comprise the genus of described inquiry ID corresponding inquiry data
Property description information so that described database server is to described attribute description information, corresponding data enters row cache, generate with slow
The corresponding inquiry plan of data deposited and search index, and described inquiry ID is associated with described inquiry plan；
Receiver module 602, is additionally operable to receive the corresponding unit of the data with described caching that described database server sends
Data structure.
The database server of the present embodiment is used for executing the technical scheme of embodiment of the method shown in Fig. 3, and it realizes principle
Similar with technique effect, here is omitted.
One of ordinary skill in the art will appreciate that：The all or part of step realizing above-mentioned each method embodiment can be led to
Cross the related hardware of programmed instruction to complete.Aforesaid program can be stored in a computer read/write memory medium.This journey
Sequence upon execution, executes the step including above-mentioned each method embodiment；And aforesaid storage medium includes：ROM, RAM, magnetic disc or
Person's CD etc. is various can be with the medium of store program codes.
Finally it should be noted that：Various embodiments above only in order to technical scheme to be described, is not intended to limit；To the greatest extent
Pipe has been described in detail to the present invention with reference to foregoing embodiments, it will be understood by those within the art that：Its according to
So the technical scheme described in foregoing embodiments can be modified, or wherein some or all of technical characteristic is entered
Row equivalent；And these modifications or replacement, do not make the essence of appropriate technical solution depart from various embodiments of the present invention technology
The scope of scheme.
Claims (10)
1. a kind of data base query method is it is characterised in that include：
The inquiry request that receiving data storehouse client sends, comprises inquiry mark ID and query argument in described inquiry request；
Determine the inquiry plan prestoring according to described inquiry ID；
According to the inquiry plan of described query argument and determination, the data caching in advance executes data query；
Send Query Result to described database client；
Before the inquiry request that described receiving data storehouse client sends, also include：
Inquiry ID and query logic that receiving data storehouse client sends, comprise in described query logic corresponding to described inquiry ID
The attribute description information of inquiry data；
To described attribute description information, corresponding data enters row cache；
Generate the corresponding inquiry plan of data with caching and search index, and described inquiry ID is carried out with described inquiry plan
Association；
Send metadata structure corresponding with the data of described caching to described database client.
2. method according to claim 1 it is characterised in that described according to described query argument and determine inquiry meter
Draw, the data caching in advance executes data query, including：
According to described query argument, determine search index；
According to described search index, determine inquiry address, and by the data copy preserving at described inquiry address to output buffering
Area；
Described to described database client send Query Result, including：
Data is activation in described output buffer is given described database client.
3. method according to claim 2 is it is characterised in that described determine inquiry address according to described search index, and
By the data copy preserving at described inquiry address to output buffer, including：
According to described search index, determine at least two inquiry addresses, wherein, in each corresponding tables of data in inquiry address
Storage address；
According to each inquiry address, searching data from corresponding tables of data, and the data copy that will find from each tables of data
To output buffer.
4. method according to claim 1 is it is characterised in that described data corresponding to described attribute description information is carried out
Caching, including：
According to described attribute description information, at least two tables of data are associated；
The tables of data of association is entered row cache.
5. a kind of data base query method is it is characterised in that include：
Send inquiry request to database server, in described inquiry request, comprise inquiry mark ID and query argument, so that institute
State database server and determine the inquiry plan prestoring according to described inquiry ID, and according to described query argument and determination
Inquiry plan, executes data query in the data caching in advance；
Receive the Query Result that described database server sends；
Before the described transmission inquiry request to database server, also include：
Send inquiry ID and query logic to described database server, comprise in described query logic corresponding to described inquiry ID
The attribute description information of inquiry data, so that described database server is to described attribute description information, and corresponding data is delayed
Deposit, generate inquiry plan corresponding with the data caching and search index, and described inquiry ID is carried out with described inquiry plan
Association；
Receive the corresponding metadata structure of the data with described caching that described database server sends.
6. a kind of database server is it is characterised in that include：
Receiver module, the inquiry request sending for receiving data storehouse client, comprise inquiry mark ID in described inquiry request
And query argument；
Determining module, for determining the inquiry plan prestoring according to described inquiry ID；
Enquiry module, for the inquiry plan according to described query argument and determination, executes data in the data caching in advance
Inquiry；
Sending module, for sending Query Result to described database client；
Described receiver module, was additionally operable to before the inquiry request that receiving data storehouse client sends：
Inquiry ID and query logic that receiving data storehouse client sends, comprise in described query logic corresponding to described inquiry ID
The attribute description information of inquiry data；
Described database server, also includes：
Cache module, enters row cache for data corresponding to described attribute description information, generates corresponding with the data of caching
Inquiry plan and search index, and described inquiry ID is associated with described inquiry plan；
Described sending module, is additionally operable to send metadata knot corresponding with the data of described caching to described database client
Structure.
7. database server according to claim 6 is it is characterised in that described enquiry module, including：
Determining unit, for according to described query argument, determining search index；
Copy cell, for according to described search index, determining inquiry address, and the data preserving at described inquiry address is copied
Shellfish is to output buffer；
Described sending module, specifically for：
Data is activation in described output buffer is given described database client.
8. database server according to claim 7 is it is characterised in that described copy cell, specifically for：
According to described search index, determine at least two inquiry addresses, wherein, in each corresponding tables of data in inquiry address
Storage address；
According to each inquiry address, searching data from corresponding tables of data, and the data copy that will find from each tables of data
To output buffer.
9. database server according to claim 6 is it is characterised in that described cache module, specifically for：
According to described attribute description information, at least two tables of data are associated；
The tables of data of association is entered row cache.
10. a kind of database client is it is characterised in that include：
Sending module, for sending inquiry request to database server, comprises inquiry mark ID and looks in described inquiry request
Ask parameter, so that described database server determines, according to described inquiry ID, the inquiry plan prestoring, and looked into according to described
Ask parameter and the inquiry plan determining, the data caching in advance executes data query；
Receiver module, for receiving the Query Result that described database server sends；
Described sending module, was additionally operable to before sending inquiry request to database server：
Send inquiry ID and query logic to described database server, comprise in described query logic corresponding to described inquiry ID
The attribute description information of inquiry data, so that described database server is to described attribute description information, and corresponding data is delayed
Deposit, generate inquiry plan corresponding with the data caching and search index, and described inquiry ID is carried out with described inquiry plan
Association；
Described receiver module, is additionally operable to receive the corresponding metadata of the data with described caching that described database server sends
Structure.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410027522.0A CN103729471B (en) | 2014-01-21 | 2014-01-21 | Data base query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410027522.0A CN103729471B (en) | 2014-01-21 | 2014-01-21 | Data base query method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103729471A CN103729471A (en) | 2014-04-16 |
| CN103729471B true CN103729471B (en) | 2017-03-08 |
Family
ID=50453545
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410027522.0A Active CN103729471B (en) | 2014-01-21 | 2014-01-21 | Data base query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103729471B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112784139A (en) * | 2021-01-13 | 2021-05-11 | 多点(深圳)数字科技有限公司 | Query method, query device, electronic equipment and computer readable medium |
Families Citing this family (23)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105224560B (en) * | 2014-06-20 | 2019-12-06 | 腾讯科技（北京）有限公司 | Cache data searching method and device |
| CN105447009A (en) * | 2014-08-12 | 2016-03-30 | 阿里巴巴集团控股有限公司 | Method and device for generating query strings |
| CN104866603B (en) * | 2015-06-01 | 2018-09-25 | 明算科技（北京）股份有限公司 | The call method and metadata management system of metadata |
| CN106708838A (en) * | 2015-11-12 | 2017-05-24 | 华为技术有限公司 | Flow data query method and apparatus |
| CN106776638A (en) * | 2015-11-24 | 2017-05-31 | 大唐软件技术股份有限公司 | Database operation method and device |
| CN105760477A (en) * | 2016-02-15 | 2016-07-13 | 中国建设银行股份有限公司 | Data query method and system for multiple data sources and associated equipment therefore |
| CN107229628B (en) * | 2016-03-23 | 2022-02-01 | 金篆信科有限责任公司 | Distributed database preprocessing method and device |
| CN105930496A (en) * | 2016-05-06 | 2016-09-07 | 深圳市永兴元科技有限公司 | Data query method and system |
| CN108090056B (en) * | 2016-11-21 | 2021-06-15 | 中兴通讯股份有限公司 | Data query method, device and system |
| CN106528854A (en) * | 2016-11-28 | 2017-03-22 | 加和（北京）信息科技有限公司 | DMP querying method and device |
| CN106844740B (en) * | 2017-02-14 | 2020-12-29 | 华南师范大学 | Data pre-reading method based on memory object cache system |
| CN108664516A (en) * | 2017-03-31 | 2018-10-16 | 华为技术有限公司 | Enquiring and optimizing method and relevant apparatus |
| CN107451252A (en) * | 2017-07-30 | 2017-12-08 | 深圳有麦科技有限公司 | Method for quickly querying and its system based on API |
| CN107517262A (en) * | 2017-08-31 | 2017-12-26 | 江西博瑞彤芸科技有限公司 | Business datum storage method |
| CN110019559A (en) * | 2017-12-27 | 2019-07-16 | 航天信息股份有限公司 | A kind of data query method and system |
| CN110334114B (en) * | 2018-02-12 | 2024-05-17 | 北京京东尚科信息技术有限公司 | Method and device for inquiring data |
| CN109446386B (en) * | 2018-10-23 | 2020-10-27 | 中国银行股份有限公司 | Data query method and device |
| CN111506553B (en) * | 2019-01-31 | 2023-07-04 | 阿里巴巴集团控股有限公司 | Function setting method and device for database |
| CN111984849B (en) * | 2019-05-24 | 2025-06-13 | 北京京东尚科信息技术有限公司 | Information query method, device, equipment and medium |
| CN111488382A (en) * | 2020-04-16 | 2020-08-04 | 北京思特奇信息技术股份有限公司 | Data calling method and system and electronic equipment |
| CN112035522B (en) * | 2020-07-16 | 2021-09-07 | 中科驭数（北京）科技有限公司 | Database data acquisition method and device |
| CN113312355B (en) * | 2021-06-15 | 2025-03-18 | 北京沃东天骏信息技术有限公司 | A method and device for data management |
| CN115129749A (en) * | 2022-08-12 | 2022-09-30 | 济南浪潮数据技术有限公司 | Complex query optimization method, device and medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102141990A (en) * | 2010-02-01 | 2011-08-03 | 阿里巴巴集团控股有限公司 | Searching method and device |
| CN102930054A (en) * | 2012-11-19 | 2013-02-13 | 北京奇虎科技有限公司 | Data search method and data search system |
| CN103064960A (en) * | 2012-12-31 | 2013-04-24 | 华为技术有限公司 | Method and equipment for database query |
| CN103226610A (en) * | 2013-05-07 | 2013-07-31 | 华为技术有限公司 | Method and device for querying database table |
| CN103324724A (en) * | 2013-06-26 | 2013-09-25 | 华为技术有限公司 | Method and device for processing data |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9665620B2 (en) * | 2010-01-15 | 2017-05-30 | Ab Initio Technology Llc | Managing data queries |
-
2014
- 2014-01-21 CN CN201410027522.0A patent/CN103729471B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102141990A (en) * | 2010-02-01 | 2011-08-03 | 阿里巴巴集团控股有限公司 | Searching method and device |
| CN102930054A (en) * | 2012-11-19 | 2013-02-13 | 北京奇虎科技有限公司 | Data search method and data search system |
| CN103064960A (en) * | 2012-12-31 | 2013-04-24 | 华为技术有限公司 | Method and equipment for database query |
| CN103226610A (en) * | 2013-05-07 | 2013-07-31 | 华为技术有限公司 | Method and device for querying database table |
| CN103324724A (en) * | 2013-06-26 | 2013-09-25 | 华为技术有限公司 | Method and device for processing data |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112784139A (en) * | 2021-01-13 | 2021-05-11 | 多点(深圳)数字科技有限公司 | Query method, query device, electronic equipment and computer readable medium |
| CN112784139B (en) * | 2021-01-13 | 2024-07-02 | 多点(深圳)数字科技有限公司 | Query method, device, electronic equipment and computer readable medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103729471A (en) | 2014-04-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103729471B (en) | Data base query method and device | |
| CN104685498B (en) | The hardware implementation mode of polymerization/division operation：Hash table method | |
| US9183267B2 (en) | Linked databases | |
| US9720992B2 (en) | DML replication with logical log shipping | |
| US9454558B2 (en) | Managing an index of a table of a database | |
| US10120900B1 (en) | Processing a database query using a shared metadata store | |
| US20140074771A1 (en) | Query optimization | |
| US9229960B2 (en) | Database management delete efficiency | |
| CN106708996B (en) | Method and system for full text search of relational database | |
| CN107783985B (en) | Distributed database query method, device and management system | |
| US12282498B2 (en) | Relationship retrieval in a partitioned list of records | |
| CN106095863B (en) | A kind of multidimensional data query and storage system and method | |
| CN105183735A (en) | Data query method and query device | |
| CN107943952A (en) | A kind of implementation method that full-text search is carried out based on Spark frames | |
| CN108509437A (en) | A kind of ElasticSearch inquiries accelerated method | |
| US20150310052A1 (en) | Managing a table of a database | |
| US20140337338A1 (en) | Efficient multi-tenant spatial and relational indexing | |
| US10812322B2 (en) | Systems and methods for real time streaming | |
| US20140019454A1 (en) | Systems and Methods for Caching Data Object Identifiers | |
| CN106484694B (en) | Full-text search method and system based on distributed data base | |
| US10929362B2 (en) | Adaptive query processor for query systems with limited capabilities | |
| CN102902763A (en) | Method and device for relating and retrieving information processing data and processing information tasks | |
| CN109947759A (en) | A data index establishment method, index retrieval method and device | |
| CN103886038A (en) | Data caching method and device | |
| CN103559307A (en) | Caching method and device for query |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20200214 Address after: 518129 Bantian HUAWEI headquarters office building, Longgang District, Guangdong, Shenzhen Patentee after: HUAWEI TECHNOLOGIES Co.,Ltd. Address before: 210012 Ande Gate No. 94, Yuhuatai District, Jiangsu, Nanjing Patentee before: Huawei Technologies Co.,Ltd. |
|
| TR01 | Transfer of patent right |