MOLAP Multidimensional Online Analytical processing: In MOLAP data is stored in form of multidimensional cubes and not in relational databases.....
|
Data warehousing is merely extracting data from different sources, cleaning the data and storing it in the warehouse......
|
Deleting data from data warehouse is known as data purging. While loading data into staging or in the target table fresh data loading may be needed every time.....
|
A data cube stores data in a summarized version which helps in a faster analysis of data. The data is stored in such a way that it allows reporting easily......
|
OLTP: Online Transaction and Processing helps and manages applications based on transactions involving high volume of data........
|
Data mining can be used in a variety of fields/industries like marketing, advertising of goods, products, services, AI, government intelligence......
|
A stage of data mining is a logical process for searching large amount information for finding important data......
|
"Discreet data can be considered as defined or finite data. E.g. Mobile numbers, gender. Continuous data can be considered.....
|
Models in Data mining help the different algorithms in decision making or pattern matching.......
|
Data warehousing can be used for analyzing the business needs by storing data in a meaningful form......
|
A decision tree is a tree in which every node is either a leaf node or a decision node. This tree takes an input an object and outputs some decision.....
|
Naive Bayes Algorithm is used to generate mining models. These models help to identify relationships between input columns and the predictable columns....
|
Clustering algorithm is used to group sets of data with similar characteristics also called as clusters.....
|
Time series algorithm can be used to predict continuous values of data. Once the algorithm is skilled to predict a series of data......
|
Association algorithm is used for recommendation engine that is based on a market based analysis.....
|
Sequence clustering algorithm collects similar or related paths, sequences of data containing events......
|
Data mining is used to examine or explore the data using queries. These queries can be fired on the data warehouse.....
|
SQL Server data mining offers Data Mining Add-ins for office 2007 that allows discovering the patterns and relationships of the data.....
|
Data mining extension is based on the syntax of SQL. It is based on relational concepts and mainly used to create and manage the data mining models......
|
A data mining extension can be used to slice the data the source cube in the order as discovered by data mining......
|