CN116881258A - Business data storage method, equipment and medium based on ERP system - Google Patents
Business data storage method, equipment and medium based on ERP system Download PDFInfo
- Publication number
- CN116881258A CN116881258A CN202310904515.3A CN202310904515A CN116881258A CN 116881258 A CN116881258 A CN 116881258A CN 202310904515 A CN202310904515 A CN 202310904515A CN 116881258 A CN116881258 A CN 116881258A
- Authority
- CN
- China
- Prior art keywords
- bill
- information
- business
- data
- state
- 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 78
- 238000013500 data storage Methods 0.000 title claims abstract description 66
- 238000013507 mapping Methods 0.000 claims abstract description 46
- 230000008569 process Effects 0.000 claims description 29
- 230000008859 change Effects 0.000 claims description 15
- 238000012216 screening Methods 0.000 claims description 7
- 206010048669 Terminal state Diseases 0.000 claims description 3
- 238000010586 diagram Methods 0.000 description 9
- 238000004590 computer program Methods 0.000 description 7
- 238000005516 engineering process Methods 0.000 description 7
- 238000007726 management method Methods 0.000 description 6
- 238000012545 processing Methods 0.000 description 6
- 238000012550 audit Methods 0.000 description 5
- 230000009286 beneficial effect Effects 0.000 description 4
- 230000006870 function Effects 0.000 description 4
- 238000013439 planning Methods 0.000 description 4
- 230000000694 effects Effects 0.000 description 3
- 230000000977 initiatory effect Effects 0.000 description 3
- 230000001360 synchronised effect Effects 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000008520 organization Effects 0.000 description 2
- 230000009897 systematic effect Effects 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 238000007730 finishing process Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 239000003999 initiator Substances 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 238000012552 review 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- 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
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Computing Systems (AREA)
- Software Systems (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the specification discloses a business data storage method, equipment and medium based on an ERP system, and relates to the technical field of ERP, wherein the method comprises the following steps: acquiring a to-be-processed business bill in an ERP system, and determining a plurality of corresponding bill information based on the to-be-processed business bill; determining a plurality of circulation nodes corresponding to the business document to be processed, and filling document information in the business document to be processed through the circulation nodes to generate initial document information; acquiring a pre-constructed data storage mapping relation, wherein a storage database comprises a cache database and a relation database; based on the data storage mapping relation, storing each bill information in the initial bill information into a corresponding storage database respectively; determining bill information to be updated in the initial bill information, and carrying out state update on the bill information to be updated in a cache database corresponding to the bill information to be updated so as to generate business bill data, so that the business data is stored, and the bill information to be updated comprises bill state information.
Description
Technical Field
The present disclosure relates to the field of ERP technologies, and in particular, to a method, an apparatus, and a medium for storing business data based on an ERP system.
Background
An enterprise resource planning (Enterprise Resource Planning, ERP) system is a management platform which is based on information technology, integrates information technology and advanced management ideas, and provides decision means for enterprise staff and decision layers by using systematic management ideas. In the implementation process of the economic service, the business bill is input into the system, and data circulation is carried out after the input into the system. In the process of data circulation, the changed data information is often only a few, and most of service information is not allowed to be modified in the process of circulation. For example, the business users fill out the business trip reimbursement bill, the business trip users submit after filling out, the information of the amount, reimbursement person, journey and the like of the original bill is not changed, and the approval state, payment state and the like of the bill are changed in the process.
In a conventional ERP system, a database is generally used for storage, a relational database is used for storage in a data storage manner, or a cache database is used for storage, and a table with small data size is placed in the cache database for storage, so that service data is not placed in the cache database but is placed in the relational database for storage because of large service data size. In addition, aiming at the circulation characteristics of service data, the update operation of the data in the relational database belongs to IO operation, the update speed is slower than that of the memory operation of the cache data, and archive log files are easily generated due to data changes such as bill approval in the circulation process of the service data, so that the files in the relational database are increased, and the system performance is influenced. Therefore, the traditional ERP system storage mode stores service data in a relational database, and economic service data is easy to generate archive log files due to data changes such as data circulation, auditing and the like, so that files in the relational database are increased, and the system performance is influenced.
Disclosure of Invention
One or more embodiments of the present disclosure provide a method, an apparatus, and a medium for storing business data based on an ERP system, which are used to solve the following technical problems: the traditional ERP system storage mode stores service data in a relational database, and economic service data is easy to generate archive log files due to the fact that data circulation, auditing and other operations are required to be carried out, so that files in the relational database are increased, and system performance is affected.
One or more embodiments of the present disclosure adopt the following technical solutions:
one or more embodiments of the present disclosure provide a business data storage method based on an ERP system, which is characterized in that the method includes: acquiring a to-be-processed business bill in an ERP system, and determining a plurality of corresponding bill information based on the to-be-processed business bill; determining a plurality of circulation nodes corresponding to the business document to be processed, and filling document information in the business document to be processed through the circulation nodes to generate initial document information, wherein the circulation nodes comprise business document filling nodes and at least one business document updating node; acquiring a pre-constructed data storage mapping relation, wherein the data storage mapping relation comprises a plurality of bill information and a storage database corresponding to each bill information, and the storage database comprises a cache database and a relational database; based on the data storage mapping relation, storing each bill information in the initial bill information into a corresponding storage database respectively; and determining bill information to be updated in the initial bill information, and carrying out state update on the bill information to be updated in a cache database corresponding to the bill information to be updated through each business bill updating node so as to generate business bill data and realize storage of the business data, wherein the bill information to be updated comprises bill state information.
Further, before obtaining the pre-constructed data storage mapping relationship, the method further includes: determining information attribute of each bill information, wherein the information attribute comprises at least one business bill updating node corresponding to the bill information, the number of times to be updated corresponding to the bill information and the data volume of each bill information; and determining a storage database of each bill information based on the information attribute of each bill information to establish a data storage mapping relation between the bill information and the storage database, wherein the storage database comprises any one of a cache database and a relation database.
Further, based on the information attribute of each bill information, determining a storage database of each bill information specifically includes: determining the data quantity in the information attribute of each bill information; screening a plurality of bill information according to the data quantity of each bill information and a preset data quantity threshold value to obtain first type bill information, wherein the data quantity of each first bill information in the first type bill information is not larger than the preset data quantity threshold value; in the first type of bill information, according to at least one service bill updating node corresponding to each first bill information, or according to the number of times to be updated corresponding to each first bill information, bill information screening is carried out to obtain first specified bill information, wherein in the first type of bill information, the number of service bill updating nodes corresponding to the first specified bill information is the largest or the number of times to be updated corresponding to the first specified bill information is the largest; and establishing a first corresponding relation between the first appointed bill information and a cache database, and establishing a second corresponding relation between other bill information except the first appointed bill information and a relation database.
Further, based on the data storage mapping relationship, storing each document information in the initial document information into a corresponding storage database, specifically including: determining a first corresponding relation between first appointed bill information in the initial bill information and the cache database and a second corresponding relation between other bill information in the initial bill information and the relation database according to the data storage mapping relation; storing first appointed bill information in the initial bill information into the cache database according to the first corresponding relation, and storing other bill information into the relation database according to the second corresponding relation.
Further, through each service bill updating node, in a cache database corresponding to the bill information to be updated, performing state updating on the bill information to be updated to generate service bill data, which specifically includes: determining the update sequence of the business bill update nodes to the bill information to be updated and a cache database corresponding to the bill information to be updated;
according to the updating sequence, sequentially carrying out state updating on the bill information to be updated in the cache database through each business bill updating node to generate updated bill data; determining a current bill state in the updated bill data, and judging whether the current bill state is an end state in the bill state evolution information according to the current bill state and the bill state evolution information acquired in advance; when the current bill state is the end state in the bill state evolution information, synchronizing the current bill state from the cache database to the relational database; and generating the business bill data based on the current bill state corresponding to the updated bill data and other bill data except the updated bill data in the initial bill information.
Further, before judging whether the current bill state is the end state in the bill state evolution information according to the current bill state and the pre-acquired bill state evolution information, the method further comprises: acquiring the state change of the business document to be processed in the circulation process; setting bill state evolution information corresponding to the business bill to be processed based on state change of the business bill to be processed in the circulation process, wherein the bill state evolution information comprises a plurality of bill states arranged in a specified sequence and sequence identifiers of each bill state in the bill state evolution information.
Further, after generating the business document data, the method further includes: when a user needs to inquire the current bill state of the business bill data, determining the bill identification of the business bill data; based on the bill identification, searching the bill state in the cache database, and judging whether the current bill state corresponding to the bill identification exists in the cache database; and if the current bill state corresponding to the bill identifier does not exist in the cache database, taking the terminal state corresponding to the business bill data in the relation data as the current bill state of the business bill data based on the bill identifier.
Further, after generating the business document data, the method further includes: and after the business bill data is filled, removing the updated bill data in the cache database.
One or more embodiments of the present specification provide a business data storage device based on an ERP system, including:
at least one processor; the method comprises the steps of,
a memory communicatively coupled to the at least one processor; wherein,,
the memory stores instructions executable by the at least one processor to enable the at least one processor to:
acquiring a to-be-processed business bill in an ERP system, and determining a plurality of corresponding bill information based on the to-be-processed business bill; determining a plurality of circulation nodes corresponding to the business document to be processed, and filling document information in the business document to be processed through the circulation nodes to generate initial document information, wherein the circulation nodes comprise business document filling nodes and at least one business document updating node; acquiring a pre-constructed data storage mapping relation, wherein the data storage mapping relation comprises a plurality of bill information and a storage database corresponding to each bill information, and the storage database comprises a cache database and a relational database; based on the data storage mapping relation, storing each bill information in the initial bill information into a corresponding storage database respectively; and determining bill information to be updated in the initial bill information, and carrying out state update on the bill information to be updated in a cache database corresponding to the bill information to be updated through each business bill updating node so as to generate business bill data and realize storage of the business data, wherein the bill information to be updated comprises bill state information.
One or more embodiments of the present specification provide a non-volatile computer storage medium storing computer-executable instructions configured to:
acquiring a to-be-processed business bill in an ERP system, and determining a plurality of corresponding bill information based on the to-be-processed business bill; determining a plurality of circulation nodes corresponding to the business document to be processed, and filling document information in the business document to be processed through the circulation nodes to generate initial document information, wherein the circulation nodes comprise business document filling nodes and at least one business document updating node; acquiring a pre-constructed data storage mapping relation, wherein the data storage mapping relation comprises a plurality of bill information and a storage database corresponding to each bill information, and the storage database comprises a cache database and a relational database; based on the data storage mapping relation, storing each bill information in the initial bill information into a corresponding storage database respectively; and determining bill information to be updated in the initial bill information, and carrying out state update on the bill information to be updated in a cache database corresponding to the bill information to be updated through each business bill updating node so as to generate business bill data and realize storage of the business data, wherein the bill information to be updated comprises bill state information.
The above-mentioned at least one technical scheme that this description embodiment adopted can reach following beneficial effect: according to the technical scheme, the bill information in the business bill data to be processed is filled through the circulation node, initial bill information is generated, each bill information is stored into the relational database or the cache database according to the storage database corresponding to each bill information in the initial bill information, state data with large change and small data quantity in the business data are placed into the cache database, after the data are changed to a final state, the data are synchronized into the relational database from the cache database, and only the bill state information in the cache database is updated. The operation of updating the cache database is a memory operation, and compared with the update of the data file corresponding to the IO operation in the relational database, the update speed is high, in addition, the archiving log generated by the data change is not generated in the relational database, the data file in the relational database cannot be increased by bill approval, the pressure of the relational database can be reduced because the archiving log and other database operations are not generated, and the overall performance of the system is improved.
Drawings
In order to more clearly illustrate the embodiments of the present description or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described below, it being obvious that the drawings in the following description are only some of the embodiments described in the present description, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art. In the drawings:
fig. 1 is a schematic flow chart of a business data storage method based on an ERP system according to an embodiment of the present disclosure;
fig. 2 is an application schematic diagram of a business data storage method based on an ERP system according to an embodiment of the present disclosure;
fig. 3 is a schematic structural diagram of a business data storage device based on an ERP system according to an embodiment of the present disclosure.
Detailed Description
In order to make the technical solutions in the present specification better understood by those skilled in the art, the technical solutions in the embodiments of the present specification will be clearly and completely described below with reference to the drawings in the embodiments of the present specification, and it is obvious that the described embodiments are only some embodiments of the present specification, not all embodiments. All other embodiments, which can be made by one of ordinary skill in the art based on the embodiments herein without making any inventive effort, shall fall within the scope of the present disclosure.
An enterprise resource planning (Enterprise Resource Planning, ERP) system is a management platform which is based on information technology, integrates information technology and advanced management ideas, and provides decision means for enterprise staff and decision layers by using systematic management ideas. In the implementation process of the economic service, the business bill is input into the system, and data circulation is carried out after the input into the system. In the process of data circulation, the changed data information is often only a few, and most of service information is not allowed to be modified in the process of circulation. For example, the business users fill out the business trip reimbursement bill, the business trip users submit after filling out, the information of the amount, reimbursement person, journey and the like of the original bill is not changed, and the approval state, payment state and the like of the bill are changed in the process.
In a conventional ERP system, a database is generally used for storage, a relational database is used for storage in a data storage manner, or a cache database is used for storage, and a table with small data size is placed in the cache database for storage, so that service data is not placed in the cache database but is placed in the relational database for storage because of large service data size. In addition, aiming at the circulation characteristics of service data, the update operation of the data in the relational database belongs to IO operation, the update speed is slower than that of the memory operation of the cache data, and archive log files are easily generated due to data changes such as bill approval in the circulation process of the service data, so that the files in the relational database are increased, and the system performance is influenced. Therefore, the traditional ERP system storage mode stores service data in a relational database, and economic service data is easy to generate archive log files due to data changes such as data circulation, auditing and the like, so that files in the relational database are increased, and the system performance is influenced.
The embodiment of the present disclosure provides a business data storage method based on an ERP system, and it should be noted that, an execution subject in the embodiment of the present disclosure may be a server, or may be any device having a data processing capability. Fig. 1 is a flow chart of a business data storage method based on an ERP system according to an embodiment of the present disclosure, as shown in fig. 1, mainly including the following steps:
step S101, obtaining a to-be-processed business document in the ERP system, and determining a plurality of corresponding document information based on the to-be-processed business document.
In one embodiment of the present disclosure, a business document to be processed in an ERP system is obtained, and a plurality of corresponding document information is determined based on the business document to be processed. The business documents to be processed can be economic business documents such as reimbursement documents, purchase approval documents and the like, and the economic business documents refer to business documents related to economic transactions in business data, for example, a document payment process exists in reimbursement documents.
Step S102, determining a plurality of circulation nodes corresponding to the business document to be processed, and filling document information in the business document to be processed through the circulation nodes to generate initial document information.
The circulation node comprises a service bill filling node and at least one service bill updating node;
in one embodiment of the present disclosure, a plurality of circulation nodes corresponding to a service document to be processed are determined, where the circulation nodes include a service document filling node and at least one service document updating node, the service document updating node may also be referred to as an auditing node, a payment node, etc., the service document filling node may be considered as an initiator of the service document, and performs initial information filling on the service document, and at least one service document updating node performs updating of document information such as auditing, approval, payment, etc. of the service document. And filling bill information in the business bill to be processed through a business bill filling node in the circulation node to generate initial bill information. Fig. 2 is an application schematic diagram of a business data storage method based on an ERP system according to an embodiment of the present disclosure, as shown in fig. 2, a user logs in to the ERP system, adds a reimbursement bill, submits after filling, where the user fills in the reimbursement bill for a business bill in a circulation node. The initial bill information includes a plurality of bill information, for example, a reimbursement user, reimbursement unit, reimbursement amount, accounting organization, bill state, and the like, which are all bill information.
Step S103, a pre-constructed data storage mapping relation is obtained.
The data storage mapping relation comprises a plurality of bill information and a storage database corresponding to each bill information, wherein the storage database comprises a cache database and a relation database.
Before the pre-constructed data storage mapping relation is obtained, the method further comprises the following steps: determining information attribute of each bill information, wherein the information attribute comprises at least one business bill updating node corresponding to the bill information, the number of times to be updated corresponding to the bill information and the data volume of each bill information; and determining a storage database of each bill information based on the information attribute of each bill information to establish a data storage mapping relation between the bill information and the storage database, wherein the storage database comprises any one of a cache database and a relation database.
In one embodiment of the present specification, before step S103, a data storage mapping relationship needs to be constructed according to a plurality of document information in the initial document information. Firstly, determining information attribute of each bill information, wherein the information attribute comprises at least one business bill updating node corresponding to the bill information, the number of times to be updated corresponding to the bill information and the data volume of each bill information, the at least one business bill updating node corresponding to the bill information refers to a node with updating authority for the bill information, for example, the business bill updating node corresponding to the bill information in the bill state is a node with approval authority, a node with payment authority and the like, and for the bill information of the account amount, the business bill updating node is a business bill filling node, and the user node corresponding to the account initiating user fills in the bill information. Similarly, the number of times to be updated corresponding to the bill information refers to the number of times that the bill information needs to be updated in the data circulation process, for example, the number of times to be updated corresponding to a reimbursement user, a reimbursement unit, a reimbursement amount, an accounting organization and the like is 1, that is, only when the bill is initially filled, the user node corresponding to the reimbursement initiating user performs single filling on the bill information. And secondly, determining a storage database of each bill information according to the information attribute of each bill information so as to establish a data storage mapping relation between the bill information and the storage database, wherein the storage database comprises any item in a cache database and a relation database.
Based on the information attribute of each bill information, determining a storage database of each bill information specifically comprises: determining the data quantity in the information attribute of each bill information; screening a plurality of bill information according to the data quantity of each bill information and a preset data quantity threshold value to obtain first type bill information, wherein the data quantity of each first bill information in the first type bill information is not larger than the preset data quantity threshold value; in the first type of bill information, according to at least one service bill updating node corresponding to each piece of first bill information, or according to the number of times to be updated corresponding to each piece of first bill information, bill information screening is carried out to obtain first specified bill information, wherein in the first type of bill information, the number of service bill updating nodes corresponding to the first specified bill information is the largest or the number of times to be updated corresponding to the first specified bill information is the largest; and establishing a first corresponding relation between the first appointed bill information and the cache database, and establishing a second corresponding relation between other bill information except the first appointed bill information and the relation database.
In one embodiment of the present disclosure, determining a data amount in an information attribute of each document information, and screening among a plurality of document information according to the data amount of each document information to obtain first-type document information with data amounts not greater than a preset data amount threshold. And in the first type of bill information, according to at least one service bill updating node corresponding to each first bill information, or according to the number of times to be updated corresponding to each first bill information, filtering the bill information to obtain first specified bill information, wherein the number of service bill updating nodes corresponding to the first specified bill information in the first type of bill information is the largest or the number of times to be updated corresponding to the first specified bill information is the largest. And establishing a first corresponding relation between the first appointed bill information and the cache database, and establishing a second corresponding relation between other bill information except the first appointed bill information and the relation database.
In one embodiment of the present description, a data storage mapping is obtained.
Step S104, based on the data storage mapping relation, each piece of document information in the initial document information is respectively stored into a corresponding storage database.
Based on the data storage mapping relation, storing each bill information in the initial bill information into a corresponding storage database respectively, wherein the method specifically comprises the following steps: determining a first corresponding relation between first appointed bill information in the initial bill information and the cache database and a second corresponding relation between other bill information in the initial bill information and the relation database according to the data storage mapping relation; storing first appointed bill information in the initial bill information into the cache database according to the first corresponding relation, and storing other bill information into the relation database according to the second corresponding relation.
In one embodiment of the present disclosure, a first correspondence between first specified document information in initial document information and a cache database is determined according to a data storage mapping relationship, and the first specified document information in the initial document information is stored in the cache database according to the first correspondence. And determining a second corresponding relation between other bill information in the initial bill information and the relation database according to the data storage mapping relation, and storing the other bill information into the relation database according to the second corresponding relation. Taking the reimbursement document in fig. 2 as an example, document information such as document number, date filled, account person, account unit, reimbursement description, account amount, account currency, etc. is stored in a BXDJ table in a relational database, and document state information such as document number, document state, etc. is stored in a cache database, for example, a remote dictionary service (Remote Dictionary Server, redis) database.
Step S105, determining bill information to be updated in the initial bill information, and carrying out state update on the bill information to be updated in a cache database corresponding to the bill information to be updated through each business bill updating node so as to generate business bill data and realize storage of the business data.
Through each business document updating node, in a cache database corresponding to the document information to be updated, carrying out state updating on the document information to be updated to generate business document data, which specifically comprises the following steps: determining the update sequence of the business bill update nodes to the bill information to be updated and a cache database corresponding to the bill information to be updated; according to the updating sequence, sequentially carrying out state updating on the bill information to be updated in the cache database through each business bill updating node to generate updated bill data; determining a current bill state in the updated bill data, and judging whether the current bill state is an end state in the bill state evolution information according to the current bill state and the pre-acquired bill state evolution information; when the current bill state is the end state in the bill state evolution information, synchronizing the current bill state from the cache database to the relational database; and generating the business bill data based on the current bill state corresponding to the updated bill data and other bill data except the updated bill data in the initial bill information.
In an embodiment of the present disclosure, determining an update sequence of document information to be updated and a specified storage database corresponding to the document information to be updated by a plurality of service document update nodes, where the update sequence may be according to preset audit logic, for example, the audit logic is that first an a department performs initial audit, then a B department performs review, and then a C department performs payment, and then the corresponding update sequence is a service document update node corresponding to the a department, a service document update node corresponding to the B department, and a service document update node corresponding to the C department, where audit, payment, and so on need to be sequentially performed according to the audit logic.
When the designated storage database corresponding to the bill information to be updated is a cache database, according to the update sequence, through each business bill update node, sequentially performing state update on the bill information to be updated in the cache database, generating updated bill data, and determining the current bill state in the updated bill data, wherein the current bill state can be the latest state obtained after the corresponding operations such as auditing and payment are completed by the business data update node, and performing state update on the corresponding bill information. As shown in fig. 2, when the user node corresponding to the account opening initiating user fills in the bill information, the information content corresponding to the bill state is the bill making state, that is, the current bill state is the bill making state. And judging whether the current bill state is an end state in the bill state evolution information according to the current bill state and the bill state evolution information acquired in advance. If the current bill state is the end state in the bill state evolution information, synchronizing the current bill state from the cache database to the relational database; and generating business bill data based on the current bill state corresponding to the updated bill data and other bill data except the updated bill data in the initial bill information.
Taking bill approval, bill payment and bill completion as examples, explanation will be made. When the corresponding business data updating node is used for bill approval, only the bill state in the Redis database needs to be updated; when the bill is paid, only the bill state in the Redis database is updated to be the payment completion, and the operation of updating the Redis is memory operation and is faster than the update speed of IO operation data files in the relational database, and the archival log generated by data change is not generated in the relational database, so that the data files in the relational database can not be increased due to bill approval. Because archive logs and other database operations are not generated, the pressure of the relational database can be reduced, and the overall performance of the system is improved. After the bill is completed, the Redis database judges the bill state as the completion state, synchronizes the bill state to the relational database, and realizes data archiving. At this time, although there is database synchronization operation, the frequency of synchronization is greatly reduced, and the document state is synchronized only once from the new increase to the completion of the document.
According to the current bill state and the pre-acquired bill state evolution information, judging whether the current bill state is before the end state in the bill state evolution information, wherein the method further comprises the following steps: acquiring the state change of the business document to be processed in the circulation process; and setting bill state evolution information corresponding to the business bill to be processed based on the state change of the business bill to be processed in the circulation process, wherein the bill state evolution information comprises a plurality of bill states arranged in a specified sequence and sequence identifiers of each bill state in the bill state evolution information.
In one embodiment of the present disclosure, a state change of a business document to be processed in a circulation process is obtained, for example, the state change corresponding to four processes including a document making process, a document auditing process, a document payment completion process and a document finishing process. Setting bill state evolution information corresponding to the business bill to be processed based on state change of the business bill to be processed in the circulation process, taking a bill making state, an auditing state, a payment completion state and a bill completion state as the bill state evolution information, and sequentially arranging according to the sequence, wherein the bill state evolution information comprises a plurality of bill states which are sequentially arranged and sequential identifiers of each bill state in the bill state evolution information, and the bill states need to be sequentially changed.
After generating the business document data, the method further comprises: and after the business bill data is filled, removing the updated bill data in the cache database.
In one embodiment of the present disclosure, after the document is completed, the data in the dis data is shifted out, so that space is made for the subsequent service information.
After generating the business document data, the method further comprises: when a user needs to inquire the current bill state of the business bill data, determining the bill identification of the business bill data; based on the bill identification, searching the bill state in the cache database, and judging whether the current bill state corresponding to the bill identification exists in the cache database; and if the current bill state corresponding to the bill identifier does not exist in the cache database, taking the terminal state corresponding to the business bill data in the relation data as the current bill state of the business bill data based on the bill identifier.
According to the technical scheme, the bill information in the business bill data to be processed is filled through the circulation node, initial bill information is generated, each bill information is stored into the relational database or the cache database according to the storage database corresponding to each bill information in the initial bill information, state data with large change and small data quantity in the business data are placed into the cache database, after the data are changed to a final state, the data are synchronized into the relational database from the cache database, and only the bill state information in the cache database is updated. The operation of updating the cache database is a memory operation, and compared with the update of the data file corresponding to the IO operation in the relational database, the update speed is high, in addition, the archiving log generated by the data change is not generated in the relational database, the data file in the relational database cannot be increased by bill approval, the pressure of the relational database can be reduced because the archiving log and other database operations are not generated, and the overall performance of the system is improved.
The embodiment of the present disclosure further provides a service data storage device based on an ERP system, as shown in fig. 3, where the device includes: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor, the instructions being executable by the at least one processor to enable the at least one processor to:
acquiring a to-be-processed business bill in an ERP system, and determining a plurality of corresponding bill information based on the to-be-processed business bill; determining a plurality of circulation nodes corresponding to the business document to be processed, and filling document information in the business document to be processed through the circulation nodes to generate initial document information, wherein the circulation nodes comprise business document filling nodes and at least one business document updating node; acquiring a pre-constructed data storage mapping relation, wherein the data storage mapping relation comprises a plurality of bill information and a storage database corresponding to each bill information, and the storage database comprises a cache database and a relation database; based on the data storage mapping relation, storing each bill information in the initial bill information into a corresponding storage database respectively; and determining bill information to be updated in the initial bill information, and carrying out state update on the bill information to be updated in a cache database corresponding to the bill information to be updated through each business bill updating node so as to generate business bill data and realize storage of the business data, wherein the bill information to be updated comprises bill state information.
The present specification embodiments also provide a non-volatile computer storage medium storing computer-executable instructions configured to:
acquiring a to-be-processed business bill in an ERP system, and determining a plurality of corresponding bill information based on the to-be-processed business bill; determining a plurality of circulation nodes corresponding to the business document to be processed, and filling document information in the business document to be processed through the circulation nodes to generate initial document information, wherein the circulation nodes comprise business document filling nodes and at least one business document updating node; acquiring a pre-constructed data storage mapping relation, wherein the data storage mapping relation comprises a plurality of bill information and a storage database corresponding to each bill information, and the storage database comprises a cache database and a relation database; based on the data storage mapping relation, storing each bill information in the initial bill information into a corresponding storage database respectively; and determining bill information to be updated in the initial bill information, and carrying out state update on the bill information to be updated in a cache database corresponding to the bill information to be updated through each business bill updating node so as to generate business bill data and realize storage of the business data, wherein the bill information to be updated comprises bill state information.
In this specification, each embodiment is described in a progressive manner, and identical and similar parts of each embodiment are all referred to each other, and each embodiment mainly describes differences from other embodiments. In particular, for apparatus, devices, non-volatile computer storage medium embodiments, the description is relatively simple, as it is substantially similar to method embodiments, with reference to the section of the method embodiments being relevant.
The foregoing describes specific embodiments of the present disclosure. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims can be performed in a different order than in the embodiments and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.
The devices and media provided in the embodiments of the present disclosure are in one-to-one correspondence with the methods, so that the devices and media also have similar beneficial technical effects as the corresponding methods, and since the beneficial technical effects of the methods have been described in detail above, the beneficial technical effects of the devices and media are not repeated here.
It will be appreciated by those skilled in the art that embodiments of the present description may be provided as a method, system, or computer program product. Accordingly, the present specification may take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present description can take the form of a computer program product on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) having computer-usable program code embodied therein.
The present description is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the specification. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In one typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include volatile memory in a computer-readable medium, random Access Memory (RAM) and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of computer-readable media.
Computer readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of storage media for a computer include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device. Computer-readable media, as defined herein, does not include transitory computer-readable media (transmission media), such as modulated data signals and carrier waves.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article or apparatus that comprises the element.
The foregoing is merely one or more embodiments of the present description and is not intended to limit the present description. Various modifications and alterations to one or more embodiments of this description will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement, or the like, which is within the spirit and principles of one or more embodiments of the present description, is intended to be included within the scope of the claims of the present description.
Claims (10)
1. A business data storage method based on an ERP system, the method comprising:
acquiring a to-be-processed business bill in an ERP system, and determining a plurality of corresponding bill information based on the to-be-processed business bill;
determining a plurality of circulation nodes corresponding to the business document to be processed, and filling document information in the business document to be processed through the circulation nodes to generate initial document information, wherein the circulation nodes comprise business document filling nodes and at least one business document updating node;
acquiring a pre-constructed data storage mapping relation, wherein the data storage mapping relation comprises a plurality of bill information and a storage database corresponding to each bill information, and the storage database comprises a cache database and a relational database;
Based on the data storage mapping relation, storing each bill information in the initial bill information into a corresponding storage database respectively;
and determining bill information to be updated in the initial bill information, and carrying out state update on the bill information to be updated in a cache database corresponding to the bill information to be updated through each business bill updating node so as to generate business bill data and realize storage of the business data, wherein the bill information to be updated comprises bill state information.
2. The method for storing business data based on an ERP system according to claim 1, wherein before obtaining the pre-constructed data storage mapping relationship, the method further comprises:
determining information attribute of each bill information, wherein the information attribute comprises at least one business bill updating node corresponding to the bill information, the number of times to be updated corresponding to the bill information and the data volume of each bill information;
and determining a storage database of each bill information based on the information attribute of each bill information to establish a data storage mapping relation between the bill information and the storage database, wherein the storage database comprises any one of a cache database and a relation database.
3. The business data storage method based on the ERP system according to claim 2, wherein the determining the storage database of each document information based on the information attribute of each document information specifically comprises:
determining the data quantity in the information attribute of each bill information;
screening a plurality of bill information according to the data quantity of each bill information and a preset data quantity threshold value to obtain first type bill information, wherein the data quantity of each first bill information in the first type bill information is not larger than the preset data quantity threshold value;
in the first type of bill information, according to at least one service bill updating node corresponding to each first bill information, or according to the number of times to be updated corresponding to each first bill information, bill information screening is carried out to obtain first specified bill information, wherein in the first type of bill information, the number of service bill updating nodes corresponding to the first specified bill information is the largest or the number of times to be updated corresponding to the first specified bill information is the largest;
and establishing a first corresponding relation between the first appointed bill information and a cache database, and establishing a second corresponding relation between other bill information except the first appointed bill information and a relation database.
4. The business data storage method based on the ERP system of claim 3, wherein each document information in the initial document information is stored in a corresponding storage database based on the data storage mapping relationship, and the method specifically comprises the following steps:
determining a first corresponding relation between first appointed bill information in the initial bill information and the cache database and a second corresponding relation between other bill information in the initial bill information and the relation database according to the data storage mapping relation;
storing first appointed bill information in the initial bill information into the cache database according to the first corresponding relation, and storing other bill information into the relation database according to the second corresponding relation.
5. The method for storing business data based on an ERP system according to claim 1, wherein, by each business document updating node, in a cache database corresponding to the document information to be updated, the state of the document information to be updated is updated to generate business document data, which specifically includes:
Determining the update sequence of the business bill update nodes to the bill information to be updated and a cache database corresponding to the bill information to be updated;
according to the updating sequence, sequentially carrying out state updating on the bill information to be updated in the cache database through each business bill updating node to generate updated bill data;
determining a current bill state in the updated bill data, and judging whether the current bill state is an end state in the bill state evolution information according to the current bill state and the bill state evolution information acquired in advance;
when the current bill state is the end state in the bill state evolution information, synchronizing the current bill state from the cache database to the relational database;
and generating the business bill data based on the current bill state corresponding to the updated bill data and other bill data except the updated bill data in the initial bill information.
6. The method for storing business data based on an ERP system according to claim 5, wherein before determining whether the current document state is the end state in the document state evolution information according to the current document state and the pre-acquired document state evolution information, the method further comprises:
Acquiring the state change of the business document to be processed in the circulation process;
setting bill state evolution information corresponding to the business bill to be processed based on state change of the business bill to be processed in the circulation process, wherein the bill state evolution information comprises a plurality of bill states arranged in a specified sequence and sequence identifiers of each bill state in the bill state evolution information.
7. The ERP system-based business data storage method of claim 5, wherein after generating the business document data, the method further comprises:
when a user needs to inquire the current bill state of the business bill data, determining the bill identification of the business bill data;
based on the bill identification, searching the bill state in the cache database, and judging whether the current bill state corresponding to the bill identification exists in the cache database;
and if the current bill state corresponding to the bill identifier does not exist in the cache database, taking the terminal state corresponding to the business bill data in the relation data as the current bill state of the business bill data based on the bill identifier.
8. The ERP system-based business data storage method of claim 5, wherein after generating the business document data, the method further comprises:
and after the business bill data is filled, removing the updated bill data in the cache database.
9. A business data storage device based on an ERP system, the device comprising:
at least one processor; the method comprises the steps of,
a memory communicatively coupled to the at least one processor; wherein,,
the memory stores instructions executable by the at least one processor to enable the at least one processor to:
acquiring a to-be-processed business bill in an ERP system, and determining a plurality of corresponding bill information based on the to-be-processed business bill;
determining a plurality of circulation nodes corresponding to the business document to be processed, and filling document information in the business document to be processed through the circulation nodes to generate initial document information, wherein the circulation nodes comprise business document filling nodes and at least one business document updating node;
Acquiring a pre-constructed data storage mapping relation, wherein the data storage mapping relation comprises a plurality of bill information and a storage database corresponding to each bill information, and the storage database comprises a cache database and a relational database;
based on the data storage mapping relation, storing each bill information in the initial bill information into a corresponding storage database respectively;
and determining bill information to be updated in the initial bill information, and carrying out state update on the bill information to be updated in a cache database corresponding to the bill information to be updated through each business bill updating node so as to generate business bill data and realize storage of the business data, wherein the bill information to be updated comprises bill state information.
10. A non-transitory computer storage medium storing computer-executable instructions, the computer-executable instructions configured to:
acquiring a to-be-processed business bill in an ERP system, and determining a plurality of corresponding bill information based on the to-be-processed business bill;
determining a plurality of circulation nodes corresponding to the business document to be processed, and filling document information in the business document to be processed through the circulation nodes to generate initial document information, wherein the circulation nodes comprise business document filling nodes and at least one business document updating node;
Acquiring a pre-constructed data storage mapping relation, wherein the data storage mapping relation comprises a plurality of bill information and a storage database corresponding to each bill information, and the storage database comprises a cache database and a relational database;
based on the data storage mapping relation, storing each bill information in the initial bill information into a corresponding storage database respectively;
and determining bill information to be updated in the initial bill information, and carrying out state update on the bill information to be updated in a cache database corresponding to the bill information to be updated through each business bill updating node so as to generate business bill data and realize storage of the business data, wherein the bill information to be updated comprises bill state information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310904515.3A CN116881258A (en) | 2023-07-21 | 2023-07-21 | Business data storage method, equipment and medium based on ERP system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310904515.3A CN116881258A (en) | 2023-07-21 | 2023-07-21 | Business data storage method, equipment and medium based on ERP system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116881258A true CN116881258A (en) | 2023-10-13 |
Family
ID=88260246
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310904515.3A Pending CN116881258A (en) | 2023-07-21 | 2023-07-21 | Business data storage method, equipment and medium based on ERP system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116881258A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117669567A (en) * | 2024-01-31 | 2024-03-08 | 青岛冠成软件有限公司 | Document management method |
-
2023
- 2023-07-21 CN CN202310904515.3A patent/CN116881258A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117669567A (en) * | 2024-01-31 | 2024-03-08 | 青岛冠成软件有限公司 | Document management method |
| CN117669567B (en) * | 2024-01-31 | 2024-04-23 | 青岛冠成软件有限公司 | Document management method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20200356537A1 (en) | Resharding method and system for a distributed storage system | |
| CN109271450B (en) | Database synchronization method, device, server and storage medium | |
| CN107391628B (en) | Data synchronization method and device | |
| CN106649828B (en) | Data query method and system | |
| US20130047161A1 (en) | Selecting processing techniques for a data flow task | |
| CN112487083B (en) | Data verification method and device | |
| CN116881258A (en) | Business data storage method, equipment and medium based on ERP system | |
| CN114077602B (en) | Data migration method and device, electronic equipment and storage medium | |
| CN105608126A (en) | Method and apparatus for establishing secondary indexes for massive databases | |
| CN109033365B (en) | Data processing method and related equipment | |
| CN111680017A (en) | Data synchronization method and device | |
| CN107798120B (en) | Data conversion method and device | |
| CN111459913B (en) | Capacity expansion method and device of distributed database and electronic equipment | |
| CN116127932A (en) | Business report generation method, equipment and medium | |
| CN115455121A (en) | Real-time reliable data synchronous transmission method, equipment and medium | |
| CN111325494A (en) | Inventory management method, device, system and storage medium | |
| TWI754837B (en) | Method, apparatus, device and computer-readable medium for database migration | |
| US20090276603A1 (en) | Techniques for efficient dataloads into partitioned tables | |
| CN113190563B (en) | Index generation method, device and storage medium | |
| US11687416B2 (en) | Data backup optimization | |
| CN115544096B (en) | Data query method and device, computer equipment and storage medium | |
| CN117974334A (en) | Multi-stage synchronous management method, equipment and medium for accounting purpose | |
| CN115271902A (en) | Budget processing method, device, equipment and medium for account statement sheet | |
| CN118195665A (en) | Standard cost calculating method, apparatus and medium for reducing accounting data volume | |
| CN116701529A (en) | Method, equipment and medium for realizing cross-system push information interface |
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 |