CN104408171A - Receipt sub-table row-correlated query device and method - Google Patents
Receipt sub-table row-correlated query device and method Download PDFInfo
- Publication number
- CN104408171A CN104408171A CN201410761795.8A CN201410761795A CN104408171A CN 104408171 A CN104408171 A CN 104408171A CN 201410761795 A CN201410761795 A CN 201410761795A CN 104408171 A CN104408171 A CN 104408171A
- Authority
- CN
- China
- Prior art keywords
- document
- interface
- business
- row
- source documents
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
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/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24564—Applying rules; Deductive queries
- G06F16/24566—Recursive queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a receipt sub-table row-correlated query device. The receipt sub-table row-correlated query device comprises a business interface providing unit for providing corresponding universal receipt interfaces based on the incidence relation of business receipts to be queried, and a business correlated query unit for invoking the corresponding receipt interfaces to perform recursive call query incidence relation and store and display business data obtained according to the recursive call query incidence relation. The invention further provides a receipt sub-table row-correlated query method. By means of the technical scheme and based on an existing correlated query mode, single-object types can be fully utilized to complete correlated query of multi-object types and establish a multi-object type involved universal and unified correlated-query thought.
Description
Technical field
The present invention relates to technical field of data processing, particularly, relate to a kind of document sublist row correlation inquiry device and a kind of document sublist row relation query method.
Background technology
Along with the development of computer networking technology and database technology and universal, increasing enterprise relies on management software to carry out administering and maintaining of day to day operation.All kinds of business datum is all the data instance of certain class type of service in fact, is not isolated existence, has business relations of countless ties in the middle of it between the business datum of miscellaneous service type.
In some operation flows of enterprise, the document preparing to increase newly in some business activities of flow process middle and lower reaches often can need to generate with reference to one or more business paper existed of upstream, and one is completed by following four operation stepss usually with reference to raw single business activity: first inquire about upstream document; Then selected document from Query Result, the target document of formation base after selected; Then current document data are edited; Finally preserve and generate final target document.By repeatedly similar business operation, between each document, establish miscellaneous service association.
User, when utilizing management software to carry out corporate operation and service management, often can need to check the relation between each business datum, for doing operational decision making or generating related statements data etc.Therefore often need the correlation inquiry function between the tender of documents at management software back warp, come clearly for user represents the business relations between all kinds of business datum.
Its operation can be divided into two class scenes, the first, choose certain business datum, inquire about the upstream and downstream business information of this business datum association, the second, choose the concrete sublist row data of certain business datum, inquire the upstream and downstream service data information associated by sublist data line of this business datum, and navigate in the concrete association sublist data of concrete business datum.
Give an example to explain, in supply chain field, booking form document is used for maintenance to customer subscription order data, and sales order is used for the maintenance to sales situation and detailed data, and invoice for sales is used for the maintenance to the data of making out an invoice of sales data.Be have distinct business upstream-downstream relationship between this three classes document, what first generate is booking form, then can generate sales order by booking form, can generate invoice for sales after sales order completes.User may need choosing certain sales order data, inquire about booking form and the invoice for sales of its correspondence, then directly enter corresponding document and check detailed service data, this is corresponding first kind scene above just, also certain the material sublist information chosen in booking form may be needed, inquire about its final lot-size in sales order, this is corresponding Equations of The Second Kind scene above just.
As there is no direct document correlation inquiry function, user needs in sales order, record its document number, then booking form or invoice for sales node is opened, inquire about its related information, if need the related information inquiring about sublist row, operate then more complicated, need the master meter according to document to be checked and sublist relevant information thereof, go other document to retrieve or travel through just can obtain relevant information, if when multiple booking list generates a sales order, then more complicated, need itemize to go retrieval comparison just can obtain final related information.In sum, its operating process is loaded down with trivial details and directly perceived not.
Therefore, need a kind of new correlation inquiry technology, on existing correlation inquiry mode basis, the correlation inquiry that single object type completes multi-object type can be made full use of, set up general, the unified query thinking of the correlation inquiry that multi-object type participates in.
Summary of the invention
The present invention is just based on the problems referred to above, propose a kind of new correlation inquiry technology, on existing correlation inquiry mode basis, the correlation inquiry that single object type completes multi-object type can be made full use of, set up general, the unified query thinking of the correlation inquiry that multi-object type participates in.
In view of this, the present invention proposes a kind of document sublist row correlation inquiry device, comprising: business interface providing unit, for based on the incidence relation between each business paper to be checked, provide corresponding general document interface; Business association query unit, for calling corresponding document interface, carrying out recursive call inquiry incidence relation, storing the business datum that recursive call inquiry incidence relation obtains and representing.In this technical scheme, carry out recursive traversal by the relevant interface configuration data calling each document, penetrate layer by layer, finally inquire all upstream and downstream document related informations, and graphic exhibition, friendly interface, it is clear to operate.
In technique scheme, preferably, described business interface providing unit, specifically comprises: single field source documents interface provides module, if unique for the source documents type of this business paper, then provides single field source documents interface; Compound fields source documents interface provides module, if not unique for the source documents type of this business unit, then and the line number joint investigation interface used when providing compound fields source documents interface to be provided in expansion.In this technical scheme, can demonstrate between document and associate, and need accurately be positioned in the business scenario inquiry of associated invoice data corresponding to certain document sublist row.
In technique scheme, preferably, described business interface providing unit, specifically also comprises: line number joint investigation interface provides module, the line number joint investigation interface used during for being provided in expansion; And, described single field source documents interface provides module to provide the operation of single field source documents interface, which comprise further: the concrete field of definition current business document and the corresponding document major key coupling of source documents type, define multiple field in interface, meet the situation that multiple field all can be mated; And/or, described compound fields source documents interface provides module to provide the operation of compound fields source documents interface, comprise further: provide some to origin definitions, often pair comprises a source documents type and a source documents, needs to mate document types and document major key during coupling simultaneously; And/or the operation of the line number joint investigation interface used when described line number joint investigation interface provides module to be provided in expansion, comprises further: the line number of definition current business document maps and source documents line number maps, and uses when doing association coupling for antithetical phrase table row number.
In technique scheme, preferably, described business association query unit, specifically comprises: inquiry request afferent module, for the inquiry request based on user, imports document parameter and current document type into; This inquiry request, if row correlation inquiry, also comprises in document number and specifically chooses sublist row number information except current document major key; Recursive call enquiry module, for based on the document parameter imported into and current document type, obtain business paper upstream and downstream information searching class, adopt recursive call algorithm, carry out recursive call inquiry, until the preposition or follow-up document of corresponding document is that sky then stops recurrence; Incidence relation enquiry module, for based on recursive call Query Result, inquires about the concrete document information of particular type, goes to perform specifically inquire about incidence relation from business paper joint investigation requestor; Business datum stores and module, for the business datum obtained based on concrete inquiry incidence relation, finally constructs the complete result data comprising upstream and downstream document and association sublist joint investigation information aggregate and returns to interface, foreground and do and represent; And define business datum result, storage line joint investigation related information region.In this technical scheme, user only needs to realize relevant interface logic, can realize the inquiry of document upstream and downstream information association and concrete sublist row related information inquiry, can promote user-interaction experience to a great extent, and improve search efficiency.
In technique scheme, preferably, described recursive call enquiry module obtains the operation of business paper upstream and downstream information searching class, comprises further: definition obtains the follow-up document of specified type document, and obtains the preposition document method of specified type document; And/or described incidence relation enquiry module performs the operation of concrete inquiry incidence relation, comprises further: if common document joint investigation, then direct inquiring document; If row joint investigation, then according to after the corresponding line number of row joint investigation document interface polls, then find its corresponding document according to line number; And/or the row joint investigation related information region of described business datum storage and module stores, comprises the data detailed construction of row joint investigation information.
According to a further aspect of the invention, also proposed a kind of document sublist row relation query method, comprising: step 202: based on the incidence relation between each business paper to be checked, corresponding general document interface is provided; Step 204: call corresponding document interface, carries out recursive call inquiry incidence relation, stores the business datum that recursive call inquiry incidence relation obtains and represents.In this technical scheme, carry out recursive traversal by the relevant interface configuration data calling each document, penetrate layer by layer, finally inquire all upstream and downstream document related informations, and graphic exhibition, friendly interface, it is clear to operate.
In technique scheme, preferably, described step 202, specifically comprises: step 302: if the source documents type of this business paper is unique, then provide single field source documents interface; Step 304: if the source documents type of this business unit is not unique, then provide compound fields source documents interface.In this technical scheme, can demonstrate between document and associate, and need accurately be positioned in the business scenario inquiry of associated invoice data corresponding to certain document sublist row.
In technique scheme, preferably, described step 202, specifically also comprises: step 306: the line number joint investigation interface used when being provided in expansion; And, described step 302 provides the operation of single field source documents interface, comprise further: which field concrete of definition current business document and the corresponding document major key coupling of source documents type, define multiple field, meet the situation that multiple field all can be mated in interface; And/or described step 304 provides the operation of compound fields source documents interface, comprises further: provide some to origin definitions, often pair comprises a source documents type and a source documents, needs to mate document types and document major key during coupling simultaneously; And/or the operation of the line number joint investigation interface used when described step 306 is provided in expansion, comprises further: the line number of definition current business document maps and source documents line number maps, and uses when doing association coupling for antithetical phrase table row number.
In technique scheme, preferably, described step 204, specifically comprises: step 402: based on the inquiry request of user, imports document parameter and current document type into; This inquiry request, if row correlation inquiry, also comprises in document number and specifically chooses sublist row number information except current document major key; Step 404: based on the document parameter imported into and current document type, obtains business paper upstream and downstream information searching class, adopts recursive call algorithm, carry out recursive call inquiry, until the preposition or follow-up document of corresponding document is that sky then stops recurrence; Step 406: based on recursive call Query Result, the concrete document information of inquiry particular type, goes to perform from business paper joint investigation requestor and specifically inquires about incidence relation; Step 408: the business datum obtained based on concrete inquiry incidence relation, finally constructs the complete result data comprising upstream and downstream document and association sublist joint investigation information aggregate and returns to interface, foreground and do and represent; And define business datum result, storage line joint investigation related information region.In this technical scheme, user only needs to realize relevant interface logic, can realize the inquiry of document upstream and downstream information association and concrete sublist row related information inquiry, can promote user-interaction experience to a great extent, and improve search efficiency.
In technique scheme, preferably, described step 404 obtains the operation of business paper upstream and downstream information searching class, comprises further: definition obtains the follow-up document of specified type document, and obtains the preposition document method of specified type document; And/or described step 406 performs the operation of concrete inquiry incidence relation, comprises further: if common document joint investigation, then direct inquiring document; If row joint investigation, then according to after the corresponding line number of row joint investigation document interface polls, then find its corresponding document according to line number; And/or the row joint investigation related information region that described step 408 stores, comprises the data detailed construction of row joint investigation information.
By above technical scheme, on existing correlation inquiry mode basis, the correlation inquiry that single object type completes multi-object type can be made full use of, set up general, the unified query thinking of the correlation inquiry that multi-object type participates in.
Accompanying drawing explanation
Fig. 1 shows the block diagram of document sublist row correlation inquiry device according to an embodiment of the invention;
Fig. 2 shows the process flow diagram of document sublist row relation query method according to an embodiment of the invention;
Fig. 3 shows the process flow diagram of business interface providing unit according to an embodiment of the invention;
Fig. 4 shows the process flow diagram of service management query unit according to an embodiment of the invention;
Fig. 5 shows the process flow diagram of purchase order according to an embodiment of the invention;
Fig. 6 shows the structural representation of operational data structure according to an embodiment of the invention;
Fig. 7 shows the structural representation of the data detailed construction of row joint investigation information according to an embodiment of the invention;
Fig. 8 shows the logical diagram of recursive call algorithm according to an embodiment of the invention;
Fig. 9 shows the process flow diagram of recursive call method according to an embodiment of the invention.
Embodiment
In order to more clearly understand above-mentioned purpose of the present invention, feature and advantage, below in conjunction with the drawings and specific embodiments, the present invention is further described in detail.It should be noted that, when not conflicting, the feature in the embodiment of the application and embodiment can combine mutually.
Set forth a lot of detail in the following description so that fully understand the present invention; but; the present invention can also adopt other to be different from other modes described here and implement, and therefore, protection scope of the present invention is not by the restriction of following public specific embodiment.
Fig. 1 shows the block diagram of document sublist row correlation inquiry device according to an embodiment of the invention.
As shown in Figure 1, document sublist row correlation inquiry device 100 according to an embodiment of the invention, comprising: business interface providing unit 102, for based on the incidence relation between each business paper to be checked, provides corresponding general document interface; Business association query unit 104, for calling corresponding document interface, carrying out recursive call inquiry incidence relation, storing the business datum that recursive call inquiry incidence relation obtains and representing.In this technical scheme, carry out recursive traversal by the relevant interface configuration data calling each document, penetrate layer by layer, finally inquire all upstream and downstream document related informations, and graphic exhibition, friendly interface, it is clear to operate.
In technique scheme, preferably, business interface providing unit 102, specifically comprises: single field source documents interface provides module 1022, if unique for the source documents type of this business paper, then provides single field source documents interface; Compound fields source documents interface provides module 1024, if not unique for the source documents type of this business unit, then provides compound fields source documents interface.In this technical scheme, can demonstrate between document and associate, and need accurately be positioned in the business scenario inquiry of associated invoice data corresponding to certain document sublist row.
In technique scheme, preferably, business interface providing unit 102, specifically also comprises:; Line number joint investigation interface provides module 1026, the line number joint investigation interface used during for being provided in expansion; And, single field source documents interface provides module 1022 to provide the operation of single field source documents interface, which comprise further: the concrete field of definition current business document and the corresponding document major key coupling of source documents type, define multiple field in interface, meet the situation that multiple field all can be mated; And/or, compound fields source documents interface provides module 1024 to provide the operation of compound fields source documents interface, comprise further: provide some to origin definitions, often pair comprises a source documents type and a source documents, needs to mate document types and document major key during coupling simultaneously; And/or the operation of the line number joint investigation interface used when line number joint investigation interface provides module 1026 to be provided in expansion, comprises further: the line number of definition current business document maps and source documents line number maps, and uses when doing association coupling for antithetical phrase table row number.
In technique scheme, preferably, business association query unit 104, specifically comprises: inquiry request afferent module 1042, for the inquiry request based on user, imports document parameter and current document type into; This inquiry request, if row correlation inquiry, also comprises in document number and specifically chooses sublist row number information except current document major key; Recursive call enquiry module 1044, for based on the document parameter imported into and current document type, obtain business paper upstream and downstream information searching class, adopt recursive call algorithm, carry out recursive call inquiry, until the preposition or follow-up document of corresponding document is that sky then stops recurrence; Incidence relation enquiry module 1046, for based on recursive call Query Result, inquires about the concrete document information of particular type, goes to perform specifically inquire about incidence relation from business paper joint investigation requestor; Business datum stores and module 1048, for the business datum obtained based on concrete inquiry incidence relation, finally constructs the complete result data comprising upstream and downstream document and association sublist joint investigation information aggregate and returns to interface, foreground and do and represent; And define business datum result, storage line joint investigation related information region.In this technical scheme, user only needs to realize relevant interface logic, can realize the inquiry of document upstream and downstream information association and concrete sublist row related information inquiry, can promote user-interaction experience to a great extent, and improve search efficiency.
In technique scheme, preferably, recursive call enquiry module 1044 obtains the operation of business paper upstream and downstream information searching class, comprises further: definition obtains the follow-up document of specified type document, and obtains the preposition document method of specified type document; And/or incidence relation enquiry module 1046 performs the operation of concrete inquiry incidence relation, comprises further: if common document joint investigation, then direct inquiring document; If row joint investigation, then according to after the corresponding line number of row joint investigation document interface polls, then find its corresponding document according to line number; And/or the row joint investigation related information region that business datum stores and module 1048 stores, comprises the data detailed construction of row joint investigation information.
Fig. 2 shows the process flow diagram of document sublist row relation query method according to an embodiment of the invention.
As shown in Figure 2, document sublist row relation query method according to an embodiment of the invention, comprising: step 202: based on the incidence relation between each business paper to be checked, provides corresponding general document interface; Step 204: call corresponding document interface, carries out recursive call inquiry incidence relation, stores the business datum that recursive call inquiry incidence relation obtains and represents.In this technical scheme, carry out recursive traversal by the relevant interface configuration data calling each document, penetrate layer by layer, finally inquire all upstream and downstream document related informations, and graphic exhibition, friendly interface, it is clear to operate.
In technique scheme, preferably, as shown in Figure 3, step 202, specifically comprises: step 302: if the source documents type of this business paper is unique, then provide single field source documents interface; Step 304: if the source documents type of this business unit is not unique, then provide compound fields source documents interface.In this technical scheme, can demonstrate between document and associate, and need accurately be positioned in the business scenario inquiry of associated invoice data corresponding to certain document sublist row.
In technique scheme, preferably, step 202, specifically also comprises: step 306: the line number joint investigation interface used when being provided in expansion; And, step 302 provides the operation of single field source documents interface, comprise further: which field concrete of definition current business document and the corresponding document major key coupling of source documents type, define multiple field, meet the situation that multiple field all can be mated in interface; And/or step 304 provides the operation of compound fields source documents interface, comprises further: provide some to origin definitions, often pair comprises a source documents type and a source documents, needs to mate document types and document major key during coupling simultaneously; And/or the operation of the line number joint investigation interface used when step 306 is provided in expansion, comprises further: the line number of definition current business document maps and source documents line number maps, and uses when doing association coupling for antithetical phrase table row number.
In technique scheme, preferably, as shown in Figure 4, step 204, specifically comprises: step 402: based on the inquiry request of user, imports document parameter and current document type into; This inquiry request, if row correlation inquiry, also comprises in document number and specifically chooses sublist row number information except current document major key; Step 404: based on the document parameter imported into and current document type, obtains business paper upstream and downstream information searching class, adopts recursive call algorithm, carry out recursive call inquiry, until the preposition or follow-up document of corresponding document is that sky then stops recurrence; Step 406: based on recursive call Query Result, the concrete document information of inquiry particular type, goes to perform from business paper joint investigation requestor and specifically inquires about incidence relation; Step 408: the business datum obtained based on concrete inquiry incidence relation, finally constructs the complete result data comprising upstream and downstream document and association sublist joint investigation information aggregate and returns to interface, foreground and do and represent; And define business datum result, storage line joint investigation related information region.In this technical scheme, user only needs to realize relevant interface logic, can realize the inquiry of document upstream and downstream information association and concrete sublist row related information inquiry, can promote user-interaction experience to a great extent, and improve search efficiency.
In technique scheme, preferably, step 404 obtains the operation of business paper upstream and downstream information searching class, comprises further: definition obtains the follow-up document of specified type document, and obtains the preposition document method of specified type document; And/or step 406 performs the operation of concrete inquiry incidence relation, comprises further: if common document joint investigation, then direct inquiring document; If row joint investigation, then according to after the corresponding line number of row joint investigation document interface polls, then find its corresponding document according to line number; And/or the row joint investigation related information region that step 408 stores, comprises the data detailed construction of row joint investigation information.
Technical scheme of the present invention, specifically provide a kind of technology of document sublist row correlation inquiry, when being mainly used in correlation inquiry business datum, needing not only to demonstrate between document and associate, and need accurately be positioned in the business scenario inquiry of associated invoice data corresponding to certain document sublist row.
For the defect that prior art exists, in enterprise information system, when user needs to inquire about the incidence relation between each business paper, we provide following scheme, provide three kinds of general-purpose interfaces, if the source documents type of this business paper is unique, then realize single field source documents interface, wherein define which field concrete and the corresponding document major key coupling of source documents type of current business document, define multiple field in interface, meet the situation that multiple field all may be mated; If the source documents type of this business unit is not unique, then realize compound fields source documents interface, the inside provides some to origin definitions, and often pair comprises a source documents type and a source documents, needs to mate document types and document major key during coupling simultaneously; The line number joint investigation interface used when being provided in expansion in addition, the line number wherein defining current business document maps and the mapping of source documents line number, uses when doing association coupling for antithetical phrase table row number.
Such correlation inquiry function, carries out recursive traversal by the relevant interface configuration data calling each document, penetrates layer by layer, finally inquires all upstream and downstream document related informations, and graphic exhibition, friendly interface, it is clear to operate.
The association of business paper is specific in data, be exactly the correlation inquiry between data in fact, technical scheme of the present invention invents different being from other, it is all generally the association matching inquiry to whole document, and technical scheme emphasis of the present invention is the data line rank correlation inquiry of document location being implemented to document, may be used for the service application supporting some more complicated like this, such as, once order repeatedly shipment in purchasing management, or a shipment etc. complicated business of repeatedly ordering goods.The correlation inquiry of document location is implemented to the function of the data line rank of document by technical solution of the present invention, for the data traceability of document provides important evidence, utilize this technical scheme, we can the capable implementation status of the concrete bills data orienting certain document concrete of quickness and high efficiency.
The present invention is mainly divided into two parts structure, an interface that must realize when being node definition, a part be when realizing calling interface to carry out recursive call inquiry incidence relation.
Every class document has corresponding document types, if the upstream-downstream relationship of certain document types is man-to-man relation, directly can specify its upstream and downstream associate field by define field.Consider that practical business scene is more complicated, the upstream and downstream of the document types had is likely multiple document types, the purchase order of such as Fig. 5, its document that places an order can be that manifest or purchase bill are arrived in buying, and it needs generation two paths to carry out the sign of data correlation when associating.For the business scenario of this many document types, the set of properties of document types and document associate field can be defined, allow purchase order realize many group incidence relation set of properties, circulate when carrying out correlation inquiry many groups and carry out the retrieval of associated path.
After above two kinds of definition, can think and set up incidence relation between multiple document types.But the association only between documentary is inadequate, the association of the concrete sublist row data of checking correlation inquiry in business, often can be needed to quote the relations of distribution.Such as, material data in the sublist of certain purchase order, its quantity partly may be distributed in buying in manifest, and part then carries out purchase billing, in purchase bill data.Therefore the business association inquiry carrying out the association of sublist row is needed.The present invention needs on each document types document, indicate association line number map field corresponding to its sublist row, namely the data correlation matching field when carrying out row correlation inquiry, concrete associated invoice is navigated to according to the document types of master meter and source documents when correlation inquiry, again according to sublist row field search associated line data, can penetrate layer by layer like this, than the common document joint investigation incidence relation represented between document specifically.In fact extract line number definition information to associate, we need on original document, realize interface and specify line number map field,
For storing the business datum relation of above complexity, we define following operational data structure, as Fig. 6.Two row corresponding stored row joint investigation related information region wherein, the data detailed construction comprising row joint investigation information is wherein as Fig. 7.
Adopt recursive call algorithm in joint investigation process, its algorithm calling logic figure is as Fig. 8.
After user clicks joint investigation button, need to import document parameter and current document type into, if row correlation inquiry, also comprise except current document major key in document number and specifically choose sublist row number information.
First obtain business paper upstream and downstream information searching class, wherein definition obtains the correlation technique of the follow-up document of specified type document and the preposition document of acquisition specified type document.Then its querying method of recursive call, until the preposition or follow-up document of certain document is that sky then stops recurrence.
In recursive call method, when inquiring about the concrete document information of particular type, go to perform concrete inquiry from business paper joint investigation requestor.In inquiry, if common document joint investigation, then direct inquiring document VO; If row joint investigation, then according to after the corresponding line number of row joint investigation document interface polls, then find its corresponding document VO according to line number.
After recursive call like this inquiry, finally construct the complete result data comprising upstream and downstream document and association sublist joint investigation information aggregate and return to interface, foreground and do and represent.Roughly process as shown in Figure 9.
Technical scheme of the present invention, provides a kind of definition of simple possible and realizes the technical scheme of document related information inquiry, defines related service interface and the structure definition realizing interface and object information.User only needs to realize relevant interface logic, can realize the inquiry of document upstream and downstream information association and concrete sublist row related information inquiry.Poly-in function, be simple and easy to use, user-interaction experience can be promoted to a great extent, and improve search efficiency.
More than be described with reference to the accompanying drawings technical scheme of the present invention, considered in correlation technique there is no easy, the unified solution for complicated type metadata query.Existing correlation inquiry cannot complete the correlation inquiry process that complicated type participates in.Therefore, the present invention proposes a kind of document sublist row correlation inquiry device and a kind of document sublist row relation query method, can on existing correlation inquiry mode basis, make full use of the correlation inquiry that single object type completes multi-object type, set up general, the unified query thinking of the correlation inquiry that multi-object type participates in.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. a document sublist row correlation inquiry device, is characterized in that, comprising:
Business interface providing unit, for based on the incidence relation between each business paper to be checked, provides corresponding general document interface;
Business association query unit, for calling corresponding document interface, carrying out recursive call inquiry incidence relation, storing the business datum that recursive call inquiry incidence relation obtains and representing.
2. document sublist row correlation inquiry device according to claim 1, it is characterized in that, described business interface providing unit, specifically comprises:
Single field source documents interface provides module, if unique for the source documents type of this business paper, then provides single field source documents interface;
Compound fields source documents interface provides module, if not unique for the source documents type of this business unit, then provides compound fields source documents interface; The line number joint investigation interface used when being provided in expansion.
3. document sublist row correlation inquiry device according to claim 2, it is characterized in that, described business interface providing unit, specifically also comprises:
Line number joint investigation interface provides module, the line number joint investigation interface used during for being provided in expansion; And,
Described single field source documents interface provides module to provide the operation of single field source documents interface, comprises further:
Which field concrete of definition current business document and the corresponding document major key coupling of source documents type, define multiple field, meet the situation of multiple fields match in interface;
And/or,
Described compound fields source documents interface provides module to provide the operation of compound fields source documents interface, comprises further:
There is provided some to origin definitions, often pair comprises a source documents type and a source documents, needs to mate document types and document major key during coupling simultaneously;
And/or,
The operation of the line number joint investigation interface that described line number joint investigation interface uses when providing module to be provided in expansion, comprises further:
The line number of definition current business document maps and source documents line number maps, and uses when doing association coupling for antithetical phrase table row number.
4. the document sublist row correlation inquiry device according to any one of claim 1-3, it is characterized in that, described business association query unit, specifically comprises:
Inquiry request afferent module, for the inquiry request based on user, imports document parameter and current document type into; This inquiry request, if row correlation inquiry, also comprises in document number and specifically chooses sublist row number information except current document major key;
Recursive call enquiry module, for based on the document parameter imported into and current document type, obtain business paper upstream and downstream information searching class, adopt recursive call algorithm, carry out recursive call inquiry, until the preposition or follow-up document of corresponding document is that sky then stops recurrence;
Incidence relation enquiry module, for based on recursive call Query Result, inquires about the concrete document information of particular type, goes to perform specifically inquire about incidence relation from business paper joint investigation requestor;
Business datum stores and module, for the business datum obtained based on concrete inquiry incidence relation, finally constructs the complete result data comprising upstream and downstream document and association sublist joint investigation information aggregate and returns to interface, foreground and do and represent; And define business datum result, storage line joint investigation related information region.
5. document sublist row correlation inquiry device according to claim 4, is characterized in that, described recursive call enquiry module obtains the operation of business paper upstream and downstream information searching class, comprises further:
Definition obtains the follow-up document of specified type document, and obtains the preposition document method of specified type document;
And/or,
Described incidence relation enquiry module performs the operation of concrete inquiry incidence relation, comprises further:
If common document joint investigation, then direct inquiring document; If row joint investigation, then according to after the corresponding line number of row joint investigation document interface polls, then find its corresponding document according to line number;
And/or,
The row joint investigation related information region of described business datum storage and module stores, comprises the data detailed construction of row joint investigation information.
6. a document sublist row relation query method, is characterized in that, comprising:
Step 202: based on the incidence relation between each business paper to be checked, provides corresponding general document interface;
Step 204: call corresponding document interface, carries out recursive call inquiry incidence relation, stores the business datum that recursive call inquiry incidence relation obtains and represents.
7. document sublist row relation query method according to claim 6, it is characterized in that, described step 202, specifically comprises:
Step 302: if the source documents type of this business paper is unique, then provide single field source documents interface;
Step 304: if the source documents type of this business unit is not unique, then the line number joint investigation interface used when providing compound fields source documents interface to be provided in expansion.
8. document sublist row relation query method according to claim 7, it is characterized in that, described step 202, specifically also comprises:
Step 306: the line number joint investigation interface used when being provided in expansion; And,
Described step 302 provides the operation of single field source documents interface, comprises further:
Which field concrete of definition current business document and the corresponding document major key coupling of source documents type, define multiple field, meet the situation of multiple fields match in interface;
And/or,
Described step 304 provides the operation of compound fields source documents interface, comprises further:
There is provided some to origin definitions, often pair comprises a source documents type and a source documents, needs to mate document types and document major key during coupling simultaneously;
And/or,
The operation of the line number joint investigation interface that described step 306 uses when being provided in expansion, comprises further:
The line number of definition current business document maps and source documents line number maps, and uses when doing association coupling for antithetical phrase table row number.
9. the document sublist row relation query method according to any one of claim 6-8, it is characterized in that, described step 204, specifically comprises:
Step 402: based on the inquiry request of user, imports document parameter and current document type into; This inquiry request, if row correlation inquiry, also comprises in document number and specifically chooses sublist row number information except current document major key;
Step 404: based on the document parameter imported into and current document type, obtains business paper upstream and downstream information searching class, adopts recursive call algorithm, carry out recursive call inquiry, until the preposition or follow-up document of corresponding document is that sky then stops recurrence;
Step 406: based on recursive call Query Result, the concrete document information of inquiry particular type, goes to perform from business paper joint investigation requestor and specifically inquires about incidence relation;
Step 408: the business datum obtained based on concrete inquiry incidence relation, finally constructs the complete result data comprising upstream and downstream document and association sublist joint investigation information aggregate and returns to interface, foreground and do and represent; And define business datum result, storage line joint investigation related information region.
10. document sublist row relation query method according to claim 9, it is characterized in that, described step 404 obtains the operation of business paper upstream and downstream information searching class, comprises further:
Definition obtains the follow-up document of specified type document, and obtains the preposition document method of specified type document;
And/or,
Described step 406 performs the operation of concrete inquiry incidence relation, comprises further:
If common document joint investigation, then direct inquiring document; If row joint investigation, then according to after the corresponding line number of row joint investigation document interface polls, then find its corresponding document according to line number;
And/or,
The row joint investigation related information region that described step 408 stores, comprises the data detailed construction of row joint investigation information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410761795.8A CN104408171B (en) | 2014-12-12 | 2014-12-12 | Document sublist row correlation inquiry device and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410761795.8A CN104408171B (en) | 2014-12-12 | 2014-12-12 | Document sublist row correlation inquiry device and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104408171A true CN104408171A (en) | 2015-03-11 |
| CN104408171B CN104408171B (en) | 2019-03-26 |
Family
ID=52645802
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410761795.8A Active CN104408171B (en) | 2014-12-12 | 2014-12-12 | Document sublist row correlation inquiry device and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104408171B (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105046415A (en) * | 2015-06-29 | 2015-11-11 | 用友优普信息技术有限公司 | Document joint-check method and document joint-check device |
| CN105046414A (en) * | 2015-06-29 | 2015-11-11 | 用友优普信息技术有限公司 | Business tracing method and business tracing device applied to ERP systems |
| CN107833024A (en) * | 2017-11-24 | 2018-03-23 | 江苏中威科技软件系统有限公司 | Retroactive method is signed in the visualization of flow |
| CN108062255A (en) * | 2018-01-08 | 2018-05-22 | 东莞嘉泰钟表有限公司 | One kind is mutually related method for module in production management |
| CN108288147A (en) * | 2018-01-08 | 2018-07-17 | 东莞嘉泰钟表有限公司 | A kind of quick-searching and input control method for production management |
| CN109377159A (en) * | 2018-09-19 | 2019-02-22 | 成都信息工程大学 | A kind of software modeling procedure incarnation evolution system and method, processor, terminal |
| CN109542947A (en) * | 2018-10-29 | 2019-03-29 | 金蝶软件（中国）有限公司 | Data statistical approach, device, computer equipment and storage medium |
| CN110019182A (en) * | 2017-08-15 | 2019-07-16 | 华为技术有限公司 | A kind of data traceability method and device |
| CN112337099A (en) * | 2020-10-27 | 2021-02-09 | 腾讯科技（北京）有限公司 | Service management method and device |
| CN113392105A (en) * | 2021-05-24 | 2021-09-14 | 国网河北省电力有限公司衡水供电分公司 | Service data processing method and terminal equipment |
| CN113903421A (en) * | 2021-10-11 | 2022-01-07 | 上海柯林布瑞信息技术有限公司 | Method and device for rapidly processing medical scientific research form data |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060271390A1 (en) * | 2005-03-03 | 2006-11-30 | Alan Rich | Integrated system, tools, and methods for designing automated business process applications |
| CN101706800A (en) * | 2009-11-23 | 2010-05-12 | 金蝶软件（中国）有限公司 | Finding method and system of associated invoice |
| CN101894149A (en) * | 2010-06-23 | 2010-11-24 | 畅捷通软件有限公司 | Method and device for tracking and inquiring document |
| CN102236662A (en) * | 2010-04-23 | 2011-11-09 | 广州市西美信息科技有限公司 | Database query and control method |
| CN102646111A (en) * | 2012-02-16 | 2012-08-22 | 中国测绘科学研究院 | Knowledge base-based fast construction method of common correlation information query tree |
| CN102945271A (en) * | 2012-10-31 | 2013-02-27 | 南京国图信息产业股份有限公司 | Simplified storing and backtracking method for several times of historical relation changes of single land parcel |
-
2014
- 2014-12-12 CN CN201410761795.8A patent/CN104408171B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060271390A1 (en) * | 2005-03-03 | 2006-11-30 | Alan Rich | Integrated system, tools, and methods for designing automated business process applications |
| CN101706800A (en) * | 2009-11-23 | 2010-05-12 | 金蝶软件（中国）有限公司 | Finding method and system of associated invoice |
| CN102236662A (en) * | 2010-04-23 | 2011-11-09 | 广州市西美信息科技有限公司 | Database query and control method |
| CN101894149A (en) * | 2010-06-23 | 2010-11-24 | 畅捷通软件有限公司 | Method and device for tracking and inquiring document |
| CN102646111A (en) * | 2012-02-16 | 2012-08-22 | 中国测绘科学研究院 | Knowledge base-based fast construction method of common correlation information query tree |
| CN102945271A (en) * | 2012-10-31 | 2013-02-27 | 南京国图信息产业股份有限公司 | Simplified storing and backtracking method for several times of historical relation changes of single land parcel |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105046414A (en) * | 2015-06-29 | 2015-11-11 | 用友优普信息技术有限公司 | Business tracing method and business tracing device applied to ERP systems |
| CN105046415A (en) * | 2015-06-29 | 2015-11-11 | 用友优普信息技术有限公司 | Document joint-check method and document joint-check device |
| CN110019182B (en) * | 2017-08-15 | 2023-11-17 | 华为技术有限公司 | Data tracing method and device |
| CN110019182A (en) * | 2017-08-15 | 2019-07-16 | 华为技术有限公司 | A kind of data traceability method and device |
| CN107833024A (en) * | 2017-11-24 | 2018-03-23 | 江苏中威科技软件系统有限公司 | Retroactive method is signed in the visualization of flow |
| CN108062255A (en) * | 2018-01-08 | 2018-05-22 | 东莞嘉泰钟表有限公司 | One kind is mutually related method for module in production management |
| CN108288147A (en) * | 2018-01-08 | 2018-07-17 | 东莞嘉泰钟表有限公司 | A kind of quick-searching and input control method for production management |
| CN109377159A (en) * | 2018-09-19 | 2019-02-22 | 成都信息工程大学 | A kind of software modeling procedure incarnation evolution system and method, processor, terminal |
| CN109542947A (en) * | 2018-10-29 | 2019-03-29 | 金蝶软件（中国）有限公司 | Data statistical approach, device, computer equipment and storage medium |
| CN109542947B (en) * | 2018-10-29 | 2020-12-29 | 金蝶软件（中国）有限公司 | Data statistical method, device, computer equipment and storage medium |
| CN112337099A (en) * | 2020-10-27 | 2021-02-09 | 腾讯科技（北京）有限公司 | Service management method and device |
| CN112337099B (en) * | 2020-10-27 | 2024-01-12 | 腾讯科技（北京）有限公司 | Service management method and device |
| CN113392105A (en) * | 2021-05-24 | 2021-09-14 | 国网河北省电力有限公司衡水供电分公司 | Service data processing method and terminal equipment |
| CN113903421A (en) * | 2021-10-11 | 2022-01-07 | 上海柯林布瑞信息技术有限公司 | Method and device for rapidly processing medical scientific research form data |
| CN113903421B (en) * | 2021-10-11 | 2022-04-12 | 上海柯林布瑞信息技术有限公司 | Method and device for rapidly processing medical scientific research form data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104408171B (en) | 2019-03-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104408171A (en) | Receipt sub-table row-correlated query device and method | |
| US11631124B1 (en) | System and method of mapping product attributes between different schemas | |
| US9317557B2 (en) | Answering relational database queries using graph exploration | |
| US20190095395A1 (en) | Systems and methods for querying databases | |
| US9218409B2 (en) | Method for generating and using a reusable custom-defined nestable compound data type as database qualifiers | |
| US9495475B2 (en) | Method of representing an XML schema definition and data within a relational database management system using a reusable custom-defined nestable compound data type | |
| CN105183735A (en) | Data query method and query device | |
| CN103177329B (en) | Rule-based determination and checking in business object processing | |
| US20100131568A1 (en) | System, method and structures for a reusable custom-defined nestable compound data type for construction of database objects | |
| CN109710618A (en) | The mixing storage method and system of knowledge mapping data relationship separation | |
| JP7141270B2 (en) | Database search system and method | |
| US20130238549A1 (en) | Using Dimension Substitutions in OLAP Cubes | |
| CN102591952A (en) | Data query device and data query method based on semanteme | |
| CN103186628B (en) | A kind of mapping method between common information model and relevant database | |
| US10360232B2 (en) | Semantic mapping of data from an entity-relationship model to a graph-based data format to facilitate simplified querying | |
| US20100131565A1 (en) | Method for creating a self-configuring database system using a reusable custom-defined nestable compound data type | |
| CN101609473A (en) | A kind of method of Structured Query Language (SQL) of reconstruct report query and device | |
| CN105975489A (en) | Metadata-based online SQL code completion method | |
| Chitti et al. | Data management: Relational vs blockchain databases | |
| CN101645062B (en) | Report form generation method and system | |
| CN102253967A (en) | Data searching system and data searching method | |
| CN104050264A (en) | Method and device for generating SQL statement | |
| CN104268191A (en) | Document display method and device | |
| Lee et al. | Research trend analysis for sustainable qr code use-focus on big data analysis | |
| CN101840427A (en) | Data processing method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Applicant after: Yonyou Network Technology Co., Ltd. Address before: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Applicant before: UFIDA Software Co., Ltd. |
|
| COR | Change of bibliographic data | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |