Traditional systems are good for OLTP (online transaction processing) and some basic Data Analysis and BI use cases. Within the scope, the traditional systems are best in performance and management. The following figure shows a traditional system on a high-level overview:
Traditional systems with BIA
The steps for typical traditional systems are as follows:
Data resides in a database
ETL (Extract Transform Load) processes
Data moved into a data warehouse
Business Intelligence Applications can have some BI reporting
Data can be used by Data Analysis Application as well
When the data grows, traditional systems fail to process, or even store, the data; and even if they do, it comes at a very high cost and effort because of the limitations in the architecture, issue with scalability and resource constraints, incapability or difficulty to scale horizontally.
