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.
Can we have a report with several data providers?
Explain the hot backup in case of Oracle.
State the different steps of data warehouse design process.
List out the various detected patterns.
How can you save the Business Objects document that may be accessed by all the users in the workgroup mode?
Give a brief introduction of the term Dimensional Modeling?
What do you understand by the term foreign key in DBMS, and why is it employed for?
Provide a brief introduction of the term ‘Data warehousing ’?
How must you modify the function to handle error?
Write a brief note on the differences between a data warehouse and data mart?
18,76,764
1930844 Asked
3,689
Active Tutors
1449369
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!