Home > DeveloperSection > Interviews > What is DataWarehousing?

Posted on    October-12-2014 11:11 PM

 MSSQL Server Database  MSSQL Server 
Ratings:
 1 Answer(s)
  657  View(s)
Rate this:

Kamlakar Singh
Kamlakar Singh

Total Post:80

Points:400
Posted on    October-12-2014 11:11 PM

1.    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;

2.    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;

3.    Non-volatile, meaning that data in the database is never over-written or deleted, once committed, the data is static, read-only, but retained for future reporting.

4.    Integrated, meaning that the database contains data from most or all of an organization's operational applications, and that this data is made consistent.


Don't want to miss updates? Please click the below button!

Follow MindStick