CN107402970B - Information generation method and device - Google Patents

Information generation method and device Download PDF

Info

Publication number
CN107402970B
CN107402970B CN201710515752.5A CN201710515752A CN107402970B CN 107402970 B CN107402970 B CN 107402970B CN 201710515752 A CN201710515752 A CN 201710515752A CN 107402970 B CN107402970 B CN 107402970B
Authority
CN
China
Prior art keywords
check
information
task
analysis processing
item
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201710515752.5A
Other languages
Chinese (zh)
Other versions
CN107402970A (en
Inventor
梁福坤
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Xingxuan Technology Co Ltd
Original Assignee
Beijing Xingxuan Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Xingxuan Technology Co Ltd filed Critical Beijing Xingxuan Technology Co Ltd
Priority to CN201710515752.5A priority Critical patent/CN107402970B/en
Publication of CN107402970A publication Critical patent/CN107402970A/en
Application granted granted Critical
Publication of CN107402970B publication Critical patent/CN107402970B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • G06F16/24553Query execution of query operations
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • G06F16/2358Change 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 invention provides an information generation method and device. The method comprises the following steps: acquiring task configuration information input by a user through a check rule configuration table; acquiring a check item in an online analysis processing report; determining the position information of the check item in the online analysis processing report according to the header information of the online analysis processing report; and generating a query and verification task for initiating query of the table item contents of the online analysis processing report and verifying the table item contents corresponding to the verification items according to the position information and the task configuration information. The technical scheme provided by the embodiment of the invention does not need to write programs manually, so that the implementation is simpler and the maintenance is convenient.

Description

Information generation method and device
Technical Field
The present invention relates to the field of computer technologies, and in particular, to an information generating method and apparatus.
Background
OLAP (Online Analytical Processing) tries to process a large amount of data in a data warehouse and converts the data into useful information, so that data can be summarized, analyzed and processed, and an enterprise can be helped to complete decisions.
In the verification of the final output result of OLAP analysis, the abnormity of the cells or specific indexes is found, and the data quality can be guaranteed in a universal manner and at low cost. FIG. 1 shows a data diagram presented by OLAP analysis. The user, upon selecting query column content (e.g., strike-rate monthly cumulative value, merchant day UV, as shown in the figure), row content (e.g., day, city, KA label in the figure), and filter rules, may present a diagram in the user interface as shown in FIG. 1. The check on the cell refers to the check on the cell similar to the first cell 1 or the second cell 2 in the graph, and a data check rule can be set on the cell individually. The verification of the index item is to verify the values of all column cells in the column of the merchant daily UV index or the dynamic selling rate monthly accumulated value index in fig. 1.
The purpose of setting the check rule is to give an alarm when the value of a certain cell is found to be not in accordance with the expectation through the check or the value of a cell in a certain column or the value of a cell in a certain row in a certain index is found to be not in accordance with the expectation.
In the prior art, the checking means is mostly realized by a man-made coding mode. That is, the corresponding check statements are edited manually for the tracked object, the definition of the check rules is complex and complex, and the reusability of the same type of check rules is poor.
Disclosure of Invention
Fig. 2 shows a prior art verification process for a cell. In the prior art, a data verification SQL (Structured Query Language) template needs to be manually written for data to be verified; then defining a target expected value range corresponding to the data check SQL template; the data check SQL template and its corresponding target expected value range are then registered as a routine task. And generating verification SQL after the routine task is successfully registered. The checking SQL runs a checking task at a preset time point or at equal intervals to check the result of a specified object (such as a cell item or an index item) in the OLAP report.
As can be seen from the above, in the prior art, the data verification task is defined more complicatedly, and a corresponding data verification SQL template needs to be manually written and corresponding routine tasks are manually generated for different cells or different index items, which is poor in maintainability; in addition, because the reusability of the existing data checking task with extremely strong pertinence is poor, each checking object needs to be redefined.
Thus, in one embodiment of the present invention, an information generating method is provided. The method comprises the following steps: acquiring task configuration information input by a user through a check rule configuration table; acquiring a check item in an online analysis processing report; determining the position information of the check item in the online analysis processing report according to the header information of the online analysis processing report; and generating a query and verification task for initiating query of the table item contents of the online analysis processing report and verifying the table item contents corresponding to the verification items according to the position information and the task configuration information.
Optionally, the acquiring the check item in the online analysis processing report includes: displaying a check control on an online analysis processing report display interface; and taking a cell as the check item in response to a sequential trigger event aiming at the check control and the cell in the online analysis processing report.
Optionally, determining, according to header information of the online analysis processing report, location information of the check item in the online analysis processing report, including: if the header information of the online analysis processing report is a single-stage header, taking the absolute row coordinate and the absolute vertical coordinate of the check item in the online analysis processing report as the position information; and if the header information of the online analysis processing report is a multi-level header, taking the header information corresponding to the check item and the relative row coordinate or the relative column coordinate of the check item in the table area where the header information is located as the position information.
Optionally, the acquiring task configuration information input by the user through the check rule configuration table includes: displaying the check rule configuration table on a user interface; receiving the task configuration information input by a user through the check rule configuration table; wherein the task configuration information at least comprises: the task execution frequency, the verification type information, the verification mode and the verification reference information.
Optionally, the method may further include: initiating the query and verification task when a time interval set by the task execution frequency is reached; inquiring the table item content of the online analysis processing report in a delay time period set by the task execution delay rule from a database; acquiring at least one table item content at the position information from the online analysis processing report as at least one check item value participating in checking according to the checking type information, the checking mode and the position information; processing the at least one check item value according to the check mode to obtain a value to be checked corresponding to the check mode; and comparing the value to be verified with the verification reference information to obtain a verification result.
Optionally, the task configuration information further includes: alarm mode and alarm object; and the above method further comprises: and if the verification result is abnormal, sending an alarm prompt to the alarm object according to the alarm mode.
Optionally, the task configuration information further includes: rule state information; and the above method further comprises: and marking whether the query and verification task is available or not by adopting the rule state information, and initiating the query task when the verification rule is available.
Optionally, the method may further include: checking the task configuration information; and
generating an inquiry checking task for initiating inquiry of the table item content of the online analysis processing report and checking the table item content corresponding to the checking item according to the position information and the task configuration information, wherein the inquiry checking task comprises the following steps:
and if the task configuration information passes the verification, generating a query verification task for initiating query of the table item content of the online analysis processing report and verifying the table item content corresponding to the verification item according to the position information and the task configuration information.
Optionally, the method may further include: and if the task configuration information is not verified, displaying a failed prompt on a user interface.
In another embodiment of the invention, an automatic verification rule generation device is provided. The device includes: the first acquisition module is used for acquiring task configuration information input by a user through a check rule configuration table; the second acquisition module is used for acquiring the check items in the online analysis processing report; the determining module is used for determining the position information of the check item in the online analysis processing report according to the header information of the online analysis processing report; and the generating module is used for generating an inquiry and verification task for initiating inquiry of the table item content of the online analysis processing report and verification of the table item content corresponding to the verification item according to the position information and the task configuration information.
In yet another embodiment of the present invention, an electronic device is provided. The electronic device comprises a processor and a memory, wherein the memory is used for storing one or more computer instructions, and the one or more computer instructions can realize the steps of the information generation method when being executed by the processor.
In still another embodiment of the present invention, there is provided a computer-readable storage medium storing a computer program which, when executed by a computer, can implement the steps in the above-described information generating method.
In the technical scheme provided by the embodiment of the invention, a user only needs to check the rule configuration table to perform rule configuration, so that the visualization of the rule configuration is realized, and the rule configuration is simpler; in addition, the technical scheme provided by the embodiment of the invention automatically generates the check rule aiming at the check item according to the general task configuration information and the position information of the check item in the online analysis processing report, wherein the task configuration information and the position information are general information, but the data with extremely strong pertinence, such as the index item corresponding to the row and the column where the specific check item is located, is required to be substituted when a data check SQL template is manually written in the prior art, and the check rule generated by adopting the general information has reusability; in addition, the technical scheme provided by the embodiment of the invention does not need to write programs manually, so that the implementation is simpler and the maintenance is convenient.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and those skilled in the art can also obtain other drawings according to the drawings without creative efforts.
FIG. 1 is a diagram illustrating an example of an online analytical processing report;
FIG. 2 is a schematic diagram illustrating a generation flow of check SQL in the prior art;
fig. 3 is a schematic flowchart of an information generating method according to an embodiment of the present invention;
fig. 4 is an exemplary diagram of a check rule configuration table involved in an information generating method according to an embodiment of the present invention;
FIG. 5 is a diagram illustrating an online analytical processing report with a single-level header, according to an embodiment of the present invention;
FIG. 6a is a diagram illustrating an online analytic processing report with a multi-level header, according to an embodiment of the present invention;
FIG. 6b is a diagram illustrating another online analytic processing report having a multi-level header, according to an embodiment of the present invention;
fig. 7 is a schematic flowchart of an information generating method according to another embodiment of the present invention;
fig. 8 is a block diagram of an information generating apparatus according to an embodiment of the present invention;
fig. 9 is a block diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention.
In some of the flows described in the specification, claims, and above-described figures of the present invention, a number of operations are included that occur in a particular order, which operations may be performed out of order or in parallel as they occur herein. The sequence numbers of the operations, e.g., 101, 102, etc., are used merely to distinguish between the various operations, and do not represent any order of execution per se. Additionally, the flows may include more or fewer operations, and the operations may be performed sequentially or in parallel. It should be noted that, the descriptions of "first", "second", etc. in this document are used for distinguishing different messages, devices, modules, etc., and do not represent a sequential order, nor limit the types of "first" and "second" to be different.
The technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention. It is to be understood that the described embodiments are merely exemplary of the invention, and not restrictive of the full scope of the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Fig. 3 is a flowchart illustrating an information generating method according to an embodiment of the present invention. As shown in fig. 1, the method includes:
101. and acquiring task configuration information input by a user through a check rule configuration table.
102. And acquiring the check items in the online analysis processing report.
103. And determining the position information of the check item in the online analysis processing report according to the header information of the online analysis processing report.
104. And generating a query and verification task for initiating query of the table item contents of the online analysis processing report and verifying the table item contents corresponding to the verification items according to the position information and the task configuration information.
In the foregoing 101, a check rule configuration table is displayed on the user interface, and at least one configuration item is listed in the check rule configuration table to guide the user to fill in the corresponding task configuration information. An example of a check rule configuration table is shown in fig. 4. The check rule configuration table shows a plurality of configuration items, such as: rule state configuration items, check time, sending an abnormal alarm in a mailbox mode, copying a mailbox list configuration item, a monitoring type configuration item, an absolute value check mode and a corresponding check reference threshold interval, a day-to-ring ratio check mode and a corresponding check reference threshold interval, a week-to-year ratio check mode and a corresponding check reference threshold interval and the like. The example shown in fig. 4 only shows three verification manners, i.e., an absolute value, a daily-to-ring ratio, and a weekly-to-similar ratio, and may also include a weekly-to-average value, a monthly-to-ring ratio, and other verification manners.
In an implementation solution, the step 101 may be implemented as follows:
and S1, displaying the verification rule configuration table on a user interface.
And S2, receiving the task configuration information input by the user through the check rule configuration table.
Wherein the task configuration information at least comprises: the task execution frequency, the task execution delay rule, the verification type information, the verification mode, the verification reference information and the like.
In specific implementation, the check rule configuration table can be displayed after a user triggers a configuration control on a user interface; or after a user touches a specific control on the keyboard; or after receiving voice control of the user. The user can use a keyboard, a touch screen or a voice mode to input corresponding task configuration information in each item in the verification rule configuration table.
In the above 102, the check item may be a cell or an index item (i.e. a column or a row corresponding to index information). For a cell, the number of check items is 1; for the index item, the check item includes all cells in a row or a column corresponding to the index item, and the number of the check items is the number of all cells in the row or the column.
In an implementation technical solution, how a certain cell in the online analysis processing report is determined as a check item can be implemented by the following method:
and S1, displaying the verification control on the online analysis processing report display interface.
S2, responding to the sequence trigger event aiming at the check control and a cell in the online analysis processing report, and taking the cell as the check item.
The above-mentioned sequential trigger event is: after the trigger event for the check control, there is a trigger event for the cell. The trigger event may be a click operation performed by using a mouse, a click operation performed by using a touch screen, a language input operation by a microphone, or the like. Here, it should be noted that: the above only lists the check item as a cell. When the check item is the index item, the user can select the trigger event of the row or the column after the trigger event for the check control, and all the cells in the selected row or the selected column are the check item.
The header information of the online analysis processing report mentioned in 103 above refers to the style information of the row header 20 and the list header 10 shown in fig. 5. In practical application, the header of the online analysis processing report form has a plurality of types, namely a single-stage header and a multi-stage header. The single-level header refers to a single-row header and a single-column header, and the online analysis processing report shown in fig. 5 is a single-level header report; the multi-level header means that the multi-level header includes a multi-row header and/or a multi-row header, and the online analysis processing report shown in fig. 6a and 6b is a multi-level header report. FIG. 6a shows a report with a multi-level row header; fig. 6b shows a report with a multi-level list header. For the single-level header, since the order of the report presentation is fixed and unchanged each time, a position replacement order between the header of the list or the header of the row will occur, and a new order will not exist each time, the absolute row coordinate and the absolute ordinate of the check item in the online analysis processing report can be directly used as the position information. For some multi-level headers, for example, the report shown in fig. 6a, the row header of the report is a multi-level header, and 8.9.1 in the row header is the version number of the App, because the App has to be updated, some old versions of APPs in the report will be released and new versions of App headers will be added, and in such multi-level header reports with header changes, the combination of header information and relative position can be used as position information. For example, in the connection processing analysis report with multi-level headers shown in fig. 6a, the cells 30 outlined in the figure are check items; since the list header is a single list header and the row header is a multi-level row header, the location information of the check entry can be represented by: header 8.9.1 and running water (after offer) information, and the row coordinates (i.e., the third row from 2017-03-06 down) in the table area where header 8.9.1 and running water (after offer) are located. This way of combining header information with relative position is more applicable than the absolute coordinates used by a single level header as position information. Of course, it is also possible to use absolute row coordinates and absolute column coordinates as position information for a multi-level report in which header changes do not occur.
As can be seen from the above, step 103 in the above embodiment can be implemented by the following method:
if the header information of the online analysis processing report is a single-stage header, taking the absolute row coordinate and the absolute vertical coordinate of the check item in the online analysis processing report as the position information;
and if the header information of the online analysis processing report is a multi-level header, taking the header information corresponding to the check item and the relative row coordinate or the relative column coordinate of the check item in the table area where the header information is located as the position information.
Further, if the header information of the online analysis processing report is a multi-level header, taking the header information corresponding to the check item and the relative row coordinates or the relative column coordinates of the check item in the table area where the header information is located as the position information, the method may further include the following steps:
if the multi-level header of the online analysis processing report is a multi-level row header, taking the header information of the multi-level row header corresponding to the column where the check item is located and the relative row coordinates of the check item in the table area where the header information is located as the position information;
if the multi-level table header of the online analysis processing report is a multi-level list header, taking the table header information of the multi-level list header corresponding to the row where the check item is located and the relative column coordinates of the check item in the table area where the table header information is located as the position information;
if the multi-level table header of the online analysis processing report includes a multi-level row table header and a multi-level column table header, taking the table header information of the multi-level column table header corresponding to the column where the check item is located and the relative row coordinate of the check item in the table area where the table header information is located as the location information, or taking the table header information of the multi-level column table header corresponding to the row where the check item is located and the relative column coordinate of the check item in the table area where the table header information is located as the location information.
Here, it should be noted that: when the multi-level header of the online analysis processing report includes a multi-level row header and a multi-level column header (such as the report shown in fig. 6 b), the first method or the second method is selected to determine the location information. Because the header of the report is frequently updated, the report can be updated in both ways in practical application. However, it is more feasible that which multi-level header of the multi-level row header and the multi-level column header is easy to change is determined first, and if the multi-level row header is easy to change, the first mode can be selected; if the multi-level list header is subject to alteration, the second mode may be selected. The first method is to use the header information of the multi-level list header corresponding to the column where the check item is located and the relative row coordinate of the check item in the table area where the header information is located as the position information; in the second aspect, the header information of the multi-level column header corresponding to the row in which the check item is located and the relative column coordinates of the check item in the table area in which the header information is located are used as the position information.
Based on the above, the task configuration information may include: the task execution frequency, the task execution delay rule, the verification type information, the verification mode, the verification reference information and the like. Correspondingly, in the above 104, a value rule for querying a check item in the check task may be generated according to the check mode and the location information in the task configuration information. For example, if the check mode is absolute value check, the value rule takes a single value, namely the table content corresponding to the check item; if the check mode is a day-to-ring ratio check mode, the value-taking rule should take double values, which are the table content corresponding to the check item at the current time and the table content corresponding to the check item at the current time of the previous day respectively. And generating a query and verification initiation rule, a verification rule, an alarm rule and the like in the query and verification task according to the task configuration information. The generated query and verification tasks can be stored in a database so as to be convenient for calling and realizing the report query and the verification of the report verification items at regular or equal time intervals.
In the technical scheme provided by the embodiment, the user only needs to check the rule configuration table to perform rule configuration, so that the rule configuration is visualized, and the rule configuration is simpler; in addition, the technical scheme provided by the embodiment of the invention automatically generates the check rule aiming at the check item according to the general task configuration information and the position information of the check item in the online analysis processing report, wherein the task configuration information and the position information are general information, but the data with extremely strong pertinence, such as the index item corresponding to the row and the column where the specific check item is located, is required to be substituted when a data check SQL template is manually written in the prior art, and the check rule generated by adopting the general information has reusability; in addition, the technical scheme provided by the embodiment of the invention does not need to write programs manually, so that the implementation is simpler and the maintenance is convenient.
Further, in the above and following embodiments, the above method may further include the following steps: and checking the task configuration information. Correspondingly, in step 104, generating a query and check task for initiating query of the entry content of the online analysis processing report and checking the entry content corresponding to the check entry according to the location information and the task configuration information may specifically be:
and if the task configuration information passes the verification, generating a query verification task for initiating query of the table item content of the online analysis processing report and verifying the table item content corresponding to the verification item according to the position information and the task configuration information.
Still further, the method may further comprise: and if the task configuration information is not verified, displaying a failed prompt on a user interface.
The task configuration information is checked to check whether the configuration items input by the user through the check rule configuration table meet the setting requirements. Such as whether the mailbox is correct, whether the time format meets the requirements, etc. If the verification fails, a prompt can be displayed on a user interface and fed back to the user, so that the user can make modification in time.
Fig. 7 is a flowchart illustrating an information generating method according to another embodiment of the present invention. As shown in fig. 7, the method includes:
201. and displaying the check rule configuration table on a user interface.
202. And receiving the task configuration information input by the user through the check rule configuration table.
Wherein the task configuration information at least comprises: the method comprises the following steps of task execution frequency, task execution delay rules, verification type information, verification modes and verification reference information.
203. And acquiring the check items in the online analysis processing report.
204. And determining the position information of the check item in the online analysis processing report according to the header information of the online analysis processing report.
205. And generating a query and verification task for initiating query of the table item contents of the online analysis processing report and verifying the table item contents corresponding to the verification items according to the position information and the task configuration information.
206. And storing the query and check task to a database.
207. And initiating the query and check task when a time interval set by the task execution frequency is reached.
208. And querying the table item content of the online analysis processing report in the delay time period set by the task execution delay rule from a database.
209. And acquiring at least one table item content at the position information from the online analysis processing report as at least one check item value participating in checking according to the checking type information, the checking mode and the position information.
210. And processing the at least one check item value according to the check mode to obtain a value to be checked corresponding to the check mode.
211. And comparing the value to be verified with the verification reference information to obtain a verification result.
The above 201-206 can refer to the corresponding contents in the above embodiments, and are not described herein again.
The task 207 is a task that needs to be executed multiple times. The initiation rule of the task is generated based on the execution frequency of the task set by the user. The frequency of tasks, i.e. the frequency with which tasks are performed, is for example once in 10 minutes or once in half an hour, etc.
In the above 208, the delay time period set by the task execution delay rule is to ensure that all the data to be queried by the user falls into the database. Because the data warehousing is delayed, new data generated at the current moment may not be imported into the database in real time, and particularly under the condition of large data volume, the problem of data warehousing delay is more common. Therefore, the technical scheme provided by the embodiment of the invention ensures that the target data queried by the query task falls into the database by setting the task execution delay rule. Of course, for a data architecture where real-time data warehousing is better, the task execution delay rule may be set to 0. An explanation is given below, by way of example, of the delay time period set by the task execution delay rule. The scenes are for example: the time interval set by the task execution frequency is 5 minutes, namely, the query and verification task is initiated every 5 minutes. If the task execution delay rule is 10 minutes, the corresponding delay time period is from 15 minutes before the current time to 10 minutes before the current time.
In 209, the check type information includes: a cell class and an index class. The checking mode comprises the following steps: absolute value checking mode, day-to-ring ratio checking mode, week-to-week ratio checking mode and the like. The absolute value check mode is whether the table content item of the check item is in a set check interval. The daily ring ratio check method is to determine whether the ratio of the table content of the today's T1 time check item to the table content of the yesterday T1 time check item is within a set daily ring ratio interval. The week parity check mode is whether the ratio of the table content of the check item at the time of Monday T1 of the week to the table content of the check item at the time of Monday T1 of the last week is within a set week parity interval.
And acquiring the quantity of the table entry contents to be extracted from the report according to the verification type information and the verification mode. For example, when the check type information is a cell type and the check mode is an absolute value, the content of the table entry obtained from the report is one; when the check type information is a cell and the check mode is a daily-to-annular ratio, two table item contents are acquired from the report, wherein the two table item contents are respectively the table item contents at the position information in the report on the day and the table item contents at the position information in the report on the previous day; when the check type is an index item and the check mode is an absolute value, the table item contents acquired from the report are all table item contents on the column or row at the position information; when the checking type is an index item and the checking mode is a day-to-circle ratio, acquiring all table item contents on a column or a row at the position information and all table item contents on the column or the row at the position information in the report of the previous day from the report of the current day; and so on.
As can be seen from the above, the verification method includes: absolute value check mode, daily-to-annular ratio check mode, weekly-to-annular ratio check mode and the like. Each check mode has a corresponding calculation rule. In the above step 210, if the check mode is an absolute value check mode, the absolute value of the check term value may be calculated to obtain the absolute value of the check term value; if the check mode is a daily-to-annular ratio check mode, calculating the ratio (namely D1/D2) of the check item value D1 at the time of the current day T1 to the check item value D2 at the time of the yesterday T1 to obtain a value to be checked; if the verification mode is the weekly parity verification mode, calculating the ratio of the check item value D1 'at the time of Monday T1 of the week to the check item value D2' at the time of Monday T1 of the last week (i.e. D1 '/D2').
211, the verification reference information is generally characterized as a reference value interval, e.g., (0,200); (500, + ∞), and the like. Accordingly, the step 211 is to substantially determine whether the value to be verified is within the reference value range, if so, the verification result is normal, otherwise, the verification result is abnormal.
Further, the task configuration information mentioned in the above method embodiments further includes: alarm mode and alarm object; correspondingly, the technical scheme provided by each method embodiment can further comprise the following steps: and if the verification result is abnormal, sending an alarm prompt to the alarm object according to the alarm mode.
Wherein, the alarm mode can be specifically: sending an alarm by mail, sending an alarm by short message, and the like, which is not particularly limited in the embodiment of the present invention.
Further, the task configuration information mentioned in the above method embodiments may further include: rule state information; correspondingly, each of the above method embodiments may further include the steps of:
and marking whether the query and check task is available or not by adopting the rule state information.
Wherein the rule state may include: a valid state or an invalid state. If the query check task is marked as a valid state, the query check task is available. And if the query check task is marked as an invalid state, indicating that the query check task is unavailable. The available query and check tasks are initiated and executed when the initiation conditions are met; the unavailable query task is not initiated and executed at all. In general, the rule state information of the query and check task is a valid state by default. The purpose of adding the rule state information for the query and verification task is to provide an interactive interface for closing or opening the query and verification task, and a user can open or close the query and verification task at any time by changing the rule state information.
It should be noted that: the execution subjects of the steps of the method provided by the above embodiments may be the same device, or different devices may be used as the execution subjects of the method. For example, the execution subjects of steps 101 to 103 may be device a; for another example, the execution subject of steps 101 and 102 may be device a, and the execution subject of step 103 may be device B; and so on.
Fig. 8 is a schematic structural diagram illustrating an automatic verification rule generating apparatus according to an embodiment of the present invention. As shown in fig. 8, the apparatus includes: a first obtaining module 301, a second obtaining module 302, a determining module 303 and a generating module 304. The first obtaining module 301 is configured to obtain task configuration information input by a user through a check rule configuration table; the second obtaining module 302 is configured to obtain a check item in the online analysis processing report; the determining module 303 is configured to determine, according to header information of the online analysis processing report, location information of the check item in the online analysis processing report; the generating module 304 is configured to generate a query and check task for initiating query of entry content of the online analysis processing report and checking entry content corresponding to the check entry according to the location information and the task configuration information.
Further, the first obtaining module 301 is further configured to: displaying the check rule configuration table on a user interface; receiving the task configuration information input by a user through the check rule configuration table; wherein the task configuration information at least comprises: the task execution frequency, the verification type information, the verification mode and the verification reference information.
Further, the second obtaining module 302 is further configured to: displaying a check control on an online analysis processing report display interface; and taking a cell as the check item in response to a sequential trigger event aiming at the check control and the cell in the online analysis processing report.
Further, the determining module 303 is further configured to: if the header information of the online analysis processing report is a single-stage header, taking the absolute row coordinate and the absolute vertical coordinate of the check item in the online analysis processing report as the position information; and if the header information of the online analysis processing report is a multi-level header, taking the header information corresponding to the check item and the relative row coordinate or the relative column coordinate of the check item in the table area where the header information is located as the position information.
Further, the device may further include: the device comprises an initiating module, a query module, a third acquisition module, a processing module and a comparison module. The initiating module is used for triggering a query task when a frequency setting time interval appointed by the task execution frequency is reached; the query module is used for querying the table item content of the online analysis processing report in the delay time period set by the task execution delay rule from a database; the third acquisition module is used for acquiring at least one table item content at the position information from the online analysis processing report as at least one check item value participating in checking according to the check type information, the check mode and the position information; the processing module is used for processing the at least one check item value according to the check mode to obtain a value to be checked corresponding to the check mode; the comparison module is used for comparing the value to be verified with the verification reference information to obtain a verification result.
Further, the information generating apparatus further includes: alarm mode and alarm object; and the apparatus may further comprise an alarm module. And the alarm module is used for sending an alarm prompt to the alarm object according to the alarm mode when the verification result is abnormal.
Further, the task configuration information may further include: rule state information; and the apparatus further comprises: and a marking module. The marking module is used for marking whether the query and check task is available or not by adopting the rule state information.
Further, the task configuration information may further include: and (5) a checking module. The checking module is used for checking the task configuration information; and the generating module is further used for generating an inquiry and verification task for initiating inquiry of the table item contents of the online analysis processing report and verifying the table item contents corresponding to the verification items according to the position information and the task configuration information if the task configuration information passes the verification.
Further, the information generating apparatus may further include: and a display module. The display module is used for displaying a failure prompt on a user interface when the task configuration information is not verified.
Here, it should be noted that: the information generating apparatus provided in the foregoing embodiments may implement the technical solutions described in the foregoing method embodiments, and the specific implementation principle of each module or unit may refer to the corresponding content in the foregoing method embodiments, which is not described herein again.
An embodiment of the invention also provides electronic equipment. As shown in fig. 9, the electronic device includes a processor 401 and a memory 402, where the memory 402 is used for storing a program that supports the processor 401 to execute the information generating method provided in the foregoing embodiments, and the processor 401 is configured to execute the program stored in the memory 402.
The program comprises one or more computer instructions for execution invoked by the processor 401. The one or more computer instructions, when executed by processor 401, enable the steps in the above-described information generation method.
The memory 402, which is a non-volatile computer-readable storage medium, may be used to store non-volatile software programs, non-volatile computer-executable programs, and modules, such as program instructions/modules corresponding to the information generating method in the embodiment of the present invention (for example, the first obtaining module 301, the second obtaining module 302, the determining module 303, and the generating module 304 shown in fig. 8). The processor 401 executes various functional applications and data processing of the electronic device, that is, implements the information generating method of the above-described method embodiment, by executing the nonvolatile software program, instructions, and modules stored in the memory 402.
The processor 401 is configured to: acquiring task configuration information input by a user through a check rule configuration table; acquiring a check item in an online analysis processing report; determining the position information of the check item in the online analysis processing report according to the header information of the online analysis processing report; and generating a query and verification task for initiating query of the table item contents of the online analysis processing report and verifying the table item contents corresponding to the verification items according to the position information and the task configuration information.
The processor 401 may execute the method provided by the embodiment of the present invention, and has corresponding functional modules and beneficial effects of the execution method, and reference may be made to the method provided by the embodiment of the present application for technical details that are not described in detail in the embodiment.
The embodiments of the present invention further provide a computer-readable storage medium storing a computer program, where the computer program, when executed by a computer, can implement the steps in the information generating method provided in the above embodiments.
The above-described embodiments of the apparatus are merely illustrative, and the units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware. With this understanding in mind, the above-described technical solutions may be embodied in the form of a software product, which can be stored in a computer-readable storage medium such as ROM/RAM, magnetic disk, optical disk, etc., and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the methods described in the embodiments or some parts of the embodiments.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
The invention discloses a1 and an information generation method, which comprises the following steps:
acquiring task configuration information input by a user through a check rule configuration table;
acquiring a check item in an online analysis processing report;
determining the position information of the check item in the online analysis processing report according to the header information of the online analysis processing report;
and generating a query and verification task for initiating query of the table item contents of the online analysis processing report and verifying the table item contents corresponding to the verification items according to the position information and the task configuration information.
A2, the method as in A1, wherein the obtaining the check items in the online analytic processing report includes:
displaying a check control on an online analysis processing report display interface;
and taking a cell as the check item in response to a sequential trigger event aiming at the check control and the cell in the online analysis processing report.
A3, the method as in A1, wherein the determining the location information of the check item in the online analytic processing report according to the header information of the online analytic processing report includes:
if the header information of the online analysis processing report is a single-stage header, taking the absolute row coordinate and the absolute vertical coordinate of the check item in the online analysis processing report as the position information;
and if the header information of the online analysis processing report is a multi-level header, taking the header information corresponding to the check item and the relative row coordinate or the relative column coordinate of the check item in the table area where the header information is located as the position information.
A4, the method as in any one of the above A1 to A3, wherein the obtaining the task configuration information input by the user through the check rule configuration table includes:
displaying the check rule configuration table on a user interface;
receiving the task configuration information input by a user through the check rule configuration table;
wherein, the task configuration information at least comprises the following items: the method comprises the following steps of task execution frequency, task execution delay rules, verification type information, verification modes and verification reference information.
A5, the method as in a4, further comprising:
initiating the query and verification task when a time interval set by the task execution frequency is reached;
inquiring the table item content of the online analysis processing report in a delay time period set by the task execution delay rule from a database;
acquiring at least one table item content at the position information from the online analysis processing report as at least one check item value participating in checking according to the checking type information, the checking mode and the position information;
processing the at least one check item value according to the check mode to obtain a value to be checked corresponding to the check mode;
and comparing the value to be verified with the verification reference information to obtain a verification result.
A6, the method as in A5, wherein the task configuration information further includes: alarm mode and alarm object; and
the method further comprises the following steps:
and if the verification result is abnormal, sending an alarm prompt to the alarm object according to the alarm mode.
A7, the method as stated in the above a5 or a6, the task configuration information further includes: rule state information; and
the method further comprises the following steps:
and marking whether the query and check task is available or not by adopting the rule state information.
A8, the method of any preceding A1 to A3, further comprising:
checking the task configuration information; and
generating an inquiry checking task for initiating inquiry of the table item content of the online analysis processing report and checking the table item content corresponding to the checking item according to the position information and the task configuration information, wherein the inquiry checking task comprises the following steps:
and if the task configuration information passes the verification, generating a query verification task for initiating query of the table item content of the online analysis processing report and verifying the table item content corresponding to the verification item according to the position information and the task configuration information.
A9, the method as in A8, further comprising:
and if the task configuration information is not verified, displaying a failed prompt on a user interface.
The invention also discloses B10, an information generating device, comprising:
the first acquisition module is used for acquiring task configuration information input by a user through a check rule configuration table;
the second acquisition module is used for acquiring the check items in the online analysis processing report;
the determining module is used for determining the position information of the check item in the online analysis processing report according to the header information of the online analysis processing report;
and the generating module is used for generating an inquiry and verification task for initiating inquiry of the table item content of the online analysis processing report and verification of the table item content corresponding to the verification item according to the position information and the task configuration information.
B11, the apparatus as described in B10 above, the second obtaining module further configured to:
displaying a check control on an online analysis processing report display interface;
and taking a cell as the check item in response to a sequential trigger event aiming at the check control and the cell in the online analysis processing report.
B12, the apparatus as described above in B10, the determining module further configured to:
if the header information of the online analysis processing report is a single-stage header, taking the absolute row coordinate and the absolute vertical coordinate of the check item in the online analysis processing report as the position information;
and if the header information of the online analysis processing report is a multi-level header, taking the header information corresponding to the check item and the relative row coordinate or the relative column coordinate of the check item in the table area where the header information is located as the position information.
B13, the apparatus as described in any of the above B10-B12, the first obtaining module further configured to:
displaying the check rule configuration table on a user interface;
receiving the task configuration information input by a user through the check rule configuration table;
wherein the task configuration information at least comprises: the task execution frequency, the verification type information, the verification mode and the verification reference information.
B14, the device as described in B13 above, further comprising:
the initiating module is used for initiating the query and verification task when a time interval set by the task execution frequency is reached;
the query module is used for querying the table item content of the online analysis processing report in the delay time period set by the task execution delay rule from a database;
a third obtaining module, configured to obtain, according to the verification type information, the verification method, and the location information, at least one entry content at the location of the location information from the online analysis processing report as at least one verification entry value participating in verification;
the processing module is used for processing the at least one check item value according to the check mode to obtain a value to be checked corresponding to the check mode;
and the comparison module is used for comparing the value to be verified with the verification reference information to obtain a verification result.
B15, the device as stated in the above B14, the task configuration information further includes: alarm mode and alarm object; and
the device, still include:
and the alarm module is used for sending an alarm prompt to the alarm object according to the alarm mode when the verification result is abnormal.
B16, the device as described in the above B14 or B15, further including in the task configuration information: rule state information; and
the device further comprises:
and the marking module is used for marking whether the query and check task is available or not by adopting the rule state information.
B17, the device as described in any of the above B10-B12, further comprising:
the checking module is used for checking the task configuration information; and
and the generation module is also used for generating an inquiry and verification task for initiating inquiry of the table item content of the online analysis processing report and verifying the table item content corresponding to the verification item according to the position information and the task configuration information if the task configuration information passes the verification.
B18, the device as described in B17 above, further comprising:
and the display module is used for displaying a failed prompt on a user interface when the task configuration information is not verified.
The invention also discloses C19, an electronic device, comprising a memory and a processor; the storage is for storing one or more computer instructions which, when executed by the processor, are capable of performing the steps of the method of any one of A1-A9 above.
The invention also discloses C20, a computer readable storage medium storing a computer program which, when executed by a computer, can implement the steps of the method of any one of A1-A9.

Claims (20)

1. An information generating method, comprising:
acquiring task configuration information input by a user through a check rule configuration table;
acquiring a check item in an online analysis processing report;
determining the position information of the check item in the online analysis processing report according to the header information of the online analysis processing report;
generating an inquiry checking task for initiating inquiry of the table item contents of the online analysis processing report and checking the table item contents corresponding to the checking items according to the position information and the task configuration information;
the acquiring of the task configuration information input by the user through the check rule configuration table includes:
displaying the check rule configuration table on a user interface;
receiving the task configuration information input by a user through the check rule configuration table;
wherein, the task configuration information at least comprises the following items: the method comprises the following steps of task execution frequency, task execution delay rules, verification type information, verification modes and verification reference information;
the information generation method further includes:
inquiring the table item content of the online analysis processing report in a delay time period set by the task execution delay rule from a database;
taking at least one table entry content as at least one check entry value participating in the check;
processing the at least one check item value according to the check mode to obtain a value to be checked corresponding to the check mode;
and comparing the value to be verified with the verification reference information to obtain a verification result.
2. The method of claim 1, wherein the obtaining the check terms in the online analytical processing report comprises:
displaying a check control on an online analysis processing report display interface;
and taking a cell as the check item in response to a sequential trigger event aiming at the check control and the cell in the online analysis processing report.
3. The method of claim 1, wherein determining the location information of the check item in the online analytics processing report based on the header information of the online analytics processing report comprises:
if the header information of the online analysis processing report is a single-stage header, taking the absolute row coordinate and the absolute vertical coordinate of the check item in the online analysis processing report as the position information;
and if the header information of the online analysis processing report is a multi-level header, taking the header information corresponding to the check item and the relative row coordinate or the relative column coordinate of the check item in the table area where the header information is located as the position information.
4. The method of claim 1, further comprising:
and acquiring at least one table item content at the position information from the online analysis processing report as at least one check item value participating in checking according to the checking type information, the checking mode and the position information.
5. The method of claim 4, further comprising: and initiating the query and check task when a time interval set by the task execution frequency is reached.
6. The method of claim 1, wherein the task configuration information further comprises: alarm mode and alarm object; and
the method further comprises the following steps:
and if the verification result is abnormal, sending an alarm prompt to the alarm object according to the alarm mode.
7. The method according to claim 1, 4, 5 or 6, wherein the task configuration information further comprises: rule state information; and
the method further comprises the following steps:
and marking whether the query and check task is available or not by adopting the rule state information.
8. The method of any of claims 1 to 3, further comprising:
checking the task configuration information; and
generating an inquiry checking task for initiating inquiry of the table item content of the online analysis processing report and checking the table item content corresponding to the checking item according to the position information and the task configuration information, wherein the inquiry checking task comprises the following steps:
and if the task configuration information passes the verification, generating a query verification task for initiating query of the table item content of the online analysis processing report and verifying the table item content corresponding to the verification item according to the position information and the task configuration information.
9. The method of claim 8, further comprising:
and if the task configuration information is not verified, displaying a failed prompt on a user interface.
10. An information generating apparatus, characterized by comprising:
the first acquisition module is used for acquiring task configuration information input by a user through a check rule configuration table;
the second acquisition module is used for acquiring the check items in the online analysis processing report;
the determining module is used for determining the position information of the check item in the online analysis processing report according to the header information of the online analysis processing report;
a generating module, configured to generate, according to the location information and the task configuration information, an inquiry check task that initiates an inquiry about the contents of the entries of the online analysis processing report and checks the contents of the entries corresponding to the check entries;
the first obtaining module is further configured to:
displaying the check rule configuration table on a user interface;
receiving the task configuration information input by a user through the check rule configuration table;
wherein the task configuration information at least comprises: the task execution frequency, the verification type information, the verification mode and the verification reference information;
the information generating apparatus further includes:
the query module is used for querying the table item content of the online analysis processing report in the delay time period set by the task execution delay rule from a database;
the third acquisition module takes the content of at least one table entry as at least one check entry value participating in checking;
the processing module is used for processing the at least one check item value according to the check mode to obtain a value to be checked corresponding to the check mode;
and the comparison module is used for comparing the value to be verified with the verification reference information to obtain a verification result.
11. The apparatus of claim 10, wherein the second obtaining module is further configured to:
displaying a check control on an online analysis processing report display interface;
and taking a cell as the check item in response to a sequential trigger event aiming at the check control and the cell in the online analysis processing report.
12. The apparatus of claim 10, wherein the determining module is further configured to:
if the header information of the online analysis processing report is a single-stage header, taking the absolute row coordinate and the absolute vertical coordinate of the check item in the online analysis processing report as the position information;
and if the header information of the online analysis processing report is a multi-level header, taking the header information corresponding to the check item and the relative row coordinate or the relative column coordinate of the check item in the table area where the header information is located as the position information.
13. The apparatus according to claim 10, wherein the third obtaining module is configured to obtain, from the online analysis processing report, at least one entry content of the location information as at least one check entry value participating in the check according to the check type information, the check method, and the location information.
14. The apparatus of claim 13, further comprising:
and the initiating module is used for initiating the query and verification task when a time interval set by the task execution frequency is reached.
15. The apparatus of claim 10, wherein the task configuration information further comprises: alarm mode and alarm object; and
the device, still include:
and the alarm module is used for sending an alarm prompt to the alarm object according to the alarm mode when the verification result is abnormal.
16. The apparatus according to claim 10, 13, 14 or 15, wherein the task configuration information further comprises: rule state information; and
the device further comprises:
and the marking module is used for marking whether the query and check task is available or not by adopting the rule state information.
17. The apparatus of any one of claims 10 to 12, further comprising:
the checking module is used for checking the task configuration information; and
and the generation module is also used for generating an inquiry and verification task for initiating inquiry of the table item content of the online analysis processing report and verifying the table item content corresponding to the verification item according to the position information and the task configuration information if the task configuration information passes the verification.
18. The apparatus of claim 17, further comprising:
and the display module is used for displaying a failed prompt on a user interface when the task configuration information is not verified.
19. An electronic device comprising a memory and a processor; the memory is for storing one or more computer instructions which, when executed by the processor, are capable of performing the steps of the method of any one of claims 1-9.
20. A computer-readable storage medium, in which a computer program is stored, which, when being executed by a computer, is adapted to carry out the steps of the method of any one of claims 1 to 9.
CN201710515752.5A 2017-06-29 2017-06-29 Information generation method and device Active CN107402970B (en)

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 CN107402970A (en) 2017-11-28
CN107402970B true CN107402970B (en) 2020-09-08

Family

ID=60404598

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710515752.5A Active CN107402970B (en) 2017-06-29 2017-06-29 Information generation method and device

Country Status (1)

Country Link
CN (1) CN107402970B (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
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

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8019795B2 (en) * 2007-12-05 2011-09-13 Microsoft Corporation Data warehouse test automation framework

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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

Also Published As

Publication number Publication date
CN107402970A (en) 2017-11-28

Similar Documents

Publication Publication Date Title
US11249981B2 (en) Data quality analysis
US10121114B2 (en) Metadata-driven audit reporting system with hierarchical relationships
US11003563B2 (en) Compliance testing through sandbox environments
EP3949274A1 (en) Systems and methods for improved meeting engagement
US11164110B2 (en) System and method for round trip engineering of decision metaphors
CN107748752B (en) Data processing method and device
CN113076104A (en) Page generation method, device, equipment and storage medium
US11379466B2 (en) Data accuracy using natural language processing
CN107402970B (en) Information generation method and device
CN111897806A (en) Big data offline data quality inspection method and device
CN109783385A (en) A kind of product test method and apparatus
CN111008894A (en) Bank client information period reminding control method and device
CN110941608B (en) Method, device and equipment for generating buried point analysis and funnel analysis report
CN114462370A (en) Method and device for generating view, storage medium and electronic equipment
US8321844B2 (en) Providing registration of a communication
CN110517010A (en) A kind of data processing method, system and storage medium
CN110502404B (en) Early warning processing method based on data management platform and related equipment
CN112416983B (en) Data processing method and device and computer readable storage medium
CN115982153A (en) Index library generation method, model establishment method, device, equipment and storage medium
US20220100631A1 (en) Microservices graph generation
CN117236438A (en) Decision making system, method, device and storage medium
CN117591390A (en) Buried point regression method, medium, device and computing equipment
CN117407513A (en) Question processing method, device, equipment and storage medium based on large language model
CN112733015A (en) User behavior analysis method, device, equipment and medium
CN115471041A (en) Method, device, equipment and storage medium for identifying black product account

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

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.

CB02 Change of applicant information
GR01 Patent grant
GR01 Patent grant