Database information write-back processing method and device, electronic equipment and storage medium

Abstract

The invention provides a database information write-back processing method and device, electronic equipment and a storage medium, the database information write-back processing method comprises the following steps: obtaining an original data table containing revision data, the original data table at least comprising header coordinate information and a plurality of data items, and the data items and the header coordinate information are correspondingly arranged; based on a preset coordinate conversion model, performing coordinate simplification processing on the header coordinate information in the original data table to obtain simplified coordinates corresponding to the data items; according to the data items and the simplified coordinates corresponding to the data items, a revision data table containing revision data is constructed, and the revision data table at least comprises the revision data and the simplified coordinates corresponding to the revision data; and performing persistence processing on the revised data table so as to store the revised data table in a preset storage medium. According to the method, the data processing efficiency can be improved, and the storage space occupied by the form type data can be reduced.

Description

Technical Field

[0001] The present invention relates to the field of information processing technology, and in particular to a database information write-back processing method, a database information write-back processing device, an electronic device and a computer-readable storage medium. Background Art

[0002] In information processing systems, form data usually consists of multiple data items, each of which corresponds to specific header coordinate information to distinguish different types of data. However, since each data item in the form requires detailed header coordinate data to ensure the accuracy of its position and the readability of the data, as the complexity of the form increases, the storage volume of the header coordinate data also increases, resulting in a significant increase in the overall data storage requirements. When the data in the form needs to be modified or updated, the system's response speed will be seriously affected due to the need to process a large amount of header coordinate data, thereby reducing the user experience and increasing the cost of data storage. Summary of the invention

[0003] The present invention is based on the inventor's discovery and understanding of the following facts and problems:

[0004] In information processing systems, form data is usually composed of multiple data items, each of which carries specific information content and is located and distinguished by header coordinate information. Header coordinate information not only ensures the accurate position of each data item in the form, but also ensures the readability and comprehensibility of the data, which is crucial for the effective transmission and processing of information.

[0005] However, as the complexity of forms continues to increase, the amount of header coordinate information will also increase significantly. In particular, when the data in the form needs to be modified or updated, the system needs to process a large amount of header coordinate data to ensure that the updated data can still accurately correspond to the corresponding field position. This process is not only time-consuming and labor-intensive, but may also lead to a significant decrease in system response speed, and may even cause serious consequences such as data confusion or loss. In addition, as the demand for data storage continues to increase, the cost of data storage is also continuing to rise. For form data that needs to be stored for a long time and frequently accessed, the high storage cost is undoubtedly a considerable burden.

[0006] To this end, an embodiment of the present invention provides a database information write-back processing method, a database information write-back processing device, an electronic device and a computer-readable storage medium, which can improve data processing efficiency and reduce the storage space occupied by form data.

[0007] The database information write-back processing method provided by the embodiment of the present invention comprises the following steps:

[0008] Acquire an original data table containing revised data, wherein the original data table at least includes table header coordinate information and a plurality of data items, wherein the data items are arranged corresponding to the table header coordinate information;

[0009] Based on a preset coordinate conversion model, coordinate simplification processing is performed on the header coordinate information in the original data table to obtain simplified coordinates corresponding to the data item;

[0010] Constructing a revision data table containing revision data according to the data item and the simplified coordinates corresponding to the data item, wherein the revision data table at least includes the revision data and the simplified coordinates corresponding to the revision data;

[0011] The revised data table is persistently processed to be stored in a preset storage medium.

[0012] In summary, the database information write-back processing method provided by the present invention realizes the compression and simplification of form data through the steps of coordinate simplification, revision data table construction and persistence processing, which not only improves the subsequent data processing efficiency, but also reduces the demand for storage space. At the same time, persistence processing can also ensure the security and reliability of the revision data table, providing strong support for the long-term storage and access of data.

[0013] In some embodiments, the header coordinate information includes multiple field information, first tag serial numbers corresponding to some fields in the multiple field information, and second tag serial numbers corresponding to another part of the multiple field information; the coordinate conversion model includes at least a coordinate simplification algorithm, and the coordinate simplification algorithm includes:

[0014] According to the header coordinate information in the original data table, field information corresponding to the data item in the original data table, and a first mark serial number and a second mark serial number corresponding to the field information are obtained;

