CN106933918A - The querying method and device of tables of data - Google Patents
The querying method and device of tables of data Download PDFInfo
- Publication number
- CN106933918A CN106933918A CN201511032612.XA CN201511032612A CN106933918A CN 106933918 A CN106933918 A CN 106933918A CN 201511032612 A CN201511032612 A CN 201511032612A CN 106933918 A CN106933918 A CN 106933918A
- Authority
- CN
- China
- Prior art keywords
- data
- tables
- information
- link field
- target entity
- 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
- G06F16/24542—Plan optimisation
- G06F16/24544—Join order optimisation
-
- 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
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)
- Operations Research (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This application discloses the querying method and device of a kind of tables of data.Wherein, the querying method includes：The filter condition carried in inquiry request is obtained, wherein, filter condition is used to indicate to obtain the target entity information in the absence of other entities；Based on filter condition, other entities and the corresponding multiple tables of data of target entity are obtained；The table relation of multiple tables of data is obtained, wherein, record has the link field of each tables of data in table relation；Using link field, according to the predetermined connected mode result for being connected, obtaining inquiry request counter to multiple tables of data.By the application, the low technical problem of the efficiency of prior art inquiry tables of data is solved.
Description
Technical field
The application is related to data processing field, in particular to the querying method and device of a kind of tables of data.
Background technology
In business scenario, there is the multiple entity situations such as order, page browsing information, whole entities can be by meeting
Words are associated.When being dissected to session, no condition often occurs, such as in the absence of the session of any one occurrence,
Need to being filtered in the absence of event.When filtering is in the absence of event the need for above-mentioned, traditional way,
It is Impala (dominating the inquiry system of exploitation by Cloudera companies) using Not Exists (not existing) sentences
In judged, each event in tables of data is judged one by one due to needing during judgement, it is impossible to batch
Quantization performs judgement, therefore this kind filtering is slow in the absence of the mode Performance comparision of event, cause to inquire about the effect of tables of data
Rate is low.
For the low problem of the efficiency of prior art inquiry tables of data, effective solution is not yet proposed at present.
The content of the invention
The embodiment of the present application provides the querying method and device of a kind of tables of data, at least to solve prior art inquiry number
According to the low technical problem of the efficiency of table.
According to the one side of the embodiment of the present application, there is provided a kind of querying method of tables of data, the querying method includes：
The filter condition carried in inquiry request is obtained, wherein, filter condition is used to indicate to obtain the mesh in the absence of other entities
Mark entity information；Based on filter condition, other entities and the corresponding multiple tables of data of target entity are obtained；Obtain multiple
The table relation of tables of data, wherein, record has the link field of each tables of data in table relation；Using link field, press
According to the predetermined connected mode result for being connected, obtaining inquiry request counter to multiple tables of data.
Further, using link field, multiple tables of data are carried out with anti-connection according to predetermined connected mode includes：Profit
With link field, according to left connected mode, connected multiple tables of data are counter.
Further, according to left connected mode, connected multiple tables of data are counter, obtained the result bag of inquiry request
Include：Using the corresponding table of target entity as left-handed watch, using the corresponding table of other entities as right table；From right table, obtain
The property value of the link field first information inconsistent with the property value of link field in left-handed watch；The for being recorded in left-handed watch
Two information and the first information as inquiry request result.
Further, target entity and other entities are the object for having achievement data, and object includes one of the following：Order,
Session, event and page browsing information.
Further, link field has corresponding relation with the attribute information of target entity.
According to the another aspect of the embodiment of the present application, a kind of inquiry unit of tables of data is additionally provided, the inquiry unit bag
Include：First acquisition module, for obtaining the filter condition carried in inquiry request, wherein, filter condition is used to indicate
Obtain the target entity information in the absence of other entities；Second acquisition module, for based on filter condition, obtaining other
Entity and the corresponding multiple tables of data of target entity；3rd acquisition module, the table relation for obtaining multiple tables of data,
Wherein, record has the link field of each tables of data in table relation；Processing module, for utilizing link field, according to
The predetermined connected mode result for being connected, obtaining inquiry request counter to multiple tables of data.
Further, processing module includes：Connection submodule, for utilizing link field, according to left connected mode,
Connected multiple tables of data are counter.
Further, connection submodule includes：First treatment submodule, for using the corresponding table of target entity an as left side
Table, using the corresponding table of other entities as right table；Acquisition submodule, for from right table, obtaining the category of link field
Property value and left-handed watch in link field the inconsistent first information of property value；Second processing submodule, for by left-handed watch
Record the second information and the first information as inquiry request result.
Further, target entity and other entities are the object for having achievement data, and object includes one of the following：Order,
Session, event and page browsing information.
Further, link field has corresponding relation with the attribute information of target entity.
In the embodiment of the present application, based on the inquiry request for obtaining the target entity information in the absence of other entities, utilize
The link field of other entities and the corresponding multiple tables of data of target entity, is connected multiple tables of data are counter, is obtained
In the absence of the Query Result of the target entity information of other entities.By above-described embodiment, carrying out in the absence of other realities
During the inquiry of the target entity information of body, the tables of data of tables of data and target entity to other entities is counter to be connected,
So that without judging one by one each data in each table, the mesh that can be obtained in the absence of other entities is connected by table
Mark entity information, realizes the batch query to tables of data, improves the execution speed of inquiry tables of data, solves existing
The low problem of efficiency of technology inquiry tables of data, improves the efficiency of inquiry tables of data.
Brief description of the drawings
Accompanying drawing described herein is used for providing further understanding of the present application, constitutes the part of the application, this Shen
Schematic description and description please does not constitute the improper restriction to the application for explaining the application.In accompanying drawing
In：
Fig. 1 is a kind of flow chart of the querying method of the tables of data according to the embodiment of the present application；
Fig. 2 is a kind of schematic diagram of the inquiry unit of the tables of data according to the embodiment of the present application.
Specific embodiment
In order that those skilled in the art more fully understand application scheme, below in conjunction with the embodiment of the present application
Accompanying drawing, is clearly and completely described to the technical scheme in the embodiment of the present application, it is clear that described embodiment
The only embodiment of the application part, rather than whole embodiments.Based on the embodiment in the application, ability
The every other embodiment that domain those of ordinary skill is obtained under the premise of creative work is not made, should all belong to
The scope of the application protection.
It should be noted that term " first ", " in the description and claims of this application and above-mentioned accompanying drawing
Two " it is etc. for distinguishing similar object, without for describing specific order or precedence.It should be appreciated that this
The data that sample is used can be exchanged in the appropriate case, so as to embodiments herein described herein can with except
Here the order beyond those for illustrating or describing is implemented.Additionally, term " comprising " and " having " and they
Any deformation, it is intended that covering is non-exclusive to be included, for example, containing process, the side of series of steps or unit
Method, system, product or equipment are not necessarily limited to those steps clearly listed or unit, but may include unclear
List or for these processes, method, product or other intrinsic steps of equipment or unit.
Embodiment 1
According to the embodiment of the present application, there is provided a kind of embodiment of the querying method of tables of data, it is necessary to explanation,
The step of flow of accompanying drawing is illustrated can perform in the such as one group computer system of computer executable instructions, and
And, although logical order is shown in flow charts, but in some cases, can be with different from order herein
Perform shown or described step.
Fig. 1 is a kind of flow chart of the querying method of the tables of data according to the embodiment of the present application, as shown in figure 1, this is looked into
Inquiry method comprises the following steps：
Step S102, obtains the filter condition carried in inquiry request, wherein, filter condition is used to indicate to obtain not deposit
In the target entity information of other entities.
Step S104, based on filter condition, obtains other entities and the corresponding multiple tables of data of target entity.
Step S106, obtains the table relation of multiple tables of data, wherein, record has the connection of each tables of data in table relation
Field.
Step S108, using link field, is connected according to predetermined connected mode is counter to multiple tables of data, is looked into
Ask the result of request.
Using the embodiment of the present application, based on the inquiry request for obtaining the target entity information in the absence of other entities, utilize
The link field of other entities and the corresponding multiple tables of data of target entity, is connected multiple tables of data are counter, is obtained
In the absence of the Query Result of the target entity information of other entities.By above-described embodiment, carrying out in the absence of other realities
During the inquiry of the target entity information of body, the tables of data of tables of data and target entity to other entities is counter to be connected,
So that without judging one by one each data in each table, the mesh that can be obtained in the absence of other entities is connected by table
Mark entity information, realizes the batch query to tables of data, improves the execution speed of inquiry tables of data, solves existing
The low problem of efficiency of technology inquiry tables of data, improves the efficiency of inquiry tables of data.
When inquiry request does not exist the session (i.e. above-mentioned target entity) of event (other i.e. above-mentioned entities) to obtain
When, event table corresponding with event, and conversational list corresponding with session are obtained first, then analyze event table and meeting
The table relation of table is talked about, the link field between event table and conversational list in table relation is obtained, finally will using link field
Event table and conversational list carry out table association, in this application, that is, being connected event table and conversational list are counter, obtain
To table association results, the result is the Query Result of the session in the absence of event for obtaining.
Wherein, table association can be carried out by link field between above-mentioned multiple tables of data, link field can be multiple
The same alike result field of tables of data.For example, above-mentioned event table and conversational list, it is possible to use session identification (Session ID)
As link field, two tables are associated by the session identification of user.
Alternatively, using link field, multiple tables of data are carried out with anti-connection according to predetermined connected mode includes：Utilize
Link field, according to left connected mode, is connected multiple tables of data are counter.Anti- connection can be left disconnected.
By above-described embodiment, due to link field can be utilized, according to left connected mode, multiple tables of data are carried out
Anti- connection, the result of anti-connection is the Query Result of the target entity information in the absence of other entities, this kind of issuer
Formula realizes the batch query to tables of data, shortens the query time to tables of data, enormously simplify traditional logarithm
The process inquired about one by one according to table.
In above-described embodiment of the application, target entity and other entities are the object for having achievement data, and object includes
One of the following：Order, session, event and page browsing information.
Alternatively, target entity can be session, it is corresponding with session to have conversational list, in conversational list at least including it is following extremely
One of few achievement data：The session identification of user, user's pet name and user basic information；Other entities can be page
Face browses information, with page browsing information to that should have page browsing information table, in page browsing information table at least include with
At least one lower achievement data：Number of page views, page browsing address and page browsing duration.
Further, according to left connected mode, connected multiple tables of data are counter, obtained the result bag of inquiry request
Include：Using the corresponding table of target entity as left-handed watch, using the corresponding table of other entities as right table；From right table, obtain
The property value of the link field first information inconsistent with the property value of link field in left-handed watch；The for being recorded in left-handed watch
Two information and the first information as inquiry request result.
Specifically, table association is carried out by the way of Left Anti Join, table is (i.e. above-mentioned for the fact that by required filtering
The corresponding table of target entity) used as left-handed watch, table is used as right table (other i.e. above-mentioned entities for the fact that will participate in filtering
Corresponding table), using the link field in table relation, left-handed watch and right table are carried out into table association, the result after table association,
Do not exist the Query Result of the target entity of other entities.Using this kind of connected mode, i.e., using left-handed watch as benchmark,
Obtain in right table with left-handed watch in link field the inconsistent information (the i.e. above-mentioned first information) of property value, that is, filter
Fall consistent with the property value of the link field in left-handed watch information in right table, recorded in the first information for obtaining and left-handed watch
All information are the result of inquiry request.
Below by taking Tables 1 and 2 as an example in detail, above-described embodiment of the application is described in detail.As shown in table 1, ID represents table 1
Address information, Num represents number designation；As shown in table 2, ID represents the address information of table 2, and Name represents number
Word title.
Table 1
| ID | Num |
| 1 | 20050111 |
| 2 | 20050112 |
| 3 | 20050113 |
| 4 | 20050114 |
| 5 | 20050115 |
Table 2
| ID | Name |
| 1 | 2006032401 |
| 2 | 2006032402 |
| 3 | 2006032403 |
| 4 | 2006032404 |
| 8 | 2006032405 |
Table 3
| ID | Num | ID | Name |
| 1 | 20050111 | Null | Null |
| 2 | 20050112 | Null | Null |
| 3 | 20050113 | Null | Null |
| 4 | 20050114 | Null | Null |
| 5 | 20050115 | 8 | 2006032405 |
Tables 1 and 2 is analyzed and is understood, two link fields of table are ID.Using above-mentioned Left Anti Join
Connected mode carries out table association to Tables 1 and 2, if the fact that table 1 is filtered for required for table, table 2 is filtered for participation
The fact table, then using table 1 as left-handed watch, using table 2 as right table.Using link field ID, Tables 1 and 2 is pressed
Table association is carried out according to Left Anti Join modes, as shown in table 3, table 3 is included in table 1 the table association results for obtaining
All information and the information different from the attribute information of ID in table 1 of record, it is corresponding that these information are inquiry request
Query Result, wherein, inquiry request is in the absence of the Num with the attribute information identical information of the ID of Name.
By above-described embodiment, it is possible to use Left Anti Join connected modes, the table association of multiple tables of data is realized,
During table is associated, the batch query to multiple tables of data is realized, reduces the number of times of system queries tables of data,
So as to improve the efficiency of tables of data inquiry.
In above-described embodiment of the application, link field has corresponding relation with the attribute information of target entity.
Specifically, the filter condition for being carried in based on inquiry request is obtained after multiple tables of data, multiple by analyzing
The table relation of tables of data, obtains the link field of each tables of data of record in table relation.Due to each tables of data be with
The corresponding tables of data of entity, therefore the link field of each tables of data has corresponding closing with corresponding entity attributes information
System.Tables 1 and 2 as escribed above, ID is two link fields of table, and table 1 is data corresponding with target entity
Table, the Num in table 1 represents the attribute information of the target entity, as shown in Table 1, in table the attribute information of ID with
Num correspondences in table, each ID value one Num value of correspondence.
It should be noted that table 2 is tables of data corresponding with other entities, the Name in table 2 represents other realities
The attribute information of body, as shown in Table 2, the attribute information of ID is corresponding with the Name in table in table, and each ID value is right
Answer a Name value.
Tables 1 and 2 it is merely exemplary give two tables of data, the tables of data in the application is not limited thereto, on
The querying method of the tables of data stated can apply in the inquiry of various tables of data of actual data processing field.
In a kind of optional embodiment, when inquiry request does not exist event (other i.e. above-mentioned entities) to obtain
During session (i.e. above-mentioned target entity), event table corresponding with event, and meeting corresponding with session are obtained first
Words table；Then the table relation of analysis event table and conversational list, obtains the connection between event table and conversational list in table relation
Field (i.e. above-mentioned session identification)；Finally use Left Anti Join connected modes, it will words table as left-handed watch, i.e.,
The fact that conversational list is filtered for required for table, is the fact that participate in filtering table using event table as right table, i.e. event table,
Event table and conversational list are carried out into table association using two link fields of table.Specifically, using conversational list as benchmark,
Obtain in event table with conversational list in link field the inconsistent first information of property value, filter out in event table with
The consistent information of the property value of the link field in conversational list, remembers in the first information in the event table for obtaining and conversational list
All information of record are the Query Result of the session in the absence of event.
Embodiment 2
According to the another aspect of the application, a kind of embodiment of the inquiry unit of tables of data is additionally provided.
Fig. 2 is a kind of schematic diagram of the inquiry unit of the tables of data according to the embodiment of the present application, as shown in Fig. 2 this is looked into
Asking device can include：First acquisition module 20, the second acquisition module 40, the 3rd acquisition module 60 and processing module
80。
Wherein, the first acquisition module 20, for obtaining the filter condition carried in inquiry request, wherein, filter condition
For indicating to obtain the target entity information in the absence of other entities.
Second acquisition module 40, for based on filter condition, obtaining other entities and the corresponding multiple data of target entity
Table.
3rd acquisition module 60, the table relation for obtaining multiple tables of data, wherein, record has each number in table relation
According to the link field of table.
Processing module 80, for utilizing link field, is connected according to predetermined connected mode is counter to multiple tables of data,
Obtain the result of inquiry request.
Using the embodiment of the present application, based on the inquiry request for obtaining the target entity information in the absence of other entities, utilize
The link field of other entities and the corresponding multiple tables of data of target entity, is connected multiple tables of data are counter, is obtained
In the absence of the Query Result of the target entity information of other entities.By above-described embodiment, carrying out in the absence of other realities
During the inquiry of the target entity information of body, the tables of data of tables of data and target entity to other entities is counter to be connected,
So that without judging one by one each data in each table, the mesh that can be obtained in the absence of other entities is connected by table
Mark entity information, realizes the batch query to tables of data, improves the execution speed of inquiry tables of data, solves existing
The low problem of efficiency of technology inquiry tables of data, improves the efficiency of inquiry tables of data.
When inquiry request does not exist the session (i.e. above-mentioned target entity) of event (other i.e. above-mentioned entities) to obtain
When, event table corresponding with event, and conversational list corresponding with session are obtained first, then analyze event table and meeting
The table relation of table is talked about, the link field between event table and conversational list in table relation is obtained, finally will using link field
Event table and conversational list carry out table association, in this application, that is, being connected event table and conversational list are counter, obtain
To table association results, the result is the Query Result of the session in the absence of event for obtaining.
Wherein, table association can be carried out by link field between above-mentioned multiple tables of data, link field can be multiple
The same alike result field of tables of data.For example, above-mentioned event table and conversational list, it is possible to use session identification (Session ID)
As link field, two tables are associated by the session identification of user.
Alternatively, processing module includes：Connection submodule, for utilizing link field, according to left connected mode, will
Multiple tables of data are counter to be connected.
By above-described embodiment, due to link field can be utilized, according to left connected mode, multiple tables of data are carried out
Anti- connection, the result of anti-connection is the Query Result of the target entity information in the absence of other entities, this kind of issuer
Formula realizes the batch query to tables of data, shortens the query time to tables of data, enormously simplify traditional logarithm
The process inquired about one by one according to table.
Further, connection submodule includes：First treatment submodule, for using the corresponding table of target entity an as left side
Table, using the corresponding table of other entities as right table；Acquisition submodule, for from right table, obtaining the category of link field
Property value and left-handed watch in link field the inconsistent first information of property value；Second processing submodule, for by left-handed watch
Record the second information and the first information as inquiry request result.
Specifically, table association is carried out by the way of Left Anti Join, table is (i.e. above-mentioned for the fact that by required filtering
The corresponding table of target entity) used as left-handed watch, table is used as right table (other i.e. above-mentioned entities for the fact that will participate in filtering
Corresponding table), using the link field in table relation, left-handed watch and right table are carried out into table association, the result after table association,
Do not exist the Query Result of the target entity of other entities.Using this kind of connected mode, i.e., using left-handed watch as benchmark,
Obtain in right table with left-handed watch in link field the inconsistent information (the i.e. above-mentioned first information) of property value, that is, filter
Fall consistent with the property value of the link field in left-handed watch information in right table, recorded in the first information for obtaining and left-handed watch
All information are the result of inquiry request.
By above-described embodiment, it is possible to use Left Anti Join connected modes, the table association of multiple tables of data is realized,
During table is associated, the batch query to multiple tables of data is realized, reduces the number of times of system queries tables of data,
So as to improve the efficiency of tables of data inquiry.
In above-described embodiment of the application, target entity and other entities are the object for having achievement data, and object includes
One of the following：Order, session, event and page browsing information.
Alternatively, target entity can be session, it is corresponding with session to have conversational list, in conversational list at least including it is following extremely
One of few achievement data：The session identification of user, user's pet name and user basic information；Other entities can be page
Face browses information, with page browsing information to that should have page browsing information table, in page browsing information table at least include with
At least one lower achievement data：Number of page views, page browsing address and page browsing duration.
In above-described embodiment of the application, link field has corresponding relation with the attribute information of target entity.
Specifically, the filter condition for being carried in based on inquiry request is obtained after multiple tables of data, multiple by analyzing
The table relation of tables of data, obtains the link field of each tables of data of record in table relation.Due to each tables of data be with
The corresponding tables of data of entity, therefore the link field of each tables of data has corresponding closing with corresponding entity attributes information
System.Tables 1 and 2 as escribed above, ID is two link fields of table, and table 1 is data corresponding with target entity
Table, the Num in table 1 represents the attribute information of the target entity, as shown in Table 1, in table the attribute information of ID with
Num correspondences in table, each ID value one Num value of correspondence.
It should be noted that table 2 is tables of data corresponding with other entities, the Name in table 2 represents other realities
The attribute information of body, as shown in Table 2, the attribute information of ID is corresponding with the Name in table in table, and each ID value is right
Answer a Name value.
Tables 1 and 2 it is merely exemplary give two tables of data, the tables of data in the application is not limited thereto, on
The querying method of the tables of data stated can apply in the inquiry of various tables of data of actual data processing field.
In a kind of optional embodiment, when inquiry request does not exist event (other i.e. above-mentioned entities) to obtain
During session (i.e. above-mentioned target entity), event table corresponding with event, and meeting corresponding with session are obtained first
Words table；Then the table relation of analysis event table and conversational list, obtains the connection between event table and conversational list in table relation
Field (i.e. above-mentioned session identification)；Finally use Left Anti Join connected modes, it will words table as left-handed watch, i.e.,
The fact that conversational list is filtered for required for table, is the fact that participate in filtering table using event table as right table, i.e. event table,
Event table and conversational list are carried out into table association using two link fields of table.Specifically, using conversational list as benchmark,
Obtain in event table with conversational list in link field the inconsistent first information of property value, filter out in event table with
The consistent information of the property value of the link field in conversational list, remembers in the first information in the event table for obtaining and conversational list
All information of record are the Query Result of the session in the absence of event.
The inquiry unit of above-mentioned tables of data include processor and memory, above-mentioned first acquisition module, the second acquisition module,
3rd acquisition module and processing module etc. in memory, are being deposited as program unit storage by computing device storage
Said procedure unit in reservoir.The result of above-mentioned filter condition, tables of data and inquiry request may be stored in depositing
In reservoir.
Kernel is included in processor, is gone in memory to transfer corresponding program unit by kernel.Kernel can set one
Or more, parse content of text by adjusting kernel parameter.
Memory potentially includes the volatile memory in computer-readable medium, random access memory (RAM) and/
Or the form, such as read-only storage (ROM) or flash memory (flash RAM) such as Nonvolatile memory, memory includes at least one
Individual storage chip.
Present invention also provides a kind of embodiment of computer program product, when being performed on data processing equipment, fit
In the program code for performing initialization there are as below methods step：The filter condition carried in inquiry request is obtained, wherein,
Filter condition is used to indicate to obtain the target entity information in the absence of other entities；Based on filter condition, other realities are obtained
Body and the corresponding multiple tables of data of target entity；The table relation of multiple tables of data is obtained, wherein, there be record in table relation
The link field of each tables of data；Using link field, connected according to predetermined connected mode is counter to multiple tables of data,
Obtain the result of inquiry request.
Above-mentioned the embodiment of the present application sequence number is for illustration only, and the quality of embodiment is not represented.
In above-described embodiment of the application, the description to each embodiment all emphasizes particularly on different fields, and does not have in certain embodiment
The part of detailed description, may refer to the associated description of other embodiment.
In several embodiments provided herein, it should be understood that disclosed technology contents, can be by other
Mode realize.Wherein, device embodiment described above is only schematical, such as division of described unit,
Can be a kind of division of logic function, there can be other dividing mode when actually realizing, for example multiple units or component
Can combine or be desirably integrated into another system, or some features can be ignored, or do not perform.It is another, institute
Display or the coupling each other for discussing or direct-coupling or communication connection can be by some interfaces, unit or mould
The INDIRECT COUPLING of block or communication connection, can be electrical or other forms.
The unit that is illustrated as separating component can be or may not be it is physically separate, it is aobvious as unit
The part for showing can be or may not be physical location, you can with positioned at a place, or can also be distributed to
On multiple units.Some or all of unit therein can be according to the actual needs selected to realize this embodiment scheme
Purpose.
In addition, during each functional unit in the application each embodiment can be integrated in a processing unit, it is also possible to
It is that unit is individually physically present, it is also possible to which two or more units are integrated in a unit.It is above-mentioned integrated
Unit can both be realized in the form of hardware, it would however also be possible to employ the form of SFU software functional unit is realized.
If the integrated unit is to realize in the form of SFU software functional unit and as independent production marketing or use
When, can store in a computer read/write memory medium.Based on such understanding, the technical scheme of the application
The part for substantially being contributed to prior art in other words or all or part of the technical scheme can be produced with software
The form of product is embodied, and the computer software product is stored in a storage medium, including some instructions are used to make
Obtain a computer equipment (can be personal computer, server or network equipment etc.) and perform each implementation of the application
The all or part of step of example methods described.And foregoing storage medium includes：USB flash disk, read-only storage (ROM,
Read-Only Memory), random access memory (RAM, Random Access Memory), mobile hard disk,
Magnetic disc or CD etc. are various can be with the medium of store program codes.
The above is only the preferred embodiment of the application, it is noted that for the ordinary skill people of the art
For member, on the premise of the application principle is not departed from, some improvements and modifications can also be made, these improve and moisten
Decorations also should be regarded as the protection domain of the application.
Claims (10)
1. a kind of querying method of tables of data, it is characterised in that including：
The filter condition carried in inquiry request is obtained, wherein, the filter condition is used to indicate acquisition not exist
The target entity information of other entities；
Based on the filter condition, described other entities and the corresponding multiple tables of data of the target entity are obtained；
The table relation of the multiple tables of data is obtained, wherein, record has the company of each tables of data in the table relation
Connect field；
Using the link field, connected according to predetermined connected mode is counter to the multiple tables of data, obtained
The result of the inquiry request.
2. querying method according to claim 1, it is characterised in that the link field is utilized, according to predetermined company
Connecing mode and the multiple tables of data is carried out instead to connect includes：
Using the link field, according to left connected mode, connected the multiple tables of data is counter.
3. querying method according to claim 2, it is characterised in that according to left connected mode, by the multiple number
Connected according to table is counter, the result for obtaining the inquiry request includes：
Using the corresponding table of the target entity as left-handed watch, by the corresponding table of other entities as right table；
From the right table, the property value of the link field and the property value of link field in the left-handed watch are obtained
The inconsistent first information；
Will in the left-handed watch record the second information and the first information as the inquiry request result.
4. querying method as claimed in any of claims 1 to 3, it is characterised in that the target entity and
Described other entities are the object for having achievement data, and the object includes one of the following：Order, session, event
And page browsing information.
5. querying method as claimed in any of claims 1 to 3, it is characterised in that the link field with
The attribute information of the target entity has corresponding relation.
6. a kind of inquiry unit of tables of data, it is characterised in that including：
First acquisition module, for obtaining the filter condition carried in inquiry request, wherein, the filter condition
For indicating to obtain the target entity information in the absence of other entities；
Second acquisition module, for based on the filter condition, obtaining described other entities and the target entity
Corresponding multiple tables of data；
3rd acquisition module, the table relation for obtaining the multiple tables of data, wherein, remember in the table relation
Record has the link field of each tables of data；
Processing module, for utilizing the link field, enters according to predetermined connected mode to the multiple tables of data
The anti-connection of row, obtains the result of the inquiry request.
7. inquiry unit according to claim 6, it is characterised in that the processing module includes：
Connection submodule, for utilizing the link field, according to left connected mode, by the multiple tables of data
It is counter to be connected.
8. inquiry unit according to claim 7, it is characterised in that the connection submodule includes：
First treatment submodule, for using the corresponding table of the target entity as left-handed watch, by described other entities
Corresponding table is used as right table；
Acquisition submodule, for from the right table, in obtaining the property value of the link field and the left-handed watch
The inconsistent first information of the property value of link field；
Second processing submodule, for the second information and the first information that will be recorded in the left-handed watch as institute
State the result of inquiry request.
9. the inquiry unit according to any one in claim 6 to 8, it is characterised in that the target entity and
Described other entities are the object for having achievement data, and the object includes one of the following：Order, session, event
And page browsing information.
10. the inquiry unit according to any one in claim 6 to 8, it is characterised in that the link field with
The attribute information of the target entity has corresponding relation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201511032612.XA CN106933918A (en) | 2015-12-31 | 2015-12-31 | The querying method and device of tables of data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201511032612.XA CN106933918A (en) | 2015-12-31 | 2015-12-31 | The querying method and device of tables of data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106933918A true CN106933918A (en) | 2017-07-07 |
Family
ID=59444861
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201511032612.XA Pending CN106933918A (en) | 2015-12-31 | 2015-12-31 | The querying method and device of tables of data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106933918A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108038135A (en) * | 2017-11-21 | 2018-05-15 | 平安科技（深圳）有限公司 | Electronic device, the method for multilist correlation inquiry and storage medium |
| CN109948034A (en) * | 2017-09-27 | 2019-06-28 | 北京国双科技有限公司 | The method and device for extracting page info is realized based on filtering conversation |
| CN110019559A (en) * | 2017-12-27 | 2019-07-16 | 航天信息股份有限公司 | A kind of data query method and system |
| CN111046039A (en) * | 2019-11-25 | 2020-04-21 | 金蝶软件（中国）有限公司 | Document query method and related device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101770479A (en) * | 2008-12-31 | 2010-07-07 | 北京亿阳信通软件研究院有限公司 | Association relationship query method and device |
| CN102567329A (en) * | 2010-12-15 | 2012-07-11 | 金蝶软件（中国）有限公司 | Data query method and data query system |
| CN102819545A (en) * | 2011-12-22 | 2012-12-12 | 金蝶软件（中国）有限公司 | Bill inquiring method and device based on general filtering condition compound assembly |
-
2015
- 2015-12-31 CN CN201511032612.XA patent/CN106933918A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101770479A (en) * | 2008-12-31 | 2010-07-07 | 北京亿阳信通软件研究院有限公司 | Association relationship query method and device |
| CN102567329A (en) * | 2010-12-15 | 2012-07-11 | 金蝶软件（中国）有限公司 | Data query method and data query system |
| CN102819545A (en) * | 2011-12-22 | 2012-12-12 | 金蝶软件（中国）有限公司 | Bill inquiring method and device based on general filtering condition compound assembly |
Non-Patent Citations (2)
| Title |
|---|
| 崔华: "《基于Oracle的SQL优化》", 31 January 2014, 电子工业出版社 * |
| 无: ""SQL Join的一些总结(实例)"", 《HTTPS://WWW.JB51.NET/ARTICLE/30972.HTM》 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109948034A (en) * | 2017-09-27 | 2019-06-28 | 北京国双科技有限公司 | The method and device for extracting page info is realized based on filtering conversation |
| CN109948034B (en) * | 2017-09-27 | 2022-03-18 | 北京国双科技有限公司 | Method and device for extracting page information based on filtering session |
| CN108038135A (en) * | 2017-11-21 | 2018-05-15 | 平安科技（深圳）有限公司 | Electronic device, the method for multilist correlation inquiry and storage medium |
| CN110019559A (en) * | 2017-12-27 | 2019-07-16 | 航天信息股份有限公司 | A kind of data query method and system |
| CN111046039A (en) * | 2019-11-25 | 2020-04-21 | 金蝶软件（中国）有限公司 | Document query method and related device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106557498A (en) | Date storage method and device and data query method and apparatus | |
| CN106708841B (en) | The polymerization and device of website visitation path | |
| CN108320213A (en) | Electric business Method of Commodity Recommendation and electric business Platform Server | |
| US20180246955A1 (en) | Method and device for searching legal provision | |
| CN108427695A (en) | Method and application server are recommended by enterprise | |
| CN106933918A (en) | The querying method and device of tables of data | |
| CN107040397A (en) | A kind of service parameter acquisition methods and device | |
| CN107798102A (en) | A kind of page display method and device | |
| CN107729330B (en) | Method and apparatus for acquiring data set | |
| CN107784070A (en) | A kind of method, apparatus and equipment for improving data cleansing efficiency | |
| CN106933935A (en) | task storage method and device | |
| CN106933914A (en) | The data processing method and device of many tables of data | |
| CN107391506A (en) | Method and apparatus for inquiring about data | |
| CN106933897A (en) | Data query method and apparatus | |
| CN108153719A (en) | Merge the method and apparatus of electrical form | |
| CN107832444A (en) | Event based on search daily record finds method and device | |
| CN106933927A (en) | The connection method of tables of data and device | |
| CN106919609A (en) | Product information method for pushing and device | |
| CN107273388A (en) | The treating method and apparatus and querying method and device of trial video | |
| CN112256844B (en) | Text classification method and device | |
| CN106933904A (en) | The filter method and device of data | |
| CN104408188B (en) | Data processing method and device | |
| CN108053275A (en) | A kind of online product screening method, system and storage medium | |
| CN106933920A (en) | The screening technique and device of session | |
| CN107767010A (en) | Range value data statistical method, electronic installation and computer-readable recording 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 | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 100083 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Applicant after: Beijing Guoshuang Technology Co.,Ltd. Address before: 100086 Cuigong Hotel, 76 Zhichun Road, Shuangyushu District, Haidian District, Beijing Applicant before: Beijing Guoshuang Technology Co.,Ltd. |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170707 |