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

when listing items that have an order of priority.

Answer from: Quest

answer: b

explanation:

Another question on Computers and Technology

Computers and Technology, 22.06.2019 18:30

All of the following are characteristics that must be contained in any knowledge representation scheme except

Answers: 3

Answer

Computers and Technology, 23.06.2019 06:00

What makes myhexadecimalnumber a child of mynumber? which methods does myhexadecimalnumber inherit directly from the mynumber class? what can an instance of the mynumber class do? what can an instance of the myhexadecimalnumber class do? which methods are overridden? why are they overridden? how many examples of overloading are there? why was this done? where is the super keyword used? what is it doing? why isn’t the incoming value set immediately in the second myhexadecimalnumber constructor? how many examples can you find of an inherited method being called?

Answers: 1

Answer

Computers and Technology, 23.06.2019 15:30

Brian wants to conduct an online search with a certain phrase. he intends to use the words books that belong to the 1800s in his search. how should he use the word that in his search?

Answers: 1

Answer

Computers and Technology, 24.06.2019 12:00

Jack is assisting his younger sibling mary with her mathematics assignment, which includes a study of the number system. jack explains to mary that whole numbers are counting numbers that could be used to record the number of fruits in a basket. which data type represents whole numbers? a.integers.b.floating-point numbers. c.strings.d.boolean

Answers: 1

Answer

You know the right answer?

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

Questions