What is Virtual Warehouse?

Answer More Questions

4 weeks ago

A virtual warehouse is a set of views over operational databases. For efficient query processing, only some of the possible summary views may be materialized. A virtual warehouse is easy to build but requires excess capability on operational database servers.

5 5

Bench Partner

Bench Partner

Sep 25, 2021

More related questions

1. Why Data Preprocessing is needed and which are the techniques used for data Preprocessing?

2. Explain Common Hadoop Shell Commands

3. What is Hadoop Architecture and Storage?

4. What is Big Data and Characteristics of Big Data V3s?

5. Explain Clustering, Spatial mining, Web mining, Text mining in brief

6. Explain usage of Data warehousing for information processing, analytical processing, and data Mining

7. What do you mean by data mart? What are the different types of data mart?

8. Explain meta data repository

9. Explain Data Warehouse Design Process in Detail

10. What is Data Warehouse? Explain it with Key Feature

11. What is Business Intelligence? Explain Business Intelligence in today’s perspective

12. How does the ANSI-SPARC architecture promote logical and physical data independence in databases?

13. What are the Major Issues and Challenges of Data Mining?

14. What is HOLAP?

15. What is Enterprise Warehouse?

16. What is Data Mart?

17. What are dependent and independent data marts?

18. What is VLDB?

19. What are Research prototypes?

20. What is the difference between generic single-task tools and generic multi-task tools?

21. What are the areas in which data warehouses are used in present and in future?

22. What is DMQL?

23. What are the factors involved while choosing data mining system?

24. What is Text mining?

25. What is spatial data mining?

26. What are the DB Miner tool in data mining?

27. How data mining is used in health care analysis?

28. How data mining is used in banking industry?

29. Explain the types of data mining.

30. What does audio data mining mean?

31. What is OLAP?

32. What is OLTP?

33. Define Chameleon method?

34. What is CURE?

35. Differentiate Agglomerative and Divisive Hierarchical Clustering?

36. What is Hierarchical method?

37. What is CLARA and CLARANS?

38. What do u mean by partitioning method?

39. Define nominal, ordinal and ratio scaled variables?

40. Define Binary variables? And what are the two types of binary variables?

41. What are interval scaled variables?

42. What are the different types of data used for cluster analysis?

43. What are the requirements of cluster analysis?

44. What are the fields in which clustering techniques are used?

45. What is Clustering and Cluster Analysis?

46. What are the techniques to improve the efficiency of Apriori algorithm?

47. How to generate association rules from frequent item sets?

48. What is the purpose of Apriori Algorithm?

49. Describe the different classifications of Association rule mining.

50. Define support and confidence in Association rule mining.

51. How is a data warehouse different from a database?

52. Describe challenges to data mining regarding data mining methodology and user interaction issues.

53. Classifications of Data mining systems

54. What is Cluster Analysis?

55. What are the advanced database systems?

56. What is Descriptive model?

57. What is Predictive model?

58. What is the purpose of Data mining Technique?

59. What is Genetic algorithm?

60. What is meta learning?

61. Give few statistical techniques in data mining

62. What are the some of the data mining techniques?

63. What is the Architecture of a typical data mining?

64. What is the use of the knowledge base?

65. What are the steps involved in KDD?

66. What is KDD?

67. What are the alternative terms for data?

Questions Bank

View all Questions