SEO 1 Links

  SEO Blog
  SEO Forum

  Active Topics

SEO Forums

  SEO Forum
  SEM Forum

  Link Networks
  Mod Rewrite
  Revenue Networks

  Social Bookmarking



  Link Exchange


Time Now:
Mon Apr 23, 2018 12:28 am

All times are GMT

Log in





Who is Online

Most users ever online in a day was 2917 on Thu Oct 25, 2007 4:43 pm

Member Websites
Commodity Tips 1

Free Sitewide Links
For Top Members

SEO 1 Forums > Content >

Data warehousing

Author Thread
Preferred Member

Joined: 01 Jan 2009
Good Posts: 107
Location: UK
Data warehousing  Reply with quote  

A data warehouse is a collection of data marts representing historical data from different operations in the company. This data is stored in a structure optimized for querying and data analysis as a data warehouse. Table design, dimensions and organization should be consistent throughout a data warehouse so that reports or queries across the data warehouse are consistent. A data warehouse can also be viewed as a database for historical data from different functions within a company.

The data provided by the data warehouse for analysis provides information on a specific subject, rather than the functions of the company and is collected from varying sources into one unit having time-variant.

Data warehousing professionals build and maintain critical warehouse infrastructure to support business and assist business executives in making smart business decisions. Warehouse ETL (Extraction, Transformation and Loading of data) is an essential part of data warehousing where the data warehousing professional populate data warehouse with information from production databases. Data warehousing professionals work with business analysts and make changes to warehouse ETL in order to maintain consistent and accurate reporting on warehouse table structures.

The concept of data warehousing dates back to the late 1980s [2] when IBM researchers Barry Devlin and Paul Murphy developed the "business data warehouse". In essence, the data warehousing concept was intended to provide an architectural model for the flow of data from operational systems to decision support environments.

Key developments in early years of data warehousing were:

* 1960s - General Mills and Dartmouth College, in a joint research project, develop the terms dimensions and facts.
* 1970s - ACNielsen and IRI provide dimensional data marts for retail sales.
* 1983 - Teradata introduces a database management system specifically designed for decision support.
* 1988 - Barry Devlin and Paul Murphy publish the article An architecture for a business and information systems in IBM Systems Journal where they introduce the term "business data warehouse".
* 1990 - Red Brick Systems introduces Red Brick Warehouse, a database management system specifically for data warehousing.
* 1991 - Prism Solutions introduces Prism Warehouse Manager, software for developing a data warehouse.
* 1991 - Bill Inmon publishes the book Building the Data Warehouse.
* 1995 - The Data Warehousing Institute, a for-profit organization that promotes data warehousing, is founded.
* 1996 - Ralph Kimball publishes the book The Data Warehouse Toolkit.
* 1997 - Oracle 8, with support for star queries, is released.

Post Thu Jun 11, 2009 7:47 am
 View user's profile Send private message Visit poster's website
Full Member

Joined: 13 Dec 2008
Good Posts: 68
Location: On earth
 Reply with quote  

data warehousing is familiar with data mining? i think it termed the same. It is best use for biggies for development and stretching their wings in new and emerging markets.

Seo India
Post Fri Jun 12, 2009 10:04 pm
 View user's profile Send private message Visit poster's website
New Member

Joined: 03 Aug 2009
Good Posts: 3

 Reply with quote  

The use of hypertext, hyperlinks and a page-based model of sharing information, introduced with Mosaic and later Netscape, helped to define web content, ...

Post Mon Aug 03, 2009 4:27 am
 View user's profile Send private message
Full Member

Joined: 16 Nov 2010
Good Posts: 83
Location: India
 Reply with quote  

I was not aware from Data Warehousing. Share more posts like this.

CBSE Model Papers | CBSE Sample Papers 2011 | CBSE X Maths Preparation
Post Tue Mar 01, 2011 4:09 am
 View user's profile Send private message Visit poster's website

Reply to topic
Jump to:  
Display posts from previous:      

SEO 1 © 2005-2015 - SEO 1 the SEO Forum