Data Warehousing
Difference between Data Mining and Data Warehouse
What is Data warehouse? A data warehouse is a technique for collecting and managing data from...
OLTP is an operational system that supports transaction-oriented applications in a 3-tier architecture. It administers the day to day transaction of an organization. OLTP is basically focused on query processing, maintaining data integrity in multi-access environments as well as effectiveness that is measured by the total number of transactions per second. The full form of OLTP is Online Transaction Processing.
In this OLTP tutorial, you will learn:
Following are important characteristics of OLTP:
OLTP system is an online database changing system. Therefore, it supports database query such as insert, update, and delete information from the database.
Consider a point of sale system of a supermarket, following are the sample queries that this system can process:
Here is the architecture of OLTP:
This data helps you to discover data patterns, analyze raw data, and make analytical decisions for your organization's growth.
An example of the OLTP system is the ATM center. Assume that a couple has a joint account with a bank. One day both simultaneously reach different ATM centers at precisely the same time and want to withdraw the total amount present in their bank account.
However, the person that completes the authentication process first will be able to get money. In this case, the OLTP system makes sure that the withdrawn amount will be never more than the amount present in the bank. The key to note here is that OLTP systems are optimized for transactional superiority instead of data analysis.
Other examples of OLTP system are:
Here is the important difference between OLTP and OLAP:
OLTP | OLAP |
OLTP is an online transactional system. | OLAP is an online analysis and data retrieving process. |
It is characterized by large numbers of short online transactions. | It is characterized by a large volume of data. |
OLTP is an online database modifying system. | OLAP is an online database query management system. |
OLTP uses traditional DBMS. | OLAP uses the data warehouse. |
Insert, Update, and Delete information from the database. | Mostly select operations |
OLTP and its transactions are the sources of data. | Different OLTP databases become the source of data for OLAP. |
OLTP database must maintain data integrity constraints. | OLAP database does not get frequently modified. Hence, data integrity is not an issue. |
It's response time is in a millisecond. | Response time in seconds to minutes. |
The data in the OLTP database is always detailed and organized. | The data in the OLAP process might not be organized. |
Allow read/write operations. | Only read and rarely write. |
It is a market-orientated process. | It is a customer orientated process. |
Queries in this process are standardized and simple. | Complex queries involving aggregations. |
Complete backup of the data combined with incremental backups. | OLAP only need a backup from time to time. Backup is not important compared to OLTP |
DB design is an application-oriented example: Database design changes with the industry like retail, airline, banking, etc. | DB design is subject-oriented. Example: Database design changes with subjects like sales, marketing, purchasing, etc. |
It is used by Data critical users like clerk, DBA & Data Base professionals. | It is used by Data knowledge users like workers, managers, and CEO. |
It is designed for real time business operations. | It is designed for analysis of business measures by category and attributes. |
Transaction throughput is the performance metric | Query throughput is the performance metric. |
This kind of Database user allows thousands of users. | This kind of Database allows only hundreds of users. |
It helps to Increase user's self-service and productivity | Help to Increase the productivity of business analysts. |
Data Warehouses historically have been a development project which may prove costly to build. | An OLAP cube is not an open SQL server data warehouse. Therefore, technical knowledge and experience are essential to managing the OLAP server. |
It provides a fast result for daily used data. | It ensures that response to the query is quicker consistently. |
It is easy to create and maintain. | It lets the user create a view with the help of a spreadsheet. |
OLTP is designed to have fast response time, low data redundancy, and is normalized. | A data warehouse is created uniquely so that it can integrate different data sources for building a consolidated database |
Following are the pros/benefits of OLTP system:
Here are cons/drawbacks of OLTP system:
What is Data warehouse? A data warehouse is a technique for collecting and managing data from...
{loadposition top-ads-automation-testing-tools} ETL testing is performed before data is moved into...
{loadposition top-ads-automation-testing-tools} What is Business Intelligence Tool? BUSINESS...
What is Information? Information is a set of data that is processed in a meaningful way according to...
Reporting tools are software that provides reporting, decision making, and business intelligence...
Data visualization tools are cloud-based applications that help you to represent raw data in easy...