CLUSTERING IN DATA MINING

Clustering is a division of data into groups of similar objects. Each group, called cluster, consists of objects that are similar between themselves and dissimilar to objects of other groups. Representing data by fewer clusters necessarily loses certain fine details (akin to lossy data compression), but achieves simplification. It represents many data objects by few [...]

Continue reading →

Things to be remembered in Case Analysis

Case Analysis has always been an important facet of MBA Curriculum. But it also plays a vital role in professional sphere. Every company comes across varied types of issues, which often distorts the functioning of the various departments. One has to analyze a case not from the point of view of academics but something that [...]

Continue reading →

Data Mart

A Data Mart is a customized smaller version of a Data Warehouse. Data Marts are smaller and focused on the customization needs of a particular department and the end users. These provide inputs to the Decision SupportĀ  System for the department. Purpose of a Data Mart : The collection of numerous Data Marts together constitutes [...]

Continue reading →

Data Modeling

Data Modeling is defined as the process whereby, integrated data obtained from divergent sources is modeled to map to the users perspective. There are different types of Data Models that can be used to organize data to target specific Data Warehousing applications. A dimension is any category of stored information, for example a product. It [...]

Continue reading →

Data warehouse

A Data Warehouse is a repository database that efficiently extracts data from existing systems for the rapid analysis and reporting of information in a business enterprise. Operations, such as querying and report generation can be performed on the data stored inĀ  Data Warehouse. These qeries may be analytical, ad hoc, or statistical in nature. Various [...]

Continue reading →

Data Warehousing

Business success is determined by the ability to take timely and accurate decisions. The accuracy of these decisions, in turn, is dependent on the information that is made available to the decision makers. With the wide variety of data being generated by the business, the problems that emerge include converting different formats into one common [...]

Continue reading →

Database Files in SQL Server

Each database is stored as a set of files on the hard disk of the computer. These files include : Primary data file : The primary data file contains the database objects. The primary file can be used for the system tables and objects, and the secondary file can be used to store user data [...]

Continue reading →