oltp vs olap
-
hi every one i'm not sure if it's true to brought my question here but I want to make clear how much Datawarehouse is useful for a company.what i want is a query example in sql which is long and hard for operational database and is a piece of cake for analytical database. I've searched a lot but I can't fine one may be I searched wrongly but I would be so thanks full if any one could help me with this as soon as possible.
-
hi every one i'm not sure if it's true to brought my question here but I want to make clear how much Datawarehouse is useful for a company.what i want is a query example in sql which is long and hard for operational database and is a piece of cake for analytical database. I've searched a lot but I can't fine one may be I searched wrongly but I would be so thanks full if any one could help me with this as soon as possible.
Instead of trying to find a "query" difference try researching the uses of the different types of database, a datawharehouse is a snapshot, usually delayed from real time, of the transaction (OLPT) database that is optimised for reporting (querying). It is not an either/or question, once you reporting queries begin impacting on your transaction processing you need an OLAP solution as well as the OLTP. This is a very simplistic view, there are entire libraries written on this subject!
Never underestimate the power of human stupidity RAH
-
Instead of trying to find a "query" difference try researching the uses of the different types of database, a datawharehouse is a snapshot, usually delayed from real time, of the transaction (OLPT) database that is optimised for reporting (querying). It is not an either/or question, once you reporting queries begin impacting on your transaction processing you need an OLAP solution as well as the OLTP. This is a very simplistic view, there are entire libraries written on this subject!
Never underestimate the power of human stupidity RAH
thanks so much,i almost know what you are talking about. but I really want a query . this is a an extract from a book :"Although many decision-support queries can be written in SQL, others either cannot be expressed in SQL or cannot be expressed easily in SQL." I want an example of this kind of query which is written in both.
-
thanks so much,i almost know what you are talking about. but I really want a query . this is a an extract from a book :"Although many decision-support queries can be written in SQL, others either cannot be expressed in SQL or cannot be expressed easily in SQL." I want an example of this kind of query which is written in both.
a.fatemeh wrote:
I want an example of this kind of query which is written in both.
Good luck with that, even if you could get the examples it would take a lot explaining to get the context of the requirement. You might want to look into the Microsoft example databases, they have various OLTP and OLAP dbs (AdventureWorks etc), there may be such comparative examples based on them but I doubt it.
Never underestimate the power of human stupidity RAH
-
a.fatemeh wrote:
I want an example of this kind of query which is written in both.
Good luck with that, even if you could get the examples it would take a lot explaining to get the context of the requirement. You might want to look into the Microsoft example databases, they have various OLTP and OLAP dbs (AdventureWorks etc), there may be such comparative examples based on them but I doubt it.
Never underestimate the power of human stupidity RAH