Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Data Subset Tool?

Re: Data Subset Tool?

From: Jared Still <jkstill_at_cybcon.com>
Date: Sun, 20 Jan 2002 14:06:13 -0800
Message-ID: <F001.003F53F3.20020120131522@fatcity.com>

Do you know if anyone has successfully used this tool on an SAP database? That would be *truly* impressive.

Jared

On Sunday 20 January 2002 10:55, Dale Edgar wrote:
> Hi Jared
>
> > I've seen some pretty ugly schemas in Oracle, from third
> > party apps in particular.
> >
> > It would be most interesting if an automated tool could
> > subset these.
>
> They do get ugly don't they - however, I would be very suprised if DataBee
> was not able to cut a subset.
>
> DataBee is quite simple in concept - at its most fundamental level it
> processes a list of rules which tell it which tables need which supporting
> rows from other tables. The schema complexity is largely an irrelevant
> issue - DataBee takes things one rule at a time and says "I have this row
> in this table therefore I need these rows from this table based on this
> join condition). It is very fast and implicitly eliminates duplicates. It
> is also interesting to note that table size is also not super important.
> Sure the extract is slower on large databases, but the extract time scales
> upwards with the size in a very well behaved manner.
>
> Give it a try if you want. There is a fully functional evaluation version
> (with sample schema) available for download on the DataBee website.
> http://www.DataBee.com
>
>
> Thanks
> Dale Edgar
> Net 2000 Ltd.
> Dale_at_DataBee.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Sun Jan 20 2002 - 16:06:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US