Coupon Accepted Successfully!


Data Warehouse

A data warehouse is a repository of an organization's electronically stored data. Data warehouses are designed to facilitate reporting and analysis. A data warehouses are operational systems which perform day-to-day transaction processing.

Benefits of Data Warehousing

Some of the benefits that a data warehouse provides are as follows: 
  • A data warehouse provides a common data model for all data of interest regardless of the data's source. This makes it easier to report and analyze information than it would be if multiple data models were used to retrieve information such as sales invoices, order receipts, general ledger charges, etc. 
  • Prior to loading data into the data warehouse, inconsistencies are identified and resolved. This greatly simplifies reporting and analysis. 
  • Information in the data warehouse is under the control of data warehouse users so that, even if the source system data is purged over time, the information in the warehouse can be stored safely for extended periods of time. 
  • Because they are separate from operational systems, data warehouses provide retrieval of data without slowing down operational systems. 
  • Data warehouses facilitate decision support system applications such as trend reports (e.g., the items with the most sales in a particular area within the last two years), exception reports, and reports that show actual performance versus goals. 
  • Data warehouses can work in conjunction with and, hence, enhance the value of operational business applications, notably customer relationship management (CRM) systems.

Function and Subroutine

  • Function: A function is a self contained block of code that perform a particular task. Every function has a unique name In ‘’C’’ function is classified into two categories.
    1. Library function or inbuilt function and
    2. User define function. Main() is example of user define function and printf(), scanf() are the example of library function.
  • Subroutine: A subroutine is a group of statements that can be executed from different points in a program. Syntax for defining subroutine varies from one language to another language.

Generation of Computer

1st Generation (1946 - 1958) Machine Language
2nd Generation (1959 - 1964) Assembly Language
3rd Generation (1965 - 1970) High Level Language
4th Generation (1971 - ) SQL (Structured query language)
5th Generation (today) Still under development phase



  1. C is known as middle level programming language. It is also known as procedural language. It is a combination of high level and low level.
  2. C++:- C++ is a high level language (OOPS) and also it is a object oriented programming language. Java is another Object oriented programming language. 
  3. Fortran:- It is known as Formula translation. It is used for scientific application.
  4. COBOL:- stands for common business oriented language. Used for record keeping and data management in business organizations.
  5. BASIC:- stands for beginner’s all purpose symbolic instruction code. First language designed for non-professional programmers.
  6. PASCAL:- Named after French inventor – Blaise Pascal. First developed as teaching tools.

Test Your Skills Now!
Take a Quiz now
Reviewer Name