What's the best development tool for Oracle ?

[B.Dimple]

What's the best development tool for Oracle ?

I want to develop a Data Dictionary.

I like Oracle for the backend but it's difficult to decide what's the
best choice for the development tool.

I like PL/SQL for development but I'm concerned that I don't seem to
be able to find anyone using this approach, such as the Dynamic PSP
product.

I'd appreciate any recommendations between PL/SQL, Dreamweaver, Cold
Fusion, ASP, and so on.

TIA

B.Dimple

[Hans Forbrich]

"B.Dimple" wrote: What's the best development tool for Oracle ? I want to develop a Data Dictionary. I like Oracle for the backend but it's difficult to decide what's the best choice for the development tool. I like PL/SQL for development but I'm concerned that I don't seem to be able to find anyone using this approach, such as the Dynamic PSP product. I'd appreciate any recommendations between PL/SQL, Dreamweaver, Cold Fusion, ASP, and so on. TIA B.Dimple

No single tool is best. As a result, Oracle has bundled a whole kit of
tools into the Developer Suite. They do the job quite nicely. Trial is
from the same place you can download the database ...
http://otn.oracle.com

You should be aware that any discussion of tools will invariably invoke
religious fervor.

[Daniel Morgan]

B.Dimple wrote: What's the best development tool for Oracle ? I want to develop a Data Dictionary. I like Oracle for the backend but it's difficult to decide what's the best choice for the development tool. I like PL/SQL for development but I'm concerned that I don't seem to be able to find anyone using this approach, such as the Dynamic PSP product. I'd appreciate any recommendations between PL/SQL, Dreamweaver, Cold Fusion, ASP, and so on. TIA B.Dimple

The first thing that comes to mind is why are you trying to reinvent the
wheel? What do you mean, exactly, by "develop a Data Dictionary"?

The products you list PL/SQL, Dreamweaver, Cold Fusion all do completely
different things. One is the back-end procedure language, one is a
front-end development tool, one is a web development tool.

Hopefully you are less confused about what it is you are trying to do
than indicated by your post.

You want tool recommendations? Here's what we need to know.

1. What is your skill set?
2. What hardware and operating system for development and deployment?
3. What are you trying to develop ... with specificity?
4. What transaction size?
5. What transaction volume?
6. What data types?
7. How many simultaneous users?

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Jan Gelbrich]

Hi. Comments inline.

"B.Dimple" <bdimple@myway.com> schrieb im Newsbeitrag
news:eb271e19.0401051452.55a1b168@posting.google.com... What's the best development tool for Oracle ? I want to develop a Data Dictionary.

Why ? Oracle has the biggest DD of all databases already delivered with the
product,
just try out those some 100 vies v$xxx, user_xxx, dba_xxx, all_xxx ...
I am sorry to say so, but that indicates that You do not know sufficient
about Oracle ...
I like Oracle for the backend

Good decision :) Congratulations !
but it's difficult to decide what's the best choice for the development tool.

True, because there are so many from Oracle and by third parties.
You can use Oracle Developer Suite or JDeveloper e.g., or other languages
via ODBC.
As Thou like it ..
I like PL/SQL for development but I'm concerned that I don't seem to be able to find anyone using this approach,

I would think there are not too few people doing some PL/SQL. You will find
them !
You should not be afraid the the Java crowd is the only people doing
programming out there :)
such as the Dynamic PSP product. I'd appreciate any recommendations between PL/SQL, Dreamweaver, Cold Fusion, ASP, and so on.

The "hacking approach" without some kind of a concept is the worst
beginning.
Please specifiy some of Your targets ("backend" is too vague).
I am working at the "backend" and I am using a number of tools for different
tasks.

If You just want one supercool tool for everything thinkable,
we could hardly help You.
TIA B.Dimple

hth, Jan

[Malcolm Dew-Jones]

Jan Gelbrich (j_gelbrich@westfalen-blatt.de) wrote:

: As Thou like it ..

As thou liketh it
^ ^^

[Jan Gelbrich]

"Malcolm Dew-Jones" <yf110@vtn1.victoria.tc.ca> schrieb im Newsbeitrag
news:3ffb0b59@news.victoria.tc.ca... Jan Gelbrich (j_gelbrich@westfalen-blatt.de) wrote: : As Thou like it .. As thou liketh it ^ ^^

Thank You :)

[drew]

bdimple@myway.com (B.Dimple) wrote in message news:<eb271e19.0401051452.55a1b168@posting.google.com>... What's the best development tool for Oracle ? I want to develop a Data Dictionary. I like Oracle for the backend but it's difficult to decide what's the best choice for the development tool. I like PL/SQL for development but I'm concerned that I don't seem to be able to find anyone using this approach, such as the Dynamic PSP product. I'd appreciate any recommendations between PL/SQL, Dreamweaver, Cold Fusion, ASP, and so on. TIA B.Dimple



