Advice

[daveL]

Hi, I work for a company that handles 100k Insurance claims per Day
Weve stared a new Part of the Web site that handles a new type of insurance
claim...
In our other system, they actually create duplicate of the claim for
reporting purpose (web site lits, queries etc)
so the main database is not hit so often.
I feel this is really not a good way to do this..the maintenance is high
for instance if a customer sends 100 claims and they need to be reprocesssed
..we have to delete in the main database and in the reporting database
and so on...since there only being select Queried not updated in the
reporting database...i dont see no reason not to just use the Main
database..all selects have (nolock)...is there Really a benefit of using a
reporting
database...
DaveL

[nidaar]

There are many implications to consider from performance, security and
maintenance points of views. Given the limited info, we can ask some
of the following questions that comes to mind very quickly:
* Does the reporting application require additional indexes to run
fast searches, which might negatively affect the transaction database?
* Are intermediate tables required / utilized by the application for
complex reporting purposes? (Although their usefulness is highly
debated)
* Is the separate reporting database on a different server which might
be serving as part of a scale-out strategy?
* Does the reporting application require specific database /
connection parameters which might not be applicable to the main
database?
* Does the reporting database also a carry a role like providing some
redundancy or data history? E.g like a snapshot database?

James

[DaveL]

The Reporting Database is just a Copy of the Main Database, so the main
Database is not hit as often
both are on the Same Server

The Reporting database does have a couple of Indexes on it that the main
database does not have...

It also is not used as a Reporting Database as you would expect, it merly
delivers lists and lookups for past items
which are contained in the main database....

DaveL

"nidaar" <nid...@gmail.com> wrote in message
news:c65ad85c-b3f5-41e8...@k20g2000vbp.googlegroups.com...