Analytic databases used for OLAP(On Line Analytical Processing) are primarily static, read-only databases which store archived, historical data used for analysis. For example, a bank might store customer transaction records over the last ten years in an analytic database and use that database to analyze banking strategies or trends to give better service to it’s customers.
Operational databases used for OLTP(On Line Transaction Processing), are used to manage more dynamic bits of data or current or live data. Operational databases allow you to modify data (add, change or delete data). These types of databases are usually used to track real-time information. For example, a Bank might have an operational database used to track day-to-day/daily transaction of their customers, new customer entries, existing customer-detail changes, etc
No comments:
Post a Comment