There is some companies using Dynamic PSP based on Oracle.
The full links is http://www.dynamicpsp.com/dpsp/prod/!go?ln=nnresume
and new version of www.webrecruiter.com will be fully based on DPSP2.
Dreamweaver is fully support by Dynamic PSP too.
Check the Macromedia Dreamweaver support Site Extension for Dynamic
PSP and you will see how simple to use Dreamweaver and Dynamic PSP
together.

[B.Dimple]

Hans Forbrich <forbrich@yahoo.net> wrote in message news:<3FF9F113.CFAB7203@yahoo.net>... "B.Dimple" wrote: What's the best development tool for Oracle ? I want to develop a Data Dictionary. I like Oracle for the backend but it's difficult to decide what's the best choice for the development tool. I like PL/SQL for development but I'm concerned that I don't seem to be able to find anyone using this approach, such as the Dynamic PSP product. I'd appreciate any recommendations between PL/SQL, Dreamweaver, Cold Fusion, ASP, and so on. TIA B.Dimple No single tool is best. As a result, Oracle has bundled a whole kit of tools into the Developer Suite. They do the job quite nicely. Trial is from the same place you can download the database ... http://otn.oracle.com
You should be aware that any discussion of tools will invariably invoke religious fervor.
Thanks for the warning about something I hadn't expected but certainly
turns out to be true.

[B.Dimple]

> The first thing that comes to mind is why are you trying to reinvent the wheel? What do you mean, exactly, by "develop a Data Dictionary"?
Like the guy said about 'What is Jazz ?' - if you have to ask the
question, you wouldn't understand the answer.
Do some homework and you will find that there is no affordable Data
Dictionary on the market.
The products you list PL/SQL, Dreamweaver, Cold Fusion all do completely different things.
I already know that - please don't waste your time and mine.
Hopefully you are less confused about what it is you are trying to do than indicated by your post.
Gratuitous offense is inappropriate in these Groups, although for some
reason it's all to common from people like you.
You want tool recommendations? Here's what we need to know.
No you don't.

Look at the other replies to my post - they are all more helpful than
yours and take a good deal less time to respond by the people who want
to help and not simply criticize like you do.

B.Dimple

[B.Dimple]

"Jan Gelbrich" <j_gelbrich@westfalen-blatt.de> wrote in message news:<btdpun$5c3pi$1@ID-152732.news.uni-berlin.de>... Hi. Comments inline. "B.Dimple" <bdimple@myway.com> schrieb im Newsbeitrag news:eb271e19.0401051452.55a1b168@posting.google.com... What's the best development tool for Oracle ? I want to develop a Data Dictionary. I am sorry to say so, but that indicates that You do not know sufficient about Oracle ...
You misunderstand my question, which is concerned with an Enterprise
Data Dictionary to support Compliance.

It was hard to derive anything of value from the rest of your answer.

B.Dimple

[B.Dimple]

>andrew_toropov@hotmail.com (drew) wrote in message news: Check the Macromedia Dreamweaver support Site Extension for Dynamic PSP and you will see how simple to use Dreamweaver and Dynamic PSP together.
Thanks very much and I'll follow up your suggestions.

B.Dimple

[Robert A.M. van Lopik]

"B.Dimple" <bdimple@myway.com> wrote in message
news:eb271e19.0401101542.5ef399f3@posting.google.com... The first thing that comes to mind is why are you trying to reinvent the wheel? What do you mean, exactly, by "develop a Data Dictionary"? Like the guy said about 'What is Jazz ?' - if you have to ask the question, you wouldn't understand the answer. Do some homework and you will find that there is no affordable Data Dictionary on the market.
Actually Oracle does have a reasonable Enterprise Data Dictionary inside its
product Designer. In one of its previous incarnations it was even called
CASE*Dictionary. And no, it has nothing to do with the dictionary inside the
Oracle database itself. And yes, unfortunately Oracle seems to have declarec
it "end-of-life", while at the same time being unable to produce an
analogous product to go with its JDeveloper tool.

By the way, what is left of those other Enterprise Dictionaries? The IBM-one
was called AD/Cycle, IIRC, and there was also an effort by Microsoft,
Platinum and Rational. That was all in the mid nineties.

ciao
rob van lopik



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.558 / Virus Database: 350 - Release Date: 3-1-2004

[B.Dimple]

> > I'd appreciate any recommendations between PL/SQL, Dreamweaver, Cold Fusion, ASP, and so on.
Check the Macromedia Dreamweaver support Site Extension for Dynamic PSP and you will see how simple to use Dreamweaver and Dynamic PSP together.
I like the sound of the combination of Dreamweaver and Dynamic PSP.
Unfortunately my search for your suggestion of Dreamweaver Support
Site Extension for Dynamic PSP produced no results.

Please send me a URL, and I would also recommend that you talk to
Macromedia about making your product more visible on their web site.

TIA

B.Dimple

[B.Dimple]

