Data Mining Techniques
Data Mining is the process of extracting useful information and patterns from enormous data. Data Mining includes collection, extraction, analysis and statistics of data. It is also known as Knowledge discovery […]
Phases of Knowledge Discovery in DataBases (KDD)
Knowledge Discovery Some people don’t differentiate data mining from knowledge discovery while others view data mining as an essential step in the process of knowledge discovery. Here is the list […]
Success Factors of Data Warehousing
Expectations are communicated to the users IT is often unwilling or afraid to tell the users what they will be getting and when. Users should be told about the following: […]
Data Warehousing and Architecture
Data warehousing is the process of constructing and using a data warehouse. A data warehouse is constructed by integrating data from multiple heterogeneous sources that support analytical reporting, structured and/or […]
Data Marts
A data mart is a repository of data that is designed to serve a particular community of knowledge workers. The difference between a data warehouse and a data mart can be confusing because the […]
OLTP & OLAP
OLTP (On-line Transaction Processing) is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE). The main emphasis for OLTP systems is put on very fast query processing, maintaining […]
Data Manipulation Language
A Data Manipulation Language (DML) is a family of computer languages including commands permitting users to manipulate data in a database. This manipulation involves inserting data into database tables, retrieving […]
Constraints
Constraints are the rules enforced on the data columns of a table. These are used to limit the type of data that can go into a table. This ensures the […]
Creating Databases and Tables
The SQL CREATE DATABASE statement is used to create a new SQL database. Syntax The basic syntax of this CREATE DATABASE statement is as follows − CREATE DATABASE DatabaseName; Always the database […]
