Tag Archives: ERP

OLTP vs OLAP

OLTP (Online transaction processing system) is a traditional term used for transaction system used to carry out day to day business functions such as ERP, CRM etc. OLTP system solved a critical business problem of automating daily business functions and running real time reports and analysis. But these systems were not designed for analysis and queries. Frustration started to build in Business management as OLTP systems could not provide the analysis on the data. Resource heavy management analytical queries started to affect performance of OLTP systems and users of OLTP system also got frustrated. Read More »

What is ERP

ERP (Enterprise Resource Planning) is a software system that allows companies to integrate their internal functions, such as Manufacturing, Production Planning, Finance, Sales, Service, Engineering, HR etc, around a common corporate database. In many companies, all these departments run their own software applications that are not properly integrated. Read More »