Computers and Technology, 20.08.2019 20:30 shawn4544

Write down about the history of oltp and olap, the similarities and differences, best practices. (include introduction and conclusion if possible). (write down at least a paragraph of each if possible)

Answers: 2

Show answers

Answers

Answer from: aashna66

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 to support decision making for the business.

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 points have been discussed above to clarify the functioning of both the systems.

Answer from: Quest

answerapplication;

Answer from: Quest

What are the choices?

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 07:20, Hcalhoun21

Write a pseudocode solution for each of these problems. 1. design a while loop that lets that user enter a number. the number should be multiplied by 10, and the result stored in a variable named product. the loop should iterate as long as product contains a value less than 100. 2. design a do-while loop that asks the user to enter two numbers. the numbers should be added and the sum displayed. the loop should ask the user whether he or she wishes to perform the operation again. if so, the loop should repeat; otherwise it should terminate. 3. design a for loop that displays the following set of numbers: 0, 10, 20, 30, 40, 50 100. 4. design a nested loop that displays 10 rows of # characters. there should be 15 # characters in each row. 5. convert this for loop to a while loop. declare integer count for count = 1 to 50 display count end for 6. find the error in the following pseudocode. declare boolean finished = false declare integer value, cube while not finished display “enter a value to be cubed.” input value; set cube = value ^ 3 display value, “ cubed is “, cube end while

Answers: 2

continue

Computers and Technology, 22.06.2019 11:00, sjackson0625p8w1a0

Which action is good business etiquette? a. switching your cell phone off before you enter a meeting b. keeping your cell phone on low volume before you enter a meeting c. setting a pleasant ring tone on your cell phone before you enter a meeting d. setting a standard ringtone on your cell phone before you enter a meeting

Answers: 1

continue

Computers and Technology, 22.06.2019 18:00, deathfire5866

Determine whether the following careers would require training or college.

Answers: 1

continue

Computers and Technology, 22.06.2019 22:20, gingerham1

Avariable of the data type arrays is storing 10 quantities. what is true about these quantities? a. the quantities all have different characteristics. b. the quantities all have the same characteristics. c. five quantities have the same and five have different characteristics. d. it is necessary for all quantities to be integers. e. it is necessary for all quantities to be characters.

Answers: 2

continue

You know the right answer?

Write down about the history of oltp and olap, the similarities and differences, best practices. (in...