CN111796907A - Data checking method and device based on checking script, electronic equipment and medium - Google Patents
Data checking method and device based on checking script, electronic equipment and medium Download PDFInfo
- Publication number
- CN111796907A CN111796907A CN202010537584.1A CN202010537584A CN111796907A CN 111796907 A CN111796907 A CN 111796907A CN 202010537584 A CN202010537584 A CN 202010537584A CN 111796907 A CN111796907 A CN 111796907A
- Authority
- CN
- China
- Prior art keywords
- checking
- field
- script
- data
- rule
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 40
- 230000004044 response Effects 0.000 claims abstract description 5
- 230000015654 memory Effects 0.000 claims description 16
- 238000004590 computer program Methods 0.000 claims description 11
- 238000001514 detection method Methods 0.000 claims 7
- 230000003287 optical effect Effects 0.000 description 5
- 230000015572 biosynthetic process Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 238000003786 synthesis reaction Methods 0.000 description 3
- 230000006399 behavior Effects 0.000 description 2
- 238000005034 decoration Methods 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 238000013475 authorization Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000012937 correction Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 230000008439 repair process Effects 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/455—Emulation; Interpretation; Software simulation, e.g. virtualisation or emulation of application or operating system execution engines
- G06F9/45504—Abstract machines for programme code execution, e.g. Java virtual machine [JVM], interpreters, emulators
- G06F9/45508—Runtime interpretation or emulation, e g. emulator loops, bytecode interpretation
- G06F9/45512—Command shells
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
- G06F9/44505—Configuring for program initiating, e.g. using registry, configuration files
- G06F9/4451—User profiles; Roaming
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Stored Programmes (AREA)
Abstract
The application provides a data checking method and device based on a checking script, electronic equipment and a medium. The data checking method comprises the following steps: generating a rule configuration file in response to a rule configuration operation of a user; reading the configuration rule file, and generating a corresponding check script for each preset field in the configuration rule file; and executing the checking script to check each field in the target data, and determining a checking table of a corresponding type according to a checking result of each field for a user to check. The checking method is based on the sql definition checking rule of the standard database, and a user can develop the rule only by mastering the writing skill of the standard sql statement. Moreover, the rule configuration based on the text can complete large-batch rule customization without a large amount of operations by a user. The data checking method can automatically generate a checking script (sql script), simplifies the work of deploying online and modifying, can display the checking table, and is convenient for a user to correct data.
Description
Technical Field
The present application relates to the technical field of data checking, and in particular, to a data checking method and apparatus based on a checking script, an electronic device, and a medium.
Background
The data checking is an important link in the data processing process, quality problems existing in input data can be found through the data checking link, and then through generating a data checking result or a data checking report, a person or a company providing data is supervised to improve or repair errors of the data quality, so that a good data base is provided for subsequent data processing. However, existing software-based data checking schemes have a large dependence on software, such as:
(1) if the user wants to adjust (add or modify) the check rule based on the open source software, the user needs to modify, compile and deploy the code under the condition of fully knowing the open source code, and the requirement on user skills is high.
(2) If the checking scheme is based on commercial software, then expensive software purchasing or authorization cost is required. In addition, software-based checking usually only can perform rule configuration by dragging an icon on a page, and cannot import rules in batches (for example, text, excel, and the like), and checking an increased amount of data (the increased amount of data does not refer to a large amount of data, but a large amount of newly added data with different structures, and a corresponding checking rule is established for each increased amount of data) takes a lot of time to drag an icon on a page, and click various buttons or input boxes on the page to perform checking parameter configuration.
(3) In the case of a self-coding based data checking scheme, a user is required to develop a large amount of code. The user needs to compile codes for each check rule, and if new rules are added subsequently, the user needs to modify, compile and deploy the program on line, and needs to perform a large amount of regression tests and other works.
Disclosure of Invention
The present application provides a data checking method, apparatus, electronic device and medium based on a checking script to solve at least one of the above technical problems.
In a first aspect, an embodiment of the present application provides a data checking method based on a checking script, including: generating a rule configuration file in response to a rule configuration operation of a user;
reading the configuration rule file, and generating a corresponding check script for each preset field in the configuration rule file;
and executing the checking script to check each field in the target data, and determining a checking table of a corresponding type according to a checking result of each field for a user to check.
In one embodiment of the present application, the rule profile includes at least: the system comprises at least one preset field, a regular expression for checking each preset field, a checking level corresponding to each regular expression and problem description content corresponding to each checking level.
In an embodiment of the present application, generating a corresponding check script for each preset field in a configuration rule file includes: and generating a checking script corresponding to the preset field according to the regular expression generation of the preset field.
In an embodiment of the present application, determining a corresponding type of check table according to a check result of each field includes: and if the checking result of the field is true, copying and inserting the source record of the field into the checking success table.
In an embodiment of the present application, determining a corresponding type of check table according to a check result of each field includes: and if the checking result of the field is not true and the checking level is warning, inserting the source record of the field into the checking problem table, and copying the source record of the field into the checking success table.
In an embodiment of the present application, determining a corresponding type of check table according to a check result of each field includes: and if the checking result of the field is not true and the checking level is wrong, inserting the source record of the field into the checking problem table.
In one embodiment of the present application, the checking problem table includes at least: the field with the non-true checking result, the checking level corresponding to the field with the non-true checking result, and the problem description content corresponding to each checking level.
In a second aspect, an embodiment of the present application provides a data checking apparatus based on a checking script, including:
the file generating module is used for responding to the rule configuration operation of a user and generating a rule configuration file;
the script generation module is used for reading the configuration rule file and generating a corresponding check script for each preset field in the configuration rule file;
and the field checking module is used for executing the checking script to check each field in the target data, and determining a checking table of a corresponding type according to the checking result of each field for the user to check.
In a third aspect, an embodiment of the present application provides an electronic device, including a memory and a processor, where the processor is communicatively connected to the memory;
the memory stores a computer program, and when the computer program is executed by the processor, the data checking method based on the checking script provided by the above embodiments of the present application is realized.
In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, where a computer program is stored on the storage medium, and when the computer program is executed by a processor, the data checking method based on the checking script provided in the foregoing embodiment of the present application is implemented.
The technical scheme provided by the embodiment of the application at least has the following beneficial effects:
in the embodiment of the application, the data checking method defines the checking rule based on the sql of the standard database, and the user can develop the rule only by mastering the writing skill of the standard sql statement. Moreover, the rule configuration based on the text can complete large-batch rule customization without a large amount of operations by a user. The data checking method can automatically generate a checking script (sql script), a user does not need to develop codes, and the work of deploying online and modifying is simplified. The data checking method can also determine the checking table of the corresponding type according to the checking result, can conveniently display the data checking result and is convenient for a user to correct the data.
Additional aspects and advantages of the present application will be set forth in part in the description which follows and, in part, will be obvious from the description, or may be learned by practice of the present application.
Drawings
The foregoing and/or additional aspects and advantages of the present application will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings of which:
FIG. 1 is a schematic flow chart of a data checking method based on a checking script according to the present application;
FIG. 2 is a block diagram of a data checking apparatus based on a checking script according to the present application;
fig. 3 is a block diagram of an electronic device provided in the present application.
Detailed Description
Reference will now be made in detail to the present application, examples of which are illustrated in the accompanying drawings, wherein like reference numerals refer to the same or similar parts or parts having the same or similar functions throughout. In addition, if a detailed description of the known art is not necessary for illustrating the features of the present application, it is omitted. The embodiments described below with reference to the drawings are exemplary only for the purpose of explaining the present application and are not to be construed as limiting the present application.
It will be understood by those within the art that, unless otherwise defined, all terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application belongs. It will be further understood that terms, such as those defined in commonly used dictionaries, should be interpreted as having a meaning that is consistent with their meaning in the context of the prior art and will not be interpreted in an idealized or overly formal sense unless expressly so defined herein.
As used herein, the singular forms "a", "an", "the" and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will be further understood that the terms "comprises" and/or "comprising," when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof. It will be understood that when an element is referred to as being "connected" or "coupled" to another element, it can be directly connected or coupled to the other element or intervening elements may also be present. Further, "connected" or "coupled" as used herein may include wirelessly connected or wirelessly coupled. As used herein, the term "and/or" includes all or any element and all combinations of one or more of the associated listed items.
First, the terms referred to in the embodiments of the present application will be briefly explained:
structured query language: structured Query Language (SQL), a special purpose programming Language, is a database Query and programming Language for accessing data and querying, updating, and managing relational database systems.
Data checking: and checking the field of each piece of data according to a data rule defined by a user, wherein the field which does not pass the check is not processed in the next stage.
The following describes the technical solutions of the present application and how to solve the above technical problems with specific embodiments.
The embodiment of the application provides a data checking method based on a checking script, and a flow diagram of the data checking method is shown in fig. 1, and the method comprises the following steps:
s101: and generating a rule configuration file in response to the rule configuration operation of the user.
In the embodiment of the application, the rule configuration file is an excel file, and a user performs rule configuration through the excel. The rule configuration file includes at least: the system comprises at least one preset field, a regular expression for checking each preset field, a checking level corresponding to each regular expression and problem description content corresponding to each checking level.
The content of a form of rule configuration file provided by the embodiment of the present application is shown in table 1:
TABLE 1
In table 1, the first row is a header, and in a second row example in table 1, a table name of the row is "TableA", the preset field is "a", the rule expression for checking each preset field is "trim (a) not in (1,2,3, 4)", the checking level "error" corresponds to each rule expression, the problem description content corresponding to the checking level is "a cannot be 1234", and the contents of other rows in table 1 are not described again here.
In table 1, the check level "error" represents an error, the check level "warning" represents an alarm, and the regular expression is an expression based on the standard sql.
S102: and reading the configuration rule file, and generating a corresponding check script for each preset field in the configuration rule file.
In an embodiment of the present application, generating a corresponding check script for each preset field in a configuration rule file includes: and generating a checking script corresponding to the preset field according to the regular expression generation of the preset field. The embodiment of the application provides a python program, and the python program can read a configuration rule file and automatically generate a check script for each preset field.
S103: and executing the checking script to check each field in the target data, and determining a checking table of a corresponding type according to a checking result of each field for a user to check.
In an embodiment of the present application, determining a corresponding type of check table according to a check result of each field includes: and if the checking result of the field is true (true), copying and inserting the source record of the field into the checking success table.
In an embodiment of the present application, determining a corresponding type of check table according to a check result of each field includes: if the checking result of the field is not (false) true and the checking level is warning (warning), inserting the source record of the field into the checking problem table, and copying the source record of the field into the checking success table.
In an embodiment of the present application, determining a corresponding type of check table according to a check result of each field includes: if the checking result of the field is false and the checking level is error, the source record of the field is inserted into the checking problem table.
In one embodiment of the present application, the checking problem table includes at least: the field with the non-true checking result, the checking level corresponding to the field with the non-true checking result, and the problem description content corresponding to each checking level.
The contents of a form of the problem checking table provided by the embodiment of the present application are shown in table 2:
| data ID | Level of check | Field(s) | Description of the invention |
| 123425 | error | a | a cannot be 1234 |
| 123426 | warning | c | c cannot be empty |
TABLE 2
In table 2, the first behavior is a header, and in the second behavior example in table 2, the field whose check result is not true is "a", the check level corresponding to the field whose check result is not true is "error", and the problem description content corresponding to the check level "error" is "a cannot be 1234".
The data checking method provided by the embodiment of the application defines the checking rule based on the sql of the standard database, and a user can develop the rule only by mastering the writing skill of the standard sql statement. Moreover, the rule configuration based on the text can complete large-batch rule customization without a large amount of operations by a user. The data checking method can automatically generate a checking script (sql script), a user does not need to develop codes, and the work of deploying online and modifying is simplified. The data checking method can also determine the checking table of the corresponding type according to the checking result, can conveniently display the data checking result and is convenient for a user to correct the data.
Based on the same inventive concept, the embodiment of the present application further provides a data checking apparatus 200 based on a checking script, as shown in fig. 2, the data checking apparatus 200 includes a file generating module 201, a script generating module 202, and a field checking module 203.
The file generation module 201 is configured to generate a rule configuration file in response to a rule configuration operation of a user.
The script generating module 202 is configured to read the configuration rule file, and generate a corresponding check script for each preset field in the configuration rule file.
The field checking module 203 is configured to execute a checking script to check each field in the target data, and determine a checking table of a corresponding type according to a checking result of each field for a user to view.
In one embodiment of the present application, the rule profile includes at least: the system comprises at least one preset field, a regular expression for checking each preset field, a checking level corresponding to each regular expression and problem description content corresponding to each checking level.
In an embodiment of the present application, the script generating module 202 is specifically configured to: and generating a checking script corresponding to the preset field according to the regular expression generation of the preset field.
In an embodiment of the present application, the field checking module 203 is specifically configured to: and if the checking result of the field is true, copying and inserting the source record of the field into the checking success table.
In an embodiment of the present application, the field checking module 203 is specifically configured to: and if the checking result of the field is not true and the checking level is warning, inserting the source record of the field into the checking problem table, and copying the source record of the field into the checking success table.
In an embodiment of the present application, the field checking module 203 is specifically configured to: and if the checking result of the field is not true and the checking level is wrong, inserting the source record of the field into the checking problem table.
In one embodiment of the present application, the checking problem table includes at least: the field with the non-true checking result, the checking level corresponding to the field with the non-true checking result, and the problem description content corresponding to each checking level.
Compared with the prior art, the data checking device 200 for checking the script provided by the embodiment of the application can define the checking rule based on the sql of the standard database, and the user can develop the rule only by mastering the writing skill of the standard sql statement. Moreover, the rule configuration based on the text can complete large-batch rule customization without a large amount of operations by a user. The data checking device 200 can automatically generate a checking script (sql script), and a user does not need to develop codes, thereby simplifying the work of deploying online and modifying. The data checking device 200 can also determine the checking table of the corresponding type according to the checking result, can conveniently display the data checking result, and is convenient for a user to correct the data.
The data checking device 200 based on the checking script provided by the embodiment of the present application has the same inventive concept as the embodiments described above, and the contents not shown in detail in the data checking device 200 based on the checking script may refer to the embodiments described above, and are not described again here.
Based on the same inventive concept, the embodiment of the present application further provides an electronic device 300, as shown in fig. 3, the electronic device 300 includes a memory 303 and a processor 301, and the processor 301 is communicatively connected to the memory 303.
The memory 303 stores a computer program, and when the computer program is executed by the processor 301, the data checking method based on the checking script provided by the above embodiments of the present application is implemented.
Alternatively, the processor 301 and the memory 303 may be connected by a bus 302. Optionally, the speech synthesis server 300 may further comprise a transceiver 304. It should be noted that the transceiver 304 is not limited to one in practical applications, and the structure of the speech synthesis server 300 is not limited to the embodiment of the present application.
The processor 301 is applied to the embodiment of the present application, and is configured to implement the method shown in the above method embodiment. The transceiver 304 may include a receiver and a transmitter, and the transceiver 304 is applied in the embodiment of the present application to implement the function of the speech synthesis server 300 of the embodiment of the present application to communicate with other devices when executed.
The Processor 301 may be a CPU (Central Processing Unit), a general-purpose Processor, a DSP (Digital Signal Processor), an ASIC (Application specific integrated Circuit), an FPGA (Field Programmable Gate Array) or other Programmable logic device, a transistor logic device, a hardware component, or any combination thereof. Which may implement or perform the various illustrative logical blocks, modules, and circuits described in connection with the disclosure. The processor 301 may also be a combination of computing functions, e.g., comprising one or more microprocessors, a combination of a DSP and a microprocessor, or the like.
The Memory 303 may be a ROM (Read Only Memory) or other type of static storage device that can store static information and instructions, a RAM (Random Access Memory) or other type of dynamic storage device that can store information and instructions, an EEPROM (Electrically erasable programmable Read Only Memory), a CD-ROM (Compact disk Read Only Memory) or other optical disk storage, optical disk storage (including Compact disk, laser disk, optical disk, digital versatile disk, blu-ray disk, etc.), a magnetic disk storage medium or other magnetic storage device, or any other medium that can be used to carry or store a desired computer program in the form of instructions or data structures and that can be accessed by a computer, but is not limited to these.
Compared with the prior art, the electronic device 300 provided by the embodiment of the application can define the checking rule based on the sql of the standard database, and the user can develop the rule only by mastering the writing skill of the standard sql statement. Moreover, the rule configuration based on the text can complete large-batch rule customization without a large amount of operations by a user. The electronic device 300 can automatically generate a checking script (sql script), and a user does not need to develop codes, thereby simplifying the deployment, online deployment and modification. The electronic device 300 may further determine the corresponding type of check table according to the check result, so that the data check result may be displayed more conveniently, and a user may perform data correction conveniently.
The electronic device 300 provided in the embodiment of the present application has the same inventive concept as the embodiments described above, and the details that are not shown in the electronic device 300 may refer to the embodiments described above, and are not described herein again.
Based on the same inventive concept, an embodiment of the present application further provides a computer-readable storage medium, where a computer program is stored on the storage medium, and when the computer program is executed by a processor, the data checking method based on the checking script provided by the above embodiment of the present application is implemented.
The computer-readable storage medium provided herein includes, but is not limited to, any type of disk including floppy disks, hard disks, optical disks, CD-ROMs, and magneto-optical disks, ROMs, RAMs, EPROMs (Erasable Programmable Read-Only memories), EEPROMs, flash memory, magnetic cards, or optical cards. That is, a readable medium includes any medium that stores or transmits information in a form readable by a device (e.g., a computer).
The computer-readable storage medium provided in the embodiments of the present application has the same inventive concept as the embodiments described above, and contents not shown in detail in the computer-readable storage medium may refer to the embodiments described above, and are not described herein again.
Those of skill in the art will appreciate that the various operations, methods, steps in the processes, acts, or solutions discussed in this application can be interchanged, modified, combined, or eliminated. Further, other steps, measures, or schemes in various operations, methods, or flows that have been discussed in this application can be alternated, altered, rearranged, broken down, combined, or deleted. Further, steps, measures, schemes in the prior art having various operations, methods, procedures disclosed in the present application may also be alternated, modified, rearranged, decomposed, combined, or deleted.
In the description of the present application, it is to be understood that the terms "first", "second" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implying any number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of that feature. In the description of the present application, "a plurality" means two or more unless otherwise specified.
It should be understood that, although the respective steps in the flowcharts of the drawings are sequentially shown based on the indication of the arrow, the steps are not necessarily sequentially performed based on the order indicated by the arrow. The steps are not performed in the exact order shown and may be performed in other orders unless explicitly stated herein. Moreover, at least a portion of the steps in the flow chart of the figure may include multiple sub-steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, which are not necessarily performed in sequence, but may be performed alternately or alternately with other steps or at least a portion of the sub-steps or stages of other steps.
The foregoing is only a partial embodiment of the present application, and it should be noted that, for those skilled in the art, several modifications and decorations can be made without departing from the principle of the present application, and these modifications and decorations should also be regarded as the protection scope of the present application.
Claims (10)
1. A data checking method based on a checking script is characterized by comprising the following steps:
generating a rule configuration file in response to a rule configuration operation of a user;
reading the configuration rule file, and generating a corresponding check script for each preset field in the configuration rule file;
and executing the checking script to check each field in the target data, and determining a checking table of a corresponding type according to a checking result of each field for a user to check.
2. A method for data detection based on a detection script according to claim 1, wherein the rule configuration file comprises at least:
the system comprises at least one preset field, a regular expression for checking each preset field, a checking level corresponding to each regular expression and problem description content corresponding to each checking level.
3. A data checking method according to claim 2, wherein the generating a corresponding checking script for each preset field in the configuration rule file comprises: and generating a checking script corresponding to the preset field according to the regular expression generation of the preset field.
4. The data checking method based on the checking script as claimed in claim 2, wherein the determining the checking table of the corresponding type according to the checking result of each field comprises: and if the checking result of the field is true, copying and inserting the source record of the field into the checking success table.
5. The data checking method based on the checking script as claimed in claim 2, wherein the determining the checking table of the corresponding type according to the checking result of each field comprises: and if the checking result of the field is not true and the checking level is warning, inserting the source record of the field into a checking problem table, and copying the source record of the field into a checking success table.
6. The data checking method based on the checking script as claimed in claim 2, wherein the determining the checking table of the corresponding type according to the checking result of each field comprises: and if the checking result of the field is not true and the checking level is wrong, inserting the source record of the field into a checking problem table.
7. A method for data detection based on a detection script according to claim 5 or 6, wherein the detection problem table comprises at least:
the field with the non-true checking result, the checking level corresponding to the field with the non-true checking result, and the problem description content corresponding to each checking level.
8. A data checking apparatus based on a checking script, comprising:
the file generating module is used for responding to the rule configuration operation of a user and generating a rule configuration file;
the script generation module is used for reading the configuration rule file and generating a corresponding check script for each preset field in the configuration rule file;
and the field checking module is used for executing the checking script to check each field in the target data, and determining a checking table of a corresponding type according to the checking result of each field for a user to check.
9. An electronic device comprising a memory and a processor, the processor communicatively coupled to the memory;
the memory stores a computer program which, when executed by the processor, implements a method of data detection based on a detection script according to any one of claims 1-7.
10. A computer-readable storage medium, characterized in that the storage medium has stored thereon a computer program which, when executed by a processor, implements a method for data checking based on a checking script according to any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010537584.1A CN111796907A (en) | 2020-06-12 | 2020-06-12 | Data checking method and device based on checking script, electronic equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010537584.1A CN111796907A (en) | 2020-06-12 | 2020-06-12 | Data checking method and device based on checking script, electronic equipment and medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111796907A true CN111796907A (en) | 2020-10-20 |
Family
ID=72803298
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010537584.1A Pending CN111796907A (en) | 2020-06-12 | 2020-06-12 | Data checking method and device based on checking script, electronic equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111796907A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112347095A (en) * | 2020-11-16 | 2021-02-09 | 建信金融科技有限责任公司 | Data table processing method and device and server |
| CN112667612A (en) * | 2020-12-25 | 2021-04-16 | 建信金融科技有限责任公司 | Data quality checking method and device, electronic equipment and storage medium |
| CN114091972A (en) * | 2021-12-02 | 2022-02-25 | 建信金融科技有限责任公司 | Data checking method and device, electronic equipment and storage medium |
| CN114862220A (en) * | 2022-05-17 | 2022-08-05 | 城云科技（中国）有限公司 | Method, device and application for conveniently checking validity of data application index |
| CN118095919A (en) * | 2024-01-02 | 2024-05-28 | 江苏金融租赁股份有限公司 | Method and system for checking quality of service data |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107908725A (en) * | 2017-11-14 | 2018-04-13 | 中国银行股份有限公司 | A kind of batch data method of calibration, device and system |
| CN110837496A (en) * | 2019-11-08 | 2020-02-25 | 浪潮云信息技术有限公司 | Data quality management method and system based on dynamic sql |
| CN111159171A (en) * | 2019-12-31 | 2020-05-15 | 中国铁塔股份有限公司 | Data auditing method and system |
| CN111177176A (en) * | 2019-11-18 | 2020-05-19 | 腾讯科技（深圳）有限公司 | Data detection method, device and storage medium |
-
2020
- 2020-06-12 CN CN202010537584.1A patent/CN111796907A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107908725A (en) * | 2017-11-14 | 2018-04-13 | 中国银行股份有限公司 | A kind of batch data method of calibration, device and system |
| CN110837496A (en) * | 2019-11-08 | 2020-02-25 | 浪潮云信息技术有限公司 | Data quality management method and system based on dynamic sql |
| CN111177176A (en) * | 2019-11-18 | 2020-05-19 | 腾讯科技（深圳）有限公司 | Data detection method, device and storage medium |
| CN111159171A (en) * | 2019-12-31 | 2020-05-15 | 中国铁塔股份有限公司 | Data auditing method and system |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112347095A (en) * | 2020-11-16 | 2021-02-09 | 建信金融科技有限责任公司 | Data table processing method and device and server |
| CN112347095B (en) * | 2020-11-16 | 2023-04-21 | 建信金融科技有限责任公司 | Data table processing method, device and server |
| CN112667612A (en) * | 2020-12-25 | 2021-04-16 | 建信金融科技有限责任公司 | Data quality checking method and device, electronic equipment and storage medium |
| CN114091972A (en) * | 2021-12-02 | 2022-02-25 | 建信金融科技有限责任公司 | Data checking method and device, electronic equipment and storage medium |
| CN114862220A (en) * | 2022-05-17 | 2022-08-05 | 城云科技（中国）有限公司 | Method, device and application for conveniently checking validity of data application index |
| CN118095919A (en) * | 2024-01-02 | 2024-05-28 | 江苏金融租赁股份有限公司 | Method and system for checking quality of service data |
| CN118095919B (en) * | 2024-01-02 | 2024-08-06 | 江苏金融租赁股份有限公司 | Method and system for checking quality of service data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111796907A (en) | Data checking method and device based on checking script, electronic equipment and medium | |
| CN110716878B (en) | Automatic interface testing method, device and system | |
| US20150212983A1 (en) | Quick Font Match | |
| CN112613288B (en) | Method, device, computer equipment and storage medium for generating bill | |
| CN105740219A (en) | Report self-defining method and device | |
| CN113032275A (en) | Method and device for testing field, electronic equipment and storage medium | |
| CN113434542B (en) | Data relationship identification method and device, electronic equipment and storage medium | |
| CN112052157B (en) | Method, device and system for constructing test message | |
| CN111522881B (en) | Service data processing method, device, server and storage medium | |
| CN117669518A (en) | File generation method, system, computer device and storage medium | |
| CN112861491A (en) | Report processing method and device, electronic equipment and computer readable storage medium | |
| CN112231232A (en) | Method, device and equipment for determining test data model and generating test data | |
| CN109388685B (en) | Method and device for warehousing spatial data used by planning industry | |
| CN112445461B (en) | Business rule generation method and device, electronic equipment and readable storage medium | |
| CN114490415A (en) | Service testing method, computer device, storage medium, and computer program product | |
| CN114153461A (en) | Script processing method and device, electronic equipment and storage medium | |
| CN113918593A (en) | Method and device for identifying financial data abnormity, storage medium and computing equipment | |
| US20050198616A1 (en) | Pattern system generation apparatus and pattern application apparatus | |
| US11934300B2 (en) | Reducing computing power for generating test scenario files for decision models | |
| CN117555955B (en) | Data conversion method, data conversion device, computer device, and storage medium | |
| CN114756440B (en) | Data writing method, device and equipment of smart card and storage medium | |
| CN114677186B (en) | Offer calculation method and device for financial product, computer equipment and storage medium | |
| US20180129486A1 (en) | System and method for estimating programming capability | |
| CN115826928B (en) | Program generating method, system, electronic device and computer readable storage medium | |
| CN115129355B (en) | Page repair method, system and computer equipment thereof |
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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20220926 Address after: 25 Financial Street, Xicheng District, Beijing 100033 Applicant after: CHINA CONSTRUCTION BANK Corp. Address before: 25 Financial Street, Xicheng District, Beijing 100033 Applicant before: CHINA CONSTRUCTION BANK Corp. Applicant before: Jianxin Financial Science and Technology Co.,Ltd. |
|
| TA01 | Transfer of patent application right |