Skip to main content

Data Warehouse and Warehousing || Basic To Advance Concepts



DATA WAREHOUSE
Data warehouse is a collection of data that support decision making processes. It provide the following features are
·        Subject oriented
·        Consistent
·        Shows its evaluations over time
·        Non volatile
A data warehouse is a central location where consolidated data from multiple locations are stored. It is like a relational database design for analytical processing.

DATA WAREHOUSING
Data warehousing is the act of organizing data and storing data in a way so as to make its retrieval efficient and insightful. Also called data as the process of transferring  data into information. Is a collection of method, techniques, and tools to support knowledge workers to conduct data analysis that help with performing decision making process and improving information resources.

Comments

Popular posts from this blog

Components of Computer System

A system is defined as a set of interacting elements, responding to inputs so as to produce outputs. The computer system also consists of the following elements or components. Software Hardware Firmware Humanware   Software All the intangible components of the computer system are known as software In other words, we can say that all computer programs and applications run behind the monitor screen, are known as software. Computer software is a term that describes computer programs. Example   Microsoft-windows (all operating system software) and notepad, MS office suite, window media player(application software). Software is further divided into two parts these are following 1) system software 2) application software Hardware All tangible component of a computer system is known as hardware. In other words, computer hardware is the collection of physical parts of the computer system. Example  CPU(Microprocessor), monitor, keyboard, mouse, speaker, pr

Characteristics Of Computers System || You Should Know

The characteristics of computers that have made them so powerful and universally useful are speed, accuracy, diligence, versatility, and storage capacity. Let us discuss them briefly. Speed: -  As you know the computer can work very fast. It takes only a few seconds for calculations that we take hours to complete. You will be surprised to know that a computer can perform millions (1,000,000) of instructions and even more per second. Therefore, we determine the speed of the computer in terms of a microsecond (10-6 part of a second) or nanosecond (10 to the power -9 part of a second). From this, you can imagine how fast your computer performs work.  Diligence:   A computer is free from tiredness, lack of concentration, fatigue, etc. It can work for hours without creating any errors. If millions of calculations are to be performed, a computer will perform every calculation with the same accuracy. Due to this capability, it overpowers human beings in the

Block Diagram of Computer|| Basic Explanation

A typical computer system irrespective of its size, class or type consists of hardware and software, integrated and synchronized together to perform computational work or data processing. Computer anatomy is concerned with the way the various functional units operate and how they connected together to form the computer system. A computer system consists of the following functional units : 1)  Input unit 2) Memory/Storage unit 3) CPU(central processing unit) 4) Output unit