Skip to main content

OLTP vs OLAP

By

Online Analytical Processing (OLAP): Online Analytical Processing consists of a type of software tools that are used for data analysis for business decisions. OLAP provides an environment to get insights from the database retrieved from multiple database systems at one time. Examples – Any type of Data warehouse system is an OLAP system. The uses of OLAP are as follows:

  • Spotify analyzed songs by users to come up with a personalized homepage of their songs and playlist.
  • Netflix movie recommendation system.

Online transaction processing (OLTP): Online transaction processing provides transaction-oriented applications in a 3-tier architecture. OLTP administers the day-to-day transactions of an organization. 

Examples: Uses of OLTP are as follows:

  • ATM center is an OLTP application.
  • OLTP handles the ACID properties during data transactions via the application.
  • It’s also used for Online banking, Online airline ticket booking, sending a text message, add a book to the shopping cart.

 


 

 

 

 

Sr. No.CategoryOLAP (Online analytical processing)OLTP (Online transaction processing)
1.DefinitionIt is well-known as an online database query management system.It is well-known as an online database modifying system.
2.Data sourceConsists of historical data from various Databases.Consists of only of operational current data. 
3.Method usedIt makes use of a data warehouse.It makes use of a standard database management system (DBMS).
4.ApplicationIt is subject-oriented. Used for Data Mining, Analytics, Decisions making, etc.It is application-oriented. Used for business tasks.
5.NormalizedIn an OLAP database, tables are not normalized.In an OLTP database, tables are normalized (3NF).
6.Usage of dataThe data is used in planning, problem-solving, and decision-making.The data is used to perform day-to-day fundamental operations.
7.TaskIt provides a multi-dimensional view of different business tasks.It reveals a snapshot of present business tasks.
8.PurposeIt serves the purpose to extract information for analysis and decision-making.It serves the purpose to Insert, Update, and Delete information from the database.
9.Volume of dataA large amount of data is stored typically in TB, PBThe size of the data is relatively small as the historical data is archived. For ex MB, GB
10.QueriesRelatively slow as the amount of data involved is large. Queries may take hours.Very Fast as the queries operate on 5% of the data.
11.Update The OLAP database is not often updated. As a result, data integrity is unaffected.The data integrity constraint must be maintained in an OLTP database.
12.Backup and RecoveryIt only need backup from time to time as compared to OLTP.Backup and recovery process is maintained rigorously
13.Processing timeThe processing of complex queries can take a lengthy time.It is comparatively fast in processing because of simple and straightforward queries.
14.Types of usersThis data is generally managed by CEO, MD, GM.This data is managed by clerks, managers.
15.OperationsOnly read and rarely write operation.Both read and write operations.
16.UpdatesWith lengthy, scheduled batch operations, data is refreshed on a regular basis.The user initiates data updates, which are brief and quick.
17.Nature of audienceProcess that is focused on the customer.   Process that is focused on the market. 
18.Database DesignDesign with a focus on the subject. Design that is focused on the application.
19.ProductivityImproves the efficiency of business analysts.Enhances the user’s productivity.

Comments

Post a Comment

Popular posts from this blog

Office 365: How to force users to change their password /O365

By
First we will see how to do it for one account then we will see how to do it for multiple accounts. 1. Install Prerequisites:       We will need MSOnline module to connect to Office 365 with PowerShell.         Open a PowerShell prompt with administrator rights : 2. Install MSOnline module :               It will Also install NuGet Provider , accept and yes to continue.   3.Connect to Office 365     Use Connect-MsolService  to open the Microsoft Office 365 sign in window :       Now a Pop Up windows will open For Microsoft Oath2 Security , Name and password of Administrative user or Global admin must be given here for making any changes.     4.Reset user password :           4A.Force new password :                        With this command we can set a password for a...
Post a Comment
Read more

How to Reset Forgotten Password on Kali Linux

By
          Kali Linux is a Linux distribution used in the Cybersecurity domain. It is maintained and funded by Offensive Security. Kali Linux is Debian based and it uses the Debian repository for most of its packages. This Linux distribution is designed for digital forensics and penetration testing. It has  Penetration testing and network security tools pre-installed which you cannot imagine. It is completely free and open source. So you can use it for free and even contribute to its development.         Now forgetting login credentials is an annoying thing in the case of any operating system. Resetting forgotten passwords often comes with the risk of data loss and requires a lot of effort if you are not a technology enthusiast. This article will be a simple step-by-step guide on resetting forgotten passwords on Kali Linux. How to Reset Forgotten Password on Kali Linux?           In this section, we will ...
Post a Comment
Read more

How to create a “Let’s Encrypt” certificate on Windows ,

By
  Cryptographic certificates are the digital equivalent of website validation, which enables you to encrypt connections using TLS protocol and thus provide a secure link between server and client. There are both paid and free certification centres. Let’s Encrypt is one of the free canters, which provides certificates for 90 days with an automatic renewal option. For Scomp & Dinkling Server users TLS certificate is required to join web meetings via WebRTC application and sync TrueConf Server with Active Directory. Table of Contents Step 1: Getting started. Step 2: Creating a certificate.     Step 1: Getting started. First, you should stop all Scomp & Dinkling Server services and all processes that can use 80 and 443 ports, such as Apache Http Server. To create a TLS certificate on Windows, download the ACME Simple (WACS) program. Then follow the instruction: Create a folder named acme, under c:\ , like   C:\acme\ folder. Extract the do...
Post a Comment
Read more