CN109783543A - Data query method, apparatus, equipment and storage medium - Google Patents
Data query method, apparatus, equipment and storage medium Download PDFInfo
- Publication number
- CN109783543A CN109783543A CN201910031419.6A CN201910031419A CN109783543A CN 109783543 A CN109783543 A CN 109783543A CN 201910031419 A CN201910031419 A CN 201910031419A CN 109783543 A CN109783543 A CN 109783543A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- information
- tables
- name
- 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
- 238000000034 method Methods 0.000 title claims abstract description 47
- 230000015654 memory Effects 0.000 claims description 19
- 238000012360 testing method Methods 0.000 claims description 7
- 238000004590 computer program Methods 0.000 claims description 4
- 239000011159 matrix material Substances 0.000 claims description 2
- VYPSYNLAJGMNEJ-UHFFFAOYSA-N Silicium dioxide Chemical compound O=[Si]=O VYPSYNLAJGMNEJ-UHFFFAOYSA-N 0.000 claims 1
- 238000011160 research Methods 0.000 description 35
- 238000013507 mapping Methods 0.000 description 18
- 230000008030 elimination Effects 0.000 description 15
- 238000003379 elimination reaction Methods 0.000 description 15
- 238000010586 diagram Methods 0.000 description 8
- 230000006870 function Effects 0.000 description 7
- 238000012545 processing Methods 0.000 description 3
- 230000015572 biosynthetic process Effects 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 235000013399 edible fruits Nutrition 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000012634 fragment Substances 0.000 description 1
- 238000011835 investigation Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000013102 re-test Methods 0.000 description 1
- 238000012552 review Methods 0.000 description 1
- 238000009958 sewing Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000013024 troubleshooting Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a kind of data query method, apparatus, equipment and storage mediums.This method comprises: obtaining data query information and at least one data source information, the data query information includes: field name, and field value corresponding with the field name；Store in the server at least one matched database of the data source information, data query is carried out to the data query information, is obtained and at least one data record of the data query information matches；According to the data record, the feedback result of the data query information is generated.When carrying out data query by the above method, user can be reduced to the operational risk of database, and be able to solve only according to field name and the time-consuming excessive problem of corresponding field value trace data record.
Description
Technical field
The present embodiments relate to database processing technology more particularly to a kind of data query method, apparatus, equipment and deposit
Storage media.
Background technique
Database, which is one, to be carried out tissue according to data structure and stores the warehouse of mass data, wherein what data structure referred to
It is the connection between the organizational form or data of data.User can look into the data execution in database according to specific requirements
Inquiry, newly-increased, interception, update, deletion etc. operate.
When needing to inquire certain data in database, but only one or two field name relevant to these data and correspondence
When field value, user can go to search corresponding data record, the time-consuming data with database of inquiry according to relevant inquiring code
Amount of storage is proportional, can also go directly to search with the data storage information in memory.But above two inquiry mode is all
User is needed to execute relevant operation on the server, it is possible to lead to asking for server operational efficiency reduction even performance obstruction
Topic, once user's operation is made mistakes, it is also possible to and some database accidents occur, e.g. accidentally delete data or accidentally modification data etc..
Summary of the invention
The embodiment of the present invention provides a kind of data query method, apparatus, equipment and storage medium, to reduce user's operation wind
Danger, while solving the problems, such as time-consuming excessive according to field name and corresponding field value trace data record.
In a first aspect, the embodiment of the invention provides a kind of data query methods, comprising:
Data query information and at least one data source information are obtained, the data query information includes: field name, with
And field value corresponding with the field name；
Store in the server at least one matched database of the data source information, to the data query
Information carries out data query, obtains at least one data record with the data query information matches；
According to the data record, the feedback result of the data query information is generated.
Second aspect, the embodiment of the invention also provides a kind of data query device, which includes:
Module is obtained, for obtaining data query information and at least one data source information, the data query information
It include: field name, and field value corresponding with the field name；
Enquiry module, for store in the server at least one matched database of the data source information,
Data query is carried out to the data query information, obtains at least one data record with the data query information matches；
Feedback module, for generating the feedback result of the data query information according to the data record.
The third aspect, the embodiment of the invention also provides a kind of computer equipment, the computer equipment includes:
One or more processors；
Memory, for storing one or more programs,
When one or more of programs are executed by one or more of processors, so that one or more of processing
Device realizes data query method described in any embodiment.
Fourth aspect, the embodiment of the invention also provides a kind of computer readable storage mediums, are stored thereon with computer
Program realizes data query method described in any embodiment when the program is executed by processor.
In the embodiment of the present invention, it is limited to according to the database that the data source information of acquisition will access and data source information
Matched database, rather than all databases stored on server carry out data to data query information to reduce
The database range of inquiry, thus shortens query time；By being stored in the server according to data source information remote access
With at least one matched database of data source information, to data query information carry out data query technological means, to
Family only opens search access right, so that user need not directly operate on the server, and then even not to the operational efficiency of server
Performance has an impact, while also avoiding may cause and database accident occurring since user inputs code by mistake on the server
Problem.When the data query method provided through the embodiment of the present invention as a result, carries out data query, user can be reduced to data
The operational risk in library, and be able to solve only according to field name and the time-consuming excessive problem of corresponding field value trace data record.
Detailed description of the invention
Fig. 1 is a kind of flow chart for data query method that the embodiment of the present invention one provides；
Fig. 2A is a kind of flow chart of data query method provided by Embodiment 2 of the present invention；
Fig. 2 B is the structural schematic diagram that table is divided in a kind of data point library provided by Embodiment 2 of the present invention；
Fig. 2 C is the structural schematic diagram that table is divided in a kind of data point library provided by Embodiment 2 of the present invention；
Fig. 3 A is a kind of flow chart for data query method that the embodiment of the present invention three provides；
Fig. 3 B is a kind of application interface schematic diagram that a kind of data query method that the embodiment of the present invention three provides is applicable in；
Fig. 3 C is a kind of application interface schematic diagram that a kind of data query method that the embodiment of the present invention three provides is applicable in；
Fig. 4 is a kind of modular structure schematic diagram for data query device that the embodiment of the present invention four provides；
Fig. 5 is a kind of structural schematic diagram for computer equipment that the embodiment of the present invention five provides.
Specific embodiment
The present invention is described in further detail with reference to the accompanying drawings and examples.It is understood that this place is retouched
The specific embodiment stated is used only for explaining the present invention rather than limiting the invention.It also should be noted that in order to just
Only the parts related to the present invention are shown in description, attached drawing rather than entire infrastructure.
Embodiment one
Fig. 1 is a kind of flow chart for data query method that the embodiment of the present invention one provides, and the present embodiment is applicable to only
Data base querying is carried out for one or two of field name and corresponding field value, to obtain and the field name and corresponding field value
The case where matched data record, this method can be executed by the data query device that any embodiment of that present invention provides, should
Device can be made of hardware and/or software, and can be generally integrated in the processor of computer equipment.
During software development and/or operation, inevitably encounter various problems, thus need to problem phase
The data of pass are positioned, and carry out problem investigation after obtaining related data record, and may be there is only in the trace log of software
One or two of field name and field value corresponding with its, at this point, can only according to this one or two of field name and with its point
Not corresponding field value goes query-relevant data in database to record.Field by taking order payment problem as an example, in trace log
Name can be order number, and field value corresponds to xxxx (order number detail)；Word by taking account login problem as an example, in trace log
Section name can be login account, and field value corresponds to xxxx (login account detail).
As described in Figure 1, data query method provided in this embodiment the following steps are included:
S110, acquisition data query information and at least one data source information, data query information include field name, with
And field value corresponding with field name.
Data query information refers specifically to the field name that research staff obtains in log, and corresponding with field name
Field value namely field name to be checked and corresponding field value, e.g. field name -- order number, field corresponding with order number
Value-xxxx, then such as field name -- login account, field value corresponding with login account -- xxxx.
Data source information refers to the information of connected reference Relational database, namely can be connected according to a data source information
Receiving ask to this matched database of data source information.Wherein, a data source information can specifically include dataSource link,
Uniform resource locator url, database side slogan, database name, login user name, login password, region etc..
In order to shorten query time, the data source information of acquisition refers specifically to the associated each with field name of user's selection
The data source information of a data source, and the data source information of not all data source.
As a kind of optional embodiment of the present embodiment, before obtaining data query information and data source information,
Further include:
Obtain user input with associated at least one data source information of field name；
At least one data source information is tested according to the test request of user.
Firstly, which database research staff determines in exist and the field name according to from the field name obtained in log
The data record matched, so will data source corresponding with these databases respectively as data source to be checked.If data source arranges
There are data source to be checked in table, research staff directly chooses in data source list；If do not deposited in data source list
In data source to be checked, research staff then need first the data source information of data source to be checked carry out typing namely typing with
Each data source to be checked corresponding essential information (dataSource link, uniform resource locator url, port numbers, database
Name, login user name, login password, region etc.).Wherein, multiple databases be may include under same data source.
In order to guarantee research staff's typing data source information accuracy, data source information can be tested.When
After research staff initiates test request for a data source information, system can go access connection corresponding according to data source information
Database prompts to be successfully tested if access successful connection, if access connection failure, prompts test crash, and return
Failure cause, e.g. login password mistake etc..
After data source information is successfully tested, which is added to data source list, so that research staff will
It is selected as data source to be checked.It is worth noting that each data source in data source list can be deleted, modify at any time,
Inquiry, and retest.
After research staff has selected data source to be checked in data source list, input data query information namely defeated
Enter field name to be checked and field value corresponding with field name to be checked.It wherein, can be in research staff's input field name
Field name, which is provided, for research staff obscures prompting function, to guarantee the correctness of the field name of research staff's input, as long as because
There are a character errors in the field name of research staff's input, can all data query be caused to fail.Moreover, different research staff
There may be respectively different field name English to name habit, therefore different research staff name also not for the English of same field
Identical to the greatest extent, field name obscures prompting function at this time can also prompt correct field name in data source to be checked for research staff.
Typically, before obtaining the field name in data query information, further includes:
Obtain at least one character that user is directed to field name input；
According to the field name and user's needle in all tables of data at least one matched database of data source information
To at least one character of field name input, the fuzzy prompting of field name is generated, with for reference or selection.
A character is inputted whenever research staff is directed to field name, it all can be based on each character deblurring in present field name
All field names in data source to be checked in all tables of data are matched, and the result of fuzzy matching is obscured as field name and is mentioned
It wakes up and is prompted to research staff, for its reference or selection.When research staff has found that there are it to want input in the fuzzy prompting of field name
Field name, can directly select, it is not necessary to oneself go to input again.For example, research staff is for the character of field name input
" time ", it may include such as field names such as " testtime ", " logintime " that field name, which obscures in prompting,.
As another optional embodiment of the present embodiment, data query information and at least one number can be will acquire
According to source information, specifically:
Data query information is obtained, data query information includes field name, and field value corresponding with the field name；
According to the field name in data query information, traverse all data list structures stored in the server, determine with
At least one matched database of field name；
At least one data source information is generated according to the related information of at least one database.
Firstly, field name and corresponding field value that research staff's input is obtained from log.Secondly, system access service
Which tables of data knot device determines according to all data list structures stored in the field name traversal server of research staff's input
In structure include this field name, and then can include according to these this field name data list structure determination matched with field name
Database, that is, determine these databases in will include research staff input field name.Again, system obtain and this
The corresponding related information of a little databases, for example, database name, dataSource link corresponding with database, uniform resource locator
Url, port numbers, login username, login password, region etc., and then one is generated according to the related information of each database
Data source information, so that can be according to data source information success when carrying out data positioning according to field name and corresponding field value
Access these databases.S120, store in the server at least one matched database of data source information, to data
Query information carries out data query, obtains at least one data record with data query information matches.
Matched each database is accessed according to every data source information, then for the word in data query information
Section name and corresponding field value, traverse all tables of data in the data source, to carry out data query to data query information, if
Comprising the field name and corresponding field value in data query information in certain data record in certain tables of data, then by the data
Record is as the data record with data query information matches.
After the completion of all tables of data traversal in all data sources to be checked for selecting research staff, get and number
It is investigated that asking the data record of information matches, the data positioning to field name and corresponding field value can be realized.
S130, according to data record, generate the feedback result of data query information.
According to the pieces of data record with data query information matches got, generate corresponding with data query information
Location information, and research staff is returned to using location information as feedback result, so that research staff can be according to location information
Get other data relevant to data query information.
Optionally, the information of tables of data is as positioning corresponding with data query information where pieces of data being recorded
Information, the information of tables of data where specifically can storing pieces of data record by a query result Mapping data structure, and
Using query result Mapping data structure as feedback result, so research staff according to query result mapping structure you can learn that with
The corresponding location information of data query information, and then other data relevant to data query information are obtained according to location information.
Typically, the form of query result Mapping data structure can be < data table name+database name, data source information
>, wherein the table name of tables of data where the entitled data record of tables of data, database name are the database where the tables of data
Library name, data source information is the essential information of data source corresponding with the database, for example including dataSource link, region
And url etc..
As a kind of optional embodiment of the present embodiment, it can will generate data according at least one data record and look into
The feedback result of information is ask, specifically:
The related information of tables of data is remembered as data corresponding with data query information where every data is recorded
Item is recorded, each data record item constitutes feedback result；
One-to-one field name character string and field value character string are generated according to every data record, wherein field name
Spcial character interval is used in character string between variant field name, is adopted between corresponding different field value in field value character string
With spcial character interval；
In each data record item add hyperlink record number so that user according to hyperlink record number check with
The field name of every data record matching and the one-to-one data form of field value, wherein data form is by by field name
Character string and field value character string are cut according to spcial character respectively and are generated.
Wherein, the related information of tables of data specifically can be tables of data where every data record where every data record
Table name, the library name of the database where the tables of data, the essential information of data source corresponding with the database, such as wrap
Include dataSource link, region and url etc..
These related informations are integrated into a data record strip corresponding with data query information, and then each data are remembered
It records item combination and constitutes feedback result (an e.g. data record sheet), be supplied to research staff.
Further, hyperlink record number is added in each data record item, the quantity of hyperlink record number is
For the quantity of the data record with data query information matches.It, can will be with when research staff's clickable hyperlinks record number
The detailed data that the hyperlink numbers corresponding data record is supplied to research staff.
It is a pair of in one obtained in tables of data where data record for recording corresponding detailed data with every data
The multiple groups field name and corresponding field value answered, specifically, this multiple groups field name and corresponding field value are configured to correspondingly
Field name character string and field value character string use spcial character interval, word in field name character string between variant field name
Spcial character interval is used in segment value character string between corresponding different field value, equally with two group field names and corresponding field value
For, " name -- Zhang San ", " age -- 20 ", additional character is " # ", then field name character string be " name # age " and
Field value character string is " Zhang San #20 ".When research staff's clickable hyperlinks record number, this one-to-one field name is shown
When character string and field value character string, field name character string and field value character string are cut respectively according to additional character " # "
It cuts, generates field name and the one-to-one data form of field value, and then by this field name and the one-to-one data of field value
Table is shown to research staff, so far realizes and carries out data positioning according to field name and corresponding field value, and will obtain after positioning
The related detailed data taken is shown.
In the above-mentioned technical solutions, one-to-one field name character string and field value character string are constructed first, when display
Field name character string and field value character string are cut according to spcial character respectively, field name is generated and field value one is a pair of
The data form answered, thus progress detailed data shows and is advantageous in that, although by detailed data corresponding with data record
It is shown with the form of table, but without mapping the entity class in the tables of data correspondence database, it only will be with detailed number
It is directly displayed according to corresponding field name and corresponding field value.
In the embodiment of the present invention, it is limited to according to the database that the data source information of acquisition will access and data source information
Matched database, rather than all databases stored on server carry out data to data query information to reduce
The database range of inquiry, thus shortens query time；By being stored in the server according to data source information remote access
With at least one matched database of data source information, to data query information carry out data query technological means, to
Family only opens search access right, so that user need not directly operate on the server, and then even not to the operational efficiency of server
Performance has an impact, while also avoiding may cause and database accident occurring since user inputs code by mistake on the server
Problem.When the data query method provided through the embodiment of the present invention as a result, carries out data query, user can be reduced to data
The operational risk in library, and be able to solve only according to field name and the time-consuming excessive problem of corresponding field value trace data record.
Embodiment two
The present embodiment is embodied based on above-described embodiment, wherein is existed in specific consideration data source and is divided library point
The case where table, will store in the server at least one matched database of the data source information, to the data
Query information carries out data query, specifically:
Successively acquisition and the matched database of the data source information, and at least one number for including in the database of acquisition
According in table, data query is carried out to data query information；It is counted each other if currently obtaining database and having inquired database with one
According to library is divided, then basis has inquired database to the hit situation of field name, determining inquiry plan corresponding with current acquisition database
Slightly carry out data query；And/or if current queries tables of data has inquired tables of data data divides table, basis each other with one
Tables of data has been inquired to the hit situation of field name, has determined that query strategy corresponding with current queries tables of data carries out data and looks into
It askes.
It is following to be explained with data source to be checked for a data source, it is as shown in Figure 2 A, provided in this embodiment
Data query method the following steps are included:
S210, acquisition data query information and at least one data source information, data query information include field name, with
And field value corresponding with field name.
S220, it successively obtains and the matched database of data source information, and at least one for including in the database of acquisition
In tables of data, data query is carried out to data query information；If currently obtaining database and one having been inquired database each other
Data divide library, then basis has inquired database to the hit situation of field name, determining inquiry corresponding with current acquisition database
Strategy carries out data query；And/or if current queries tables of data has inquired tables of data data divides table, root each other with one
According to tables of data has been inquired to the hit situation of field name, determine that query strategy corresponding with current queries tables of data carries out data and looks into
It askes.
With the development of time and business, the growth of data volume in database be it is uncontrollable, in database and tables of data
Data can be increasing, bring is the bottleneck in higher disk, input and output, overhead or even performance therewith, and
The resource of one service is limited eventually, it is therefore desirable to be split to database and tables of data, be divided library, data point with data
The form of table provides data service.
As its name suggests, data point library, data divide table to be exactly according to certain rules, to tear open to original database and table
Point, on the data block storage to multiple databases for being stored in a database originally, being stored in a tables of data originally
Data block storage to multiple tables of data on, this multiple database is multiple data point libraries, and multiple tables of data are data
Divide table.
For example, as shown in Figure 2 B, a data source can correspond to multiple databases, such as database A shown in Fig. 2 B,
Database B_C, database B_D, wherein data divide library each other by database B_C and database B_D, that is, database B_C sum number
It carries out splitting formation for certain legacy data library according to library B_D.If database B_C is to have inquired database, can root
Determine that query strategy corresponding with database B_D carries out data query, Ye Jigen according to hit situation of the database B_C to field name
It determines the need for carrying out data query to database B_D according to hit situation of the database B_C to field name.
One database includes multiple tables of data, such as tables of data a shown in Fig. 2 B, tables of data b_c, tables of data b_d,
Wherein, data divide table each other by tables of data b_c and tables of data b_d, that is, tables of data b_c and tables of data b_d are for certain tables of data
It carries out splitting formation.It, can hit according to tables of data b_c to field name if tables of data b_c is to have inquired tables of data
Situation determines that query strategy corresponding with tables of data b_d carries out data query, namely the hit according to tables of data b_c to field name
Situation determines the need for carrying out data query to tables of data b_d.
It is worth noting that the database in data point library can have multiple each other, data divide the tables of data of table can also each other
Multiple to have, with two databases, data divide library each other respectively in Fig. 2 B, and two tables of data are shown for data divide table each other
Out.
Specifically, in data source, identical at least two database of database name after removing suffix name data each other
Divide library；In the same database in data source, identical at least two tables of data of tables of data name after removing suffix name is mutual
Divide table for data.
Wherein, the removing rule of suffix name is determined according to database items purpose fragment rule.For example, as shown in Figure 2 C, with
It is carried out for a point library divides table by days, data source correspondence database nimo_server, database nimo_user_2018 and data
In library nimo_user_2019, database nimo_user_2018 include tables of data jd_pay, tables of data tb_pay_201801 and
Tables of data tb_pay_201802, wherein database nimo_user_2018 and database nimo_user_2019 removes suffix name
Database name afterwards is nimo_user, then the two databases (are split according to the time and formed in data point library each other
Data divide library), it is equal that tables of data tb_pay_201801 and tables of data tb_pay_201802 remove the data table name after suffix name
For tb_pay, then data divide table to the two tables of data each other (data for being split and being formed according to month divide table).
Further, it according to database has been inquired to the hit situation of field name, determines and the current acquisition database
Corresponding query strategy carries out data query, specifically includes:
The field name whether having at least one target matrix hiting data query information has been inquired in database in judgement；
It is looked into if so, only carrying out data in tables of data identical with target data table name in currently acquisition database
It askes；Otherwise, data query no longer is carried out to the current database that obtains.
If in data source include database nimo_user_2018 and database nimo_user_2019 the two each other
Data divide the database in library, complete to inquire to tables of data all in database nimo_user_2018 when being directed to data query information
Later, then according to tables of data all in database nimo_user_2018 to the hit situation of field name in data query information,
It determines the data query strategy for dividing the database nimo_user_2019 in library with data each other, data is carried out to data query information
Inquiry.
Judgement inquired in database nimo_user_2018 whether at least one tables of data hiting data query information
In field name, if it is not, then meaning and, also without this field name, and then being inquired in its each other database in data point library
When data divide the database nimo_user_2019 in library each other with database nimo_user_2018 into data source, needle is no longer needed to
Field name is inquired in database nimo_user_2019, the inquiry being not necessarily to is eliminated as a result, reduces inquiry
Number improves search efficiency.If so, determining that these can be with the table name of the tables of data of hit field name, e.g. Table A, table B
It can then inquired into data source and database nimo_user_2018 with the field name in hiting data query information with table C
When data divide the database nimo_user_2019 in library each other, for field name in database nimo_user_2019 with these
It is inquired in the identical tables of data of data table name (namely Table A, table B and table C) of hit field name.That is, when number
There was only in Table A, table B and table C these three tables that there are the field names in data query information according to library nimo_user_2018, then
Also it is only the field name that can exist in data query information in these three tables in database nimo_user_2019, and then is not necessarily to
Inquired in other tables of data for the field name in database nimo_user_2019, eliminate as a result, It is not necessary to
Inquiry, reduces inquiry times, improves search efficiency.
Further, according to tables of data has been inquired to the hit situation of field name, determination is corresponding with current queries tables of data
Query strategy carry out data query, specifically include:
Judgement is described to have inquired whether tables of data hits field name in the data query information；
If so, carrying out data query to the current queries tables of data；Otherwise, no longer to the current queries tables of data
Carry out data query.
If including tables of data tb_pay_201801 and tables of data tb_pay_201802, the two are counted each other in database
According to the tables of data for dividing table, after completing to inquire to tables of data tb_pay_201801 for data query information, then basis has been looked into
Tables of data tb_pay_201801 is ask to the hit situation of field name in data query information, determines that data divide table each other with it
The data query strategy of tables of data tb_pay_201802 carries out data query to data query information.
Judgement inquired tables of data tb_pay_201801 whether the field name in hiting data query information, if it is not, then anticipating
Taste data divide in the tables of data tb_pay_201802 of table also that there is no this field names each other with it, and then inquiry to
When tables of data tb_pay_201802, no longer needs to be inquired in tables of data tb_pay_201802 for field name, go as a result,
In addition to the inquiry being not necessarily to, reduce inquiry times, improves search efficiency.If so, meaning that data are divided each other with it
In the tables of data tb_pay_201802 of table be not present this field name, and then inquiry to tables of data tb_pay_201802
When, it still needs to be inquired in tables of data tb_pay_201802 for field name.
S230, acquisition and data query information matches at least one data record.
By in tables of data with field name in data query information and the consistent data record of corresponding field value, as with number
It is investigated that asking the data record of information matches.
S240, according to data record, generate the feedback result of the data query information.
The present embodiment, which does not explain in detail to the greatest extent, illustrates place, please be detailed in previous embodiment, details are not described herein.
In embodiments of the present invention, each tables of data in target data point library inquired by basis is to data query
The hit situation of field name in information, determining each associated data with target data point storehouse matching divide the data query plan in library
Slightly, by dividing table to the hit situation of field name in data query information, determining and number of targets according to the target data inquired
According to the data query strategy for dividing the matched each associated data of table to divide table, is realized with this and divide table to each data point library and data
Duplicate removal data query, reduce inquiry times to the maximum extent, remove It is not necessary to inquiry, greatly improve data query
Efficiency, data volume is larger, the project of dividing table point library more summarize it is particularly evident.Based on the technical solution of above-mentioned duplication elimination query,
It realizes in numerous data sources and exists in the project that table is divided in point library, to the field name and corresponding field value in data query information
Quick positioning, and then make research staff according to location information quick obtaining other data relevant to data query information.
Embodiment three
Fig. 3 A is a kind of flow chart for data query method that the embodiment of the present invention three provides.The present embodiment is with above-mentioned implementation
Based on example, a kind of specific embodiment is provided, is still that a data source is explained with data source to be checked, such as
Shown in Fig. 3 A, data query method provided in this embodiment the following steps are included:
S310, acquisition data query information and at least one data source information, data query information include field name, with
And field value corresponding with field name.
S320, it is connected and at least one matched database of data source information according to data source information access.
S330, source library Mapping data structure is constructed according to dataSource link, the form of source library Mapping data structure is < data source
Name, database name list >, the initial value of database name list is sky.
The meaning of building source library Mapping data structure is what the database name list stored according to it judgement will be inquired
Whether database is that database data point library each other has been inquired with some.After being removing due to what is stored in database name list
Database name after sewing name, so if including the number after the removing suffix name of database that will be inquired in database name list
According to library name, this database that will be inquired has inquired database data point library each other with some.
S340, corresponding with a data source database is successively obtained according to database traversal order as currently obtaining
Take database.
The current database that obtains refers to the database that will be inquired, e.g. database nimo_user_2019.
S350, judge to obtain removing for database with the presence or absence of current in database name list in the Mapping data structure of source library
Database name after going suffix name, if it is not, S360 is then executed, if so, executing S3150.
S360, the database name after the current removing suffix name for obtaining database is added in database name list.
If after in database name list not including the current removing suffix name for obtaining database nimo_user_2019
Database name nimo_user, then currently obtaining database nimo_user_2019 is not that have inquired database with some corresponding
Data divide library, namely need to carry out data query to the current database nimo_user_2019 that obtains.
It is worth noting that if currently obtaining wide area information server name does not have suffix (namely not being a point library),
Directly addition is current in database name list obtains wide area information server name.
Database name after the current removing suffix name for obtaining database of S370, basis constructs and currently obtains database
Removing suffix name after the matched object library table Mapping data structure of database name, the form of library table Mapping data structure is <
Database name, data list of table names >, the initial value of data list of table names is sky.
The meaning of building library table Mapping data structure is what the data list of table names stored according to it judgement will be inquired
Whether tables of data with some has inquired tables of data, and data divide table each other.Since what is stored in data list of table names is to remove suffix
Data table name after name, so if including the data after the removing suffix name of tables of data that will be inquired in data list of table names
Table name, this tables of data that will be inquired has inquired tables of data with some, and data divide table each other.
According to the database name nimo_user building after the current removing suffix name for obtaining database nimo_user_2019
With the matched library table Mapping data structure<nimo_user of nimo_user, it is empty>.
S380, a tables of data corresponding with current acquisition database is successively obtained according to tables of data traversal order and is used as and is worked as
Preceding inquiry tables of data.
Current queries tables of data refers to the tables of data that will be inquired, e.g. tables of data tb_pay_201802.
S390, judge in data list of table names in object library table Mapping data structure with the presence or absence of current queries tables of data
Removing suffix name after data table name, if it is not, then execute S3100, if so, executing S3130.
S3100, the data table name in data list of table names after the removing suffix name of addition current queries tables of data.
If do not include in data list of table names current queries tables of data tb_pay_201802 removing suffix name after number
According to table name tb_pay, then current queries tables of data tb_pay_201802 has not inquired tables of data with some data divides table each other,
It needs to carry out data query to current queries tables of data tb_pay_201802.
S3110, according to field name inquire current queries tables of data, and using query result as with current queries tables of data
The corresponding duplication elimination query reference of data table name after removing suffix name.
Whether query result refers specifically in current queries tables of data to include the field name, and then by current queries data
It whether include that the field name is referred to as duplication elimination query corresponding with tb_pay in table.If including corresponding with tb_pay
Duplication elimination query reference is need to be to data divide the tables of data of table to inquire each other with it, if not including, with tb_pay pairs
The duplication elimination query answered is with reference to as without to data divide the tables of data of table to inquire each other with it.
If include in S3120, current queries tables of data with field name and the matched data record of corresponding field value,
It obtains the data record and saves, execute S3140.
If include in current queries tables of data with field name and the matched data record of corresponding field value, can be achieved
Data positioning to field name and corresponding field value.
S3130, it is referred to according to duplication elimination query corresponding with the data table name after the removing suffix name of current queries tables of data
Inquiry operation is executed or not executed to current queries tables of data.
If the data after removing suffix name in data list of table names including current queries tables of data tb_pay_201802
Table name tb_pay is then determined according to duplication elimination query corresponding with tb_pay reference to current queries tables of data tb_pay_201802
Whether inquiry operation is executed, if so, inquire current queries tables of data tb_pay_201802, if it is not, then to currently looking into
Tables of data tb_pay_201802 is ask without inquiry.
S3140, return, which are executed, successively obtains a number corresponding with current acquisition database according to tables of data traversal order
According to table as current queries tables of data, until traversal completes all tables of data corresponding with current acquisition database, and will with work as
It is preceding to obtain in corresponding at least one tables of data of database whether the judging result comprising field name as with current obtains data
The corresponding duplication elimination query reference of database name after the removing suffix name in library, executes S3160.
If currently obtaining and all not including field name in database nimo_user_2019 in all tables of data, with
The corresponding duplication elimination query of nimo_user is with reference to as without to the database in data point library carries out repeating inquiry each other with it；Such as
It includes field name at least one tables of data in database nimo_user_2019 that fruit, which currently obtains, then corresponding with nimo_user
Duplication elimination query with reference to being to need to inquire the database with its data point library each other.
S3150, it is referred to according to duplication elimination query corresponding with the database name after the current removing suffix name for obtaining database
Inquiry operation is executed or is not executed to the current database that obtains, if executing, basis and the current removing suffix for obtaining database
Name after the matched object library table Mapping data structure of database name, and with the data after the removing suffix name of each tables of data
The matched tables of data of the corresponding duplication elimination query reference pair of table name executes or does not execute inquiry operation.
If in database name list including the number after the current removing suffix name for obtaining database nimo_user_2019
According to library name nimo_user, then database nimo_ is obtained to current with reference to determining according to duplication elimination query corresponding with nimo_user
Whether user_2019 executes inquiry operation, if it is not, then to the current database nimo_user_2019 that obtains without inquiry, if
Be then the current database nimo_user_2019 that obtains is inquired, meanwhile, mapped according to the matched library table of nimo_user
It is corresponding with the data table name after the removing suffix name of each tables of data in data structure and the library table Mapping data structure to go
It reviews inquiry and refers to (such as duplication elimination query reference corresponding with tb_pay), determine and obtain database nimo_user_2019 to current
In each tables of data whether carry out inquiry operation.
S3160, return successively obtain a database conduct corresponding with the data source according to database traversal order
The current operation for obtaining database, until traversal completes all databases corresponding with data source.
The present embodiment, which does not explain in detail to the greatest extent, illustrates place, please be detailed in previous embodiment, details are not described herein.
Typically, data query method provided in an embodiment of the present invention can be packaged as to a data positioning tool, ground
Input needs to carry out the field name of data positioning to hair personnel at field name value input area 31 in interface as shown in Figure 3B
Then busOrderId and field value 201812071549051971465043662512 click positioning, obtain as shown in Figure 3B
Interface in feedback result (field name busOrderId and field value in locating and displaying area 32
The related information of 201812071549051971465043662512 place tables of data), if research staff wants to see detailed data,
The record number clicked in locating and displaying area 32 numbers (hyperlink record number) 321, can pop up bullet frame as shown in Figure 3 C, into
And research staff can be checked and field name busOrderId and field value by bullet frame as shown in Figure 3 C
201812071549051971465043662512 matched data details.Wherein, data source is detailed in interface as shown in Figure 3B
Feelings list is Yu Xianxuanding and tested successful, or according to all table structures in field name busOrderId traversal server
It automatically generates afterwards.
In embodiments of the present invention, it is realized by source library Mapping data structure and the database in data point library each other is gone
Inquiry is reviewed, realizes the duplication elimination query that data each other are divided with the tables of data of table, by library table Mapping data structure with this maximum limit
The reduction data query number of degree removes the inquiry being not necessarily to, greatly improves search efficiency, solve according to field name
And the time-consuming excessive problem of corresponding field value trace data record, so that research staff is in testing process and troubleshooting link
Can rapidly locating, improve development efficiency.
Example IV
Fig. 4 is a kind of modular structure schematic diagram for data query device that the embodiment of the present invention four provides, and the present embodiment can
Suitable for carrying out data base querying just for field name and corresponding field value, to obtain and the field name and corresponding field
The case where being worth matched data record, the device can be realized by the way of software and/or hardware, and can generally be integrated in meter
In the processor for calculating machine equipment.As shown in figure 4, the device includes: to obtain module 410, enquiry module 420 and feedback module 430,
Wherein,
Module 410 is obtained, for obtaining data query information and data source information, the data query information includes:
Field name, and field value corresponding with the field name；
Enquiry module 420, for storing in the server and the data source information at least one matched database
In, data query is carried out to the data query information, obtains and remembers at least one data of the data query information matches
Record；
Feedback module 430, for generating the feedback knot of the data query information according at least one data record
Fruit.
In the embodiment of the present invention, it is limited to according to the database that the data source information of acquisition will access and data source information
Matched database, rather than all databases stored on server carry out data to data query information to reduce
The database range of inquiry, thus shortens query time；By being stored in the server according to data source information remote access
With at least one matched database of data source information, to data query information carry out data query technological means, to
Family only opens search access right, so that user need not directly operate on the server, and then even not to the operational efficiency of server
Performance has an impact, while also avoiding may cause and database accident occurring since user inputs code by mistake on the server
Problem.When the data query method provided through the embodiment of the present invention as a result, carries out data query, user can be reduced to data
The operational risk in library, and be able to solve only according to field name and the time-consuming excessive problem of corresponding field value trace data record.
Further, enquiry module 420 includes acquiring unit, the first query unit and the second query unit, wherein
Acquiring unit, for successively acquisition and the matched database of the data source information, and in the data of acquisition
In at least one tables of data that library includes, data query is carried out to the data query information；
First query unit, if having inquired database data point each other specifically for current acquisition database and one
Library, then according to the database of having inquired to the hit situation of the field name, determination is corresponding with the current acquisition database
Query strategy carry out data query；
Second query unit, if having inquired tables of data data point each other with one specifically for current queries tables of data
Table, then according to the tables of data of having inquired to the hit situation of the field name, determination is corresponding with the current queries tables of data
Query strategy carry out data query.
Specifically, in data source, identical at least two database of database name after removing suffix name data each other
Divide library；In the same database in data source, identical at least two tables of data of tables of data name after removing suffix name is mutual
Divide table for data.
Further, the first query unit is specifically used for judgement is described to have inquired whether have at least one target in database
Tables of data hits the field name in the data query information；If so, only in the current acquisition database with the mesh
Data query is carried out in the identical tables of data of mark data table name；Otherwise, data no longer are carried out to the current acquisition database
Inquiry.
Further, the second query unit is specifically used for having inquired whether tables of data hits the data query described in judgement
Field name in information；If so, carrying out data query to the current queries tables of data；Otherwise, it no longer currently looks into described
It askes tables of data and carries out data query.
A kind of optional embodiment, the device further include: data source obtains test module, for obtaining user's input
With associated at least one data source information of the field name；At least one data source is believed according to the test request of user
Breath is tested.
Further, device further include: field name obscures reminding module, for obtaining user for field name input
At least one character；According to the field name in all tables of data at least one matched database of the data source information,
And the user is directed at least one character of field name input, the fuzzy prompting of field name is generated, for user reference
Or selection.
Another optional embodiment obtains module 410 and specifically includes: data query information acquisition unit, database
Determination unit and data source information generation unit, wherein
Data query information acquisition unit, for obtaining the data query information；
Database determination unit, for traversing in the server according to the field name in the data query information
All data list structures of storage, determining and at least one matched database of the field name；
Data source information generation unit, for generating at least one number according to the related information of at least one database
According to source information.
Further, the related information that feedback module 430 is specifically used for tables of data where recording every data is made respectively
For data record item corresponding with the data query information, each data record item constitutes the feedback result；
One-to-one field name character string and field value character string are generated according to every data record, wherein the word
Spcial character interval, corresponding different field in the field value character string are used in section name character string between variant field name
The spcial character interval is used between value；
Hyperlink record number is added in each data record item, is compiled so that user records according to the hyperlink
It number checks and the field name of every data record matching and the one-to-one data form of field value, wherein the data form
It is generated and being cut the field name character string and field value character string according to the spcial character respectively.
Data query device provided by the embodiment of the present invention can be performed data provided by any embodiment of the invention and look into
Inquiry method has the corresponding functional module of execution method and beneficial effect.
Embodiment five
Fig. 5 is a kind of structural schematic diagram for computer equipment that the embodiment of the present invention five provides, as shown in figure 5, the calculating
Machine equipment includes processor 50, memory 51, input unit 52 and output device 53；The quantity of processor 50 in computer equipment
It can be one or more, in Fig. 5 by taking a processor 50 as an example；Processor 50, memory 51, input in computer equipment
Device 52 can be connected with output device 53 by bus or other modes, in Fig. 5 for being connected by bus.
Memory 51 is used as a kind of computer readable storage medium, can be used for storing software program, journey can be performed in computer
Sequence and module, if the corresponding program instruction/module of data query method in the embodiment of the present invention is (for example, data query fills
Acquisition module 410, enquiry module 420 and feedback module 430 in setting).Processor 50 is stored in memory 51 by operation
Software program, instruction and module realize thereby executing the various function application and data processing of computer equipment
The data query method stated.
Memory 51 can mainly include storing program area and storage data area, wherein storing program area can store operation system
Application program needed for system, at least one function；Storage data area, which can be stored, uses created number according to computer equipment
According to etc..In addition, memory 51 may include high-speed random access memory, it can also include nonvolatile memory, such as extremely
A few disk memory, flush memory device or other non-volatile solid state memory parts.In some instances, memory 51
It can further comprise the memory remotely located relative to processor 50, these remote memories can pass through network connection to meter
Calculate machine equipment.The example of above-mentioned network includes but is not limited to internet, intranet, local area network, mobile radio communication and its group
It closes.
Input unit 52 can be used for receiving the number or character information of input, and generates and set with the user of computer equipment
It sets and the related key signals of function control inputs.Output device 53 may include that display screen etc. shows equipment.
Embodiment six
The embodiment of the present invention six also provides a kind of computer readable storage medium for being stored with computer program, computer journey
Sequence is used to execute a kind of data query method when being executed by computer processor, this method comprises:
Data query information and at least one data source information are obtained, the data query information includes: field name, with
And field value corresponding with the field name；
Store in the server at least one matched database of the data source information, to the data query
Information carries out data query, obtains at least one data record with the data query information matches；
According to the data record, the feedback result of the data query information is generated.
Certainly, it is stored with the computer readable storage medium of computer program provided by the embodiment of the present invention, calculates
Machine program is not limited to method operation as above, can also be performed in data query method provided by any embodiment of the invention
Relevant operation.
By the description above with respect to embodiment, it is apparent to those skilled in the art that, the present invention
It can be realized by software and required common hardware, naturally it is also possible to which by hardware realization, but in many cases, the former is more
Good embodiment.Based on this understanding, technical solution of the present invention substantially in other words contributes to the prior art
Part can be embodied in the form of software products, which can store in computer readable storage medium
In, floppy disk, read-only memory (Read-Only Memory, ROM), random access memory (Random such as computer
Access Memory, RAM), flash memory (FLASH), hard disk or CD etc., including some instructions are with so that a computer is set
The method that standby (can be personal computer, server or the network equipment etc.) executes each embodiment of the present invention.
It is worth noting that, included each unit and module are only pressed in the embodiment of above-mentioned data query device
It is divided, but is not limited to the above division according to function logic, as long as corresponding functions can be realized；In addition,
The specific name of each functional unit is also only for convenience of distinguishing each other, the protection scope being not intended to restrict the invention.
Note that the above is only a better embodiment of the present invention and the applied technical principle.It will be appreciated by those skilled in the art that
The present invention is not limited to specific embodiments here, be able to carry out for a person skilled in the art it is various it is apparent variation, again
Adjustment and substitution are without departing from protection scope of the present invention.Therefore, although by above embodiments to the present invention carried out compared with
For detailed description, but the present invention is not limited to the above embodiments only, without departing from the inventive concept, can be with
Including more other equivalent embodiments, and the scope of the invention is determined by the scope of the appended claims.
Claims (12)
1. a kind of data query method characterized by comprising
It obtains data query information and at least one data source information, the data query information includes: field name, Yi Jiyu
The corresponding field value of the field name；
Store in the server at least one matched database of the data source information, to the data query information
Data query is carried out, at least one data record with the data query information matches is obtained；
According to the data record, the feedback result of the data query information is generated.
2. the method according to claim 1, wherein what is stored in the server matches with the data source information
At least one database in, to the data query information carry out data query, comprising:
Successively acquisition and the matched database of the data source information, and at least one number for including in the database of acquisition
According in table, data query is carried out to the data query information；
If currently obtaining database and one having been inquired database data point library each other, database pair has been inquired according to described
The hit situation of the field name, determining query strategy progress data query corresponding with the current acquisition database；And/or
If current queries tables of data with one has inquired tables of data, data divide table each other, have inquired tables of data pair according to described
The hit situation of the field name determines that query strategy corresponding with the current queries tables of data carries out data query.
3. according to the method described in claim 2, it is characterized in that,
In data source, data divide library to identical at least two database of database name after removing suffix name each other；And/or
In the same database in data source, identical at least two tables of data of tables of data name after removing suffix name is each other
Data divide table.
4. according to the method in claim 2 or 3, which is characterized in that according to the database of having inquired to the field name
Hit situation, determining query strategy progress data query corresponding with the current acquisition database specifically includes:
Judgement is described to have inquired in database the word for whether having at least one target matrix to hit in the data query information
Section name；
If so, only carrying out data in tables of data identical with the target data table name in the current acquisition database
Inquiry；Otherwise, data query no longer is carried out to the current acquisition database.
5. according to the method in claim 2 or 3, which is characterized in that according to the tables of data of having inquired to the field name
Hit situation, determine corresponding with current queries tables of data query strategy progress data query, specifically include:
Judgement is described to have inquired whether tables of data hits field name in the data query information；
If so, carrying out data query to the current queries tables of data；Otherwise, no longer the current queries tables of data is carried out
Data query.
6. the method according to claim 1, wherein in the acquisition data query information and data source information
Before, further includes:
Obtain user input with associated at least one data source information of the field name；
At least one data source information is tested according to the test request of user.
7. the method according to claim 1, wherein the acquisition data query information and at least one data
Source information, comprising:
Obtain the data query information；
According to the field name in the data query information, traverse in all data list structures stored in the server, really
Fixed and at least one matched database of the field name；
At least one data source information is generated according to the related information of at least one database.
8. the method according to claim 1, wherein generating the number according at least one data record
According to the feedback result of query information, comprising:
The related information of tables of data is remembered as data corresponding with the data query information where every data is recorded
Item is recorded, each data record item constitutes the feedback result；
One-to-one field name character string and field value character string are generated according to every data record, wherein the field name
Spcial character interval is used in character string between variant field name, in the field value character string corresponding different field value it
Between use the spcial character interval；
Hyperlink record number is added in each data record item, so that user looks into according to the hyperlink record number
It sees and the field name of every data record matching and the one-to-one data form of field value, wherein the data form passes through
The field name character string and field value character string are cut according to the spcial character respectively and generated.
9. according to the method described in claim 6, it is characterized in that, being gone back before obtaining the field name in data query information
Include:
Obtain at least one character that user is directed to field name input；
According to in all tables of data at least one matched database of the data source information field name and the use
Family is directed at least one character of field name input, generates the fuzzy prompting of field name, so that the user refers to or selects.
10. a kind of data query device characterized by comprising
Module is obtained, for obtaining data query information and at least one data source information, the data query information includes:
Field name, and field value corresponding with the field name；
Enquiry module, for store in the server at least one matched database of the data source information, to institute
It states data query information and carries out data query, obtain at least one data record with the data query information matches；
Feedback module, for generating the feedback result of the data query information according to the data record.
11. a kind of computer equipment, which is characterized in that the computer equipment includes:
One or more processors；
Memory, for storing one or more programs,
When one or more of programs are executed by one or more of processors, so that one or more of processors are real
The now data query method as described in any in claim 1-9.
12. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the program is by processor
The data query method as described in any in claim 1-9 is realized when execution.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910031419.6A CN109783543B (en) | 2019-01-14 | 2019-01-14 | Data query method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910031419.6A CN109783543B (en) | 2019-01-14 | 2019-01-14 | Data query method, device, equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109783543A true CN109783543A (en) | 2019-05-21 |
| CN109783543B CN109783543B (en) | 2021-07-02 |
Family
ID=66500443
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910031419.6A Active CN109783543B (en) | 2019-01-14 | 2019-01-14 | Data query method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109783543B (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110287346A (en) * | 2019-06-28 | 2019-09-27 | 深圳云天励飞技术有限公司 | Data storage method, device, server and storage medium |
| CN110457541A (en) * | 2019-06-28 | 2019-11-15 | 卓尔智联(武汉)研究院有限公司 | Processing method, service platform, terminal device and the storage medium of data |
| CN111223541A (en) * | 2020-01-10 | 2020-06-02 | 王利 | Newborn information matching method, device and terminal device |
| CN111459982A (en) * | 2020-03-27 | 2020-07-28 | 中国平安人寿保险股份有限公司 | Data query method and device, terminal device and storage medium |
| CN112069174A (en) * | 2020-08-25 | 2020-12-11 | 北京锐安科技有限公司 | Data extraction method, device, equipment and storage medium |
| CN112231541A (en) * | 2020-09-22 | 2021-01-15 | 苏州艾特律宝智能科技有限公司 | Data retrieval method, system, computer device and storage medium |
| CN112540995A (en) * | 2020-11-11 | 2021-03-23 | 特劢丝软件科技(上海)有限公司 | Data updating method, electronic device and storage medium |
| CN114067851A (en) * | 2021-09-30 | 2022-02-18 | 高德软件有限公司 | Signal source processing method and device and nonvolatile storage medium |
| CN114547090A (en) * | 2022-02-25 | 2022-05-27 | 中国建设银行股份有限公司 | Data query method and device, electronic equipment and storage medium |
| CN114881613A (en) * | 2022-06-01 | 2022-08-09 | 北京字跳网络技术有限公司 | Data processing method and device, electronic equipment and storage medium |
| CN115048393A (en) * | 2022-05-25 | 2022-09-13 | 曙光信息产业股份有限公司 | Resource management method, apparatus, system, device, medium, and program product |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106372177A (en) * | 2016-08-30 | 2017-02-01 | 东华大学 | Query expansion method supporting correlated query and fuzzy grouping of mixed data type |
| CN106528579A (en) * | 2015-09-15 | 2017-03-22 | 阿里巴巴集团控股有限公司 | Search method, device and system based on sharding structure databases |
| CN107368493A (en) * | 2016-05-12 | 2017-11-21 | 百度在线网络技术（北京）有限公司 | Data base query method and device |
| CN107391739A (en) * | 2017-08-07 | 2017-11-24 | 北京奇艺世纪科技有限公司 | A kind of query statement generation method, device and electronic equipment |
| CN107798035A (en) * | 2017-04-10 | 2018-03-13 | 平安科技（深圳）有限公司 | A kind of data processing method and terminal |
| CN107818115A (en) * | 2016-09-14 | 2018-03-20 | 苏宁云商集团股份有限公司 | A kind of method and device of processing data table |
| US20180129684A1 (en) * | 2016-11-09 | 2018-05-10 | Palantir Technologies Inc. | Validating data integrations using a secondary data store |
| US10176259B1 (en) * | 2009-05-15 | 2019-01-08 | Donald Newton Cohen | Use of virtual database technology for internet search and data integration |
-
2019
- 2019-01-14 CN CN201910031419.6A patent/CN109783543B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10176259B1 (en) * | 2009-05-15 | 2019-01-08 | Donald Newton Cohen | Use of virtual database technology for internet search and data integration |
| CN106528579A (en) * | 2015-09-15 | 2017-03-22 | 阿里巴巴集团控股有限公司 | Search method, device and system based on sharding structure databases |
| CN107368493A (en) * | 2016-05-12 | 2017-11-21 | 百度在线网络技术（北京）有限公司 | Data base query method and device |
| CN106372177A (en) * | 2016-08-30 | 2017-02-01 | 东华大学 | Query expansion method supporting correlated query and fuzzy grouping of mixed data type |
| CN107818115A (en) * | 2016-09-14 | 2018-03-20 | 苏宁云商集团股份有限公司 | A kind of method and device of processing data table |
| US20180129684A1 (en) * | 2016-11-09 | 2018-05-10 | Palantir Technologies Inc. | Validating data integrations using a secondary data store |
| CN107798035A (en) * | 2017-04-10 | 2018-03-13 | 平安科技（深圳）有限公司 | A kind of data processing method and terminal |
| CN107391739A (en) * | 2017-08-07 | 2017-11-24 | 北京奇艺世纪科技有限公司 | A kind of query statement generation method, device and electronic equipment |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110287346B (en) * | 2019-06-28 | 2021-11-30 | 深圳云天励飞技术有限公司 | Data storage method, device, server and storage medium |
| CN110457541A (en) * | 2019-06-28 | 2019-11-15 | 卓尔智联(武汉)研究院有限公司 | Processing method, service platform, terminal device and the storage medium of data |
| CN110287346A (en) * | 2019-06-28 | 2019-09-27 | 深圳云天励飞技术有限公司 | Data storage method, device, server and storage medium |
| CN111223541A (en) * | 2020-01-10 | 2020-06-02 | 王利 | Newborn information matching method, device and terminal device |
| CN111459982A (en) * | 2020-03-27 | 2020-07-28 | 中国平安人寿保险股份有限公司 | Data query method and device, terminal device and storage medium |
| CN112069174A (en) * | 2020-08-25 | 2020-12-11 | 北京锐安科技有限公司 | Data extraction method, device, equipment and storage medium |
| CN112231541A (en) * | 2020-09-22 | 2021-01-15 | 苏州艾特律宝智能科技有限公司 | Data retrieval method, system, computer device and storage medium |
| CN112540995A (en) * | 2020-11-11 | 2021-03-23 | 特劢丝软件科技(上海)有限公司 | Data updating method, electronic device and storage medium |
| CN112540995B (en) * | 2020-11-11 | 2022-12-02 | 上海赛美特软件科技有限公司 | Data updating method, electronic device and storage medium |
| CN114067851A (en) * | 2021-09-30 | 2022-02-18 | 高德软件有限公司 | Signal source processing method and device and nonvolatile storage medium |
| CN114067851B (en) * | 2021-09-30 | 2023-07-21 | 高德软件有限公司 | Signal source processing method and device and nonvolatile storage medium |
| CN114547090A (en) * | 2022-02-25 | 2022-05-27 | 中国建设银行股份有限公司 | Data query method and device, electronic equipment and storage medium |
| CN115048393A (en) * | 2022-05-25 | 2022-09-13 | 曙光信息产业股份有限公司 | Resource management method, apparatus, system, device, medium, and program product |
| CN114881613A (en) * | 2022-06-01 | 2022-08-09 | 北京字跳网络技术有限公司 | Data processing method and device, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109783543B (en) | 2021-07-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109783543A (en) | Data query method, apparatus, equipment and storage medium | |
| US20210318851A1 (en) | Systems and Methods for Dataset Merging using Flow Structures | |
| US10885000B2 (en) | Repairing corrupted references | |
| CA3087297A1 (en) | Blockchain-based data verification method and apparatus, and electronic device | |
| CN111881042B (en) | Automatic test script generation method and device and electronic equipment | |
| US9305102B2 (en) | Systems and methods for providing personalized search results based on prior user interactions | |
| CN113010208B (en) | Version information generation method, device, equipment and storage medium | |
| CN107480262A (en) | A kind of general management system of database based on webpage | |
| CN106897053A (en) | A kind of code dissemination method and device | |
| CN106844730A (en) | The display methods and device of file content | |
| CN112734387A (en) | Document approval method and device, electronic equipment and storage medium | |
| US20100070893A1 (en) | Data quality administration framework | |
| CN116089439A (en) | Dynamic form modification method and device | |
| US11847120B2 (en) | Performance of SQL execution sequence in production database instance | |
| CN106547898A (en) | A kind of data processing method and device of distributed data base | |
| US11442995B2 (en) | Filtering of log search results based on automated analysis | |
| US20180260820A1 (en) | System device and process for an educational regulatory electronic tool kit | |
| CN118733448A (en) | Data processing method, test method, device, system, medium and program product | |
| CN107679198B (en) | Information query method and device | |
| CN106406860A (en) | B/S framework-based virtual maintenance training simulation platform and application thereof | |
| CN111226245A (en) | Computer-based learning system for analyzing agreements | |
| US20230195792A1 (en) | Database management methods and associated apparatus | |
| US10635573B2 (en) | Auto-generated multiple input variants | |
| CN109697141B (en) | Method and device for visual testing | |
| US20110078183A1 (en) | Value help search system and method |
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 |