CN107291961B - Data processing method and device - Google Patents
Data processing method and device Download PDFInfo
- Publication number
- CN107291961B CN107291961B CN201710671290.6A CN201710671290A CN107291961B CN 107291961 B CN107291961 B CN 107291961B CN 201710671290 A CN201710671290 A CN 201710671290A CN 107291961 B CN107291961 B CN 107291961B
- Authority
- CN
- China
- Prior art keywords
- data
- field
- checked
- table structure
- structure information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- User Interface Of Digital Computer (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application discloses a data processing method and a device, wherein the method comprises the following steps: acquiring a data table name to which data to be checked belongs, wherein the data to be checked comprises data of at least one field; inquiring prestored table structure information corresponding to the data table name, wherein the table structure information comprises specification descriptions of all fields; determining field specification descriptions corresponding to the data of each field in the data to be checked in a table structure one by one; and correspondingly displaying the data of each field in the data to be checked and the corresponding field specification. According to the method and the device, the data dictionary does not need to be switched repeatedly by workers and the data to be checked are avoided, so that the data normalization checking process is simpler and more visual.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a data processing method and apparatus.
Background
In banking systems and other systems, it is common for upper level systems to download data that is not explicitly labeled with a field label. In order to detect the correctness of the downloaded data, a worker needs to query the data dictionary to determine the specification of each field of the downloaded data according to the table name of the downloaded data. And then switching back and forth between the data dictionary and the downloaded data page to check the validity of the downloaded data according to the field specification recorded in the data dictionary, for example, checking whether the length of a certain field data in the downloaded data meets the data length specified by the field.
Obviously, the existing processing method needs a worker to switch between different table pages to realize the inspection of the data specification, and the operation is cumbersome and not intuitive.
Disclosure of Invention
In view of this, the present application provides a data processing method and apparatus, which are used to solve the problem that the existing method requires a worker to switch between different table pages to implement inspection of data specifications, and is complicated in operation and not intuitive.
In order to achieve the above object, the following solutions are proposed:
a method of data processing, comprising:
acquiring a data table name to which data to be checked belongs, wherein the data to be checked comprises data of at least one field;
inquiring prestored table structure information corresponding to the data table name, wherein the table structure information comprises specification descriptions of all fields;
determining field specification descriptions corresponding to the data of each field in the data to be checked in a table structure one by one;
and correspondingly displaying the data of each field in the data to be checked and the corresponding field specification.
Preferably, the sorting order of the specification descriptions of the fields in the table structure information corresponding to the data table name which is prestored is the same as the sorting order of the fields in the data to be checked;
the determining of the field specification of the data of each field in the data to be checked, which corresponds to one in the table structure, includes:
and determining the field specification corresponding to the field sorting sequence in the table structure according to the field sorting sequence of the field data in the data to be checked, and determining that the field specification is in one-to-one correspondence with the field data.
Preferably, the displaying the data of each field in the data to be checked corresponding to the corresponding field specification includes:
and displaying the data of each field in the data to be checked and the corresponding field specification in the same row in a table.
Preferably, the method further comprises the following steps:
and checking whether the data to be checked meets the specification or not according to the field specification corresponding to the data of each field in the data to be checked.
Preferably, the field specification in the table structure information includes: any one or more field specification descriptions of field name, field type, field length, field meaning, and field value.
A data processing apparatus comprising:
the data table name acquisition unit is used for acquiring the data table name to which the data to be checked belongs, and the data to be checked comprises data of at least one field;
the table structure information query unit is used for querying pre-stored table structure information corresponding to the data table name, and the table structure information comprises specification descriptions of all fields;
a specification corresponding unit, configured to determine field specification descriptions of data of each field in the data to be checked, where the data correspond to each other in the table structure one by one;
and the data display unit is used for correspondingly displaying the data of each field in the data to be checked and the corresponding field specification.
Preferably, the sorting order of the specification descriptions of the fields in the table structure information corresponding to the data table name which is prestored is the same as the sorting order of the fields in the data to be checked;
the process of determining, by the specification correspondence unit, a field specification description in which data of each field in the data to be collated corresponds to each other in the table structure includes:
and determining the field specification corresponding to the field sorting sequence in the table structure according to the field sorting sequence of the field data in the data to be checked, and determining that the field specification is in one-to-one correspondence with the field data.
Preferably, the process of displaying, by the data display unit, data of each field in the data to be checked and the corresponding field specification correspondingly includes:
and displaying the data of each field in the data to be checked and the corresponding field specification in the same row in a table.
Preferably, the method further comprises the following steps:
and the standard checking unit is used for checking whether the data to be checked meets the standard or not according to the field standard specification corresponding to the data of each field in the data to be checked.
Preferably, the field specification in the table structure information includes: any one or more field specification descriptions of field name, field type, field length, field meaning, and field value.
According to the technical scheme, the data processing method provided by the embodiment of the application obtains the name of the data table to which the data to be checked belongs, wherein the data to be checked comprises data of at least one field; inquiring prestored table structure information corresponding to the data table name, wherein the table structure information comprises specification descriptions of all fields; determining field specification descriptions corresponding to the data of each field in the data to be checked in a table structure one by one; and correspondingly displaying the data of each field in the data to be checked and the corresponding field specification. According to the method, the table structure information corresponding to different data table names is stored in advance, the table structure information comprises field specification descriptions, the corresponding relation is inquired to determine the corresponding table structure information according to the data table name to which the data to be checked belongs, the field specification descriptions corresponding to the data of the fields in the data to be checked in the table structure one to one are further determined, the data of the fields in the data to be checked and the corresponding field specification descriptions are displayed correspondingly, a worker does not need to repeatedly switch a data dictionary and the data to be checked, and the data specification checking process is simpler and more visual.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, it is obvious that the drawings in the following description are only embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
Fig. 1 is a flowchart of a data processing method disclosed in an embodiment of the present application;
FIG. 2 illustrates a diagram of a data structure to be collated;
FIG. 3 illustrates a table structure information diagram;
FIG. 4 is a flow chart of another data processing method disclosed in the embodiments of the present application;
FIG. 5 is a flow chart of another data processing method disclosed in the embodiments of the present application;
FIG. 6 illustrates a field data and field specification corresponding presentation effect diagram;
FIG. 7 is a flow chart of another data processing method disclosed in the embodiments of the present application;
fig. 8 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The embodiment of the application discloses a data processing scheme, which is characterized in that different data table names and corresponding table structure information are collected in advance, when the normative inspection is required to be carried out on data to be checked, corresponding table structure information is determined by inquiring the corresponding relation according to the data table name to which the data to be checked belongs, field specifications corresponding to fields in the table structure of the data to be checked in a one-to-one mode are determined, and the field specifications are correspondingly displayed on the same page, so that a worker can check conveniently.
Referring to fig. 1, fig. 1 is a flowchart of a data processing method disclosed in an embodiment of the present application. As shown in fig. 1, the method includes:
step S100, obtaining a data table name to which data to be checked belongs, wherein the data to be checked comprises data of at least one field;
specifically, the data downloaded by the upper system is used as the data to be checked. When the upper layer system downloads the data, the name of a data table to which the downloaded data belongs can be marked, and the name of the data table is the name of the data table to which the data to be checked belongs.
Wherein the data to be collated includes data of at least one field.
Referring to fig. 2, a diagram of a data structure to be collated is illustrated. In fig. 2, a plurality of columns of data are arranged in the longitudinal direction, each column corresponds to one field, data of a plurality of fields distributed in the transverse direction form a piece of data to be checked, and for example, one row of data marked in black in fig. 2 is the data to be checked. The data to be collated may comprise data of a plurality of fields, different fields corresponding to different meanings.
Step S110, inquiring prestored table structure information corresponding to the data table name, wherein the table structure information comprises specification descriptions of all fields;
specifically, the table structure information of different data tables can be summarized in advance, and the corresponding relation between the table structure information and the data table names is established and stored.
Based on this, after the data table name to which the data to be checked belongs is obtained in the previous step, the corresponding relation is inquired, and the table structure information corresponding to the data table name is determined.
The table structure information includes specification of each field. Referring to fig. 3, fig. 3 illustrates a table structure information diagram. In fig. 3, the first row indicates the specification type, and each row except the first row corresponds to the specification description of one field. With a second behavior example, the corresponding field specification includes: the BOCS field stores English name 0, data item English name OE47-APPG, data item Chinese name acquisition mode, data type CHAR, maximum data length 1, field meaning and value range A: and (4) collecting the total amount.
Step S120, determining the field specification descriptions of the data of each field in the data to be checked, which correspond to each other in the table structure;
specifically, the method and the device can preset the sorting mode of each field in the data to be checked and the sorting mode of the field specification in the table structure, for example, the sorting mode of the field is consistent with or opposite to the sorting mode of the field specification, and further, the field specification descriptions corresponding to the data of each field in the data to be checked in the table structure one by one can be determined according to the preset sorting mode.
The following is illustrated by a specific example:
the data to be checked includes data of 3 fields, which are respectively: field 1: a, field 2: b, field 3: and C, sequencing the three fields in sequence. In the table structure of the pre-statistics, the specification corresponding to the field 1 is arranged in the first bit, the specification corresponding to the field 2 is arranged in the second bit, and the specification corresponding to the field 3 is arranged in the third bit. Further, according to the sort order, the field specification description arranged at the first bit in the table structure may be one-to-one associated with the data a corresponding to the field 1, the field specification description arranged at the second bit in the table structure may be one-to-one associated with the data B corresponding to the field 2, and the field specification description arranged at the third bit in the table structure may be one-to-one associated with the data C corresponding to the field 3.
Of course, the above merely illustrates one alternative embodiment.
And S130, correspondingly displaying the data of each field in the data to be checked and the corresponding field specification.
Specifically, in the previous step and the field specification descriptions of the data of each field in the data to be checked, which correspond to each other in the table structure, are determined, and in this step, the data of each field and the corresponding field specification descriptions may be displayed correspondingly.
The data processing method provided by the embodiment of the application obtains the name of a data table to which data to be checked belongs, wherein the data to be checked comprises data of at least one field; inquiring prestored table structure information corresponding to the data table name, wherein the table structure information comprises specification descriptions of all fields; determining field specification descriptions corresponding to the data of each field in the data to be checked in a table structure one by one; and correspondingly displaying the data of each field in the data to be checked and the corresponding field specification. According to the method, the table structure information corresponding to different data table names is stored in advance, the table structure information comprises field specification descriptions, the corresponding relation is inquired to determine the corresponding table structure information according to the data table name to which the data to be checked belongs, the field specification descriptions corresponding to the data of the fields in the data to be checked in the table structure one to one are further determined, the data of the fields in the data to be checked and the corresponding field specification descriptions are displayed correspondingly, a worker does not need to repeatedly switch a data dictionary and the data to be checked, and the data specification checking process is simpler and more visual.
Optionally, the field specification in the table structure information may include: any one or more field specification descriptions of field name, field type, field length, field meaning, and field value.
In another embodiment of the present application, a sorting order of the specification descriptions of the fields in the table structure information corresponding to the data table name, which is pre-stored, may be set to be the same as a sorting order of the fields in the data to be collated. That is, the same fields are sorted in the same order in the table structure information and the data to be checked.
The above examples are also illustrative: the data to be checked includes data of 3 fields, which are respectively: field 1: a, field 2: b, field 3: and C, sequencing the three fields in sequence. In the table structure of the pre-statistics, the specification corresponding to the field 1 is arranged in the first bit, the specification corresponding to the field 2 is arranged in the second bit, and the specification corresponding to the field 3 is arranged in the third bit.
Based on this, the present application introduces another data processing method, which is shown in fig. 4 and includes:
s200, acquiring a data table name to which data to be checked belongs, wherein the data to be checked comprises data of at least one field;
specifically, the data downloaded by the upper system is used as the data to be checked. When the upper layer system downloads the data, the name of a data table to which the downloaded data belongs can be marked, and the name of the data table is the name of the data table to which the data to be checked belongs.
Wherein the data to be collated includes data of at least one field.
Step S210, inquiring prestored table structure information corresponding to the data table name, wherein the table structure information comprises specification descriptions of all fields;
specifically, the table structure information of different data tables can be summarized in advance, and the corresponding relation between the table structure information and the data table names is established and stored.
Based on this, after the data table name to which the data to be checked belongs is obtained in the previous step, the corresponding relation is inquired, and the table structure information corresponding to the data table name is determined.
Step S220, according to the field sorting sequence of the field data in the data to be checked, determining the field specification corresponding to the field sorting sequence in the table structure, and determining that the field specification corresponds to the field data one by one;
the above-listed examples are illustrative:
the field specifications arranged at the first bit in the table structure may be one-to-one corresponding to the data a corresponding to the field 1, the field specifications arranged at the second bit in the table structure may be one-to-one corresponding to the data B corresponding to the field 2, and the field specifications arranged at the third bit in the table structure may be one-to-one corresponding to the data C corresponding to the field 3, in the sorting order.
And step S230, correspondingly displaying the data of each field in the data to be checked and the corresponding field specification.
In the embodiment of the present application, a specific implementation manner of determining field specification descriptions corresponding to data of each field in the data to be checked in a table structure one to one is introduced, that is, when a data table structure to which the data to be checked belongs is obtained through pre-learning and summarizing, the field specification descriptions are sequentially determined according to the sorting sequence of each field in the data to be checked, so that the sequence of each field in the data to be checked is consistent with that of each field in the data table structure. Further, according to the field sorting order of the field data in the data to be checked, the field specification corresponding to the field sorting order in the table structure may be determined, and the field specification and the field data may be determined to correspond one to one.
In yet another embodiment of the present application, there is further disclosed yet another data processing method, as shown in fig. 5, the method including:
step S300, obtaining a data table name to which data to be checked belongs, wherein the data to be checked comprises data of at least one field;
specifically, the data downloaded by the upper system is used as the data to be checked. When the upper layer system downloads the data, the name of a data table to which the downloaded data belongs can be marked, and the name of the data table is the name of the data table to which the data to be checked belongs.
Wherein the data to be collated includes data of at least one field.
Step S310, inquiring prestored table structure information corresponding to the data table name, wherein the table structure information comprises specification descriptions of all fields;
specifically, the table structure information of different data tables can be summarized in advance, and the corresponding relation between the table structure information and the data table names is established and stored.
Based on this, after the data table name to which the data to be checked belongs is obtained in the previous step, the corresponding relation is inquired, and the table structure information corresponding to the data table name is determined.
Step S320, determining the field specification description of the data of each field in the data to be checked, which corresponds to each other in the table structure;
specifically, the implementation of this step can be implemented in the manner described in the previous embodiment. And will not be described in detail herein.
Step S330, the data of each field in the data to be checked and the corresponding field specification are displayed in the same row in the table.
With reference to fig. 6, fig. 6 illustrates a diagram of field data and field specification corresponding display effect.
Fig. 6 illustrates the effect of showing the first piece of data to be checked in fig. 1 and the specification of each field in the example of fig. 3 in the same row in the same table. In fig. 6, each row corresponds to a field from the second row, the values of the fields are written in the last column in fig. 6, and the specifications corresponding to the fields are illustrated as columns before the last column.
In yet another embodiment of the present application, there is further disclosed yet another data processing method, as shown in fig. 7, the method comprising:
s400, acquiring a data table name to which data to be checked belongs, wherein the data to be checked comprises data of at least one field;
specifically, the data downloaded by the upper system is used as the data to be checked. When the upper layer system downloads the data, the name of a data table to which the downloaded data belongs can be marked, and the name of the data table is the name of the data table to which the data to be checked belongs.
Wherein the data to be collated includes data of at least one field.
Step S410, inquiring prestored table structure information corresponding to the data table name, wherein the table structure information comprises specification descriptions of all fields;
specifically, the table structure information of different data tables can be summarized in advance, and the corresponding relation between the table structure information and the data table names is established and stored.
Based on this, after the data table name to which the data to be checked belongs is obtained in the previous step, the corresponding relation is inquired, and the table structure information corresponding to the data table name is determined.
Step S420, determining field specification descriptions of the data of each field in the data to be checked, which correspond to each other in the table structure;
specifically, the implementation of this step can be implemented in the manner described in the previous embodiment. And will not be described in detail herein.
Step S430, correspondingly displaying the data of each field in the data to be checked and the corresponding field specification;
specifically, the implementation of this step may be implemented as described in the previous embodiment, that is, the data of each field in the data to be checked and the specification of the corresponding field are shown in the same row in the table.
Step S440, checking whether the data to be checked meets the specification according to the field specification corresponding to the data of each field in the data to be checked.
The description is made in connection with the example of fig. 6:
taking the process of performing the normative check on the first field of the data to be checked as an example, the value of the first field is a, and the value range defined by the specification of the first field is a: and collecting the total quantity, so that the value of the first field can be determined to be in accordance with the specification.
Further taking the example of the process of performing the normative check on the second field of the data to be checked, the value of the second field is 20191020. The specification of the second field defines a value range as the system date and the value conforms to the system date specification. Further, the specification of the second field also limits the maximum length of the data volume to be 8, and the check shows that the value length does not exceed 8, so that the value of the second field can be determined to be in accordance with the specification.
In the data processing method introduced in this embodiment, a process of performing normative check on the field value according to the field specification is further added, and a process of manual review can be replaced, so that the normative check efficiency is higher and the accuracy is higher.
The following describes a data processing apparatus provided in an embodiment of the present application, and the data processing apparatus described below and the data processing method described above may be referred to correspondingly.
Referring to fig. 8, fig. 8 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present disclosure. As shown in fig. 8, the apparatus includes:
a data table name acquisition unit 11, configured to acquire a data table name to which data to be checked belongs, where the data to be checked includes data of at least one field;
a table structure information query unit 12, configured to query table structure information corresponding to the data table name, where the table structure information includes specification descriptions of various fields;
a specification corresponding unit 13, configured to determine field specification descriptions of data of each field in the data to be checked, where the data correspond to each other in the table structure;
and the data display unit 14 is configured to correspondingly display data of each field in the data to be checked and the corresponding field specification.
The data processing device provided by the embodiment of the application stores table structure information corresponding to different data table names in advance, the table structure information comprises field specification descriptions, and then according to the data table name to which data to be checked belongs, corresponding relations are inquired to determine corresponding table structure information, the field specification descriptions corresponding to the data of the fields in the data to be checked in the table structure one by one are further determined, the data of the fields in the data to be checked correspond to the corresponding field specification descriptions to be displayed, a worker does not need to repeatedly switch a data dictionary and the data to be checked, and the data specification checking process is simpler and more visual.
Optionally, the field specification in the table structure information may include: any one or more field specification descriptions of field name, field type, field length, field meaning, and field value.
Optionally, the present application may set a sorting order of the specification descriptions of the fields in the table structure information corresponding to the data table name, which is pre-stored, to be the same as the sorting order of the fields in the data to be checked. Based on this, the process of determining, by the specification correspondence unit, a field specification description in which data of each field in the data to be checked corresponds to one another in the table structure may specifically include:
and determining the field specification corresponding to the field sorting sequence in the table structure according to the field sorting sequence of the field data in the data to be checked, and determining that the field specification is in one-to-one correspondence with the field data.
Optionally, the process of displaying, by the data display unit, data of each field in the data to be checked and the corresponding field specification correspondingly may specifically include:
and displaying the data of each field in the data to be checked and the corresponding field specification in the same row in a table.
Optionally, the data processing apparatus of the present application may further include:
and the standard checking unit is used for checking whether the data to be checked meets the standard or not according to the field standard specification corresponding to the data of each field in the data to be checked.
Finally, it should also be noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
The embodiments in the present description are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the application. Thus, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (9)
1. A data processing method, comprising:
acquiring a data table name to which data to be checked belongs, wherein the data to be checked comprises data of at least one field;
inquiring prestored table structure information corresponding to the data table name, wherein the table structure information comprises specification descriptions of all fields;
determining field specification descriptions corresponding to the data of each field in the data to be checked in a table structure one by one;
correspondingly displaying the data of each field in the data to be checked and the corresponding field specification;
after the exhibition, the method also comprises the following steps:
and checking whether the data to be checked meets the specification or not according to the field specification corresponding to the data of each field in the data to be checked.
2. The method according to claim 1, wherein the sorting order of the specification descriptions of the fields in the table structure information corresponding to the data table name which is prestored is the same as the sorting order of the fields in the data to be checked;
the determining of the field specification of the data of each field in the data to be checked, which corresponds to one in the table structure, includes:
and determining the field specification corresponding to the field sorting sequence in the table structure according to the field sorting sequence of the field data in the data to be checked, and determining that the field specification is in one-to-one correspondence with the field data.
3. The method according to claim 1, wherein the displaying the data of each field in the data to be checked corresponding to the corresponding field specification comprises:
and displaying the data of each field in the data to be checked and the corresponding field specification in the same row in a table.
4. The method according to any one of claims 1-3, wherein the field specification in the table structure information comprises: any one or more field specification descriptions of field name, field type, field length, field meaning, and field value.
5. A data processing apparatus, comprising:
the data table name acquisition unit is used for acquiring the data table name to which the data to be checked belongs, and the data to be checked comprises data of at least one field;
the table structure information query unit is used for querying pre-stored table structure information corresponding to the data table name, and the table structure information comprises specification descriptions of all fields;
a specification corresponding unit, configured to determine field specification descriptions of data of each field in the data to be checked, where the data correspond to each other in the table structure one by one;
the data display unit is used for correspondingly displaying the data of each field in the data to be checked and the corresponding field specification;
further comprising:
and the standard checking unit is used for checking whether the data to be checked meets the standard or not according to the field standard specification corresponding to the data of each field in the data to be checked.
6. The apparatus according to claim 5, wherein the sorting order of the specification descriptions of the fields in the table structure information corresponding to the data table name pre-stored is the same as the sorting order of the fields in the data to be checked;
the process of determining, by the specification correspondence unit, a field specification description in which data of each field in the data to be collated corresponds to each other in the table structure includes:
and determining the field specification corresponding to the field sorting sequence in the table structure according to the field sorting sequence of the field data in the data to be checked, and determining that the field specification is in one-to-one correspondence with the field data.
7. The apparatus according to claim 5, wherein the process of displaying the data of each field in the data to be checked and the corresponding field specification by the data display unit correspondingly comprises:
and displaying the data of each field in the data to be checked and the corresponding field specification in the same row in a table.
8. The apparatus of any one of claims 5-7, further comprising:
and the standard checking unit is used for checking whether the data to be checked meets the standard or not according to the field standard specification corresponding to the data of each field in the data to be checked.
9. The apparatus according to any one of claims 5-7, wherein the field specification in the table structure information comprises: any one or more field specification descriptions of field name, field type, field length, field meaning, and field value.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710671290.6A CN107291961B (en) | 2017-08-08 | 2017-08-08 | Data processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710671290.6A CN107291961B (en) | 2017-08-08 | 2017-08-08 | Data processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107291961A CN107291961A (en) | 2017-10-24 |
| CN107291961B true CN107291961B (en) | 2020-08-11 |
Family
ID=60104694
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710671290.6A Active CN107291961B (en) | 2017-08-08 | 2017-08-08 | Data processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107291961B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108363751B (en) * | 2018-01-29 | 2019-08-27 | 武汉迎风聚智科技有限公司 | A kind of detection method and system of public accumalation fund for housing construction operation system |
| CN111352983A (en) * | 2018-12-24 | 2020-06-30 | 深圳市优必选科技有限公司 | Service attribute dynamic expansion method and device, computer equipment and storage medium |
| CN112860722A (en) * | 2021-03-24 | 2021-05-28 | 成都新希望金融信息有限公司 | Data checking method and device, electronic equipment and readable storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101373467A (en) * | 2007-08-24 | 2009-02-25 | 上海全成通信技术有限公司 | Method for exhibiting data reporting form |
| CN102253975A (en) * | 2011-06-16 | 2011-11-23 | 上海博康智能网络科技有限公司 | Automatic switching system and method for database |
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
| CN106547786A (en) * | 2015-09-22 | 2017-03-29 | 阿里巴巴集团控股有限公司 | A kind of date storage method and device |
-
2017
- 2017-08-08 CN CN201710671290.6A patent/CN107291961B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101373467A (en) * | 2007-08-24 | 2009-02-25 | 上海全成通信技术有限公司 | Method for exhibiting data reporting form |
| CN102253975A (en) * | 2011-06-16 | 2011-11-23 | 上海博康智能网络科技有限公司 | Automatic switching system and method for database |
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
| CN106547786A (en) * | 2015-09-22 | 2017-03-29 | 阿里巴巴集团控股有限公司 | A kind of date storage method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107291961A (en) | 2017-10-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107291961B (en) | Data processing method and device | |
| CN110908891A (en) | Test data generation method and device, electronic equipment and storage medium | |
| US8171422B2 (en) | System and method for scrolling data | |
| CN103248739A (en) | Contact list navigation display method and device and mobile communication equipment | |
| CN104050243A (en) | Network searching method and system combined with searching and social contact | |
| CN104424271A (en) | Method and system for automatically acquiring digital resources of publications | |
| CN110825805A (en) | Data visualization method and device | |
| CN114417157B (en) | Data pushing method and device, computer equipment and computer medium | |
| CN105930149B (en) | A kind of display methods and device | |
| CN110990519A (en) | Vehicle fault diagnosis method and device, electronic equipment and storage medium | |
| CN105653600A (en) | Generation method and device of test question digest information | |
| CN107203525B (en) | Database processing method and device | |
| CN110908892A (en) | Interface data testing method and device and readable storage medium | |
| CN108804676B (en) | Post sorting method, device and equipment and computer readable storage medium | |
| CN111259274A (en) | Information processing method, device, equipment and information display device | |
| JP2010211575A (en) | Information evaluation support system | |
| CN106202572B (en) | Method and device for displaying e-book catalog | |
| CN102902987A (en) | Hand input text processing method, hand input text processing system and electronic device | |
| CN106959960B (en) | Data acquisition method and device | |
| DE102015112168A1 (en) | Process for creating an online shop | |
| CN109471935B (en) | Questionnaire survey object determining method and device, electronic equipment and storage medium | |
| CN110555089A (en) | character name matching method and device and computer readable storage medium | |
| CN116628338A (en) | Mobile terminal product recommendation method, system, computer and readable storage medium | |
| CN112149402B (en) | Document matching method, device, electronic equipment and computer readable storage medium | |
| KR101045850B1 (en) | Device for providing digital timeline through the website |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |