Data warehouse is a technology that aggregates structured data from one or more sources so that it can be compared and analyzed rather than transaction processing, whereas Data mining is the process of analyzing unknown patterns of data.
A data warehouse is a centralized pool of data. Data warehouse is basically a repository where large amount of data is stored . The advantage of data warehouse is that we can archive the data that is not used in a long time.
data are rarely deleted
There are various features of Data Mining. Some of them are as follows :-Data mining discovers hidden information in your data and also will help marketing companies build models based on historical data to predict who will respond to the new marketing campaigns such as direct mail, online marketing campaign…etc.Data mining gives financial institutions information about loan information and credit reporting.Data mining is a powerful tool that can help you find patterns and relationships within your data.Data mining can confirm or qualify such empirical observations in addition to finding new patterns that may not be immediately discernible through simple observation.Data mining helps government agency by digging and analyzing records of financial transaction to build patterns that can detect money laundering or criminal activities.
Sageworks Industry Data is a comprehensive, private company industry data platform that allows users to gather real-time industry data and specific industry recommendations. This product suite includes private company benchmarking, data mining, and industry-specific advice for improvement.
The most common types of business intelligence software are spreadsheets, reporting and querying software, OLAP, digital dashboards, data mining, data warehousing, decision engineering, process mining, business performance management, and local information systems. Each suits specific needs of a business or individual.
Data warehouse is the database on which we apply data mining.
it's data warehouse....data warehouse: it is a collection of multiple databases or it it is repository of data.data mining it is the process of extracting data from data warehouse.
catch important data from data warehouse.
mining the data is called data mining. Mining the text is called text mining
difference between Data Mining and OLAP
A data warehouse functions as a repository for all the data held by an organisation. The main functions are to reduce cost of data storage, facilitate data mining, and facilitate ability to back up data at an organisational level.
One of the biggest benefits is that you can archive your data to a data warehouse. This can keep your main "production" database smaller which can provide some performance benefits. Also you can use the data warehouse to run complex queries and data-mining without adverse effects on the performance of your "production" application.
data warehouse A data warehouse is the main repository of an organization's historical data, its corporate memory. It contains the raw material for management's decision support system. The critical factor leading to the use of a data warehouse is that a data analyst can perform complex queries and analysis, such as data mining, on the information without slowing down the operational systems. data mining The development of computational algorithms for the identification or extraction of structure from data. This is done in order to help reduce, model, understand, or analyze the data. Tasks supported by data mining include prediction, segmentation, dependency modeling, summarization, and change and deviation detection. Database systems have brought digital data capture and storage to the mainstream of data processing, leading to the creation of large data warehouses.
A data warehouse has multiple functional areas whereby a centralized organizational unit is responsible for implementing it. On the contrary, data marts focus on particular functional areas hence are simple forms of a data warehouse.
CHARECTERISTICS OF DATA MINING CHARECTERISTICS OF DATA MINING
A data warehouse is the main repository of an organization's historical data, its corporate memory. * Data warehouses enhance end-user access to a wide variety of data. * Decision support system users can obtain specified trend reports, e.g. the item with the most sales in a particular area within the last two years. * Data warehouses can be a significant enabler of commercial business applications, particularly customer relationship management (CRM) systems.A data warehouse is a logical collection of information gathered from many different operational databases used to create business intelligence that supports business analysis activities and decision making tasks.
Data warehouse is a large repository of data. The data may or may not be of any use. Partitioning in Data warehouse can be done by forming clusters and then forming groups.Partitioning in datawarehouse can be done by forming clusters. Partitioning can be done on the basis of relation between the data.