[0015] Coordinate operation is performed on the first mark number and the second mark number of the data item to obtain the simplified coordinates corresponding to the data item, and the simplified coordinates of the data item are equal to the product of the first mark number corresponding to the data item and the maximum value of multiple second mark numbers in the header coordinate information plus the second mark number corresponding to the data item.

[0016] In some embodiments, the plurality of field information includes a first field identifier and a second field identifier; the database information write-back processing method further includes the steps of:

[0017] According to the table header coordinate information in the original data table, obtaining the type and the number of types identified by the first field in the table header coordinate information and the type and the number of types identified by the second field in the table header coordinate information;

[0018] According to the type and number of the first field identifiers, the first field identifiers in the header coordinate information are sorted and marked to obtain a first marking sequence number corresponding to the first field identifier;

[0019] According to the type and number of the second field identifiers, sorting and marking processing is performed on the second field identifiers in the header coordinate information to obtain a second marking sequence number corresponding to the second field identifier.

[0020] In some embodiments, the table header coordinate information includes at least column header information, the first field identifier and the second field identifier are arranged side by side in the column header information, the first field identifier is set to one of the product category and location information, and the second field identifier is set to the other of the product category and location information.

[0021] In some embodiments, the database information write-back processing method further comprises the following steps after the step of performing persistent processing on the revised data table to store it in a preset storage medium:

[0022] Reversely extracting the revision data set in the preset storage medium to obtain a revision data table;

[0023] The reversely extracted revision data table is recorded into a third-party storage medium.

[0024] In some embodiments, the database information write-back processing method further comprises the following steps after the step of performing coordinate simplification processing on the header coordinate information in the original data table based on a preset coordinate conversion model to obtain simplified coordinates corresponding to the data item:

[0025] Constructing a simplified data table with simplified coordinates according to the data item and the simplified coordinates corresponding to the data item;

[0026] The simplified data table is persisted so as to be stored in a preset storage medium.

[0027] In some embodiments, the step of obtaining the original data table containing the revised data includes:

[0028] Get the revision data entered by the input device;

[0029] The revised data is updated to the original data table to obtain the original data table containing the revised data.

[0030] In some embodiments, the step of obtaining the original data table containing the revised data includes:

[0031] Get the original data table;

[0032] Determine whether the original data table contains revised data;

[0033] If the original data table contains revised data, the step of obtaining the original data table with the revised data is performed.

[0034] In addition, the database information write-back processing device provided by the embodiment of the present invention includes:

[0035] An acquisition module, the acquisition module is used to acquire an original data table containing revised data, the original data table at least includes table header coordinate information and a plurality of data items, the data items are arranged corresponding to the table header coordinate information;

[0036] A coordinate conversion module, wherein a coordinate conversion model is provided in the coordinate conversion module, and the coordinate conversion module is used to perform coordinate simplification processing on the header coordinate information in the original data table according to a preset coordinate conversion model to obtain simplified coordinates corresponding to the data item;

[0037] A data extraction module, the data extraction module is used to construct a revision data table containing revision data according to the data item and the simplified coordinates corresponding to the data item, the revision data table at least including the revision data and the simplified coordinates corresponding to the revision data;

[0038] A data writing module is used to perform persistence processing on the revised data table so as to store it in a preset storage medium.

[0039] In addition, the electronic device provided by an embodiment of the present invention includes a processor and a memory, wherein the memory stores machine-readable instructions executable by the processor, and when the machine-readable instructions are executed by the processor, the steps in the database information write-back processing method provided in any of the above embodiments are executed.

[0040] In addition, the computer-readable storage medium provided in an embodiment of the present invention stores machine-readable instructions. When the storage medium runs on an electronic device, the machine-readable instructions are used to enable the electronic device to execute the steps in the database information write-back processing method provided in any of the above embodiments. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] The accompanying drawings are used to provide a further understanding of the embodiments of the present invention and constitute a part of the specification. Together with the following specific implementations, they are used to explain the embodiments of the present invention, but do not constitute a limitation on the embodiments of the present invention. In the accompanying drawings:

[0042] Figure 1 It is a flowchart of a database information write-back processing method provided by an embodiment of the present invention.

[0043] Figure 2It is a schematic diagram of an original data table in a database information write-back processing method provided by an embodiment of the present invention.

[0044] Figure 3 yes Figure 2 Schematic diagram of revised inventory data in the original data sheet shown.

[0045] Figure 4 yes Figure 2 Schematic diagram of the revised sales figures in the original data sheet shown.

[0046] Figure 5 It is a corresponding relationship diagram between the first field identifier and the first tag serial number in the database information write-back processing method provided by an embodiment of the present invention.

[0047] Figure 6 It is a corresponding relationship diagram between the second field identifier and the second tag serial number in the database information write-back processing method provided by an embodiment of the present invention.

[0048] Figure 7 It is a diagram of the correspondence between field information and simplified coordinates in a database information write-back processing method provided in an embodiment of the present invention.

[0049] Figure 8 It is a schematic diagram of a revised data table of inventory quantity stored in a preset storage medium in a database information write-back processing method provided in an embodiment of the present invention.

[0050] Fig. 9 It is a schematic diagram of a revised data table of estimated sales volume stored in a preset storage medium in a database information write-back processing method provided in an embodiment of the present invention.

[0051] Fig.10 It is a structural diagram of a database information write-back processing device provided by an embodiment of the present invention.

[0052] Fig.11 It is a schematic diagram of the hardware structure of an electronic device provided by an embodiment of the present invention.

[0053] Reference numerals:

[0054] 100, database information write-back processing device; 110, acquisition module; 120, coordinate conversion module; 130, data extraction module; 140, data writing module;

[0055] 210, processor; 220, memory; 230, communication interface; 240, communication bus. DETAILED DESCRIPTION

[0056] Embodiments of the present invention are described in detail below, and examples of the embodiments are shown in the accompanying drawings. The embodiments described below with reference to the accompanying drawings are exemplary and intended to be used to explain the present invention, but should not be understood as limiting the present invention.

[0057] refer to Figure 1 , is a flow chart of a database information write-back processing method provided by an embodiment of the present invention. The database information write-back processing method comprises the following steps:

[0058] S10, obtaining an original data table containing revised data, wherein the original data table at least includes table header coordinate information and a plurality of data items, and the data items are arranged corresponding to the table header coordinate information.

[0059] Specifically, the data item is the main component element in the original data table, which is used to represent specific information. The revised data is also a type of data item. In other words, the original data table contains not only revised data but also unrevised data items. The header coordinate information is used to identify the position of each data item in the original data table, ensuring that the data item can be correctly identified and processed during the data processing process.

[0060] S20, based on a preset coordinate conversion model, coordinate simplification processing is performed on the header coordinate information in the original data table to obtain simplified coordinates corresponding to the data item.

[0061] Specifically, the preset coordinate transformation model can transform the header coordinate information in the original data table, so that complex coordinate information containing multi-level classification is converted into concise simplified coordinates, which helps to speed up the subsequent data processing efficiency and effectively reduces the storage space requirements.

[0062] S30, constructing a revision data table containing revision data according to the data item and the simplified coordinates corresponding to the data item, wherein the revision data table at least includes the revision data and the simplified coordinates corresponding to the revision data.

[0063] Specifically, after the coordinate simplification process is completed, each data item corresponds to a simplified coordinate, and then the revised data in the data item can be extracted to construct a revised data table containing the revised data, which facilitates understanding and display of the revised content of the original data table.

[0064] S40, performing persistence processing on the revised data table to store it in a preset storage medium.

[0065] Specifically, the persistence processing includes at least data compression, encryption, backup and storage processes, so as to store the revised data table in a preset storage medium. The preset storage medium may be a local disk, Network File System (NFS), Azure Storage, a relational database, a NoSQL database, a cloud storage service or other storage medium. It should be noted that the specific selection of the preset storage medium may depend on factors such as application requirements, data scale and access performance.

[0066] In summary, the database information write-back processing method provided by the present invention realizes the compression and simplification of form data through the steps of coordinate simplification, revision data table construction and persistence processing, which not only improves the subsequent data processing efficiency, but also reduces the demand for storage space. At the same time, persistence processing can also ensure the security and reliability of the revision data table, providing strong support for the long-term storage and access of data.

[0067] In this embodiment, the step of constructing a revision data table containing revision data according to the data item and the simplified coordinates corresponding to the data item in S30 further includes:

[0068] Extract the revised data from the data items in the original data table;

[0069] A revision data table containing the revision data is constructed according to the simplified coordinates corresponding to the revision data in the data item.

[0070] It should be noted that the step of extracting the revised data from the data items in the original data table is not necessarily strictly located in step S30. In some embodiments, the step of extracting the revised data from the data items in the original data table can also be arranged before the step S30. That is, the step of extracting the revised data from the data items in the original data table can be performed after the step of obtaining the original data table containing the revised data.

[0071] In some embodiments, the header coordinate information includes multiple field information, first tag serial numbers corresponding to some fields in the multiple field information, and second tag serial numbers corresponding to another part of the multiple field information, and the coordinate conversion model includes at least a coordinate simplification algorithm, and the coordinate simplification algorithm includes:

[0072] According to the header coordinate information in the original data table, field information corresponding to the data item in the original data table, and a first mark serial number and a second mark serial number corresponding to the field information are obtained;

[0073] Coordinate operation is performed on the first marking serial number and the second marking serial number of the data item to obtain simplified coordinates corresponding to the data item.

[0074] Furthermore, the simplified coordinates of the data item are equal to the product of the first mark number corresponding to the data item and the maximum value of multiple second mark numbers in the header coordinate information plus the second mark number corresponding to the data item.

[0075] Specifically, a data item in the original data table usually corresponds to multiple field information. That is, the first mark number and the second mark number corresponding to the field information can be superimposed to clearly identify the position of the data item in the original data table. The coordinate simplification algorithm can blend the multiple field information corresponding to the data item to simplify the header information and reduce the storage space requirement.

[0076] Furthermore, the plurality of field information includes a first field identifier and a second field identifier, and the database information write-back processing method further includes the steps of:

[0077] According to the table header coordinate information in the original data table, obtaining the type and the number of types identified by the first field in the table header coordinate information and the type and the number of types identified by the second field in the table header coordinate information;

[0078] According to the type and number of the first field identifiers, the first field identifiers in the header coordinate information are sorted and marked to obtain a first marking sequence number corresponding to the first field identifier;

[0079] According to the type and number of the second field identifiers, sorting and marking processing is performed on the second field identifiers in the header coordinate information to obtain a second marking sequence number corresponding to the second field identifier.

[0080] Among them, the maximum value of the multiple second mark numbers in the header coordinate information in the coordinate simplification algorithm is also the number of types of the second field identifier. In other words, the simplified coordinates of the data item in the original data table are equal to the product of the first mark number corresponding to the data item and the number of types of the second field identifier in the original data item plus the second mark number corresponding to the data item. And the first identification number and the second mark number are also the initial simplification of the first field information and the second field information, realizing the initial simplification of the header information in the data table, and preparing for the execution of the coordinate simplification algorithm.

[0081] In this embodiment, the table header coordinate information includes at least column header information, and the first field identifier and the second field identifier are arranged side by side in the column header information, so that the data item can be accurately positioned by the first field identifier and the second field identifier.

[0082] Optionally, the header coordinate information includes commodity category and location information, the first field identifier may be set to one of the commodity category and location information, and the second field identifier may be set to the other of the commodity category and location information.

[0083] In this application, for the convenience of description, Figures 2 to 9 The steps in the database information write-back processing method provided by the present invention are described below. Figure 2 A schematic diagram of an original data table provided for this embodiment. Figure 2 The column header information of the internal data table at least includes the product categories such as coffee and mineral water and the location information such as Beijing, Shanghai, and Guangzhou. Figure 2 The horizontal header information of the internal data table shall at least include the information of the first quarter of 2024, the second quarter of 2024, the third quarter of 2024 and the fourth quarter of 2024. Figure 2 The first field identifier may be the product category, such as coffee, mineral water, etc. The second field identifier may be location information, such as Beijing, Shanghai, Guangzhou, etc. Figure 2 The revision data in can be Figure 3 and Figure 4 It should be noted that, in some embodiments, the first field identifier and the second field identifier may also be located on the horizontal header information of the data table, which will not be described in detail here.

[0084] In the execution process of the database information write-back processing method provided in the above embodiment, the first field identifier and the second word identifier in the original data table can be obtained first, that is, Figure 2 Then, the first field identifier and the second field identifier are sorted to obtain the corresponding relationship between the first field identifier and the first tag serial number, and the corresponding relationship between the second field identifier and the second tag serial number. Figure 5 is a corresponding relationship diagram between the first field identifier and the first tag sequence number in this embodiment, Figure 6 This is a diagram of the correspondence between the second field identifier and the second tag number in this embodiment.

[0085] like Figure 7 As shown, during the execution of step S20, the coordinate simplification algorithm can be used to calculate the first mark number and the second mark number to obtain the simplified coordinates corresponding to the combination of the first field and the second field, that is, the simplified coordinates corresponding to the data item. For example, the first mark number corresponding to the commodity type coffee is 0, the second mark number corresponding to the location information Beijing is 2, and the number of types corresponding to the location information is 3, then the simplified coordinates corresponding to coffee and Beijing are 2; the first mark number corresponding to the commodity type mineral water is 1, the second mark number corresponding to the location information Shanghai is 1, and the number of types corresponding to the location information is 3, then the simplified coordinates corresponding to mineral water and Shanghai are 4.

[0086] Then, according to the simplified coordinates and the revised data in the original data table, a revised data table containing the revised data and simplified coordinates is constructed, that is, Figure 8 The stock quantities shown correspond to the revised data sheet and Fig. 9 Of course, in some embodiments, Figure 8 The stock quantities shown correspond to the revised data sheet and Fig. 9 The revised data tables corresponding to the projected sales volumes shown can also be combined into one table.

[0087] Finally, the revised data table including the revised data and simplified coordinates is processed by persistence and stored in a preset storage medium.

[0088] In some embodiments, the database information write-back processing method further comprises the following steps after the step of performing persistent processing on the revised data table to store it in a preset storage medium:

[0089] Reversely extracting the revision data set in the preset storage medium to obtain a revision data table;

[0090] The reverse extracted revision data table is entered into a third-party storage medium.

[0091] That is to say, the database information write-back processing method provided by the embodiment of the present invention not only covers the process of extracting revised data from the original data table, constructing a revised data table, and persistently storing it in a preset storage medium, but also further expands the reverse extraction of data and the migration capabilities across storage media, facilitating the transmission of form-type data and the display of revised data to upstream and downstream customers. The third-party storage medium can be a relational database, NoSQL database, cloud storage service of a different type from the preset storage medium, or any other medium that can meet data storage requirements.

[0092] In some embodiments, the database information write-back processing method further comprises the following steps after the step of performing coordinate simplification processing on the header coordinate information in the original data table based on a preset coordinate conversion model to obtain simplified coordinates corresponding to the data item:

[0093] Constructing a simplified data table with simplified coordinates according to the data item and the simplified coordinates corresponding to the data item;

[0094] The simplified data table is persisted so as to be stored in a preset storage medium.

[0095] Specifically, after the step of performing coordinate simplification processing on the header coordinate information in the original data table based on a preset coordinate transformation model to obtain simplified coordinates corresponding to the data item, a simplified data table with simplified coordinates can be constructed based on the data item and the simplified coordinates corresponding to the data item, thereby realizing the storage of a simplified data table with complete data items.

[0096] That is to say, the database information write-back processing method provided by the present invention can also be used to process all data items in the original data table to generate a simplified data table with simplified coordinates to facilitate subsequent data updates, data transmission and data storage, and especially to reduce the demand for storage space.

[0097] In some embodiments, the step of obtaining the original data table containing the revised data includes:

[0098] Get the revision data entered by the input device;

[0099] The revised data is updated to the original data table to obtain the original data table containing the revised data.

[0100] The input device may be a keyboard, a touch screen or other input device, and the data to be revised is directly input into the system. The input data may include modification of field values, addition of new data or deletion of old data, etc., depending on the specific needs and operations of the user. Then, the system will update the revised data into the original data table, thereby generating a new original data table containing the revised data; then steps S20 to S40 can be executed again.

[0101] In some embodiments, the step of obtaining the original data table containing the revised data includes:

[0102] Get the original data table;

[0103] Determine whether the original data table contains revised data;

[0104] If the original data table contains revised data, the original data table containing the revised data is obtained.

[0105] Specifically, the database information write-back processing method first obtains the original data table, and then determines whether the obtained original data table contains revised data. This step can avoid unnecessary processing progress and ensure that steps S20 to S40 are only executed when really needed.

[0106] That is, when the original data table contains the revised data, steps S20 to S40 are executed; when the original data table does not contain the revised data, the execution of steps S20 to S40 is stopped.

[0107] Of course, in some other embodiments, when the original data table does not contain revised data, step S20 can continue to be executed, and then the step of constructing a simplified data table with simplified coordinates based on the data items and the simplified coordinates corresponding to the data items, and persisting the simplified data table to store it in a preset storage medium can be performed to realize the processing of the entire data table and reduce the storage space requirement of the entire data table.

[0108] In addition, it should be made clear that Figure 1 The flowchart of the database information write-back processing method shown in the flowchart is a sequence of steps based only on the logical sequence provided by one of the many embodiments of the present invention. This sequence is intended to clearly illustrate the execution process of the method in a specific application scenario. However, in actual applications, the flexibility and scalability of the present invention allow technicians to adjust the sequence of the above steps according to different actual needs and environmental conditions, such as the existence of parallel or parallel relationships between some steps, which will not be repeated here.

[0109] refer to Fig.10 , is a schematic diagram of the structure of a database information write-back processing device 100 provided in an embodiment of the present invention. The database information write-back processing device 100 includes an acquisition module 110, a coordinate conversion module 120, a data extraction module 130 and a data writing module 140, and the above modules are electrically connected to realize information transmission and reception. Of course, in some embodiments, the acquisition module 110, the coordinate conversion module 120, the data extraction module 130 and the data writing module 140 can also be integrated into one, so that the overall structure is more compact.

[0110] Among them, the acquisition module 110 is used to obtain the original data table containing the revised data, and the original data table at least includes header coordinate information and multiple data items, and the data items are set corresponding to the header coordinate information. The coordinate conversion module 120 is provided with a coordinate conversion model, and the coordinate conversion module 120 is used to perform coordinate simplification processing on the header coordinate information in the original data table according to a preset coordinate conversion model to obtain simplified coordinates corresponding to the data items. The data extraction module 130 is used to construct a revised data table containing the revised data according to the data items and the simplified coordinates corresponding to the data items, and the revised data table at least includes the revised data and the simplified coordinates corresponding to the revised data. The data writing module 140 is used to perform persistence processing on the revised data table to store it in a preset storage medium.

[0111] It should be noted that the database information write-back processing device provided in the embodiment of the present application has the same implementation principle and technical effects as those in the aforementioned database information write-back processing method embodiment. For the sake of brief description, for matters not mentioned in the device embodiment, reference may be made to the corresponding contents in the aforementioned database information write-back processing method embodiment.

[0112] refer to Fig.11 , is a schematic diagram of the hardware structure of an electronic device provided in one embodiment of the present invention. The electronic device provided in this embodiment includes a processor 210 and a memory 220, and the memory 220 stores machine-readable instructions executable by the processor 210. When the machine-readable instructions are executed by the processor 210, the steps in the database information write-back processing method described in any of the above embodiments are executed. Among them, each of the processor 210 and the memory 220 is provided with at least one.

[0113] In this embodiment, the electronic device further includes a communication interface 230 and a communication bus 240, wherein the processor 210, the memory 220 and the communication interface 230 are connected to each other via the communication bus 240. The communication bus 240 can be divided into an address bus, a data bus, a control bus, etc. For convenience of representation, Figure 3 In the figure, only one thick line is used to represent the communication bus 240, but it does not mean that there is only one communication bus 240 or one type of communication bus 240. The processor 210 may also be called a controller, and there is no limitation on the name.

[0114] In the embodiment of the present application, the memory 220 stores instructions that can be executed by at least one processor 210. The at least one processor 210 can execute the steps in the database information write-back processing method discussed above by executing the instructions stored in the memory 220. The processor 210 can implement Figure 3 The functions of each module in the device shown.

[0115] Among them, the processor 210 is the control center of the device, and can use various interfaces and lines to connect the various parts of the entire control device. By running or executing instructions stored in the memory 220 and calling data stored in the memory 220, the various functions of the device and process data, the device can be monitored as a whole.

[0116] In one possible design, the processor 210 may include one or more processing units, and the processor 210 may integrate an application processor and a modem processor, wherein the application processor mainly processes an operating system, an operating body interface, and application programs, and the modem processor mainly processes wireless communications. It is understandable that the above-mentioned modem processor may not be integrated into the processor. In some embodiments, the processor 210 and the memory 220 may be implemented on the same chip or on separate chips.

[0117] The processor 210 may be a general-purpose processor, such as a central processing unit (CPU), a digital signal processor, an application-specific integrated circuit, a field programmable gate array or other programmable logic device, a discrete gate or transistor logic device, or a discrete hardware component, and may implement or execute the methods, steps, and logic block diagrams disclosed in the embodiments of the present application. A general-purpose processor may be a microprocessor or any conventional processor, etc. The steps of the database information write-back processing method disclosed in the embodiments of the present application may be directly embodied as being executed by a hardware processor, or may be executed by a combination of hardware and software modules in the processor.

[0118] The memory 220, as a non-volatile computer-readable storage medium, can be used to store non-volatile software programs, non-volatile computer executable programs and modules. The memory 220 may include at least one type of storage medium, such as a flash memory, a hard disk, a multimedia card, a card-type memory, a random access memory (Random Access Memory, RAM), a static random access memory (Static Random Access Memory, SRAM), a programmable read-only memory (Programmable Read Only Memory, PROM), a read-only memory (Read Only Memory, ROM), an electrically erasable programmable read-only memory (Electrically Erasable Programmable Read-Only Memory, EEPROM), a magnetic memory, a disk, an optical disk, etc. The memory 220 is any other medium that can be used to carry or store a desired program code in the form of an instruction or data structure and can be accessed by a computer, but is not limited thereto. The memory 220 in the embodiment of the present application can also be a circuit or any other device that can realize a storage function, for storing program instructions and / or data.

[0119] By programming the processor 210, the code corresponding to the database information write-back processing method described in the above embodiment can be fixed into the chip, so that the chip can execute the code when running. Figure 2 The steps of the database information write-back processing method of the embodiment shown are as follows: How to design and program the processor 210 is a technology well known to those skilled in the art and will not be described in detail here.

[0120] The embodiment of the present application also provides a computer-readable storage medium, in which computer-executable instructions are stored. When the computer-executable instructions are executed by the processor 210, they are used to implement the database information write-back processing method described in any of the above embodiments. Therefore, they will not be described in detail here. In addition, the description of the beneficial effects of the same method will not be repeated. For technical details not disclosed in the computer storage medium embodiment involved in the present invention, please refer to the description of the method embodiment of the present invention.

[0121] In some possible implementations, various aspects of the database information write-back processing method provided in the present application may also be implemented in the form of a program product, which includes a program code. When the program product is run on an apparatus, the program code is used to enable the control device to execute the steps of the database information write-back processing method according to various exemplary implementations of the present application described above in this specification.

[0122] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented in one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that include computer-usable program code.

[0123] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0124] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0125] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process in the computer or other programmable device. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0126] In addition, any process or method description in the flowchart or otherwise described herein may be understood to represent a module, segment or portion of code that includes one or more executable instructions for implementing the steps of a custom logical function or process, and the scope of the preferred embodiments of the present invention includes additional implementations in which functions may not be performed in the order shown or discussed, including performing functions in a substantially simultaneous manner or in the reverse order depending on the functions involved, which should be understood by technicians in the technical field to which the embodiments of the present invention belong.

[0127] Although the embodiments of the present invention have been shown and described above, it is to be understood that the above embodiments are exemplary and are not to be construed as limitations of the present invention. A person skilled in the art may change, modify, replace and vary the above embodiments within the scope of the present invention.

Claims

1. A database information write-back processing method, characterized in that: The steps include: Acquire an original data table containing revised data, wherein the original data table at least includes table header coordinate information and a plurality of data items, wherein the data items are arranged corresponding to the table header coordinate information; Based on a preset coordinate conversion model, coordinate simplification processing is performed on the header coordinate information in the original data table to obtain simplified coordinates corresponding to the data item; Constructing a revision data table containing revision data according to the data item and the simplified coordinates corresponding to the data item, wherein the revision data table at least includes the revision data and the simplified coordinates corresponding to the revision data; The revised data table is persistently processed to be stored in a preset storage medium.

2. The database information write-back processing method according to claim 1, characterized in that: The header coordinate information includes a plurality of field information, a first mark serial number corresponding to a part of the fields in the plurality of field information, and a second mark serial number corresponding to another part of the fields in the plurality of field information; The coordinate transformation model at least includes a coordinate simplification algorithm, and the coordinate simplification algorithm includes: According to the header coordinate information in the original data table, field information corresponding to the data item in the original data table, and a first mark serial number and a second mark serial number corresponding to the field information are obtained; Coordinate operation is performed on the first mark number and the second mark number of the data item to obtain the simplified coordinates corresponding to the data item, and the simplified coordinates of the data item are equal to the product of the first mark number corresponding to the data item and the maximum value of multiple second mark numbers in the header coordinate information plus the second mark number corresponding to the data item.

3. The database information write-back processing method according to claim 2, characterized in that: The plurality of field information includes a first field identifier and a second field identifier; the database information write-back processing method further includes the steps of: According to the table header coordinate information in the original data table, obtaining the type and the number of types identified by the first field in the table header coordinate information and the type and the number of types identified by the second field in the table header coordinate information; According to the type and number of the first field identifiers, sort and mark the first field identifiers in the header coordinate information to obtain a first mark sequence number corresponding to the first field identifier; According to the type and number of the second field identifiers, the second field identifiers in the header coordinate information are sorted and marked to obtain a second marking sequence number corresponding to the second field identifier.

4. The database information write-back processing method according to claim 3, characterized in that: The table header coordinate information at least includes column header information, the first field identifier and the second field identifier are arranged side by side in the column header information, the first field identifier is set to one of the commodity type and location information, and the second field identifier is set to the other of the commodity type and location information.

5. The database information write-back processing method according to claim 1, characterized in that: The database information write-back processing method further comprises the following steps after the step of performing persistent processing on the revised data table to store it in a preset storage medium: Reversely extracting the revision data set in the preset storage medium to obtain a revision data table; Entering the reversely extracted revision data table into a third-party storage medium; And / or, the database information write-back processing method further comprises the steps of: performing coordinate simplification processing on the header coordinate information in the original data table based on a preset coordinate conversion model to obtain simplified coordinates corresponding to the data item; Constructing a simplified data table with simplified coordinates according to the data item and the simplified coordinates corresponding to the data item; The simplified data table is persisted so as to be stored in a preset storage medium.

6. The database information write-back processing method according to claim 1, characterized in that: The step of obtaining the original data table containing the revised data comprises: Get the revision data entered by the input device; The revised data is updated to the original data table to obtain the original data table containing the revised data.

7. The database information write-back processing method according to claim 1, characterized in that: The step of obtaining the original data table containing the revised data comprises: Get the original data table; Determine whether the original data table contains revised data; If the original data table contains revised data, the original data table containing the revised data is obtained.

8. A database information write-back processing device, characterized in that: include: An acquisition module, the acquisition module is used to acquire an original data table containing revised data, the original data table at least includes table header coordinate information and a plurality of data items, the data items are arranged corresponding to the table header coordinate information; A coordinate conversion module, wherein a coordinate conversion model is provided in the coordinate conversion module, and the coordinate conversion module is used to perform coordinate simplification processing on the header coordinate information in the original data table according to a preset coordinate conversion model to obtain simplified coordinates corresponding to the data item; A data extraction module, the data extraction module is used to construct a revision data table containing revision data according to the data item and the simplified coordinates corresponding to the data item, the revision data table at least including the revision data and the simplified coordinates corresponding to the revision data; A data writing module is used to perform persistence processing on the revised data table so as to store it in a preset storage medium.

9. An electronic device, characterized in that: The method comprises a processor and a memory, wherein the memory stores machine-readable instructions executable by the processor, and when the machine-readable instructions are executed by the processor, the steps in the database information write-back processing method described in any one of claims 1 to 7 are executed.

10. A computer-readable storage medium, characterized in that: Machine-readable instructions are stored therein. When the storage medium is run on an electronic device, the machine-readable instructions are used to enable the electronic device to execute the steps in the database information write-back processing method described in any one of claims 1 to 7.

Images