dbTalk Databases Forums  

best free data profiling tool

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss best free data profiling tool in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
goog
 
Posts: n/a

Default best free data profiling tool - 06-19-2007 , 01:39 PM






Hi,

I am in search of a downloadable oracle data profiling/quality tool.
Any recommendation is highly appreciated. Thanks!

N.


Reply With Quote
  #2  
Old   
DA Morgan
 
Posts: n/a

Default Re: best free data profiling tool - 06-19-2007 , 07:08 PM






goog wrote:
Quote:
Hi,

I am in search of a downloadable oracle data profiling/quality tool.
Any recommendation is highly appreciated. Thanks!

N.
Define what the tool should do and for which versions of Oracle.

Profiling what?
Quality of what?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
  #3  
Old   
Ana C. Dent
 
Posts: n/a

Default Re: best free data profiling tool - 06-19-2007 , 11:46 PM



goog <ning.zhu (AT) dfa (DOT) state.ny.us> wrote in news:1182278356.123525.4780
@j4g2000prf.googlegroups.com:

Quote:
Hi,

I am in search of a downloadable oracle data profiling/quality tool.
Any recommendation is highly appreciated. Thanks!

N.

TKPROF is Oracle's profiling tool and is delivered as part of every
recent/current release.

The only quality tool that matters is the gray matter between one's ears.


Reply With Quote
  #4  
Old   
Raoul De Kezel
 
Posts: n/a

Default Re: best free data profiling tool - 06-20-2007 , 03:15 AM



In article <1182278356.123525.4780 (AT) j4g2000prf (DOT) googlegroups.com>,
ning.zhu (AT) dfa (DOT) state.ny.us says...
Quote:
Hi,

I am in search of a downloadable oracle data profiling/quality tool.
Any recommendation is highly appreciated. Thanks!

N.

First, ORASRP, together with Cary Millsap book
"Optimizing Oracle Performance"

--- Raoul


Reply With Quote
  #5  
Old   
goog
 
Posts: n/a

Default Re: best free data profiling tool - 06-20-2007 , 08:01 AM



On Jun 19, 8:08 pm, DA Morgan <damor... (AT) psoug (DOT) org> wrote:
Quote:
goog wrote:
Hi,

I am in search of a downloadable oracle data profiling/quality tool.
Any recommendation is highly appreciated. Thanks!

N.

Define what the tool should do and for which versions of Oracle.

Profiling what?
Quality of what?
--
Daniel A. Morgan
University of Washington
damor...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Groupwww.psoug.org
Basically I am looking for tools that can do DATA profiling meaning
http://en.wikipedia.org/wiki/Data_profiling
May be data integrity is a better word to say. It is one of the
latest oracle releases, 10g I think.



Reply With Quote
  #6  
Old   
DA Morgan
 
Posts: n/a

Default Re: best free data profiling tool - 06-20-2007 , 08:13 AM



goog wrote:
Quote:
On Jun 19, 8:08 pm, DA Morgan <damor... (AT) psoug (DOT) org> wrote:
goog wrote:
Hi,
I am in search of a downloadable oracle data profiling/quality tool.
Any recommendation is highly appreciated. Thanks!
N.
Define what the tool should do and for which versions of Oracle.

Profiling what?
Quality of what?
--
Daniel A. Morgan
University of Washington
damor...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Groupwww.psoug.org

Basically I am looking for tools that can do DATA profiling meaning
http://en.wikipedia.org/wiki/Data_profiling
May be data integrity is a better word to say. It is one of the
latest oracle releases, 10g I think.
No.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
  #7  
Old   
goog
 
Posts: n/a

Default Re: best free data profiling tool - 06-20-2007 , 08:34 AM



On Jun 20, 12:46 am, "Ana C. Dent" <anaced... (AT) hotmail (DOT) com> wrote:
Quote:
goog <ning.... (AT) dfa (DOT) state.ny.us> wrote in news:1182278356.123525.4780
@j4g2000prf.googlegroups.com:

Hi,

I am in search of a downloadable oracle data profiling/quality tool.
Any recommendation is highly appreciated. Thanks!

N.

TKPROF is Oracle's profiling tool and is delivered as part of every
recent/current release.

The only quality tool that matters is the gray matter between one's ears.
Thank you for your input. However, I am not looking for a tool from
performance point of view. What I am looking for is an open source
tool that can tell me the quality of the data in the database.



Reply With Quote
  #8  
Old   
goog
 
Posts: n/a

Default Re: best free data profiling tool - 06-20-2007 , 08:37 AM



On Jun 20, 4:15 am, Raoul De Kezel <hasta... (AT) hotmail (DOT) com> wrote:
Quote:
In article <1182278356.123525.4... (AT) j4g2000prf (DOT) googlegroups.com>,
ning.... (AT) dfa (DOT) state.ny.us says...

Hi,

I am in search of a downloadable oracle data profiling/quality tool.
Any recommendation is highly appreciated. Thanks!

N.

First, ORASRP, together with Cary Millsap book
"Optimizing Oracle Performance"

--- Raoul
Thank you for your input. As I mentioned in another reply, I am not
looking
for tools from performance point of view. What I am looking for is an
open
source software that can tell the quality of data in the database.
Basically it
can perform column profiling, dependency profiling and redundancy
profiling,
etc. Any thoughts? Thanks.




Reply With Quote
  #9  
Old   
Hasta
 
Posts: n/a

Default Re: best free data profiling tool - 06-20-2007 , 01:17 PM



In article <1182346671.841873.314110 (AT) n15g2000prd (DOT) googlegroups.com>,
ning.zhu (AT) dfa (DOT) state.ny.us says...
Quote:
On Jun 20, 4:15 am, Raoul De Kezel <hasta... (AT) hotmail (DOT) com> wrote:
In article <1182278356.123525.4... (AT) j4g2000prf (DOT) googlegroups.com>,
ning.... (AT) dfa (DOT) state.ny.us says...

Hi,

I am in search of a downloadable oracle data profiling/quality tool.
Any recommendation is highly appreciated. Thanks!

N.

First, ORASRP, together with Cary Millsap book
"Optimizing Oracle Performance"

--- Raoul

Thank you for your input. As I mentioned in another reply, I am not
looking
for tools from performance point of view. What I am looking for is an
open
source software that can tell the quality of data in the database.
Basically it
can perform column profiling, dependency profiling and redundancy
profiling,
etc. Any thoughts? Thanks.

Oh ? That's data analysis for non semantic purposes, right ?

Unfortunatly, I'm completely foreign to this very interesting
field. I would be very happy to know the results of your
findings and evalutions...

And, if you have some time, a very quick overview of your goals
would be most welcome too...

Best regards

--- Raoul



Reply With Quote
  #10  
Old   
gazzag
 
Posts: n/a

Default Re: best free data profiling tool - 06-21-2007 , 04:25 AM



On 20 Jun, 14:37, goog <ning.... (AT) dfa (DOT) state.ny.us> wrote:
Quote:
Thank you for your input. As I mentioned in another reply, I am not
looking
for tools from performance point of view. What I am looking for is an
open
source software that can tell the quality of data in the database.
Basically it
can perform column profiling, dependency profiling and redundancy
profiling,
etc. Any thoughts? Thanks.
SQL*Plus comes free with Oracle. Best tool there is.

HTH

-g



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.