FREE online courses on Business Needs and ERP - ERP System - Database systems

 

The current generation of database systems is based on relational technology (RDBMS). These database systems support querying using standard query language known as Structured Query Language (SQL). Business logic which specifies the set of actions that need to be performed (such as check stock situation and update inventory) is written using SQL and is invoked when user performs an action. These database systems support access of multiple distributed data sources and allow synchronizing of data manipulation across these sources.

 

ERP systems built on this technology will support organizations with the need to setup distributed systems with less dependence on a central information resource location. Use of standard query language will enable organizations to perform post implementation maintenance with confidence since the systems in place are not tied to proprietary languages. The skill needed to do this activity will not be at a premium in the market place. Salability issues are addressed since sizing of hardware may be done to cater to the business process activities performed at a specific location. Addition of new location(s) will not lead to disruption at other locations.