Computers and Technology, 17.08.2019 18:20 kelseeygee

Online transaction processing (oltp) and online analytical processing (olap) are similar mis strategies used to with business decision making. what is the primary difference between oltp and olap?

Answers: 3

Show answers

Answers

Answer from: isaiahmichel93081

OLTP ( On-line Transaction Processing )

As the name suggests, this system is designed for handling transactions on web applications.

Examples include Banking system.

OLAP ( On-line Analytical Processing )

As per the name, this system is developed for analyzing and reporting functions for web applications.

These systems form a part of data warehousing.

Examples include data mining for Banking system.

OLTP databases undergo ETL operations to form a part of OLAP system. Data from several OLTP database are extracted as per the requirements, transformed ( formatted and cleaned ) to fit the OLAP requirements, and loaded into the OLAP system.

Similarities

•Both OLTP and OLAP are designed for online processing and support web based applications.

•In both systems, processing is done on large scale owing to their online presence.

Differences

•OLTP is designed to handle daily operation. OLAP is designed for decision support.

•OLTP supports data update and data insert operations. OLAP supports data analysis.

•OLTP supports insert, update and delete operations only. OLAP supports data extraction to support decision making process.

•Transactions form the source of data. Several OLTPs form the source of data.

•In OLTP, transactions are shorter in nature. In OLAP, transactions are longer.

•In OLTP, processing time is shorter. In OLAP, processing time is longer.

•Data modification queries are simpler. Data analysis queries are complex in nature.

•OLTP are normalized up to third normal form. OLAP are not normalized.

•Data in OLTP system are frequently modified. Data in OLAP systems are not frequently modified.

•OLTP should maintain data integrity. Data integrity in OLAP is unaffected.

•OLTP stores only current data. OLAP stores historical data.

•OLAP systems must have periodic back up. OLTP back up is achieved by reloading the databases.

The major differences are discussed above to clarify the functioning of both the systems.

Answer from: Quest

What program is this in?

Answer from: Quest

Hdi4nfnfuhdjdurjfjc7fjrnckf snuck fhfjfkfmfjfk4jrhr

Another question on Computers and Technology

Computers and Technology, 22.06.2019 04:00

Which spereadsheet type will determine how well a bussiness has done over the past year

Answers: 1

Answer

Computers and Technology, 23.06.2019 01:10

Are special combinations of keys that tell a computer to perform a command. keypads multi-keys combinations shortcuts

Answers: 1

Answer

Computers and Technology, 23.06.2019 15:30

Write a program in plp assembly that counts up by one starting from zero (or one) inside a loop and writes this value to the leds every time the value is increased. the memory address of the leds is 0xf0200000. the table below shows the meaning and an example usage of the instructions covered in the video, plp instructions for project 1. instruction example usage meaning load immediate li $t0, 8 register $t0 is set to the value, 8. store word sw $t2, 0($t1) the value in register $t1 is used as the memory address. the value in register $t2 is copied into this memory address. add addiu $t4, $t3, 29 register $t4 is assigned the sum of 29 and the value in register $t3. jump j your_label_name the program jumps to the line following the label, "your_label_name: ". label your label name: defines a label called "your_label_name: " that can be jumped to

Answers: 2

Answer

Computers and Technology, 23.06.2019 17:30

Per the municipal solid waste report, what are the most common sources of waste (trash

Answers: 3

Answer

You know the right answer?

Online transaction processing (oltp) and online analytical processing (olap) are similar mis strateg...

Questions