What is Data Warehouse? Explain it with Key Feature

Answer More Questions

1 year ago

Data Mining and Data Warehousing

What is Data Warehouse?

Data warehousing provides architectures and tools for business executives to systematically organize, understand, and use their data to make strategic
A data warehouse refers to a database that is maintained separately from an organization’s operational
Data warehouse systems allow for the integration of a variety of application
They support information processing by providing a solid platform of consolidated historical data for
According to William H. Inmon, a leading architect in the construction of data warehouse systems, “A data warehouse is a subject-oriented, integrated, time-variant, and nonvolatile collection of data in support of management’s decision making process”
The four keywords, subject-oriented, integrated, time-variant, and nonvolatile, distinguish data warehouses from other data repository systems, such as relational database systems, transaction processing systems, and file systems.

Subject-oriented

A data warehouse is organized around major subjects, such as customer, supplier, product, and
Rather than concentrating on the day-to-day operations and transaction processing of an organization, a data warehouse focuses on the modeling and analysis of data for decision
Data warehouses typically provide a simple and concise view around particular subject issues by excluding data that are not useful in the decision support process.

Integrated

A data warehouse is usually constructed by integrating multiple heterogeneous sources, such as relational databases, flat files, and on-line transaction records.
Data cleaning and data integration techniques are applied to ensure consistency in naming conventions, encoding structures, attribute measures, and so on.

Time-variant

Data are stored to provide information from a historical perspective (e.g., the past 5–10 years).
Every key structure in the data warehouse contains, either implicitly or explicitly, an element of

Nonvolatile

A data warehouse is always a physically separate store of data transformed from the application data found in the operational
Due to this separation, a data warehouse does not require transaction processing, recovery, and concurrency control
It usually requires only two operations in data accessing: initial loading of data and access of

5 5

Raju Singhaniya

Raju Singhaniya

Oct 14, 2021

More related questions

1. The Term “Business Intelligence” is also used as an alternative term for Data Mining. Justify appropriateness of term with comparison of the term “Artificial Intelligence”

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

3. Explain Common Hadoop Shell Commands

4. What is Hadoop Architecture and Storage?

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

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

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

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

9. Explain meta data repository

10. Explain Data Warehouse Design Process in Detail

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 Virtual Warehouse?

19. What is VLDB?

20. What are Research prototypes?

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

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

23. What is DMQL?

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

25. What is Text mining?

26. What is spatial data mining?

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

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

29. How data mining is used in banking industry?

30. Explain the types of data mining.

31. What does audio data mining mean?

32. What is OLAP?

33. What is OLTP?

34. Define Chameleon method?

35. What is CURE?

36. Differentiate Agglomerative and Divisive Hierarchical Clustering?

37. What is Hierarchical method?

38. What is CLARA and CLARANS?

39. What do u mean by partitioning method?

40. Define nominal, ordinal and ratio scaled variables?

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

42. What are interval scaled variables?

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

44. What are the requirements of cluster analysis?

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

46. What is Clustering and Cluster Analysis?

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

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

49. What is the purpose of Apriori Algorithm?

50. Describe the different classifications of Association rule mining.

51. Define support and confidence in Association rule mining.

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

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

54. Classifications of Data mining systems

55. What is Cluster Analysis?

56. What are the advanced database systems?

57. What is Descriptive model?

58. What is Predictive model?

59. What is the purpose of Data mining Technique?

60. What is Genetic algorithm?

61. What is meta learning?

62. Give few statistical techniques in data mining

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

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

65. What is the use of the knowledge base?

Questions Bank

View all Questions