CN104484331A - Electronic reimbursement module performance optimization method based on ERP system - Google Patents
Electronic reimbursement module performance optimization method based on ERP system Download PDFInfo
- Publication number
- CN104484331A CN104484331A CN201410616536.6A CN201410616536A CN104484331A CN 104484331 A CN104484331 A CN 104484331A CN 201410616536 A CN201410616536 A CN 201410616536A CN 104484331 A CN104484331 A CN 104484331A
- Authority
- CN
- China
- Prior art keywords
- account
- electronics
- erp system
- data
- render
- 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.)
- Granted
Links
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/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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- 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/10—Office automation; Time management
Abstract
The invention relates to an electronic reimbursement module performance optimization method based on an ERP system and aims at improving the ERP system and optimizing the performance of the ERP system to reduce the dependency of the ERP system on hardware. In order to solve the technical problem, the electronic reimbursement module performance optimization method based on the ERP system comprises the step 1 of screening users, the step 2 of clearing an associated cache, the step 3 of isolating the codes of search help in the module, the step 4 of classifying dynamic data and static data and clearing after backup, the step 5 of realizing the viewing of an electronic reimbursement statement and directly invoking accessories attached on receipts with voucher accessories at an SAP end, and the step 6 of archiving historical data related to electronic reimbursement application such as ERP backlogs, and after finishing data archiving, rebooting the electronic reimbursement module of the ERP system. Compared with the prior art, the electronic reimbursement module performance optimization method based on the ERP system guarantees that the data processing efficiency is not affected within long time, namely 4-5 years, without upgrading the hardware.
Description
Technical field
The present invention relates to company ERP system, particularly relate to a kind of electronics being exclusively used in the inner ERP system of large enterprise and to render an account module performance optimization method.
Background technology
For large-scale Business group, management, ERP system is absolutely necessary an ingredient.If prior art Patent number is disclose in the patent of invention " being applied to the method for sending information in enterprise resource planning ERP and device " of 200910249671.0 to be a kind ofly applied to method for sending information in enterprise resource planning ERP and device, the method for sending information be wherein applied in enterprise resource planning ERP comprises: the document determination document types selected according to user; According to described document types, from database, obtain the receipt field that described document types is corresponding; Display comprises the interface of receipt field list, and described receipt field list comprises obtained receipt field; Receive the receipt field that user selects in described receipt field list; According to user-selected receipt field, obtain bills data; The bills data obtained is utilized to generate text and send.Use the technical scheme that this inventive embodiments provides, according to different document automatic acquisition to bills data, can increase work efficiency.
Along with the continuous expansion of system ovelay range, increasing year by year of user's frequency of utilization, data volume, system performance problems is given prominence to gradually.Special in the peak traffic time in the end of the year at the end of month, the user's use amount due to ERP system itself causes greatly electronics to render an account system responses slowly, and Consumer's Experience is poor.And the data storing of EP enterprise portal is in the database of ERP, the triggering of workflow is also based on ERP system, therefore there are following problem and potential risks:
1, because ERP system on-line time is longer, have accumulated the data of sorts of systems aspect of a large amount of daily record classes, pending class.Because the time is longer, the existence of these data has not substantially been queried or has used in business, and therefore the existence of these data often causes some database table to take larger space.
2, since ERP system is reached the standard grade, developed a large amount of from exploitation program.Often there is the problems such as operational efficiency is low, response speed is slow in these from exploitation program.These, from the execution of exploitation programs, can consume a large amount of system resource, cause ERP system and electronics system cloud gray model of rendering an account slow.
3, each module of ERP is due to business demand or system call interception, when importing a large number of services data carry out background job in systems in which, and can very big consumption systems performance.
Above-mentioned several situation all can cause the speed of the access ERP server of enterprise portal EP to decline, and causes the data interaction of enterprise portal and ERP server unstable.Finally, there will be when user creates document or use help for search in door and wait as long for; When using general operations inventory, there is the information of " attempting to make mistakes when connecting supplier ", wait a series of problem.
The method of much increasing work efficiency in ERP is all need a large amount of hardware supported, is completely to rely on hardware performance to promote the work efficiency of ERP system.Once there is a large amount of fragment and ephemeral data in long ERP system in service time.These data are comparatively disperseed, and are difficult to remove, and the time one will slow down the travelling speed of ERP system for a long time greatly.At one's wit's end to this in prior art, this problem can only be alleviated by upgrading hardware.Finally cause HardwareUpgring expense too high, bring unnecessary waste.
Also some Optimized Measures are had in prior art, the change that module is never ripe but the electronics for core the most key in ERP system is rendered an account, because electronics is rendered an account, module relates to bankroll problem, sometimes a numeric error will cause very large loss, needs a highly stable method to process.
Summary of the invention
The object of the invention is to improveing ERP system, Optimal performance makes it reduce dependence to hardware, especially be optimized process to the electronics of core module of rendering an account, guaranteeing the burden not increasing hardware under the prerequisite that information is accurate, safe, long-time use can not lower efficiency.
In order to solve the problems of the technologies described above, the present invention is achieved by the following technical solutions: the electronics based on ERP system is rendered an account module performance optimization method, comprises the steps:
Step 1: screening user: redefine electronics and to render an account module login account, arranges separately electronics and to render an account module login account, delete in ERP system the account of module authority of rendering an account without electronics in electronics renders an account module;
Step 2: cleaning association buffer memory: cleaning enterprise gateway server IE buffer memory;
Step 3: the code of Search Help help for search in isolation module, re-establishes corresponding independent module;
Step 4: dynamic data and static data are classified, and clear up after backup;
Step 5:SAP end realizes electronics form of rendering an account and checks that voucher annex directly calls the annex that document mounts;
Step 6:ERP is pending etc. relates to electronics and to render an account the historical data archiving of application; After restart ERP system electronics to render an account module.
Preferably, described cleaning enterprise gateway server IE caching step is undertaken by timer timing.So just avoid owing to forgetting the situation of clearing up in time and causing storing excess garbage or the long impact of clearance time normally to work.
Preferably, in described step 4, dynamic data and static data cleaning and cleaning enterprise gateway server IE caching step synchronously carry out.Which simplify the startup opportunity of timer.
Preferably, in described step 4, institute's dynamic data refers to the document do not completed for more than a year submitted to, or the workflow of makeing mistakes is caused because not configuring the reasons such as approving person in flow nodes, each office key user is provided and does not complete inventory, carry out workflow after being configured by key user to restart, or confirmed that the document that cannot complete and workflow are deleted; Triggered but occur because of system performance reasons collapse workflow, backstage make after restarting workflow continue flow-through, to complete the examination & approval of document;
Described static data refers in the related service master data allocation list of work flow step, obviously invalid configuration entry, and this partial content is removed after can confirming with each office key user, thus effectively improves workflow execution efficiency.
Preferably, in described step 5, SAP end realizes electronics form of rendering an account and checks that voucher annex directly calls the annex that document mounts, examination & approval node is detailed to use workflow ID to check, from the direct accessing database of system level, reduce user and log in the number of times of door and the actuating quantity of operation, indirectly improve the access speed of enterprise portal.
Preferably, in described step 6, pending etc. to relate to the render an account historical data archiving of application of electronics be in search ERP system and electronics is rendered an account the data of more than 3 years of module relation to ERP, distinguish valid data and make dirty data, delete the data of cancelling, association label rear update time is redefined to valid data, deletes original valid data.What clear up is the relevant data of module of rendering an account with electronics in ERP system herein.
Compared with prior art, the present invention, by module performance optimization method of rendering an account based on the electronics of ERP system, after practical operation, uses the electronics of more than 5 years module whole data volume of rendering an account to drop to less than 30% of legacy data amount; More than 2 years electronics module whole data volume of rendering an account drop to less than 60% of legacy data amount.Under the prerequisite of not upgrading hardware, ensure that in the long period, namely in 4-5, data-handling efficiency can not be influenced.
Embodiment
The concrete implementation step of the present invention is as follows: step 1: screening user: redefine electronics and to render an account module login account, arranges separately electronics and to render an account module login account, delete in ERP system the account of module authority of rendering an account without electronics in electronics renders an account module;
Step 2: cleaning association buffer memory: cleaning enterprise gateway server IE buffer memory;
Step 3: the code of Search Help help for search in isolation module, re-establishes corresponding independent module;
Step 4: dynamic data and static data are classified, and clear up after backup;
Step 5:SAP end realizes electronics form of rendering an account and checks that voucher annex directly calls the annex that document mounts;
Step 6:ERP is pending etc. relates to electronics and to render an account the historical data archiving of application; After restart ERP system electronics to render an account module.
Optimize electronics to render an account system and the direct single sign on mechanism of ERP system.Need to use the render an account user of module of electronics at present and must also have corresponding account in ERP system, to cause in common large-scale Business group in ERP system the account of rendering an account for electronics merely nearly tens thousand of multiple.By analysis, there is optimization space in this account one to one single sign on mechanism, can use general account by enterprise portal submitter, and unified distribution authority, many-to-one mode saves the License resource of ERP system.Such can by account decreased number order of magnitude.
Timing pushes the pending information of enterprise portal, timing cleaning enterprise gateway server IE buffer memory.
The code of Search Help help for search in isolation enterprise portal.The render an account business datum of system of electronics is stored in the database of ERP, when using help for search, data interaction can be produced, when a large number of users same time operates, take Installed System Memory comparatively large, therefore isolation Search Help searching code is in a separate modular, optimization data bank code, improve seek rate, reduce search time, greatly can improve the performance of system.And reduce Search Help to render an account to electronics the data influence of module.
Dynamic data and static data periodic cleaning:
The workflow that dynamic data refers to have submitted to but the document do not completed for more than a year or cause because not configuring the reasons such as approving person in flow nodes is made mistakes.Can provide each office key user and not complete inventory, carry out workflow after being configured by key user and restart, or confirm that the document that cannot complete and workflow are deleted.In addition, triggered but occur because of system performance reasons collapse workflow, backstage make after restarting workflow continue flow-through, to complete the examination & approval of document.
Static data refers in the related service master data allocation list of work flow step, obviously invalid configuration entry.This partial content is removed after can confirming with each office key user, thus effectively improves workflow execution efficiency.SAP end realizes electronics form of rendering an account and checks that voucher annex directly calls the annex that document mounts, and examination & approval node is detailed to use workflow ID to check.Develop this type of and penetrate function not only just user above business, and make the direct accessing database of user from system level, reduce user and log in the number of times of door and the actuating quantity of operation, indirectly improve the access speed of enterprise portal.ERP is pending etc. relates to electronics and to render an account the historical data archiving of application.ERP system is reached the standard grade the enterprise more than 10 years, and history outstanding data reaches millions, and historical data does not re-use, but the historical data of millions can bring the performance issue of existing pending inquiry.
The present invention is applicable to the inside ERP of large-scale corporation.The electronics of more than 5 years module whole data volume of rendering an account can be used to drop to less than 30% of legacy data amount by such optimization method; More than 2 years electronics module whole data volume of rendering an account drop to less than 60% of legacy data amount.Electronics after cleaning renders an account module under the prerequisite of not upgrading hardware, and ensure that in the long period, namely in 4-5, data-handling efficiency can not be influenced.
The foregoing is only specific embodiments of the invention, but technical characteristic of the present invention is not limited thereto, any those skilled in the art is in the field of the invention, and the change done or modification are all encompassed among the scope of the claims of the present invention.
Claims (6)
1. to render an account module performance optimization method based on the electronics of ERP system, it is characterized in that, comprise the steps:
Step 1: screening user: redefine electronics and to render an account module login account, arranges separately electronics and to render an account module login account, delete in ERP system the account of module authority of rendering an account without electronics in electronics renders an account module;
Step 2: cleaning association buffer memory: cleaning enterprise gateway server IE buffer memory;
Step 3: the code of Search Help help for search in isolation module, re-establishes corresponding independent module;
Step 4: dynamic data and static data are classified, and clear up after backup;
Step 5:SAP end realizes electronics form of rendering an account and checks that voucher annex directly calls the annex that document mounts;
Step 6:ERP is pending etc. relates to electronics and to render an account the historical data archiving of application; After restart ERP system electronics to render an account module.
2. to render an account module performance optimization method based on the electronics of ERP system as claimed in claim 1, it is characterized in that, described cleaning enterprise gateway server IE caching step is undertaken by timer timing.
3. to render an account module performance optimization method based on the electronics of ERP system as claimed in claim 2, it is characterized in that, in described step 4, dynamic data and static data cleaning and cleaning enterprise gateway server IE caching step synchronously carry out.
4. to render an account module performance optimization method based on the electronics of ERP system as claimed in claim 3, it is characterized in that, in described step 4 institute's dynamic data refer to have submitted to but the document do not completed for more than a year, or the workflow of makeing mistakes is caused because not configuring the reasons such as approving person in flow nodes, each office key user is provided and does not complete inventory, carry out workflow after being configured by key user to restart, or confirmed that the document that cannot complete and workflow are deleted; Triggered but occur because of system performance reasons collapse workflow, backstage make after restarting workflow continue flow-through, to complete the examination & approval of document;
Described static data refers in the related service master data allocation list of work flow step, obviously invalid configuration entry, and this partial content is removed after can confirming with each office key user, thus effectively improves workflow execution efficiency.
5. to render an account module performance optimization method based on the electronics of ERP system as claimed in claim 1, it is characterized in that, in described step 5, SAP end realizes electronics form of rendering an account and checks that voucher annex directly calls the annex that document mounts, examination & approval node is detailed to use workflow ID to check, from the direct accessing database of system level, reduce user and log in the number of times of door and the actuating quantity of operation, indirectly improve the access speed of enterprise portal.
6. to render an account module performance optimization method based on the electronics of ERP system as claimed in claim 1, it is characterized in that, in described step 6, pending etc. to relate to the render an account historical data archiving of application of electronics be in search ERP system and electronics is rendered an account the data of more than 3 years of module relation to ERP, distinguish valid data and make dirty data, delete the data of cancelling, association label rear update time is redefined to valid data, deletes original valid data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410616536.6A CN104484331B (en) | 2014-11-05 | 2014-11-05 | Electronics based on ERP system is rendered an account module performance optimization method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410616536.6A CN104484331B (en) | 2014-11-05 | 2014-11-05 | Electronics based on ERP system is rendered an account module performance optimization method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104484331A true CN104484331A (en) | 2015-04-01 |
| CN104484331B CN104484331B (en) | 2017-12-19 |
Family
ID=52758872
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410616536.6A Active CN104484331B (en) | 2014-11-05 | 2014-11-05 | Electronics based on ERP system is rendered an account module performance optimization method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104484331B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106504083A (en) * | 2016-10-25 | 2017-03-15 | 广西犇云科技有限公司 | A kind of cloud desktop is rendered an account system |
| CN109509076A (en) * | 2018-12-06 | 2019-03-22 | 国网浙江杭州市余杭区供电有限公司 | A kind of management-control method based on battalion's wealth integrated management system |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102103710A (en) * | 2009-12-21 | 2011-06-22 | 中国移动通信集团公司 | ERP (Enterprise Resource Planning) system access control method and platform |
| CN102202044A (en) * | 2011-02-25 | 2011-09-28 | 北京兴宇中科科技开发股份有限公司 | Portable cloud storage method and device |
| CN103473297A (en) * | 2013-09-05 | 2013-12-25 | 北京邮电大学 | Multimedia question-answering system and method based on intelligent mobile terminal |
| CN103473654A (en) * | 2013-09-23 | 2013-12-25 | 国家电网公司 | Asset data cleaning auxiliary method and system for electric ERP system |
| CN103701871A (en) * | 2013-12-12 | 2014-04-02 | 四川长虹电器股份有限公司 | Implementing method for enabling virtual terminal to acquire APP STORE deployment state |
| CN103745317A (en) * | 2013-12-31 | 2014-04-23 | 金蝶软件（中国）有限公司 | Business processing property analyzing method and device |
| US20140279963A1 (en) * | 2013-03-12 | 2014-09-18 | Sap Ag | Assignment of data temperatures in a framented data set |
| CN105683928A (en) * | 2013-09-27 | 2016-06-15 | 微软技术许可有限责任公司 | Data caching policy in multiple tenant enterprise resource planning system |
-
2014
- 2014-11-05 CN CN201410616536.6A patent/CN104484331B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102103710A (en) * | 2009-12-21 | 2011-06-22 | 中国移动通信集团公司 | ERP (Enterprise Resource Planning) system access control method and platform |
| CN102202044A (en) * | 2011-02-25 | 2011-09-28 | 北京兴宇中科科技开发股份有限公司 | Portable cloud storage method and device |
| US20140279963A1 (en) * | 2013-03-12 | 2014-09-18 | Sap Ag | Assignment of data temperatures in a framented data set |
| CN103473297A (en) * | 2013-09-05 | 2013-12-25 | 北京邮电大学 | Multimedia question-answering system and method based on intelligent mobile terminal |
| CN103473654A (en) * | 2013-09-23 | 2013-12-25 | 国家电网公司 | Asset data cleaning auxiliary method and system for electric ERP system |
| CN105683928A (en) * | 2013-09-27 | 2016-06-15 | 微软技术许可有限责任公司 | Data caching policy in multiple tenant enterprise resource planning system |
| CN103701871A (en) * | 2013-12-12 | 2014-04-02 | 四川长虹电器股份有限公司 | Implementing method for enabling virtual terminal to acquire APP STORE deployment state |
| CN103745317A (en) * | 2013-12-31 | 2014-04-23 | 金蝶软件（中国）有限公司 | Business processing property analyzing method and device |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106504083A (en) * | 2016-10-25 | 2017-03-15 | 广西犇云科技有限公司 | A kind of cloud desktop is rendered an account system |
| CN109509076A (en) * | 2018-12-06 | 2019-03-22 | 国网浙江杭州市余杭区供电有限公司 | A kind of management-control method based on battalion's wealth integrated management system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104484331B (en) | 2017-12-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101438261B (en) | Techniques and system to perform gradual upgrades | |
| CN103380423A (en) | Systems and methods for private cloud computing | |
| CN106201501A (en) | A kind of configurableization construction method to mobile terminal form interface and system | |
| CN103020149B (en) | Share data update apparatus and shared data-updating method | |
| US20090076872A1 (en) | Convergence Of Customer And Internal Assets | |
| JP6054888B2 (en) | Method, system, and computer program for providing fare detection from rule attributes | |
| CN102043859A (en) | Data updating method and device | |
| CN105931004A (en) | Webpage-based multi-terminal storage electronic business management system | |
| CN102209098A (en) | Smart card remote detection method and system | |
| CN103440285A (en) | Large-scale mobile phone game system and database updating method of large-scale mobile phone game system | |
| US20100049573A1 (en) | Automated security provisioning for outsourced operations | |
| CN102184100A (en) | Geological disaster prevention and treatment informationized service integration framework and method based on service oriented architecture (SOA) | |
| CN107729222A (en) | User behavior statistical method, system, computer equipment and storage medium | |
| CN104484331A (en) | Electronic reimbursement module performance optimization method based on ERP system | |
| US20180012292A1 (en) | Information processing apparatus, information processing method, and computer readable storage medium | |
| CN101064024A (en) | Annual fee maintenance system | |
| AU2008203816B2 (en) | Message sequence management of enterprise based correlated events | |
| CN102289519A (en) | Application server and method for coordinating data of same and database | |
| CN102024010A (en) | Data processing system and data processing method | |
| CN106611299A (en) | Organization information management method | |
| CN106204263B (en) | Transaction progress control method and device | |
| US20140358743A1 (en) | Travel mistake and fraud detection | |
| CN107678856B (en) | Method and device for processing incremental information in business entity | |
| CN106600291A (en) | Multi-level agent-based public cloud order delivery method | |
| CN104010008A (en) | Method for controlling mass invalid access to server |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |