OLAP and OLTP
Explain the following term: a) OLAP b) OLTP
Explain the following term:
a) OLAP
b) OLTP
Expert
OLTP:
In case, an on-line operational database system is utilized for the proficient retrieval and storage and management of the huge amounts of data, then the system is known as on-line transaction processing.
OLAP:
Data warehouse systems serves users (or) knowledge workers within the role of data analysis and decision-making. Such systems may organize and represent the data in several formats. These systems are called as the on-line analytical processing systems.
Describe briefly the difference between pessimistic locking and optimistic locking?
Write down security domain in Business Objects?
Briefly describe the term dimension tables and fact tables?
What is the main dissimilarity between horizontal and vertical partitioning?
Explain the term intelligent binning?
States the term Mirror Activator Disk mirroring?
Explain briefly the term data mart?
In which case the functional dependencies are not equations? Describe briefly?
Which member function places a new node on the end of the linked list? Answer: appendNode(): This member function places a new node on the end of t
What are the main tasks of a Server?
18,76,764
1942561 Asked
3,689
Active Tutors
1411830
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!