what is dataware house?

Question

what is data ware house

Answer 1

It is a computer program that is used to categorise and store huge amounts of data. The data is stored in files and you can find what you need quickly by running something called a 'query' to extract the information you are looking for.

All companies will use a data warehouse of some description to organise their data for example: Customer details, supplier details, sales information, customer order information, employee information, ..... Everything.

Answer 2

A data warehouse is a database geared towards the business intelligence requirements of an organisation. The data warehouse integrates data from the various operational systems and is typically loaded from these systems at regular intervals. Data warehouses contain historical information that enables analysis of business performance over time.

Answer 3

A data warehouse is a database geared towards the business intelligence requirements of an organisation. The data warehouse integrates data from the various operational systems and is typically loaded from these systems at regular intervals. Data warehouses contain historical information that enables analysis of business performance over time.

or
A data warehouse is the main repository of the organization's historical data, its corporate memory. For example, an organization would use the information that's stored in its data warehouse to find out what day of the week they sold the most widgets in May 1992, or how employee sick leave the week before Christmas differed between California and Quebec from 2001-2005. In other words, the data warehouse contains the raw material for management's decision support system.

While operational systems are optimized for simplicity and speed of modification (online transaction processing, or OLTP) through heavy use of database normalization and an entity-relationship model, the data warehouse is optimized for reporting and analysis (online analytical processing, or OLAP). Frequently data in Data Warehouses is heavily denormalised, summarised and/or stored in a dimension-based model but this is not always required to achieve acceptable query response times.

More formally, Bill Inmon (one of the earliest and most influential practitioners) defined a data warehouse as follows:

Subject-oriented, meaning that the data in the database is organized so that all the data elements relating to the same real-world event or object are linked together;
Time-variant, meaning that the changes to the data in the database are tracked and recorded so that reports can be produced showing changes over time;
Non-volatile, meaning that data in the database is never over-written or deleted, but retained for future reporting; and,
Integrated, meaning that the database contains data from most or all of an organization's operational applications, and that this data is made consistent.


or

u can try this link 4 details http://en.wikipedia.org/wiki/Data_warehouse

Answer 4

A data warehouse is a computer system for archiving and analyzing an organisation's historical data, such as sales, salaries, or other information from day-to-day operations. Normally, an organisation copies (or snapshots) information from its operational systems (such as sales and human resources) to the data warehouse on a regular schedule, such as every night or every weekend; after that, management can perform complex queries and analysis (such as data mining) on the information without slowing down the operational systems

Answer 5

Some where they keep servers that stores data can also be known as a datacentre which is a more generic term for a secure building with double redundancy that houses servers. Other names include Server farms and colocation centres

Answer 6

Most datawarehouses are characterized by:

-- hundreds of gigabytes to terabyte in size. dealing with that scale takes knowledge.

-- periods of read mostly activity, with periods of short bursts of FURIOUS load, reorg, rebuild activity

-- use of specialized features that many people have read about but fewer have used such as bitmap indexes, materialized views, star query schemas, partitioning, etc.

-- use of parallel query -- similar to the point right above.

-- constantly shifting set of questions - requiring shifting sets of data, MV's, indexes, etc (most systems, once production, are relatively static. DW's -- every day is a brand
new day)

To name a few. Dealing with terabytes of data is hard, takes experience. Lots of know how required.

Answer 7

the data stored in a particular lacation

Answer 8

Where server lies and all datas directed through.

Answer 9

try this link

http://bibrains.blogspot.in/