OLTP(On-Line Transaction Processing)
It is a set of information which processes a data transaction in a database system that manage transaction-oriented applications, typically for data entry and retrieval transaction processing.
OLAP(On-Line Analytical Processing)
OLAP is an approach to quickly provide answers to analytical queries that are multi-dimensional in nature.It supports the regular retrieving of information depends upon the user input system in real time.
OLTP Vs OLAP
In general we can assume that OLTP systems provide source data to data warehouses, whereas OLAP systems help to analyze it.
| OLTP | OLAP |
| Characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE). | Characterized by relatively low volume of transactions. |
| OLTP systems is put on very fast query processing, maintaining data integrity.
in multi-access environments. |
Queries are often very complex and involve aggregations. |
| Effectiveness measured by number of transactions per second. | For OLAP systemsa response time is an effectiveness measure. |
Before OLAP technology was well developed, data had to be extracted from databases using “queries”.This meant that the analyst had to structure a request to the database for the information desired, and then
submitted this query to the database server.That server would processing query and return the results.
Depending on the size of the database and the data requested, this query could take minutes or hours to complete.In this sense, the “online” aspect of this type of reporting is questionable.For this purpose OLAP was developed.
In the next article we will see how to create a analysis services(that is creating cube in OLAP) in .net