What is data modeling and data mining? What is this used for?

What is data modeling and data mining?

Designing a model for data or database is called data modelling. Data is reposited in fact table and dimension table. Fact table consists of data about transaction and dimensional table consists of master data. Data model is used to design abstract model of database.

The process of obtaining the hidden trends is called as data mining. Data mining is used to transform the hidden into information. Data mining is also used in a wide range of practicing profiles such as marketing, surveillance, fraud detection.

What is data modeling and data mining? What is this used for?

Data modeling aims to identify all entities that have data. It then defines a relationship between these entities. Data models can be conceptual, logical or Physical data models. Conceptual models are typically used to explore high level business concepts in case of stakeholders. Logical models are used to explore domain concepts. While Physical models are used to explore database design.

Data mining is used to examine or explore the data using queries. These queries can be fired on the data warehouse. Data mining helps in reporting, planning strategies, finding meaningful patterns etc. it can be used to convert a large amount of data into a sensible form.
Data warehousing - Difference between ER Modeling and Dimensional Modeling.
Difference between ER Modeling and Dimensional Modeling - Dimensional modelling is very flexible for the user perspective.........
Data warehousing - What is snapshot with reference to data warehouse?
What is snapshot with reference to data warehouse? - A snapshot of data warehouse is a persisted report from the catalogue........
Data warehousing - What is degenerate dimension table?
What is degenerate dimension table? - The dimensions that are persisted in the fact table is called dimension table........
Post your comment