Development of Reliable Information Systems, Techniques and Related Issues (DRISTI 2012) |
Foundation of Computer Science USA |
DRISTI - Number 1 |
April 2012 |
Authors: Navin Kumar Pal |
8c40ec83-0d38-4486-b54d-67bb010e1fe2 |
Navin Kumar Pal . Effective Way to Increase Performance in ERP Projects. Development of Reliable Information Systems, Techniques and Related Issues (DRISTI 2012). DRISTI, 1 (April 2012), 4-6.
Sometime a problem that occurs in organizations is when there is no current DBA function in the organization. For some organizations, the ERP application is their introduction to database management systems and relational technology. In this case, a DBA function should be created before the ERP system is selected to ensure that the right decisions are made. Failure to do so can result in bad decisions, which in turn can cause the ERP implementation to fail. If the implementation does not fail completely, other problems can occur afterward that are difficult to fix and could have been avoided with proper up-front planning. Examples of the problems that can occur include performance degradation, unmet service levels, and improper or non-existent backup and recovery plans. Organizations implementing packaged applications should plan and budget for ongoing database administration as a key component of supporting the packaged application. The database administration function will ensure the acceptable, consistent performance for the packaged application, as well as ensuring an effective backup and recovery procedure, a workable database change management process, release management and data migration, and enhancing overall data availability. To accomplish this requires a working knowledge of both the package itself and the DBMS used by the package. Without a mixture of these skills, the performance of the application is likely to suffer. In the worst case scenario, the ERP implementation may fail completely.