Advantages of data warehousing
State the different advantages of the data warehousing?
Expert
Following advantages are offered by the data warehousing:
a) It develops the quality and accessibility of the data. b) It capitalizes over the potential value of organization’s information. c) It combines the valuable archive data along with the latest data within the operational sources. d) It improves the amount of information which is available to the users. e) It reduces the requirement of the users in order to access the operational data. f) It decreases the strain on the IT departments, since they may gnerate one database to serve all the user groups.
Write down a short note on the functions of a reporting system?
Specify the types of join that are available?
Write brief note on E.F. Codd, and why is he noteworthy in the development of modern database systems?
Write down a short note on the difference between an ERD and EER.
Why do normalized tables need more complex SQL when SQL statements are employed in application programs?
Illustrates storing of data in stored procedures increase the access time?
Explain the term lattice of cuboids in brief.
How can you save the Business Objects document that may be accessed by all the users in the workgroup mode?
Illustrates the basic elements in ER models?
Explain the term precision in Data Structures? Answer: Precision considers as to the accuracy of the decimal portion of a value. It is the number of digits permitted
18,76,764
1941817 Asked
3,689
Active Tutors
1428999
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!