CN103714070B - Data query method and system - Google Patents
Data query method and system Download PDFInfo
- Publication number
- CN103714070B CN103714070B CN201210375159.2A CN201210375159A CN103714070B CN 103714070 B CN103714070 B CN 103714070B CN 201210375159 A CN201210375159 A CN 201210375159A CN 103714070 B CN103714070 B CN 103714070B
- Authority
- CN
- China
- Prior art keywords
- data
- tables
- row
- data row
- mark
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
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/248—Presentation of query results
-
- 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/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A kind of data query method, comprises the following steps：Obtain to the inquiry request for the data row chosen from the first tables of data or the second tables of data, first tables of data is connected with the second tables of data to be illustrated in same operation interface；The data row that corresponding relation be present with the data row is searched from the first tables of data and the second tables of data according to the inquiry request, by the data row chosen and the data traveling line flag found.In addition, additionally provide a kind of data query system.Above-mentioned data query method and system, by showing the first tables of data and the second tables of data in same operation interface, and the data row of corresponding relation from the first tables of data and the second data table search and the data row chosen according to the data row chosen be present, aforesaid operations are carried out on the client, the data for frequently going whois lookup related are not required to, the burden of server is alleviated, is not required to frequently switch interface, operation is simplified, improves operating efficiency.
Description
Technical field
The present invention relates to information inquiry field, more particularly to a kind of data query method and system.
Background technology
The species of data is a lot, certain relevance between some data be present, i.e., certain be present between data and data
Relation.Such as exist between reconciliation data and journal account data and hook to relation, i.e., both should mutually correspond to, without difference.It is logical
In the case of often, reconciliation data and journal account data are to separate displaying, and non-reconciliation data and reconciliation data are also divided among
Different form displayings, shows even if some are put in same form, is also simply distinguished according to mark.
In order to inquire about journal account data with the hook of reconciliation data to relation, database can only be re-read by filter condition
Inquired about, for one-to-many, the reconciliation situation of many-one and multi-to-multi need by frequently set filter condition come
To Query Result, frequently inquired about this, can constantly go server to read data, increase the burden of server, and because
Reconciliation data and journal account data are shown on different interfaces, it is necessary to frequently switch interface, cumbersome.
The content of the invention
Based on this, it is necessary to which server burden can be mitigated and can simplify operation by providing one kind, improve the data of operating efficiency
Querying method.
It can mitigate server burden in addition, there is a need to and provide one kind and simplify operation, the data for improving operating efficiency are looked into
Inquiry system.
A kind of data query method, comprises the following steps：
Obtain to the inquiry request for the data row chosen from the first tables of data or the second tables of data, first tables of data and
Second tables of data, which is connected, to be illustrated in same operation interface；
Searched according to the inquiry request from the first tables of data and the second tables of data and corresponding close be present with the data row
The data row of system, by the data row chosen and the data traveling line flag found.
In one of the embodiments, it is described to be searched according to the inquiry request from the first tables of data and the second tables of data
The data row of corresponding relation with the data row be present, and by the data traveling line flag chosen data row and found
Step includes：
If the data that the data row chosen in the first tables of data, is chosen according to obtaining the inquiry request
The mark of data row in second tables of data of the presence corresponding relation recorded in capable hiding field；
According to the mark location of data row in second tables of data into the second tables of data corresponding data row, and mark
Corresponding data row in the data row chosen in first tables of data and the second tables of data；
Obtain the first data of the presence corresponding relation recorded in the second tables of data in the hiding field of corresponding data row
The mark of data row in table；
According to the mark location of data row in first tables of data into the first tables of data corresponding data row, and mark
Corresponding data row in corresponding data row and the first tables of data in second tables of data.
In one of the embodiments, it is described to be searched according to the inquiry request from the first tables of data and the second tables of data
The data row of corresponding relation with the data row be present, and by the data traveling line flag chosen data row and found
Step includes：
If the data that the data row chosen in the second tables of data, is chosen according to obtaining the inquiry request
The mark of data row in first tables of data of the presence corresponding relation recorded in capable hiding field；
According to the mark location of data row in first tables of data into the first tables of data corresponding data row, and mark
Corresponding data row in the data row chosen in second tables of data and the first tables of data；
Obtain the second data of the presence corresponding relation recorded in the first tables of data in the hiding field of corresponding data row
The mark of data row in table；
According to the mark location of data row in second tables of data into the second tables of data corresponding data row, and mark
Corresponding data row in corresponding data row and the second tables of data in first tables of data.
In one of the embodiments, obtaining to the inquiry for the data row chosen from the first tables of data or the second tables of data
Before the step of request, in addition to step：
One fulcrum is set in the operation interface, and coordinate system is established with the fulcrum, fixes the coordinate of the fulcrum,
First tables of data is connected with the second tables of data by the fulcrum to be illustrated in the operation interface；
It is described by it is described choose data row with find data traveling line flag the step of include：
Obtain the predetermined point coordinates for the data row chosen the predetermined point coordinates of data row and found；
Two predetermined points are connected by fulcrum using marking.
In one of the embodiments, obtained described to the data row chosen from the first tables of data or the second tables of data
Before the step of inquiry request, in addition to step：
Obtain the request that corresponding relation is established to data row in data row in the first tables of data and the second tables of data；
Corresponding relation is established to data row in the first tables of data and the second tables of data according to preparatory condition according to the request；
In the hiding field of data row there is the second number of corresponding relation with the data row in record in the first tables of data
According to the mark of data row in table, in the hiding field of data row there is corresponding close in record with the data row in the second tables of data
The mark of data row in first tables of data of system.
A kind of data query system, including：
Acquisition module, for obtaining to the inquiry request for the data row chosen from the first tables of data or the second tables of data, institute
State the first tables of data and be connected with the second tables of data and be illustrated in same operation interface；
Searching modul, for being searched according to the inquiry request from the first tables of data and the second tables of data and the data
The data row of corresponding relation be present in row；
Mark module, for by the data traveling line flag chosen data row and found.
In one of the embodiments, if the data row chosen is in the first tables of data, the acquisition module is also used
Second number of the presence corresponding relation recorded in the hiding field for the data row chosen described in being obtained according to the inquiry request
According to the mark of the data row in table；
The searching modul is additionally operable to the mark location according to data row in second tables of data into the second tables of data
Corresponding data row；
The mark module is additionally operable to corresponding number in the data row chosen in the tables of data of mark first and the second tables of data
According to row；
The acquisition module is additionally operable to obtain the presence recorded in the hiding field of corresponding data row in the second tables of data
The mark of data row in first tables of data of corresponding relation；
The searching modul is additionally operable to the mark location according to data row in first tables of data into the first tables of data
Corresponding data row；
The mark module is additionally operable in the tables of data of mark second corresponding number in corresponding data row and the first tables of data
According to row.
In one of the embodiments, if the data row chosen is in the second tables of data, the acquisition module is also used
First number of the presence corresponding relation recorded in the hiding field for the data row chosen described in being obtained according to the inquiry request
According to the mark of the data row in table；
The searching modul is additionally operable to the mark location according to data row in first tables of data into the first tables of data
Corresponding data row；
The mark module is additionally operable to corresponding number in the data row chosen in the tables of data of mark second and the first tables of data
According to row；
The acquisition module is additionally operable to obtain the presence recorded in the hiding field of corresponding data row in the first tables of data
The mark of data row in second tables of data of corresponding relation；
The searching modul is additionally operable to the mark location according to data row in second tables of data into the second tables of data
Corresponding data row；
The mark module is additionally operable in the tables of data of mark first corresponding number in corresponding data row and the second tables of data
According to row.
In one of the embodiments, in addition to：
Fulcrum setup module, coordinate system is established for setting a fulcrum in the operation interface, and with the fulcrum, Gu
The coordinate of the fixed fulcrum, first tables of data is connected with the second tables of data by the fulcrum is illustrated in the operation interface
On；
Coordinate obtaining module, for obtaining the predetermined point for the data row chosen the predetermined point coordinates of data row and found
Coordinate；
The mark module is additionally operable to that two predetermined points are connected by fulcrum using marking.
In one of the embodiments, in addition to：
Relationship request acquisition module, data row in data row in the first tables of data and the second tables of data is established for obtaining
The request of corresponding relation；
Relation establishes module, for being asked according to described according to preparatory condition to number in the first tables of data and the second tables of data
Corresponding relation is established according to row；
Memory module, for record in the hiding field of data row in the first tables of data with the data row in the presence of corresponding
The mark of data row in second tables of data of relation, recorded and the data in the hiding field of data row in the second tables of data
The mark of data row in capable the first tables of data that corresponding relation be present.
Above-mentioned data query method and system, by showing the first tables of data and the second data in same operation interface
Table, and corresponding relation is had from the first tables of data and the second data table search and the data row chosen according to the data row chosen
Data row, aforesaid operations are carried out on the client, are not required to the data for frequently going whois lookup related, are alleviated server
Burden, and the first tables of data and the second tables of data are shown on same interface, and operated in the operation interface, are not required to
Frequently switch interface, simplify operation, improve operating efficiency.
Brief description of the drawings
Fig. 1 is the schematic flow sheet of data query method in one embodiment；
To be chosen in one embodiment, data row searches corresponding data row in the first tables of data to Fig. 2 and the flow of mark is shown
It is intended to；
To be chosen in one embodiment, data row searches corresponding data row in the second tables of data to Fig. 3 and the flow of mark is shown
It is intended to；
Fig. 4 establishes the schematic flow sheet of corresponding relation for data row in data row in the first tables of data and the second tables of data；
Fig. 5 is the man-to-man corresponding relation schematic diagram of the data row with predetermined point coordinates；
Fig. 6 is the corresponding relation schematic diagram of data row multi-to-multi；
Fig. 7 is the internal structure schematic diagram of data query system in one embodiment；
Fig. 8 is the internal structure schematic diagram of data query system in another embodiment；
Fig. 9 is the internal structure schematic diagram of data query system in another embodiment.
Embodiment
Detailed retouch is carried out to the technical scheme of data query method and system with reference to specific embodiment and accompanying drawing
State, so that it is clearer.
As shown in figure 1, in one embodiment, a kind of data query method, comprise the following steps：
Step S110, the inquiry request of the data row to being chosen from the first tables of data or the second tables of data is obtained, this first
Tables of data is connected with the second tables of data to be illustrated in same operation interface.
Specifically, setting a fulcrum in operation interface, and coordinate system is established with the fulcrum, fixes the coordinate of the fulcrum,
First tables of data is connected and is illustrated in the operation interface by the fulcrum with the second tables of data.For example, the branch point coordinates for (x,
y).User's data row chosen in the first tables of data or the data chosen in the second tables of data are obtained in operation interface
Inquiry request caused by row triggering.
Step S120, searched and data row presence pair from the first tables of data and the second tables of data according to the inquiry request
The data row that should be related to, this is chosen into data row and the data traveling line flag found.
Specifically, the data row of the presence corresponding relation for the hiding field record for choosing data row is obtained according to inquiry request
Mark, can be searched according to the mark and on data row corresponding to navigating to, then using mark record, such as using the side of line
Formula links up the data row chosen with corresponding data row.
Further, by it is described choose data row with find data traveling line flag the step of include：Acquisition is chosen
The predetermined point coordinates of the predetermined point coordinates of data row and the data row found；Two predetermined points are passed through using marking
Fulcrum is connected.It is directly perceived using marking, and draw simple.
Above-mentioned data query method, by showing the first tables of data and the second tables of data, and root in same operation interface
The data row of corresponding relation from the first tables of data and the second data table search and the data row chosen according to the data row chosen be present,
Aforesaid operations are carried out on the client, are not required to the data for frequently going whois lookup related, alleviate the burden of server,
And the first tables of data and the second tables of data are shown on same interface, and operated in the operation interface, it is not required to frequently
Switch interface, simplify operation, improve operating efficiency.
As shown in Fig. 2 in one embodiment, in above-mentioned data query method, if the data row chosen is in the first number
Corresponding close be present with the data row according in table, then being searched according to the inquiry request from the first tables of data and the second tables of data
The data row of system, and by this choose data row with find data traveling line flag the step of include：
Step S210, the corresponding pass of the presence recorded in the hiding field of the data row chosen is obtained according to the inquiry request
The mark of data row in second tables of data of system.
Specifically, the second number that corresponding relation be present with the data row is have recorded in the hiding field for the data row chosen
According to the mark of the data row in table, the mark refers to the number field of data row in the second tables of data, such as 1001,1002, but
Not limited to this.
Step S220, according to the mark location of data row in second tables of data into the second tables of data corresponding data
OK, and in the tables of data of mark first corresponding data row in the data row chosen and the second tables of data.
Specifically, after data row corresponding to navigating to, the coordinate of the predetermined point for calculating the data row that choose and the can be passed through
The coordinate of the predetermined point of corresponding data row in two tables of data, then two predetermined points are linked together, that is, select by fulcrum
In the predetermined point of data row be wired to fulcrum, the predetermined of corresponding data row in the second tables of data is then wired to by fulcrum
Point.
For the ease of calculating the coordinate of predetermined point, the highly consistent of the first tables of data and the second tables of data is set, placement
Apical position is consistent, it is assumed that is T, the highly consistent of every a line of tables of data is H, and the width per a line is unanimously M, operation interface
The total line number for the tables of data that one screen can be shown is L, and the predetermined point A for the data row chosen coordinate is (X1, Y1), fulcrum B's
Coordinate is (X, Y), and the predetermined point C of the data row of corresponding relation coordinate is (X2, Y2).Predetermined point A coordinate X1To hide word
Columns where segment table lattice, by the line number L where predetermined point A1With 1 and, then again divided by it is total line number L's and 1 and obtain business,
Then ask T with the business's and, obtain Y1 value, i.e. Y1=T+ (L1+1)/(L+1), wherein, it is because gauge outfit line number is 0 to add 1.Together
Sample can determine that C coordinate.Then coordinate line connection is pressed by three.
In addition, can not be when there is the data row in the second tables of data of corresponding relation with the data row in the first tables of data
During same screen display, data row in the second tables of data can be rolled, after finding corresponding data row, redefines the data row
The coordinate of predetermined point.
One-to-many, the corresponding relation of many-one or multi-to-multi be present in the data row in the first tables of data and the second tables of data
, it can be positioned successively according to coordinate calculation.
Step S230, obtain the presence corresponding relation recorded in the second tables of data in the hiding field of corresponding data row
The mark of data row in first tables of data.
Specifically, the data row in the first tables of data of field record is hidden in the second tables of data in corresponding data row
Mark includes the mark for the data row chosen, and may also comprise the mark for other data rows that corresponding relation in the first tables of data be present
Know.For example, the data row L1 chosen in the first tables of data N1 and the second tables of data N2, the first tables of data N1 hiding field is recorded
Data row be identified as N2L2 (second the second data of tables of data row), N2L3 (the data row of the second tables of data the 3rd), second number
The data row recorded according to the hiding field of data row L2 in table N2 is identified as N1L1 (first the first data of tables of data row), N1L3
(the data row of the first tables of data the 3rd) etc..
Step S240, according to the mark location of data row in first tables of data into the first tables of data corresponding data
OK, corresponding data row in corresponding data row and the first tables of data and in the tables of data of mark second.
Specifically, according to above-mentioned coordinate calculation navigate to corresponding to data rows, then marking.
As shown in figure 3, in one embodiment, in above-mentioned data query method, if the data row chosen is second
In tables of data, then searched according to the inquiry request from the first tables of data and the second tables of data with the data row in the presence of corresponding
The data row of relation, and by it is described choose data row with find data traveling line flag the step of include：
Step S310, the presence pair recorded in the hiding field of data row chosen according to obtaining the inquiry request
The mark of data row in the first tables of data that should be related to.
Specifically, after data row corresponding to navigating to, the coordinate of the predetermined point for calculating the data row that choose and the can be passed through
The coordinate of the predetermined point of corresponding data row in one tables of data, then two predetermined points are linked together, that is, select by fulcrum
In the predetermined point of data row be wired to fulcrum, the predetermined of corresponding data row in the first tables of data is then wired to by fulcrum
Point.
Step S320, according to the mark location of data row in first tables of data into the first tables of data corresponding data
OK, and in the tables of data of mark second corresponding data row in the data row chosen and the first tables of data.
Step S330, obtain the presence corresponding relation recorded in the first tables of data in the hiding field of corresponding data row
The mark of data row in second tables of data.
Specifically, the data row in the second tables of data of field record is hidden in the first tables of data in corresponding data row
Mark includes the mark for the data row chosen, and may also comprise the mark for other data rows that corresponding relation in the second tables of data be present
Know.For example, the data row L1 chosen in the first tables of data N1 and the second tables of data N2, the second tables of data N2 hiding field is recorded
Data row be identified as N1L2 (first the second data of tables of data row), N1L3 (the data row of the first tables of data the 3rd), first number
The data row recorded according to the hiding field of data row L2 in table N1 is identified as N2L1 (second the first data of tables of data row), N2L3
(the data row of the second tables of data the 3rd) etc..
Step S340, according to the mark location of data row in second tables of data into the second tables of data corresponding data
OK, corresponding data row in corresponding data row and the second tables of data and in the tables of data of mark first.
Above-mentioned data query method, can be quick by the data line identifier of the corresponding relation of the hiding field record of data row
Corresponding data row is navigated to, improves search efficiency, and the data obtained are on the client, are not required to again frequently from service
Device extracts data, alleviates server burden.
As shown in figure 4, in one embodiment, above-mentioned data query method, obtaining to from the first tables of data or second
Before the step of inquiry request for the data row that tables of data is chosen, in addition to step：
Step S410, obtain and corresponding relation is established with data row in the second tables of data to data row in the first tables of data asked
Ask.
Step S420, data row in the first tables of data and the second tables of data is established according to preparatory condition according to the request
Corresponding relation.
Specifically, preparatory condition can be set as needed, for example, the date caused by data, the numbering of data distribution is consistent
Deng.
Step S430, in the hiding field of data row there is corresponding relation in record with the data row in the first tables of data
The second tables of data in data row mark, in the second tables of data in the hiding field of data row record deposited with the data row
The mark of data row in the first tables of data of corresponding relation.
Specifically, the hiding field that the data row of corresponding relation in the first tables of data and the second tables of data be present records respectively
Mutual mark, subsequent query can be facilitated.
In addition, the data row for not setting up corresponding relation according to preparatory condition, can manually establish corresponding pass
System.
Above-mentioned data query method can be applicable in cash in banks reconciliation.Using the first tables of data as bank statement, second
Tables of data be cash in bank journal exemplified by illustrate.
(1) grid control is respectively placed in operation interface, a fulcrum is set among two tablespaces, as even
The central point connect.
(2) request being associated to bank statement and cash in bank journal is obtained in the operation interface, according to
The request is according to the automatic reconciliation of preparatory condition.
Specifically, as shown in figure 5, according to the request according to the automatic reconciliation of preparatory condition, i.e., by the number in bank statement
Corresponding relation is established according to row and the data row in cash in bank journal, and the identification record of corresponding relation is hidden accordingly
In field, as cash in bank journal data line identifier be 1002 the hiding field record FBankID (numbers of bank statement
According to capable mark) 1005,1011.(bank deposits the hiding field record FCnID that the data line identifier of bank statement is 1002
The mark of the data row of money journal account) 1011.
(3) obtain to the hook of the data row chosen in cash in bank journal to request.
Specifically, hook to referring to that data row has corresponding close with the data row in bank statement in cash in bank journal
System.
(4) mark according to the hook to the data row of the bank statement of the hiding field record of the acquisition request data row,
Data row corresponding to the mark is searched, and obtains the predetermined point coordinates of two data rows, is connected by fulcrum by ruling.
Specifically, Fig. 5 is the man-to-man corresponding relation schematic diagram of the data row with predetermined point coordinates.In Fig. 5, the number chosen
1009, predetermined point A, fulcrum B are identified as according to the data row of behavior cash in bank journal, corresponding bank statement
Data row is identified as 1009, predetermined point C, rules A being connected to C by B.
(5) bank for obtaining the presence corresponding relation of the hiding field record of the data row of the bank statement found deposits
The mark of the data row of money journal account, according to the data row of identifier lookup cash in bank journal corresponding to, then obtain
The predetermined point coordinates of the data row of the corresponding cash in bank journal, predetermined chain-dotted line is connected to fulcrum.
Specifically, Fig. 6 is the corresponding relation schematic diagram of data row multi-to-multi.In Fig. 6, in the cash in bank journal chosen
Data line identifier is 1002, and it is 1005 Hes that it, which hides the data line identifier of the bank statement of the presence corresponding relation of field record,
1011, after the data row 1005 for the bank statement for finding corresponding relation, obtain the hiding field record of data row 1005
The data line identifier that the cash in bank journal of corresponding relation be present is 1002 and 1003, then will obtain the pre- of data row 1003
Fixed point is connected to fulcrum.
In addition, balance reconciliation sheet will be generated in operation interface after bank statement and cash in bank journal reconciliation.
As shown in fig. 7, in one embodiment, a kind of data query system, including acquisition module 110, searching modul 120
With mark module 130.Wherein：
Acquisition module 110 is used to obtain to the inquiry request for the data row chosen from the first tables of data or the second tables of data,
First tables of data is connected with the second tables of data to be illustrated in same operation interface.
Specifically, setting a fulcrum in operation interface, and coordinate system is established with the fulcrum, fixes the coordinate of the fulcrum,
First tables of data is connected and is illustrated in the operation interface by the fulcrum with the second tables of data.For example, the branch point coordinates for (x,
y).User's data row chosen in the first tables of data or the data chosen in the second tables of data are obtained in operation interface
Inquiry request caused by row triggering.
Searching modul 120 is used to be searched from the first tables of data and the second tables of data and the number according to the inquiry request
The data row of corresponding relation according to row be present.
Specifically, the data row of the presence corresponding relation for the hiding field record for choosing data row is obtained according to inquiry request
Mark, can be searched according to the mark and on data row corresponding to navigating to.Recorded using mark, will such as by the way of line
The data row chosen links up with corresponding data row.
Mark module 130 is used for the data traveling line flag chosen data row and found.For example with line
Mode the data row chosen is linked up with corresponding data row.
Above-mentioned data query system, by showing the first tables of data and the second tables of data, and root in same operation interface
The data row of corresponding relation from the first tables of data and the second data table search and the data row chosen according to the data row chosen be present,
Aforesaid operations are carried out on the client, are not required to the data for frequently going whois lookup related, alleviate the burden of server,
And the first tables of data and the second tables of data are shown on same interface, and operated in the operation interface, it is not required to frequently
Switch interface, simplify operation, improve operating efficiency.
Further, if the data row chosen is in the first tables of data, acquisition module 110 is additionally operable to look into according to
Ask the data in the second tables of data of the presence corresponding relation recorded in the hiding field for the data row chosen described in acquisition request
Capable mark.
Specifically, the second number that corresponding relation be present with the data row is have recorded in the hiding field for the data row chosen
According to the mark of the data row in table, the mark refers to the number field of data row in the second tables of data, such as 1001,1002, but
Not limited to this.
Searching modul 120 be additionally operable to according to the mark location of data row in second tables of data into the second tables of data it is right
The data row answered.
Specifically, after data row corresponding to navigating to, the coordinate of the predetermined point for calculating the data row that choose and the can be passed through
The coordinate of the predetermined point of corresponding data row in two tables of data, then two predetermined points are linked together, that is, select by fulcrum
In the predetermined point of data row be wired to fulcrum, the predetermined of corresponding data row in the second tables of data is then wired to by fulcrum
Point.
For the ease of calculating the coordinate of predetermined point, the highly consistent of the first tables of data and the second tables of data is set, placement
Apical position is consistent, it is assumed that is T, the highly consistent of every a line of tables of data is H, and the width per a line is unanimously M, operation interface
The total line number for the tables of data that one screen can be shown is L, and the predetermined point A for the data row chosen coordinate is (X1, Y1), fulcrum B's
Coordinate is (X, Y), and the predetermined point C of the data row of corresponding relation coordinate is (X2, Y2).Predetermined point A coordinate X1To hide word
Columns where segment table lattice, by the line number L where predetermined point A1With 1 and, then again divided by it is total line number L's and 1 and obtain business,
Then ask T with the business's and, obtain Y1 value, i.e. Y1=T+ (L1+1)/(L+1), wherein, it is because gauge outfit line number is 0 to add 1.Together
Sample can determine that C coordinate.Then mark module 130 presses coordinate line connection by three.
In addition, can not be when there is the data row in the second tables of data of corresponding relation with the data row in the first tables of data
During same screen display, data row in the second tables of data can be rolled, after finding corresponding data row, redefines the data row
The coordinate of predetermined point.
Mark module 130 is additionally operable to corresponding data in the data row chosen in the tables of data of mark first and the second tables of data
OK.
Acquisition module 110 is additionally operable to obtain the presence pair recorded in the hiding field of corresponding data row in the second tables of data
The mark of data row in the first tables of data that should be related to.
Specifically, the data row in the first tables of data of field record is hidden in the second tables of data in corresponding data row
Mark includes the mark for the data row chosen, and may also comprise the mark for other data rows that corresponding relation in the first tables of data be present
Know.For example, the data row L1 chosen in the first tables of data N1 and the second tables of data N2, the first tables of data N1 hiding field is recorded
Data row be identified as N2L2 (second the second data of tables of data row), N2L3 (the data row of the second tables of data the 3rd), second number
The data row recorded according to the hiding field of data row L2 in table N2 is identified as N1L1 (first the first data of tables of data row), N1L3
(the data row of the first tables of data the 3rd) etc..
Searching modul 120 be additionally operable to according to the mark location of data row in first tables of data into the first tables of data it is right
The data row answered.
Specifically, navigate to corresponding data row according to above-mentioned coordinate calculation.
Mark module 130 is additionally operable in the tables of data of mark second corresponding data in corresponding data row and the first tables of data
OK.The marking of mark module 130.
Further, if the data row chosen is in the second tables of data, acquisition module 110 is additionally operable to look into according to
Ask the data in the first tables of data of the presence corresponding relation recorded in the hiding field for the data row chosen described in acquisition request
Capable mark.
Specifically, after data row corresponding to navigating to, the coordinate of the predetermined point for calculating the data row that choose and the can be passed through
The coordinate of the predetermined point of corresponding data row in one tables of data, then two predetermined points are linked together, that is, select by fulcrum
In the predetermined point of data row be wired to fulcrum, the predetermined of corresponding data row in the first tables of data is then wired to by fulcrum
Point.
Searching modul 120 be additionally operable to according to the mark location of data row in first tables of data into the first tables of data it is right
The data row answered.
Mark module 130 is additionally operable to corresponding data in the data row chosen in the tables of data of mark second and the first tables of data
OK.
Acquisition module 110 is additionally operable to obtain the presence pair recorded in the hiding field of corresponding data row in the first tables of data
The mark of data row in the second tables of data that should be related to.
Specifically, the data row in the second tables of data of field record is hidden in the first tables of data in corresponding data row
Mark includes the mark for the data row chosen, and may also comprise the mark for other data rows that corresponding relation in the second tables of data be present
Know.For example, the data row L1 chosen in the first tables of data N1 and the second tables of data N2, the second tables of data N2 hiding field is recorded
Data row be identified as N1L2 (first the second data of tables of data row), N1L3 (the data row of the first tables of data the 3rd), first number
The data row recorded according to the hiding field of data row L2 in table N1 is identified as N2L1 (second the first data of tables of data row), N2L3
(the data row of the second tables of data the 3rd) etc..
Searching modul 120 be additionally operable to according to the mark location of data row in second tables of data into the second tables of data it is right
The data row answered.
Mark module 130 is additionally operable in the tables of data of mark first corresponding data in corresponding data row and the second tables of data
OK.
Above-mentioned data query system, can be quick by the data line identifier of the corresponding relation of the hiding field record of data row
Corresponding data row is navigated to, improves search efficiency, and the data obtained are on the client, are not required to again frequently from service
Device extracts data, alleviates server burden.
As shown in figure 8, above-mentioned data query system, except including acquisition module 110, searching modul 120 and mark module
130, in addition to fulcrum setup module 140 and coordinate obtaining module 150.Wherein：
Fulcrum setup module 140 is used to set a fulcrum in the operation interface, and establishes coordinate system with the fulcrum,
The coordinate of the fixed fulcrum, first tables of data is connected with the second tables of data by the fulcrum is illustrated in operation circle
On face.
Coordinate obtaining module 150 be additionally operable to obtain choose the predetermined point coordinates of data row and the data row that finds it is pre-
Pinpoint coordinate.
Mark module 130 is additionally operable to that two predetermined points are connected by fulcrum using marking.It is straight using marking
See, and draw simple.
As shown in figure 9, in one embodiment, above-mentioned data query system, except including acquisition module 110, searching mould
Block 120 and mark module 130, in addition to relationship request acquisition module 160, relation establish module 170 and memory module 180.Its
In：
Relationship request acquisition module 160 is used to obtain to be built to data row in the first tables of data and data row in the second tables of data
The request of vertical corresponding relation.
Relation is established module 170 and is used for according to the request according to preparatory condition in the first tables of data and the second tables of data
Data row establishes corresponding relation.
Specifically, preparatory condition can be set as needed, for example, the date caused by data, the numbering of data distribution is consistent
Deng.
Memory module 180 is used in the first tables of data record and data row presence pair in the hiding field of data row
The mark of data row in the second tables of data that should be related to, recorded and the number in the hiding field of data row in the second tables of data
The mark of data row in the first tables of data of corresponding relation according to row be present.
Specifically, the hiding field that the data row of corresponding relation in the first tables of data and the second tables of data be present records respectively
Mutual mark, subsequent query can be facilitated.
In addition, the data row for not setting up corresponding relation according to preparatory condition, can manually establish corresponding pass
System.
Above-mentioned data query system can be applicable in cash in banks reconciliation.Using the first tables of data as bank statement, second
Tables of data be cash in bank journal exemplified by illustrate.
(1) grid control is respectively placed in operation interface, fulcrum setup module 140 is set among two tablespaces
Put a fulcrum, the central point as connection.
(2) relationship request acquisition module 160 is obtained to bank statement and cash in bank journal in the operation interface
The request being associated, according to the request according to the automatic reconciliation of preparatory condition.
Specifically, as shown in figure 5, according to the request according to the automatic reconciliation of preparatory condition, i.e., by the number in bank statement
Corresponding relation is established according to row and the data row in cash in bank journal, and the identification record of corresponding relation is hidden accordingly
In field, as cash in bank journal data line identifier be 1002 the hiding field record FBankID (numbers of bank statement
According to capable mark) 1005,1011.(bank deposits the hiding field record FCnID that the data line identifier of bank statement is 1002
The mark of the data row of money journal account) 1011.
(3) acquisition module 110 is obtained to the hook of the data row chosen in cash in bank journal to request.
Specifically, hook to referring to that data row has corresponding close with the data row in bank statement in cash in bank journal
System.
(4) number of the acquisition module 110 according to the hook to the bank statement of the hiding field record of the acquisition request data row
According to capable mark, searching modul 120 searches data row corresponding to the mark, and coordinate obtaining module 150 obtains two data rows
Predetermined point coordinates, mark module 130 by two predetermined points by fulcrum pass through rule connect.
Specifically, Fig. 5 is the man-to-man corresponding relation schematic diagram of the data row with predetermined point coordinates.In Fig. 5, the number chosen
1009, predetermined point A, fulcrum B are identified as according to the data row of behavior cash in bank journal, corresponding bank statement
Data row is identified as 1009, predetermined point C, rules A being connected to C by B.
(5) presence of the hiding field record of the data row for the bank statement that the acquisition of acquisition module 110 is found is corresponding
The mark of the data row of the cash in bank journal of relation, the cash in banks corresponding to according to the identifier lookup of searching modul 120
The predetermined point of the data row of journal account, then the data row of the acquisition of the coordinate obtaining module 150 corresponding cash in bank journal
Predetermined chain-dotted line is connected to fulcrum by coordinate, mark module 130.
Specifically, Fig. 6 is the corresponding relation schematic diagram of data row multi-to-multi.In Fig. 6, in the cash in bank journal chosen
Data line identifier is 1002, and it is 1005 Hes that it, which hides the data line identifier of the bank statement of the presence corresponding relation of field record,
1011, after the data row 1005 for the bank statement for finding corresponding relation, obtain the hiding field record of data row 1005
The data line identifier that the cash in bank journal of corresponding relation be present is 1002 and 1003, then will obtain the pre- of data row 1003
Fixed point is connected to fulcrum.
In addition, balance reconciliation sheet will be generated in operation interface after bank statement and cash in bank journal reconciliation.
Embodiment described above only expresses the several embodiments of the present invention, and its description is more specific and detailed, but simultaneously
Therefore the limitation to the scope of the claims of the present invention can not be interpreted as.It should be pointed out that for one of ordinary skill in the art
For, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to the guarantor of the present invention
Protect scope.Therefore, the protection domain of patent of the present invention should be determined by the appended claims.
Claims (8)
1. a kind of data query method, comprises the following steps：
Obtain to the inquiry request for the data row chosen from the first tables of data or the second tables of data, first tables of data and second
Tables of data, which is connected, to be illustrated in same operation interface；
If the data row that the data row chosen in the first tables of data, is chosen according to obtaining the inquiry request
Hide the mark of the data row in the second tables of data of the presence corresponding relation recorded in field；
According to the mark location of data row in second tables of data into the second tables of data corresponding data row, and mark first
Corresponding data row in the data row chosen in tables of data and the second tables of data；
In the first tables of data for obtaining the presence corresponding relation recorded in the second tables of data in the hiding field of corresponding data row
Data row mark；
According to the mark location of data row in first tables of data into the first tables of data corresponding data row, and mark second
Corresponding data row in corresponding data row and the first tables of data in tables of data；
Wherein, in the hiding field of data row there are the second data of corresponding relation with the data row in record in the first tables of data
The mark of data row in table, in the hiding field of data row there is corresponding relation in record with the data row in the second tables of data
The mark of data row in first tables of data, the data row in the first tables of data and the second tables of data exist it is one-to-many, many-one or
The corresponding relation of multi-to-multi.
2. data query method according to claim 1, it is characterised in that methods described also includes：
If the data row that the data row chosen in the second tables of data, is chosen according to obtaining the inquiry request
Hide the mark of the data row in the first tables of data of the presence corresponding relation recorded in field；
According to the mark location of data row in first tables of data into the first tables of data corresponding data row, and mark second
Corresponding data row in the data row chosen in tables of data and the first tables of data；
In the second tables of data for obtaining the presence corresponding relation recorded in the first tables of data in the hiding field of corresponding data row
Data row mark；
According to the mark location of data row in second tables of data into the second tables of data corresponding data row, and mark first
Corresponding data row in corresponding data row and the second tables of data in tables of data.
3. according to the data query method described in claim 1, it is characterised in that obtaining to from the first tables of data or second
Before the step of inquiry request for the data row that tables of data is chosen, in addition to step：
One fulcrum is set in the operation interface, and coordinate system is established with the fulcrum, the coordinate of the fixed fulcrum is described
First tables of data is connected with the second tables of data by the fulcrum to be illustrated in the operation interface；
The step of corresponding data row includes in corresponding data row and the first tables of data in the tables of data of mark second：
Obtain the predetermined point coordinates of corresponding data row in the predetermined point coordinates for choosing data row and the second tables of data；
Two predetermined points are connected by fulcrum using marking.
4. according to the data query method described in claim 1, it is characterised in that obtain to from the first tables of data described or
Before the step of inquiry request for the data row that second tables of data is chosen, in addition to step：
Obtain the request that corresponding relation is established to data row in data row in the first tables of data and the second tables of data；
Corresponding relation is established to data row in the first tables of data and the second tables of data according to preparatory condition according to the request.
A kind of 5. data query system, it is characterised in that including：
Acquisition module, for obtaining to the inquiry request for the data row chosen from the first tables of data or the second tables of data, described the
One tables of data is connected with the second tables of data to be illustrated in same operation interface；
If the data row chosen, in the first tables of data, the acquisition module is additionally operable to obtain institute according to the inquiry request
State the mark of the data row in the second tables of data of the presence corresponding relation recorded in the hiding field for the data row chosen；
Searching modul, for according to the mark location of data row in second tables of data into the second tables of data corresponding data
OK；
Mark module, for corresponding data row in the data row chosen in the tables of data of mark first and the second tables of data；
The presence that the acquisition module is additionally operable to record in the hiding field of corresponding data row in the second tables of data of acquisition is corresponding
The mark of data row in first tables of data of relation；
The searching modul is additionally operable to be corresponded into the first tables of data according to the mark location of data row in first tables of data
Data row；
The mark module is additionally operable in the tables of data of mark second corresponding data row in corresponding data row and the first tables of data；
Wherein, in the hiding field of data row there are the second data of corresponding relation with the data row in record in the first tables of data
The mark of data row in table, in the hiding field of data row there is corresponding relation in record with the data row in the second tables of data
The mark of data row in first tables of data, the data row in the first tables of data and the second tables of data exist it is one-to-many, many-one or
The corresponding relation of multi-to-multi.
6. data query system according to claim 5, it is characterised in that if the data row chosen is in the second data
In table, recorded in the hiding field for the data row that the acquisition module is additionally operable to choose according to obtaining the inquiry request
The mark of the data row in the first tables of data of corresponding relation be present；
The searching modul is additionally operable to be corresponded into the first tables of data according to the mark location of data row in first tables of data
Data row；
The mark module is additionally operable to corresponding data row in the data row chosen in the tables of data of mark second and the first tables of data；
The presence that the acquisition module is additionally operable to record in the hiding field of corresponding data row in the first tables of data of acquisition is corresponding
The mark of data row in second tables of data of relation；
The searching modul is additionally operable to be corresponded into the second tables of data according to the mark location of data row in second tables of data
Data row；
The mark module is additionally operable in the tables of data of mark first corresponding data row in corresponding data row and the second tables of data.
7. according to the data query system described in claim 5, it is characterised in that also include：
Fulcrum setup module, coordinate system, fixed institute are established for setting a fulcrum in the operation interface, and with the fulcrum
The coordinate of fulcrum is stated, first tables of data is connected with the second tables of data by the fulcrum to be illustrated in the operation interface；
Coordinate obtaining module, choose for obtaining the predetermined point coordinates of data row and corresponding data row in the second tables of data
Predetermined point coordinates；
The mark module is additionally operable to that two predetermined points are connected by fulcrum using marking.
8. according to the data query system described in claim 5, it is characterised in that also include：
Relationship request acquisition module, it is corresponding with data row foundation in the second tables of data to data row in the first tables of data for obtaining
The request of relation；
Relation establishes module, for being asked according to described according to preparatory condition to data row in the first tables of data and the second tables of data
Establish corresponding relation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210375159.2A CN103714070B (en) | 2012-09-29 | 2012-09-29 | Data query method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210375159.2A CN103714070B (en) | 2012-09-29 | 2012-09-29 | Data query method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103714070A CN103714070A (en) | 2014-04-09 |
| CN103714070B true CN103714070B (en) | 2018-03-20 |
Family
ID=50407058
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210375159.2A Active CN103714070B (en) | 2012-09-29 | 2012-09-29 | Data query method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103714070B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109376173A (en) * | 2018-11-08 | 2019-02-22 | 郑州云海信息技术有限公司 | A kind of data query method, apparatus, electronic equipment and storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102479242A (en) * | 2010-11-30 | 2012-05-30 | 英业达股份有限公司 | System and method for displaying query result by relational graph |
| CN102576376A (en) * | 2009-07-08 | 2012-07-11 | 史蒂文·查尔斯·科恩 | Medical history system |
-
2012
- 2012-09-29 CN CN201210375159.2A patent/CN103714070B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102576376A (en) * | 2009-07-08 | 2012-07-11 | 史蒂文·查尔斯·科恩 | Medical history system |
| CN102479242A (en) * | 2010-11-30 | 2012-05-30 | 英业达股份有限公司 | System and method for displaying query result by relational graph |
Non-Patent Citations (3)
| Title |
|---|
| 关系型数据库，数据库表设计，两个表的连接关系是多对多，连接表的设计除了传统的设计方案外还有其他设计方案么？或者说有几种可能的设计方案;佚名;《http://www.zhihu.com/question/20194546》;20120423;第1-2页 * |
| 应用财务软件银行自动对账功能，提高银行存款对账效率;陈欣 等;《中国农业会计》;20110110;第2011年卷(第01期);第42-44页 * |
| 掌握用友ERP-U8软件中银行对账的操作方法;haoyun88;《http://www.doc88.com/p-25624273928.html》;20110305;第1-5页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103714070A (en) | 2014-04-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2020061939A1 (en) | Method, apparatus, and system for identifying device, storage medium, processor, and terminal | |
| JP2009058252A5 (en) | ||
| RU2004109570A (en) | COMPUTER SEARCH USING ASSOCIATIVE RELATIONS | |
| JP2010027031A (en) | Apparatus, method, and program for name identification using note data | |
| CN101311958A (en) | Data information enquiry storage method of credit rating enquiry service system | |
| CN101882135B (en) | Data processing method and device | |
| JP5878610B1 (en) | Data processing system and data processing program using geographic information | |
| CN104199881A (en) | Database cluster, data query method and data synchronism method and device | |
| JP4473893B2 (en) | Work item extraction device, work item extraction method, and work item extraction program | |
| CN107220266A (en) | It is a kind of to create Service Database, business datum storage and the method and device for determining business datum | |
| CN103198071B (en) | Datagram table generating method and device thereof | |
| CN102467525A (en) | Document associating method and system | |
| CN102521364A (en) | Method for inquiring shortest path between two points on map | |
| CN110969000B (en) | Data merging processing method and device | |
| CN103678682B (en) | Magnanimity raster data processing and management method based on abstraction templates | |
| CN103712628B (en) | Guidance path plotting method and terminal | |
| CN108255964B (en) | Method for displaying process flow route | |
| CN110516120A (en) | Information processing method and device, storage medium, electronic device | |
| CN103714070B (en) | Data query method and system | |
| CN107291951B (en) | Data processing method, device, storage medium and processor | |
| CN107133391A (en) | The generation method and system of construction drawing | |
| JP2007079866A (en) | Image classification apparatus, image classification method, image classification program, and image pickup device | |
| JP5060601B2 (en) | Document analysis apparatus and program | |
| JP5826148B2 (en) | Drawing management server and drawing management system using the same | |
| JP2011059818A (en) | Sediment control related information management system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |