CN117971850A - Method, device, equipment and medium for maintaining data consistency - Google Patents
Method, device, equipment and medium for maintaining data consistency Download PDFInfo
- Publication number
- CN117971850A CN117971850A CN202410210781.0A CN202410210781A CN117971850A CN 117971850 A CN117971850 A CN 117971850A CN 202410210781 A CN202410210781 A CN 202410210781A CN 117971850 A CN117971850 A CN 117971850A
- Authority
- CN
- China
- Prior art keywords
- basic
- service
- target information
- basic table
- materials
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 41
- 238000004590 computer program Methods 0.000 claims description 10
- 230000004048 modification Effects 0.000 abstract description 9
- 238000012986 modification Methods 0.000 abstract description 9
- 238000010586 diagram Methods 0.000 description 3
- 230000001360 synchronised effect Effects 0.000 description 3
- 238000012217 deletion Methods 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- 230000014509 gene expression Effects 0.000 description 2
- 230000004044 response Effects 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2358—Change logging, detection, and notification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Human Resources & Organizations (AREA)
- Entrepreneurship & Innovation (AREA)
- Development Economics (AREA)
- Computer Security & Cryptography (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to the technical field of computers, and provides a method, a device, equipment and a medium for maintaining data consistency. The method comprises the following steps: establishing an association relationship between a basic table corresponding to the material basic information and a business table corresponding to the material business requirement based on the material number of the material; and responding to a request for carrying out corresponding operation on the target information in the basic table, calling all service tables corresponding to the basic table based on the association relation, checking whether the target information exists in the service tables, and confirming whether the corresponding operation is carried out on the target information in the basic table according to a checking result so as to keep the consistency of the data in the basic table and the service tables. The scheme can effectively avoid the problem that the data of the basic table is inconsistent with the data of the service table due to the modification of the basic table, and avoid the data errors of the summary report of the follow-up export of the service table.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method, an apparatus, a device, and a medium for maintaining data consistency.
Background
In the management software, some frequently used basic information is imported by the user at the beginning of using the management software, and is used for ex-warehouse, in-warehouse, etc. in the management software, so that the basic information cannot be modified or deleted in principle. The existing management software isolates the forms for storing the basic information from the forms for using the basic information, so that if the forms for storing the basic information are modified or deleted, the summarized report obtained based on the forms for using the basic information is wrong, and finally the management software is abnormal and cannot be used continuously.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a method, apparatus, device, and medium for maintaining data consistency.
According to a first aspect of the present invention, there is provided a method of maintaining data consistency, for use in management software, the method of maintaining data consistency comprising:
establishing an association relationship between a basic table corresponding to the material basic information and a business table corresponding to the material business requirement based on the material number of the material;
And responding to a request for carrying out corresponding operation on the target information in the basic table, calling all service tables corresponding to the basic table based on the association relation, checking whether the target information exists in the service tables, and confirming whether the corresponding operation is carried out on the target information in the basic table according to a checking result so as to keep the consistency of the data in the basic table and the service tables.
In some embodiments, the step of confirming whether to perform the corresponding operation on the target information in the base table according to a result of the checking includes:
And responding to the fact that the target information does not exist in all service tables corresponding to the basic table, and carrying out corresponding operation on the target information in the basic table.
In some embodiments, the step of confirming whether to perform the corresponding operation on the target information in the base table according to the checking result to maintain consistency of data in the base table and the service table includes:
Responding to the existence of the target information in a part or all of the service tables corresponding to the basic table, acquiring the service table with the target information, prompting the service table with the target information based on a preset prompting rule, and not carrying out the corresponding operation on the target information in the basic table so as to keep the consistency of the data in the basic table and the service table.
In some embodiments, the method of maintaining data consistency further comprises:
And configuring a basic table corresponding to the basic information of the materials based on the materials dictionary, the supplier dictionary, the warehouse dictionary, the goods position dictionary and the salesman dictionary, wherein the basic information comprises material numbers, material names and material models.
In some embodiments, the method of maintaining data consistency further comprises:
And configuring a service table based on the service requirement of the user on the material, wherein the service table comprises a warehouse entry list, a warehouse exit list, a bill of lading and a contract.
In some embodiments, the step of establishing an association between a base table corresponding to the material base information and a service table corresponding to the material service requirement based on the material number of the material includes:
Searching all basic tables corresponding to the basic information of the materials in the management software based on the physical numbers of the materials to obtain a target basic table;
Searching all service tables corresponding to material service requirements in the management software based on the physical numbers of the materials to obtain a plurality of service tables;
and establishing an association relation between the target basic table and the service tables.
In some embodiments, the corresponding operations include a modify operation and a delete operation.
According to a second aspect of the present invention, there is provided an apparatus for maintaining data consistency, for use in management software, the apparatus comprising:
The first module is used for establishing an association relationship between a basic table corresponding to the basic information of the materials and a business table corresponding to the business requirements of the materials based on the material numbers of the materials;
and the second module is used for responding to the request of carrying out corresponding operation on the target information in the basic table, calling all service tables corresponding to the basic table based on the association relation, checking whether the target information exists in the service tables, and confirming whether the corresponding operation is carried out on the target information in the basic table according to the checking result so as to keep the consistency of the data in the basic table and the service tables.
In some embodiments, the second module is further to: and responding to the fact that the target information does not exist in all service tables corresponding to the basic table, and carrying out corresponding operation on the target information in the basic table.
In some embodiments, the second module is further to: responding to the existence of the target information in a part or all of the service tables corresponding to the basic table, acquiring the service table with the target information, prompting the service table with the target information based on a preset prompting rule, and not carrying out the corresponding operation on the target information in the basic table so as to keep the consistency of the data in the basic table and the service table.
In some embodiments, the apparatus for maintaining data consistency further comprises means for: and configuring a basic table corresponding to the basic information of the materials based on the materials dictionary, the supplier dictionary, the warehouse dictionary, the goods position dictionary and the salesman dictionary, wherein the basic information comprises material numbers, material names and material models.
In some embodiments, the apparatus for maintaining data consistency further comprises means for: and configuring a service table based on the service requirement of the user on the material, wherein the service table comprises a warehouse entry list, a warehouse exit list, a bill of lading and a contract.
In some embodiments, the first module is further to: searching all basic tables corresponding to the basic information of the materials in the management software based on the physical numbers of the materials to obtain a target basic table;
Searching all service tables corresponding to material service requirements in the management software based on the physical numbers of the materials to obtain a plurality of service tables;
and establishing an association relation between the target basic table and the service tables.
In some embodiments, the corresponding operations include a modify operation and a delete operation.
According to a third aspect of the present invention, there is also provided an electronic device including:
At least one processor; and
And a memory storing a computer program executable on the processor, the processor executing the method of maintaining data consistency as described above.
According to a fourth aspect of the present invention there is also provided a computer readable storage medium storing a computer program which when executed by a processor performs the aforementioned method of maintaining data consistency.
According to the method for maintaining the data consistency, the association relation between the basic table corresponding to the basic information of the materials and the service table corresponding to the business requirements of the materials is established according to the material numbers, if the corresponding operation is carried out on the target information in the basic table, all the business tables corresponding to the basic table are called according to the association relation, whether the target information exists in the business tables is checked, whether the corresponding operation is carried out on the target information in the basic table is confirmed according to the checking result, and therefore the data consistency of the basic table and the business table is maintained. The problem that the data of the basic table is inconsistent with the data of the service table due to modification of the basic table can be effectively avoided, data errors of a summary report form which is exported later on of the service table are avoided, stability of management software is improved, and normal and stable operation of the management software is guaranteed.
In addition, the invention also provides a device for keeping data consistency, an electronic device and a computer readable storage medium, which can also realize the technical effects, and are not repeated here.
Drawings
In order to more clearly illustrate the embodiments of the invention or the technical solutions in the prior art, the drawings that are necessary for the description of the embodiments or the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the invention and that other embodiments may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of a method for maintaining data consistency according to one embodiment of the present invention;
FIG. 2 is another flow chart of a method for maintaining data consistency according to another embodiment of the present invention;
FIG. 3 is a schematic diagram of an apparatus for maintaining data consistency according to another embodiment of the present invention;
FIG. 4 is an internal block diagram of an electronic device in accordance with another embodiment of the present invention;
fig. 5 is a block diagram of a computer readable storage medium according to another embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the following embodiments of the present invention will be further described in detail with reference to the accompanying drawings.
It should be noted that, in the embodiments of the present invention, all the expressions "first" and "second" are used to distinguish two entities with the same name but different entities or different parameters, and it is noted that the "first" and "second" are only used for convenience of expression, and should not be construed as limiting the embodiments of the present invention, and the following embodiments are not described one by one.
In one embodiment, referring to fig. 1, the present invention provides a method 100 for maintaining data consistency, specifically, the method for maintaining data consistency includes the following steps:
Step 101, establishing an association relationship between a basic table corresponding to material basic information and a business table corresponding to material business requirements based on material numbers of materials;
step 102, in response to receiving a request for performing a corresponding operation on the target information in the base table, calling all service tables corresponding to the base table based on the association relationship, checking whether the target information exists in the service tables, and confirming whether to perform the corresponding operation on the target information in the base table according to a checking result so as to maintain consistency of data in the base table and the service tables.
The application relates to a method for keeping data consistency, which establishes an association relation between a basic table corresponding to basic information of materials and a business table corresponding to business requirements of the materials according to material numbers, if the corresponding operation is carried out on target information in the basic table, all business tables corresponding to the basic table are called according to the association relation, whether the target information exists in the business tables is checked, and whether the corresponding operation is carried out on the target information in the basic table is confirmed according to a check result, so that the data consistency of the basic table and the business table is kept. The problem that the data of the basic table is inconsistent with the data of the service table due to modification of the basic table can be effectively avoided, data errors of a summary report form which is exported later on of the service table are avoided, stability of management software is improved, and normal and stable operation of the management software is guaranteed.
Referring to fig. 1, the step of determining whether to perform the corresponding operation on the target information in the base table according to the checking result according to several embodiments of the present invention includes:
And responding to the fact that the target information does not exist in all service tables corresponding to the basic table, and carrying out corresponding operation on the target information in the basic table.
Referring to fig. 1, the step of determining whether to perform the corresponding operation on the target information in the base table according to the checking result to maintain the consistency of the data in the base table and the service table according to the embodiments of the present invention includes:
Responding to the existence of the target information in a part or all of the service tables corresponding to the basic table, acquiring the service table with the target information, prompting the service table with the target information based on a preset prompting rule, and not carrying out the corresponding operation on the target information in the basic table so as to keep the consistency of the data in the basic table and the service table.
Through the association relation established between the basic table and the service table, when the basic table is correspondingly operated, firstly, the service table associated with the basic table is checked to confirm whether the basic table is correspondingly operated, so that the problem that the basic table and the service table are inconsistent in data due to modification of the basic table can be effectively avoided, and the data errors of the summary report of the follow-up export of the service table are avoided.
Referring to fig. 1, the method for maintaining data consistency according to several embodiments of the present invention further includes:
And configuring a basic table corresponding to the basic information of the materials based on the materials dictionary, the supplier dictionary, the warehouse dictionary, the goods position dictionary and the salesman dictionary, wherein the basic information comprises material numbers, material names and material models.
Referring to fig. 1, the method for maintaining data consistency according to several embodiments of the present invention further includes:
And configuring a service table based on the service requirement of the user on the material, wherein the service table comprises a warehouse entry list, a warehouse exit list, a bill of lading and a contract.
Referring to fig. 1, the step of establishing an association relationship between a base table corresponding to material base information and a service table corresponding to material service requirements based on material numbers of materials according to several embodiments of the present invention includes:
Searching all basic tables corresponding to the basic information of the materials in the management software based on the physical numbers of the materials to obtain a target basic table;
Searching all service tables corresponding to material service requirements in the management software based on the physical numbers of the materials to obtain a plurality of service tables;
and establishing an association relation between the target basic table and the service tables.
In some embodiments, when the management software is started, the information manager configures the base table based on a material dictionary, a supplier dictionary, a warehouse dictionary, a goods space dictionary, a salesman dictionary and the like, wherein the material dictionary and the supplier dictionary are configuration items with higher use frequency, and key items including material numbers, names, specification models and the like are obtained from the base table. Meanwhile, the information manager collects the business demands of the users on the materials and configures business tables such as warehouse entry, warehouse exit, bill of lading and contracts based on the business demands. After the basic table and the business table related to the materials are configured, the association relationship between the basic table and the business table is established according to the material numbers of the materials. In one example, the association relationship between the basic table and the service table is stored through a configurable table, in which the association relationship between the basic table and the service table is recorded through the physical number of the material, specifically, for example, for the material number a, one basic table (basic table 1) where the material number a is located is obtained according to the material number a, and all service tables (service table 1, service table 2 and service table 3) where the material number a is located are obtained at the same time, and in the configurable table, the basic table 1 is respectively associated with the service table 1, the service table 2 and the service table 3, and in general, one basic table is generally associated with a plurality of service tables. Table 1 below is a table structure configured in a configurable table, and includes a base table, a service table field (such as a material number), a prompt message, and an operation flag, where the operations include a delete operation and a modify operation.
TABLE 1
The prompting information is information which is prompted to the user when the service table is not checked to pass, for example, the service table 1 is checked to pass, and the target information in the basic table is not suggested to be modified; the service table field is a field for establishing association between a base table and a corresponding service table in a configurable table, such as a material number of the present application, and the operation flag is a flag corresponding to a modification operation and a deletion operation respectively, such as a modification operation is 1 and a deletion operation is 2.
In some embodiments, when the corresponding operation is performed on the target information in the base table, all service tables corresponding to the base table are checked based on the association relationship between the base table and the service table recorded in the configurable table. Fig. 2 is a flowchart of a method for maintaining data consistency according to another embodiment of the present invention, please refer to fig. 2, in an example, in a created check table, all service tables corresponding to a base table recorded in the configurable table are combined for checking, and service tables not meeting the check rule are prompted to a user based on a preset prompting rule, and no corresponding operation is performed on target information in the base table. Specifically, for example, the quantity information in the basic table 1 where the material number a is located needs to be modified (or deleted), all the service tables (service table 1, service table 2 and service table 3) corresponding to the basic table 1 are acquired based on the configurable table and synchronized into a check table, in the check table, whether the quantity information of the material corresponding to the material number a in the basic table 1 exists in the service table 1, the service table 2 and the service table 3 is checked in sequence, if the quantity information of the material corresponding to the material number a exists (for example, the quantity information of the material corresponding to the material number a exists in the service table 3), the quantity information of the material corresponding to the material number a is indicated to be used in the corresponding service table (service table 3), the quantity information of the material corresponding to the material number a in the basic table 1 cannot be operated correspondingly, otherwise, when the corresponding service table (service table 3) performs the subsequent summary report, the problem of data error caused by inconsistent data with the data of the basic table can occur; if the number information of the materials corresponding to the material number A is not used in all the service tables (service table 1, service table 2 and service table 3) corresponding to the basic table 1, the number information of the materials corresponding to the material number A in the basic table 1 can be correspondingly operated, the problem that the data of the basic table and the service table are inconsistent is avoided, the stability of management software is improved, and the normal and stable operation of the management software is ensured.
According to several embodiments of the present invention, the corresponding operations include a modify operation and a delete operation.
In some embodiments, please continue to refer to fig. 2, if the target information of a certain basic table (such as basic table 1) needs to be modified, the operation flag is selected to be 1, the service table field is selected, the service table field is the material number, the basic table 1 is selected from all basic tables in the management software, all service tables corresponding to the basic table 1 are selected from the configurable tables based on the material number, such as a warehouse entry list and a warehouse exit list, and prompt information is edited, such as that the material number cannot be modified, based on this, all service tables corresponding to the basic table 1 are checked in sequence, and whether the target information of the basic table 1 is modified is confirmed according to the check result. The problem that the data of the basic table is inconsistent with the data of the service table due to modification of the basic table can be effectively avoided, data errors of a summary report form which is exported later on of the service table are avoided, stability of management software is improved, and normal and stable operation of the management software is guaranteed.
In some embodiments, referring to fig. 3, the present invention further provides an apparatus 200 for maintaining data consistency, applied to management software, where the apparatus includes:
A first module 201, configured to establish an association relationship between a base table corresponding to the material base information and a service table corresponding to the material service requirement based on a material number of the material;
And a second module 202, configured to, in response to receiving a request for performing a corresponding operation on the target information in the base table, invoke all service tables corresponding to the base table based on the association relationship, check whether the target information exists therein, and confirm whether to perform the corresponding operation on the target information in the base table according to a check result, so as to maintain consistency of data in the base table and the service tables.
According to several embodiments of the present invention, the second module 202 is further configured to: and responding to the fact that the target information does not exist in all service tables corresponding to the basic table, and carrying out corresponding operation on the target information in the basic table.
According to several embodiments of the present invention, the second module 202 is further configured to: responding to the existence of the target information in a part or all of the service tables corresponding to the basic table, acquiring the service table with the target information, prompting the service table with the target information based on a preset prompting rule, and not carrying out the corresponding operation on the target information in the basic table so as to keep the consistency of the data in the basic table and the service table.
According to several embodiments of the present invention, the apparatus for maintaining data consistency further comprises means for performing the steps of: and configuring a basic table corresponding to the basic information of the materials based on the materials dictionary, the supplier dictionary, the warehouse dictionary, the goods position dictionary and the salesman dictionary, wherein the basic information comprises material numbers, material names and material models.
According to several embodiments of the present invention, the apparatus for maintaining data consistency further comprises means for performing the steps of: and configuring a service table based on the service requirement of the user on the material, wherein the service table comprises a warehouse entry list, a warehouse exit list, a bill of lading and a contract.
According to several embodiments of the present invention, the first module 201 is further configured to: searching all basic tables corresponding to the basic information of the materials in the management software based on the physical numbers of the materials to obtain a target basic table;
Searching all service tables corresponding to material service requirements in the management software based on the physical numbers of the materials to obtain a plurality of service tables;
and establishing an association relation between the target basic table and the service tables.
According to several embodiments of the present invention, the corresponding operations include a modify operation and a delete operation.
The invention relates to a device for keeping data consistency, which establishes an association relation between a basic table corresponding to basic information of materials and a business table corresponding to business requirements of the materials according to the numbers of the materials, if the corresponding operation is carried out on target information in the basic table, all business tables corresponding to the basic table are called according to the association relation, whether the target information exists in the business tables is checked, and whether the corresponding operation is carried out on the target information in the basic table is confirmed according to the checking result, so that the data consistency of the basic table and the business table is kept. The problem that the data of the basic table is inconsistent with the data of the service table due to modification of the basic table can be effectively avoided, data errors of a summary report form which is exported later on of the service table are avoided, stability of management software is improved, and normal and stable operation of the management software is guaranteed.
It should be noted that, for specific limitation of the apparatus for maintaining data consistency, reference may be made to the limitation of the method for maintaining data consistency hereinabove, and no further description is given here. The various modules in the apparatus for maintaining data consistency described above may be implemented in whole or in part by software, hardware, or a combination thereof. The above modules may be embedded in hardware or independent of a processor in the electronic device, or may be stored in software in a memory in the electronic device, so that the processor may call and execute operations corresponding to the above modules.
According to another aspect of the present invention, there is provided an electronic device, which may be a server, and an internal structure thereof is shown in fig. 4. The electronic device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the electronic device is configured to provide computing and control capabilities. The memory of the electronic device includes a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the electronic device is for storing data. The network interface of the electronic device is used for communicating with an external terminal through a network connection. The computer program, when executed by a processor, implements the method for maintaining data consistency described above, where the method for maintaining data consistency includes:
establishing an association relationship between a basic table corresponding to the material basic information and a business table corresponding to the material business requirement based on the material number of the material;
And responding to a request for carrying out corresponding operation on the target information in the basic table, calling all service tables corresponding to the basic table based on the association relation, checking whether the target information exists in the service tables, and confirming whether the corresponding operation is carried out on the target information in the basic table according to a checking result so as to keep the consistency of the data in the basic table and the service tables.
In some embodiments, the step of confirming whether to perform the corresponding operation on the target information in the base table according to a result of the checking includes:
And responding to the fact that the target information does not exist in all service tables corresponding to the basic table, and carrying out corresponding operation on the target information in the basic table.
In some embodiments, the step of confirming whether to perform the corresponding operation on the target information in the base table according to the checking result to maintain consistency of data in the base table and the service table includes:
Responding to the existence of the target information in a part or all of the service tables corresponding to the basic table, acquiring the service table with the target information, prompting the service table with the target information based on a preset prompting rule, and not carrying out the corresponding operation on the target information in the basic table so as to keep the consistency of the data in the basic table and the service table.
In some embodiments, the method of maintaining data consistency further comprises:
And configuring a basic table corresponding to the basic information of the materials based on the materials dictionary, the supplier dictionary, the warehouse dictionary, the goods position dictionary and the salesman dictionary, wherein the basic information comprises material numbers, material names and material models.
In some embodiments, the method of maintaining data consistency further comprises:
And configuring a service table based on the service requirement of the user on the material, wherein the service table comprises a warehouse entry list, a warehouse exit list, a bill of lading and a contract.
In some embodiments, the step of establishing an association between a base table corresponding to the material base information and a service table corresponding to the material service requirement based on the material number of the material includes:
Searching all basic tables corresponding to the basic information of the materials in the management software based on the physical numbers of the materials to obtain a target basic table;
Searching all service tables corresponding to material service requirements in the management software based on the physical numbers of the materials to obtain a plurality of service tables;
and establishing an association relation between the target basic table and the service tables.
In some embodiments, the corresponding operations include a modify operation and a delete operation.
According to yet another aspect of the present invention, a computer readable storage medium is provided, as shown in fig. 5, on which a computer program is stored, which when executed by a processor implements the above-described method of maintaining data consistency.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in embodiments provided herein may include non-volatile and/or volatile memory. The nonvolatile memory can include Read Only Memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (SYNCHLINK) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above examples illustrate only a few embodiments of the application, which are described in detail and are not to be construed as limiting the scope of the application. It should be noted that it will be apparent to those skilled in the art that several variations and modifications can be made without departing from the spirit of the application, which are all within the scope of the application. Accordingly, the scope of protection of the present application is to be determined by the appended claims.
Claims (10)
1. A method for maintaining data consistency, applied to management software, the method comprising:
establishing an association relationship between a basic table corresponding to the material basic information and a business table corresponding to the material business requirement based on the material number of the material;
And responding to a request for carrying out corresponding operation on the target information in the basic table, calling all service tables corresponding to the basic table based on the association relation, checking whether the target information exists in the service tables, and confirming whether the corresponding operation is carried out on the target information in the basic table according to a checking result so as to keep the consistency of the data in the basic table and the service tables.
2. The method of maintaining data consistency according to claim 1, wherein the step of confirming whether to perform the corresponding operation on the target information in the base table according to the check result includes:
And responding to the fact that the target information does not exist in all service tables corresponding to the basic table, and carrying out corresponding operation on the target information in the basic table.
3. The method for maintaining data consistency according to claim 2, wherein the step of confirming whether the corresponding operation is performed on the target information in the base table according to the checking result to maintain data consistency in the base table and the service table comprises:
Responding to the existence of the target information in a part or all of the service tables corresponding to the basic table, acquiring the service table with the target information, prompting the service table with the target information based on a preset prompting rule, and not carrying out the corresponding operation on the target information in the basic table so as to keep the consistency of the data in the basic table and the service table.
4. The method of maintaining data consistency of claim 1, wherein the method of maintaining data consistency further comprises:
And configuring a basic table corresponding to the basic information of the materials based on the materials dictionary, the supplier dictionary, the warehouse dictionary, the goods position dictionary and the salesman dictionary, wherein the basic information comprises material numbers, material names and material models.
5. The method of maintaining data consistency of claim 4, wherein the method of maintaining data consistency further comprises:
And configuring a service table based on the service requirement of the user on the material, wherein the service table comprises a warehouse entry list, a warehouse exit list, a bill of lading and a contract.
6. The method for maintaining data consistency according to claim 1, wherein the step of establishing an association relationship between a base table corresponding to basic information of materials and a service table corresponding to service requirements of materials based on the material numbers of the materials comprises:
Searching all basic tables corresponding to the basic information of the materials in the management software based on the physical numbers of the materials to obtain a target basic table;
Searching all service tables corresponding to material service requirements in the management software based on the physical numbers of the materials to obtain a plurality of service tables;
and establishing an association relation between the target basic table and the service tables.
7. The method of maintaining data consistency of claim 1, wherein the corresponding operations include a modify operation and a delete operation.
8. An apparatus for maintaining data consistency, for use with management software, the apparatus comprising:
The first module is used for establishing an association relationship between a basic table corresponding to the basic information of the materials and a business table corresponding to the business requirements of the materials based on the material numbers of the materials;
and the second module is used for responding to the request of carrying out corresponding operation on the target information in the basic table, calling all service tables corresponding to the basic table based on the association relation, checking whether the target information exists in the service tables, and confirming whether the corresponding operation is carried out on the target information in the basic table according to the checking result so as to keep the consistency of the data in the basic table and the service tables.
9. An electronic device, comprising:
At least one processor; and
A memory storing a computer program executable in the processor, the processor executing the method of maintaining data consistency as claimed in any one of claims 1 to 7 when the program is executed.
10. A computer readable storage medium storing a computer program, characterized in that the computer program, when executed by a processor, performs the method of maintaining data consistency of any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410210781.0A CN117971850A (en) | 2024-02-26 | 2024-02-26 | Method, device, equipment and medium for maintaining data consistency |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410210781.0A CN117971850A (en) | 2024-02-26 | 2024-02-26 | Method, device, equipment and medium for maintaining data consistency |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117971850A true CN117971850A (en) | 2024-05-03 |
Family
ID=90864411
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202410210781.0A Pending CN117971850A (en) | 2024-02-26 | 2024-02-26 | Method, device, equipment and medium for maintaining data consistency |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117971850A (en) |
-
2024
- 2024-02-26 CN CN202410210781.0A patent/CN117971850A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108573371B (en) | Data approval method, device, computer equipment and storage medium | |
| CN110069449B (en) | File processing method, device, computer equipment and storage medium | |
| CN109474578B (en) | Message checking method, device, computer equipment and storage medium | |
| CN109446068B (en) | Interface test method, device, computer equipment and storage medium | |
| CN108829781B (en) | Client information query method, device, computer equipment and storage medium | |
| CN111027295B (en) | Data processing method, device, computer equipment and storage medium | |
| CN110633160A (en) | Interface calling method and device, computer equipment and storage medium | |
| WO2020155771A1 (en) | Spreadsheet data processing method and apparatus, computer device, and storage medium | |
| CN110908778B (en) | Task deployment method, system and storage medium | |
| WO2020199594A1 (en) | Service component loading method and apparatus, and computer device and storage medium | |
| CN109144487B (en) | Method, device, computer equipment and storage medium for developing business of parts | |
| CN109033139B (en) | Client information query method, device, computer equipment and storage medium | |
| CN109460252B (en) | Configuration file processing method and device based on git and computer equipment | |
| CN108512948B (en) | Address book updating method and device, computer equipment and storage medium | |
| CN111190742B (en) | Resource coordination method, device, computer equipment and storage medium | |
| CN113608913A (en) | Parameter checking method, system, device and storage medium | |
| CN111209061A (en) | Method and device for filling in user information, computer equipment and storage medium | |
| CN111522881B (en) | Service data processing method, device, server and storage medium | |
| CN110263305B (en) | Configuration file comparison method, device, equipment and storage medium | |
| CN110543465B (en) | Directory operation method and device, computer equipment and storage medium | |
| CN117971850A (en) | Method, device, equipment and medium for maintaining data consistency | |
| CN112465612B (en) | Document information processing method, device, computer equipment and storage medium | |
| CN113259154B (en) | Method and device for informing middle station data verification, computer equipment and storage medium | |
| CN112783866B (en) | Data reading method, device, computer equipment and storage medium | |
| CN112148597B (en) | Method for eliminating iOS device authorization dialog box, test method and storage medium |
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 |