image_pdfimage_print

Data Warehouse and Data Mining

1)Data Mining: Data mining, the extraction of hidden predictive information from large databases, is a powerful new technology with great potential to help companies focus on the most important information in their data warehouses. Data mining... Read more

Normalization

Normalization: It is the process of removing redundant data from your tables in order to improve storage efficiency, data integrity and scalability. This improvement is balanced against an increase in complexity and potential performance losses... Read more

Entity Relationship Model Part-2

Relationship: A relationship is an association among several entities. Relationship Set: A relationship set is a set of relationships of the same type. Relationship Type: A relationship type defines a set of associations among entities... Read more

Entity Relationship Model Part-1

Database Model: Logical structure of a database and fundamental determines in which manner data can be stored, organized and manipulated. 1)Hierarchical Model: Data is organized in tree like structure, implying a single parent for each... Read more

Introduction of Database

Data: Facts, figures, statistics etc. Record: Collection of related data items. Table or Relation: Collection of related records. Database: Collection of related relation/data. In database, data is organized strictly in row and column format.The columns are called Fields, Attributes or Domains.... Read more