CN109299110A - Data query method, apparatus, storage medium and electronic equipment - Google Patents
Data query method, apparatus, storage medium and electronic equipment Download PDFInfo
- Publication number
- CN109299110A CN109299110A CN201811334227.4A CN201811334227A CN109299110A CN 109299110 A CN109299110 A CN 109299110A CN 201811334227 A CN201811334227 A CN 201811334227A CN 109299110 A CN109299110 A CN 109299110A
- Authority
- CN
- China
- Prior art keywords
- data
- line
- query
- line unit
- matched
- 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.)
- Granted
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This disclosure relates to a kind of data query method, device, storage medium and electronic equipment, it is related to information technology field, applied to server, this method comprises: the inquiry request that parsing is sent by terminal, to obtain at least one corresponding query pattern of at least one query information in inquiry request, search whether exist and matched first line unit of at least one query pattern in concordance list, when there are when at least one first line unit in concordance list, in the data line identified by least one first line unit in the database, it searches and the matched data line of at least one query information, terminal will be sent to as query result with the matched data line of at least one query information.The disclosure realizes the inquiry to distributed data base, improves the search efficiency of distributed data base, saves storage resource.
Description
Technical field
This disclosure relates to information technology field, and in particular, to a kind of data query method, apparatus, storage medium and electricity
Sub- equipment.
Background technique
With the fast development of the information technologies such as internet, cloud computing and Internet of Things, corresponding bring data volume is also to be in
The growth of existing explosion type, and traditional database is no longer satisfied the storage demand of mass data, therefore to mass data
Storage would generally select distributed data base (English: distributed data base, abbreviation: DDB).Such as Hbase data
Library is a PostgreSQL database distributed, towards column, is suitable for unstructured data storage, reads in Hbase database
The mode for taking a line to record is, by the line unit (English: Rowkey) for capableing of unique identification a line record.
In the prior art, the inquiry that realize Hbase database needs manually to the table or specified specified in database
Column establish index (part column are mapped out from database), when being inquired, only inquire in the column that index maps out, thus
Return to line unit.Since the data volume in database is very big, and structure is complicated, therefore the efficiency inquired is very low, while establishing rope
Draw and also consumes memory space.
Summary of the invention
Purpose of this disclosure is to provide a kind of data query method, apparatus, storage medium and electronic equipments, existing to solve
The problem of having efficiency data query in technology low, expending memory space.
To achieve the goals above, according to the first aspect of the embodiments of the present disclosure, a kind of data query method is provided, is applied
In server, which comprises
The inquiry request sent by terminal is parsed, it is corresponding extremely to obtain at least one query information in the inquiry request
A few query pattern；
Search whether exist and matched first line unit of at least one described query pattern in concordance list；
When in the concordance list there are when the first line unit described at least one, in the database by least one described institute
It states in the data line that the first line unit is identified, searches and the matched data line of at least one query information；
The terminal will be sent to as query result with the matched data line of at least one query information.
Optionally, it in the data line identified by least one described described first line unit in the database, looks into
It looks for and the matched data line of at least one query information, comprising:
When in the concordance list there are when the first line unit described at least one, by least one institute described in the database
Data line that the first line unit is identified is stated as target line；
It is searched and the matched data line of at least one query information in the target line.
Optionally, it is described when in the concordance list there are when the first line unit described at least one, by institute in the database
Data line that at least one described first line unit is identified is stated as target line, comprising:
When there are when the first line unit described at least one, determine each first line unit corresponding in the concordance list
One table name；
The tables of data that each first table name is identified is searched in the database；
At least one data line that at least one described described first line unit is identified is determined in all tables of data；
By at least one described data line as the target line.
Optionally, described to parse the inquiry request sent by terminal, it is inquired with obtaining at least one in the inquiry request
At least one corresponding query pattern of information, comprising:
According at least one described query information, the matched regular expression of each query information is obtained；
Using each matched regular expression of query information as a query pattern.
Optionally, the method also includes:
When first line unit is not present in the concordance list, search and the query pattern in the database
The target data matched arranges, and the matched regular expression of data institute in the target data column is identical as the query pattern；
When there are when target data column described at least one, determine at least one described described number of targets in the database
According at least one corresponding second line unit of column and corresponding second table name of each second line unit；
The tables of data that each second table name is identified is searched in the database；
At least one data line that at least one described second line unit is identified is determined in all tables of data；
In at least one data line that at least one described second line unit is identified at least one described query information
Matched data line is sent to the terminal as query result；
According at least one described second line unit, each corresponding second table name of second line unit and the inquiry mould
Formula updates the concordance list.
Optionally, in described at least one data line for being identified at least one described second line unit with described at least one
A matched data line of query information is sent to the terminal as query result, comprising:
At least one data line that at least one described second line unit is identified is as target line；
Institute is sent to as query result with the matched data line of at least one query information using in the target line
State terminal.
Optionally, the method also includes:
When the target data column are not present in the database, it will be prompted to information and be sent to the terminal, it is described to mention
Show that information is used to indicate inquiry failure.
Optionally, described at least one second line unit according to, corresponding second table name of each second line unit and
The query pattern updates the concordance list, comprising:
By the corresponding relationship of each second line unit and the query pattern, the query pattern and the target data
The corresponding relationship of column is stored in the concordance list.
According to the second aspect of an embodiment of the present disclosure, a kind of data query device is provided, server, described device are applied to
It include: parsing module, for parsing the inquiry request sent by terminal, to obtain at least one inquiry letter in the inquiry request
Cease at least one corresponding query pattern；
First searching module, for searching whether exist and at least one described query pattern matched the in concordance list
One line unit；
Second searches sending module, for when in the concordance list there are when the first line unit described at least one, in data
In the data line identified by least one described described first line unit in library, search and at least one described query information
The data line matched；
Sending module, for institute will to be sent to as query result with the matched data line of at least one query information
State terminal.
Optionally, the second lookup sending module includes:
First searches submodule, for when in the concordance list there are when the first line unit described at least one, by the number
According to the data line that at least one described first line unit is identified described in library as target line；
Second searches submodule, for searching and the matched data of at least one query information in the target line
Row.
Optionally, the first lookup submodule is used for:
When there are when the first line unit described at least one, determine each first line unit corresponding in the concordance list
One table name；
The tables of data that each first table name is identified is searched in the database；
At least one data line that at least one described described first line unit is identified is determined in all tables of data；
By at least one described data line as the target line.
Optionally, the parsing module includes:
Analyzing sub-module, for obtaining the matched canonical table of each query information according at least one described query information
Up to formula；
Mode determines submodule, for using each matched regular expression of query information as an inquiry
Mode.
Optionally, described device further include:
Data column searching module is used for when first line unit is not present in the concordance list, in the database
Search and arranged with the matched target data of the query pattern, the matched regular expression of data institute in the target data column with
The query pattern is identical；
The data column searching module, be also used to when in the database there are when target data column described at least one,
Determine that at least one described described target data arranges at least one corresponding second line unit and each second line unit is corresponding
Second table name；
The data column searching module is also used to search the number that each second table name is identified in the database
According to table；
The data column searching module is also used to determine at least one described second line unit institute in all tables of data
At least one data line of mark；
The sending module, at least one data line for being also used to be identified at least one described second line unit with institute
The matched data line of at least one query information is stated as query result and is sent to the terminal；
Update module, for according at least one described second line unit, corresponding second table name of each second line unit
With the query pattern, the concordance list is updated.
Optionally, the sending module includes:
Submodule is inquired, at least one data line for being identified at least one described second line unit is as target
Row；
Sending submodule, for using in the target line with the matched data line of at least one query information as looking into
It askes result and is sent to the terminal.
Optionally, the sending module, is also used to:
When the target data column are not present in the database, it will be prompted to information and be sent to the terminal, it is described to mention
Show that information is used to indicate inquiry failure.
Optionally, the update module is used for:
By the corresponding relationship of each second line unit and the query pattern, the query pattern and the target data
The corresponding relationship of column is stored in the concordance list.
According to the third aspect of an embodiment of the present disclosure, a kind of computer readable storage medium is provided, calculating is stored thereon with
The step of machine program, the data query method that realization first aspect provides when which is executed by processor.
According to a fourth aspect of embodiments of the present disclosure, a kind of electronic equipment is provided, comprising:
Memory is stored thereon with computer program；
Processor, for executing the computer program in the memory, to realize the data of first aspect offer
The step of querying method.
Through the above technical solutions, the disclosure receives the inquiry request sent by terminal first, by parsing inquiry request,
It include at least one corresponding query pattern of at least one query information in inquiry request to obtain, then lookup is in concordance list
No presence and matched first line unit of at least one query pattern, when there is one or more first line units in concordance list,
Lookup and the matched data line of at least one query information in the data line that all first line units are identified, finally will be at least one
A matched data line of query information is sent to terminal as query result.It can be realized the inquiry to distributed data base, mention
The high search efficiency of distributed data base, saves storage resource.
Other feature and advantage of the disclosure will the following detailed description will be given in the detailed implementation section.
Detailed description of the invention
Attached drawing is and to constitute part of specification for providing further understanding of the disclosure, with following tool
Body embodiment is used to explain the disclosure together, but does not constitute the limitation to the disclosure.In the accompanying drawings:
Fig. 1 is a kind of flow chart of data query method shown according to an exemplary embodiment；
Fig. 2 is the flow chart of another data query method shown according to an exemplary embodiment；
Fig. 3 is the flow chart of another data query method shown according to an exemplary embodiment；
Fig. 4 is the flow chart of another data query method shown according to an exemplary embodiment；
Fig. 5 is the flow chart of another data query method shown according to an exemplary embodiment；
Fig. 6 is a kind of block diagram of data query device shown according to an exemplary embodiment；
Fig. 7 is the block diagram of another data query device shown according to an exemplary embodiment；
Fig. 8 is the block diagram of another data query device shown according to an exemplary embodiment；
Fig. 9 is the block diagram of another data query device shown according to an exemplary embodiment；
Figure 10 is the block diagram of another data query device shown according to an exemplary embodiment；
Figure 11 is the block diagram of a kind of electronic equipment shown according to an exemplary embodiment.
Specific embodiment
Example embodiments are described in detail here, and the example is illustrated in the accompanying drawings.Following description is related to
When attached drawing, unless otherwise indicated, the same numbers in different drawings indicate the same or similar elements.Following exemplary embodiment
Described in embodiment do not represent all implementations consistent with this disclosure.On the contrary, they be only with it is such as appended
The example of the consistent device and method of some aspects be described in detail in claims, the disclosure.
Before introducing data query method, apparatus, storage medium and the electronic equipment of disclosure offer, first to this public affairs
It opens application scenarios involved in each embodiment to be introduced, includes server and terminal in the application scenarios, terminal can
It is communicated by network with server, database (such as can be Hbase database) is contained in server, can be received
The inquiry request that terminal is sent, and query result is returned into terminal.Wherein, server can be local server, can also be with
Cloud server, terminal for example can be smart phone, tablet computer, smart television, smartwatch, PDA (English:
Personal Digital Assistant, Chinese: personal digital assistant), the mobile terminals such as portable computer, be also possible to platform
The fixed terminals such as formula computer.
Fig. 1 is a kind of flow chart of data query method shown according to an exemplary embodiment, as shown in Figure 1, the party
Method is applied to server, comprising:
Step 101, the inquiry request sent by terminal is parsed, it is corresponding to obtain at least one query information in inquiry request
At least one query pattern.
For example, when user requires to look up the data in database, inquiry can be sent by terminal to server and asked
It asks, may include the data to be inquired of user in inquiry request, is i.e. query information, query information can be one or more.Clothes
Device be engaged in after receiving inquiry request, each of inquiry request query information is parsed, to obtain this at least one
The corresponding one or more query patterns of query information.Wherein, the query information in inquiry request can be according to preset DSL
(English: Domain-specific Languages, Chinese: field language-specific) description, server is to inquiry request with right
The DSL answered parses query information, and to obtain the corresponding query pattern of query information, query pattern, which can be understood as user, to be looked into
The attribute of the data of inquiry, i.e., the data format of a certain data column in database, query pattern can have one or more, each
The data format of a certain data column in query pattern correspondence database.It is required to look up in database with user comprising identification card number
For 211123456789101234 and name be Li Ming data, pass through terminal to server send inquiry request, inquiry request
Including<211123456789101234>AND<Li Ming>, i.e., " 211123456789101234 " are a query information, " Li Ming "
For a query information, server parses two query informations, and obtain two query patterns: 17 or 18 bit digitals are (i.e.
The corresponding query pattern of identification card number), 2-4 Chinese characters (i.e. the corresponding query pattern of name).
Step 102, search whether exist and matched first line unit of at least one query pattern in concordance list.
It is exemplary, search whether to exist in concordance list with matched first line unit of whole query patterns, can in concordance list
It further include these data column pair with the mode comprising certain data column (or referred to as field) in tables of data each in database
One or more line units are answered, while can also be including the corresponding table name of line unit each in these line units, wherein table name can be unique
Mark data table, it is also necessary to which explanation is.First line unit can be zero, one or more.When the first line unit is not present (i.e. zero
It is a) when, indicate do not have to arrange with the data of whole query pattern exact matchings in concordance list, when the first line unit is one or more
When, indicate that there are data exactly match with whole query patterns in concordance list arranges, the corresponding line unit of these data column is the
One line unit.It is arranged with the matched data of whole query patterns, it can be understood as the mode of data and query pattern be one by one in data column
It is corresponding, i.e., according to the corresponding relationship of line unit in concordance list and query pattern, by concordance list with the matched whole rows of query pattern
Key is as the first line unit group.For example, in concordance list there are two data column in data, respectively meet 17 or 18 bit digitals
Mode and 2-4 Chinese characters mode, then can determine the two data column with<211123456789101234>AND<Lee
Bright > the query pattern that is parsed matching, it is the first line unit that the two corresponding data, which arrange corresponding line unit,.It needs to illustrate
It is the data column for including in concordance list, corresponding data column in the query pattern inquired before can be are also possible in advance
Specified certain data column.
Step 103, when in concordance list there are when at least one first line unit, in the database by least one the first row
In the data line that key is identified, search and the matched data line of at least one query information.
Step 104, terminal will be sent to as query result with the matched data line of at least one query information.
For example, when there are one or more line units in concordance list, according to the relationship of line unit in concordance list and table name,
It determines the corresponding table name of each first line unit, determines that each first line unit is corresponding further according to the corresponding table name of each first line unit
Tables of data, then the data line that all the first line unit is identified in tables of data is obtained, later in the number that all the first line unit is identified
It, finally will be with the matched data line of at least one query information according to lookup in row and the matched data line of at least one query information
Terminal is sent to as query result.Wherein, the quantity of the first line unit is greater than or equal to the number of tables of data, i.e. a tables of data
One or more first line units can be corresponded to.For example, inquiry request includes<211123456789101234>AND<Li Ming>, then
The query pattern parsed is 17 or 18 bit digitals and 2-4 Chinese characters namely query pattern is identification card number and name, it is assumed that rope
Draw in table there are two data column to match respectively with 17 or 18 bit digitals and 2-4 Chinese character the two query patterns, accordingly this
Two data column have corresponded to three line units, then these three line units are exactly that the first above-mentioned line unit (can be understood as having found and meet
The mark of the data line of querying condition in inquiry request), it is assumed that these three first line units are respectively as follows: 1001101,1100110,
1100111, then can take out 1001101,1100110,1,100,111 three data lines identified in database, then this three
Inquiry includes the data line of " 211123456789101234 " and " Li Ming " in a data line, is sent to end as query result
End.
For example, storing the population information in certain city in database, it is now desired to searching name in database is " Wang Ming ",
Identification card number be " 610123456789101234 ", gender be " male " data, can be inputted by terminal<Wang Ming>AND<
Inquiry request is sent to server by the inquiry request of 610123456789101234>AND<male>, terminal.Server is receiving
To after the inquiry request, inquiry request is parsed, to three query informations " Wang Ming " for including in inquiry request,
" 610123456789101234 " and " male " seek corresponding regular expression respectively, to obtain three query patterns: 2-4 Chinese characters
(the corresponding inquiry of gender of the bit digital of (the corresponding query pattern of name), 17 or 18 (the corresponding query pattern of identification card number), 0 or 1
Mode).Later, searched whether in concordance list exist with matched first line unit of whole query patterns, i.e., in search index table
With the presence or absence of the data in three data column, meet the mode of the bit digital of 2-4 Chinese characters, 17 or 18,0 or 1 respectively, if deposited
Arranging corresponding line unit in, these three data is the first line unit, such as three data arrange corresponding two the first line units, are respectively as follows:
1111101,1100000, two data lines of 1111101,1100000 marks in database are taken out, finally by the two data
Data line in row including " Wang Ming ", " 610123456789101234 " and " male " is sent to terminal as query result, such as
Include " Wang Ming " in the data line of 1100000 marks, but does not include " 610123456789101234 " and " male ", and 1111101
Include simultaneously in the data line of mark " Wang Ming ", " 610123456789101234 " and " male ", then by the data of 1111101 marks
1111101 data lines identified are taken out in the corresponding tables of data of row, are sent to terminal as final query result.
In conclusion the disclosure receives the inquiry request sent by terminal first, by parsing inquiry request, to be looked into
Asking includes at least one corresponding query pattern of at least one query information in request, then search whether in concordance list to exist with
Matched first line unit of at least one query pattern, when there is one or more first line units in concordance list, all first
Lookup and the matched data line of at least one query information in the data line that line unit is identified will finally be believed at least one inquiry
Matched data line, which is ceased, as query result is sent to terminal.It can be realized the inquiry to distributed data base, improve distribution
The search efficiency of formula database, saves storage resource.
Fig. 2 is the flow chart of another data query method shown according to an exemplary embodiment, as shown in Fig. 2, step
Rapid 103 can be realized by following steps:
Step 1031, when in concordance list there are when at least one first line unit, by the first line unit of at least one in database
The data line identified is as target line.
Step 1032, it is searched and the matched data line of at least one query information in target line.
It is exemplary, when there is one or more line units in concordance list, according to the relationship of line unit in concordance list and table name, really
Determine the corresponding table name of each first line unit, determines the corresponding number of each first line unit further according to the corresponding table name of each first line unit
According to table, then using all the data line that is identified of the first line units is searched in target line and extremely later as target line in tables of data
A few matched data line of query information.
Optionally, step 1031 can be accomplished by the following way:
1) when there are when at least one first line unit, determine corresponding first table name of each first line unit in concordance list.
2) tables of data that each first table name is identified is searched in the database.
3) at least one data line that at least one first line unit is identified is determined in all tables of data.
4) will an at least data line as target line.
For example, when in concordance list there are when at least one first line unit, first according to line unit in concordance list and table name
Corresponding relationship, determine corresponding first table name of each first line unit, wherein the quantity of the first line unit be greater than or equal to the first table
Quantity (the i.e. tables of data of corresponding first table name mark of first line unit, the tables of data of first table name mark of name
May include multiple first line units), then determine the tables of data that the first table name is identified in database, all tables of data are obtained later
The total data row (the first line unit and data line correspond) that middle the first line unit of whole is identified, finally makees total data row
For target line.For example, arranging in concordance list there are two data is parsed with<211123456789101234>AND<Li Ming>respectively
Query pattern matching out, the two corresponding data arrange corresponding three the first line units, be respectively as follows: 1001101,1100110,
1100111, first determine the corresponding table name of three the first line units, table name belonging to 1001101 are as follows: 0x5211,1100110 Hes
Table name belonging to 1100111 is all 0x7100, then the corresponding tables of data of 0x5211 and 0x7100 is searched in the database, and
A 1001101 corresponding data lines are taken out in the tables of data of 0x5211 mark, are taken out in the tables of data of 0x7100 mark
1100110,1100111 corresponding two data lines, using these three data lines as target line.
Fig. 3 is the flow chart of another data query method shown according to an exemplary embodiment, as shown in figure 3, step
Rapid 101 may include:
Step 1011, according at least one query information, the matched regular expression of each query information is obtained.
Step 1012, using the matched regular expression of each query information as a query pattern.
It is exemplary, it may include one or more query informations in inquiry request, query information for example can be text
Format, by the corresponding data of each query information according to regular expression (English: Regular Expression) rule into
Row description, to obtain the matched regular expression of each query information, using the matched regular expression of each query information as
One query pattern, the i.e. corresponding query pattern of a regular expression, multiple regular expressions correspond to multiple queries mode.
Correspondingly, query pattern is matched with data column, then it can be understood as regular expression corresponding to the data in data column and look into
The corresponding regular expression of inquiry mode is identical.It is<Zhang San>AND<male>citing with inquiry request, server can remove inquiry and ask
After the bound symbol (such as: AND, OR etc.) asked, parse two query informations for including in inquiry request: " Zhang San " and
" male " " male " corresponding data are described according to the rule of regular expression, i.e., 0 or 1 (the corresponding query pattern of gender),
" Zhang San " corresponding data are described according to the rule of regular expression, i.e. 2-4 Chinese character (the corresponding inquiry mould of name
Formula), by " name ", " gender " corresponding two regular expressions as two query patterns.
Fig. 4 is the flow chart of another data query method shown according to an exemplary embodiment, as shown in figure 4, should
Method is further comprising the steps of:
Step 105, it when the first line unit is not present in concordance list, searches and the matched target of query pattern in the database
Data arrange, and the matched regular expression of data institute in target data column is identical as query pattern.
It for example, can be by searching in the database and query pattern when the first line unit is not present in concordance list
Matched target data column are to inquire data, wherein the matched regular expression of data institute and inquiry mould in target data column
Formula is identical.
Step 106, when there are when at least one target data column, determine at least one target data column correspondence in database
At least one second line unit and corresponding second table name of each second line unit.
Step 107, the tables of data that each second table name is identified is searched in the database.
Step 108, at least one data line that at least one second line unit is identified is determined in all tables of data.
Step 109, at least one data line at least one second line unit identified at least one query information
Matched data line is sent to terminal as query result.
It is exemplary, when there are target data column matched with query pattern in database, it can determine that target data arranges
Corresponding second line unit and corresponding second table name of each second line unit.Wherein, the second line unit can be one or more, the
The quantity of two table names is less than or equal to the quantity of the second line unit.Corresponding tables of data is determined further according to the second table name, finally by institute
Have in tables of data in the total data row (the second line unit and data line correspond) that all the second line units are identified at least one
A matched data line of query information is sent to terminal as query result.Above-mentioned determines at least one in all tables of data
At least one data line that second line unit is identified, and at least one data line that the second line unit is identified determine with extremely
The method that a few matched data line of query information is sent to terminal, and is directed to the first line unit mark in above-mentioned steps 103 and 104
The processing method at least one data line known is identical, repeats no more.
Step 110, according at least one second line unit, corresponding second table name of each second line unit and query pattern, more
New concordance list.
It is exemplary, it, will after the second line unit and corresponding second table name of each second line unit have been determined in step 106
Corresponding relationship between query pattern and the second line unit, the second table name is stored in concordance list, updates concordance list to inquire energy later
It is enough that query result is directly obtained according to concordance list.Wherein it is possible to by the corresponding relationship of each second line unit and query pattern, look into
The corresponding relationship of inquiry mode and target data column, is stored in concordance list, i.e., it is corresponding with query pattern to contain line unit in concordance list
The corresponding relationship of data arrange in relationship, query pattern and database corresponding relationship, line unit and table name, wherein line unit and data
Row corresponds, and table name and tables of data correspond, and tables of data may include one or more line units.
Fig. 5 is the flow chart of another data query method shown according to an exemplary embodiment, as shown in figure 5, step
Rapid 109 may comprise steps of:
Step 1091, at least one data line at least one second line unit identified is as target line.
Step 1092, end is sent to as query result with the matched data line of at least one query information using in target line
End.
It is exemplary, when there are target data column matched with query pattern in database, it can determine that target data arranges
Corresponding second line unit and corresponding second table name of each second line unit.Wherein, the second line unit can be one or more, the
The quantity of two table names is less than or equal to the quantity of the second line unit.Corresponding tables of data is determined further according to the second table name, finally by institute
There is the total data row (the second line unit and data line correspond) that all the second line unit is identified in tables of data to be used as target line,
Terminal is sent to as query result with the matched data line of at least one query information using in target line again.
It should be noted that being determined in step 102 and the first row being not present when concordance list is empty (when first inquiry)
Key executes step 105 to step 106, inquires in database and arrange with the presence or absence of target data, if it does, by query pattern and
Target data arranges corresponding second line unit, the second table name is stored in concordance list, has at this time included in first inquiry in concordance list
Inquiry instruction corresponding index information can be directly from index when sending identical inquiry instruction again so as to terminal later
The first line unit is searched in table.With increasing for inquiry times, the also more and more (inquiries time of query pattern included in concordance list
Number is bigger, and the query pattern in concordance list eventually maintains a Finite Number magnitude), therefore, in the present embodiment, do not need pre-
Concordance list is first established manually, can dynamically establish concordance list during data query, is avoided and is established concordance list band manually
The workload come, and the structure (i.e. the modes of data in data column) of data in database can be accurately identified, improve rope
Draw the accuracy of table foundation and data query.Further, for the extending transversely of database, modification concordance list is not needed, it can
With during data query, automatic adaptation concordance list improves the efficiency of data query.
Optionally, this method may also comprise the following steps::
When target data column are not present in database, it will be prompted to information and be sent to terminal, prompt information, which is used to indicate, to be looked into
Ask failure.
It is exemplary, when determining that there is no target datas to arrange in database in step 105, then indicating in database without full
The data line of sufficient query pattern can send prompt information to terminal at this time, and to prompt the user of using terminal, this time inquiry is lost
It loses.
In conclusion the disclosure receives the inquiry request sent by terminal first, by parsing inquiry request, to be looked into
Asking includes at least one corresponding query pattern of at least one query information in request, then search whether in concordance list to exist with
Matched first line unit of at least one query pattern, when there is one or more first line units in concordance list, all first
Lookup and the matched data line of at least one query information in the data line that line unit is identified will finally be believed at least one inquiry
Matched data line, which is ceased, as query result is sent to terminal.It can be realized the inquiry to distributed data base, improve distribution
The search efficiency of formula database, saves storage resource.
Fig. 6 is a kind of block diagram of data query device shown according to an exemplary embodiment, as shown in fig. 6, the device
200 are applied to server, comprising:
Parsing module 201 is inquired for parsing the inquiry request sent by terminal with obtaining at least one in inquiry request
At least one corresponding query pattern of information.
First searching module 202, for searching whether exist and at least one query pattern matched the in concordance list
One line unit.
Second searching module 203, for when in concordance list there are when at least one first line unit, in the database by extremely
In the data line that few first line unit is identified, search and the matched data line of at least one query information.
Sending module 204, for end will to be sent to as query result with the matched data line of at least one query information
End.
Fig. 7 is the block diagram of another data query device shown according to an exemplary embodiment, as shown in fig. 7, second
Searching module 203 includes:
First searches submodule 2031, for when in concordance list there are when at least one first line unit, by database extremely
The data line that few first line unit is identified is as target line.
Second searches submodule 2032, for searching and the matched data line of at least one query information in target line.
Optionally, the first lookup submodule 2031 can be used for executing following steps:
1) when there are when at least one first line unit, determine corresponding first table name of each first line unit in concordance list.
2) tables of data that each first table name is identified is searched in the database.
3) at least one data line that at least one first line unit is identified is determined in all tables of data.
4) will an at least data line as target line.
Fig. 8 is the block diagram of another data query device shown according to an exemplary embodiment, as shown in figure 8, parsing
Module 201 includes:
Analyzing sub-module 2011, for obtaining the matched canonical table of each query information according at least one query information
Up to formula.
Mode determines submodule 2012, for using the matched regular expression of each query information as an inquiry mould
Formula.
Fig. 9 is the block diagram of another data query device shown according to an exemplary embodiment, as shown in figure 9, the dress
Set 200 further include:
Data column searching module 205, for searching and inquiring in the database when the first line unit is not present in concordance list
The target data of pattern match arranges, and the matched regular expression of data institute in target data column is identical as query pattern.
Data column searching module 205 is also used to when there are when at least one target data column, determining at least one in database
A target data arranges at least one corresponding second line unit and corresponding second table name of each second line unit.
Data column searching module 205 is also used to search the tables of data that each second table name is identified in the database.
Data column searching module 205, be also used in all tables of data determine at least one second line unit identified to
A few data line.
Sending module 204, at least one at least one data line for being also used to be identified at least one the second line unit
A matched data line of query information is sent to terminal as query result.
Update module 206, for according at least one second line unit, corresponding second table name of each second line unit and inquiry
Mode updates concordance list.
Figure 10 is the block diagram of another data query device shown according to an exemplary embodiment, as shown in Figure 10, hair
The module 204 is sent to include:
Submodule 2041 is inquired, at least one data line for being identified at least one second line unit is as target
Row.
Sending submodule 2042, for being tied in target line with the matched data line of at least one query information as inquiry
Fruit is sent to terminal.
Optionally, sending module 203 can be also used for:
When target data column are not present in database, it will be prompted to information and be sent to terminal, prompt information, which is used to indicate, to be looked into
Ask failure.
Optionally, update module 205 can be used to implement following steps:
The corresponding relationship that the corresponding relationship of each second line unit and query pattern, query pattern and target data are arranged, is deposited
Enter concordance list.
About the device in above-described embodiment, wherein modules execute the concrete mode of operation in related this method
Embodiment in be described in detail, no detailed explanation will be given here.
In conclusion the disclosure receives the inquiry request sent by terminal first, by parsing inquiry request, to be looked into
Asking includes at least one corresponding query pattern of at least one query information in request, then search whether in concordance list to exist with
Matched first line unit of at least one query pattern, when there is one or more first line units in concordance list, all first
Lookup and the matched data line of at least one query information in the data line that line unit is identified will finally be believed at least one inquiry
Matched data line, which is ceased, as query result is sent to terminal.It can be realized the inquiry to distributed data base, improve distribution
The search efficiency of formula database, saves storage resource.
Figure 11 is the block diagram of a kind of electronic equipment 300 shown according to an exemplary embodiment.For example, electronic equipment 300
It may be provided as a server.Referring to Fig.1 1, electronic equipment 300 includes processor 322, and quantity can be one or more
A and memory 332, for storing the computer program that can be executed by processor 322.The calculating stored in memory 332
Machine program may include it is one or more each correspond to one group of instruction module.In addition, processor 322 can be by
It is configured to execute the computer program, to execute above-mentioned data query method.
In addition, electronic equipment 300 can also include power supply module 326 and communication component 350, which can be with
It is configured as executing the power management of electronic equipment 300, which, which can be configured as, realizes electronic equipment 300
Communication, for example, wired or wireless communication.In addition, the electronic equipment 300 can also include input/output (I/O) interface 358.Electricity
Sub- equipment 300 can be operated based on the operating system for being stored in memory 332, such as Windows ServerTM, Mac OS
XTM, UnixTM, LinuxTM etc..
In a further exemplary embodiment, a kind of computer readable storage medium including program instruction is additionally provided, it should
The step of above-mentioned data query method is realized when program instruction is executed by processor.For example, the computer readable storage medium
It can be the above-mentioned memory 332 including program instruction, above procedure instruction can be executed by the processor 322 of electronic equipment 300
To complete above-mentioned data query method.
In conclusion the disclosure receives the inquiry request sent by terminal first, by parsing inquiry request, to be looked into
Asking includes at least one corresponding query pattern of at least one query information in request, then search whether in concordance list to exist with
Matched first line unit of at least one query pattern, when there is one or more first line units in concordance list, all first
Lookup and the matched data line of at least one query information in the data line that line unit is identified will finally be believed at least one inquiry
Matched data line, which is ceased, as query result is sent to terminal.It can be realized the inquiry to distributed data base, improve distribution
The search efficiency of formula database, saves storage resource.
The preferred embodiment of the disclosure is described in detail in conjunction with attached drawing above, still, the disclosure is not limited to above-mentioned reality
The detail in mode is applied, in the range of the technology design of the disclosure, those skilled in the art are considering specification and practice
After the disclosure, it is readily apparent that other embodiments of the disclosure, belongs to the protection scope of the disclosure.
It is further to note that specific technical features described in the above specific embodiments, in not lance
In the case where shield, it can be combined in any appropriate way.Simultaneously between a variety of different embodiments of the disclosure
Any combination can also be carried out, as long as it, without prejudice to the thought of the disclosure, equally should be considered as disclosure disclosure of that.
The disclosure is not limited to the precision architecture being described above out, and the scope of the present disclosure is only limited by the attached claims
System.
Claims (10)
1. a kind of data query method, which is characterized in that be applied to server, which comprises
The inquiry request sent by terminal is parsed, to obtain at least one query information in the inquiry request corresponding at least one
A query pattern；
Search whether exist and matched first line unit of at least one described query pattern in concordance list；
When in the concordance list there are when the first line unit described at least one, in the database by it is described at least one described
In the data line that one line unit is identified, search and the matched data line of at least one query information；
The terminal will be sent to as query result with the matched data line of at least one query information.
2. the method according to claim 1, wherein it is described in the database by it is described at least one described
In the data line that one line unit is identified, search and the matched data line of at least one query information, comprising:
When in the concordance list there are when the first line unit described at least one, by described in the database at least one described
The data line that one line unit is identified is as target line；
It is searched and the matched data line of at least one query information in the target line.
3. according to the method described in claim 2, it is characterized in that, described there are described at least one the in the concordance list
When one line unit, using the data line that at least one described first line unit is identified described in the database as target line, comprising:
When there are when the first line unit described at least one, determine corresponding first table of each first line unit in the concordance list
Name；
The tables of data that each first table name is identified is searched in the database；
At least one data line that at least one described described first line unit is identified is determined in all tables of data；
By at least one described data line as the target line.
4. the method according to claim 1, wherein described parse the inquiry request sent by terminal, to obtain
At least one corresponding query pattern of at least one query information in the inquiry request, comprising:
According at least one described query information, the matched regular expression of each query information is obtained；
Using each matched regular expression of query information as a query pattern.
5. according to the method described in claim 4, it is characterized in that, the method also includes:
When first line unit is not present in the concordance list, search in the database matched with the query pattern
Target data arranges, and the matched regular expression of data institute in the target data column is identical as the query pattern；
When there are when target data column described at least one, determine at least one described described target data column in the database
At least one corresponding second line unit and corresponding second table name of each second line unit；
The tables of data that each second table name is identified is searched in the database；
At least one data line that at least one described second line unit is identified is determined in all tables of data；
It will be matched at least one data line that at least one described second line unit is identified at least one described query information
Data line be sent to the terminal as query result；
According at least one described second line unit, each corresponding second table name of second line unit and the query pattern, more
The new concordance list.
6. according to the method described in claim 5, it is characterized in that, it is described by least one described second line unit identified to
It is sent to the terminal as query result with the matched data line of at least one query information in a few data line, is wrapped
It includes:
At least one data line that at least one described second line unit is identified is as target line；
The end is sent to as query result with the matched data line of at least one query information using in the target line
End.
7. a kind of data query device, which is characterized in that be applied to server, described device includes:
Parsing module, for parsing the inquiry request sent by terminal, to obtain at least one inquiry letter in the inquiry request
Cease at least one corresponding query pattern；
First searching module, for searching whether exist and the matched the first row of at least one query pattern in concordance list
Key；
Second searches sending module, for when in the concordance list there are when the first line unit described at least one, in the database
The data line identified by least one described described first line unit in, search it is matched at least one described query information
Data line；
Sending module, for the end will to be sent to as query result with the matched data line of at least one query information
End.
8. device according to claim 7, which is characterized in that described second, which searches sending module, includes:
First searches submodule, for when in the concordance list there are when the first line unit described at least one, by the database
Described in the data line that is identified of at least one described first line unit as target line；
Second searches submodule, for searching and the matched data line of at least one query information in the target line.
9. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the program is held by processor
The step of any one of claim 1-6 the method is realized when row.
10. a kind of electronic equipment characterized by comprising
Memory is stored thereon with computer program；
Processor, for executing the computer program in the memory, to realize described in any one of claim 1-6
The step of method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811334227.4A CN109299110B (en) | 2018-11-09 | 2018-11-09 | Data query method and device, storage medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811334227.4A CN109299110B (en) | 2018-11-09 | 2018-11-09 | Data query method and device, storage medium and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109299110A true CN109299110A (en) | 2019-02-01 |
| CN109299110B CN109299110B (en) | 2020-09-25 |
Family
ID=65146366
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811334227.4A Active CN109299110B (en) | 2018-11-09 | 2018-11-09 | Data query method and device, storage medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109299110B (en) |
Cited By (41)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109918472A (en) * | 2019-02-27 | 2019-06-21 | 北京百度网讯科技有限公司 | Method, apparatus, equipment and the medium of storage and inquiry data |
| WO2020220216A1 (en) * | 2019-04-29 | 2020-11-05 | Splunk Inc. | Search time estimate in data intake and query system |
| CN111897840A (en) * | 2020-08-14 | 2020-11-06 | 北京字节跳动网络技术有限公司 | Data searching method and device, electronic equipment and storage medium |
| CN113297273A (en) * | 2021-06-09 | 2021-08-24 | 北京百度网讯科技有限公司 | Method and device for querying metadata and electronic equipment |
| CN113688150A (en) * | 2021-07-27 | 2021-11-23 | 珠海金山办公软件有限公司 | Keyword searching method and device, electronic equipment and storage medium |
| US11232100B2 (en) | 2016-09-26 | 2022-01-25 | Splunk Inc. | Resource allocation for multiple datasets |
| US11238112B2 (en) | 2016-09-26 | 2022-02-01 | Splunk Inc. | Search service system monitoring |
| US11250056B1 (en) | 2016-09-26 | 2022-02-15 | Splunk Inc. | Updating a location marker of an ingestion buffer based on storing buckets in a shared storage system |
| US11281706B2 (en) | 2016-09-26 | 2022-03-22 | Splunk Inc. | Multi-layer partition allocation for query execution |
| US11294941B1 (en) | 2016-09-26 | 2022-04-05 | Splunk Inc. | Message-based data ingestion to a data intake and query system |
| US11321321B2 (en) | 2016-09-26 | 2022-05-03 | Splunk Inc. | Record expansion and reduction based on a processing task in a data intake and query system |
| US11341131B2 (en) | 2016-09-26 | 2022-05-24 | Splunk Inc. | Query scheduling based on a query-resource allocation and resource availability |
| US11416528B2 (en) | 2016-09-26 | 2022-08-16 | Splunk Inc. | Query acceleration data store |
| US11442935B2 (en) | 2016-09-26 | 2022-09-13 | Splunk Inc. | Determining a record generation estimate of a processing task |
| US11461334B2 (en) | 2016-09-26 | 2022-10-04 | Splunk Inc. | Data conditioning for dataset destination |
| US11494380B2 (en) | 2019-10-18 | 2022-11-08 | Splunk Inc. | Management of distributed computing framework components in a data fabric service system |
| US11500875B2 (en) | 2017-09-25 | 2022-11-15 | Splunk Inc. | Multi-partitioning for combination operations |
| US11550847B1 (en) | 2016-09-26 | 2023-01-10 | Splunk Inc. | Hashing bucket identifiers to identify search nodes for efficient query execution |
| US11562023B1 (en) | 2016-09-26 | 2023-01-24 | Splunk Inc. | Merging buckets in a data intake and query system |
| US11567993B1 (en) | 2016-09-26 | 2023-01-31 | Splunk Inc. | Copying buckets from a remote shared storage system to memory associated with a search node for query execution |
| US11580107B2 (en) | 2016-09-26 | 2023-02-14 | Splunk Inc. | Bucket data distribution for exporting data to worker nodes |
| US11586692B2 (en) | 2016-09-26 | 2023-02-21 | Splunk Inc. | Streaming data processing |
| US11586627B2 (en) | 2016-09-26 | 2023-02-21 | Splunk Inc. | Partitioning and reducing records at ingest of a worker node |
| US11593377B2 (en) | 2016-09-26 | 2023-02-28 | Splunk Inc. | Assigning processing tasks in a data intake and query system |
| US11599541B2 (en) | 2016-09-26 | 2023-03-07 | Splunk Inc. | Determining records generated by a processing task of a query |
| US11604795B2 (en) | 2016-09-26 | 2023-03-14 | Splunk Inc. | Distributing partial results from an external data system between worker nodes |
| US11615104B2 (en) | 2016-09-26 | 2023-03-28 | Splunk Inc. | Subquery generation based on a data ingest estimate of an external data system |
| US11620336B1 (en) | 2016-09-26 | 2023-04-04 | Splunk Inc. | Managing and storing buckets to a remote shared storage system based on a collective bucket size |
| US11663227B2 (en) | 2016-09-26 | 2023-05-30 | Splunk Inc. | Generating a subquery for a distinct data intake and query system |
| US11704313B1 (en) | 2020-10-19 | 2023-07-18 | Splunk Inc. | Parallel branch operation using intermediary nodes |
| US11715051B1 (en) | 2019-04-30 | 2023-08-01 | Splunk Inc. | Service provider instance recommendations using machine-learned classifications and reconciliation |
| US11720537B2 (en) | 2018-04-30 | 2023-08-08 | Splunk Inc. | Bucket merging for a data intake and query system using size thresholds |
| US11860940B1 (en) | 2016-09-26 | 2024-01-02 | Splunk Inc. | Identifying buckets for query execution using a catalog of buckets |
| US11874691B1 (en) | 2016-09-26 | 2024-01-16 | Splunk Inc. | Managing efficient query execution including mapping of buckets to search nodes |
| US11921672B2 (en) | 2017-07-31 | 2024-03-05 | Splunk Inc. | Query execution at a remote heterogeneous data store of a data fabric service |
| US11922222B1 (en) | 2020-01-30 | 2024-03-05 | Splunk Inc. | Generating a modified component for a data intake and query system using an isolated execution environment image |
| US11989194B2 (en) | 2017-07-31 | 2024-05-21 | Splunk Inc. | Addressing memory limits for partition tracking among worker nodes |
| US12013895B2 (en) | 2016-09-26 | 2024-06-18 | Splunk Inc. | Processing data using containerized nodes in a containerized scalable environment |
| US12072939B1 (en) | 2021-07-30 | 2024-08-27 | Splunk Inc. | Federated data enrichment objects |
| US12093272B1 (en) | 2022-04-29 | 2024-09-17 | Splunk Inc. | Retrieving data identifiers from queue for search of external data system |
| US12118009B2 (en) | 2017-07-31 | 2024-10-15 | Splunk Inc. | Supporting query languages through distributed execution of query engines |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103020204A (en) * | 2012-12-05 | 2013-04-03 | 北京普泽天玑数据技术有限公司 | Method and system for carrying out multi-dimensional regional inquiry on distribution type sequence table |
| CN103810224A (en) * | 2012-11-15 | 2014-05-21 | 阿里巴巴集团控股有限公司 | Information persistence and query method and device |
| CN104573022A (en) * | 2015-01-12 | 2015-04-29 | 浪潮软件股份有限公司 | Data query method and device for HBase |
| CN104636389A (en) * | 2013-11-14 | 2015-05-20 | 博雅网络游戏开发（深圳）有限公司 | Hbase database real-time query achieving method and system |
| CN107506464A (en) * | 2017-08-30 | 2017-12-22 | 武汉烽火众智数字技术有限责任公司 | A kind of method that HBase secondary indexs are realized based on ES |
| CN107515882A (en) * | 2016-06-17 | 2017-12-26 | 阿里巴巴集团控股有限公司 | Data query method and device |
-
2018
- 2018-11-09 CN CN201811334227.4A patent/CN109299110B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103810224A (en) * | 2012-11-15 | 2014-05-21 | 阿里巴巴集团控股有限公司 | Information persistence and query method and device |
| CN103020204A (en) * | 2012-12-05 | 2013-04-03 | 北京普泽天玑数据技术有限公司 | Method and system for carrying out multi-dimensional regional inquiry on distribution type sequence table |
| CN104636389A (en) * | 2013-11-14 | 2015-05-20 | 博雅网络游戏开发（深圳）有限公司 | Hbase database real-time query achieving method and system |
| CN104573022A (en) * | 2015-01-12 | 2015-04-29 | 浪潮软件股份有限公司 | Data query method and device for HBase |
| CN107515882A (en) * | 2016-06-17 | 2017-12-26 | 阿里巴巴集团控股有限公司 | Data query method and device |
| CN107506464A (en) * | 2017-08-30 | 2017-12-22 | 武汉烽火众智数字技术有限责任公司 | A kind of method that HBase secondary indexs are realized based on ES |
Cited By (53)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US11874691B1 (en) | 2016-09-26 | 2024-01-16 | Splunk Inc. | Managing efficient query execution including mapping of buckets to search nodes |
| US11442935B2 (en) | 2016-09-26 | 2022-09-13 | Splunk Inc. | Determining a record generation estimate of a processing task |
| US11797618B2 (en) | 2016-09-26 | 2023-10-24 | Splunk Inc. | Data fabric service system deployment |
| US11593377B2 (en) | 2016-09-26 | 2023-02-28 | Splunk Inc. | Assigning processing tasks in a data intake and query system |
| US12013895B2 (en) | 2016-09-26 | 2024-06-18 | Splunk Inc. | Processing data using containerized nodes in a containerized scalable environment |
| US11599541B2 (en) | 2016-09-26 | 2023-03-07 | Splunk Inc. | Determining records generated by a processing task of a query |
| US11232100B2 (en) | 2016-09-26 | 2022-01-25 | Splunk Inc. | Resource allocation for multiple datasets |
| US11238112B2 (en) | 2016-09-26 | 2022-02-01 | Splunk Inc. | Search service system monitoring |
| US11250056B1 (en) | 2016-09-26 | 2022-02-15 | Splunk Inc. | Updating a location marker of an ingestion buffer based on storing buckets in a shared storage system |
| US11281706B2 (en) | 2016-09-26 | 2022-03-22 | Splunk Inc. | Multi-layer partition allocation for query execution |
| US11294941B1 (en) | 2016-09-26 | 2022-04-05 | Splunk Inc. | Message-based data ingestion to a data intake and query system |
| US11321321B2 (en) | 2016-09-26 | 2022-05-03 | Splunk Inc. | Record expansion and reduction based on a processing task in a data intake and query system |
| US11995079B2 (en) | 2016-09-26 | 2024-05-28 | Splunk Inc. | Generating a subquery for an external data system using a configuration file |
| US11341131B2 (en) | 2016-09-26 | 2022-05-24 | Splunk Inc. | Query scheduling based on a query-resource allocation and resource availability |
| US11663227B2 (en) | 2016-09-26 | 2023-05-30 | Splunk Inc. | Generating a subquery for a distinct data intake and query system |
| US11392654B2 (en) | 2016-09-26 | 2022-07-19 | Splunk Inc. | Data fabric service system |
| US11416528B2 (en) | 2016-09-26 | 2022-08-16 | Splunk Inc. | Query acceleration data store |
| US11620336B1 (en) | 2016-09-26 | 2023-04-04 | Splunk Inc. | Managing and storing buckets to a remote shared storage system based on a collective bucket size |
| US11461334B2 (en) | 2016-09-26 | 2022-10-04 | Splunk Inc. | Data conditioning for dataset destination |
| US11966391B2 (en) | 2016-09-26 | 2024-04-23 | Splunk Inc. | Using worker nodes to process results of a subquery |
| US11615104B2 (en) | 2016-09-26 | 2023-03-28 | Splunk Inc. | Subquery generation based on a data ingest estimate of an external data system |
| US11550847B1 (en) | 2016-09-26 | 2023-01-10 | Splunk Inc. | Hashing bucket identifiers to identify search nodes for efficient query execution |
| US11562023B1 (en) | 2016-09-26 | 2023-01-24 | Splunk Inc. | Merging buckets in a data intake and query system |
| US11567993B1 (en) | 2016-09-26 | 2023-01-31 | Splunk Inc. | Copying buckets from a remote shared storage system to memory associated with a search node for query execution |
| US11586627B2 (en) | 2016-09-26 | 2023-02-21 | Splunk Inc. | Partitioning and reducing records at ingest of a worker node |
| US11586692B2 (en) | 2016-09-26 | 2023-02-21 | Splunk Inc. | Streaming data processing |
| US11580107B2 (en) | 2016-09-26 | 2023-02-14 | Splunk Inc. | Bucket data distribution for exporting data to worker nodes |
| US11604795B2 (en) | 2016-09-26 | 2023-03-14 | Splunk Inc. | Distributing partial results from an external data system between worker nodes |
| US11860940B1 (en) | 2016-09-26 | 2024-01-02 | Splunk Inc. | Identifying buckets for query execution using a catalog of buckets |
| US11921672B2 (en) | 2017-07-31 | 2024-03-05 | Splunk Inc. | Query execution at a remote heterogeneous data store of a data fabric service |
| US11989194B2 (en) | 2017-07-31 | 2024-05-21 | Splunk Inc. | Addressing memory limits for partition tracking among worker nodes |
| US12118009B2 (en) | 2017-07-31 | 2024-10-15 | Splunk Inc. | Supporting query languages through distributed execution of query engines |
| US11500875B2 (en) | 2017-09-25 | 2022-11-15 | Splunk Inc. | Multi-partitioning for combination operations |
| US11860874B2 (en) | 2017-09-25 | 2024-01-02 | Splunk Inc. | Multi-partitioning data for combination operations |
| US11720537B2 (en) | 2018-04-30 | 2023-08-08 | Splunk Inc. | Bucket merging for a data intake and query system using size thresholds |
| CN109918472A (en) * | 2019-02-27 | 2019-06-21 | 北京百度网讯科技有限公司 | Method, apparatus, equipment and the medium of storage and inquiry data |
| US11334544B2 (en) | 2019-02-27 | 2022-05-17 | Beijing Baidu Netcom Science And Technology Co., Ltd. | Method, apparatus, device and medium for storing and querying data |
| KR20200104789A (en) * | 2019-02-27 | 2020-09-04 | 베이징 바이두 넷컴 사이언스 앤 테크놀로지 코., 엘티디. | Method, apparatus, device and medium for storing and querying data |
| KR102407510B1 (en) * | 2019-02-27 | 2022-06-10 | 베이징 바이두 넷컴 사이언스 앤 테크놀로지 코., 엘티디. | Method, apparatus, device and medium for storing and querying data |
| WO2020220216A1 (en) * | 2019-04-29 | 2020-11-05 | Splunk Inc. | Search time estimate in data intake and query system |
| US11615087B2 (en) | 2019-04-29 | 2023-03-28 | Splunk Inc. | Search time estimate in a data intake and query system |
| US11715051B1 (en) | 2019-04-30 | 2023-08-01 | Splunk Inc. | Service provider instance recommendations using machine-learned classifications and reconciliation |
| US11494380B2 (en) | 2019-10-18 | 2022-11-08 | Splunk Inc. | Management of distributed computing framework components in a data fabric service system |
| US12007996B2 (en) | 2019-10-18 | 2024-06-11 | Splunk Inc. | Management of distributed computing framework components |
| US11922222B1 (en) | 2020-01-30 | 2024-03-05 | Splunk Inc. | Generating a modified component for a data intake and query system using an isolated execution environment image |
| CN111897840A (en) * | 2020-08-14 | 2020-11-06 | 北京字节跳动网络技术有限公司 | Data searching method and device, electronic equipment and storage medium |
| US11704313B1 (en) | 2020-10-19 | 2023-07-18 | Splunk Inc. | Parallel branch operation using intermediary nodes |
| CN113297273B (en) * | 2021-06-09 | 2024-03-01 | 北京百度网讯科技有限公司 | Method and device for inquiring metadata and electronic equipment |
| CN113297273A (en) * | 2021-06-09 | 2021-08-24 | 北京百度网讯科技有限公司 | Method and device for querying metadata and electronic equipment |
| CN113688150A (en) * | 2021-07-27 | 2021-11-23 | 珠海金山办公软件有限公司 | Keyword searching method and device, electronic equipment and storage medium |
| CN113688150B (en) * | 2021-07-27 | 2024-08-13 | 珠海金山办公软件有限公司 | Keyword searching method and device, electronic equipment and storage medium |
| US12072939B1 (en) | 2021-07-30 | 2024-08-27 | Splunk Inc. | Federated data enrichment objects |
| US12093272B1 (en) | 2022-04-29 | 2024-09-17 | Splunk Inc. | Retrieving data identifiers from queue for search of external data system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109299110B (en) | 2020-09-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109299110A (en) | Data query method, apparatus, storage medium and electronic equipment | |
| CN103377652B (en) | A kind of method, device and equipment for carrying out speech recognition | |
| CN108255958A (en) | Data query method, apparatus and storage medium | |
| CN109669741B (en) | Language switching method, server and storage medium for terminal application dynamic document | |
| CN109558525B (en) | Test data set generation method, device, equipment and storage medium | |
| CA2802458C (en) | Synchronizing endpoint data stores having disparate schemas | |
| CN107562743B (en) | Data storage method and device, and data search request processing method and device | |
| CN111221840A (en) | Data processing method and device, data caching method, storage medium and system | |
| CN112416962A (en) | Data query method, device and storage medium | |
| CN108520019A (en) | Data managing method, device, equipment and computer readable storage medium | |
| CN113553339B (en) | Data query method, middleware, electronic device and storage medium | |
| CN110019444B (en) | Operation request processing method, device, equipment and system | |
| CN113868252A (en) | Database mode matching method and device and SQL query statement generation method | |
| CN112102840A (en) | Semantic recognition method, device, terminal and storage medium | |
| CN113505143B (en) | Sentence type conversion method and device, storage medium and electronic device | |
| CN111625638A (en) | Question processing method, device and equipment and readable storage medium | |
| CN103079194B (en) | Service adaptation method, apparatus and system | |
| CN112667632B (en) | Metadata processing method and device | |
| CN110737662B (en) | Data analysis method, device, server and computer storage medium | |
| CN111767451A (en) | Searching method, electronic equipment and computer readable storage medium | |
| CN117009430A (en) | Data management method, device, storage medium and electronic equipment | |
| CN109361399A (en) | A kind of method, apparatus, equipment and storage medium obtaining byte sequence | |
| CN114884824A (en) | Method, device and system for querying delay budget path | |
| US11914658B2 (en) | Multi-node word segmentation system and method for keyword search | |
| CN110471708B (en) | Method and device for acquiring configuration items based on reusable components |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |