CN116400836A

CN116400836A - Auditing result custom export data middle stage and operation method

Info

Publication number: CN116400836A
Application number: CN202310329364.3A
Authority: CN
Inventors: 雷勇; 杨超; 熊韶光; 龚凌蒙
Original assignee: Jiangxi Communication Industry Service Co ltd
Current assignee: Jiangxi Communication Industry Service Co ltd
Priority date: 2023-03-30
Filing date: 2023-03-30
Publication date: 2023-07-07

Abstract

The invention provides a auditing result custom derived data center and an operation method, and relates to the technical field of computation. The execution module comprises an auditing rule module, a rule deriving module and an auditing report module. When the module is executed, the user interface is displayed through the common item window and all the catalog windows, and a corresponding operation method is set. The running method comprises the steps of establishing auditing rules, accessing a database to obtain auditing result data, analyzing the data to obtain the auditing result data, and generating at least one export file. The invention redefines the corresponding operation method, so that the user can conveniently read the data items and select the data items. The key information of the inspection result is completely displayed by configuring the export rule, the exported data is split into one file or a plurality of files according to the data attribution department, and the attribution department of the abnormal data can be positioned.

Description

Auditing result custom export data middle stage and operation method

Technical Field

The invention relates to the technical field of computation, in particular to a auditing result custom export data center and an operation method.

Background

The data is an important asset for enterprises, the enterprises can accumulate various data in the operation process, and the data can be deeply mined and analyzed through induction and extraction in the later period, so that better decision information is provided for the enterprises. However, although the data can help the enterprises to promote, the quality of the data is very important, so that if one wants to reasonably utilize the data, the enterprise needs to treat the data first, and the accuracy and the effectiveness of the data are ensured.

In the existing data center operation process, due to the large data presentation amount, a user is very inconvenient to browse data items and select the data items. When the data items are selected to derive the checking result, the current common data quality checking result only can display partial information of the data, and the home department of the data can not be positioned, so that the subsequent correction feedback is inconvenient.

Therefore, the existing audit result data middle station needs to be updated from the data presentation mode.

Disclosure of Invention

In order to solve the technical problems, the invention provides a auditing result custom export data center and an operation method, which enable a user to more conveniently read data items and select the data items by setting a display configuration interface of the data items and defining an input command mode, thereby improving the operation efficiency; and by configuring the export rule, the key information of the inspection result is completely displayed, and one-key export offline viewing is supported, so that the inspection is very convenient.

The invention comprises a auditing result custom export data middle table of the first aspect; and the auditing result self-defining and leading out the data middle platform operation method in the second aspect.

The audit result self-defined data middle platform comprises a data source formed by a data storage device, an execution module and a configuration interface displayed on a display. The execution module comprises an auditing rule module with a plurality of task configurations, an export rule module for exporting key fields and an auditing report module for checking and exporting auditing results.

When executing any one of the modules and pushing the configuration interface to the display, the configuration interface is provided with at least a common item window for displaying the alternative catalogs, any position except for the check boxes of the alternative catalogs in the common item window is provided with a first instruction receiving area for receiving a user request to view more alternative catalogs.

And after receiving an instruction of viewing more alternative catalogs, which is requested by a user in the first instruction receiving area, switching the common item window to an all-catalog window for displaying all the alternative catalogs in batches.

The audit rule module is used for specific task configuration, and when the audit rule module is executed and the configuration interface is pushed to the display, the alternative catalogue displayed by the configuration interface at least comprises options of record number verification, null value verification, uniqueness verification, data format verification, accuracy verification, logic verification, fluctuation verification and custom verification.

The export rule module is used for maintaining key fields exported by the auditing result; when the export rule module is executed and the configuration interface is pushed to the display, the alternative catalog presented by the configuration interface includes at least export rule key fields.

And when the auditing report module is executed and the configuration interface is pushed to the display, the alternative catalogue displayed by the configuration interface at least comprises an alternative data catalogue of the auditing result.

The above-mentioned audit result custom exports the data middle station, wherein the first instruction receiving area starts all directory windows by receiving the mouse input command; the mouse input command is the rolling or clicking of a key in the mouse in the first instruction receiving area.

The above-mentioned audit result custom-derived data middle stage, wherein, at least excluding the rest positions except check boxes in all directory windows, there is a second instruction receiving area for receiving user request to newly create an all directory window and closing the last all directory window currently displayed; and continuously displaying the rest alternative catalogs which are not displayed in the all catalog window by newly creating the all catalog window.

The above-mentioned audit result custom exports data center, wherein the user request is implemented through mouse input, specifically: clicking the left mouse button creates an all-directory window, and clicking the right mouse button closes the last all-directory window currently displayed.

After the instruction receiving area of the all-directory window is newly built, the mouse pointer jumps to the newly built all-directory window.

After closing one all directory window, the mouse pointer jumps to the last all directory window currently displayed; when the current configuration interface has no all directory windows, the mouse pointer jumps to the common item window.

