Skip to content


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 (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 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 […]

error: Content is protected !!