Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-18 : 09:12:38
|
| Anthony Burgin writes "Hi there,I'm a fourth year student at university and have the pleasure (???) to document an experiment of my choice in Oracle. I have chosen Denormalisation - what is the effect on performance of storing running totals? Evidently, this will be compared to a normalised data model. The current problem I have is that term has come to but an end and I do not have access to the University resources to begin testing some transactions. The question I hope you can answer is to provide an insight to how SQL will calculate the running totals of a customer(s) orders. I am aware of the entity root that the algorithm will have to follow yet do not see how SQL will derive the data and thus produce the answer. I have only been doing Oracle for 1 month and would appreciate some advice. I am storing the running total in the customer relation, my data model consists of the following entities:Area - Customer - Order - Order_line - Product - Category.Though I haven't provided you with the attributes, could you outline (an example perhaps) of how a derived attribute pulls data from other entites?Your advise is much appreciated. If you require the data model then do e-mail meKind regards...Ant" |
|
|
|
|
|
Running totals