The audit result custom export data middle platform is as described above, wherein the first virtual button for receiving a mouse input command to create an all-directory window or close the last all-directory window currently displayed is provided in all-directory windows.

After creating an all-directory window, the mouse pointer jumps to the first virtual button in the created all-directory window.

After closing one full directory window, the mouse pointer jumps to the first virtual button in the last full directory window currently displayed.

When the current configuration interface has no all directory windows, the mouse pointer jumps to the common item window.

The above-mentioned self-defined data export platform of auditing result, wherein, the position where the check boxes are located in all directory windows is provided with a third instruction receiving area for selecting or deselecting the check boxes, when the mouse pointer is in the third instruction receiving area, the key rolling operation in the mouse is received, and then check boxes of alternative directories in all directory windows are checked in turn from one direction to the other direction; or sequentially cancel checked check boxes from one direction to the other.

After clicking one check box by the middle button of the mouse, receiving the scrolling operation of the middle button of the mouse, and sequentially checking the rest check boxes from the check box to one direction or the other direction; or cancel the checked check box from one direction or the other.

The audit result custom export data middle table, wherein all directory window display areas at least occupy more than 90% of the height range of the configuration interface; the configuration interface may display a plurality of all directory windows in a row, each of the all directory windows displaying a portion of the all candidate directories.

The above-mentioned audit result custom export data middle station, wherein all directory windows have key field request input boxes, and the selection request mode for selecting key fields is as follows:

determining the key field according to the selection request, and storing the key field and the standard data in an associated manner; and operating the alternative catalogue corresponding to the key field matched with the target field according to the submitted query request.

The above-mentioned audit result custom export data middle station, wherein the execution module at least further comprises:

and the domain rule module is used for executing the merging of excel after the inspection result is exported.

And selecting an inspection rule module, determining an inspection task according to the selected inspection rule, and configuring a data chart to be inspected according to the inspection task.

And the configuration flow module is used for configuring at least one auditing task into an auditing flow in a dragging mode.

And the timing execution module is used for creating a scheduling information configuration timing execution strategy.

And the auditing report module is used for checking auditing result data and supporting export after the auditing flow scheduling execution is completed.

The method for operating the audit result custom derived data center is realized through the audit result custom derived data center of the first aspect.

The method for self-defining and exporting the data center operation of the auditing result comprises the following steps:

s1: and establishing an auditing rule through an auditing rule module, establishing a domain dividing rule by a domain dividing rule module, and leading out corresponding task configuration.

S2: and acquiring detailed rules of the sub-domains including the configuration of the sub-domain fields and the export configuration of the auditing result according to the sub-domain rules.

S3: and accessing a database to obtain inspection result data.

S4: traversing the inspection result data, acquiring a domain field value according to the domain field configuration, and acquiring a corresponding domain name according to the domain value and the domain rule.

S05: according to the configuration of the audit result export, configuring audit result data to be exported, and exporting one of a single table and a plurality of tables, specifically:

and maintaining merging and splitting of the export files through the domain dividing rule module, so that at least one export file is generated after the audit result data is exported, and the export file generates an excel report file.

The method for customizing and exporting the data center operation of the auditing result further comprises the following steps:

s11: and when traversing the auditing result data, carrying out exception checking on the auditing result data through the auditing rules.

S12: and obtaining the abnormal data after verification, and obtaining a data primary key set for the abnormal data.

S13: and (3) reversely checking the detailed rule information of the access database, auditing the configuration of the export header, the configuration of the sub-domain fields and the sub-domain through the audit rule record, and positioning the access database to the attribution department of the abnormal data.

The checking result data is subjected to exception checking, including one or a combination of record number checking, null value checking, uniqueness checking, data format checking, accuracy checking, logic checking and fluctuation checking and custom checking.

The invention has the beneficial effects that:

the selection and deselection modes of the alternative catalogue check boxes are defined through the display modes of the alternative catalogues in the configuration interface and the mode of opening and closing the alternative catalogue viewing windows, so that a user can conveniently browse data items and select the data items, and the operation efficiency is improved.

The key information of the inspection result is completely displayed through configuration of the export rule, one-key export offline viewing is supported, exported data is split into one file or a plurality of files according to the data attribution department, and the export data can be positioned to the attribution department of abnormal data, so that subsequent rectifying feedback is facilitated.

Drawings

In order to more clearly illustrate the technical solutions to which the embodiments of the present application relate, the drawings that are needed in the description of the embodiments will be briefly described below, however, the drawings in the following description are only some embodiments of the present application, and other drawings can be easily obtained according to these drawings without inventive effort for a person skilled in the art.

FIG. 1 is a schematic diagram of a structure of a middle stage of audit result custom export data according to the present invention;

FIG. 2 is a schematic diagram of a commonly used items window displayed in the configuration interface of the present invention;

FIG. 3 is a schematic diagram of an overall catalog window displayed in the configuration interface of the present invention;

FIG. 4 is a schematic diagram of mouse operations in a full directory window.

1-a display; 2-a common item window; 3-all directory windows; 4-check boxes; 5-a first instruction receiving area; 6-key field request input box; 7-an alternative directory; 8-a second instruction receiving area; 9-a third instruction receiving area; 10-a first virtual button; 12-instruction schematic for opening and closing an entire directory window; 13-check and uncheck check boxes.

Description of the embodiments

Example one:

in this embodiment, the audit result custom exports the data center, including the data source composed of the data storage device, the configuration interface displayed on the display 1, the execution module formed by the execution code, wherein the code is written into another storage device, and belongs to a different storage device from the data storage device, but may also be the same storage device.

Through the illustration in fig. 1, the audit result custom export data middle stage of this example is composed of audit rule, configuration design, data source.

Referring to fig. 1, the execution module includes an audit rule module with a plurality of task configurations, an export rule module for exporting key fields, and an audit report module for viewing and exporting audit results.

The auditing task of the data quality system configuration is to select a specific configuration, the optional configuration comprises various options such as record number verification, null value verification, uniqueness verification, data format verification, accuracy verification, logic verification, fluctuation verification, custom verification and the like, wherein the auditing rule module is used for specific task configuration, and when the auditing rule module is executed and the configuration interface is pushed to the display 1, the alternative catalogue displayed by the configuration interface is the record number verification, null value verification, uniqueness verification, data format verification, accuracy verification, logic verification, fluctuation verification and custom verification and the like, and when the corresponding configuration is checked, the auditing task is completed according to the configuration.

The export rule module is used for maintaining key fields exported by the auditing result; when executing the export rule module and pushing the configuration interface to the display 1, the alternative catalogue presented by the configuration interface mainly refers to the export rule key field.

And the auditing report module is used for checking auditing result data and supporting one-key exporting of an excel report file after the auditing flow scheduling execution is completed.

The domain rule module is used for maintaining the combination of excels after the audit result is exported, for example, the audit result report generates a plurality of excel report files according to the dimension of the affiliated company. Because the auditing rules of the present invention include single-table rules and multi-table rules.

The selected auditing rule module determines auditing tasks according to the selected auditing rules, and configures data charts (data tables or views) to be audited according to the auditing tasks. The invention can realize the custom rule for the auditing rule.

The configuration flow module executes at least one auditing task and configures the auditing task into an auditing flow in a dragging mode so as to facilitate unified browsing and viewing.

The timing execution module is used for creating a scheduling information configuration timing execution strategy.

The invention maintains the key field derived from the auditing result through the configuration of the auditing rule module, and the configuration of the domain rule module and other modules call corresponding functional configuration to enable the auditing report to support the custom display content or the content derived by the custom setting.

The above examples enable the audit report export files to be flexibly configured, specifically, the audit report export files support merging according to domain rules, such as: the number of the abnormal data of the inspection report is 100, and the number of companies to which the abnormal data belong is 2, so that the inspection result export file can generate 2 files according to the companies. This facilitates locating the home department for the anomalous data and facilitates subsequent corrective feedback.

Example two:

the auditing result custom exporting data middle stage operation method is realized by the auditing result custom exporting data middle stage in the example I.

The method comprises the following steps:

s21: and establishing auditing rules through an auditing rule module. Specifically, after clicking the new button, starting configuration of the auditing task detail, including:

entering a data quality topic domain: the data quality topic domain module is a classification management, can create different quality inspection topic domains such as projects, contracts, accounting and the like, and controls rights;

entering a newly added data quality topic field: a new quality check topic field such as project, contract, accounting, etc. is created and rights are controlled.

Entering a data quality topic field: jump to the corresponding data quality topic field.

Entering a data quality inspection task domain: and jumping to a corresponding data quality inspection task domain function module.

Selecting whether a packet is newly added: and selecting whether to newly add a data auditing task group according to the task condition.

And (3) operating the newly added data auditing grouping: and finishing the newly added group according to the prompt by using the newly added function of the domain management page.

Entering an audit packet: among the plurality of packets, a corresponding packet is entered.

And starting to select a check rule, wherein the check rule is divided into a plurality of types according to a single-table rule, a multi-table rule and a self-defined checking rule, and is selected according to the situation, and the selectable check rule is as follows:

(1) Checking the recorded number: checking whether the number of data in a certain table is the set number or not, or whether the data in a certain section is in a certain section or not.

(2) Null value checking: checking whether certain field values of a certain table are empty or not and whether the values are in a certain interval or not; the non-conforming data is listed for statistics.

(3) Uniqueness checking: checking whether the field value of a certain field of a certain table has repeated data, and listing the repeated data into statistics.

(4) And (3) checking a data format: checking whether a field value of a field of a certain table meets a certain format (such as character string, integer and date); the non-conforming data is listed for statistics.

(5) And (3) accuracy verification: it is checked whether the values of certain fields of a certain table exactly meet the parameter conditions.

(6) And (3) logic verification: it is checked whether the values of certain fields of a certain table fulfill certain logical conditions. Logic conditions are determined by auditing the expressions.

(7) And (5) fluctuation verification: the values of certain fields of a certain table are checked against the change of the last day, last week, etc. And carrying out statistical treatment on the change condition.

(8) Custom SQL verification: and by writing SQL sentences, checking data, and checking the checking result data to find statistics.

After the verification rule is selected and configured, the accessed database or data source is filled in the source table and the target table, whether the information such as the database is correct or not is required to be configured and confirmed, and if the information such as the source database, the data source and the like is wrong, tasks may be wrong.

And (3) checking result export configuration: configuration of which result data to export, export of single or multiple tables, etc.

And establishing a domain dividing rule through a domain dividing rule module, and maintaining the combination and the splitting of the audit result export files so that one audit result export can generate one or more export files.

Whether there is a domain rule: see if a domain rule already exists.

Newly added domain division rules: and performing new addition export sub-domains according to the prompt.

Selecting a domain field configuration: and selecting the fields to be divided according to the situation, so that the derived result is split.

The configuration flow comprises the following steps: and using a flow designer to carry out flow design on the auditing task to be executed, so that the auditing task is executed sequentially.

Configuring scheduling timing execution: and performing configuration scheduling on tasks which need to be executed multiple times or at specific time.

S22: after the establishment of the auditing rules is completed, the database or the data source is accessed through the link execution of the library, and the data is downloaded to obtain auditing result data. The data source may be external data or internal data.

S23: traversing the inspection result data, acquiring a domain field value according to the domain field configuration, and acquiring a corresponding domain name according to the domain value and the domain rule.

S24: and carrying out exception verification on the auditing result data through the auditing rules.

S25: and obtaining the abnormal data after verification, and obtaining a data primary key set for the abnormal data.

S26: and (3) reversely checking the detailed rule information of the access database, auditing the configuration of the export header, the configuration of the sub-domain fields and the sub-domain through the audit rule record, and positioning the access database to the attribution department of the abnormal data.

S27: configuration is exported according to the auditing result, auditing result data to be exported is configured, and one of a single table and a plurality of tables is exported; maintaining merging and splitting of the export files to lead the audit result data to be exported to generate at least one export file;

s28: after the task is executed, corresponding results exist in the log, and the log can be checked; and meanwhile, the export file generates a corresponding excel report file.

Example three:

in an example two, domain rule module establishes domain rule, and can maintain combination and split of audit result export files, so that one audit result export can generate one or more export files.

After selecting the field configuration of the domain, splitting the exported result, and exporting the checked result data into a single form or a plurality of forms after selecting the field to be divided; and (3) generating one or more excel export files after the audit result data is exported by maintaining the merging and splitting of the export files.

The specific inspection result data obtains a plurality of excel export files through a segmentation rule, and the implementation flow is as follows:

s31: and obtaining auditing rule id and auditing detail data.

Presetting an auditing rule tool: a plurality of different auditing rule tools are arranged under the auditing rule module and are arranged in the auditing rule module tools in advance, and each auditing rule tool defines an auditing rule id; when a certain audit rule id needs to be called, the audit rule module can be operated to acquire the selected audit rule id.

Domain rule tools are also preset, and a domain rule id is defined for the domain rule tools.

S32: by auditing rule ids, into datax process audioexport,

finding out the selected auditing rule id from the datax_process_audio_export_column and deriving the auditing rule id, and configuring the auditing rule after combining a plurality of auditing rule ids.

S33: the configured auditing rule is exported as query sql, and the system obtains the header configuration and domain rule id of a preset exported excel file in an auditing rule module.

S34: and finally, packaging the query sql and the audit detail data, and putting the query sql into a corresponding database for execution to obtain audit result data required by the clients.

S34: and searching a domain dividing rule tool from the selected domain dividing rule id to the datax_audio_range and datax_audio_range_detail, finishing domain dividing configuration, and obtaining detailed rules of the domains.

S35: traversing the inspection result data, acquiring a corresponding domain field value of the current traversing data according to the domain field configuration, and acquiring a corresponding domain name according to the domain value and the domain rule of the current data.

When traversing data for the first time, creating a map with a key as a domain object value and an excel write object. Firstly acquiring a domain name from the traversal data, then judging whether a key exists in the map object as a current domain object, and if the key exists in the map object, acquiring an excel writing object of the map and writing the current traversal data; if not, a new excel writing object is created to write the current data, and put into the map object.

And generating a corresponding excel report file according to the excel writing object in the map.

Example four:

in an example two, performing exception verification on the auditing result data through the auditing rule; the method comprises the steps of obtaining abnormal data after verification, and obtaining a data primary key set for the abnormal data; and the access database, the audit export header configuration, the domain field configuration and the detailed rule information of the domain are reversely checked through the audit rule record, and the home department of the abnormal data is positioned.

