1.1 Definition of Data ware house
“A data ware is a subject –oriented,
integrated, time varying, non-volatile collection of data in support of the management’s
decision making process”
By
W H Inmon(1993)
A
data warehouse is organized around major subject such a customer, products,
sale etc. Data are organized according to subject instead of application. The
data organized by subject obtains only information necessary for the decision
support system.
1.1.2 Non-Volatile:
The
data are not updated and changed in any way once they enter the data warehouse
but data is only loaded, refreshed and accessed for query. Data warehouse is a
always physically separate store of data which is transformed from the
application from the appropriate environment, therefore DWH don’t need
transaction, processing, recovery, concurrency control etc.
1.1.3 Time
Varying:
Data
are stored in a DWH to provide a historical perspective. Every key structure in
DWH contain implicitly or explicitly, an element of time. The DWH contains a
place for sorting data that are 5 to 10 years old or older to be used for
comparisons, trends, forecasting.
1.1.4 Integrated
A
DWH is usually constructed by integrating multiple, heterogeneous source such
as relation databases, flat files and OLTP.
ReplyDeleteyou described really well and such a nice post. Thanks
We buy residential vacant land
we buy land
Al jaren buigen marketing-experts zich over deze vraag en het hield ons ook inmiddels al jaren bezig. huis te koop Kerkrade
ReplyDeleteAs the growth of Big data solutions companies , it is essential to spread knowledge in people. This meetup will work as a burst of awareness.
ReplyDeleteGreat blog !It is best institute.Top Training institute In chennai
ReplyDeletehttp://chennaitraining.in/devops-training-in-chennai/
http://chennaitraining.in/datastage-training-in-chennai/
http://chennaitraining.in/abinitio-training-in-chennai/
http://chennaitraining.in/pentaho-training-in-chennai/
http://chennaitraining.in/msbi-training-in-chennai/
http://chennaitraining.in/informatica-mdm-training-in-chennai/
Superlative style of writing that every new blogger aspires to have.
ReplyDeleteRe-roofing
Nice post.
ReplyDeleteInformatica mdm training
Informatica message Queue online training
Informatica message Queue training
Informatica power center online training
Informatica power center training
Manual Testing online training
Manual Testing training
Microservices online training
Microservices training
Office 365 online training
Office 365 training
Open stack online training
Open stack training
SAP ABAP on Hana online training
SAP ABAP on Hana training
The roof is perhaps the most important part of any building - as it provides protection to all the other parts against the weather. If your roof is in bad shape the rest of your home will be too, so as you can see, it is very important to keep your roof in the best possible state. Your best bet in this endeavour, is to contact a reputable roofing service for consultancy.But what is a good roofing service? Good question. In my opinion, the best roofing service is one that:Rooftech Construction
ReplyDeleteA very awesome blog post. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. Best Japanese Tableware
ReplyDelete