Need Info on Large Databases
I need info on large databases. Probably in Oracle.
Specifically, how big is big?
... need a repository of detail transactions for a client
they do 2 Billion transactions anually ... @ 500 bytes each (real gross) after a little performance-based data modeling, we're looking at a terrabyte. I can split it into 20 "clumps" -- nearly all work is done within a clump, but would need some management reporting across the whole set.
we need to add 8-10million transactions each day.
Can you help give me some perspective on this? If not, can you tell me who can?
Need Info on Large Databases (reply)
I would recommend a company called PANGAEA SYSTEMS INC, talk to bthoen@pangaea.ca. They specialize in Oracle database design.
On 2/16/99 8:29:01 AM, Alan wrote:
> I need info on large databases. Probably in Oracle.
Specifically, how big
> is big?
... need a repository of detail transactions for a client
they
> do 2 Billion transactions anually ... @ 500 bytes each (real gross) after a
> little performance-based data modeling, we're looking at a terrabyte. I
> can split it into 20 "clumps" -- nearly all work is done within a
> clump, but would need some management reporting across the whole set.
we
> need to add 8-10million transactions each day.
Can you help give me some
> perspective on this? If not, can you tell me who can?
Need Info on Large Databases (reply)
Your problem here is not just the large number of transactions per day, but the distribution of those transactions. For any DBMS, there is a maximum possible throughput per second. Assuming 10 million transactions per day (416,667 per hour or 6944 per minute) you may have to use some buffering technology to spread those transactions over the 24 hour period (something like MSMQ).
A lot here depends upon the quality with which the application is written -- to increase the transaction rate further, you may have to coalesce multiple SQL statements into a single batch and add the batch to the message queue.
Certainly, it's not a simple problem!
On 2/16/99 8:29:01 AM, Alan wrote:
> I need info on large databases. Probably in Oracle.
Specifically, how big
> is big?
... need a repository of detail transactions for a client
they
> do 2 Billion transactions anually ... @ 500 bytes each (real gross) after a
> little performance-based data modeling, we're looking at a terrabyte. I
> can split it into 20 "clumps" -- nearly all work is done within a
> clump, but would need some management reporting across the whole set.
we
> need to add 8-10million transactions each day
Can you help give me some
> perspective on this? If not, can you tell me who can?
