his just sequence of my previous post……
As per Justin Cave an Oracle ACE Member:
I suppose that depends on how you define “modern data warehouse technique”. You could define that term to require the use of a relational database. Assuming you do not define the term to require a relational database, you could use anything– flat files, object databases, hierarchical databases, etc– to build a data warehouse. Relational databases give you a certain degree […]

[Read more →]

This just sequence of my previous post……
I agree with Justin that concept exist before the relational database was invented. Last time I know they call it EIS then they name it MIS and now data warehouse. But what I am taking about is modern data warehouse technique, I really doubt that any other type of database can support it without following relational database concept. Let me know which one?
I am still searching for my answers and have discuss with lot of people, but when I asked them have they seen any implementation of data warehouse without using relational database, the […]

[Read more →]

This just sequence of my previous post……
I posted it in oracle forum.
As per Justin Cave an Oracle ACE Member:
You can certainly build a data warehouse (or any other type of database) without using a relational database. Whether you ought to do such a thing, however, is another question.
Relational databases provide a lot of functionality that facilitates building data warehouses (or other types of data-driven applications), but other tools could certainly do the same […]

[Read more →]

Today I came across one very interesting question
“Data Warehouse can be only deployed in relation database.”
Above statement is true or false.
If we see it simply without any complication or may be go back 7-8 years it’s answer may be false as I find out after doing research on it
“A data warehouse can be normalized or denormalized. It can be a relational database, multidimensional database, flat file, hierarchical database, object database, etc. Data warehouse data often gets changed. And data warehouses often focus on a specific activity or entity.” Larry Greenfield
The data warehouse is normally (but does not have to be) […]

[Read more →]