Re: Help getting Streaming data into Oracle

We need an idea of how much data, and what you might want to do with it, and how soon after it arrives you want to do it. e.g.

If         the volume is huge,
but     you don't mind a 15 minute lag,
and     you only keep 24 hours then try a plan like:

    Create a partition table partitioned on date/time to hold the     data - but load the latest 15 minutes into a separate     non-partitioned table, then swap the table with the top     partition and start in on a new table.

Given enough hardware I've designed two variations on this sort of theme that coped with numbers in the order of millions of rows per hour in 'near real' time.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Michael Joseph wrote in message <36B75FB6.D6425306_at_qmick.com>...
>I have a data feed of realtime quotes coming obver the TCP/IP network
>that I need to stream into an Oracle 8 database.
>
>How is this best managed..?
>
>Thanks for your help
>
>Mike. J.
>
Received on Tue Feb 02 1999 - 15:01:28 CST