Xref: alice comp.databases.oracle.server:39609
Path: alice!news-feed.fnsi.net!newsfeed.ecrc.net!newsfeed.nacamar.de!dispose.news.demon.net!demon!news.demon.co.uk!demon!jlcomp.demon.co.uk!not-for-mail
From: "Jonathan Lewis" <jonathan@jlcomp.demon.co.uk>
Newsgroups: comp.databases.oracle.server
Subject: Re: Help getting Streaming data into Oracle
Date: Tue, 2 Feb 1999 21:01:28 -0000
Message-ID: <917989506.20857.0.nnrp-07.9e984b29@news.demon.co.uk>
References: <36B75FB6.D6425306@qmick.com>
X-Trace: news.demon.co.uk 917989506 nnrp-07:20857 NO-IDENT jlcomp.demon.co.uk:158.152.75.41
X-Complaints-To: abuse@demon.net
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Lines: 33

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@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.
>