Explain meta data repository

Answer More Questions

1 year ago

Data Mining and Data Warehousing

What is Metadata?

Metadata are data about data. When used in a data warehouse, metadata are the data that define warehouse
Metadata are created for the data names and definitions of the given
Additional metadata are created and captured for time stamping any extracted data, the source of the extracted data, and missing fields that have been added by data cleaning or integration

A metadata repository should contain the following

A description of the structure of the data warehouse, which includes the warehouse schema, view, dimensions, hierarchies, and derived data definitions, as well as data mart locations and
Operational metadata, which include data lineage (history of migrated data and the sequence of transformations applied to it), currency of data (active, archived, or purged), and monitoring information (warehouse usage statistics, error reports, and audit trails).
The algorithms used for summarization, which include measure and dimension definition algorithms, data on granularity, partitions, subject areas, aggregation, summarization and predefined queries and
The mapping from the operational environment to the data warehouse, which includes source databases and their contents, gateway descriptions, data partitions, data extraction, cleaning, transformation rules and defaults, data refresh and purging rules, and security (user authorization and access control).
Data related to system performance, which include indices and profiles that improve data access and retrieval performance, in addition to rules for the timing and scheduling of refresh, update, and replication
Business metadata, which include business terms and definitions, data ownership information, and charging

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 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 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