>>Bill inmon is the father of data warehousing.
>>It emphasis on information rather than data.
>>The data warehouse is the hub for decision support data.
>>A good datawarewhouse will provide the right data ... to the right people... at the right time...
>>>Data warehousing is defined as the subject-oriented , integrated , timevarient , non-volatile collection of data in support of the management decisions.
subjectoriented :: The data warehouse is oriented around the major subjects of the enterprise such as customers, vendors, product and activity.
integrated :: The data needs to be stored in the data warehouse in a single, globally accepted fashion even when the underlying operating system store the data in different forms.
It is done by encoding and measuring attributes we will see this in brief in my next post.
Time varient :: Every time you store the data in the data warehouse a snap shot is taken so that you cant change the contents of the data warehouse . Time-horizon is 5-10 years. Here the record cant be updated.
Non-Volatile :: Load the data . Once the snapshot is made you can only access but not update or change informations. That you cannot make adjustments .
Generally,warehouse is a place where we store .Data warehousing is storing data as information and Data minning is getting information from the data which we have stored in the data warehouse. For example lets have a chain of retail shops.And in each shop we get the sales report which is the data and make a database and from the database we get information and that is a data warehouse and from the data warehouse we mine data about products which is best in sales in the market , the areas which need special attention for sales and which is best for which place.
There are four levels in data warehouse . they are :
>old detail :: stores old sales details >>very rarely used
>>current detail :: stores currrent sales details >> rarely used
>>>lightly summarized data :: stores summarized data>>frequently used
>>>>highly summarized data :: stores highly summarized data mostly informations >> highly used
>>It emphasis on information rather than data.
>>The data warehouse is the hub for decision support data.
>>A good datawarewhouse will provide the right data ... to the right people... at the right time...
>>>Data warehousing is defined as the subject-oriented , integrated , timevarient , non-volatile collection of data in support of the management decisions.
subjectoriented :: The data warehouse is oriented around the major subjects of the enterprise such as customers, vendors, product and activity.
integrated :: The data needs to be stored in the data warehouse in a single, globally accepted fashion even when the underlying operating system store the data in different forms.
It is done by encoding and measuring attributes we will see this in brief in my next post.
Time varient :: Every time you store the data in the data warehouse a snap shot is taken so that you cant change the contents of the data warehouse . Time-horizon is 5-10 years. Here the record cant be updated.
Non-Volatile :: Load the data . Once the snapshot is made you can only access but not update or change informations. That you cannot make adjustments .
Generally,warehouse is a place where we store .Data warehousing is storing data as information and Data minning is getting information from the data which we have stored in the data warehouse. For example lets have a chain of retail shops.And in each shop we get the sales report which is the data and make a database and from the database we get information and that is a data warehouse and from the data warehouse we mine data about products which is best in sales in the market , the areas which need special attention for sales and which is best for which place.
There are four levels in data warehouse . they are :
>old detail :: stores old sales details >>very rarely used
>>current detail :: stores currrent sales details >> rarely used
>>>lightly summarized data :: stores summarized data>>frequently used
>>>>highly summarized data :: stores highly summarized data mostly informations >> highly used
1 comment:
data warehousig!!nice technical stuff...but it would be good if ti is even more basic...keep going...
Post a Comment