online analytical processing (olap) and online transaction processing (oltp) and types of OLAP

on January 17, 2019 data warehousing and mining 1 comment

online analytical processing (olap) and online transaction processing (oltp) and types of OLAP

olap:- The full name of olap is Online Analytical Processing
Online analytical processing is database organisation process in which large business databases organized and support intelligence.
olap is online database querying system.
olap is what works with historical data. Data in olap is not normalized, meaning data is redundant.
olap is used to analyze the data and the data remains stored in the multi-dimensional schema. The data in it is non-volatile.

online analytical processing (olap) and online transaction processing (oltp) and types of OLAP

It is based on the multi-dimensional data model that allows used to analyze database information from multiple database systems at one time.
It allows users and analysts to get information through fast consistent and interactive access to information.
olap applies consolidation data; olap data comes from the various olap databases.
olap is a class of systems, which provide answers to multi dimensional quarries.
olap tools enable users to analyze multidimensional and data interactively from multiple perspectives. olap consist of three basic analytical operations.
Consolidation (roll-up), drill-down, slicing and dicing.
olap is computer processing a user to easily and selectively extract and view data from different points of view.
olap deals with historical data or archival data. olap is charactererized by relatively low volume of .

online analytical processing (olap) and online transaction processing (oltp) and types of OLAP
Types of olap:-
1) Relational olap(ROLAP)
2) Multi dimensional olap(MOLAP)
3) Hybrid olap(HOLAP)
4) Specialized SQL servers

online analytical processing (olap) and online transaction processing (oltp) and types of OLAP
1. Relational olap:-To store and manage warehouse data.
2.Multi dimensional olap:-MOLAP uses based multi dimensional storage engines for multi dimensional view of data.
3. Hybrid olap(HOLAP):-Hybrid olapis a combination of both ROLAP and OLAP.
4. Specialized SQL servers:-SQl stands for structured query language so sql servers are used to provide data processing by query processing with the use of sql queries.

oltp: Online Transaction Processing
oltp is a class of information system that facilitates and manages transaction oriented applications, typically for data entry and retrieval transaction processing on a management system.
It works with original ie operational data and oltp processes the transaction for each day.
oltp is online database modifying system.

online analytical processing (olap) and online transaction processing (oltp) and types of OLAP
For example: - Whatever process is taken out of the bank, such as: - inserting atm card, inserting PIN code, etc., comes inside oltp.
It is used to store data at a faster speed. In it the volatile data and current data are executed and there is no historical data and oltp has a detailed data store.
online analytical processing (olap) and online transaction processing (oltp) and types of OLAP

Data in the oltp database is normalized and this means that the data is not redundant (extra).
oltp is characterized by a large of short on-line transaction (INSERT, UPDATE, and DELETE).
The main emphasis for oltp systems is fast query processing , access environment and an effectiveness measured by number of transactions per second.
In oltp database there is a detailed and current data and schema used to store transactional database is the entity model. It involves ovaries accessing individual record like update your Email in company database.