CN107402970A - Information generating method and device - Google Patents
Information generating method and device Download PDFInfo
- Publication number
- CN107402970A CN107402970A CN201710515752.5A CN201710515752A CN107402970A CN 107402970 A CN107402970 A CN 107402970A CN 201710515752 A CN201710515752 A CN 201710515752A CN 107402970 A CN107402970 A CN 107402970A
- Authority
- CN
- China
- Prior art keywords
- information
- verification
- analytical processing
- check item
- line analytical
- 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
- 238000000034 method Methods 0.000 title claims abstract description 66
- 238000012795 verification Methods 0.000 claims abstract description 211
- 238000012545 processing Methods 0.000 claims abstract description 124
- 238000004590 computer program Methods 0.000 claims description 7
- 230000004044 response Effects 0.000 claims description 7
- 230000008569 process Effects 0.000 claims description 3
- 238000004364 calculation method Methods 0.000 claims 2
- 238000012423 maintenance Methods 0.000 abstract description 3
- 230000000977 initiatory effect Effects 0.000 description 8
- 238000010586 diagram Methods 0.000 description 7
- 230000002159 abnormal effect Effects 0.000 description 6
- 239000003795 chemical substances by application Substances 0.000 description 5
- 238000012937 correction Methods 0.000 description 3
- 210000004209 hair Anatomy 0.000 description 3
- 238000012360 testing method Methods 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000012800 visualization Methods 0.000 description 2
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 2
- 241000208340 Araliaceae Species 0.000 description 1
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 description 1
- 235000003140 Panax quinquefolius Nutrition 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 235000008434 ginseng Nutrition 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 238000012552 review Methods 0.000 description 1
- 238000012163 sequencing technique Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
-
- 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/23—Updating
- G06F16/2358—Change logging, detection, and notification
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Debugging And Monitoring (AREA)
Abstract
The embodiment of the present invention provides a kind of information generating method and device.Wherein, method includes the steps：Obtain the task configuration information that user inputs by verifying rule configuration list；Obtain the check item in on-line analytical processing form；According to the Table Header information of the on-line analytical processing form, positional information of the check item in the on-line analytical processing form is determined；According to the positional information and the task configuration information, the inquiry verification task inquired about the contents in table of the on-line analytical processing form and verified to contents in table corresponding to the check item is initiated in generation.Technical scheme provided in an embodiment of the present invention is realized simpler and easy to maintenance without entering writing for line program manually.
Description
Technical field
The present invention relates to field of computer technology, more particularly to a kind of information generating method and device.
Background technology
OLAP (Online Analytical Processing on-line analytical processings) tries hard to a large amount of in processing data warehouse
Data, and convert it to useful information, so as to realize conclusion, analysis and the processing to data, help enterprise to complete to determine
Plan.
In the verification of the final output result of olap analysis, the exception for cell or specific targets is found, can be compared with
The quality of data is ensured to be general, inexpensive.Fig. 1 shows the schematic diagram data that olap analysis shows.User exists
Inquiry row content (moving pin rate month to date value, trade company day UV as illustrated in the drawing), row content be have selected (in such as figure：Day, city,
KA labels) and filtering rule after, diagram as shown in Figure 1 can be shown in the user interface.Verification to cell refers to
Verification to being similar to 2 this kind of cell of first module lattice 1 or second unit lattice in figure, can be separately provided data to cell
Verification rule.And the verification to index item is or the dynamic pin rate month to date value index column to such as Tu1Zhong trade companies day UV index
The value of all column unit lattice is required for being verified.
The purpose of setting verification rule be in order to do not met in the value that some cell is found by verifying it is expected or
It was found that the value of a cell in the value or certain a line of a cell in a certain row in some index do not meet it is pre-
During the phase, alarmed.
In the prior art, verification means are realized by way of artificially encoding.It is i.e. artificial for tracking pair
Editor as carrying out verification sentence accordingly, verify rule and define relatively complicated, complexity, and same type verifies regular reusability
Difference.
The content of the invention
Fig. 2 is shown in the prior art to the checking procedure of cell.In the prior art, it is necessary to first be directed to the number to be verified
According to writing a data check SQL (Structured Query Language, SQL) template manually；Then
Define target corresponding to data check SQL templates and be expected codomain；It is then that data check SQL templates and its corresponding target is pre-
Time value domain is registered as routine mission.Generation verification SQL after routine mission succeeds in registration.Verification SQL i.e. can be in preset time point
Or at equal intervals the time operation verification task, with OLAP forms specified object (such as cell item or index item) carry out result
Verification.
As shown in the above, data check task definition is complex in the prior art, for different cells or
Different index item need to write a corresponding data check SQL template manually and manually generate corresponding routine mission, and it is tieed up
Shield property is poor；In addition, because the reusable poor-performing of the extremely strong data check task of existing this specific aim, each verification
Object is required for redefining.
Then, in one embodiment of the invention, there is provided a kind of information generating method.This method includes：Obtain and use
The task configuration information that family is inputted by verifying rule configuration list；Obtain the check item in on-line analytical processing form；According to institute
The Table Header information of on-line analytical processing form is stated, determines position letter of the check item in the on-line analytical processing form
Breath；According to the positional information and the task configuration information, generation is initiated to inquire about the list item of the on-line analytical processing form
Content and the inquiry verification task verified to contents in table corresponding to the check item.
Alternatively, the check item obtained in on-line analytical processing form, including：In on-line analytical processing report display
On interface, display verification control；In response to for a cell in the verification control and the on-line analytical processing form
Sequence trigger switch event, using the cell as the check item.
Alternatively, according to the Table Header information of the on-line analytical processing form, determine the check item at described online point
Positional information in analysis processing form, including：If the Table Header information of the on-line analytical processing form is single-stage gauge outfit, by institute
Absolute row coordinate and absolute ordinate of the check item in the on-line analytical processing form are stated as the positional information；If institute
The Table Header information for stating on-line analytical processing form is multistage gauge outfit, then by the Table Header information corresponding to the check item and described
Opposing rows coordinate or relative row coordinate of the check item in table area where the Table Header information are as the positional information.
Alternatively, the task configuration information for obtaining user and being inputted by verifying rule configuration list, including：In user circle
The verification rule configuration list is shown on face；Receive the task that user is inputted by the verification rule configuration list and match somebody with somebody confidence
Breath；Wherein, comprised at least in the task configuration information：The tasks carrying frequency, verification type information, verification mode and verification ginseng
According to information.
Optionally, above-mentioned method may also include：Initiated when the time interval of tasks carrying frequency setting reaches
The inquiry verification task；Inquired about from the database in cycle time delay of the tasks carrying Delay Rules setting
The contents in table of the on-line analytical processing form；According to verification type information, verification mode and the positional information, from described
At least one contents in table at the positional information is obtained in on-line analytical processing form as at least one of participation verification
Check item numerical value；At least one check item numerical value is handled to obtain the verification mode pair according to the verification mode
The value to be verified answered；The value to be verified is compared with the verification with reference to information, to obtain check results.
Alternatively, also include in the task configuration information：Type of alarm and alarm object；And the above method also wraps
Include：If the check results send alarm to be abnormal, according to the type of alarm to the alarm object.
Alternatively, also include in the task configuration information：Rule state information；And the above method also includes：Using
Whether inquiry verification task can use described in the rule state information flag, be looked into when the verification rule is can use described in initiation
Inquiry task.
Alternatively, the above method may also include：The task configuration information is verified；And
According to the positional information and the task configuration information, generation is initiated to inquire about the on-line analytical processing form
Contents in table and the inquiry verification task verified to contents in table corresponding to the check item, including：
If the task configuration information is by verification, according to the positional information and the task configuration information, generation
Initiate what is inquired about the contents in table of the on-line analytical processing form and contents in table corresponding to the check item is verified
Inquire about verification task.
Alternatively, above-mentioned method may also include：If the task configuration information is not validated, on a user interface
Display does not pass through prompting.
In another embodiment of the present invention, there is provided one kind verification rule generation device.The device includes：The
One acquisition module, the task configuration information inputted for obtaining user by verifying rule configuration list；Second acquisition module, is used for
Obtain the check item in on-line analytical processing form；Determining module, for being believed according to the gauge outfit of the on-line analytical processing form
Breath, determines positional information of the check item in the on-line analytical processing form；Generation module, for according to the position
Information and the task configuration information, generation are initiated to inquire about the contents in table of the on-line analytical processing form and to the verification
The inquiry verification task that contents in table corresponding to is verified.
In another embodiment of the present invention, there is provided a kind of electronic equipment.The electronic equipment includes processor and storage
Device, the memory are used to store one or more computer instruction, and one or more computer instruction is by the processing
Device can realize the step in above- mentioned information generation method when performing.
In another embodiment of the present invention, there is provided a kind of computer-readable storage medium for being stored with computer program
Matter, the step in above- mentioned information generation method can be realized when the computer program is computer-executed.
In technical scheme provided in an embodiment of the present invention, user only need to enter line discipline configuration by verifying rule configuration list,
Realize the visualization of rule configuration so that rule configuration is simpler；Further, since technical side provided in an embodiment of the present invention
Case is the positional information in on-line analytical processing form according to general task configuration information and check item, automatically generates pin
To check item verification rule, wherein task configuration information and positional information are general information, rather than are existed in the prior art
Index item etc. is this corresponding to row and column where specific check item need to be substituted into when writing a data check SQL template manually is directed to
Property extremely strong data, it is this that reusability is had more using the verification rule of general information generation；In addition, the embodiment of the present invention carries
The technical scheme of confession is realized simpler and easy to maintenance without entering writing for line program manually.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are this hairs
Some bright embodiments, for those of ordinary skill in the art, on the premise of not paying creative work, can be with root
Other accompanying drawings are obtained according to these accompanying drawings.
Fig. 1 shows the schematic diagram of an instantiation of on-line analytical processing form；
Fig. 2 shows the product process schematic diagram for verifying SQL in the prior art；
Fig. 3 is the schematic flow sheet for the information generating method that one embodiment of the invention provides；
Fig. 4 is an example of the verification rule configuration list being related in the information generating method that one embodiment of the invention provides
Figure；
Fig. 5 is the schematic diagram of an on-line analytical processing form with single-stage gauge outfit shown in the embodiment of the present invention；
Fig. 6 a are a kind of schematic diagram of on-line analytical processing form with multistage gauge outfit shown in the embodiment of the present invention；
Fig. 6 b have the schematic diagram of the on-line analytical processing form of multistage gauge outfit for the another kind shown in the embodiment of the present invention；
Fig. 7 is the schematic flow sheet for the information generating method that another embodiment of the present invention provides；
Fig. 8 is the structured flowchart for the information generation device that one embodiment of the invention provides；
Fig. 9 is the structured flowchart for the electronic equipment that one embodiment of the invention provides.
Embodiment
In order that those skilled in the art more fully understand the present invention program, below in conjunction with the embodiment of the present invention
Accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described.
In some flows described in the specification, claims and above-mentioned accompanying drawing of the present invention, contain according to spy
Multiple operations that fixed order occurs, these operations can not be performed or performed parallel according to the order that it occurs herein.
The sequence number of operation such as 101,102 etc., it is only used for distinguishing each different operation, it is suitable that sequence number does not represent any execution in itself
Sequence.In addition, these flows can include more or less operations, and these operations can in order be performed or held parallel
OK.It should be noted that the description such as herein " first ", " second ", be for distinguishing different message, equipment, module etc.,
Sequencing is not represented, it is different types also not limit " first " and " second ".
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Site preparation describes.Obviously, described embodiment is only part of the embodiment of the present invention, rather than whole embodiments.It is based on
Embodiment in the present invention, the every other implementation that those skilled in the art are obtained under the premise of creative work is not made
Example, belongs to the scope of protection of the invention.
Fig. 3 shows the schematic flow sheet for the information generating method that one embodiment of the invention provides.It is as shown in figure 1, described
Method includes：
101st, the task configuration information that user inputs by verifying rule configuration list is obtained.
102nd, the check item in on-line analytical processing form is obtained.
103rd, according to the Table Header information of the on-line analytical processing form, determine the check item at the on-line analysis
Manage the positional information in form.
104th, according to the positional information and the task configuration information, generation is initiated to inquire about the on-line analytical processing report
The contents in table of table and the inquiry verification task verified to contents in table corresponding to the check item.
In above-mentioned 101, the displaying of verification rule configuration list on a user interface, at least one is shown in the verification rule configuration list
Individual configuration item is to guide user to insert corresponding task configuration information.A kind of example for verifying rule configuration list is shown in Fig. 4.
Multiple configuration items are shown in the verification rule configuration list, such as：Rule state configuration item, review time, pass through mail box fashion
Send abnormal alarm, make a copy for mailbox list configuration item, monitoring type configuration item, absolute value verification mode and corresponding verification reference
Threshold interval, day ring are than verification mode and corresponding verification with reference to threshold interval and week verification mode and corresponding verification on year-on-year basis
With reference to threshold interval etc..Wherein, these three verifications on year-on-year basis of absolute value, day ring ratio and week are illustrate only in the example shown in Fig. 4
Mode, it substantially can also include all averages, monthly average, on a month-on-month basis etc. verification mode, the embodiment of the present invention and this not made specifically
Limit.
In a kind of achievable technical scheme, above-mentioned steps 101 can be realized in the following way：
S1, the verification rule configuration list is shown on a user interface.
S2, receive the task configuration information that user is inputted by the verification rule configuration list.
Wherein, comprised at least in the task configuration information：The tasks carrying frequency, tasks carrying Delay Rules, verification class
Type information, verification mode and verification are with reference to information etc..
When it is implemented, verification rule configuration list can be shown after the configuration control that user is triggered in user interface；Or
Shown after particular control on user's touch control keyboard；Or shown after the Voice command of user is received.User can be used
The mode of keyboard, touch-screen or voice task configuration information corresponding to each list item input in the verification rule configuration list.
In above-mentioned 102, check item can be that a cell can also be that (i.e. an indication information is corresponding for an index item
Column or row).For cell, the quantity of check item is 1；For index item, check item includes the index item
All cells in corresponding row or column, its quantity is the quantity of all cells in the row or column.
In a kind of achievable technical scheme, how some cell in on-line analytical processing form is confirmed as school
Testing item can realize with the following method：
S1, on on-line analytical processing report display interface, display verification control.
S2, in response to for it is described verification control and the on-line analytical processing form in a cell sequence trigger switch thing
Part, using the cell as the check item.
Said sequence trigger event refers to：After first having the trigger event for verification control, then there is touching for cell
Hair event.Wherein, trigger event can be the clicking operation carried out using mouse, or the clicking operation for using touch-screen to carry out,
Or language in-put operation for passing through microphone etc..Need exist for explanation be：Check item is only listed in the above is
The situation of cell.When check item is index item, user can carry out row or column after the trigger event for verifying control
Trigger event is selected, then all cells in selected row or column are check item.
What the Table Header information of the on-line analytical processing form referred in above-mentioned 103 referred to is exactly the row gauge outfit 20 shown in Fig. 5
With the style information of list first 10.In practical application, the gauge outfit of on-line analytical processing form has single-stage gauge outfit and multistage gauge outfit more
Kind.Single-stage gauge outfit refers to single file gauge outfit and single-row gauge outfit, and on-line analytical processing form as shown in Figure 5 is single-stage gauge outfit report
Table；Multistage gauge outfit refers to include more row-column list heads and/or more row-column list heads, on-line analytical processing report as shown in figure 6 a and 6b
Table is multistage gauge outfit form.Wherein, Fig. 6 a are illustrated that the form of series of rows gauge outfit；Fig. 6 b are illustrated that multistage list head
Form.For single-stage gauge outfit, because the order of each form displaying is changeless, it may appear that list head or row gauge outfit
Between position replacement sequence, will not more have new sequence every time, therefore can be directly by the check item at the on-line analysis
Absolute row coordinate and absolute ordinate in reason form is as the positional information.For some multistage gauge outfits, such as scheme
Form shown in 6a, its row gauge outfit are multistage gauge outfit, and 8.9.1 is the version number using App in row gauge outfit, because APP has more
Newly, the APP of some legacy versions therefore in form will discharge and increase new edition APP gauge outfits, this kind of the more of gauge outfit change occur
Level gauge outfit form, optional Table Header information and relative position are combined as positional information.For example, having shown in Fig. 6 a
The connection of multistage gauge outfit handles analytical statement, and the cell 30 outlined in figure is check item；Gone because list head is single-row gauge outfit
Gauge outfit is series of rows gauge outfit, so the positional information of the check item can be by：Gauge outfit 8.9.1 and flowing water (after preferential) information and table
Row coordinate (the third line down counted from 2017-03-06) in table area where head 8.9.1 and flowing water (preferential after) combines
Form.This absolute coordinate for using Table Header information compared with single-stage gauge outfit with mode that relative position is combined is as positional information
Applicability it is wider.Certainly, for the multilevel report that gauge outfit change will not occur, sat using absolute row coordinate and absolute row
It is also feasible to be denoted as positional information.
As shown in the above, step 103 can be realized specifically with the following method in above-described embodiment：
If the Table Header information of the on-line analytical processing form is single-stage gauge outfit, by the check item at described online point
Absolute row coordinate and absolute ordinate in analysis processing form is as the positional information；
If the Table Header information of the on-line analytical processing form is multistage gauge outfit, by the gauge outfit corresponding to the check item
The opposing rows coordinate or relative row coordinate of information and the check item in table area where the Table Header information are as institute
State positional information.
Further, if the Table Header information of the above-mentioned on-line analytical processing form is multistage gauge outfit, by the verification
The opposing rows coordinate or phase of Table Header information and the check item in table area where the Table Header information corresponding to
To row coordinate as the positional information, following steps are also may particularly include：
If the multistage gauge outfit for stating on-line analytical processing form is series of rows gauge outfit, by the check item column pair
Opposing rows coordinate conduct of the Table Header information and the check item for the series of rows gauge outfit answered in table area where the Table Header information
The positional information；
If the multistage gauge outfit for stating on-line analytical processing form is multistage list head, the check item is expert at pair
Relative row coordinate conduct of the Table Header information and the check item for the multistage list head answered in table area where the Table Header information
The positional information；
If the multistage gauge outfit for stating on-line analytical processing form includes series of rows gauge outfit and multistage list head, by described in
The Table Header information of multistage list head and the check item are in table area where the Table Header information corresponding to check item column
Opposing rows coordinate as the positional information, or by the check item be expert at corresponding to multistage list head Table Header information and
Relative row coordinate of the check item in table area where the Table Header information is as the positional information.
Need exist for explanation be：The above-mentioned multistage gauge outfit that on-line analytical processing form is stated described in includes series of rows gauge outfit
During with multistage list head (form as shown in Figure 6 b), first way is selected to determine positional information, or second of side on earth
Formula determines positional information.Because it is less that more news frequently occurs for the gauge outfit of form, above two in practical application
Mode.But more it is possible that can first judge which multistage gauge outfit easily becomes in series of rows gauge outfit and multistage list head
More, if series of rows gauge outfit easily changes, first way may be selected；If multistage list head easily changes, may be selected
The second way.Wherein, first way is that the above-mentioned gauge outfit by multistage list head corresponding to the check item column is believed
The opposing rows coordinate of breath and the check item in table area where the Table Header information is as the positional information；The second way
It is i.e. above-mentioned by the check item be expert at corresponding to multistage list head Table Header information and the check item in the Table Header information institute
Relative row coordinate in table area is as the positional information.
Understand that task configuration information can include based on the above：The tasks carrying frequency, tasks carrying Delay Rules, school
Type information, verification mode and verification are tested with reference to information etc..Accordingly, can be according to the school in task configuration information in above-mentioned 104
Proved recipe formula and positional information can generate the value rule of check item in inquiry verification task.For example, if verification mode is absolute value
Verification, then value rule is to take monodrome --- table content corresponding to check item；If verification mode be day ring than verification mode,
Value rule, which should be, takes diadic, the current time of table content and the previous day respectively corresponding to the check item at current time
Table content corresponding to check item.Inquiry verification in inquiry verification task can be generated according to task configuration information and initiate rule, school
Test rule, alarm rule etc..Generation inquiry verification task can store in database, with facilitate call realize timing or
The verification of the report query and form check item of constant duration.
In the technical scheme that the present embodiment provides, user only need to enter line discipline configuration by verifying rule configuration list, realize
The visualization of regular configuration so that rule configuration is simpler；Further, since technical scheme provided in an embodiment of the present invention is
According to the positional information of general task configuration information and check item in on-line analytical processing form, automatically generate for school
The verification rule of item is tested, wherein task configuration information and positional information are general information, rather than in the prior art manual
This specific aim pole such as index item corresponding to row and column where specific check item need to be substituted into when writing a data check SQL template
Strong data, it is this that reusability is had more using the verification rule of general information generation；It is in addition, provided in an embodiment of the present invention
Technical scheme is realized simpler and easy to maintenance without entering writing for line program manually.
Further, in above-mentioned and following embodiments, may also include the steps of in the above method：The task is matched somebody with somebody
Confidence breath is verified.Accordingly, above-mentioned steps 104, according to the positional information and the task configuration information, generation is initiated
The inquiry inquired about the contents in table of the on-line analytical processing form and verified to contents in table corresponding to the check item
Verification task, can be specially：
If the task configuration information is by verification, according to the positional information and the task configuration information, generation
Initiate what is inquired about the contents in table of the on-line analytical processing form and contents in table corresponding to the check item is verified
Inquire about verification task.
Further, methods described may also include：If the task configuration information is not validated, in user interface
Upper display does not pass through prompting.
The purpose verified to task configuration information is inputted to verify user by verifying rule configuration list
Whether configuration item meets sets requirement.For example whether mailbox correct, whether time format meets the requirements etc..If verification is not led to
User can be fed back to by the way of display reminding on a user interface by crossing, in order to which user modifies in time.
Fig. 7 shows the schematic flow sheet for the information generating method that another embodiment of the present invention provides.As shown in fig. 7, institute
The method of stating includes：
201st, verification rule configuration list is shown on a user interface.
202nd, the task configuration information that user is inputted by the verification rule configuration list is received.
Wherein, comprised at least in the task configuration information：The tasks carrying frequency, tasks carrying Delay Rules, verification class
Type information, verification mode and verification are with reference to information.
203rd, the check item in on-line analytical processing form is obtained.
204th, according to the Table Header information of the on-line analytical processing form, determine the check item at the on-line analysis
Manage the positional information in form.
205th, according to the positional information and the task configuration information, generation is initiated to inquire about the on-line analytical processing report
The contents in table of table and the inquiry verification task verified to contents in table corresponding to the check item.
206th, the inquiry verification task is stored to database.
207th, the inquiry verification task is initiated when the time interval of tasks carrying frequency setting reaches.
208th, inquired about from the database described in cycle time delay of the tasks carrying Delay Rules setting
The contents in table of on-line analytical processing form.
209th, according to verification type information, verification mode and the positional information, from the on-line analytical processing form
At least one contents in table at the positional information is obtained as at least one check item numerical value for participating in verification.
210th, at least one check item numerical value is handled to obtain the verification mode according to the verification mode
Corresponding value to be verified.
211st, the value to be verified is compared with the verification with reference to information, to obtain check results.
Above-mentioned 201~206 can be found in the corresponding contents in above-described embodiment, and here is omitted.
In above-mentioned 207, verification query task is a task of needing more frequencys to perform.The initiation rule of the task is base
In the tasks carrying frequency generation that user is set.The task frequency is the frequency of tasks carrying, for example, 10 minutes once or half
Hour is once etc..
In above-mentioned 208, cycle time delay of tasks carrying Delay Rules setting here is to ensure that user will inquire about
Data fallen into database.Because data loading can have delay, new data caused by current time may be not
Have and imported database in real time, particularly the very big situation of data volume, it is more universal the problem of the delay of this data loading.Cause
This, technical scheme provided in an embodiment of the present invention ensures the target of query task inquiry by setting tasks carrying Delay Rules
Data have fallen into database.Certainly, for the preferable data framework of real time data warehousing, tasks carrying Delay Rules can be set
It is set to 0.Cycle time delay set below by way of example to tasks carrying Delay Rules makees an explanation.Scene example
Such as：The time interval that the tasks carrying frequency is set is 5 minute, you can is interpreted as initiating one query verification task every 5 minutes.
If tasks carrying Delay Rules be 10 minutes, corresponding cycle time delay be current time before before 15 minutes to current time
10 minutes.
In above-mentioned 209, verification type information includes：Cell class and index class.Verification mode includes：Absolute value verification side
Formula, day ring are than verification mode and all year-on-year verification modes etc..Wherein, absolute value verification mode is exactly in the form of check item
Whether hold item in the verification section of setting.Day ring than verification mode be the table content of T1 today moment check items with T1 yesterday when
Carve check item table content ratio whether setting day ring than in section.All verification modes on year-on-year basis are Monday this week T1
The ratio of the table content of the table content of moment check item and upper one week Monday T1 moment check item whether setting week
In year-on-year section.
The quantity for the contents in table that need to be extracted from form is would know that according to verification type information and verification mode.For example,
When to verify type information be cell class, verification mode is absolute value, the contents in table that is got from form is one；When
When verification type information is cell, verification mode is day ring ratio, the contents in table that you get from form is two, is respectively
Contents in table in same day form at the positional information and the list item in the form of the previous day at the positional information
Content；When to verify type be index item, verification mode is absolute value, the contents in table that is got from form is described
All contents in table on column or row at positional information；When to verify type be index item, verification mode is day ring ratio, from working as
Obtained in its form in all contents in table and the form of the previous day on the column or row at the positional information in institute
State all contents in table on the column or row at positional information；Etc..
As shown in the above, verification mode includes：Absolute value verification mode, day ring are than verification mode and week verification on year-on-year basis
Mode etc..Each verification mode has its corresponding computation rule.In above-mentioned 210, if verification mode verifies for absolute value
Mode, then the calculating that takes absolute value can be carried out to check item numerical value, to obtain the absolute value of the check item numerical value；If verification mode is
Day ring then calculates the verification entry value D1 at moment on the same day T1 and verification entry value D2 at T1 moment yesterday ratio (i.e. than verification mode
D1/D2), to obtain value to be verified；If verification mode is week year-on-year verification mode, the verification at T1 moment Monday this week is calculated
Entry value D1 ' and the verification entry value D2 ' at T1 moment Monday last week ratio (i.e. D1 '/D2 ').
In above-mentioned 211, verification is generally characterized as one with reference to numerical intervals, such as (0,200) with reference to information；(500 ,+
∞) etc..Accordingly, above-mentioned steps 211 are substantially exactly to judge value to be verified whether in reference to numerical intervals, if the school if
It is normal to test result, and otherwise check results are abnormal.
Further, also include in the task configuration information referred in above-mentioned each method embodiment：Type of alarm and
Alarm object；Accordingly, the technical scheme that above-mentioned each method embodiment provides can also include the steps of：If the check results
For exception, then alarm is sent to the alarm object according to the type of alarm.
Wherein, type of alarm can be specially：Alarm is sent by lettergram mode, alarmed by short message sending etc., this hair
Bright embodiment is not especially limited to this.
Further, may also include in the task configuration information referred in above-mentioned each method embodiment：Rule state
Information；Accordingly, above-mentioned each method embodiment may also include the steps of：
Inquire about whether verification task can use using described in the rule state information flag.
Wherein, rule state may include：Effective status or disarmed state.If inquiry verification task is marked as effective shape
State, then illustrate that inquiry verification task can use.If inquiry verification task is marked as disarmed state, illustrate that inquiry verification is appointed
It is engaged in unavailable.Available inquiry verification task can be initiated and perform when meeting initiation condition；Disabled query task
Any whether all without being initiated and perform.Under usual default situations, the rule state information of inquiry verification task is to have
Effect state.For inquiry verification task set up rule state information purpose be to provide for one turn off or on inquiry verification appoint
The interactive interface of business, user can be turned on and off inquiring about verification task at any time by changing rule state information.
It should be noted that：The executive agent that above-described embodiment provides each step of method may each be same equipment,
Or this method is also by distinct device as executive agent.For example the executive agent of step 101 to step 103 can be equipment
A；Again for example, step 101 and 102 executive agent can be device A, and the executive agent of step 103 can be equipment B；Etc..
Fig. 8 shows the structural representation for the verification rule generation device that one embodiment of the invention provides.Such as Fig. 8 institutes
Show, described device includes：First acquisition module 301, the second acquisition module 302, determining module 303 and generation module 304.Its
In, the first acquisition module 301 is used to obtain the task configuration information that user inputs by verifying rule configuration list；Second obtains mould
Block 302 is used to obtain the check item in on-line analytical processing form；Determining module 303 is used for according to the on-line analytical processing report
The Table Header information of table, determine positional information of the check item in the on-line analytical processing form；Generation module 304 is used for
According to the positional information and the task configuration information, generation is initiated to inquire about the contents in table of the on-line analytical processing form
And the inquiry verification task verified to contents in table corresponding to the check item.
Further, first acquisition module 301 is additionally operable to：The verification rule configuration is shown on a user interface
Table；Receive the task configuration information that user is inputted by the verification rule configuration list；Wherein, the task configuration information
In comprise at least：The tasks carrying frequency, verification type information, verification mode and verification are with reference to information.
Further, second acquisition module 302 is additionally operable to：On on-line analytical processing report display interface, display
Verify control；In response to the sequence trigger switch thing for a cell in the verification control and the on-line analytical processing form
Part, using the cell as the check item.
Further, the determining module 303 is additionally operable to：If the Table Header information of the on-line analytical processing form is single-stage
Gauge outfit, then using absolute row coordinate of the check item in the on-line analytical processing form and absolute ordinate as institute's rheme
Confidence ceases；If the Table Header information of the on-line analytical processing form is multistage gauge outfit, by the gauge outfit corresponding to the check item
The opposing rows coordinate or relative row coordinate of information and the check item in table area where the Table Header information are as institute
State positional information.
Further, described device may also include：Initiation module, enquiry module, the 3rd acquisition module, processing module and
Contrast module.Wherein, initiation module is used to trigger when the frequency setting time interval that the tasks carrying frequency is specified reaches
Query task；Enquiry module is used for cycle time delay that the tasks carrying Delay Rules setting is inquired about from the database
The contents in table of the interior on-line analytical processing form；3rd acquisition module is used for according to verification type information, verification mode
And at least one contents in table that the positional information is obtained from the on-line analytical processing form at the positional information is made
To participate at least one check item numerical value of verification；Processing module is used for according to the verification mode at least one verification
Item numerical value is handled to obtain value to be verified corresponding to the verification mode；Comparing module be used for will it is described it is to be verified be worth with it is described
Verification is compared with reference to information, to obtain check results.
Further, also include in described information generating means：Type of alarm and alarm object；And described device may be used also
Including alarm module.The alarm module be used for when the check results for it is abnormal when, according to the type of alarm to the report
Alert object sends alarm.
Further, may also include in the task configuration information：Rule state information；And described device also includes：
Mark module.Whether the mark module is used to can use using inquiry verification task described in the rule state information flag.
Further, may also include in the task configuration information：Correction verification module.Wherein, correction verification module is used for described
Task configuration information is verified；And if the generation module is additionally operable to the task configuration information and passes through verification, basis
The positional information and the task configuration information, the contents in table of the generation initiation inquiry on-line analytical processing form are simultaneously right
The inquiry verification task that contents in table corresponding to the check item is verified.
Further, described information generating means may also include：Display module.The display module is used to work as the task
When configuration information is not validated, shows do not pass through prompting on a user interface.
Need exist for explanation be：The information generation device that above-described embodiment provides can be realized in above-mentioned each method embodiment
The principle of the technical scheme of description, above-mentioned each module or unit specific implementation can be found in corresponding interior in above-mentioned each method embodiment
Hold, here is omitted.
One embodiment of the invention also provides a kind of electronic equipment.As shown in figure 9, the electronic equipment includes the He of processor 401
Memory 402, the memory 402, which is used to store, supports processor 401 to perform the information generation side that the various embodiments described above provide
The program of method, the processor 401 are configurable for performing the program stored in the memory 402.
Described program includes one or more computer instruction, wherein, described in the one or more computer instruction confession
Processor 401, which calls, to be performed.One or more computer instruction can realize that above- mentioned information is given birth to when being performed by processor 401
Into the step in method.
Memory 402 is used as a kind of non-volatile computer readable storage medium storing program for executing, available for storage non-volatile software journey
Sequence, non-volatile computer executable program and module, the program as corresponding to the information generating method in the embodiment of the present invention
Instruction/module is (for example, the first acquisition module 301, the second acquisition module 302, determining module 303 and generation mould shown in accompanying drawing 8
Block 304).Processor 401 is stored in non-volatile software program, instruction and module in memory 402 by operation, so as to
Various function application and the data processing of electronic equipment are performed, that is, realizes the information generating method of above method embodiment.
The processor 401 is used for：Obtain the task configuration information that user inputs by verifying rule configuration list；Obtain connection
Check item in machine analyzing and processing form；According to the Table Header information of the on-line analytical processing form, determine that the check item exists
Positional information in the on-line analytical processing form；According to the positional information and the task configuration information, generation is initiated
The inquiry inquired about the contents in table of the on-line analytical processing form and verified to contents in table corresponding to the check item
Verification task.
Processor 401 can perform the method that the embodiment of the present invention is provided, possess the corresponding functional module of execution method and
Beneficial effect, not ins and outs of detailed description in the present embodiment, reference can be made to the method that the embodiment of the present application is provided.
A kind of computer-readable recording medium for being stored with computer program that the embodiment of the present invention also provides, the calculating
Machine program can realize the step in the information generating method that the various embodiments described above provide when being computer-executed.
Device embodiment described above is only schematical, wherein the unit illustrated as separating component can
To be or may not be physically separate, it can be as the part that unit is shown or may not be physics list
Member, you can with positioned at a place, or can also be distributed on multiple NEs.It can be selected according to the actual needs
In some or all of module realize the purpose of this embodiment scheme.Those of ordinary skill in the art are not paying creativeness
Work in the case of, you can to understand and implement.
Through the above description of the embodiments, those skilled in the art can be understood that each embodiment can
Realized by the mode of software plus required general hardware platform, naturally it is also possible to pass through hardware.Based on such understanding, on
The part that technical scheme substantially in other words contributes to prior art is stated to embody in the form of software product, should
Computer software product can store in a computer-readable storage medium, such as ROM/RAM, magnetic disc, CD, including some fingers
Make to cause a computer equipment (can be personal computer, server, or network equipment etc.) to perform each implementation
Method described in some parts of example or embodiment.
Finally it should be noted that：The above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations；Although
The present invention is described in detail with reference to the foregoing embodiments, it will be understood by those within the art that：It still may be used
To be modified to the technical scheme described in foregoing embodiments, or equivalent substitution is carried out to which part technical characteristic；
And these modification or replace, do not make appropriate technical solution essence depart from various embodiments of the present invention technical scheme spirit and
Scope.
The invention discloses A1, a kind of information generating method, including：
Obtain the task configuration information that user inputs by verifying rule configuration list；
Obtain the check item in on-line analytical processing form；
According to the Table Header information of the on-line analytical processing form, determine the check item in the on-line analytical processing report
Positional information in table；
According to the positional information and the task configuration information, generation is initiated to inquire about the on-line analytical processing form
Contents in table and the inquiry verification task verified to contents in table corresponding to the check item.
A2, the method as described in above-mentioned A1, the check item obtained in on-line analytical processing form, including：
On on-line analytical processing report display interface, display verification control；
In response to for it is described verification control and the on-line analytical processing form in a cell sequence trigger switch event,
Using the cell as the check item.
A3, the method as described in above-mentioned A1, according to the Table Header information of the on-line analytical processing form, determine the verification
Positional information of the item in the on-line analytical processing form, including：
If the Table Header information of the on-line analytical processing form is single-stage gauge outfit, by the check item at described online point
Absolute row coordinate and absolute ordinate in analysis processing form is as the positional information；
If the Table Header information of the on-line analytical processing form is multistage gauge outfit, by the gauge outfit corresponding to the check item
The opposing rows coordinate or relative row coordinate of information and the check item in table area where the Table Header information are as institute
State positional information.
A4, the method as any one of above-mentioned A1 to A3, the acquisition user are inputted by verifying rule configuration list
Task configuration information, including：
The verification rule configuration list is shown on a user interface；
Receive the task configuration information that user is inputted by the verification rule configuration list；
Wherein, following all items are comprised at least in the task configuration information：The tasks carrying frequency, tasks carrying delay rule
Then, type information, verification mode and verification are verified with reference to information.
A5, the method as described in above-mentioned A4, in addition to：
The inquiry verification task is initiated when the time interval of tasks carrying frequency setting reaches；
Inquired about from the database described online in cycle time delay of the tasks carrying Delay Rules setting
Analyze and process the contents in table of form；
According to verification type information, verification mode and the positional information, obtained from the on-line analytical processing form
At least one contents in table at the positional information is as at least one check item numerical value for participating in verification；
Handled to obtain the verification mode correspondingly at least one check item numerical value according to the verification mode
Value to be verified；
The value to be verified is compared with the verification with reference to information, to obtain check results.
A6, the method as described in above-mentioned A5, also include in the task configuration information：Type of alarm and alarm object；With
And
Methods described, in addition to：
If the check results send alarm to be abnormal, according to the type of alarm to the alarm object.
A7, the method as described in above-mentioned A5 or A6, also include in the task configuration information：Rule state information；And
Methods described also includes：
Inquire about whether verification task can use using described in the rule state information flag.
A8, the method as any one of above-mentioned A1 to A3, in addition to：
The task configuration information is verified；And
According to the positional information and the task configuration information, generation is initiated to inquire about the on-line analytical processing form
Contents in table and the inquiry verification task verified to contents in table corresponding to the check item, including：
If the task configuration information is by verification, according to the positional information and the task configuration information, generation
Initiate what is inquired about the contents in table of the on-line analytical processing form and contents in table corresponding to the check item is verified
Inquire about verification task.
A9, the method as described in above-mentioned A8, in addition to：
If the task configuration information is not validated, shows do not pass through prompting on a user interface.
The invention also discloses B10, a kind of information generation device, including：
First acquisition module, the task configuration information inputted for obtaining user by verifying rule configuration list；
Second acquisition module, for obtaining the check item in on-line analytical processing form；
Determining module, for the Table Header information according to the on-line analytical processing form, determine the check item described
Positional information in on-line analytical processing form；
Generation module, for according to the positional information and the task configuration information, it is described online that inquiry is initiated in generation
The inquiry verification task for analyzing and processing the contents in table of form and being verified to contents in table corresponding to the check item.
B11, the device as described in above-mentioned B10, second acquisition module, are additionally operable to：
On on-line analytical processing report display interface, display verification control；
In response to for it is described verification control and the on-line analytical processing form in a cell sequence trigger switch event,
Using the cell as the check item.
B12, the device as described in above-mentioned B10, the determining module, are additionally operable to：
If the Table Header information of the on-line analytical processing form is single-stage gauge outfit, by the check item at described online point
Absolute row coordinate and absolute ordinate in analysis processing form is as the positional information；
If the Table Header information of the on-line analytical processing form is multistage gauge outfit, by the gauge outfit corresponding to the check item
The opposing rows coordinate or relative row coordinate of information and the check item in table area where the Table Header information are as institute
State positional information.
B13, the device as any one of above-mentioned B10 to B12, first acquisition module, are additionally operable to：
The verification rule configuration list is shown on a user interface；
Receive the task configuration information that user is inputted by the verification rule configuration list；
Wherein, comprised at least in the task configuration information：The tasks carrying frequency, verification type information, verification mode and
Verification is with reference to information.
B14, the device as described in above-mentioned B13, in addition to：
Initiation module, the time interval for being set in the tasks carrying frequency are initiated the inquiry verification and appointed when reaching
Business；
Enquiry module, for inquiring about cycle time delay of the tasks carrying Delay Rules setting from the database
The contents in table of the interior on-line analytical processing form；
3rd acquisition module, for according to verification type information, verification mode and the positional information, from described online point
At least one contents in table at the positional information is obtained in analysis processing form as at least one check item for participating in verification
Numerical value；
Processing module, it is described for being handled to obtain at least one check item numerical value according to the verification mode
Value to be verified corresponding to verification mode；
Comparing module, for the value to be verified to be compared with the verification with reference to information, to obtain check results.
B15, the device as described in above-mentioned B14, also include in the task configuration information：Type of alarm and alarm object；
And
Described device, in addition to：
Alarm module, for when the check results are abnormal, being sent out according to the type of alarm to the alarm object
Send alarm.
B16, the device as described in above-mentioned B14 or B15, also include in the task configuration information：Rule state information；With
And
Described device also includes：
Mark module, for whether can use using inquiry verification task described in the rule state information flag.
B17, the device as any one of above-mentioned B10 to B12, in addition to：
Correction verification module, for being verified to the task configuration information；And
If the generation module is additionally operable to the task configuration information by verification, according to the positional information and described
Task configuration information, generation are initiated to inquire about the contents in table of the on-line analytical processing form and to table corresponding to the check item
The inquiry verification task that item content is verified.
B18, the device as described in above-mentioned B17, in addition to：
Display module, for when the task configuration information is not validated, showing on a user interface not by carrying
Show.
The invention also discloses C19, a kind of electronic equipment, including memory and processor；It is described to store for storing one
Bar or a plurality of computer instruction, one or more computer instruction can be realized above-mentioned A1- during the computing device
Step in any one of A9 methods describeds.
The invention also discloses C20, a kind of computer-readable recording medium for being stored with computer program, the computer
Program can realize the step in any one of above-mentioned A1-A9 methods described when being computer-executed.
Claims (10)
- A kind of 1. information generating method, it is characterised in that including：Obtain the task configuration information that user inputs by verifying rule configuration list；Obtain the check item in on-line analytical processing form；According to the Table Header information of the on-line analytical processing form, determine the check item in the on-line analytical processing form Positional information；According to the positional information and the task configuration information, generation is initiated to inquire about the list item of the on-line analytical processing form Content and the inquiry verification task verified to contents in table corresponding to the check item.
- 2. according to the method for claim 1, it is characterised in that the check item obtained in on-line analytical processing form, Including：On on-line analytical processing report display interface, display verification control；In response to the sequence trigger switch event for a cell in the verification control and the on-line analytical processing form, by institute Cell is stated as the check item.
- 3. according to the method for claim 1, it is characterised in that according to the Table Header information of the on-line analytical processing form, Positional information of the check item in the on-line analytical processing form is determined, including：If the Table Header information of the on-line analytical processing form is single-stage gauge outfit, by the check item at the on-line analysis Absolute row coordinate and absolute ordinate in reason form is as the positional information；If the Table Header information of the on-line analytical processing form is multistage gauge outfit, by the Table Header information corresponding to the check item And opposing rows coordinate or relative row coordinate of the check item in table area where the Table Header information are as institute's rheme Confidence ceases.
- 4. according to the method in any one of claims 1 to 3, it is characterised in that the acquisition user is by verifying rule The task configuration information of allocation list input, including：The verification rule configuration list is shown on a user interface；Receive the task configuration information that user is inputted by the verification rule configuration list；Wherein, following all items are comprised at least in the task configuration information：The tasks carrying frequency, tasks carrying Delay Rules, Type information, verification mode and verification are verified with reference to information.
- A kind of 5. information generation device, it is characterised in that including：First acquisition module, the task configuration information inputted for obtaining user by verifying rule configuration list；Second acquisition module, for obtaining the check item in on-line analytical processing form；Determining module, for the Table Header information according to the on-line analytical processing form, determine the check item described online Analyze and process the positional information in form；Generation module, for according to the positional information and the task configuration information, generation to be initiated to inquire about the on-line analysis The inquiry verification task for handling the contents in table of form and being verified to contents in table corresponding to the check item.
- 6. device according to claim 5, it is characterised in that second acquisition module, be additionally operable to：On on-line analytical processing report display interface, display verification control；In response to the sequence trigger switch event for a cell in the verification control and the on-line analytical processing form, by institute Cell is stated as the check item.
- 7. device according to claim 5, it is characterised in that the determining module, be additionally operable to：If the Table Header information of the on-line analytical processing form is single-stage gauge outfit, by the check item at the on-line analysis Absolute row coordinate and absolute ordinate in reason form is as the positional information；If the Table Header information of the on-line analytical processing form is multistage gauge outfit, by the Table Header information corresponding to the check item And opposing rows coordinate or relative row coordinate of the check item in table area where the Table Header information are as institute's rheme Confidence ceases.
- 8. the device according to any one of claim 5 to 7, it is characterised in that first acquisition module, be additionally operable to：The verification rule configuration list is shown on a user interface；Receive the task configuration information that user is inputted by the verification rule configuration list；Wherein, comprised at least in the task configuration information：The tasks carrying frequency, verification type information, verification mode and verification With reference to information.
- 9. a kind of electronic equipment, it is characterised in that including memory and processor；It is described to store by storing based on one or more Calculation machine instructs, and one or more computer instruction can be realized during the computing device described in above-mentioned any one of 1-4 Step in method.
- 10. a kind of computer-readable recording medium for being stored with computer program, it is characterised in that the computer program is counted Calculation machine can realize the step in any one of above-mentioned 1-4 methods described when performing.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710515752.5A CN107402970B (en) | 2017-06-29 | 2017-06-29 | Information generation method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710515752.5A CN107402970B (en) | 2017-06-29 | 2017-06-29 | Information generation method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107402970A true CN107402970A (en) | 2017-11-28 |
| CN107402970B CN107402970B (en) | 2020-09-08 |
Family
ID=60404598
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710515752.5A Expired - Fee Related CN107402970B (en) | 2017-06-29 | 2017-06-29 | Information generation method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107402970B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110473080A (en) * | 2019-07-30 | 2019-11-19 | 阿里巴巴集团控股有限公司 | A kind of report processing method, device and computer equipment |
| CN110889106A (en) * | 2018-09-11 | 2020-03-17 | 北京京东金融科技控股有限公司 | Configuration method, device, system and computer readable storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090150447A1 (en) * | 2007-12-05 | 2009-06-11 | Microsoft Corporation | Data warehouse test automation framework |
| CN103246574A (en) * | 2012-02-10 | 2013-08-14 | 阿里巴巴集团控股有限公司 | Verification method and verification device for data accuracy |
| CN104239162A (en) * | 2014-09-09 | 2014-12-24 | 北京国双科技有限公司 | Data check method and data check device |
| CN105989044A (en) * | 2015-02-04 | 2016-10-05 | 阿里巴巴集团控股有限公司 | Database verification method and system |
-
2017
- 2017-06-29 CN CN201710515752.5A patent/CN107402970B/en not_active Expired - Fee Related
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090150447A1 (en) * | 2007-12-05 | 2009-06-11 | Microsoft Corporation | Data warehouse test automation framework |
| CN103246574A (en) * | 2012-02-10 | 2013-08-14 | 阿里巴巴集团控股有限公司 | Verification method and verification device for data accuracy |
| CN104239162A (en) * | 2014-09-09 | 2014-12-24 | 北京国双科技有限公司 | Data check method and data check device |
| CN105989044A (en) * | 2015-02-04 | 2016-10-05 | 阿里巴巴集团控股有限公司 | Database verification method and system |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110889106A (en) * | 2018-09-11 | 2020-03-17 | 北京京东金融科技控股有限公司 | Configuration method, device, system and computer readable storage medium |
| CN110473080A (en) * | 2019-07-30 | 2019-11-19 | 阿里巴巴集团控股有限公司 | A kind of report processing method, device and computer equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107402970B (en) | 2020-09-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP7507602B2 (en) | Data Quality Analysis | |
| US20220129476A1 (en) | Enhanced mechanisms for managing multidimensional data | |
| CN104391934B (en) | Data verification method and device | |
| US8645332B1 (en) | Systems and methods for capturing data refinement actions based on visualized search of information | |
| CN107908550B (en) | Software defect statistical processing method and device | |
| WO2019184123A1 (en) | Method for automatically generating financial document, device, computer apparatus, and storage medium | |
| EP2778929B1 (en) | Test script generation system | |
| CN107689887B (en) | Temporary control change online management system of nuclear power plant control system | |
| CN106096905A (en) | A kind of project management method and system | |
| US20110209042A1 (en) | Information Technology Standard Inventory Utility | |
| US11164110B2 (en) | System and method for round trip engineering of decision metaphors | |
| US10083061B2 (en) | Cloud embedded process tenant system for big data processing | |
| US11366791B2 (en) | System and method for process and automation framework to enable acceptance test driven development | |
| CN115170048B (en) | Workflow realization method, system and medium based on model and rule | |
| CN108874678A (en) | A kind of automatic test approach and device of intelligent program | |
| CN109240854A (en) | Data reconstruction method and system | |
| CN107402970A (en) | Information generating method and device | |
| CN111984882A (en) | Data processing method, system and equipment | |
| CN107688619A (en) | A kind of daily record data processing method and processing device | |
| US20160217212A1 (en) | Method, server, and system for estimating patent prosecution related activity | |
| Roubtsova et al. | KPIs and their properties defined with the EXTREME method | |
| JP4528492B2 (en) | Accident analysis support system | |
| CN111222834A (en) | Enterprise field emergency work data analysis method and system | |
| Alqodri et al. | Helpdesk ticket support system based on fuzzy Tahani algorithm | |
| CN117472641B (en) | Data quality detection method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: Building N3, Jinyu Zhizao workshop, No. 27, Jiancai Chengzhong Road, Haidian District, Beijing 100096 Applicant after: Beijing Xingxuan Technology Co.,Ltd. Address before: 100085 Beijing, Haidian District on the road to the information on the ground floor of the 1 to the 3 floor of the 2 floor, room 11, 202 Applicant before: Beijing Xiaodu Information Technology Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20200908 |