CN104484331B - Electronics based on ERP system is rendered an account module performance optimization method - Google Patents
Electronics based on ERP system is rendered an account module performance optimization method Download PDFInfo
- Publication number
- CN104484331B CN104484331B CN201410616536.6A CN201410616536A CN104484331B CN 104484331 B CN104484331 B CN 104484331B CN 201410616536 A CN201410616536 A CN 201410616536A CN 104484331 B CN104484331 B CN 104484331B
- Authority
- CN
- China
- Prior art keywords
- account
- electronics
- data
- erp system
- rendered
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 18
- 238000005457 optimization Methods 0.000 title claims abstract description 17
- 238000009877 rendering Methods 0.000 claims abstract description 14
- 238000004140 cleaning Methods 0.000 claims abstract description 12
- 230000003068 static effect Effects 0.000 claims abstract description 10
- 238000002955 isolation Methods 0.000 claims abstract description 4
- 230000008859 change Effects 0.000 description 2
- 230000005611 electricity Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 230000004044 response Effects 0.000 description 2
- 230000001960 triggered effect Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007423 decrease Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000012634 fragment Substances 0.000 description 1
- 230000007257 malfunction Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000000737 periodic effect Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 230000009897 systematic effect Effects 0.000 description 1
- 239000002699 waste material Substances 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/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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- General Engineering & Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Quality & Reliability (AREA)
- Computing Systems (AREA)
- Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Rendered an account module performance optimization method the present invention relates to the electronics based on ERP system, it is therefore intended that improved to ERP system, optimization performance makes it reduce the dependence to hardware.In order to solve the above-mentioned technical problem, the present invention comprises the following steps：Step 1：Sieve user；Step 2：Cleaning association caching；Step 3：The code of Search Help helps for search in isolation module；Step 4：Dynamic data and static data are classified, and are cleared up after backup；Step 5：SAP realizes at end that electronics form of rendering an account checks that voucher annex directly invokes the annex mounted on document；Step 6：ERP is pending etc. to be related to electronics and renders an account the historical data archiving of application；After restart the electronics of ERP system and render an account module.Compared with prior art, the present invention ensure that in the long period, i.e., data-handling efficiency will not be impacted in 45 years on the premise of not upgrading hardware.
Description
Technical field
The present invention relates to company ERP system, more particularly to a kind of electronics for being exclusively used in ERP system inside large enterprise to render an account
Module performance optimization method.
Background technology
For large-scale Business group, management, ERP system is an essential part.As in the prior art
The patent of invention of Patent No. 200910249671.0《Applied to the method for sending information and device in enterprise resource planning ERP》
In disclose it is a kind of be applied to enterprise resource planning ERP in method for sending information and device, wherein applied to ERM
Method for sending information in planning ERP includes:Document types are determined according to the document that user selects；According to the document types,
Receipt field corresponding to the document types is obtained from database；Display includes the interface of receipt field list, the document
List of fields includes acquired receipt field；Receive the receipt field that user selects in the receipt field list；According to
Receipt field selected by user, obtain bills data；Using acquired bills data generation text and send.Use the hair
The technical scheme that bright embodiment provides, bills data can be got automatically according to different documents, improve operating efficiency.
With the continuous expansion of system ovelay range, user's frequency of use, data volume increase year by year, system performance problems
It is gradually prominent.Especially in the peak traffic time in the end of the year at the end of month, because the user's usage amount of ERP system in itself causes greatly electronics report
Account system low-response, Consumer's Experience are poor.And the data storage of EP enterprise portals, in ERP database, workflow is touched
Hair is also based on ERP system, therefore there is problems with and potential risks：
1st, because ERP system on-line time is longer, substantial amounts of daily record class, the number of the sorts of systems aspect of pending class be have accumulated
According to.Because the time is longer, these data, which exist, not substantially to be queried or uses in business, therefore these data
Larger space is taken in the presence of some database tables are often caused.
2nd, since ERP system is reached the standard grade, developed substantial amounts of from exploitation program.Operation often be present from program is developed in these
The problems such as efficiency is low, response speed is slow.These can consume substantial amounts of system resource, cause ERP system from the execution for developing program
And electronics system operation of rendering an account is slow.
3rd, each modules of ERP are imported a large number of services data and are carried out backstage work in systems due to business demand or system call interception
During industry, systematic function can be greatly consumed.
Above-mentioned several situations can all cause the speed of enterprise portal EP access ERP server to decline, and cause enterprise portal
It is unstable with the data interaction of ERP server.Finally, when user creates document or occurs long during using help for search in door
Between wait；During using general operations inventory, there is the information of " attempting a connection to malfunction during supplier ", wait a series of problem.
The method that operating efficiency is much improved in ERP is all to need a large amount of hardware supporteds, is entirely to come by hardware performance
Lift the operating efficiency of ERP system.Once occur a large amount of fragments and ephemeral data in the long ERP system of usage time.These data
It is more scattered, and be difficult to clean off, the time one will slow down the speed of service of ERP system significantly long.In the prior art to this nothing
Meter can be applied, and can only alleviate this problem by upgrading hardware.It is too high to finally result in HardwareUpgring expense, it is unnecessary to bring
Waste.
Also there are some Optimized Measures in the prior art, but rendered an account mould for the electronics of the most key core in ERP system
Block never has ripe change, because electronics is rendered an account, module is related to bankroll problem, and sometimes a numeric error will be led
Very big loss is caused, it is necessary to which a highly stable method is handled.
The content of the invention
It is an object of the invention to be improved to ERP system, optimization performance makes it reduce the dependence to hardware, especially
Its electronics to core module of rendering an account optimizes processing, is ensuring that information is accurate, is not increasing the negative of hardware on the premise of safety
Load, for a long time use will not reduce efficiency.
In order to solve the above-mentioned technical problem, the present invention is achieved by the following technical solutions：Electronics based on ERP system
Render an account module performance optimization method, comprise the following steps：
Step 1：Sieve user：Redefine electronics to render an account module login account, be separately provided electronics module of rendering an account and log in
Account, the account for module authority of being rendered an account in ERP system is deleted during electronics renders an account module without electronics；
Step 2：Cleaning association caching：Clear up enterprise gateway server IE cachings；
Step 3：The code of Search Help helps for search in isolation module, re-establish corresponding single module；
Step 4：Dynamic data and static data are classified, and are cleared up after backup；
Step 5：SAP realizes at end that electronics form of rendering an account checks that voucher annex directly invokes the annex mounted on document；
Step 6：ERP is pending etc. to be related to electronics and renders an account the historical data archiving of application；After restart the electronics of ERP system
Render an account module.
Preferably, the cleaning enterprise gateway server IE caching steps are carried out by timer timing.So it is avoided that
Due to forgetting that cleaning in time causes storing excess garbage or the long situation for influenceing normal work of clearance time.
Preferably, dynamic data and static data cleaning and cleaning enterprise gateway server IE caching steps in the step 4
Rapid synchronous progress.Which simplify the startup opportunity of timer.
Preferably, institute's dynamic data refers to more than 1 year unfinished document having been filed in the step 4, or because of flow section
The reasons such as approving person are not configured in point and cause the workflow of error, and each office key user is provided and does not complete inventory, by closing
Workflow is carried out after key user configuration to restart, or has confirmed that the document that can not be completed and workflow are deleted；Triggered but because
System performance reasons and the workflow collapsed, workflow is set to continue flow-through after restarting from the background, to complete examining for document
Batch；
The static data refers in the related service master data allocation list of work flow step, hence it is evident that invalid configuration entry,
The contents of the section is removed after can confirming with each office key user, so as to effectively improve workflow execution efficiency.
Preferably, SAP ends realize that electronics form of rendering an account checks voucher annex to directly invoke on document to mount in the step 5
Annex, using workflow ID check approval node detail, directly accessed the database from system level, reduce user log in door
Number and operation actuating quantity, indirectly improve enterprise portal access speed.
Preferably, ERP the render an account historical data archivings of application of electronics that are related to such as pending are search ERP systems in the step 6
System neutralizes electronics and rendered an account the data of more than 3 years of module relation, distinguishes valid data and makees dirty data, deletes the data of calcellation,
Valid data are redefined with renewal time label after associating, deletes original valid data.What is cleared up herein is in ERP system
Rendered an account the related data of module to electronics.
Compared with prior art, the present invention is rendered an account module performance optimization method by the electronics based on ERP system, by reality
After the operation of border, drop to less than the 30% of legacy data amount using the module overall amount of data of rendering an account of the electronics of more than 5 years；2 years with
On electronics module overall amount of data of rendering an account drop to less than the 60% of legacy data amount.On the premise of not upgrading hardware,
It ensure that in the long period, i.e., data-handling efficiency will not be impacted in 4-5.
Embodiment
Specific implementation step of the present invention is as follows：Step 1：Sieve user：Electronics is redefined to render an account module login account, it is single
Solely set electronics to render an account module login account, rendered an account module authority without electronics in ERP system is deleted during electronics renders an account module
Account；
Step 2：Cleaning association caching：Clear up enterprise gateway server IE cachings；
Step 3：The code of Search Help helps for search in isolation module, re-establish corresponding single module；
Step 4：Dynamic data and static data are classified, and are cleared up after backup；
Step 5：SAP realizes at end that electronics form of rendering an account checks that voucher annex directly invokes the annex mounted on document；
Step 6：ERP is pending etc. to be related to electronics and renders an account the historical data archiving of application；After restart the electronics of ERP system
Render an account module.
Optimization electronics is rendered an account system and the direct single sign on mechanism of ERP system.Need to use electronics at present to render an account module
User must also have corresponding account in ERP system, cause to be provided purely for electronics in ERP system in common large-scale Business group
The account rendered an account is up to tens thousand of multiple.By analysis, there is optimization space in the one-to-one single sign on mechanism of this account, can
To use general account by enterprise portal submitter, authority is distributed unitedly, many-to-one mode saves ERP system
License resources.So account number can be reduced an order of magnitude.
Enterprise gateway server IE cachings are cleared up in the timing push pending information of enterprise portal, timing.
Isolate the code of Search Help helps for search in enterprise portal.The render an account business datum of system of electronics is stored in
In ERP database, when using help for search, data interaction can be produced, when being operated a large number of users same time, is accounted for
It is larger with Installed System Memory, therefore isolate Search Help searching codes into a separate modular, optimize database code, carry
Height searches speed, reduces search time, can be greatly enhanced 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：
Dynamic data refers to have been filed on but more than 1 year unfinished document or because not configuring approving person in flow nodes
Cause the workflow of error etc. reason.Each office key user can be provided and not complete inventory, carried out after being configured by key user
Workflow is restarted, or has confirmed that the document that can not be completed and workflow are deleted.In addition, having triggered but because of system performance reasons
And the workflow collapsed, workflow is continued flow-through after restarting from the background, to complete the examination ＆ approval of document.
Static data refers in the related service master data allocation list of work flow step, hence it is evident that invalid configuration entry.The portion
Point content is removed after can confirming with each office key user, so as to effectively improve workflow execution efficiency.Realize electricity in SAP ends
Son form of rendering an account checks that voucher annex directly invokes the annex mounted on document, and approval node detail is checked using workflow ID.
Develop it is such penetrate the function not only just user, and user is directly accessed the database from system level above business, reduce and use
Family logs in the number of door and the actuating quantity of operation, improves the access speed of enterprise portal indirectly.ERP is pending etc. to be related to electronics report
The historical data archiving of account application.The enterprise that ERP system was reached the standard grade more than 10 years, history outstanding data up to millions, history number
According to not used, but the historical data of millions can bring the performance issue of existing pending inquiry.
The present invention is applied to the inside ERP of large-scale corporation.The electricity of more than 5 years can be used by such a optimization method
Son module overall amount of data of rendering an account drops to less than the 30% of legacy data amount；The module of rendering an account of the electronics of more than 2 years integrally counts
Drop to less than the 60% of legacy data amount according to amount.Electronics after cleaning renders an account module on the premise of not upgrading hardware, ensures
In long period, i.e., in 4-5 data-handling efficiency will not be impacted.
The specific embodiment of the present invention is the foregoing is only, but the technical characteristic of the present invention is not limited thereto, Ren Heben
The technical staff in field in the field of the invention, all cover among the scope of the claims of the present invention by the change or modification made.
Claims (6)
- The module performance optimization method 1. the electronics based on ERP system is rendered an account, it is characterised in that comprise the following steps：Step 1：Sieve user：Redefine electronics to render an account module login account, be separately provided electronics and render an account module login account, The account for module authority of being rendered an account in ERP system is deleted during electronics renders an account module without electronics；Step 2：Cleaning association caching：Clear up enterprise gateway server IE cachings；Step 3：The code of Search Help helps for search in isolation module, re-establish corresponding single module；Step 4：Dynamic data and static data are classified, and are cleared up after backup；Step 5：SAP realizes at end that electronics form of rendering an account checks that voucher annex directly invokes the annex mounted on document；Step 6：These pending electronics of ERP are rendered an account the historical data archiving of application；After restart the electronics of ERP system and render an account mould Block.
- 2. the electronics based on ERP system is rendered an account module performance optimization method as claimed in claim 1, it is characterised in that described Enterprise gateway server IE caching steps are cleared up to carry out by timer timing.
- 3. the electronics based on ERP system is rendered an account module performance optimization method as claimed in claim 2, it is characterised in that described Dynamic data and static data cleaning and cleaning enterprise gateway server IE caching steps are synchronously carried out in step 4.
- 4. the electronics based on ERP system is rendered an account module performance optimization method as claimed in claim 3, it is characterised in that described Dynamic data refers to have been filed on but more than 1 year unfinished document in step 4, or because not configuring approving person in flow nodes The reason for and cause error workflow, to each office key user provide do not complete inventory, carry out work after being configured by key user Restart as stream, or have confirmed that the document that can not be completed and workflow are deleted；Trigger but occurred because of system performance reasons The workflow of collapse, workflow is set to continue flow-through after restarting from the background, to complete the examination ＆ approval of document；The static data refers in the related service master data allocation list of work flow step, hence it is evident that invalid configuration entry, the portion Point content is removed after can confirming with each office key user, so as to effectively improve workflow execution efficiency.
- 5. the electronics based on ERP system is rendered an account module performance optimization method as claimed in claim 1, it is characterised in that described SAP realizes at end that electronics form of rendering an account checks that voucher annex directly invokes the annex mounted on document in step 5, uses workflow ID Approval node detail is checked, is directly accessed the database from system level, user is reduced and logs in the number of door and the action of operation Amount, the access speed of enterprise portal is improved indirectly.
- 6. the electronics based on ERP system is rendered an account module performance optimization method as claimed in claim 1, it is characterised in that described Pending these of ERP, which are related to the render an account historical data archiving of application of electronics, in step 6 is rendered an account module with electronics in search ERP system The data of more than 3 years of association, distinguish valid data and make dirty data, delete the data of calcellation, valid data are redefined Renewal time label after association, delete 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 CN104484331A (en) | 2015-04-01 |
| CN104484331B true 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) |
Families Citing this family (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 (7)
| 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 |
| CN103473654A (en) * | 2013-09-23 | 2013-12-25 | 国家电网公司 | Asset data cleaning auxiliary method and system for electric ERP system |
| CN103473297A (en) * | 2013-09-05 | 2013-12-25 | 北京邮电大学 | Multimedia question-answering system and method based on intelligent mobile terminal |
| 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 |
| CN105683928A (en) * | 2013-09-27 | 2016-06-15 | 微软技术许可有限责任公司 | Data caching policy in multiple tenant enterprise resource planning system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9734173B2 (en) * | 2013-03-12 | 2017-08-15 | Sap Se | Assignment of data temperatures in a fragmented data set |
-
2014
- 2014-11-05 CN CN201410616536.6A patent/CN104484331B/en active Active
Patent Citations (7)
| 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 |
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104484331A (en) | 2015-04-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103593422B (en) | Virtual access management method of heterogeneous database | |
| CN101515290B (en) | Metadata management system with bidirectional interactive characteristics and implementation method thereof | |
| CN104935658B (en) | A kind of bank's method for allocating tasks and device | |
| CN101546311B (en) | Data processing method and data processing device for recycle bin | |
| US7797347B2 (en) | Workload aware checking of database reorganization | |
| CN107247808A (en) | A kind of distributed NewSQL Database Systems and image data querying method | |
| CN106294492A (en) | Data cleaning method and cleaning engine | |
| CN101221530B (en) | Method for automatically leading in test cases | |
| CN102479223A (en) | Data query method and system | |
| CN101136020A (en) | System and method for automatically spreading reference data | |
| CN101446971A (en) | Method for building content management system and device thereof | |
| CN102043859A (en) | Data updating method and device | |
| CN103218402A (en) | General database data structure, data migratory system and method thereof | |
| CN101599140A (en) | The system and method that daily record of work generates automatically | |
| CN101794299A (en) | Method for increment definition and processing of historical data management | |
| CN104484331B (en) | Electronics based on ERP system is rendered an account module performance optimization method | |
| CN107609172B (en) | Cross-system multi-dimensional data retrieval processing method and device | |
| CN103345486A (en) | Method for obtaining and showing picture file by client side under remote browsing environment | |
| CN110955413B (en) | Financial data processing system | |
| CN103440302B (en) | The method and system of Real Data Exchangs | |
| CN106204263B (en) | Transaction progress control method and device | |
| CN104252463B (en) | A kind of db2 data base management methods based on web system | |
| CN105260411A (en) | XBRL-based system and method for achieving detail data aggregation and drill-down of financial report | |
| CN102567836A (en) | Project resource management system | |
| CN109308606A (en) | A kind of cost of construction management system and method based on BIM technology |
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 |