Firstly, Online Analytical Processing is a process which provides software tools for analysis of data for business insights and decisions. Moreover, this system allows us to analyze database information from multiple sources. Certainly, the main objective of this system is data analysis.
Secondly, Online Transaction Processing provides transaction applications in a 3 tier architecture. In addition, it administers day to day transaction of an organization. Certainly, the main objective of this system is data processing.
Types of Online Analytical Processing (OLAP)
Let us look at some of the types of OLAP systems:
- Firstly, Multidimesional OLAP (MOLAP): this OLAP indexes directly into a multidimesional database.
- Secondly, Relational OLAP(ROLAP): this system performs dynamic multidimesional analysis of data that is stored in a relational database.
- Thirdly, Hybrid OLAP(HOLAP): This is a combination of MOLAP and ROLAP. Moreover, it has greater data capacity.
Examples of Online Analytical Processing Tools
- Dundas BI
- Sisense
- IBM Cognos Analytics
- SAP Business Intelligence
- Inetsoft
Characteristics of OLTP
OLTP generally focuses on query processing, maintaining data integrity and measure total number of transactions per second.
- Firstly, OLTP includes transaction for small amount of data.
- Secondly, it has fast response time.
- Thirdly, Databases are directly accessible to the end users.
- Moreover, it supports complex data models and tables.
- Lastly, Fully normalized schema for data consistency.
Architecture of OLTP
Architecture of OLTP includes the following:
- ETL process for extraction, transformation and loading.
- Business processes for a set of business goal and activities.
- Customers, orders and products
- Moreover, it includes data mart and data warehouse.
- Data processing and decision making.
Examples of Online Transaction Processing
- Firstly, Use of OLTP in online banking.
- Secondly, Airlines ticket booking
- Thirdly, Shopping carts
- Moreover, in Telemarketers
- Call centers updating customer details
- Lastly, in Order entry
OLAP vs OLTP
| OLAP | OLTP |
| Consists of historical data. | Consists of operational current data. |
| This system is subject oriented. Use in data mining | This system is application oriented. Use in business tasks. |
| It performs problem solving, planning and decision making. | It performs day to day fundamental operations. |
| Relatively slow as amount of data is large | Relatively faster as amount of data is small. |
Conclusion
In conclusion, we have learnt that Online Analytical Processing is a process which provides software tools for analysis of data for business insights and decisions. Moreover, this system allows us to analyze database information from multiple sources.
Types of OLAP are Multidimesional OLAP(MOLAP), Relational OLAP(ROLAP) and Hybrid OLAP(HOLAP).
Online Transaction Processing provides transaction applications in a 3 tier architecture. In addition, it administers day to day transaction of an organization. Applications of OLTP include in banking sector, airlines ticket booking, order entry, in shopping carts and in call centers fro updating customer information.
Lastly, we have learnt about the major differences between OLAP and OLTP. OLAP is subject oriented whereas OLTP is application oriented.
