- In the current global competitive world every organization require much attention/focus on running their daily business activities for the services which offered by them. For example banking, credit cards, insurance, online shopping, railway/bus reservation, bill payments,telephone,call center, etc..
- To run the business in a automated way generally every business process is automated using either a custom built software or a ERP's like Oraclepps, SAP/peopelesoft, Salesforce, Siebel CRM, Finacle, Flexcube, etc..
- Business owners have choice to choose a perfect suitable, software as per their need. For example a banking company may choose mainframes or oracle flex cube or finacle as a core banking system to operate their regular banking activities. Same time they can use Siebel as a call center application and Peoplesoft for HR processing.
- These software are designed to stores data in adatabase along with graphical user interfaces to interact with databases. Here every activity performed on GUI will lead to SELECT or INSERT or UPDATE or DELETE operation on database, such activities might be millions/billions at any given point of him.
Money deposit is INSERT operation
Withdraw money is INSERT or UPDATE operation
- To design databases to support such kind of actions E-R modeling is best data modeling technique which supports continues SELECT, UPDATE and INSERT operations at a given point of time (If we take example for bank, there can be millions of INSERT, UPDATE, SELECT operations on database tables at a given point of time ). These aapplictions are designed to perform only transaction, so these applications are generally called as OLTP (ONLINE TRANSACTION PROCESSING) applications.
