Please answer all of three questions blew, thank you so much: 1. View the video

Question

Please answer all of three questions blew, thank you so much:

1. View the video production at the link shown below and list five facts that you learned concerning these two information systems.

https://www.youtube.com/watch?v=q5f1xOA9IQQ

2.

Using one or more of the business or organizational entities listed below discuss a multi - dimensional analysis that can be performed on the entities with any or all of the above operations.

Business / Organizational Entities

•         a global parcel shipping company     •         a sports memorabilia firm

•         a nationwide college or university     •         an office supply superstore

•         a talent agency                              •         a vitamin and health shop

3.

Visit the home page of the Barnes and Noble Web site and examine especially the links towards the bottom portion of the page.

https://www.barnesandnoble.com

Explanation / Answer

Solution 1 : Five Facts :

(a) Inspite of containing less number of transactions , OLAP ( Online Analytical Processing ) involves complex calculations because it stores data in multidimensional schemas.

(b)  Inspite of containing large number of transactions , OLTP ( Online Transaction Processing ) involves easier and faster query processing.

(c) OLTP provides more data integrity than OLAP.

(d) OLAP measures its effectiveness by measuring number of response time , whereas OLTP measures its effectiveness by measuring number of transaction processed.

(e) In OLTP , data and joins are normalized because of availability of few indexes for performance optimization. whereas in OLAP , data and joins are de-normalized because of availability of large indexes for performance optimization.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.