CN109213821B - Data processing method and system - Google Patents
Data processing method and system Download PDFInfo
- Publication number
- CN109213821B CN109213821B CN201811113300.5A CN201811113300A CN109213821B CN 109213821 B CN109213821 B CN 109213821B CN 201811113300 A CN201811113300 A CN 201811113300A CN 109213821 B CN109213821 B CN 109213821B
- Authority
- CN
- China
- Prior art keywords
- data
- database
- information
- position information
- operation instruction
- 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
Abstract
The invention provides a data processing method and a data processing system. The data processing method comprises the following steps: creating a data corresponding rule of a database; generating position information according to the data to be processed and the data corresponding rule of the database; dividing the plurality of location information into a plurality of groups; each group was subjected to the following cycle in turn: when the operation instruction is a reading instruction, reading a plurality of data in the database corresponding to the position information according to the position information, and generating output information according to the output information configuration rule and the data in the database; when the operation instruction is a maintenance instruction, replacing the data in the position information database with maintenance data corresponding to the position information; and after the plurality of groups execute the loop processing, outputting output information corresponding to the plurality of groups when the operation instruction is a reading operation instruction, and outputting maintenance success information when the operation instruction is a maintenance operation instruction. The invention shortens the development period, enhances the timeliness and reduces the development cost.
Description
Technical Field
The present invention relates to the field of data processing, and in particular, to a data processing method and system.
Background
Customer data and business data are the core of the bank, and various basic businesses and abduction businesses developed by the bank need to be supported by the customer data and the business data. In recent years, with the increasing of abduction business types and the leap development of scenes and frequency of digital currency use, the requirement on the access frequency of core data is higher and higher, the timeliness of new business types and business requirements is higher and higher, and the mode of realizing business requirements according to the traditional development cycle is unable to adapt to the high-speed development.
The development period of the prior art is long, and the data requirements cannot be quickly responded; the code needs to be rewritten during each development, only partial code can be multiplexed or all the code cannot be multiplexed, and the development cost is high.
Disclosure of Invention
The embodiments of the present invention mainly aim to provide a data processing method and system, which do not need to rewrite codes, shorten a development period, enhance timeliness, and reduce development cost.
In order to achieve the above object, an embodiment of the present invention provides a data processing method, including:
creating a data corresponding rule of a database;
receiving request information, wherein the request information comprises an operation instruction and data to be processed;
generating a plurality of position information according to the data to be processed and the data corresponding rule of the database, wherein each position information comprises a table number;
dividing the plurality of position information into a plurality of groups, wherein the table numbers of the position information in each group are the same;
each group was subjected to the following cycle in turn:
judging the type of the operation instruction;
when the operation instruction is a reading instruction, the request information also comprises an output information configuration rule;
sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, and generating output information according to an output information configuration rule and the plurality of data in the database;
when the operation instruction is a maintenance instruction, the request information further includes a plurality of maintenance data corresponding to the plurality of location information;
replacing a plurality of data in a database corresponding to the plurality of position information with a plurality of maintenance data corresponding to the plurality of position information according to the plurality of position information;
and after the plurality of groups execute the loop processing, outputting output information corresponding to the plurality of groups when the operation instruction is a reading operation instruction, and outputting maintenance success information when the operation instruction is a maintenance operation instruction.
An embodiment of the present invention further provides a data processing system, including:
the creating module is used for creating a data corresponding rule of the database;
the receiving module is used for receiving request information, and the request information comprises an operation instruction and data to be processed;
the generating module is used for generating a plurality of position information according to the data to be processed and the data corresponding rule of the database, and each position information comprises a table number;
the grouping module is used for dividing the position information into a plurality of groups, and the table numbers of the position information in each group are the same;
the circulation module is used for sequentially carrying out the following circulation processing on each group:
judging the type of the operation instruction;
when the operation instruction is a reading instruction, the request information also comprises an output information configuration rule;
sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, and generating output information according to an output information configuration rule and the plurality of data in the database;
when the operation instruction is a maintenance instruction, the request information further includes a plurality of maintenance data corresponding to the plurality of location information;
replacing a plurality of data in a database corresponding to the plurality of position information with a plurality of maintenance data corresponding to the plurality of position information according to the plurality of position information;
the first output module is used for outputting output information corresponding to a plurality of groups;
and the second output module is used for outputting the maintenance success information.
The embodiment of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and capable of running on the processor, and when the processor executes the computer program, the following steps are implemented:
creating a data corresponding rule of a database;
receiving request information, wherein the request information comprises an operation instruction and data to be processed;
generating a plurality of position information according to the data to be processed and the data corresponding rule of the database, wherein each position information comprises a table number;
dividing the plurality of position information into a plurality of groups, wherein the table numbers of the position information in each group are the same;
each group was subjected to the following cycle in turn:
judging the type of the operation instruction;
when the operation instruction is a reading instruction, the request information also comprises an output information configuration rule;
sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, and generating output information according to an output information configuration rule and the plurality of data in the database;
when the operation instruction is a maintenance instruction, the request information further includes a plurality of maintenance data corresponding to the plurality of location information;
replacing a plurality of data in a database corresponding to the plurality of position information with a plurality of maintenance data corresponding to the plurality of position information according to the plurality of position information;
and after the plurality of groups execute the loop processing, outputting output information corresponding to the plurality of groups when the operation instruction is a reading operation instruction, and outputting maintenance success information when the operation instruction is a maintenance operation instruction.
An embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the following steps:
creating a data corresponding rule of a database;
receiving request information, wherein the request information comprises an operation instruction and data to be processed;
generating a plurality of position information according to the data to be processed and the data corresponding rule of the database, wherein each position information comprises a table number;
dividing the plurality of position information into a plurality of groups, wherein the table numbers of the position information in each group are the same;
each group was subjected to the following cycle in turn:
judging the type of the operation instruction;
when the operation instruction is a reading instruction, the request information also comprises an output information configuration rule;
sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, and generating output information according to an output information configuration rule and the plurality of data in the database;
when the operation instruction is a maintenance instruction, the request information further includes a plurality of maintenance data corresponding to the plurality of location information;
replacing a plurality of data in a database corresponding to the plurality of position information with a plurality of maintenance data corresponding to the plurality of position information according to the plurality of position information;
and after the plurality of groups execute the loop processing, outputting output information corresponding to the plurality of groups when the operation instruction is a reading operation instruction, and outputting maintenance success information when the operation instruction is a maintenance operation instruction.
The data processing method and the system of the embodiment of the invention firstly create the data corresponding rule of the database, then receive the request information, generate a plurality of position information according to the data to be processed and the data corresponding rule of the database, and then divide the plurality of position information into a plurality of groups to sequentially carry out the following cyclic processing on each group: judging the type of the operation instruction; when the operation instruction is a reading instruction, sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, and generating output information according to an output information configuration rule and the plurality of data in the database; when the operation instruction is a maintenance instruction, a plurality of data in the database corresponding to the plurality of position information are replaced by a plurality of maintenance data corresponding to the plurality of position information according to the plurality of position information, when the operation instruction is a reading operation instruction, output information corresponding to the plurality of groups is output, and when the operation instruction is a maintenance operation instruction, maintenance success information is output, so that the development period is shortened, the timeliness is enhanced, and the development cost is reduced.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained based on these drawings without creative efforts.
FIG. 1 is a flow chart of a data processing method in an embodiment of the invention;
fig. 2 is a block diagram of a data processing system according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, 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 invention.
In view of the long development period, the lack of rapid response to data requirements and the high development cost in the prior art, the embodiment of the invention provides a night data processing method, which shortens the development period, enhances the timeliness and reduces the development cost. The present invention will be described in detail below with reference to the accompanying drawings.
Fig. 1 is a flowchart of a data processing method in an embodiment of the present invention. As shown in fig. 1, the data processing method includes:
s101: and creating data corresponding rules of the database.
S102: and receiving request information, wherein the request information comprises an operation instruction and data to be processed.
S103: and generating a plurality of position information according to the data to be processed and the data corresponding rule of the database, wherein each position information comprises a table number.
S104: the plurality of position information are divided into a plurality of groups, and the table numbers of the position information in each group are the same.
S105: each group was subjected to the following cycle in turn: judging the type of the operation instruction; when the operation instruction is a reading instruction, the request information also comprises an output information configuration rule; sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, and generating output information according to an output information configuration rule and the plurality of data in the database; when the operation instruction is a maintenance instruction, the request information further includes a plurality of maintenance data corresponding to the plurality of location information; and replacing the plurality of data in the database corresponding to the plurality of position information by a plurality of maintenance data corresponding to the plurality of position information according to the plurality of position information.
S106: and after the plurality of groups execute the loop processing, outputting output information corresponding to the plurality of groups when the operation instruction is a reading operation instruction, and outputting maintenance success information when the operation instruction is a maintenance operation instruction.
The data processing method shown in fig. 1 may be applied to a banking system. As can be seen from the process shown in fig. 1, the data processing method according to the embodiment of the present invention creates the data corresponding rule of the database, receives the request information, generates a plurality of location information according to the data to be processed and the data corresponding rule of the database, and then divides the plurality of location information into a plurality of groups to sequentially perform the following cyclic processing on each group: judging the type of the operation instruction; when the operation instruction is a reading instruction, sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, and generating output information according to an output information configuration rule and the plurality of data in the database; when the operation instruction is a maintenance instruction, a plurality of data in the database corresponding to the plurality of position information are replaced by a plurality of maintenance data corresponding to the plurality of position information according to the plurality of position information, when the operation instruction is a reading operation instruction, output information corresponding to the plurality of groups is output, and when the operation instruction is a maintenance operation instruction, maintenance success information is output, so that the development period is shortened, the timeliness is enhanced, and the development cost is reduced.
In one embodiment, the request information further includes a plurality of data types corresponding to the plurality of location information.
After executing S104, the method further includes: reading the types of a plurality of data in the database corresponding to the plurality of position information according to a preset database corresponding rule; judging whether the types of the data in the request information are the same as the types of the data in the database; and when the types of the data in the request information and the types of the data in the database are the same, executing S105, otherwise, indicating that the request information is illegal, and stopping executing S105. For example, if the type of the data of one of the position information in the request message is a number and the type of the data of the position information in the database is a character, the execution of S105 is stopped.
In an embodiment, when the operation instruction is a read instruction, the request information further includes attributes of a plurality of data corresponding to the plurality of location information. Attributes may include fractional digits, and the like.
After reading the plurality of data in the database corresponding to the plurality of position information in sequence according to the plurality of position information, the method further comprises the following steps: and according to the attribute of each data in the request information, sequentially correcting the attribute of each data in the database, and generating output information according to the output information configuration rule and the corrected data.
In one embodiment, the output information configuration rule includes a data start position, a data length and a data type of each data in the output information in the database.
In one embodiment, the maintenance instructions include: modify instructions, insert instructions, or delete instructions.
The specific embodiment of the invention is as follows:
1. and creating data corresponding rules of the database. For example, table 1 is a basic information table, field 1 in table 1 is gender, and field 2 in table 1 is birth date; table 2 is an additional information table, field 1 in table 2 is a study calendar, and field 2 in table 2 is a work unit. Table 3 is a financial information table, field 1 monthly income in table 3, field 2 customer rating in table 3, etc.
2. And receiving request information, wherein the request information comprises an operation instruction and data to be processed. And generating a plurality of position information according to the data to be processed and the data corresponding rule of the database, wherein each position information comprises a table number. For example, if the user wants to query the birth date, work unit, month income and customer rating of a certain customer, the operation instruction is a reading instruction, and the data to be processed is the birth date, work unit, month income and customer rating of the customer. According to the data correspondence rule of the database, the following position information can be generated: the a-th client record corresponds to the fields 2, 1 and 2 in table 1, 2 in table 2, 3 and 3.
3. The plurality of position information are divided into a plurality of groups, and the table numbers of the position information in each group are the same. For example: table 1 field 2 is in the first group, table 2 field 2 is in the second group, table 3 field 1 and table 3 field 2 is in the third group. The groups can be arranged from small to large according to the group numbers, and the fields in the groups can be arranged from small to large, so that the reading efficiency is improved, and the waste of system resources is avoided.
4. Reading the types of a plurality of data in the database corresponding to the plurality of position information according to a preset database corresponding rule; and judging whether the types of the data in the request information are the same as the types of the data in the database. And if the request information is the same as the request information, executing the next step, otherwise, indicating that the request information is illegal, and stopping executing the next step. For example, if the type of the data in table 1 and 2 in the request message is a number and the type of the data in table 1 and 2 in the database is a character, the next operation is stopped.
5. Each group was subjected to the following cycle in turn: judging the type of the operation instruction; when the operation instruction is a reading instruction, the request information also comprises an output information configuration rule; sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information; and according to the attribute of each data in the request information, sequentially correcting the attribute of each data in the database, and generating output information according to the output information configuration rule and the corrected data.
For example, the date of birth is read from the field 2 of table 1 corresponding to the a-th customer record, the work units are read from the field 2 of table 2, the monthly income is read from the field 1 of table 3, and the customer rating is read from the field 2 of table 3. The decimal place of the monthly income in the request message is 2 digits and the decimal place of the monthly income in the database is 3 digits, the three digits of the monthly income in the database can be corrected to 2 digits according to a rounding rule.
The information configuration rule may include a data start position, a data length, a data type, and the like. For example, if field 1 in table 3 is the third starting position in the output message, the monthly income corresponding to field 1 in table 3 is filled in the third starting position.
When the operation instruction is a maintenance instruction, the request information further includes a plurality of maintenance data corresponding to the plurality of location information; the plurality of location information replaces a plurality of data in the database corresponding to the plurality of location information with a plurality of maintenance data corresponding to the plurality of location information. For example, if the maintenance data corresponding to the monthly income is 2000, the data corresponding to the field 1 in table 3 in the database is replaced with 2000.
6. And after the plurality of groups execute the loop processing, outputting output information corresponding to the plurality of groups when the operation instruction is a reading operation instruction, and outputting maintenance success information when the operation instruction is a maintenance operation instruction.
To sum up, the data processing method according to the embodiment of the present invention creates a data correspondence rule of a database, receives request information, generates a plurality of location information according to data to be processed and the data correspondence rule of the database, and then divides the plurality of location information into a plurality of groups to sequentially perform the following cyclic processing on each group: judging the type of the operation instruction; when the operation instruction is a reading instruction, sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, and generating output information according to an output information configuration rule and the plurality of data in the database; when the operation instruction is a maintenance instruction, a plurality of data in the database corresponding to the plurality of position information are replaced by a plurality of maintenance data corresponding to the plurality of position information according to the plurality of position information, when the operation instruction is a reading operation instruction, output information corresponding to the plurality of groups is output, and when the operation instruction is a maintenance operation instruction, maintenance success information is output, so that the development period is shortened, the timeliness is enhanced, and the development cost is reduced.
Based on the same inventive concept, the embodiment of the present invention further provides a data processing system, and as the principle of the system for solving the problem is similar to the data processing method, the implementation of the system can refer to the implementation of the method, and repeated details are not repeated.
Fig. 2 is a block diagram of a data processing system according to an embodiment of the present invention. As shown in fig. 2, the data processing system includes:
the creating module is used for creating a data corresponding rule of the database;
the receiving module is used for receiving request information, and the request information comprises an operation instruction and data to be processed;
the generating module is used for generating a plurality of position information according to the data to be processed and the data corresponding rule of the database, and each position information comprises a table number;
the grouping module is used for dividing the position information into a plurality of groups, and the table numbers of the position information in each group are the same;
the circulation module is used for sequentially carrying out the following circulation processing on each group:
judging the type of the operation instruction;
when the operation instruction is a reading instruction, the request information also comprises an output information configuration rule;
sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, and generating output information according to an output information configuration rule and the plurality of data in the database;
when the operation instruction is a maintenance instruction, the request information further includes a plurality of maintenance data corresponding to the plurality of location information;
replacing a plurality of data in a database corresponding to the plurality of position information with a plurality of maintenance data corresponding to the plurality of position information according to the plurality of position information;
the first output module is used for outputting output information corresponding to a plurality of groups;
and the second output module is used for outputting the maintenance success information.
In one embodiment, the request information further includes a plurality of types of data corresponding to the plurality of location information;
the data processing system further comprises: an inspection module to:
reading the types of a plurality of data in the database corresponding to the plurality of position information according to a preset database corresponding rule;
judging whether the types of the data in the request information are the same as the types of the data in the database;
when the types of the data in the request information and the types of the data in the database are the same, each group is subjected to cyclic processing in sequence.
In one embodiment, when the operation instruction is a read instruction, the request information further includes attributes of a plurality of data corresponding to the plurality of location information;
the circulation module is further configured to:
and according to the attribute of each data in the request information, sequentially correcting the attribute of each data in the database, and generating output information according to the output information configuration rule and the corrected data.
In one embodiment, the output information configuration rule includes a data start position, a data length and a data type of each data in the output information in the database.
To sum up, the data processing system according to the embodiment of the present invention creates the data correspondence rule of the database, receives the request information, generates a plurality of location information according to the data to be processed and the data correspondence rule of the database, and then divides the plurality of location information into a plurality of groups to sequentially perform the following cyclic processing on each group: judging the type of the operation instruction; when the operation instruction is a reading instruction, sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, and generating output information according to an output information configuration rule and the plurality of data in the database; when the operation instruction is a maintenance instruction, a plurality of data in the database corresponding to the plurality of position information are replaced by a plurality of maintenance data corresponding to the plurality of position information according to the plurality of position information, when the operation instruction is a reading operation instruction, output information corresponding to the plurality of groups is output, and when the operation instruction is a maintenance operation instruction, maintenance success information is output, so that the development period is shortened, the timeliness is enhanced, and the development cost is reduced.
The embodiment of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and capable of running on the processor, and when the processor executes the computer program, the following steps are implemented:
creating a data corresponding rule of a database;
receiving request information, wherein the request information comprises an operation instruction and data to be processed;
generating a plurality of position information according to the data to be processed and the data corresponding rule of the database, wherein each position information comprises a table number;
dividing the plurality of position information into a plurality of groups, wherein the table numbers of the position information in each group are the same;
each group was subjected to the following cycle in turn:
judging the type of the operation instruction;
when the operation instruction is a reading instruction, the request information also comprises an output information configuration rule;
sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, and generating output information according to an output information configuration rule and the plurality of data in the database;
when the operation instruction is a maintenance instruction, the request information further includes a plurality of maintenance data corresponding to the plurality of location information;
replacing a plurality of data in a database corresponding to the plurality of position information with a plurality of maintenance data corresponding to the plurality of position information according to the plurality of position information;
and after the plurality of groups execute the loop processing, outputting output information corresponding to the plurality of groups when the operation instruction is a reading operation instruction, and outputting maintenance success information when the operation instruction is a maintenance operation instruction.
To sum up, the computer device according to the embodiment of the present invention creates the data correspondence rule of the database, receives the request information, generates a plurality of location information according to the data to be processed and the data correspondence rule of the database, and then divides the plurality of location information into a plurality of groups to sequentially perform the following cyclic processing on each group: judging the type of the operation instruction; when the operation instruction is a reading instruction, sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, and generating output information according to an output information configuration rule and the plurality of data in the database; when the operation instruction is a maintenance instruction, a plurality of data in the database corresponding to the plurality of position information are replaced by a plurality of maintenance data corresponding to the plurality of position information according to the plurality of position information, when the operation instruction is a reading operation instruction, output information corresponding to the plurality of groups is output, and when the operation instruction is a maintenance operation instruction, maintenance success information is output, so that the development period is shortened, the timeliness is enhanced, and the development cost is reduced.
An embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the following steps:
creating a data corresponding rule of a database;
receiving request information, wherein the request information comprises an operation instruction and data to be processed;
generating a plurality of position information according to the data to be processed and the data corresponding rule of the database, wherein each position information comprises a table number;
dividing the plurality of position information into a plurality of groups, wherein the table numbers of the position information in each group are the same;
each group was subjected to the following cycle in turn:
judging the type of the operation instruction;
when the operation instruction is a reading instruction, the request information also comprises an output information configuration rule;
sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, and generating output information according to an output information configuration rule and the plurality of data in the database;
when the operation instruction is a maintenance instruction, the request information further includes a plurality of maintenance data corresponding to the plurality of location information;
replacing a plurality of data in a database corresponding to the plurality of position information with a plurality of maintenance data corresponding to the plurality of position information according to the plurality of position information;
and after the plurality of groups execute the loop processing, outputting output information corresponding to the plurality of groups when the operation instruction is a reading operation instruction, and outputting maintenance success information when the operation instruction is a maintenance operation instruction.
To sum up, the computer-readable storage medium according to the embodiment of the present invention creates a data correspondence rule of a database, receives request information, generates a plurality of pieces of location information according to data to be processed and the data correspondence rule of the database, and then divides the plurality of pieces of location information into a plurality of groups to sequentially perform the following cyclic processing on each group: judging the type of the operation instruction; when the operation instruction is a reading instruction, sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, and generating output information according to an output information configuration rule and the plurality of data in the database; when the operation instruction is a maintenance instruction, a plurality of data in the database corresponding to the plurality of position information are replaced by a plurality of maintenance data corresponding to the plurality of position information according to the plurality of position information, when the operation instruction is a reading operation instruction, output information corresponding to the plurality of groups is output, and when the operation instruction is a maintenance operation instruction, maintenance success information is output, so that the development period is shortened, the timeliness is enhanced, and the development cost is reduced.
The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (8)
1. A data processing method, comprising:
creating a data corresponding rule of a database;
receiving request information, wherein the request information comprises an operation instruction and data to be processed;
generating a plurality of position information according to the data to be processed and the data corresponding rule of the database, wherein each position information comprises a table number;
dividing the plurality of position information into a plurality of groups, wherein the table numbers of the position information in each group are the same;
each group was subjected to the following cycle in turn:
judging the type of the operation instruction;
when the operation instruction is a reading instruction, the request information further comprises an output information configuration rule;
sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, and generating output information according to the output information configuration rule and the plurality of data in the database;
when the operation instruction is a maintenance instruction, the request information further includes a plurality of maintenance data corresponding to the plurality of location information;
replacing a plurality of data in a database corresponding to the plurality of position information with a plurality of maintenance data corresponding to the plurality of position information according to the plurality of position information;
when the plurality of groups execute the circular processing, outputting output information corresponding to the plurality of groups when the operation instruction is a reading operation instruction, and outputting maintenance success information when the operation instruction is a maintenance operation instruction;
the request information further includes types of a plurality of data corresponding to the plurality of location information;
after dividing the plurality of location information into a plurality of groups, further comprising:
reading the types of the data in the database corresponding to the position information according to a preset database corresponding rule;
judging whether the types of the data in the request information are the same as the types of the data in the database;
and when the types of the data in the request information and the types of the data in the database are the same, sequentially carrying out cycle processing on each group.
2. The data processing method according to claim 1, wherein when the operation instruction is a read instruction, the request information further includes attributes of a plurality of data corresponding to the plurality of pieces of location information;
after sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, the method further comprises the following steps:
and according to the attribute of each data in the request information, sequentially correcting the attribute of each data in the database, and generating the output information according to the output information configuration rule and the corrected data.
3. The data processing method of claim 1,
the output information configuration rule comprises a data starting position, a data length and a data type of each data in the database in the output information.
4. A data processing system, comprising:
the creating module is used for creating a data corresponding rule of the database;
the device comprises a receiving module, a processing module and a processing module, wherein the receiving module is used for receiving request information, and the request information comprises an operation instruction and data to be processed;
the generating module is used for generating a plurality of position information according to the data to be processed and the data corresponding rule of the database, and each position information comprises a table number;
the grouping module is used for dividing the plurality of position information into a plurality of groups, and the table numbers of the position information in each group are the same;
the circulation module is used for sequentially carrying out the following circulation processing on each group:
judging the type of the operation instruction;
when the operation instruction is a reading instruction, the request information further comprises an output information configuration rule;
sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, and generating output information according to the output information configuration rule and the plurality of data in the database;
when the operation instruction is a maintenance instruction, the request information further includes a plurality of maintenance data corresponding to the plurality of location information;
replacing a plurality of data in a database corresponding to the plurality of position information with a plurality of maintenance data corresponding to the plurality of position information according to the plurality of position information;
the first output module is used for outputting output information corresponding to a plurality of groups;
the second output module is used for outputting maintenance success information;
the request information further includes types of a plurality of data corresponding to the plurality of location information;
the data processing system further comprises: an inspection module to:
reading the types of the data in the database corresponding to the position information according to a preset database corresponding rule;
judging whether the types of the data in the request information are the same as the types of the data in the database;
and when the types of the data in the request information and the types of the data in the database are the same, sequentially carrying out cycle processing on each group.
5. The data processing system according to claim 4, wherein when the operation instruction is a read instruction, the request information further includes attributes of a plurality of data corresponding to the plurality of pieces of location information;
the circulation module is further configured to:
and according to the attribute of each data in the request information, sequentially correcting the attribute of each data in the database, and generating the output information according to the output information configuration rule and the corrected data.
6. The data processing system of claim 4,
the output information configuration rule comprises a data starting position, a data length and a data type of each data in the database in the output information.
7. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor when executing the computer program implements the steps of:
creating a data corresponding rule of a database;
receiving request information, wherein the request information comprises an operation instruction and data to be processed;
generating a plurality of position information according to the data to be processed and the data corresponding rule of the database, wherein each position information comprises a table number;
dividing the plurality of position information into a plurality of groups, wherein the table numbers of the position information in each group are the same;
each group was subjected to the following cycle in turn:
judging the type of the operation instruction;
when the operation instruction is a reading instruction, the request information further comprises an output information configuration rule;
sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, and generating output information according to the output information configuration rule and the plurality of data in the database;
when the operation instruction is a maintenance instruction, the request information further includes a plurality of maintenance data corresponding to the plurality of location information;
replacing a plurality of data in a database corresponding to the plurality of position information with a plurality of maintenance data corresponding to the plurality of position information according to the plurality of position information;
when the plurality of groups execute the circular processing, outputting output information corresponding to the plurality of groups when the operation instruction is a reading operation instruction, and outputting maintenance success information when the operation instruction is a maintenance operation instruction;
the request information further includes types of a plurality of data corresponding to the plurality of location information;
after dividing the plurality of location information into a plurality of groups, further comprising:
reading the types of the data in the database corresponding to the position information according to a preset database corresponding rule;
judging whether the types of the data in the request information are the same as the types of the data in the database;
and when the types of the data in the request information and the types of the data in the database are the same, sequentially carrying out cycle processing on each group.
8. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of:
creating a data corresponding rule of a database;
receiving request information, wherein the request information comprises an operation instruction and data to be processed;
generating a plurality of position information according to the data to be processed and the data corresponding rule of the database, wherein each position information comprises a table number;
dividing the plurality of position information into a plurality of groups, wherein the table numbers of the position information in each group are the same;
each group was subjected to the following cycle in turn:
judging the type of the operation instruction;
when the operation instruction is a reading instruction, the request information further comprises an output information configuration rule;
sequentially reading a plurality of data in a database corresponding to the plurality of position information according to the plurality of position information, and generating output information according to the output information configuration rule and the plurality of data in the database;
when the operation instruction is a maintenance instruction, the request information further includes a plurality of maintenance data corresponding to the plurality of location information;
replacing a plurality of data in a database corresponding to the plurality of position information with a plurality of maintenance data corresponding to the plurality of position information according to the plurality of position information;
when the plurality of groups execute the circular processing, outputting output information corresponding to the plurality of groups when the operation instruction is a reading operation instruction, and outputting maintenance success information when the operation instruction is a maintenance operation instruction;
the request information further includes types of a plurality of data corresponding to the plurality of location information;
after dividing the plurality of location information into a plurality of groups, further comprising:
reading the types of the data in the database corresponding to the position information according to a preset database corresponding rule;
judging whether the types of the data in the request information are the same as the types of the data in the database;
and when the types of the data in the request information and the types of the data in the database are the same, sequentially carrying out cycle processing on each group.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811113300.5A CN109213821B (en) | 2018-09-25 | 2018-09-25 | Data processing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811113300.5A CN109213821B (en) | 2018-09-25 | 2018-09-25 | Data processing method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109213821A CN109213821A (en) | 2019-01-15 |
| CN109213821B true CN109213821B (en) | 2022-03-15 |
Family
ID=64984617
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811113300.5A Active CN109213821B (en) | 2018-09-25 | 2018-09-25 | Data processing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109213821B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111666290A (en) * | 2020-05-28 | 2020-09-15 | 平安科技（深圳）有限公司 | Data replacement method, device, computer equipment and medium based on artificial intelligence |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103605747A (en) * | 2013-11-20 | 2014-02-26 | 北京国双科技有限公司 | Method and device for processing file form |
| CN105095518A (en) * | 2015-09-18 | 2015-11-25 | 中国农业银行股份有限公司 | Data conversion method and device |
| CN105321331A (en) * | 2014-07-28 | 2016-02-10 | 国家电网公司 | Method, device and system for processing electricity meter information |
| CN107111641A (en) * | 2014-10-27 | 2017-08-29 | 知维科技有限公司 | For the location estimation for the database for updating location data |
| CN107392014A (en) * | 2017-06-23 | 2017-11-24 | 复旦大学 | The SQL injection defence method and system changed at random based on database structure |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9892207B2 (en) * | 2013-02-01 | 2018-02-13 | Sap Se | Automatic migration for on-premise data objects to on-demand data objects |
| CN104252452B (en) * | 2013-06-25 | 2019-03-15 | 腾讯科技（深圳）有限公司 | The method and device of data management |
| CN103744896A (en) * | 2013-12-24 | 2014-04-23 | 乐视网信息技术（北京）股份有限公司 | Method and device for data processing |
| CN107798038B (en) * | 2017-05-05 | 2020-02-14 | 平安科技（深圳）有限公司 | Data response method and data response equipment |
-
2018
- 2018-09-25 CN CN201811113300.5A patent/CN109213821B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103605747A (en) * | 2013-11-20 | 2014-02-26 | 北京国双科技有限公司 | Method and device for processing file form |
| CN105321331A (en) * | 2014-07-28 | 2016-02-10 | 国家电网公司 | Method, device and system for processing electricity meter information |
| CN107111641A (en) * | 2014-10-27 | 2017-08-29 | 知维科技有限公司 | For the location estimation for the database for updating location data |
| CN105095518A (en) * | 2015-09-18 | 2015-11-25 | 中国农业银行股份有限公司 | Data conversion method and device |
| CN107392014A (en) * | 2017-06-23 | 2017-11-24 | 复旦大学 | The SQL injection defence method and system changed at random based on database structure |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109213821A (en) | 2019-01-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106557486A (en) | A kind of storage method and device of data | |
| CN106557307B (en) | Service data processing method and system | |
| CN111352935B (en) | Index creating method, device and equipment in block chain type account book | |
| CN113268500B (en) | Service processing method and device and electronic equipment | |
| WO2017097159A1 (en) | Method and apparatus for generating random character string | |
| CN111966760B (en) | Test data generation method and device based on Hive data warehouse | |
| CN104714957A (en) | List structure changing method and device | |
| CN105468623A (en) | Data processing method and apparatus | |
| CN109213821B (en) | Data processing method and system | |
| CN113032275A (en) | Method and device for testing field, electronic equipment and storage medium | |
| CN112035230A (en) | Method and device for generating task scheduling file and storage medium | |
| CN111159278A (en) | Data display method and device, electronic equipment and computer readable storage medium | |
| CN113703753B (en) | Method and device for product development and product development system | |
| CN116226921A (en) | Desensitization processing method and device | |
| CN115543317A (en) | Front-end page development method and device | |
| CN114398226A (en) | Network asset report generation method and device | |
| CN107908425B (en) | Method and system for generating configuration file | |
| CN111723251A (en) | Method, system and equipment for importing data of graph database | |
| CN112402955B (en) | Game log recording method and system | |
| CN116166617B (en) | Catalog generation method and device for combined open format document OFD | |
| CN111930313B (en) | Method and device for data association access in host | |
| JP2009134662A (en) | Performance test data construction tool | |
| CN116069861A (en) | Data processing method, system and electronic equipment | |
| CN115495366A (en) | Fault drilling template device, template importing method and experiment creating method | |
| CN116414378A (en) | Page packaging method, page loading method and device based on WeexSDK frame |
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 |