> Actually Oracle does have a reasonable Enterprise Data Dictionary inside its product Designer. In one of its previous incarnations it was even called CASE*Dictionary.
I tried to instal Oracle Designer about two years ago and gave up in
disgust.
About six months later, I found a wonderful book called 'Oracle Web
Applications 101' by Vesterli which gave you a step-by-step process
but by then I'd lost interest.
By the way, what is left of those other Enterprise Dictionaries? The IBM-one was called AD/Cycle, IIRC, and there was also an effort by Microsoft, Platinum and Rational. That was all in the mid nineties.
I was involved in a related initiative when I worked with Ingres, but
I think it proved too difficult for the major vendors to agree on
common standards, and so as a result, there is no vendor-independent
Data Dictionary, so I'm going to develop my own Dictionary geared to
my requirements, which are related to Enterprise Data Migration and
Compliance,(eg Sarbanes-Oxley).

Thanks for your response.

B.Dimple

[Daniel Morgan]

Robert A.M. van Lopik wrote:
By the way, what is left of those other Enterprise Dictionaries? The IBM-one was called AD/Cycle, IIRC, and there was also an effort by Microsoft, Platinum and Rational. That was all in the mid nineties. ciao rob van lopik

Platinum sold ERwin, if that is what you were refering to, to Computer
Associates and it is now available as AllFusion ERwin.

Your comment about Oracle's Designer and "end-of-life"? What is the
origin of this comment? Designer is alive and well AFAIK.

I am afraid B. Dimple would rather be angry than solve the problem. He
has yet to tell anyone precisely what it is he is trying to do. And the
phrase "Data Dictionary" is so broad in scope as to be near meaningless.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[drew]

bdimple@myway.com (B.Dimple) wrote in message news:<eb271e19.0401110550.5ceca017@posting.google.com>... I'd appreciate any recommendations between PL/SQL, Dreamweaver, Cold Fusion, ASP, and so on. Check the Macromedia Dreamweaver support Site Extension for Dynamic PSP and you will see how simple to use Dreamweaver and Dynamic PSP together. I like the sound of the combination of Dreamweaver and Dynamic PSP. Unfortunately my search for your suggestion of Dreamweaver Support Site Extension for Dynamic PSP produced no results. Please send me a URL, and I would also recommend that you talk to Macromedia about making your product more visible on their web site. TIA B.Dimple

Sure.
There is an example how to use WebDAV and Dynamic psp
http://www.dpsp-yes.com/dpsp/prod/!go?id_=np_WebDAV
and link for Dreamweaver Support Site Extension for Dynamic PSP
is here http://www.dynamicpsp.com/dpsp/prod/data/Site/ZIPs/DM_EXT.exe
There is some russian's site based on Dynamic psp also. There is
one http://www.hitvideo.ru/dpsp/video/!go?id_=6000 with a busy traffic.

[Robert A.M. van Lopik]

"Daniel Morgan" <damorgan@x.washington.edu> wrote in message
news:1073846810.341977@yasure... Robert A.M. van Lopik wrote: By the way, what is left of those other Enterprise Dictionaries? The
IBM-one was called AD/Cycle, IIRC, and there was also an effort by Microsoft, Platinum and Rational. That was all in the mid nineties. Platinum sold ERwin, if that is what you were refering to, to Computer Associates and it is now available as AllFusion ERwin.

Actually CA bought all of Platinum. And I certainly did not mean ERwin,
which is an ER-modeler, not a dictionary Your comment about Oracle's Designer and "end-of-life"? What is the origin of this comment? Designer is alive and well AFAIK.

Maybe I should have used the more fashionable term "mature". I.e. no new
developments. See e.g.
http://otn.oracle.com/products/designer/mod_strat_apr_03.html
or another thread in this group today where you also contributed. In a way
this is a pity; with all young people only learning UML, they are driven to
JDeveloper and JAVA instead.

ciao
rob van lopik




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.558 / Virus Database: 350 - Release Date: 4-1-2004

[Jan Gelbrich]

"B.Dimple" <bdimple@myway.com> schrieb im Newsbeitrag
news:eb271e19.0401101547.61ffa637@posting.google.com... "Jan Gelbrich" <j_gelbrich@westfalen-blatt.de> wrote in message
news:<btdpun$5c3pi$1@ID-152732.news.uni-berlin.de>... Hi. Comments inline. "B.Dimple" <bdimple@myway.com> schrieb im Newsbeitrag news:eb271e19.0401051452.55a1b168@posting.google.com... What's the best development tool for Oracle ? I want to develop a Data Dictionary. I am sorry to say so, but that indicates that You do not know sufficient about Oracle ... You misunderstand my question, which is concerned with an
_Enterprise_ Data Dictionary to support Compliance.

OK, I see, I misunderstood You, sorry for that.
It is just that many newbees ask similar question as You, about more basic
issues.
Yours is different, I am sorry I may not be able to help You ;)

greetings, Jan