One example is as follows:

s41: configuring a single table null value auditing rule, and auditing data with a mo_proj_info field being null; executing the auditing task may obtain that the abnormal data of this auditing rule is a primary key set with the demo_proj_info field being empty, such as:

[‘a7c86963-a917-11ed-b95e-005056add07e’,

‘ad78d220-a917-11ed-b95e-005056add07e’,

‘b64976e6-a917-11ed-b95e-005056add07e’]

rule id= '20850534-3189-4243-a1bf-9a3633283480' as this audit '

Custom export execution sql, audit export header configuration, audit domain-division field, domain-division rule id can be found by the rule id lookup table datax_process_audio_export record.

One example of this gives custom derived execution sql:

select

a.PROJ_CODE,

a.proj_name,

a.PROJ_TYPE,

a.PROVINCE_ID,

b.ORG_NAME,

a.BUDEGT_COST

from demo_proj_info a

inner join demo_org b on a.PROVINCE_ID = b.id

where a.id in ${ids}

in one example, the header export configuration is as follows:

table 1: header export configuration

Field name	Field Chinese name	Type(s)	Ranking value
				PROJ_CODE	Item numbering	Character string	1
PROJ_NAME	Project name	Character string						2
				PROJ_TYPE	Item type	Character string			3
PROVINCE_ID	Province number	Character string						4
				ORG_NAME	The provinces of	Character string	5
BUDEGT_COST	Budget cost	Character string						6

The final derived statement can be obtained by combining the audit rule exception data and the custom derived execution sql as follows:

select

a.PROJ_CODE,

a.proj_name,

a.PROJ_TYPE,

a.PROVINCE_ID,

b.ORG_NAME,

a.BUDEGT_COST

from demo_proj_info a

inner join demo_org b on a.PROVINCE_ID = b.id

