what is difference between Operational vs. Analytical Systems
1
Lets talk about operational and analytics
system.
Operational Systems will be used because they run the “bread-and-butter” business processes of the organization - they are mission-critical
Analytical Systems depend on managers’ desire and ability to use them in their decision-making processes to manage the business
Analytical Systems depend on managers’ desire and ability to use them in their decision-making processes to manage the business
| Operational | Analytical | |
| Latency |
1 ms - 100 ms
|
1 min - 100 min
|
| Concurrency |
1000 - 100,000
|
1 - 10
|
| Access Pattern |
Writes and Reads
|
Reads
|
| Queries |
Selective
|
Unselective
|
| Data Scope |
Operational
|
Retrospective
|
| End User |
Customer
|
Data Scientist
|
Technology
|
NoSQL
|
MapReduce, MPP Database
|