Re: Data Subset Tool?

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: Dale Edgar
  INET: dale_at_databee.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).