CN110413665A - A kind of data query method and device - Google Patents
A kind of data query method and device Download PDFInfo
- Publication number
- CN110413665A CN110413665A CN201910586489.8A CN201910586489A CN110413665A CN 110413665 A CN110413665 A CN 110413665A CN 201910586489 A CN201910586489 A CN 201910586489A CN 110413665 A CN110413665 A CN 110413665A
- Authority
- CN
- China
- Prior art keywords
- information
- paying taxes
- node
- invoice
- making out
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/123—Tax preparation or submission
Abstract
The embodiment of the invention provides a kind of data query method and devices, are related to technical field of data processing, wherein the above method includes: the acquisition side of paying taxes information;Inquiry includes the relational graph of the side's of paying taxes information obtained in chart database, obtains the first relational graph, wherein the relational graph that the chart database is used to store each side of paying taxes between item of making out an invoice;Obtain the information of making out an invoice for including in first relational graph;Inquiry includes the relational graph of information obtained of making out an invoice in the chart database, as query result.Data query is carried out using scheme provided in an embodiment of the present invention, richer query result can be obtained.
Description
Technical field
The present invention relates to technical field of data processing, more particularly to a kind of data query method and device.
Background technique
With the use of the tax information system, staff can pass through the tax of tax information system quick search to taxpayer
Business information.In the prior art, after staff inputs this inquiry target of taxpayer in the query window of the tax information system,
Above system inquires the invoice data being stored in relevant database according to above-mentioned inquiry target, obtains inquiry knot
Fruit.Since the tax information of taxpayer is stored in relevant database in the form of relation table, i.e., each taxpayer is corresponding
The unique relationships table in relevant database, so this inquiry mode can only inquire the tax of the taxpayer as inquiry target
Business information, causes query result single.
Summary of the invention
The embodiment of the present invention is designed to provide a kind of data query method and device, to enrich query result.Body
Technical solution is as follows:
In a first aspect, the embodiment of the invention provides a kind of data query methods, which comprises
The acquisition side of paying taxes information;
Inquiry includes the relational graph of the side's of paying taxes information obtained in chart database, obtains the first relational graph, wherein institute
State relational graph of the chart database for storing each side of paying taxes between item of making out an invoice;
Obtain the information of making out an invoice for including in first relational graph;
Inquiry includes the relational graph of information obtained of making out an invoice in the chart database, as query result.
In one embodiment of the present of invention, at least one of the described side's of paying taxes information, including following information:
The side's of paying taxes identifier, the side's of paying taxes title, the mark of node corresponding to the side of paying taxes.
In one embodiment of the present of invention, the method also includes:
Determine the side's of the paying taxes information for including in the query result and information of making out an invoice;
Creation indicates first kind node and the second class node, wherein the first kind node are as follows: expression determines the side of paying taxes
The node of the corresponding side of paying taxes of information, the second class node are as follows: indicate to determine the section of the corresponding item of making out an invoice of information of making out an invoice
Point;
According to the query result, for each first kind node, determine that there are the second of relationship with the first kind node
Class node;
The relationship between first kind node and the second class node is indicated with the straight line with arrow, generates reflection first kind section
The figure of point and the second class node relationships;
Show figure generated.
In one embodiment of the present of invention, after showing figure generated, further includes:
It detects in figure generated with the presence or absence of the information in selected state;
If it is, showing the selected corresponding side of paying taxes of interior joint or item of making out an invoice in the case where chosen information is node
Details;In the case where chosen information is the straight line with arrow, shows and reflect the first of chosen straight line connection
The details of relationship between class node and the second class node.
In one embodiment of the present of invention, the corresponding side's of paying taxes information in each relational graph in the chart database is opened
The information of relationship is stored between ticket item information and the expression side of paying taxes and item of making out an invoice with structured form.
In one embodiment of the present of invention, the method also includes:
After the information of the side of paying taxes described in acquisition, start timing;
After obtaining the query result, terminate timing, it is time-consuming that timing duration is determined as inquiry;
Show that the inquiry is time-consuming.
Second aspect, the embodiment of the invention provides a kind of data query device, described device includes:
The first information obtains module, for obtaining the side's of paying taxes information;
First relational graph enquiry module, for relationship of the inquiry comprising the side's of paying taxes information obtained in chart database
Figure, obtains the first relational graph, wherein the relational graph that the chart database is used to store each side of paying taxes between item of making out an invoice;
Second information acquisition module, for obtaining the information of making out an invoice for including in first relational graph;
Query result enquiry module, for relationship of the inquiry comprising information obtained of making out an invoice in the chart database
Figure, as query result.
In one embodiment of the present of invention, at least one of the described side's of paying taxes information, including following information:
The side's of paying taxes identifier, the side's of paying taxes title, the mark of node corresponding to the side of paying taxes.
In one embodiment of the present of invention, described device further includes query result display module:
The query result display module, comprising:
Information determination unit, for determining the side's of the paying taxes information for including in the query result and information of making out an invoice;
Node creating unit indicates first kind node and the second class node for creating, wherein the first kind node
Are as follows: it indicates to determine the node of the corresponding side of paying taxes of the side's of paying taxes information, the second class node are as follows: expression determines item letter of making out an invoice
Cease the node of corresponding item of making out an invoice;
Relation determination unit, for according to the query result, for each first kind node, determination and the first kind section
There are the second class nodes of relationship for point;
Graphics generation unit, for indicating the pass between first kind node and the second class node with the straight line with arrow
System generates the figure of reflection first kind node and the second class node relationships;
Figure display unit, for showing figure generated.
In one embodiment of the present of invention, after query result display module, further includes:
State detection module, for detecting in figure generated with the presence or absence of the information in selected state;
If it is, showing the selected corresponding side of paying taxes of interior joint or item of making out an invoice in the case where chosen information is node
Details;In the case where chosen information is the straight line with arrow, shows and reflect the first of chosen straight line connection
The details of relationship between class node and the second class node.
In one embodiment of the present of invention,
The corresponding side's of paying taxes information, information of making out an invoice and the expression side of paying taxes in each relational graph in the chart database
The information of relationship is stored between item of making out an invoice with structured form.
In one embodiment of the present of invention, described device further includes time-consuming display module:
The time-consuming display module, comprising:
Start timing unit, after the information of the side of paying taxes described in acquisition, starts timing;
Terminate timing unit, for terminating timing after obtaining the query result, timing duration is determined as inquiry consumption
When;
Time-consuming display unit, for showing that the inquiry is time-consuming.
The third aspect, the embodiment of the invention provides a kind of electronic equipment, including processor, communication interface, memory and
Communication bus, wherein processor, communication interface, memory complete mutual communication by communication bus;
Memory, for storing computer program;
Processor when for executing the program stored on memory, realizes method and step described in above-described embodiment.
Fourth aspect, the embodiment of the invention provides a kind of computer readable storage medium, the computer-readable storage
Dielectric memory contains computer program, and the computer program realizes that method described in above-described embodiment walks when being executed by processor
Suddenly.
5th aspect, the embodiment of the invention also provides a kind of computer program products comprising instruction, when it is being calculated
When being run on machine, so that computer executes any of the above-described data query method.
As seen from the above, when carrying out data query using scheme provided in an embodiment of the present invention, the side's of paying taxes information is obtained;In
Inquiry includes the relational graph of the side's of paying taxes information obtained in chart database, obtains the first relational graph, wherein above-mentioned chart database
Relational graph for storing each side of paying taxes between item of making out an invoice;Obtain the information of making out an invoice for including in above-mentioned first relational graph;
Inquiry includes the relational graph of information obtained of making out an invoice in above-mentioned chart database, as query result.
The query process for obtaining above-mentioned first relational graph is known as one layer of inquiry, the query process for obtaining query result is known as
Two layers of inquiry.By above-mentioned querying method, more further two layers of inquiry is carried out on the basis of completing one layer of inquiry, simultaneously
The first relational graph is not only obtained, the relational graph in above-mentioned chart database comprising above-mentioned information of making out an invoice also is obtained, so the program
Query hierarchy it is deeper, query result is richer.
Certainly, implement any of the products of the present invention or method it is not absolutely required at the same reach all the above excellent
Point.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention for those of ordinary skill in the art without creative efforts, can be with
It obtains other drawings based on these drawings.
Fig. 1 is a kind of flow diagram of data query method provided in an embodiment of the present invention;
Fig. 2 is a kind of schematic diagram of the side's of paying taxes information provided in an embodiment of the present invention;
Fig. 3 is a kind of schematic diagram of first relational graph provided in an embodiment of the present invention;
Fig. 4 is the flow diagram of another data query method provided in an embodiment of the present invention;
Fig. 5 is a kind of schematic diagram of query result provided in an embodiment of the present invention;
Fig. 6 is a kind of structural schematic diagram of data query device provided in an embodiment of the present invention;
Fig. 7 is the structural schematic diagram of another data query device provided in an embodiment of the present invention;
Fig. 8 is the structural schematic diagram of a kind of electronic equipment provided in an embodiment of the present invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall within the protection scope of the present invention.
The embodiment of the invention discloses a kind of data query method and devices, are described in detail separately below.
Referring to Fig. 1, Fig. 1 is a kind of flow diagram of data query method provided in an embodiment of the present invention, this method packet
Include following steps 101-104.
Step 101, the side's of paying taxes information is obtained.
In this step, the side of paying taxes refers to directly dutiable unit or individual.
The side's of paying taxes information refers to the flag information that can represent the side of paying taxes.Since the side's of paying taxes information can represent the side of paying taxes, institute
It can be as the foundation inquired using the above-mentioned side's of paying taxes information.
In one embodiment of the present of invention, the above-mentioned side's of paying taxes information may include at least one of following information: pay taxes
Square identifier, the side's of paying taxes title, the mark of node corresponding to the side of paying taxes.
In the embodiment of the present invention, the related side's of paying taxes information, the invoice informations such as information of making out an invoice are stored in diagram data
In library.Wherein, the relational graph that chart database is used to store the side of paying taxes between item of making out an invoice.The above-mentioned side of paying taxes and Xiang Tu number of making out an invoice
Exist according in library in the form of " node ", is that information institute, the side of paying taxes is right respectively it is, including two class nodes in above-mentioned relation figure
The node for the side of paying taxes answered and making out an invoice is made out an invoice the node of item corresponding to information.
Wherein, node ID will be generated according to the side of paying taxes corresponding to the node for the node of the above-mentioned side of paying taxes
(Identity document identity recognition number).
The process for obtaining the side's of paying taxes information is illustrated below with reference to Fig. 2.
Referring to fig. 2, it is shown in Fig. 2 there are four rectangle frame, wherein three length are identical and are respectively provided with " taxpayer's identification
Number ", " taxpayer's title ", " node ID " printed words rectangle frame for inputting the side's of paying taxes information, length is shorter in figure and has
The rectangle frame of " inquiry " printed words is inquiry button.User's any rectangle frame input in the identical rectangle frame of above three length is received
After tax side's information, inquiry button can be clicked, such electronic equipment can obtain the side's of paying taxes information that user is inputted.For example,
After user inputs " 124674288 " in the rectangle frame with " node ID " printed words, inquiry button is clicked, what electronic equipment obtained
It is the side's of paying taxes information that node ID is 124674288.
Step 102, relational graph of the inquiry comprising the side's of paying taxes information obtained in chart database, obtains the first relationship
Figure.
Wherein, the relational graph that above-mentioned chart database is used to store each side of paying taxes between item of making out an invoice.Relational graph be for
The relationship between the side of paying taxes and item of making out an invoice is described, includes the side's of paying taxes information, information of making out an invoice and the expression side of paying taxes in relational graph
The information of relationship between item of making out an invoice.
In addition to this, the above-mentioned side of paying taxes and item of making out an invoice can be indicated in chart database in the form of " node ", or more
Stating relational graph can be by between the corresponding node in the side of paying taxes and the corresponding node description side of paying taxes of item of making out an invoice and item of making out an invoice
Relationship.
Item of making out an invoice is the project that can be issued when issuing invoice.
Specifically, the process that above-mentioned inquiry obtains the first relational graph can be known as to one layer of inquiry.
In one embodiment of the present of invention, above-mentioned chart database can be JanusGraph chart database.It is above-mentioned to make
JanusGraph chart database operates normally, and needs first to construct a distributed structure/architecture, for example, Spark framework.Then,
JanusGraph chart database is run in above-mentioned distributed structure/architecture, and in addition to this, above-mentioned JanusGraph chart database can be with
Data storage is realized based on HBase.
It is illustrated below with reference to the result that Fig. 3 inquires one layer.
The query result for carrying out one layer of inquiry and obtaining is shown referring to Fig. 3, Fig. 3.Search includes node in chart database
ID be 124674288 relational graph, after obtaining the first relational graph, the side of paying taxes involved in available each first relational graph with
And item of making out an invoice, the corresponding node in the obtained side of paying taxes node corresponding with item of making out an invoice is as shown in encircled in Fig. 3.
Step 103, the information of making out an invoice for including in above-mentioned first relational graph is obtained.
Since relational graph is the relationship for describing the side of paying taxes between item of making out an invoice, and above-mentioned first relational graph may be
One is also likely to be multiple, so, can be determined from above-mentioned first relational graph the side's of paying taxes information and at least one make out an invoice
Item information.And may have duplicate information of making out an invoice in these information of making out an invoice, after the duplicate information of making out an invoice of removal
Resulting information of making out an invoice can be used as this step information of making out an invoice to be obtained.
Step 104, relational graph of the inquiry comprising information obtained of making out an invoice in above-mentioned chart database, is tied as inquiry
Fruit.
Specifically, the inquiry relational graph process referred in this step can be known as two layers of query process.
In one embodiment of the present of invention, other than obtaining the side's of paying taxes information, querying condition can also be obtained.Above-mentioned inquiry
Condition refers to the information that can be used for being screened to query result, can be " income is similar ", " pin item similar " or " into pin item phase
One of like ".
For example, the querying condition obtained is " income is similar ", above-mentioned query result is screened, the inquiry knot after screening
Income relationship is only existed between the side of paying taxes that relational graph in fruit includes and item of making out an invoice.
Obtaining query condition information is " pin item is similar ", is screened to above-mentioned query result, the query result after screening
In the relational graph side of paying taxes for including and only exist pin n-th-trem relation n between item of making out an invoice.
Obtaining query condition information is " similar into pin item ", is screened to above-mentioned query result, the inquiry knot after screening
Both there is income relationship between the side of paying taxes that relational graph in fruit includes and item of making out an invoice, there is also pin n-th-trem relation ns.
As it can be seen that looking into for above-mentioned first relational graph will be obtained when carrying out data query using scheme provided by the above embodiment
Inquiry process is known as one layer of inquiry, and the query process for obtaining query result is known as two layers of inquiry.By above-mentioned querying method, complete
More further two layers of inquiry is carried out on the basis of one layer of inquiry, while not only obtaining the first relational graph, also obtains above-mentioned figure
It include the relational graph of above-mentioned information of making out an invoice in database, so the query hierarchy of the program is deeper, query result is richer.
Referring to fig. 4, Fig. 4 is the flow diagram of another data query method provided in an embodiment of the present invention, and above-mentioned
Embodiment illustrated in fig. 1 is compared, and 105-109 can also be included the following steps in the present embodiment.
Step 105, the side's of the paying taxes information for including in above-mentioned query result is determined and information of making out an invoice.
Since include in above-mentioned query result is relational graph, and relational graph is for describing between the side of paying taxes and item of making out an invoice
The information of relationship.Therefore, the side of paying taxes can be determined from the relational graph that above-mentioned query result is included and item of making out an invoice, determined
The side of paying taxes between may have the duplicate side of paying taxes, may also can have duplicate make out an invoice in the item of making out an invoice determined
, therefore, the information of the information of the side of paying taxes after removal duplicate message and item of making out an invoice can be determined as this step
The side's of paying taxes information and make out an invoice information.
Step 106, creation indicates first kind node and the second class node.
Wherein, above-mentioned first kind node are as follows: indicate to determine the node of the corresponding side of paying taxes of the side's of paying taxes information, above-mentioned second
Class node are as follows: indicate to determine the node of the corresponding item of making out an invoice of information of making out an invoice.
Specifically, when creating node, the node of the corresponding side of paying taxes of each side's of paying taxes information, likewise, each open
Ticket item information also corresponds to the node of an item of making out an invoice.Such as: it determines comprising the side's of paying taxes information A and B in query result, item of making out an invoice letter
C and D is ceased, two first kind nodes 1 and 2 are created, creates two the second class nodes 3 and 4, the side's of paying taxes information A corresponding node 1 is received
Tax side's information B corresponding node 2, an information C corresponding node 3 of making out an invoice, an information D corresponding node 4 of making out an invoice.Meanwhile for the ease of area
Point, different colors different nodes can be arranged.
Step 107, determining to there is pass with the first kind node for each first kind node according to above-mentioned query result
Second class node of system.
Specifically, first according to make out an invoice information and the side's of the paying taxes information for including in the relational graph of query result, and indicate
The information of relationship between the side of paying taxes and item of making out an invoice, the determining and side's of paying taxes information are further determined that there are the information of making out an invoice of relationship
There are the corresponding nodes of making out an invoice of the information of making out an invoice of relationship for the node of the side of paying taxes corresponding with the above-mentioned side's of paying taxes information.Due to,
First kind node are as follows: indicate to determine the node of the corresponding side of paying taxes of the side's of paying taxes information, above-mentioned second class node are as follows: indicate institute really
Surely the node of the corresponding item of making out an invoice of information of making out an invoice, it is possible to determine that there are the second class sections of relationship with the first kind node
Point.
In one embodiment of the present of invention, it is determining with each first kind node there are when the second class node of relationship, can be with
According to query result relational graph in include the side's of paying taxes information with make out an invoice between information, and the side of paying taxes and item of making out an invoice into
Pin relationship, the determining information of making out an invoice existed with the side's of paying taxes information into pin relationship, further determines that and the above-mentioned side's of paying taxes information pair
There is the corresponding node of making out an invoice of information of making out an invoice into pin relationship in the node for the side of paying taxes answered.The node of the above-mentioned side of paying taxes is the
A kind of node, the node of above-mentioned item of making out an invoice are the second class node, determining the second class existed with the first kind node into pin relationship
Node.
Step 108, the relationship between first kind node and the second class node is indicated with the straight line with arrow, generates reflection
The figure of first kind node and the second class node relationships.
Specifically, determining first kind node and with the first kind node there are after the second class node of relationship, Ke Yiyong
Straight line with the arrow indicates the information of relationship between the side of paying taxes for including and item of making out an invoice in relational graph.Wherein, in relational graph
The difference of relationship between the side of paying taxes and item of making out an invoice can pass through the different expressions of direction of arrow.
During of the invention one implements, it is determined that with the first kind node there are after the second class node of relationship, with band
The straight line of arrow indicates in relational graph between the side of paying taxes for including and item of making out an invoice into pin relationship: with the straight line with arrow from second
Class node is directed toward first kind node, and mark " jx " indicates that relationship is that income closes between the side of paying taxes and item of making out an invoice on this line
System;It is directed toward the second class node from first kind node with the straight line with arrow, and mark " xx " indicates the side of paying taxes on this line
Relationship is pin n-th-trem relation n between item of making out an invoice.
Step 109, figure generated is shown.
Specifically, can be shown by the Visualization Platform put up for figure generated.
Figure generated is illustrated below with reference to Fig. 5.
Referring to Fig. 5, the lower left corner of the image in Fig. 5 shows figure generated.There are 8 nodes and 16 in the figure
Straight line with arrow, wherein " id " means that the node ID for the side of paying taxes, and the node marked as 1 indicates that ID is 124674288
The side's of paying taxes information is properly termed as the target side of paying taxes node, and 4 nodes marked as 2,3,4 and 5 are paying taxes with target of inquiring
The node of making out an invoice that income relationship is only existed between Fang Jiedian, 3 nodes marked as 6,7 and 8 are made out an invoice according to obtained
Node and income relationship is only existed between an above-mentioned node of making out an invoice, the others side of the paying taxes node inquired can claim
For the query result side of paying taxes node.16 straight lines with arrow are to be directed toward the side's of paying taxes node from a node of making out an invoice, and all mark
Note is " jx ", indicates to only exist income relationship between the side's of paying taxes node and a node of making out an invoice.
In one embodiment of the present of invention, after showing figure generated, further includes:
It detects in figure generated with the presence or absence of the information in selected state;
If it is, showing the selected corresponding side of paying taxes of interior joint or item of making out an invoice in the case where chosen information is node
Details;In the case where chosen information is the straight line with arrow, shows and reflect the first of chosen straight line connection
The details of relationship between class node and the second class node.
Specifically, by node and straight line gernertion figure with the arrow, figure interior joint generated and with the arrow is detected
Straight line whether be in selected state, show the details for including in the information in selected state.If the side of paying taxes
Node is in selected state, shows the details for the side of paying taxes;If the node for item of making out an invoice is in selected state, displaying is made out an invoice
The details of item;If straight line with the arrow is in selected state, the first kind node for reflecting chosen straight line connection is shown
And second relationship between class node details.
The details for including in the information in selected state are illustrated below with reference to Fig. 5.
Selected state is in referring to Fig. 5, in Fig. 5 is the target side of paying taxes node, Item Info (the project letter on right side
Breath) in the information that is shown be the target side of paying taxes details, Key (key) indicates that main info class, Key are corresponding
Value (value) indicates the specific value that the info class includes.Wherein, " id " corresponds to " 124674288 ", " label (mark
Label) " correspond to " tax_idetity (tax identification) ", " sbh (Taxpayer Identification Number) " corresponds to
" 913304216923855287 ", " name (name) " correspond to " XXXX dress ornament Co., Ltd ", and " dah (area code) " is corresponding
In " 39 ", it is right that " bulkLoader.vertex.id (delivery node number) " corresponds to " 579976 " and " zgdm (management position) "
Ying Yu " 999 ".The details that the embodiment of the present invention only includes in information of the explanation in selected state by taking Fig. 5 as an example,
Text in figure is ceased as just letter is aided in illustrating, and does not have actual meaning.
In one embodiment of the present of invention, the corresponding side's of paying taxes information in each relational graph in above-mentioned chart database is opened
The information of relationship is stored between ticket item information and the expression side of paying taxes and item of making out an invoice with structured form.Showing above-mentioned detailed letter
It is also to be shown in the form of structuring, while the information of structured form storage can be used as an entirety and be replicated when breath.
Specifically, above-mentioned shown details include but is not limited to following data:
Invoice codes, invoice number, invoicing time, the amount of money, the amount of tax to be paid, the side's of paying taxes identifier, taxpayer's title, electronic record
Number, the side's of paying taxes qualification code, the side's of paying taxes state code, method relationship, financial administrator's relationship, the side of paying taxes main management item sale
Information with into purchase project information.
In one embodiment of the present of invention, after obtaining the above-mentioned side's of paying taxes information, start timing;Obtaining above-mentioned inquiry knot
After fruit, terminate timing, it is time-consuming that timing duration is determined as inquiry;Show that above-mentioned inquiry is time-consuming.
Specifically, starting timing to query process after obtaining the above-mentioned side's of paying taxes information, above-mentioned query result is being obtained
Afterwards, timing is terminated to query process, the duration of timing is determined as inquiry time-consuming, above-mentioned inquiry consumption is shown on Visualization Platform
When.Referring to Fig. 5, a rectangle frame is arranged at the top in Fig. 5 in query result, and " this inquiry is 0 point time-consuming for display in the rectangle frame
1 second 20 milliseconds " indicate that current input ID is 124674288 and querying condition is " income is similar ", obtain spent by query result
Duration be 1 second 20 milliseconds.
As it can be seen that data query is carried out using the scheme that the embodiment of the present invention provides, when query result is shown, by making
With node and the straight line with arrow shows the side's of paying taxes information, information of making out an invoice and the relationship that indicates the side of paying taxes between item of making out an invoice
Information, so that the displaying of query result seems intuitive, succinct.
Corresponding with above-mentioned data query method, the embodiment of the invention also provides a kind of data query devices.
Referring to Fig. 6, a kind of structural schematic diagram of data query device is provided, which includes:
The first information obtains module 601, for obtaining the side's of paying taxes information;
First relational graph enquiry module 602, for pass of the inquiry comprising the side's of paying taxes information obtained in chart database
System's figure, obtains the first relational graph, wherein the relational graph that the chart database is used to store each side of paying taxes between item of making out an invoice;
Second information acquisition module 603, for obtaining the information of making out an invoice for including in first relational graph;
Query result enquiry module 604, for inquiring in the chart database comprising information obtained of making out an invoice
Relational graph, as query result.
In one embodiment of the present of invention, at least one of the described side's of paying taxes information, including following information:
The side's of paying taxes identifier, the side's of paying taxes title, the mark of node corresponding to the side of paying taxes.
As it can be seen that above-mentioned first relational graph will be obtained when carrying out data query using scheme provided in an embodiment of the present invention
Query process is known as one layer of inquiry, and the query process for obtaining query result is known as two layers of inquiry.By above-mentioned querying method, complete
It is inquired at carrying out more further two layers on the basis of one layer of inquiry, while not only obtaining the first relational graph, also obtained above-mentioned
It include the relational graph of above-mentioned information of making out an invoice in chart database, so the query hierarchy of the program is deeper, query result is richer.
In one embodiment of the present of invention, referring to Fig. 7, the structural schematic diagram of another data query device, phase are provided
For above-mentioned embodiment illustrated in fig. 6, in the present embodiment, above-mentioned data query device can also include query result display module
605;
The query result display module 605, comprising:
Information determination unit, for determining the side's of the paying taxes information for including in the query result and information of making out an invoice;
Node creating unit indicates first kind node and the second class node for creating, wherein the first kind node
Are as follows: it indicates to determine the node of the corresponding side of paying taxes of the side's of paying taxes information, the second class node are as follows: expression determines item letter of making out an invoice
Cease the node of corresponding item of making out an invoice;
Relation determination unit, for according to the query result, for each first kind node, determination and the first kind section
There are the second class nodes of relationship for point;
Graphics generation unit, for indicating the pass between first kind node and the second class node with the straight line with arrow
System generates the figure of reflection first kind node and the second class node relationships;
Figure display unit, for showing figure generated.
In one embodiment of the present of invention, the method also includes: state detection module;
The state detection module, for detecting in figure generated with the presence or absence of the information in selected state;
If it is, showing the selected corresponding side of paying taxes of interior joint or item of making out an invoice in the case where chosen information is node
Details;In the case where chosen information is the straight line with arrow, shows and reflect the first of chosen straight line connection
The details of relationship between class node and the second class node.
In one embodiment of the present of invention, the corresponding side's of paying taxes information in each relational graph in the chart database is opened
The information of relationship is stored between ticket item information and the expression side of paying taxes and item of making out an invoice with structured form.
In one embodiment of the present of invention, described device further include: time-consuming display module;
The time-consuming display module, comprising:
Start timing unit, after the information of the side of paying taxes described in acquisition, starts timing;
Terminate timing unit to be used for after obtaining the query result, terminate timing, timing duration is determined as inquiry consumption
When;
Time-consuming display unit, for showing that the inquiry is time-consuming.
As it can be seen that data query is carried out using the device that the embodiment of the present invention provides, when query result is shown, by making
With node and the straight line with arrow shows the side's of paying taxes information, information of making out an invoice and the relationship that indicates the side of paying taxes between item of making out an invoice
Information, so that the displaying of query result seems intuitive, succinct.
Corresponding with above-mentioned page assembly matching process, the embodiment of the invention also provides a kind of electronic equipment.
Referring to Fig. 8, the structural schematic diagram of a kind of electronic equipment is provided, which includes: processor 801, communication
Interface 802, memory 803 and communication bus 804, wherein processor 801, communication interface 802, memory 803 are total by communication
Line 804 completes mutual communication,
Memory 803, for storing computer program;
Processor 801 when for executing the program stored on memory 803, is realized described in above-mentioned each embodiment
Method and step.
Corresponding with above-mentioned page assembly matching process, the embodiment of the invention also provides a kind of computer-readable storage mediums
Matter, which is characterized in that computer program is stored in the computer readable storage medium, the computer program is by processor
Method and step described in above-mentioned each embodiment is realized when execution.
As it can be seen that the query process for obtaining above-mentioned first relational graph is known as one layer of inquiry, the inquiry of query result is obtained
Journey is known as two layers of inquiry.By above-mentioned querying method, more further two layers are carried out on the basis of completing one layer of inquiry and is looked into
It askes, while not only obtaining the first relational graph, also obtain the relational graph in above-mentioned chart database comprising above-mentioned information of making out an invoice, so
The query hierarchy of the program is deeper, and query result is richer.
The communication bus that above-mentioned electronic equipment is mentioned can be Peripheral Component Interconnect standard (Peripheral Component
Interconnect, PCI) bus or expanding the industrial standard structure (Extended Industry Standard
Architecture, EISA) bus etc..The communication bus can be divided into address bus, data/address bus, control bus etc..For just
It is only indicated with a thick line in expression, figure, it is not intended that an only bus or a type of bus.
Communication interface is for the communication between above-mentioned electronic equipment and other equipment.
Memory may include random access memory (Random Access Memory, RAM), also may include non-easy
The property lost memory (Non-Volatile Memory, NVM), for example, at least a magnetic disk storage.Optionally, memory may be used also
To be storage device that at least one is located remotely from aforementioned processor.
Above-mentioned processor can be general processor, including central processing unit (Central Processing Unit,
CPU), network processing unit (Network Processor, NP) etc.;It can also be digital signal processor (Digital Signal
Processing, DSP), it is specific integrated circuit (Application Specific Integrated Circuit, ASIC), existing
It is field programmable gate array (Field-Programmable Gate Array, FPGA) or other programmable logic device, discrete
Door or transistor logic, discrete hardware components.
In another embodiment provided by the invention, a kind of computer program product comprising instruction is additionally provided, when it
When running on computers, so that computer executes any data querying method in above-described embodiment.
In the above-described embodiments, can come wholly or partly by software, hardware, firmware or any combination thereof real
It is existing.When implemented in software, it can entirely or partly realize in the form of a computer program product.The computer program
Product includes one or more computer instructions.When loading on computers and executing the computer program instructions, all or
It partly generates according to process or function described in the embodiment of the present invention.The computer can be general purpose computer, dedicated meter
Calculation machine, computer network or other programmable devices.The computer instruction can store in computer readable storage medium
In, or from a computer readable storage medium to the transmission of another computer readable storage medium, for example, the computer
Instruction can pass through wired (such as coaxial cable, optical fiber, number from a web-site, computer, server or data center
User's line (DSL)) or wireless (such as infrared, wireless, microwave etc.) mode to another web-site, computer, server or
Data center is transmitted.The computer readable storage medium can be any usable medium that computer can access or
It is comprising data storage devices such as one or more usable mediums integrated server, data centers.The usable medium can be with
It is magnetic medium, (for example, floppy disk, hard disk, tape), optical medium (for example, DVD) or semiconductor medium (such as solid state hard disk
Solid State Disk (SSD)) etc..
It should be noted that, in this document, relational terms such as first and second and the like are used merely to a reality
Body or operation are distinguished with another entity or operation, are deposited without necessarily requiring or implying between these entities or operation
In any actual relationship or order or sequence.Moreover, the terms "include", "comprise" or its any other variant are intended to
Non-exclusive inclusion, so that the process, method, article or equipment including a series of elements is not only wanted including those
Element, but also including other elements that are not explicitly listed, or further include for this process, method, article or equipment
Intrinsic element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that
There is also other identical elements in process, method, article or equipment including the element.
Each embodiment in this specification is all made of relevant mode and describes, same and similar portion between each embodiment
Dividing may refer to each other, and each embodiment focuses on the differences from other embodiments.Especially for device,
For electronic equipment, computer readable storage medium, computer program product embodiments, implement since it is substantially similar to method
Example, so being described relatively simple, the relevent part can refer to the partial explaination of embodiments of method.
The foregoing is merely illustrative of the preferred embodiments of the present invention, is not intended to limit the scope of the present invention.It is all
Any modification, equivalent replacement, improvement and so within the spirit and principles in the present invention, are all contained in protection scope of the present invention
It is interior.
Claims (10)
1. a kind of data query method, which is characterized in that the described method includes:
The acquisition side of paying taxes information;
Inquiry includes the relational graph of the side's of paying taxes information obtained in chart database, obtains the first relational graph, wherein the figure
The relational graph that database is used to store each side of paying taxes between item of making out an invoice;
Obtain the information of making out an invoice for including in first relational graph;
Inquiry includes the relational graph of information obtained of making out an invoice in the chart database, as query result.
2. the method according to claim 1, wherein the side's of paying taxes information, including in following information at least
It is a kind of:
The side's of paying taxes identifier, the side's of paying taxes title, the mark of node corresponding to the side of paying taxes.
3. the method according to claim 1, wherein the method also includes:
Determine the side's of the paying taxes information for including in the query result and information of making out an invoice;
Creation indicates first kind node and the second class node, wherein the first kind node are as follows: expression determines the side's of paying taxes information
The node of the corresponding side of paying taxes, the second class node are as follows: indicate to determine the node of the corresponding item of making out an invoice of information of making out an invoice;
According to the query result, for each first kind node, determine that there are the second class sections of relationship with the first kind node
Point;
Indicates the relationship between first kind node and the second class node with the straight line with arrow, generate reflection first kind node and
The figure of second class node relationships;
Show figure generated.
4. according to the method described in claim 3, it is characterized in that, after showing figure generated, further includes:
It detects in figure generated with the presence or absence of the information in selected state;
If it is, in the case where chosen information is node, the detailed of the selected corresponding side of paying taxes of interior joint or item of making out an invoice is shown
Thin information;In the case where chosen information is the straight line with arrow, the first kind section for reflecting chosen straight line connection is shown
The details of relationship between point and the second class node.
5. the method according to claim 1, wherein
The corresponding side's of paying taxes information in each relational graph in the chart database, information of making out an invoice and indicate the Fang Yukai that pays taxes
The information of relationship is stored between ticket item with structured form.
6. the method according to claim 1, wherein the method also includes:
After the information of the side of paying taxes described in acquisition, start timing;
After obtaining the query result, terminate timing, it is time-consuming that timing duration is determined as inquiry;
Show that the inquiry is time-consuming.
7. a kind of data query device, which is characterized in that described device includes:
The first information obtains module, for obtaining the side's of paying taxes information;
First relational graph enquiry module is obtained for relational graph of the inquiry comprising the side's of paying taxes information obtained in chart database
To the first relational graph, wherein the relational graph that the chart database is used to store each side of paying taxes between item of making out an invoice;
Second information acquisition module, for obtaining the information of making out an invoice for including in first relational graph;
Query result enquiry module, for inquiring the relational graph comprising information obtained of making out an invoice in the chart database,
As query result.
8. device according to claim 7, which is characterized in that the side's of paying taxes information, including in following information at least
It is a kind of:
The side's of paying taxes identifier, the side's of paying taxes title, the mark of node corresponding to the side of paying taxes.
9. a kind of electronic equipment, which is characterized in that including processor, communication interface, memory and communication bus, wherein processing
Device, communication interface, memory complete mutual communication by communication bus;
Memory, for storing computer program;
Processor when for executing the program stored on memory, realizes any method and step of claim 1-6.
10. a kind of computer readable storage medium, which is characterized in that be stored with computer in the computer readable storage medium
Program realizes claim 1-6 any method and step when the computer program is executed by processor.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910586489.8A CN110413665A (en) | 2019-07-01 | 2019-07-01 | A kind of data query method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910586489.8A CN110413665A (en) | 2019-07-01 | 2019-07-01 | A kind of data query method and device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN110413665A true CN110413665A (en) | 2019-11-05 |
Family
ID=68358606
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910586489.8A Pending CN110413665A (en) | 2019-07-01 | 2019-07-01 | A kind of data query method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110413665A (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112232894A (en) * | 2020-10-27 | 2021-01-15 | 江苏税软软件科技有限公司 | Data analysis method based on value-added tax invoice |
CN112527840A (en) * | 2020-12-15 | 2021-03-19 | 航天信息股份有限公司 | Medicine industry two-ticket monitoring method and device, readable medium and electronic equipment |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20120030079A1 (en) * | 2010-07-29 | 2012-02-02 | Accenture Global Services Gmbh | Risk Scoring System And Method For Risk-Based Data Assessment |
CN109558399A (en) * | 2018-11-22 | 2019-04-02 | 北京邮电大学 | A kind of date storage method and device |
CN109582808A (en) * | 2018-11-22 | 2019-04-05 | 北京锐安科技有限公司 | A kind of user information querying method, device, terminal device and storage medium |
CN109885621A (en) * | 2019-01-07 | 2019-06-14 | 北京科技大学 | A kind of data storage entities relational graph extracting method |
-
2019
- 2019-07-01 CN CN201910586489.8A patent/CN110413665A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20120030079A1 (en) * | 2010-07-29 | 2012-02-02 | Accenture Global Services Gmbh | Risk Scoring System And Method For Risk-Based Data Assessment |
CN109558399A (en) * | 2018-11-22 | 2019-04-02 | 北京邮电大学 | A kind of date storage method and device |
CN109582808A (en) * | 2018-11-22 | 2019-04-05 | 北京锐安科技有限公司 | A kind of user information querying method, device, terminal device and storage medium |
CN109885621A (en) * | 2019-01-07 | 2019-06-14 | 北京科技大学 | A kind of data storage entities relational graph extracting method |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112232894A (en) * | 2020-10-27 | 2021-01-15 | 江苏税软软件科技有限公司 | Data analysis method based on value-added tax invoice |
CN112527840A (en) * | 2020-12-15 | 2021-03-19 | 航天信息股份有限公司 | Medicine industry two-ticket monitoring method and device, readable medium and electronic equipment |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US9626176B2 (en) | Update installer with technical impact analysis | |
CN103620588B (en) | Based on browsing activity recognition matching application | |
US9830142B2 (en) | Automatic installation of selected updates in multiple environments | |
US8838610B2 (en) | Listing tune-up system | |
US20150082292A1 (en) | Automatically resolving conflicts after installation of selected updates in a computer system | |
US10026064B2 (en) | Automatically recommending updates based on stored lifecycle information | |
CN106575395A (en) | Entity resolution incorporating data from various data sources | |
JP2007184914A (en) | Method, system and program for comparing topologies (topology comparison) | |
CN105338158B (en) | A kind of method and device of information processing | |
CN108170719A (en) | A kind of search method, server and computer readable storage medium | |
CN110413665A (en) | A kind of data query method and device | |
US20180330427A1 (en) | Automated price rule notification for online consumers | |
US11614951B2 (en) | System for custom validations and scripts for mobile applications | |
JP6298004B2 (en) | Security countermeasure support apparatus and security countermeasure support method | |
JP5514316B2 (en) | Monetization of interactive network-based information objects | |
US20100169226A1 (en) | Method for facilitating the outsourcing of technology services | |
US10157172B2 (en) | Property dependency visualization | |
US20170116643A1 (en) | Alert throttling for product tracking | |
JP2005242904A (en) | Document group analysis device, document group analysis method, document group analysis system, program and storage medium | |
US20150106211A1 (en) | Graphical user interface for advertising system and method relating thereto | |
JP2017199080A (en) | Information processing terminal, information providing device, method for providing information of enterprise, method for providing information to information processing terminal, and program for causing computer to achieve the method | |
EP4027289B1 (en) | Facilitating quick evaluation of trigger conditions for business rules that modify customer-support tickets | |
CN110471730A (en) | Methods of exhibiting, system, big screen system and medium based on Echarts | |
US11500950B2 (en) | Digital search results generation | |
CN113688899A (en) | Data fusion method and device, storage medium and electronic equipment |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20191105 |