When you’re selecting a DBMS, consider speed of the database is reliable. ensure that the speed supports daily transactions volume. If the database is slow when you're doing transaction this will be a disaster.
Secondly, make sure the reliability your database is very well. The data keyed in and the result of the reports is accurate and there is no data redundancy from the database.
Thirdly, integrity of the database. Your DBMS can keep the data integrate from one sub system to the other sub systems. Supposing, purchasing department key in data of purchasing of course the data will be available for Inventory department to control if the purchased goods are already received.
Forthly, database security. You have to make sure the database is available and easy to accessed by authorized persons and secure from being accessed by unauthorised persons.
Finally, you must make sure that the database have backup functionality and data disaster recovery. You must do backup and recovery strategy for your erp database. If disasters such as hardisk crash, flood, fire, earth quake happen you still have the backup database to continue your organization operation. The recovery strategy should be easy to be done and the down time should be as short as possible.
Currently there are some databases which are very powerful in supporting ERP database. They are Oracle, MS Sql Server, DB2, PostGreSQL and more. |