where a.id in (‘a7c86963-a917-11ed-b95e-005056add07e',

‘ad78d220-a917-11ed-b95e-005056add07e',

‘b64976e6-a917-11ed-b95e-005056add07e')

Acquiring corresponding domain rule configuration and rule types according to the domain rule id lookup tables datax_audio_range and datax_audio_range_detail: start value.

The value mapping details are as follows:

table 2: value mapping detail table

Domain name	Value of
		Shanghai	31
(Jiangxi)	36

After executing the final export statement, the audit result data is obtained as follows.

Table 3: obtained audit result data

PROJ_CODE	proj_name	PROJ_TYPE	PROVINCE_ID	ORG_NAME	BUDEGT_COST
						XM00001	Test item 01	SJ	36	(Jiangxi)	10000
XM00002	Test item 02	GC	36	(Jiangxi)	20000
						XM00004	Test item 04	QT	31	Shanghai	40000

The data of the auditing result obtained in the table 3 is traversed, the threshold value of each piece of data is obtained, a corresponding excel export file is created, and the final export result is exemplified in the following tables 4 and 5:

table 4: export File 1, domain name called Jiangxi

Item numbering	Project name	Item type	Province number	The provinces of	Budget cost
						XM00001	Test item 01	SJ	36	(Jiangxi)	10000
XM00002	Test item 02	GC	36	(Jiangxi)	20000

Table 5: export File 2, domain name called Shanghai

Item numbering	Project name	Item type	Province number	The provinces of	Budget cost
						XM00004	Test item 04	QT	31	Shanghai	40000

Example five:

the auditing result self-defined export data middle stage comprises a data source formed by a data storage device, an execution module and a configuration interface displayed on a display 1.

The execution module is at least provided with the following modules: the system comprises (1) an auditing rule module with a plurality of task configurations, (2) an export rule module for exporting key fields, and (3) an auditing report module for checking and exporting auditing results.

When the auditing rule module is executed and the configuration interface is pushed to the display 1, the alternative catalogue displayed by the configuration interface at least comprises options of record number verification, null value verification, uniqueness verification, data format verification, accuracy verification, logic verification, fluctuation verification and custom verification. Of course, other options are possible depending on the application scenario.

The export rule module is used for maintaining key fields exported by the auditing result; when the export rule module is executed and the configuration interface is pushed to the display 1, the alternative catalogue displayed by the configuration interface at least comprises an export rule key field; of course, other options are possible depending on the application scenario.

When the auditing report module is executed and the configuration interface is pushed to the display 1, the alternative catalogue displayed by the configuration interface is mainly an alternative data catalogue of the auditing result.

Referring to fig. 2, when executing the above auditing rule module or the export rule module or the auditing report module, especially when executing the auditing report module, the configuration interface pushed to the display 1 has at least a common item window 2 for displaying an alternative catalog. The common items window is a portlet which shows common items or, illustratively, a small portion of the candidate catalog 7. In one example, the widget occupies less than one fifth of the display, or when the entire display tiles the configuration interface, the widget occupies less than one fifth of the configuration interface, and due to the small widget area, the displayed content is limited, only a small portion of the alternate catalog can be illustratively presented as a common item option.

Within the usual item window 2, any of the remaining positions, except the position in which the alternative catalog check box 4 is located, has a first instruction receiving area 5 for receiving a user request to view more alternative catalogs. In one example, the position of the alternative catalogue check box 4 and the position within a certain range of the periphery are regarded as the positions of the check boxes, including all pixel columns in the common item window where the check box 4 is located, the position of the check box is reserved for checking the check box by mouse operation, and the operation instruction input of the operation check box is reserved so as to avoid overlapping of the operation instruction of opening all catalogue windows and the operation check box operation instruction. Of course, the first instruction receiving area does not include the border of the common item window 2, the title bar and the positions of other virtual keys.

The entire catalog window 3 is started by receiving a mouse input command in the first instruction receiving area 5. The mouse input command is a scroll or click of a key in the mouse within the first instruction receiving area. One example is that clicking a mouse button when the mouse is slid to the first instruction receiving area 5 will open the full directory window; or another example is to arbitrarily scroll the mouse-in key when the mouse is slid to the first instruction receiving area, the entire directory window will be opened. Therefore, the whole catalog window can be opened without moving the mouse pointer to a button such as 'show', 'more' and clicking like the conventional window setting, the operation steps are saved, and the method is very friendly for efficiently viewing the audit report.

The all-directory window 3 attempts to display all of the candidate directories 7 (which may also be referred to as data entries), but is limited by the area of the configuration interface (limited by the physical area of the display), and one all-directory window can only display a portion of all of the candidate directories in batches.

Referring to fig. 3, to simultaneously present more candidate directories 7, the entire directory window display area occupies at least more than 90% of the height range of the configuration interface; the configuration interface bar may expose a plurality of full catalog windows, each full catalog window displaying a portion of the full alternate catalog 7. The candidate directories 7 are arranged longitudinally in sequence in all the directory windows.

The entire catalog window 3 has a key field request input box 6 thereon, wherein the key field is selected by the following selection request method:

The remaining positions of the all-directory window 3 excluding at least the check box 4 are provided with a second instruction receiving area 8 for receiving a user request to create an all-directory window and closing the last all-directory window currently displayed. One example is that in all the directory windows, the position of the check box of the candidate directory and the position of the check box in a certain range around the candidate directory are regarded as the positions of the check boxes, including all pixel columns in all the directory windows where the check boxes are located, the positions of the check boxes are reserved for checking the check boxes by mouse operations, and the operation instruction input of the check boxes is reserved (the mouse directly clicks the check boxes by clicking the left button or receives the key scrolling operation in the mouse), that is, a third instruction receiving area is reserved so as to avoid the coincidence of the operation instruction of opening all the directory windows and the instruction input area of newly creating one all the directory window instructions. Of course, the second instruction receiving area does not include the borders of all directory windows, the title bar and the positions of other virtual keys.

Wherein, a whole catalog window 3 is newly established for continuously displaying the rest candidate catalogs which are not displayed in the previous whole catalog window. In one example, the first all-directory window is located at the left side of the display 1, and when one all-directory window is newly built, the newly built all-directory window is closely attached to the right side of the first all-directory window and is placed side by side; of course, after a new full catalog window is created, the double will be located on the right side of the previous full catalog window. Therefore, the physical space of the display is effectively utilized by all the catalog windows, more alternative catalogs are displayed for the user, and the efficiency of the user for reading the data items is improved.

Referring to fig. 4, a mouse input instruction diagram may be presented in the overall catalog window 3, instructing the user how to submit an instruction using the mouse. The method comprises the following steps: an instruction box 12 for opening and closing one entire directory window, and a check box 13 for checking and unchecking.

In one example, the user request is implemented by mouse input, specifically: clicking the left mouse button will submit an instruction to create an entire directory window, and clicking the right mouse button will submit an instruction to close the last entire directory window currently displayed. When the user operates the instruction, the user does not need to find a conventional opened or closed virtual key and click after moving the mouse; when the method is used, a user can finish creating one whole directory window or closing the current last whole directory window only by directly clicking the left button or the right button of the mouse, so that the efficiency of reading data items and operation of the user is improved.

After the instruction receiving area of the all-directory window is newly built, the mouse pointer jumps to the newly built all-directory window. After closing one all directory window, the mouse pointer jumps to the last all directory window currently displayed; when the current configuration interface has no all directory windows, the mouse pointer jumps to the usual item window 2. Therefore, to open or close an all-directory window, the operation of enabling the user to reduce the sliding of the mouse pointer to search for the virtual key and click is achieved, and after an instruction receiving area of the all-directory window is created, the mouse pointer jumps to a second instruction area in the created all-directory window, and the user only needs to do a mouse click action (directly clicking the left button or the right button of the mouse), so that the created all-directory window can be opened or the current all-directory window can be closed. One example is that after a new all-directory window is created, the mouse pointer jumps to the third instruction area in the new all-directory window, and the user can select the candidate directory in the new all-directory window by simply directly sliding the key in the mouse. For this purpose, the efficiency of the user in viewing data items and operations is improved.

As another example, a first virtual button 10 for receiving a mouse input command to create one entire catalog window or close the last entire catalog window currently displayed is provided in the entire catalog window 3; after creating a full catalog window, the mouse pointer jumps to the first virtual button 10 in the new full catalog window, and after closing a full catalog window, the mouse pointer jumps to the first virtual button 10 in the last full catalog window currently displayed. In this example, the first virtual button 10 is disposed on the right side of all directory windows, and a "+" - "identifier is disposed on the first virtual button, so that a right side can be established again by clicking" + ", and the current all directory windows can be closed by clicking" - ", so that a user does not need to slide a mouse to search for virtual keys during operation, and the efficiency of browsing data items and operation of the user is improved.

When the current configuration interface has no all directory windows, the mouse pointer jumps to the usual item window 2.

In one example, the position of the check box 4 in the whole directory window 3 is provided with a third instruction receiving area 9 for selecting or deselecting the check box, and the third instruction receiving area 9 is located in a pixel column of the check box or comprises a part of pixel columns of the periphery of the check box, so that the third instruction receiving area forms a certain range around the check box. In the whole directory window, after the positions of the border, the title bar and other virtual keys of the directory window are divided, the rest positions are divided into a third instruction receiving area 9 on the left side and a second instruction receiving area 8 on the right side.

When the mouse pointer is positioned in the third instruction receiving area, receiving a key rolling operation in the mouse, and sequentially checking check boxes 4 of the alternative catalogs in all current catalogue windows from one direction to the other direction; or sequentially cancel checked check boxes from one direction to the other. For example, if the middle mouse button is scrolled upwards, check boxes of the alternative catalogs in all the current catalogs are checked from top to bottom in sequence; the middle mouse button is scrolled downwards, so that the check boxes 4 of the alternative catalogs in all the current catalogs windows are checked from bottom to top. For another example, when the check boxes of the candidate directories in the current all directory windows are checked, and the mouse middle key is operated to scroll downwards, the checked check boxes are sequentially unchecked from bottom to top.

When one check box 4 is clicked by utilizing the middle mouse button, the scrolling operation of the middle mouse button is received, and the rest check boxes are checked in sequence from the check box to one direction or the other direction; or cancel the checked check box from one direction or the other. In the example, clicking one of the alternative directory check boxes in the middle of all the current directory windows by using the middle mouse button, and when the middle mouse button is operated to scroll downwards again, starting the check box clicked by the mouse, and sequentially checking the check boxes below from top to bottom; or the check boxes of the alternative catalogs in all the current catalogs are checked, the checked check boxes are sequentially cancelled from top to bottom from the check box clicked by the mouse, and the example is beneficial to discontinuous check box operation.

After the instruction receiving area of the all-directory window is newly built, the mouse pointer automatically jumps to the third instruction area in the all-directory window, and the user can select the alternative directory in the all-directory window by directly sliding the middle mouse button, so that the sliding mouse operation of the user is reduced.

Example six:

the data source (database) of the invention can be an enterprise internal database, an external database, or a cloud network database, but is necessarily composed of a memory; the system is connected with a personal computer through the Internet or an internal data line and a wireless network; the data is downloaded or uploaded after accessing the database through the personal computer. In terms of database storage, single-machine or distributed, relational or non-relational, columnar storage or line storage is possible, and of course, under the condition of small data volume, a single-machine database is generally adopted, such as MySQL which is very widely applied.

The tool platform layer comprises a basic capability technology of data processing, such as a large data platform integrating data acquisition, data storage, data calculation and data security; also included are a series of tools for building data kiosks, such as offline or real-time data development tools, data communication tools, tag calculation tools, algorithm platform tools, data service tools, and self-help analysis tools. Each execution module to be adopted in the example is edited into a form of software codes through a computer, stored in a data storage device serving as a tool platform layer, and executed through a CPU calling code, so that each step in the example is completed.

The display 1 of the present invention is a component of a personal computer, a configuration interface is displayed on the display, each execution module of the present invention is edited into a form of software code by the computer, and stored in a memory of the personal computer, and when running, each step in the above example is completed by a CPU calling the code to execute. It is also possible that each execution module of the present invention is edited in the form of software code, stored in a data source (database), and executed by a CPU calling the code at the time of execution, to complete each step in the above example.

The foregoing is illustrative of the present invention and is merely illustrative of some of the ways in which the invention may be practiced, and is not intended to be the only and it is therefore not intended to limit the scope of the invention to the particular embodiments disclosed. The various examples described above can be joined to form new examples without departing from the spirit of the invention.

Claims

1. The auditing result self-defined data middle stage comprises a data source formed by a data storage device, an execution module and a configuration interface displayed on a display; it is characterized in that the method comprises the steps of,

the execution module comprises an auditing rule module with a plurality of task configurations, an export rule module for exporting key fields and an auditing report module for checking and exporting auditing results;

When executing any one of the modules and pushing the configuration interface to the display, the configuration interface is provided with at least a common item window for displaying the alternative catalogs, any position except for the check boxes of the alternative catalogs in the common item window is provided with a first instruction receiving area for receiving a user request to view more alternative catalogs;

after receiving an instruction of viewing more alternative catalogs, which is requested by a user in a first instruction receiving area, switching the common item window to an all-catalog window for displaying all the alternative catalogs in batches;

the other positions of all the directory windows except at least the check boxes are provided with a second instruction receiving area for receiving a user request to newly establish one all directory window and closing the last all directory window currently displayed; the new whole catalog window continuously displays the rest alternative catalogs which are not displayed in the whole catalog window; the user request is realized through mouse input, specifically: clicking the left button of the mouse to create an all-directory window, and clicking the right button of the mouse to close the last all-directory window currently displayed; after the instruction receiving area of the all-directory window is newly built, the mouse pointer jumps to the newly built all-directory window; after closing one all directory window, the mouse pointer jumps to the last all directory window currently displayed; when the current configuration interface has no all directory windows, the mouse pointer jumps to the common item window.

2. The audit result custom export data middle table according to claim 1, wherein the audit rule module is configured for specific task configuration, and when the audit rule module is executed and the configuration interface is pushed to the display, the alternative directory displayed by the configuration interface at least comprises options of record number verification, null value verification, uniqueness verification, data format verification, accuracy verification, logic verification, fluctuation verification and custom verification;

the export rule module is used for maintaining key fields exported by the auditing result; when the export rule module is executed and the configuration interface is pushed to the display, the alternative catalogue displayed by the configuration interface at least comprises an export rule key field;

3. An audit result custom export data middle station according to claim 1, wherein the first instruction receiving area initiates all directory windows by receiving a mouse input command; the mouse input command is the rolling or clicking of a key in the mouse in the first instruction receiving area.

4. The audit result custom export data middle station of claim 1, wherein a first virtual button for receiving a mouse input command to create an all-directory window or close a last all-directory window currently displayed is arranged in all-directory windows;

after a new all directory window is established, the mouse pointer jumps to a first virtual button in the new all directory window;

after closing one all directory window, the mouse pointer jumps to the first virtual button in the last all directory window currently displayed;

5. An audit result custom export data base according to claim 1,

a third instruction receiving area for selecting or deselecting the check boxes is arranged at the positions of the check boxes in all the directory windows, and when the mouse index is in the third instruction receiving area, the key-in-mouse scrolling operation is received, so that the check boxes of the alternative directories in all the current directory windows are sequentially checked from one direction to the other direction; or sequentially canceling checked check boxes from one direction to the other;

When one check box is clicked by the middle button of the mouse, the scrolling operation of the middle button of the mouse is received, and the rest check boxes are checked in sequence from the check box to one direction or the other direction; or cancel the checked check box from one direction or the other.

6. An audit result custom export data base according to claim 1,

the whole catalog window display area occupies at least more than 90% of the height range of the configuration interface; the configuration interface may display a plurality of all directory windows in a row, each of the all directory windows displaying a portion of the all candidate directories.

7. An audit result custom export data base according to claim 1 wherein the full directory window has a key field request entry box thereon, wherein the key field selection request is selected by:

8. An audit result custom export data base according to claim 1,

The execution module at least further comprises:

the domain rule module is used for executing the merging of excel after the inspection result is exported;

selecting an inspection rule module, determining an inspection task according to the selected inspection rule, and configuring a data chart to be inspected according to the inspection task;

the configuration flow module is used for configuring at least one checking task into a checking flow in a dragging mode;

the timing execution module is used for creating a scheduling information configuration timing execution strategy;

9. An auditing result custom derived data middle stage operation method, which is realized by an auditing result custom derived data middle stage in any one of claims 1-8;

the method comprises the following steps:

s1: establishing an auditing rule through an auditing rule module, establishing a domain dividing rule by a domain dividing rule module, and leading out corresponding task configuration;

s2: acquiring detailed rules of the sub-domains including sub-domain field configuration and audit result export configuration according to the sub-domain rules;

s3: accessing a database to obtain inspection result data;

s4: traversing the inspection result data, acquiring a domain field value according to domain field configuration, and acquiring a corresponding domain name according to the domain value and a domain rule;

10. The method for auditing result custom derived data middle station operation of claim 9, said method further comprising:

s11: when traversing the auditing result data, carrying out exception checking on the auditing result data through the auditing rules;

s12: the method comprises the steps of obtaining abnormal data after verification, and obtaining a data primary key set for the abnormal data;

s13: reversely checking the detailed rule information of the access database, auditing export header configuration, domain field configuration and domain division through the auditing rule record, and positioning the detailed rule information to the attribution department of the abnormal data;