CN108038135A - Electronic device, the method for multilist correlation inquiry and storage medium - Google Patents
Electronic device, the method for multilist correlation inquiry and storage medium Download PDFInfo
- Publication number
- CN108038135A CN108038135A CN201711166811.9A CN201711166811A CN108038135A CN 108038135 A CN108038135 A CN 108038135A CN 201711166811 A CN201711166811 A CN 201711166811A CN 108038135 A CN108038135 A CN 108038135A
- Authority
- CN
- China
- Prior art keywords
- data
- field
- associate field
- inquiry
- associate
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24532—Query optimisation of parallel queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of electronic device, the method for multilist correlation inquiry and storage medium, the method for the multilist correlation inquiry includes：The multiple queries condition that multiple tables of data are associated with inquiry is received, if it is logical AND relation there are at least two querying conditions in the querying condition, one or more associations field is determined according to the querying condition with logical AND relation；Obtain the corresponding data of identical associate field respectively in multiple tables of data, the corresponding data of identical associate field are merged into processing respectively；Data after identical associate field merging treatment are converted to the form of row, to perform inquiry based on transformed data and multiple queries condition.The present invention can improve the efficiency of multilist correlation inquiry data.
Description
Technical field
The present invention relates to database technical field, more particularly to a kind of method of electronic device, multilist correlation inquiry and deposit
Storage media.
Background technology
At present, data base querying is inquired about by row, when being associated inquiry to multilist, if user-defined inquiry
Condition is multiple, then needs inquiry multiple, such as querying condition is N number of, then first carries out data according to first querying condition
Inquiry, then carries out the data query of second querying condition, the number of inquiry is n times in query result.In querying condition
When more, the number of this inquiry mode inquiry is more so that the inefficiency of database data inquiry.
The content of the invention
It is an object of the invention to provide a kind of electronic device, the method for multilist correlation inquiry and storage medium, it is intended to carries
The efficiency of high multilist correlation inquiry data.
To achieve the above object, the present invention provides a kind of electronic device, the electronic device include memory and with it is described
The processor of memory connection, is stored with the processing system that can be run on the processor, the processing in the memory
System realizes following steps when being performed by the processor：
Associate field determines step：The multiple queries condition that multiple tables of data are associated with inquiry is received, if described look into
It is logical AND relation to have at least two querying conditions in inquiry condition, then determines one according to the querying condition with logical AND relation
Or multiple associate fields；
Data combining step：Obtain the corresponding data of identical associate field respectively in multiple tables of data, respectively will be identical
The corresponding data of associate field merge processing；
Data conversion step：Data after identical associate field merging treatment are converted to the form of row, with based on conversion
Data and multiple queries condition afterwards perform inquiry.
Preferably, the step of there is the basis querying condition of logical AND relation to determine one or more associations field,
Specifically include：
The same field of the querying condition with logical AND relation is obtained, analyzes the part of speech of the same field；
If the part of speech of the same field is predetermined part of speech, using the same field as the associate field.
Preferably, the step of data by after identical associate field merging treatment are converted to the form of row, specific bag
Include：
It is successively a line by associate field arrangement using associate field as gauge outfit；
Under the corresponding row of gauge outfit of each associate field, the data that are loaded into after the corresponding merging treatment of the associate field,
In the form of being converted to row.
Preferably, when the processing system is performed by the processor, further include：
When performing inquiry operation, acquisition meets under the associate field and the corresponding row of the associate field of multiple queries condition
Data, using the data under each associate field and the corresponding row of the associate field as a query result data, and export
Each bar query result data.
To achieve the above object, the present invention also provides a kind of method of multilist correlation inquiry, the multilist correlation inquiry
Method includes：
S1, receives the multiple queries condition that multiple tables of data are associated with inquiry, if having at least in the querying condition
Two querying conditions are logical AND relation, then determine one or more associations word according to the querying condition with logical AND relation
Section；
S2, obtains the corresponding data of identical associate field, respectively by identical associate field pair respectively in multiple tables of data
The data answered merge processing；
Data after identical associate field merging treatment, are converted to the form of row by S3, with based on transformed data and
Multiple queries condition performs inquiry.
Preferably, the step of there is the basis querying condition of logical AND relation to determine one or more associations field,
Specifically include：
The same field of the querying condition with logical AND relation is obtained, analyzes the part of speech of the same field；
If the part of speech of the same field is predetermined part of speech, using the same field as the associate field.
Preferably, the step of data by after identical associate field merging treatment are converted to the form of row, specific bag
Include：
It is successively a line by associate field arrangement using associate field as gauge outfit；
Under the corresponding row of gauge outfit of each associate field, the data that are loaded into after the corresponding merging treatment of the associate field,
In the form of being converted to row.
Preferably, after the step S3, further include：
S4, when performing inquiry operation, acquisition meets that the associate field of multiple queries condition and the associate field are corresponding
Data under row, using the data under each associate field and the corresponding row of the associate field as a query result data, and
Export each bar query result data.
Preferably, the tables of data is third normal form structured data table.
The present invention also provides a kind of computer-readable recording medium, processing is stored with the computer-readable recording medium
The step of system, the processing system realizes the method for above-mentioned multilist correlation inquiry when being executed by processor.
The beneficial effects of the invention are as follows：The present invention is being the pass of logical AND to multilist correlation inquiry, and between querying condition
When being, associate field is determined according to querying condition, obtains the corresponding data of identical associate field respectively in multiple tables of data, point
The corresponding data of identical associate field are not merged into processing, then the data after merging are converted to the form of row, with base
Inquiry is performed in transformed data, the present invention performs inquiry based on transformed data, and the operation of correlation inquiry only needs to hold
Row once, improves the efficiency of database data inquiry.
Brief description of the drawings
Fig. 1 is each optional application environment schematic diagram of embodiment one of the present invention；
Fig. 2 is the flow diagram of one embodiment of method of multilist correlation inquiry of the present invention；
Fig. 3 is the flow diagram of another embodiment of method of multilist correlation inquiry of the present invention.
Embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, with reference to the accompanying drawings and embodiments, it is right
The present invention is further elaborated.It should be appreciated that specific embodiment described herein is only to explain the present invention, not
For limiting the present invention.Based on the embodiments of the present invention, those of ordinary skill in the art are not before creative work is made
All other embodiments obtained are put, belong to the scope of protection of the invention.
It should be noted that the description for being related to " first ", " second " etc. in the present invention is only used for description purpose, and cannot
It is interpreted as indicating or implies its relative importance or imply the quantity of the technical characteristic indicated by indicating.Thus, define " the
One ", at least one this feature can be expressed or be implicitly included to the feature of " second ".In addition, the skill between each embodiment
Art scheme can be combined with each other, but must can be implemented as basis with those of ordinary skill in the art, when technical solution
It will be understood that the combination of this technical solution is not present with reference to there is conflicting or can not realize when, also not in application claims
Protection domain within.
As shown in fig.1, it is the application environment schematic diagram of the preferred embodiment of the method for multilist correlation inquiry of the present invention.Should
Application environment schematic diagram includes electronic device 1 and terminal device 2.Electronic device 1 can be suitable by network, near-field communication technology etc.
The technology of conjunction carries out data interaction with terminal device 2.
The terminal device 2, which includes, but not limited to any type, to pass through keyboard, mouse, remote controler, touch with user
The mode such as plate or voice-operated device carries out the electronic product of human-computer interaction, for example, personal computer, tablet computer, smart mobile phone,
Personal digital assistant (Personal Digital Assistant, PDA), game machine, Interactive Internet TV (Internet
Protocol Television, IPTV), intellectual Wearable, the movable equipment of guider etc., or such as
The fixed terminal of digital TV, desktop computer, notebook, server etc..User is in 2 input inquiry condition of terminal device, general
Querying condition sends to electronic device 1, electronic device 1 and performs data query according to querying condition.
The electronic device 1 be it is a kind of can according to the instruction for being previously set or storing, it is automatic carry out numerical computations and/
Or the equipment of information processing.The electronic device 1 can be computer, can also be single network server, multiple networks clothes
It is engaged in the server group either cloud being made of a large amount of hosts or the webserver based on cloud computing of device composition, wherein cloud computing
It is one kind of Distributed Calculation, a super virtual computer being made of the computer collection of a group loose couplings.
In the present embodiment, electronic device 1 may include, but be not limited only to, and can be in communication with each other connection by system bus
Memory 11, processor 12, network interface 13, memory 11 are stored with the processing system that can be run on the processor 12.Need
, it is noted that Fig. 1 illustrate only the electronic device 1 with component 11-13, it should be understood that being not required for implementing all
The component shown, what can be substituted implements more or less components.
Wherein, memory 11 includes memory and the readable storage medium storing program for executing of at least one type.Inside save as the fortune of electronic device 1
Row provides caching；Readable storage medium storing program for executing can be if flash memory, hard disk, multimedia card, card-type memory are (for example, SD or DX memories
Deng), random access storage device (RAM), static random-access memory (SRAM), read-only storage (ROM), electric erasable can compile
Journey read-only storage (EEPROM), programmable read only memory (PROM), magnetic storage, disk, CD etc. it is non-volatile
Storage medium.In certain embodiments, readable storage medium storing program for executing can be the internal storage unit of electronic device 1, such as the electronics
The hard disk of device 1；In further embodiments, which can also be that the external storage of electronic device 1 is set
Plug-in type hard disk that is standby, such as being equipped with electronic device 1, intelligent memory card (Smart Media Card, SMC), secure digital
(Secure Digital, SD) blocks, flash card (Flash Card) etc..In the present embodiment, the readable storage medium storing program for executing of memory 11
The operating system and types of applications software of electronic device 1, such as the place in one embodiment of the invention are installed on commonly used in storage
Program code of reason system etc..Export or will export each in addition, memory 11 can be also used for temporarily storing
Class data.
The processor 12 can be in certain embodiments central processing unit (Central Processing Unit,
CPU), controller, microcontroller, microprocessor or other data processing chips.The processor 12 is commonly used in the control electricity
The overall operation of sub-device 1, such as perform and carry out data interaction or communicate relevant control and processing with the terminal device 2
Deng.In the present embodiment, the processor 12 is used to run the program code stored in the memory 11 or processing data, example
Such as run processing system.
The network interface 13 may include radio network interface or wired network interface, which is commonly used in
Communication connection is established between the electronic device 1 and other electronic equipments.In the present embodiment, network interface 13 is mainly used for electricity
Sub-device 1 is connected with one or more terminal devices 2, and data are established between electronic device 1 and one or more terminal devices 2
Transmission channel and communication connection.
The processing system is stored in memory 11, including it is at least one be stored in it is computer-readable in memory 11
Instruction, which can be performed by processor device 12, to realize the method for each embodiment of the application；With
And at least one computer-readable instruction is different according to the function that its each several part is realized, can be divided into different logic moulds
Block.
In one embodiment, following steps are realized when above-mentioned processing system is performed by the processor 12：
Associate field determines step：The multiple queries condition that multiple tables of data are associated with inquiry is received, if described look into
It is logical AND relation to have at least two querying conditions in inquiry condition, then determines one according to the querying condition with logical AND relation
Or multiple associate fields；
In the present embodiment, tables of data is preferably third normal form structured data table.User is to multiple tables of data in database
When being inquired about, operated on terminal device 2, input inquiry condition, the querying condition to be multiple, multiple queries condition it
Between can be connected using logical symbol.Such as the score inquiry of the student to being recorded in tables of data, querying condition can be " languages
The student that literary achievement is more than 60 points of student and mathematics achievement is more than 60 points ".By querying condition send to electronic device 1 into
The inquiry of row database data.
In the present embodiment, when receiving the multiple queries condition that multiple tables of data are associated with inquiry, to inquiring about bar
Part is analyzed, and whether the logical symbol analyzed between multiple queries condition has a logical AND, for example, for querying condition " Chinese language into
The student that achievement is more than 60 points of student and mathematics achievement is more than 60 points ", then querying condition " Chinese Achievement Test be more than 60 points "
It is the relation of the relation, i.e. " and " of logical AND between querying condition " mathematics achievement is more than 60 points ".
Then multiple associate fields are determined according to the querying condition with logical AND relation, it is preferable that acquisition has logic
With the same field of the querying condition of relation, the part of speech of the same field is analyzed, if the part of speech of the same field is predetermined word
Property (such as noun), then using the same field as the associate field.Such as " Chinese Achievement Test is more than 60 points to querying condition
Student " inquiry is student, and querying condition " mathematics achievement is more than 60 points of student " inquiry is also student, then student is two
The same field of a querying condition, and part of speech is noun, it may be determined that associate field is the name of student.
In addition, if querying condition is more, possible associated field is multiple, for example, querying condition 1 and querying condition 2
Between associate field be name, the associate field between querying condition 2 and querying condition 3 is telephone number or order number etc.
Deng.
Data combining step：Obtain the corresponding data of identical associate field respectively in multiple tables of data, respectively will be identical
The corresponding data of associate field merge processing；
In the present embodiment, such as in two tables of data 1 and 2, a certain associate field corresponding data in table 1 are obtained,
And the associate field corresponding data in table 2 are obtained, acquired data are merged.When merging, number can be created
The data after merging are stored according to table, i.e., the data of above-mentioned acquired table 1 and table 2 are recorded under the associate field, or at this
The data of above-mentioned acquired table 1 and table 2 are associated under associate field.
Data conversion step：Data after identical associate field merging treatment are converted to the form of row, with based on conversion
Data and multiple queries condition afterwards perform inquiry.
, can be with pass when the data after by identical associate field merging treatment are converted to the form of row in the present embodiment
Connection field is gauge outfit, is successively a line by associate field arrangement, under the row of the corresponding gauge outfit of the associate field, is loaded into the association
Data after the corresponding merging treatment of field, the mode of row is converted into by such a mode.
In the present embodiment, user to multiple tables of data when being associated inquiry, after input inquiry condition, by above-mentioned true
After determining associate field, data merging and data conversion, inquiry, inquiry behaviour are performed based on transformed data and multiple queries condition
Make only to need to perform once.
In one embodiment, using " Chinese Achievement Test is more than 60 points of student and student that mathematics achievement is more than 60 points "
Querying condition illustrates exemplified by two tables of data are associated with inquiry：
The Chinese Achievement Test of student is recorded in first tables of data, and the mathematics achievement of student is recorded in second tables of data
In.It is for two querying conditions of logical AND relation：Chinese Achievement Test is more than 60 points of student and mathematics achievement is more than 60 points
Student, it is determined that associate field be student name.Then the Chinese Achievement Test of student A and mathematics achievement are merged, by student B
Chinese Achievement Test and mathematics achievement merge, and so on.
When the data after by identical associate field merging treatment are converted to the form of row, downloaded in the corresponding row of student A
Enter the Chinese Achievement Test and mathematics achievement of student A, the Chinese Achievement Test and mathematics achievement of student B are downloaded into the corresponding row of student B, with
This analogizes.
When inquiring about " student that Chinese Achievement Test is more than 60 points of student and mathematics achievement is more than 60 points ", it is only necessary to by
A student performs inquiry, and the corresponding data of first student of inquiry are that can obtain the query result of the student, and so on, association
Inquire about one time and can obtain query result, improve the efficiency of inquiry.
Compared with prior art, the present embodiment is being the relation of logical AND to multilist correlation inquiry, and between querying condition
When, associate field is determined according to querying condition, obtains the corresponding data of identical associate field respectively in multiple tables of data, respectively
The corresponding data of identical associate field are merged into processing, then the data after merging are converted to the form of row, with based on
Transformed data perform inquiry, and the present embodiment performs inquiry based on transformed data, and the operation of correlation inquiry only needs to hold
Row once, improves the efficiency of database data inquiry.
In a preferred embodiment, on the basis of the embodiment of above-mentioned Fig. 1, the processing system is by the processor
During execution, further include：
When performing inquiry operation, acquisition meets under the associate field and the corresponding row of the associate field of multiple queries condition
Data, using the data under each associate field and the corresponding row of the associate field as a query result data, and export
Each bar query result data.
In the present embodiment, using the data under associate field and the corresponding row of the associate field as a query result data,
One or more may be had by meeting the query result data of multiple queries condition, and a plurality of inquiry knot is exported in a manner of the present embodiment
Fruit data, can facilitate user to be checked and used.
As shown in Fig. 2, Fig. 2 is the flow diagram of one embodiment of method of multilist correlation inquiry of the present invention, which closes
The method that joint investigation is ask comprises the following steps：
Step S1, receives the multiple queries condition that multiple tables of data are associated with inquiry, if having in the querying condition
At least two querying conditions are logical AND relation, then determine one or more associations according to the querying condition with logical AND relation
Field；
In the present embodiment, tables of data is preferably third normal form structured data table.User is to multiple tables of data in database
When being inquired about, operated on terminal device 2, input inquiry condition, the querying condition to be multiple, multiple queries condition it
Between can be connected using logical symbol.Such as the score inquiry of the student to being recorded in tables of data, querying condition can be " languages
The student that literary achievement is more than 60 points of student and mathematics achievement is more than 60 points ".By querying condition send to electronic device into
The inquiry of row database data.
In the present embodiment, when receiving the multiple queries condition that multiple tables of data are associated with inquiry, to inquiring about bar
Part is analyzed, and whether the logical symbol analyzed between multiple queries condition has a logical AND, for example, for querying condition " Chinese language into
The student that achievement is more than 60 points of student and mathematics achievement is more than 60 points ", then querying condition " Chinese Achievement Test be more than 60 points "
It is the relation of the relation, i.e. " and " of logical AND between querying condition " mathematics achievement is more than 60 points ".
Then multiple associate fields are determined according to the querying condition with logical AND relation, it is preferable that acquisition has logic
With the same field of the querying condition of relation, the part of speech of the same field is analyzed, if the part of speech of the same field is predetermined word
Property (such as noun), then using the same field as the associate field.Such as " Chinese Achievement Test is more than 60 points to querying condition
Student " inquiry is student, and querying condition " mathematics achievement is more than 60 points of student " inquiry is also student, then student is two
The same field of a querying condition, and part of speech is noun, it may be determined that associate field is the name of student.
In addition, if querying condition is more, possible associated field is multiple, for example, querying condition 1 and querying condition 2
Between associate field be name, the associate field between querying condition 2 and querying condition 3 is telephone number or order number etc.
Deng.
Step S2, obtains the corresponding data of identical associate field, respectively by identical associated characters respectively in multiple tables of data
The corresponding data of section merge processing；
In the present embodiment, such as in two tables of data 1 and 2, a certain associate field corresponding data in table 1 are obtained,
And the associate field corresponding data in table 2 are obtained, acquired data are merged.When merging, number can be created
The data after merging are stored according to table, i.e., the data of above-mentioned acquired table 1 and table 2 are recorded under the associate field, or at this
The data of above-mentioned acquired table 1 and table 2 are associated under associate field.
Data after identical associate field merging treatment, are converted to the form of row, with based on transformed number by step S3
According to and multiple queries condition perform inquiry.
, can be with pass when the data after by identical associate field merging treatment are converted to the form of row in the present embodiment
Connection field is gauge outfit, is successively a line by associate field arrangement, under the row of the corresponding gauge outfit of the associate field, is loaded into the association
Data after the corresponding merging treatment of field, the mode of row is converted into by such a mode.
In the present embodiment, user to multiple tables of data when being associated inquiry, after input inquiry condition, by above-mentioned true
After determining associate field, data merging and data conversion, inquiry, inquiry behaviour are performed based on transformed data and multiple queries condition
Make only to need to perform once.
In one embodiment, using " Chinese Achievement Test is more than 60 points of student and student that mathematics achievement is more than 60 points "
Querying condition illustrates exemplified by two tables of data are associated with inquiry：
The Chinese Achievement Test of student is recorded in first tables of data, and the mathematics achievement of student is recorded in second tables of data
In.It is for two querying conditions of logical AND relation：Chinese Achievement Test is more than 60 points of student and mathematics achievement is more than 60 points
Student, it is determined that associate field be student name.Then the Chinese Achievement Test of student A and mathematics achievement are merged, by student B
Chinese Achievement Test and mathematics achievement merge, and so on.
When the data after by identical associate field merging treatment are converted to the form of row, downloaded in the corresponding row of student A
Enter the Chinese Achievement Test and mathematics achievement of student A, the Chinese Achievement Test and mathematics achievement of student B are downloaded into the corresponding row of student B, with
This analogizes.
When inquiring about " student that Chinese Achievement Test is more than 60 points of student and mathematics achievement is more than 60 points ", it is only necessary to by
A student performs inquiry, and the corresponding data of first student of inquiry are that can obtain the query result of the student, and so on, association
Inquire about one time and can obtain query result, improve the efficiency of inquiry.
Compared with prior art, the present embodiment is being the relation of logical AND to multilist correlation inquiry, and between querying condition
When, associate field is determined according to querying condition, obtains the corresponding data of identical associate field respectively in multiple tables of data, respectively
The corresponding data of identical associate field are merged into processing, then the data after merging are converted to the form of row, with based on
Transformed data perform inquiry, and the present embodiment performs inquiry based on transformed data, and the operation of correlation inquiry only needs to hold
Row once, improves the efficiency of database data inquiry.
In a preferred embodiment, as shown in figure 3, on the basis of the embodiment of above-mentioned Fig. 2, the step S3 it
Afterwards, further include：
Step S4, when performing inquiry operation, obtains the associate field and the associate field pair for meeting multiple queries condition
Data under the row answered, using the data under each associate field and the corresponding row of the associate field as a query result number
According to, and export each bar query result data.
In the present embodiment, using the data under associate field and the corresponding row of the associate field as a query result data,
One or more may be had by meeting the query result data of multiple queries condition, and a plurality of inquiry knot is exported in a manner of the present embodiment
Fruit data, can facilitate user to be checked and used.
The present invention also provides a kind of computer-readable recording medium, processing is stored with the computer-readable recording medium
The step of system, the processing system realizes the method for above-mentioned multilist correlation inquiry when being executed by processor.
The embodiments of the present invention are for illustration only, do not represent the quality of embodiment.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment side
Method can add the mode of required general hardware platform to realize by software, naturally it is also possible to by hardware, but in many cases
The former is more preferably embodiment.Based on such understanding, technical scheme substantially in other words does the prior art
Going out the part of contribution can be embodied in the form of software product, which is stored in a storage medium
In (such as ROM/RAM, magnetic disc, CD), including some instructions are used so that a station terminal equipment (can be mobile phone, computer, takes
Be engaged in device, air conditioner, or network equipment etc.) perform method described in each embodiment of the present invention.
It these are only the preferred embodiment of the present invention, be not intended to limit the scope of the invention, it is every to utilize this hair
The equivalent structure or equivalent flow shift that bright specification and accompanying drawing content are made, is directly or indirectly used in other relevant skills
Art field, is included within the scope of the present invention.
Claims (10)
1. a kind of electronic device, it is characterised in that the electronic device includes memory and the processing being connected with the memory
Device, is stored with the processing system that can be run on the processor in the memory, the processing system is by the processor
Following steps are realized during execution：
Associate field determines step：The multiple queries condition that multiple tables of data are associated with inquiry is received, if the inquiry bar
It is logical AND relation to have at least two querying conditions in part, then determines one or more according to the querying condition with logical AND relation
A associate field；
Data combining step：The corresponding data of identical associate field are obtained respectively in multiple tables of data, respectively by identical association
The corresponding data of field merge processing；
Data conversion step：Data after identical associate field merging treatment are converted to the form of row, with based on transformed
Data and multiple queries condition perform inquiry.
2. electronic device according to claim 1, it is characterised in that the basis has the querying condition of logical AND relation
The step of determining one or more associations field, specifically includes：
The same field of the querying condition with logical AND relation is obtained, analyzes the part of speech of the same field；
If the part of speech of the same field is predetermined part of speech, using the same field as the associate field.
3. electronic device according to claim 1 or 2, it is characterised in that described by after identical associate field merging treatment
Data the step of being converted to the form of row, specifically include：
It is successively a line by associate field arrangement using associate field as gauge outfit；
Under the corresponding row of gauge outfit of each associate field, the data that are loaded into after the corresponding merging treatment of the associate field, to turn
It is changed to the form of row.
4. electronic device according to claim 3, it is characterised in that when the processing system is performed by the processor,
Further include：
When performing inquiry operation, the number met under the associate field and the corresponding row of the associate field of multiple queries condition is obtained
According to using the data under each associate field and the corresponding row of the associate field as a query result data, and exporting each bar
Query result data.
A kind of 5. method of multilist correlation inquiry, it is characterised in that the method for the multilist correlation inquiry includes：
S1, receives the multiple queries condition that multiple tables of data are associated with inquiry, if having at least two in the querying condition
Querying condition is logical AND relation, then determines one or more associations field according to the querying condition with logical AND relation；
S2, obtains the corresponding data of identical associate field respectively in multiple tables of data, respectively that identical associate field is corresponding
Data merge processing；
Data after identical associate field merging treatment, are converted to the form of row by S3, with based on transformed data and multiple
Querying condition performs inquiry.
6. the method for multilist correlation inquiry according to claim 5, it is characterised in that the basis has logical AND relation
Querying condition the step of determining one or more associations field, specifically include：
The same field of the querying condition with logical AND relation is obtained, analyzes the part of speech of the same field；
If the part of speech of the same field is predetermined part of speech, using the same field as the associate field.
7. the method for the multilist correlation inquiry according to claim 5 or 6, it is characterised in that described by identical associate field
Data after merging treatment are converted to the step of form of row, specifically include：
It is successively a line by associate field arrangement using associate field as gauge outfit；
Under the corresponding row of gauge outfit of each associate field, the data that are loaded into after the corresponding merging treatment of the associate field, to turn
It is changed to the form of row.
8. the method for multilist correlation inquiry according to claim 7, it is characterised in that the step
After S3, further include：
S4, when performing inquiry operation, acquisition meets under the associate field and the corresponding row of the associate field of multiple queries condition
Data, using the data under each associate field and the corresponding row of the associate field as a query result data, and export
Each bar query result data.
9. the method for multilist correlation inquiry according to claim 5, it is characterised in that the tables of data is third normal form knot
Structure tables of data.
10. a kind of computer-readable recording medium, it is characterised in that be stored with processing system on the computer-readable recording medium
System, realizes the side of the multilist correlation inquiry as any one of claim 5 to 9 when the processing system is executed by processor
The step of method.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711166811.9A CN108038135A (en) | 2017-11-21 | 2017-11-21 | Electronic device, the method for multilist correlation inquiry and storage medium |
| PCT/CN2018/077635 WO2019100619A1 (en) | 2017-11-21 | 2018-02-28 | Electronic apparatus, method and system for multi-table correlated query, and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711166811.9A CN108038135A (en) | 2017-11-21 | 2017-11-21 | Electronic device, the method for multilist correlation inquiry and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108038135A true CN108038135A (en) | 2018-05-15 |
Family
ID=62094099
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711166811.9A Pending CN108038135A (en) | 2017-11-21 | 2017-11-21 | Electronic device, the method for multilist correlation inquiry and storage medium |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN108038135A (en) |
| WO (1) | WO2019100619A1 (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110032564A (en) * | 2019-03-07 | 2019-07-19 | 阿里巴巴集团控股有限公司 | A kind of determination method and apparatus of tables of data incidence relation |
| CN110597849A (en) * | 2018-05-25 | 2019-12-20 | 北京国双科技有限公司 | Data query method and device |
| CN110889286A (en) * | 2019-10-12 | 2020-03-17 | 平安科技（深圳）有限公司 | Dependency relationship identification method and device based on data table and computer equipment |
| CN111723210A (en) * | 2020-06-29 | 2020-09-29 | 深圳壹账通智能科技有限公司 | Method and device for storing data table, computer equipment and readable storage medium |
| CN111858609A (en) * | 2020-07-27 | 2020-10-30 | 北京金山云网络技术有限公司 | Fuzzy query method and device for block chain |
| CN112148771A (en) * | 2020-09-22 | 2020-12-29 | 京东数字科技控股股份有限公司 | Data association query method and device, electronic equipment and storage medium |
| CN112307050A (en) * | 2020-09-16 | 2021-02-02 | 苏宁云计算有限公司 | Identification method and device for repeated correlation calculation and computer system |
| CN115952174A (en) * | 2023-03-13 | 2023-04-11 | 青岛庚泽信息技术有限公司 | Data table connection method, system, terminal and storage medium |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1975725A (en) * | 2006-12-12 | 2007-06-06 | 华为技术有限公司 | Method and system for managing journal |
| CN102402515A (en) * | 2010-09-10 | 2012-04-04 | 深圳市鹏海运电子数据交换有限公司 | Universal custom query system and method |
| CN103530332A (en) * | 2013-09-29 | 2014-01-22 | 方正国际软件有限公司 | System and method for querying data of patient |
| CN105243162A (en) * | 2015-10-30 | 2016-01-13 | 方正国际软件有限公司 | Relational database storage-based objective data model query method and device |
| CN105320679A (en) * | 2014-07-11 | 2016-02-10 | 中国移动通信集团重庆有限公司 | Data table index set generation method and device |
| CN106484699A (en) * | 2015-08-25 | 2017-03-08 | 北京国双科技有限公司 | The generation method of data base querying field and device |
| CN106570022A (en) * | 2015-10-10 | 2017-04-19 | 阿里巴巴集团控股有限公司 | Cross-data-source query method, apparatus and system |
| CN106933918A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The querying method and device of tables of data |
| CN107273506A (en) * | 2017-06-19 | 2017-10-20 | 西安电子科技大学 | A kind of method of database multi-list conjunctive query |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7359908B2 (en) * | 2004-12-06 | 2008-04-15 | International Business Machines Corporation | Techniques for managing interdependent data objects |
| CN102855250B (en) * | 2011-06-30 | 2016-06-29 | 北京新媒传信科技有限公司 | The display output intent of a kind of user profile and system |
| CN104182405B (en) * | 2013-05-22 | 2017-05-24 | 阿里巴巴集团控股有限公司 | Method and device for connection query |
| US20150039587A1 (en) * | 2013-07-31 | 2015-02-05 | Oracle International Corporation | Generic sql enhancement to query any semi-structured data and techniques to efficiently support such enhancements |
-
2017
- 2017-11-21 CN CN201711166811.9A patent/CN108038135A/en active Pending
-
2018
- 2018-02-28 WO PCT/CN2018/077635 patent/WO2019100619A1/en active Application Filing
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1975725A (en) * | 2006-12-12 | 2007-06-06 | 华为技术有限公司 | Method and system for managing journal |
| CN102402515A (en) * | 2010-09-10 | 2012-04-04 | 深圳市鹏海运电子数据交换有限公司 | Universal custom query system and method |
| CN103530332A (en) * | 2013-09-29 | 2014-01-22 | 方正国际软件有限公司 | System and method for querying data of patient |
| CN105320679A (en) * | 2014-07-11 | 2016-02-10 | 中国移动通信集团重庆有限公司 | Data table index set generation method and device |
| CN106484699A (en) * | 2015-08-25 | 2017-03-08 | 北京国双科技有限公司 | The generation method of data base querying field and device |
| CN106570022A (en) * | 2015-10-10 | 2017-04-19 | 阿里巴巴集团控股有限公司 | Cross-data-source query method, apparatus and system |
| CN105243162A (en) * | 2015-10-30 | 2016-01-13 | 方正国际软件有限公司 | Relational database storage-based objective data model query method and device |
| CN106933918A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The querying method and device of tables of data |
| CN107273506A (en) * | 2017-06-19 | 2017-10-20 | 西安电子科技大学 | A kind of method of database multi-list conjunctive query |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110597849A (en) * | 2018-05-25 | 2019-12-20 | 北京国双科技有限公司 | Data query method and device |
| CN110597849B (en) * | 2018-05-25 | 2022-03-22 | 北京国双科技有限公司 | Data query method and device |
| CN110032564B (en) * | 2019-03-07 | 2023-07-14 | 创新先进技术有限公司 | Method and device for determining association relation of data table |
| CN110032564A (en) * | 2019-03-07 | 2019-07-19 | 阿里巴巴集团控股有限公司 | A kind of determination method and apparatus of tables of data incidence relation |
| CN110889286A (en) * | 2019-10-12 | 2020-03-17 | 平安科技（深圳）有限公司 | Dependency relationship identification method and device based on data table and computer equipment |
| CN110889286B (en) * | 2019-10-12 | 2022-04-12 | 平安科技（深圳）有限公司 | Dependency relationship identification method and device based on data table and computer equipment |
| CN111723210A (en) * | 2020-06-29 | 2020-09-29 | 深圳壹账通智能科技有限公司 | Method and device for storing data table, computer equipment and readable storage medium |
| CN111858609A (en) * | 2020-07-27 | 2020-10-30 | 北京金山云网络技术有限公司 | Fuzzy query method and device for block chain |
| CN111858609B (en) * | 2020-07-27 | 2024-10-22 | 北京金山云网络技术有限公司 | Block chain fuzzy query method and device |
| CN112307050A (en) * | 2020-09-16 | 2021-02-02 | 苏宁云计算有限公司 | Identification method and device for repeated correlation calculation and computer system |
| CN112307050B (en) * | 2020-09-16 | 2022-11-15 | 苏宁云计算有限公司 | Identification method and device for repeated correlation calculation and computer system |
| CN112148771A (en) * | 2020-09-22 | 2020-12-29 | 京东数字科技控股股份有限公司 | Data association query method and device, electronic equipment and storage medium |
| CN115952174A (en) * | 2023-03-13 | 2023-04-11 | 青岛庚泽信息技术有限公司 | Data table connection method, system, terminal and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2019100619A1 (en) | 2019-05-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108038135A (en) | Electronic device, the method for multilist correlation inquiry and storage medium | |
| CN111782216B (en) | Page generation method, server and storage medium | |
| CN111414407A (en) | Data query method and device of database, computer equipment and storage medium | |
| CN107992516A (en) | Electronic device, the method for data query and storage medium | |
| CN105913316B (en) | Rule configuration method and device | |
| CN106933871A (en) | Short linking processing method, device and short linked server | |
| CN104133765B (en) | The test case sending method of network activity and test case server | |
| CN107729137A (en) | Server, the method and storage medium of the decryption of block chain sign test | |
| CN104657435A (en) | Storage management method for application data and network management system | |
| CN112307264A (en) | Data query method and device, storage medium and electronic equipment | |
| CN112996020A (en) | Bluetooth-based automatic testing method and device and Bluetooth testing terminal | |
| CN111159040A (en) | Test data generation method, device, equipment and storage medium | |
| CN104932910A (en) | Method and system for application program interface extension | |
| CN109783589A (en) | The method, apparatus and storage medium of electronic map parsing address | |
| CN112631884A (en) | Pressure measurement method and device based on data synchronization, computer equipment and storage medium | |
| CN110222046B (en) | List data processing method, device, server and storage medium | |
| CN111813517A (en) | Task queue allocation method and device, computer equipment and medium | |
| CN107423395A (en) | Navigation data processing system | |
| CN105703964A (en) | Online application system test method and equipment | |
| CN107483565A (en) | A kind of service background recognition methods, proxy server and computer-readable storage medium | |
| CN109120731B (en) | Universal communication method, system and device | |
| CN110780864A (en) | Control method and device for class method replacement, storage medium and electronic equipment | |
| CN113504957A (en) | Table data processing method and device, computer equipment and storage medium | |
| CN110471708B (en) | Method and device for acquiring configuration items based on reusable components | |
| CN114579136A (en) | Code processing method and device, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180515 |
|
| RJ01 | Rejection of invention patent application after publication |